Prepare a CSV or Excel file

Which files Import accepts (CSV, XLSX) and how to fill in each column.

A well-prepared file passes the check without fixes. This article covers the requirements for the file and for each column.

File requirements

A .csv or .xlsx (Excel) extension. From an Excel file, WooMate reads the first sheet that has data. Save the older .xls format as XLSX or CSV.
Size up to 10 MB.
Up to 20 uploaded files per hour.
Up to 10,000 products in one import.
The first row holds the headers. Every header must be filled in and different from the others.
Every row has as many columns as the header.

WooMate detects the column separator on its own: semicolon, comma, tab or the | bar. The same goes for encoding: UTF-8 and Windows-1250 both work.

Field in WooMate	Rules
SKU	Used to identify the product. Every row needs an SKU or an ID
Product ID	A whole number from 1. Works only without variations in multiple rows
Product name	Required when adding products. Not needed for updates only
Price, Sale price, Weight	A number. Text in these fields is an error
Stock quantity	Number of units
Manage stock (yes/no)	Enter yes or no
Status (publish, draft…)	Exactly `publish`, `draft`, `pending` or `private`
Images (URLs)	Full `http://` or `https://` URLs, separated by a comma or a bar
Categories	Missing categories are created only when you save
Description, Short description	Any text

You choose the image separator in Image URLs in a cell are separated by:.

An empty cell in a matched column clears that field in the product. Don't want to change a field? Choose Skip column.

A repeated SKU or ID. WooMate then skips every row with that value, not only the second one.
A name instead of an SKU. A name doesn't identify a product.
The same SKU on two products. WooMate skips both.