Turn your supplier CSV into a Shopify import file.
Map your columns, review your products, and download the complete file for $12. No app installation or subscription.
$12 per file · free validation and sample
Input → output example (3 variants)
Your supplier CSV
| parent_id | title | sku | color | size | price | image1 |
|---|---|---|---|---|---|---|
| P100 | Classic Tee | TEE-BLK-S | Black | S | 19.00 | https://cdn…/tee-black.jpg |
| P100 | TEE-BLK-M | Black | M | 19.00 | ||
| P100 | TEE-WHT-S | White | S | 21.00 | https://cdn…/tee-white.jpg |
Shopify import CSV
| Handle | Title | Option1 Name | Option1 Value | Option2 Name | Option2 Value | Variant SKU | Variant Price | Image Src | Status |
|---|---|---|---|---|---|---|---|---|---|
| cp-classic-tee-b39af233e0cd | Classic Tee | Color | Black | Size | S | TEE-BLK-S | 19.00 | draft | |
| cp-classic-tee-b39af233e0cd | Color | Black | Size | M | TEE-BLK-M | 19.00 | |||
| cp-classic-tee-b39af233e0cd | Color | White | Size | S | TEE-WHT-S | 21.00 | |||
| cp-classic-tee-b39af233e0cd | https://cdn…/tee-black.jpg | ||||||||
| cp-classic-tee-b39af233e0cd | https://cdn…/tee-white.jpg |
Full example: product variants recipe.
Supported and unsupported
Supported
- One CSV; each row is a simple product or a variant
- Comma, semicolon or tab delimiter; UTF-8, UTF-8 BOM, UTF-16LE BOM
- Title, plain-text description, vendor, type, tags, SKU, price, compare-at price, barcode
- Up to 3 option columns (e.g. Color, Size); up to 5 product image URL columns; optional variant image
- Explicit parent/product ID column for variant grouping
- Up to 10 MiB, 5,000 rows, 80 columns; all products created as draft
Not supported
- XLSX/XLS, multiple sheets, archives, embedded images
- Inventory, locations, weight/shipping, metafields, tax/category, Google/Markets columns
- Updating existing products or stock; store migration; handle checks against your store
- HTML descriptions from the source (plain text is converted safely)
- Remote fetching of image URLs, custom formulas, AI mapping, accounts or subscriptions
How it works
- Upload your supplier CSV. We detect the delimiter and encoding and show your headers.
- Map columns to Shopify fields, choose products or variants mode and the parent ID column.
- Review grouping, errors and warnings for the whole file, plus a preview of the first products.
- Download the complete Shopify CSV for $12 — or the free fixed sample first.
Free check, paid download
Free
- Full validation report for every row
- Preview of the first 5 whole products (max 20 variants)
- One fixed sample ZIP of the first 2 whole products (max 10 variants)
- Variant groups are never cut to fit the limits
$12 one-time
- Complete
shopify-products.csvfor this file and mapping validation-report.htmlandimport-instructions.txt- Download again for 7 days with your recovery code
- No account, no app install, no subscription
Rules we apply
- Price is required per row, must be ≥ 0 with at most 2 decimals; the decimal separator is set by you and never guessed. Currency symbols and thousands separators are reported, not stripped. Zero prices need confirmation.
- Compare-at price must be greater than price. Duplicate SKUs are warned and need acknowledgement.
- Variants: option combinations must be unique inside a parent; product-level fields (title, vendor, description, type, tags) must match inside a group. Conflicts are reported by row, never merged silently.
- SKU and barcode stay text — leading zeros are preserved.
- Handles are deterministic:
cp-<slug>-<hash>. We do not check handles that already exist in your store; never enable overwrite when importing. - Cells starting with
=,+,-,@are rejected as possible spreadsheet formulas unless you choose to prefix them with an apostrophe. - Image URLs must be absolute https:// URLs. We never download them; the report marks them
not_checked. - Descriptions are imported as escaped plain text with paragraphs and line breaks — never as raw HTML.
- Nothing is dropped silently: blank, short and extra-column rows are listed in the report.
Rule pages: invalid header, duplicate option combination, invalid price.