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