Import issues

Messages about the file, column mapping and saving products.

These messages come from checking the file or from saving to the store.

File

Message	What to do
Upload a CSV or Excel (XLSX) file	Save the file as `.csv` or `.xlsx`
The old XLS format isn't supported	Save the file in Excel as XLSX or CSV
Could not read the Excel file	Save it again as XLSX or CSV
The file is too large. Max 10 MB	Split the file
Too many files uploaded within an hour	Try again later. The limit is 20 files per hour
The CSV file is empty	Check that the file has rows with data
The Excel file is empty	Check that the first sheet with data has rows
Column headers must be non-empty and unique	Fix the first row
An import can contain at most 10,000 products	Split the file
The mapping points to a column that isn't in the file	Map the columns again
The file has no valid products	Fix the rows from the problem list

Rows

Message	What to do
Missing product name	Add the name
Missing SKU and ID. The name isn't an identifier	Add a SKU or ID
Invalid product ID	Enter a whole number
Price: invalid value	Enter a number
Stock: invalid value	Enter a number
Manage stock: enter yes or no	Fix the value
Invalid status	Use publish, draft, pending or private
Invalid image URL	Enter a full http(s) address
Duplicate SKU (rows …). I'm skipping all these rows	Remove the duplicate
Variations have duplicate SKUs	Give each variation a different SKU
Skipped together with the variation in row N	Fix the row shown
Each variation needs its own SKU	Add the SKU
A variation has an empty attribute (e.g. size)	Fill in the attribute

Saving to the store

Message	What to do
The product already exists. Choose update	Change the import goal
No product found to update	Check the SKU or ID
This ID doesn't exist in the store	Check the ID
The ID and SKU point to different products	Fix the file
The store has several products with this SKU	Check them manually and keep the SKU unique
The store didn't respond	Check the product manually or retry
The process was interrupted while saving	Check the product in the store before you continue
Store read: the product wasn't created	You can retry the item

The retry button doesn't work

The message "First check the items marked “Needs checking”" means some saves have no confirmation from the store. See Background import, pausing and resuming.

The next import won't start

A store runs one import at a time. Wait until it finishes or click Show progress.

Can't find the answer? Write to hello@getwoomate.com or request free onboarding help.