ShopifyGuide

Fix Shopify CSV column names (and map supplier headers)

Shopify matches CSV columns by their exact header. A misspelled header is silently ignored, a supplier's own names ("Price", "Stock", "EAN") are not understood, and a missing Handle column stops the import. The data is in your file — Shopify just does not know where to put it.

Why it happens

  • Typos and spacing: "Varient Price", "Variant SKU", "image src".
  • Supplier or marketplace exports with their own vocabulary: Name, Price, SKU, Barcode, Image URL.
  • Columns renamed in a spreadsheet to make them "nicer" before import.

Broken example

handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Varient Price,image src
oak-table,Oak Table,Acme,Title,Default Title,TAB-1,249.00,https://example.com/table.jpg

Corrected file

Handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Variant Price,Image Src
oak-table,Oak Table,Acme,Title,Default Title,TAB-1,249.00,https://example.com/table.jpg

Check your own file in seconds

The fixer corrects wrong capitals in one click, suggests the right name for a close misspelling (you confirm the rename), and flags a missing Handle. Supplier names that are not typos ("Price", "EAN") are listed as unknown columns: rename them with the table above.

Supplier column → Shopify column

In your supplier fileShopify header
Name / Product nameTitle
DescriptionBody (HTML)
Brand / ManufacturerVendor
CategoryType (or Product Category)
SKU / ReferenceVariant SKU
Price / Retail priceVariant Price
RRP / Was priceVariant Compare At Price
EAN / UPC / GTINVariant Barcode
Weight (g)Variant Grams
Image / Image URLImage Src

How to fix it

  1. Start from Shopify's product CSV template and copy its header row exactly, capitals included.
  2. Rename supplier columns using the mapping above; leave out columns you do not need.
  3. Make sure Handle exists: it is the only column Shopify cannot do without.
  4. Columns that are not in the template (notes, internal codes) can stay: Shopify ignores them.

Shopify documents the expected format in its common product import issues page. Checking is free and your file never leaves your browser; applying fixes and downloading the corrected file take CSV Viewer Pro or a one-time 2,99€ 24-hour pass.

Other Shopify CSV problems