CatalogDock: small WooCommerce product CSV examples
===================================================

Updated 2026-10-05. Synthetic data: fictional products, no customer data. Free to use and change.
Source: https://catalogdock.org/guides/woocommerce-csv-template

All files are UTF-8, for the built-in WooCommerce importer (Products > Import).
What "expected" means: the result the CatalogDock checker gives for the file (checked with its rules on the date above).
That is a file check, not a test import. Import only into a staging copy of your store first, and never import the
files of 3-intentional-errors: they are wrong on purpose.

1-ready-to-check/
  Correct files: they pass the CatalogDock structural checks as they are.
  - simple-products.csv: Simple products.
    Expected: Passes the structural checks: 2 simple products, nothing to fix.
  - variable-product.csv: Variable product with three variations.
    Expected: Passes: the parent comes first, every variation names it in Parent and uses a size the parent lists.

2-fixed-automatically/
  A file with a problem CatalogDock fixes by itself (the order of the rows).
  - variation-before-parent.csv: Variation listed before its parent.
    Expected: VARIATION_BEFORE_PARENT, fixed automatically: the corrected file moves the parent above its variations and passes.

3-intentional-errors/
  Files with deliberate mistakes. Do not import them: they show what the report says.
  - wrong-parent-sku.csv: 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.
  - attribute-value-not-in-parent.csv: 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.

4-update-pair/
  Two files for “Update catalog”: a store export and a new supplier price list.
  - store-export.csv: Store export (8 products).
    Expected: Slot 2 of “Update catalog”: the export of the store, in the columns of Products → Export.
  - new-price-list.csv: 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).

5-supplier-price-list/
  A supplier price list for “Prepare supplier file” (German headers, semicolons).
  - supplier-price-list.csv: 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.

Safe test import (staging only):
  1. Products > Import, choose a file of 1-ready-to-check, keep "Update existing products" off.
  2. Check the mapping screen: every column should map to a WooCommerce field.
  3. After the import, open the variable product and check that all variations are attached.
  The update pair is imported with "Update existing products" on, and only after you compared the files in
  CatalogDock: the SKUs of store-export.csv must exist in the store you update.
