Shopify Product CSV Import Schema - AI Agent Skill
Free AI agent skill for generating Shopify-conformant product CSV import files. Covers every column, variant handling, image rows, and common pitfalls.
Shopify Product CSV Import Schema - Agent Skill
This is an AI agent skill - a structured technical reference designed for AI coding assistants, LLMs, and automation tools. Feed it to your AI tool of choice (Claude, ChatGPT, Cursor, Copilot, etc.) and it will generate Shopify-conformant product CSV files without the usual formatting errors.
What's in the skill file?
- File format spec: Encoding, delimiter, quoting rules
- Variant model: How Shopify's row-per-variant system works - first row has product fields, subsequent rows share the Handle with blank product fields
- Complete column reference: Every column with type, constraints, and behavior (46 columns total)
- Image handling: How to add multiple images using image-only rows
- Google Shopping fields: Product category, gender, age group, condition, custom labels
- 10 common pitfalls: Handle case sensitivity, blank product fields on variant rows, Variant Grams vs Weight Unit, and more
- Validation checklist: Pre-import checks to catch errors before upload
Key technical constraints
| Constraint | Value |
|---|---|
| Max variants per product | 100 |
| Max options per product | 3 (e.g., Size, Color, Material) |
| Boolean format | TRUE / FALSE |
| Variant grouping | Same Handle value |
| Weight field | Variant Grams - but unit is overridden by Variant Weight Unit |
| Status values | active, draft, archived |
How to use this skill
- Download the
.mdfile above - Add it to your AI tool's context - paste it into the system prompt, attach as a file, or add to your project's knowledge base
- Ask your AI to generate a Shopify product CSV and it will follow the exact schema
Works with Claude Code (add to .claude/ directory), Cursor (add to project rules), ChatGPT (attach to conversation), or any LLM workflow.
Need a ready-to-use template?
If you'd rather start with a pre-filled spreadsheet than a schema reference, download our free Shopify Product CSV Template with 3 example products and every column pre-formatted.
Skip the CSV entirely with Product Upload
Agent skills help AI generate correct CSV files - but Product Upload eliminates CSVs altogether. Import products from any supplier website directly into Shopify with one click. AI-powered descriptions, images, variants, and pricing - all handled automatically.