Catalog import

Add or update many categories, options, add-ons and products at once from a JSON, CSV or Excel file.

Catalog import adds or updates many items in one go instead of one by one. You prepare a JSON, CSV or Excel file, check it, then import it.

Import a catalog

  1. 1Open "Inventory" from the left-hand menu, then "Catalog Imports".
  2. 2Click "New import".
  3. 3Choose a mode. Both modes are explained below.
  4. 4Choose an import method: JSON, CSV or Excel. The methods are explained below.
  5. 5Upload your file. For JSON you can also paste its contents. If you are not sure how the file should look, click "Download example" (JSON) or "Download template" (CSV and Excel).
  6. 6Click "Validate". The report shows what the file contains and lists every error and warning, each with its location in the file.
  7. 7If the file is valid, click "Import catalog".

Import methods

JSON
One file can hold categories, options, add-ons, add-on groups and products together. Click "Download JSON schema" for the exact fields and the size limits.
CSV
A plain spreadsheet file (.csv). One file holds one kind of item, so you also choose what you are importing: categories, options, add-ons, add-on groups or products. Click "Download template" to get the columns.
Excel
The same as CSV, as an Excel file (.xlsx). Click "Download template" to get the columns.

CSV and Excel files can be 2 MB at most. Because a file holds one kind of item, import categories before the products that use them. Errors name the row of the file they come from.

Modes

Create and update
Items that already exist are updated and new items are created. Nothing is ever deleted.
Create only
The import fails if any item already exists, and nothing is imported.

What a file can contain

A file can hold categories, product options, add-ons, add-on groups and products. Each item is matched by a reference you choose, and products can also be matched by their SKU. Categories have two levels. Click "Download JSON schema" for the exact fields and the size limits of a file.

An import is all or nothing. If any item is invalid, nothing is imported. Fix the file and validate again.

After you click "Import catalog", the import is queued and runs in the background. Open it under "Catalog Imports" to follow its status.

Product images are downloaded in the background after the import finishes. An image link that cannot be downloaded is reported on the import and does not stop the rest.

The report shows how many new products the file adds, next to your product limit. Check it before you import.

Every import is listed under "Catalog Imports" with its status, so you can see what was imported and when.

Still need help?

Can't find what you are looking for? Our support team is happy to help.

Contact support