WooCommerce Product CSV Checker Skill

Catch the problems that make WooCommerce skip rows or import broken products, before you click Import. One command, a report you can read, and a safely fixed copy.

python3 -m woocsv check products.csv                          # report (exit 1 if anything is high severity)
python3 -m woocsv check products.csv --fix products.fixed.csv  # + fixed copy and products.fixed.changes.csv
python3 -m woocsv check products.csv --issues issues.csv --json

• File: UTF-8 encoding (Excel's Windows-1252 breaks accents), duplicate or misspelled headers, rows with the wrong number of cells, columns the importer won't import (custom fields need a meta: prefix).
• Values: Type (simple, variable, grouped, external, variation, virtual, downloadable), Published (1, 0, -1, 2), 1/0 booleans, Backorders allowed? (1, 0, notify), catalog visibility, tax status, stock (number, blank, or parent on variations), dates (YYYY-MM-DD, end after start), n/a or numbers for download limits.
• Prices and dimensions: plain numbers only (no $, no thousands separators, dot decimals), sale price below regular price, no units inside Weight (kg)-style columns.
• Variations: a Parent (SKU or id:123) that exists in the file as a variable product (or already in your store), attribute names and values that match the parent, one value per attribute, a unique SKU (WooCommerce doesn't generate one).
• Products: required Name, unique SKUs, external products with an External URL, IDs that only update existing products, id: prefixes in Grouped products/Upsells/Cross-sells, images that are local file paths or http://, <script> in descriptions.

Formatting only, each one logged in *.changes.csv: re-encode to UTF-8, yes/no/true/false to 1/0, status words (draft, published, private, pending) to codes, prices to plain numbers, units stripped from dimension columns when they match the column unit, enum values lowercased. It never changes SKUs, parents, attributes or which products exist.

skills/woocommerce-product-csv/SKILL.md tells Claude Code (or any agent that reads skills) how to run the checker, explain results and offer the fix. Copy the folder into .claude/skills/.

Run ./demo.sh for the example (9 rows, 23 issues, 9 safe fixes) and ./run_tests.sh for the tests. Python 3.9+, no dependencies, works offline; your CSV never leaves your computer.

Covers the core WooCommerce importer (woocommerce.com docs, checked Nov 9, 2026), not third-party import plugins. It can't see your store, so it can't confirm that parents, categories, tax classes or shipping classes referenced in the file already exist. Always back up and test a big import on staging.

Also see the Shopify Product CSV Checker Skill for Shopify imports. License: LICENSE.txt.