How do I export and import products?
Exporting products
-
Navigate to Marketing Shop in the left menu.
-
Select Products.
-
Select Actions in the top right corner.
-
Select Export from the dropdown menu.
-
Review the dialog confirming that the overview will be exported as an
.xlsxfile. -
Select Export again to save the file to your device.
Note: Apply filters before exporting if you want to download only a specific set of products.
Importing products
You can import product data to add new products or update existing ones.
-
Navigate to Products.
-
Select Actions.
-
Select Import.
-
In the Import products dialog:
-
Drag and drop your
.xlsxfile -
Or select a file from your computer
-
-
Check Update existing data if you want to update products already in your system.
-
Select Import to upload the file.
Important: You can download an example file from the dialog to ensure your spreadsheet matches the correct format.
Pro tips for importing
-
When updating existing products, the first column
product:general:uuidmust include the product’s unique ID. -
When importing new products, leave
product:general:uuidempty or remove the column entirely. -
It is not possible to update existing products and create new ones in the same file. Create two separate imports.
-
For partial updates, delete all columns except
product:general:uuidand the fields you want to update. This keeps the file clean and reduces mistakes.
Handling import errors
If the system detects an issue with your import file, the upload will not continue. Instead, you will see an error report that includes:
-
The column where the issue occurred
-
The error type, for example invalid value
-
The affected rows that need corrections
Correct the spreadsheet and try the import again.
Caution: Always review the error log carefully. Small formatting mistakes can prevent the entire file from uploading.
Tips
-
Use exports as backups before performing large updates.
-
Keep custom column views consistent across your team to avoid confusion during imports.
-
Maintain a master spreadsheet of your product catalog to speed up future updates.