WooCommerce Products
Clean WooCommerce product templates: required fields, pricing formats, SKUs, categories, and common import mistakes.
Expected columns
Example row
| ID | Type | SKU | Name | Published | Is featured? | Visibility in catalog | Short description | Description | Regular price | Sale price | Date sale price starts |
|---|---|---|---|---|---|---|---|---|---|---|---|
| simple | WC-TEE-CLASSIC-S | Classic Tee | 1 | 0 | visible | A short marketing blurb. | Full product description. | 24.99 |
About this format
WooCommerce's built-in Product CSV Importer is strict about column names, data types, and variation structure. This preset validates your file against the canonical importer fields and applies safe normalizations so your import runs cleanly.
Use it for migrations, bulk price updates, adding categories/tags, and importing variable products with variations. Anything risky stays in the issue list for manual review.
How it works
- 1Upload your WooCommerce product CSV (export or import template).
- 2We canonicalize headers, normalize common values, and flag missing required fields.
- 3Safe fixes are applied automatically (booleans, prices, URL cleanup).
- 4Review remaining issues, then export an import-ready CSV.
Examples of fixes
- Normalize Published / In stock? / Backorders allowed? / Sold individually?
- Normalize Regular price / Sale price to plain decimals (no currency symbols)
- Trim whitespace everywhere and normalize category/tag separators
- Validate image URLs and remove empty entries
- Detect duplicate variation attribute combinations under the same parent
FAQ
Popular CSV Guides
Step-by-step guides for common CSV import problems.
Understand how the WooCommerce product importer represents variable products with parent and child (variation) rows. Covers attribute columns, required fields per row type, and the most common import pitfalls.
How to correctly format WooCommerce product attributes in a CSV file — attribute naming, global vs. local attributes, variation attributes, and common mistakes.
Fix the most common WooCommerce product CSV import errors — missing SKUs, invalid types, variation row problems, price formatting, and attribute column issues.
Understand the difference between appending rows, merging files with the same structure, and joining files with related data. Choose the right approach for your ecommerce catalog workflow.
Understand headers, UTF-8 encoding, quoting, line endings, and the most common mistakes that break ecommerce CSV imports -- before your first upload.
How to diagnose and fix column mismatch errors in CSV imports — wrong column names, case differences, extra spaces, and column order problems across ecommerce platforms.