BigCommerce Product CSV Import Schema - AI Agent Skill
Free AI agent skill for generating BigCommerce-conformant product CSV import files. Covers Product/Variant rows, [S] option syntax, Custom Fields, and image handling.
BigCommerce Product CSV Import Schema - Agent Skill
An AI agent skill for generating BigCommerce product CSV import files. BigCommerce's format has unique conventions - a Product/Variant row model with sequential ID referencing, the unusual [S]OptionName=Value syntax for variant options, and Custom Fields for option definitions.
What's in the skill file?
- Product/Variant row model: Explicit
Itemcolumn withProductorVariantvalues - Sequential ID system: Variants reference their parent's auto-assigned ID - understanding the sequence is critical
- [S] option syntax: BigCommerce's unique
[S]Size=M[S]Colour=Whiteformat for variant option combinations - Custom Fields for options: Option definitions use
[OptionName]=[Value]in the Custom Fields column on Product rows - Complete column reference: 47 columns covering identity, pricing, SEO, images, video, and shipping
- 11 common pitfalls: Sequential ID referencing, [S] prefix syntax, Product URL format, and more
Key technical constraints
| Constraint | Value |
|---|---|
| Row types | Product and Variant (via Item column) |
| Variant option syntax | [S]Name=Value (concatenated, no separator) |
| Max variants per product | 250 |
| Boolean format | Uppercase TRUE / FALSE |
| Category separator | Semicolon (;), hierarchy uses / |
| Product URL format | Must start and end with / |
How to use this skill
- Download the
.mdfile above - Add it to your AI tool's context
- Ask your AI to generate a BigCommerce product CSV - it will handle the [S] syntax, sequential IDs, and Custom Fields correctly
Need a ready-to-use template?
If you'd rather start with a pre-filled spreadsheet than a schema reference, download our free BigCommerce Product CSV Template with example products, variants, and the [S] option syntax pre-formatted.
Skip the CSV entirely with Product Upload
BigCommerce's [S] option syntax is unlike any other platform - one wrong bracket and variants break. Product Upload imports products directly into BigCommerce from any website. No CSV, no syntax errors.