← ImportSift

Shopify product CSV template (free download, imports clean)

A ready-to-edit Shopify product CSV with the rows set up the way Shopify expects: one simple product, and one product with 4 variants (Size × Color) and 2 images. It passes our checker with zero issues.

Download the template (.csv)

Already have a big file? Shopify stops at 15 MB: split it free without breaking products.

How the rows work

  1. One product, many rows. The first row of a product carries Title, Body, Vendor, Tags and the option names. Variant and extra-image rows repeat only the Handle and fill the variant columns.
  2. Handle on every row. Same handle on every row of a product, rows kept together. Lowercase, numbers and hyphens: linen-shirt.
  3. Simple products still have an option. Use Option1 Name = Title and Option1 Value = Default Title.
  4. Option names once, values on every variant. Size / Color sit on the first row only; each variant row has its own Option1 Value / Option2 Value. Two rows with the same values = "variant already exists".
  5. Prices are plain numbers. 49.00, never $49 or 49,00.
  6. Images are public URLs. Shopify downloads them; a path like C:\Users\... can't import. Extra images go on extra rows with Image Position 2, 3…
  7. Inventory values are exact. Variant Inventory Tracker = shopify (or blank), Variant Inventory Policy = deny or continue, Variant Fulfillment Service = manual.
  8. Save as UTF-8 CSV. In Excel choose "CSV UTF-8", or curly quotes and accents come out as ’.

This template uses Shopify's classic column names (Variant Price, Body (HTML)), which Shopify still imports. Newer Shopify exports use names like Price and Description; either works, just don't mix the two in one file.

Filled it in and the import still fails? Drop your file into the free checker: it lists every problem row by row, in your browser (the file isn't uploaded).

Check my CSV free

Other import errors

ImportSift is independent and not affiliated with Shopify. · support@importsift.com