Import and export
All your products in a CSV or Excel file: export, change in a spreadsheet, and import with a preview of every change and a backup.
Export
In Catalogue > Import & export, choose Excel (.xlsx) or CSV. You get every product, with its variations in the rows below it. The columns are the same as a WooCommerce product export:
| Column | What it holds |
|---|---|
| ID | P12 for a product, V34 for a variation |
| Parent | For a variation: its product's ID or SKU |
| Type | simple, variable or variation |
| SKU, Name, Custom Variation Name | |
| Published | 1 (published), 0 (draft) or hidden |
| Is featured? | 1 or 0 |
| Short description, Description | Text or simple HTML |
| In stock? | 1, 0, or your own text such as "On order" |
| Regular price, Sale price, Solden Prijs | Solden Prijs is the seasonal price |
| Categories | Paths such as Indoor > Sofas, several separated by a vertical bar |
| Images | Web addresses separated by a vertical bar |
| Attribute 1-3 name and value(s) | e.g. Colour, and Oak and Walnut separated by a vertical bar |
| Slug, Sale from, Sale until, Price note | Extra columns of Fwdia |
Import
- Choose a CSV or Excel file and Next: see the changes. Nothing changes yet.
- The preview lists the new products, the products that change (each field, old and new value), the unchanged ones and the rows with a problem. Select a number to see only those.
- Download the backup of the old values if you like, then choose Import.
Good to know:
- Products are matched by SKU, then by ID. Other rows become new products (as drafts, unless Published says otherwise).
- Only the columns in the file change. Leave a column out and that stays as it is. An empty cell clears the value.
- Missing categories and attribute values are made for you.
- Photos with a web address of another site are downloaded to your media library after the import, a few at a time: keep the page open until it is done. Each address is downloaded once. Images given as file names only are skipped.
- Rows with a problem are skipped; the rest is imported.
Undo an import
Every import first saves the old values of the products it changes. Under Backups of your last imports, download it and import it again to put them back. Backups are kept for a day.