Skip to main content

Import Product Data

XLSX and CSV Upload​

You can import your products to the product database from an Excel (XSLX) or CSV file. The XLSX/CSV file must have the following columns:

  • title
  • locale

All other columns are optional and can be freely assigned.

  • A CSV file must be encoded in UTF-8.
  • XLSX: The import will only look at the first sheet of the XLSX file.
  • The columns in the XLSX file must be named in the first row.
  • Columns with names ending in _num will be treated as numbers and can be used in numerical comparisons.

In addition to the columns mentioned above and the custom properties, you can use the reference_id column to update existing products. This allows you to keep e.g. existing analytics data when updating products.

An example csv file could look like this:

title,locale,url,size
Product 1,en,https://example.org/product1,L
Product 2,en,https://example.org/product2,M
Product 3,de,https://example.org/product3,S

Texts containing special characters like " or , must be enclosed in double quotes. If a text contains a double quote, it must be escaped with another double quote. For example:

title,locale,description
"Product 1","en","This is a ""great"" product"

Number columns can be used in numerical comparisons. All other columns will be treated as text.

Products API​

You can also add, update, and delete products using the Products API.