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.
danger

After uploading a file, check whether the data was imported correctly. Excel sometimes displays data differently than it is stored in the file. For example, a number may be displayed as 2025-05-05 in Excel, but be imported as 45988 in LoyJoy. The product view in LoyJoy will show you the actual data that was imported. You can solve this problem by setting the data type of the column in Excel to "Text" before saving the file.

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.