On this page
Before you start
Build your file in a spreadsheet and save it as CSV. The first row holds your column names, every row below it is one product. Both a semicolon and a comma work as separator, and a price may use a decimal comma.
Keep the EAN column filled. e-tailize matches on the EAN: a known EAN updates that product, a new one creates a product, and a row without an EAN also creates a product, one with no EAN to match on next time. Images are links in the file, not pictures, up to 25 per product with a maximum image size of 5MB.
Steps
- Click "Import products" on your products page, or the "CSV" logo under "Products import". "Import products from csv file" opens.
- Click "Upload csv" and choose your file. The separator is detected automatically, so leave "Detect the csv delimiter automatically" ticked.
- Choose an option under "Image settings for import": "Skip images", "Import only for new products" or "Replace existing images".
- Map "Ean" under "Map csv columns to e-tailize". This is the only mapping the import demands.
- Map the columns you care about with the "Select column" dropdown next to each field, at least "Sku", "Main Title" and "Base Price". A product imported with only an EAN has no title, no price and no other data.
- Tick the columns you want to keep under "Custom fields". Everything you leave unmapped and unticked is dropped.
- Click "Import products".
What happens next
A summary appears with the result, for example "Processed rows: 0-1", "Products added: 1", "Products updated: 0" and "Products empty EAN: 0". Your products then stand on the products page, with the mapped columns in the standard fields and the ticked ones under "Imported custom fields".
Common problems
"EAN mapping is required!" The "Ean" field has no column. Point it at your EAN column and try again.
"Please select an image import option". Pick one of the three image options first.
"There are no fields present in the csv file or csv not loaded yet." Your file did not parse into columns. Leave "Detect the csv delimiter automatically" ticked, save the file as CSV again with a comma or a semicolon, and check the first row for empty or duplicate column names. Those give "CSV header was incorrect, please check for duplicate entries or empty column names."
Odd characters in your text. Avoid symbols such as currency signs and emoticons in your sheet. Descriptions may be plain text or HTML, so convert your text first if you want the formatting to survive.
FAQ
What happens if I import the same file twice?
The products are updated, never duplicated. EANs you already have are counted under "Products updated" and only new EANs are added, so importing a corrected sheet again is the normal way to fix a whole catalog at once.
Do I have to map every column?
No. Map the ones that belong in a standard field and keep the rest as custom fields, or leave them out. A column that is neither mapped nor ticked is simply not imported.
Was this useful?