Structure for CSV-files for import in Merchant Center

Modified on Fri, 13 Nov at 11:11 AM

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article