StoreOpsCheck guide

Shopify Product CSV Template Guide: Columns, Handles, Variants, and Images

Understand Shopify product CSV columns, required fields, handles, variant rows, image fields, SEO fields, and what to check before import.

Run the CSV checker Browse guides

Column groups in a Shopify product CSV

  • Product identity (handle, title).
  • Descriptions/content.
  • Vendor/type/tags.
  • Variant options.
  • SKU/pricing.
  • Inventory/shipping/tax.
  • Images.
  • SEO fields.
  • Status/publishing.

Product row vs variant row example

Handle,Title,Option1 Name,Option1 Value,Variant SKU,Variant Price
trail-bottle,Trail Bottle,Size,500ml,TB-500,24
trail-bottle,,Size,1L,TB-1L,29

Template mistakes to catch before import

  • Hidden header spacing: normalize headers before mapping.
  • Blank handles: fill them on every row.
  • Text prices: use numeric values only.
  • Duplicate option combos: keep each variant combination unique.
  • Broken image URLs: use valid public URLs.

Useful Shopify references

CSV checker

Run a browser-only preflight report.

CSV errors guide

Common product CSV problems and fixes.