Importing and Exporting Products
This guide explains how to batch create or update products using a CSV file. CSV import/export allows you to quickly add a new product range or make bulk updates to existing products.
You can manage product imports and exports from: Products → Manage products
When to Use CSV Import/Export
Use CSV tools when you need to:
- Create many products at once
- Update product details in bulk
- Adjust pricing, descriptions, or attributes across multiple products
- Build a new product range offline and upload it
Accessing Import and Export Options
- Go to Products → Manage products.
- Click the three dots menu next to the New product button.
- Choose one of the following:
- Import products
- Export products
Importing New Products
When creating new products via CSV, always start with the system template.
Step 1 — Download the Template
- Click Import products.
- In the dialog window, click Download template (bottom right).
- Open the template CSV file.
The template ensures:
- Correct column names
- Correct field order
- Valid formatting requirements
Step 2 — Complete the Template
Fill in the product data in the CSV file:
- Do not change column headers
- Follow the expected format for each field
- Avoid adding extra columns unless supported
Save the file in CSV format when finished.
Step 3 — Upload the File
- Open the Import products dialog.
- Select your completed CSV file.
- Run validation (see validation section below).
- Import once validation passes.
Batch Updating Existing Products
To update current products in bulk, export them first and use that file as your base.
Step 1 — Export Existing Products
- Go to Products → Manage products.
- Click the three dots menu.
- Select Export products.
- Download the CSV file.
This export file is already in the correct format for re-importing.
Step 2 — Edit the CSV
- Update only the fields you want to change
- Keep product identifiers unchanged (for matching on import)
- Do not rename column headers
Save the file as CSV when complete.
Step 3 — Re-Import the Updated File
Upload the edited CSV using the Import products option and validate before importing.
Validating CSV Data Before Import
All CSV files must be validated before they can be imported. Validation prevents incorrect or incompatible data from breaking product records.
How Validation Works
- Select your CSV file in the Import products dialog.
- Click Validate.
Fixing Validation Errors
If issues are found, validation will report:
- The row number
- The field/column
- The error type
Use this information to:
- Open your CSV file.
- Correct the flagged values.
- Save the file.
- Upload and validate again.
Repeat until validation passes successfully.