Skip to the guide

WooCommerce · Sample CSV

WooCommerce sample products CSV: a demo catalog and test files

A ready-to-import sample catalog in the columns of the built-in WooCommerce importer: 10 simple products and 5 variable products with 19 variations, categories, attributes, sale prices and image links. Use it to test Products → Import on a staging store. Below it are small files that show one case each, including typical mistakes.

Single files: simple-products.csv · variable-product.csv · variation-before-parent.csv · wrong-parent-sku.csv · attribute-value-not-in-parent.csv · store-export.csv · new-price-list.csv · supplier-price-list.csv

Free, no email. Fictional products, no customer data; free to use and change. The ZIP has a README.txt with the expected result of every file. For the small files those are the results of the CatalogDock checker (an automated file check on 2026-11-13); they are not a test import.

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.
TypeSKUNameRegular priceStockCategoriesParentAttribute 1 value(s)
simpleSMP-MUG-350Enamel mug, 350 ml12.0040Home > Kitchen
simpleSMP-NOTEBOOK-A5Notebook A56.00100Stationery
simpleSMP-PEN-GELGel pen, black2.50500Stationery
variableSMP-TEEOrganic cotton teeApparel > T-shirtsS, M, L
variationSMP-TEE-S-WHT19.0012SMP-TEES
variationSMP-TEE-S-BLK19.0015SMP-TEES
variationSMP-TEE-M-WHT19.0020SMP-TEEM
variableSMP-HOODIEHooded sweatshirtApparel > HoodiesS, 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.

ColumnsWhat they do on import
Typesimple, variable or variation. A variable product is one row; each of its variations is a row of its own.
SKUA unique product code. Variations name their parent by this code in Parent.
NameThe 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 catalogPublished: 1 published, 0 private, -1 draft. Is featured?: 1 or 0. Visibility: visible, catalog, search or hidden.
Short description, DescriptionTexts of the product page. A value with a comma is written in double quotes.
Tax statustaxable, 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 priceNumbers with a dot as the decimal separator and no currency sign. Sale price stays below Regular price.
Categories, TagsSeveral values are separated by commas; “Home > Kitchen” is the subcategory Kitchen of Home. Missing ones are created.
ImagesImage URLs separated by commas: the first is the main image, the rest the gallery. The importer downloads them.
ParentOn a variation row: the SKU of its variable product, which comes earlier in the file.
Attribute 1 name, value(s), visible, globalThe 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

  1. Use a staging copy of your store, never the live shop, and never the files of 3-intentional-errors.
  2. Products → Import, choose woocommerce-sample-products.csv (or a file of 1-ready-to-check), keep “Update existing products” off, and check the column mapping screen: every column maps to a WooCommerce field.
  3. 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.
  4. 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.

RecordTypeSKUNameRegular priceStockCategories
1simpleMUG-01Mug12.0025Kitchen
2simpleMUG-02Mug large14.0010Kitchen

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.

RecordTypeSKUNameRegular priceParentAttribute 1 nameAttribute 1 value(s)Attribute 1 visibleAttribute 1 global
1variableTS-001T-Shirt(empty)(empty)SizeSmall, Medium, Large10
2variationTS-001-ST-Shirt - Small25.00TS-001SizeSmall10
3variationTS-001-MT-Shirt - Medium25.00TS-001SizeMedium10
4variationTS-001-LT-Shirt - Large27.00TS-001SizeLarge10

Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.

Check a file

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.

RecordTypeSKUNameRegular priceParentAttribute 1 nameAttribute 1 value(s)Attribute 1 visibleAttribute 1 global
1variationTS-001-ST-Shirt - Small25.00TS-001SizeSmall10
2variableTS-001T-Shirt(empty)(empty)SizeSmall, Medium10
3variationTS-001-MT-Shirt - Medium25.00TS-001SizeMedium10

Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.

Check a file

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.

RecordTypeSKUNameRegular priceParentAttribute 1 nameAttribute 1 value(s)Attribute 1 visibleAttribute 1 global
1variableTS-001T-Shirt(empty)(empty)SizeSmall, Medium10
2variationTS-001-ST-Shirt - Small25.00TS-01SizeSmall10
3variationTS-001-MT-Shirt - Medium25.00TS-01SizeMedium10

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.

RecordTypeSKUNameRegular priceParentAttribute 1 nameAttribute 1 value(s)Attribute 1 visibleAttribute 1 global
1variableTS-001T-Shirt(empty)(empty)SizeSmall, Medium10
2variationTS-001-ST-Shirt - Small25.00TS-001SizeSmall10
3variationTS-001-LT-Shirt - Large27.00TS-001SizeLarge10

Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.

Guide: variations not linking

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.

RecordIDTypeSKUNamePublishedStockBackorders allowed?Sale priceRegular priceParent
1201simpleDK-LAMP-01Desk lamp Oslo1140(empty)49(empty)
2202simpleDK-LAMP-02Floor lamp Oslo160(empty)119(empty)
3203simpleDK-RUG-01Wool rug 120×170130159189(empty)
4204simpleDK-RUG-02Wool rug 160×230120(empty)289(empty)
5205simpleDK-CUSH-01Linen cushion sand1220(empty)29(empty)
6206simpleDK-CUSH-02Linen cushion moss100(empty)29(empty)
7207simpleDK-THR-01Cotton throw1110(empty)59(empty)
8208simpleDK-BSK-01Seagrass basket180(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).

RecordCódigoDescripciónPrecioExistencias
1DK-LAMP-01Lámpara de mesa Oslo52.0014
2DK-LAMP-02Lámpara de pie Oslo119.004
3DK-RUG-01Alfombra de lana 120×170189.003
4DK-RUG-02Alfombra de lana 160×230299.005
5DK-CUSH-01Cojín de lino arena29.0022
6DK-CUSH-02Cojín de lino musgo29.0015
7DK-THR-01Manta de algodón59.0011
8DK-NEW-01Jarrón de vidrio24.0010

Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.

How price and stock updates work

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.

RecordArtikelnummerBezeichnungPreisEK-PreisBestandKategorie
1DK-MUG-01Keramikbecher Nordlicht14.906.2025Küche
2DK-MUG-02Keramikbecher Fjord14.906.2018Küche
3DK-PLT-01Frühstücksteller Ahorn9.503.8040Küche
4DK-PLT-02Speiseteller Ahorn12.504.9032Küche
5DK-BWL-01Müslischale Sand8.903.100Küche
6DK-TWL-01Geschirrtuch Leinen7.902.7060Textil
7DK-TWL-02Geschirrtuch Karo7.902.7055Textil
8DK-APR-01Kochschürze Canvas24.009.4012Textil
9DK-CND-01Duftkerze Zeder16.505.6020Wohnen
10DK-CND-02Duftkerze Feige16.505.600Wohnen
11DK-VAS-01Vase Steingut klein19.907.309Wohnen
12DK-VAS-02Vase Steingut groß29.9011.106Wohnen

Record numbers exclude the header. (empty) marks an empty cell; · marks outer spaces and ↵ a line break.

How supplier price lists are mapped

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