WooCommerce Variable Products
WooCommerce variable products + variations (auto-creates missing parent rows and validates variation structure).
Expected columns
Example row
| ID | Type | SKU | Name | Published | Is featured? | Visibility in catalog | Short description | Description | Date sale price starts | Date sale price ends | Tax status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SKU-1001 | Sample Product | TRUE | 19.99 | 19.99 |
About this format
Use this preset to validate your CSV against the expected template and export a clean, import-ready file.
How it works
- 1Upload your CSV.
- 2We validate required fields and normalize common formatting.
- 3Auto-fix safe issues, then export a clean file.
Examples of fixes
- Trim whitespace and normalize basic fields.
- Flag missing required values.
- Standardize common boolean fields.
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.