The sample catalog
woocommerce-sample-products.csv has 34 records in 26 columns: 10 simple products, 5 variable products and their 19 variations. It is synthetic data written for this page, not a copy of the sample file that ships with WooCommerce.
- Simple products with stock, sale prices, a gallery of two images and one product that is out of stock.
- Variable products with one or two attributes (Size, Color, Volume); every variation names its parent in
Parent. - Categories with subcategories (
Home > Kitchen), a product in two categories, and tags. - 16 image URLs of pictures published on catalogdock.org: the importer downloads them, so your store needs internet access during the import.
| Type | SKU | Name | Regular price | Stock | Categories | Parent | Attribute 1 value(s) |
|---|---|---|---|---|---|---|---|
| simple | SMP-MUG-350 | Enamel mug, 350 ml | 12.00 | 40 | Home > Kitchen | ||
| simple | SMP-NOTEBOOK-A5 | Notebook A5 | 6.00 | 100 | Stationery | ||
| simple | SMP-PEN-GEL | Gel pen, black | 2.50 | 500 | Stationery | ||
| variable | SMP-TEE | Organic cotton tee | Apparel > T-shirts | S, M, L | |||
| variation | SMP-TEE-S-WHT | 19.00 | 12 | SMP-TEE | S | ||
| variation | SMP-TEE-S-BLK | 19.00 | 15 | SMP-TEE | S | ||
| variation | SMP-TEE-M-WHT | 19.00 | 20 | SMP-TEE | M | ||
| variable | SMP-HOODIE | Hooded sweatshirt | Apparel > Hoodies | S, M, L, XL |
Checked: the file passes the CatalogDock check with no finding. Our test import into an empty WooCommerce 11.1.2 store on 2026-11-13 created every product, variation, category and image.
The columns, explained
The header row uses the column names of a WooCommerce export, so the importer maps every column by itself.
| Columns | What they do on import |
|---|---|
| Type | simple, variable or variation. A variable product is one row; each of its variations is a row of its own. |
| SKU | A unique product code. Variations name their parent by this code in Parent. |
| Name | The product name. It is empty on the variation rows of this file: WooCommerce names them after the parent and the values (“Organic cotton tee - S, White”). |
| Published, Is featured?, Visibility in catalog | Published: 1 published, 0 private, -1 draft. Is featured?: 1 or 0. Visibility: visible, catalog, search or hidden. |
| Short description, Description | Texts of the product page. A value with a comma is written in double quotes. |
| Tax status | taxable, shipping or none. |
| In stock?, Stock, Backorders allowed? | A number in Stock turns on stock management for that product; 0 makes it out of stock. Backorders: 0, 1 or notify. |
| Sale price, Regular price | Numbers with a dot as the decimal separator and no currency sign. Sale price stays below Regular price. |
| Categories, Tags | Several values are separated by commas; “Home > Kitchen” is the subcategory Kitchen of Home. Missing ones are created. |
| Images | Image URLs separated by commas: the first is the main image, the rest the gallery. The importer downloads them. |
| Parent | On a variation row: the SKU of its variable product, which comes earlier in the file. |
| Attribute 1 name, value(s), visible, global | The parent lists every value (S, M, L); each variation has one. Global 0 keeps the attribute on the product, so no global attribute is added to your store. |
A safe test import
- Use a staging copy of your store, never the live shop, and never the files of
3-intentional-errors. - Products → Import, choose
woocommerce-sample-products.csv(or a file of1-ready-to-check), keep “Update existing products” off, and check the column mapping screen: every column maps to a WooCommerce field. - After the import, Products lists 15 products (10 simple, 5 variable); open a variable product and check that every variation is attached and has its attribute values.
- The update pair only makes sense for products that exist: compare the files in CatalogDock first, then import the update files with “Update existing products” on.
Then check your own file the same way before you import it into the live store.
1-ready-to-check/
Correct files: they pass the CatalogDock structural checks as they are.
Simple products
Expected: Passes the structural checks: 2 simple products, nothing to fix.
| Record | Type | SKU | Name | Regular price | Stock | Categories |
|---|---|---|---|---|---|---|
| 1 | simple | MUG-01 | Mug | 12.00 | 25 | Kitchen |
| 2 | simple | MUG-02 | Mug large | 14.00 | 10 | Kitchen |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
Variable product with three variations
Expected: Passes: the parent comes first, every variation names it in Parent and uses a size the parent lists.
| Record | Type | SKU | Name | Regular price | Parent | Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global |
|---|---|---|---|---|---|---|---|---|---|
| 1 | variable | TS-001 | T-Shirt | (empty) | (empty) | Size | Small, Medium, Large | 1 | 0 |
| 2 | variation | TS-001-S | T-Shirt - Small | 25.00 | TS-001 | Size | Small | 1 | 0 |
| 3 | variation | TS-001-M | T-Shirt - Medium | 25.00 | TS-001 | Size | Medium | 1 | 0 |
| 4 | variation | TS-001-L | T-Shirt - Large | 27.00 | TS-001 | Size | Large | 1 | 0 |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
2-fixed-automatically/
A file with a problem CatalogDock fixes by itself (the order of the rows).
Variation listed before its parent
Expected: VARIATION_BEFORE_PARENT, fixed automatically: the corrected file moves the parent above its variations and passes.
| Record | Type | SKU | Name | Regular price | Parent | Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global |
|---|---|---|---|---|---|---|---|---|---|
| 1 | variation | TS-001-S | T-Shirt - Small | 25.00 | TS-001 | Size | Small | 1 | 0 |
| 2 | variable | TS-001 | T-Shirt | (empty) | (empty) | Size | Small, Medium | 1 | 0 |
| 3 | variation | TS-001-M | T-Shirt - Medium | 25.00 | TS-001 | Size | Medium | 1 | 0 |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
3-intentional-errors/
Files with deliberate mistakes. Do not import them: they show what the report says.
Parent SKU that does not exist
Expected: PARENT_NOT_FOUND: the variations name TS-01, but the parent is TS-001. Not fixed automatically; correct Parent yourself.
| Record | Type | SKU | Name | Regular price | Parent | Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global |
|---|---|---|---|---|---|---|---|---|---|
| 1 | variable | TS-001 | T-Shirt | (empty) | (empty) | Size | Small, Medium | 1 | 0 |
| 2 | variation | TS-001-S | T-Shirt - Small | 25.00 | TS-01 | Size | Small | 1 | 0 |
| 3 | variation | TS-001-M | T-Shirt - Medium | 25.00 | TS-01 | Size | Medium | 1 | 0 |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
Variation value the parent does not offer
Expected: ATTRIBUTE_VALUE_NOT_IN_PARENT: a variation uses Large, the parent lists only Small and Medium. Not fixed automatically.
| Record | Type | SKU | Name | Regular price | Parent | Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global |
|---|---|---|---|---|---|---|---|---|---|
| 1 | variable | TS-001 | T-Shirt | (empty) | (empty) | Size | Small, Medium | 1 | 0 |
| 2 | variation | TS-001-S | T-Shirt - Small | 25.00 | TS-001 | Size | Small | 1 | 0 |
| 3 | variation | TS-001-L | T-Shirt - Large | 27.00 | TS-001 | Size | Large | 1 | 0 |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
4-update-pair/
Two files for “Update catalog”: a store export and a new supplier price list.
Store export (8 products)
Expected: Slot 2 of “Update catalog”: the export of the store, in the columns of Products → Export.
| Record | ID | Type | SKU | Name | Published | Stock | Backorders allowed? | Sale price | Regular price | Parent |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 201 | simple | DK-LAMP-01 | Desk lamp Oslo | 1 | 14 | 0 | (empty) | 49 | (empty) |
| 2 | 202 | simple | DK-LAMP-02 | Floor lamp Oslo | 1 | 6 | 0 | (empty) | 119 | (empty) |
| 3 | 203 | simple | DK-RUG-01 | Wool rug 120×170 | 1 | 3 | 0 | 159 | 189 | (empty) |
| 4 | 204 | simple | DK-RUG-02 | Wool rug 160×230 | 1 | 2 | 0 | (empty) | 289 | (empty) |
| 5 | 205 | simple | DK-CUSH-01 | Linen cushion sand | 1 | 22 | 0 | (empty) | 29 | (empty) |
| 6 | 206 | simple | DK-CUSH-02 | Linen cushion moss | 1 | 0 | 0 | (empty) | 29 | (empty) |
| 7 | 207 | simple | DK-THR-01 | Cotton throw | 1 | 11 | 0 | (empty) | 59 | (empty) |
| 8 | 208 | simple | DK-BSK-01 | Seagrass basket | 1 | 8 | 0 | (empty) | 35 | (empty) |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
New supplier price list (Spanish headers)
Expected: Slot 1 of “Update catalog”. Compared with store-export.csv: 4 products change, 3 are unchanged, 1 SKU is not in the store, 1 store product is missing from the price list (reported, not deleted).
| Record | Código | Descripción | Precio | Existencias |
|---|---|---|---|---|
| 1 | DK-LAMP-01 | Lámpara de mesa Oslo | 52.00 | 14 |
| 2 | DK-LAMP-02 | Lámpara de pie Oslo | 119.00 | 4 |
| 3 | DK-RUG-01 | Alfombra de lana 120×170 | 189.00 | 3 |
| 4 | DK-RUG-02 | Alfombra de lana 160×230 | 299.00 | 5 |
| 5 | DK-CUSH-01 | Cojín de lino arena | 29.00 | 22 |
| 6 | DK-CUSH-02 | Cojín de lino musgo | 29.00 | 15 |
| 7 | DK-THR-01 | Manta de algodón | 59.00 | 11 |
| 8 | DK-NEW-01 | Jarrón de vidrio | 24.00 | 10 |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
5-supplier-price-list/
A supplier price list for “Prepare supplier file” (German headers, semicolons).
Supplier price list with two price columns
Expected: Not a WooCommerce CSV yet. In “Prepare supplier file” the suggested rules map Artikelnummer → SKU and Preis → Regular price; the purchase price EK-Preis is not suggested. 12 records after mapping.
| Record | Artikelnummer | Bezeichnung | Preis | EK-Preis | Bestand | Kategorie |
|---|---|---|---|---|---|---|
| 1 | DK-MUG-01 | Keramikbecher Nordlicht | 14.90 | 6.20 | 25 | Küche |
| 2 | DK-MUG-02 | Keramikbecher Fjord | 14.90 | 6.20 | 18 | Küche |
| 3 | DK-PLT-01 | Frühstücksteller Ahorn | 9.50 | 3.80 | 40 | Küche |
| 4 | DK-PLT-02 | Speiseteller Ahorn | 12.50 | 4.90 | 32 | Küche |
| 5 | DK-BWL-01 | Müslischale Sand | 8.90 | 3.10 | 0 | Küche |
| 6 | DK-TWL-01 | Geschirrtuch Leinen | 7.90 | 2.70 | 60 | Textil |
| 7 | DK-TWL-02 | Geschirrtuch Karo | 7.90 | 2.70 | 55 | Textil |
| 8 | DK-APR-01 | Kochschürze Canvas | 24.00 | 9.40 | 12 | Textil |
| 9 | DK-CND-01 | Duftkerze Zeder | 16.50 | 5.60 | 20 | Wohnen |
| 10 | DK-CND-02 | Duftkerze Feige | 16.50 | 5.60 | 0 | Wohnen |
| 11 | DK-VAS-01 | Vase Steingut klein | 19.90 | 7.30 | 9 | Wohnen |
| 12 | DK-VAS-02 | Vase Steingut groß | 29.90 | 11.10 | 6 | Wohnen |
Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.
Check your own file
When your file looks like these examples, check it before the import: the check runs in your browser and is free.
Runs in your browser · No files uploaded · Never connects to your store