The Import/Export option in the Items module allows you to add new items or modify existing items in bulk. You can find this option in the top right corner of the Items module.
You use this function to quickly adjust a large amount of data, for example, to upload multiple Visuals simultaneously or to implement major corrections in product data. This is ideal as it allows you to avoid having to edit each item individually within the application.
The Import/Export functionality consists of two parts: exporting to get a template, and importing to upload data in bulk (B). Follow the steps for each part.
Exporting items
The export function lets you download data in bulk to adjust it or to use it as a basis for an import.
Navigate to Catalog > Items. You will see the Import & Export section on the right side of the screen.
Select attributes: You can choose which specific attributes you want to export under Select attributes to export.
Add: Click the plus icon (+) to add the selected attribute to the export list.
Export: Click the blue button Export as .csv to download the file.
Tip: If you need an empty template, export the desired attributes and then remove the data from the rows.
Importing items
Use the import function to apply bulk updates or add new items via a CSV file.
Prepare your file: Ensure your CSV file meets the requirements (see Important Considerations).
Upload: Click Upload file or drag and drop your file into the designated box.
Wait for processing: The import job is processed in the background. You will receive a notification once the job is complete.
Important notes⚠️
Page Size: When exporting, only the data that is displayed on the current page is exported.
File requirements:
The file must have a .CSV extension.
The maximum file size is 10MB.
Use the column names exactly as they appear in the exported template.
Required fields: The fields ID, Name, Price, and Stock are mandatory for products. Ensure these are always correctly filled in, even for new items.
Multiple values: To add multiple values to a single property (e.g., different colors), use the pipe character (|) to separate the values (for example:
Red|Blue|Green).Modifying existing items: If you want to modify an existing item, you must include the correct ID in the CSV row. The import job will then overwrite the other fields in that row with the new data.
FAQ❓
How do I know which columns to use in my import file?
The safest method is to first run an export with the desired attributes. The column names in that exported CSV file are the names you must use for your import.
What happens to items that I manually import if I run a new feed?
Items that are imported via the feed and have been modified in-app (or via bulk-import) will be overwritten after the next regular feed import job. It is safer to modify/import a copy of an item if you want the change to be preserved.
Can I import images with this function?
Yes, you can import images in bulk! You need to include the URLs of the images in the relevant columns of your CSV file.
My import failed; where can I find the error message?
Check the notifications in Tweakwise. An error log is usually generated which indicates which row(s) in your CSV file contain the error (for example, a missing required field).