To use the CSV import of articles a comma-separated CSV file is required. The file needs to be encoded using utf-8 and the maximal accepted file size is 50MB. In case the CSV file is larger, it needs to be divided into multiple CSV files.
For information of what values can be supplied for the fields, please read this article.
An example of how the import file can look like can be found here.
The CSV file's columns
| Field | Column name | Example, in case the column names can be written in several ways. |
| SKU | sku | |
| Status | status | |
| Quantity | quantity | |
| Title | title:<language> | title:sv-SE or title:en-US |
| Description | description:<language> | description:sv-SE or description:en-US |
| Price | price:SE:SEK | |
| Original Price | original_price:SE:SEK | |
| Categories | category:<number> | category:1 to category:5 |
| Main Image | main_image_url | |
| Shipping Time | shipping_time:<min/max>:SE | shipping_time:min:SE or shipping_time:max:SE |
| Market* | market:1 | |
| Parent SKU** | parent_sku | |
| Properties** | property:<property name>(:<language in case it is a free text property>) | property:color:en-US property:size_mm and others |
| Variational Properties** | variational_property:<number> | variational_property:1 to variational_property:2 |
| Other Images*** | other_image_url:<number> | other_image_url:1 to other_image_url:11 |
| Legacy Product ID*** | legacy_product_id | |
| Brand*** | brand | |
| GTIN*** | gtin |
* The column market:1 needs to be included with the value SE for each article.
** These fields are required for articles that should belong to an article group/product. You can read more about it here.
***These fields are optional, but we urge you to include Legacy Product ID if possible.
For column names supplied in the above table with <language> requires that <language> is replaced by either sv-SE, for Swedish, or en-US, for English.
At least one title and one description is required per article, however you are able to have both of the columns title:sv-SE and title:en-US and only fill in the description in the column with the appropiate language for each article.
For properties it is required to create one column per property where <property name> is replaced by the property name for the properties you want to use. For some properties, free text properties, it is required to also supply the language. You are able to have several columns for properties such as for example: property:color:sv-SE,property:size_mm,property:fyndiq-pattern and so on. You should only add values to the columns for the articles which should have the given properties.
For more information on properties, please read this article.
For column names with <number>, <number> should be replaced by an integer and you are able to have more than one column of that type.
Categories are supplied by the columns category:<number> and if only one category is supplied per article you will only need to add the column category:1. There is a maximum of five categories per article and in the case five should be added for an article you would also need to add the columns category:2 through category:5.
There is a maximum of two Variational Properties and because of that <number> can only be replaced by 1 or 2.
For other images <number> can be replaced by 1 through 11.
For Shipping Time both the column shipping_time:min:SE and shipping_time:max:SE needs to be supplied.