Import and export

Settings → Import / Export moves data in and out of your store as spreadsheets.

Export

Choose what to download: Products, Orders (optionally between two dates), Categories, Users, Features or Brands. Pick CSV or XLSX and click download.

Import

For Products, Categories, Features and Brands:

1. Click Excel template (or CSV template) on the card. The Excel template has the right column headings, example rows, drop-down lists for fixed values and an Instructions sheet describing each column.
2. Fill in the first sheet and save it as Excel (.xlsx), or as CSV, up to 32 MB.
3. Select File and Upload File.

Excel files need no special settings: dates, numbers and TRUE/FALSE are read as plain values, and the Instructions sheet is ignored. For CSV, the page shows the expected format: UTF-8, semicolon (;) between columns and a comma as the decimal separator (49,90). For products, the product import wizard (Products → Product Import/Export) is easier: it maps columns, previews and can do a test run.

Images in bulk

Bulk Image Import (ZIP) attaches images to products by SKU: name each file after the SKU (for example SKU123.jpg, and SKU123 (2).jpg for a second image) and upload the ZIP (up to 250 MB).

History

History lists every import and export with its result. Download Errors shows why rows were skipped.