WooCommerce Product CSV Import Schema - AI Agent Skill
Free AI agent skill for generating WooCommerce-conformant product CSV import files. Covers product types, attribute columns, parent-variation linking, and common pitfalls.
WooCommerce Product CSV Import Schema - Agent Skill
An AI agent skill for generating WooCommerce product CSV import files. WooCommerce's CSV format is more complex than Shopify's - it uses a type-based model with simple, variable, and variation product types, and dynamic attribute columns that don't appear in the default header.
This skill file documents every column, the parent-variation linking mechanism, attribute syntax, and the pitfalls that trip up both humans and AI tools.
What's in the skill file?
- Product type model: How
simple,variable,variation,grouped, andexternaltypes interact - Parent-variation linking: How variation rows reference their parent via the
Parentcolumn using SKU - Dynamic attribute columns: The
Attribute N name/value(s)/visible/globalpattern for product options - Pipe separator for values: Variable parents use
|to list all option values; variations use single values - Complete column reference: Every field with type, constraints, and behavior
- 10 common pitfalls: Missing Parent column, pipe vs comma, no price on variable parents, and more
Key technical constraints
| Constraint | Value |
|---|---|
| Product types | simple, variable, variation, grouped, external |
| Variation linking | Parent column = parent SKU |
| Attribute value separator | Pipe (|) on parent rows |
| Boolean format | 1 / 0 |
| Category hierarchy | Clothing > T-Shirts (space-angle-space) |
| Max options per product | Unlimited (no platform limit) |
How to use this skill
- Download the
.mdfile above - Add it to your AI tool's context - system prompt, project rules, or knowledge base
- Ask your AI to generate a WooCommerce product CSV and it will handle the type system, attribute columns, and parent-variation linking correctly
Need a ready-to-use template?
If you'd rather start with a pre-filled spreadsheet than a schema reference, download our free WooCommerce Product CSV Template with example products and every column pre-formatted.
Skip the CSV entirely with Product Upload
WooCommerce's CSV format is particularly tricky - dynamic attribute columns, pipe separators, parent-variation linking. One mistake and your variants don't connect. Product Upload bypasses all of this. Import products from any website directly into WooCommerce with one click.