Shopify CSV template checker

Check your Shopify CSV template
headers and required fields

Compare your product CSV against key Shopify-style columns including Handle, Title, Vendor, Variant SKU, Variant Barcode, Variant Price, inventory, and option fields.

Drop CSV files here

or click to browse · 15 MB each · 5 files max

No signup requiredFiles deleted after processingNo data stored

16+

Issue types checked

Auto-fix

Safe errors fixed for you

0 bytes

Data stored on server

Why imports fail

What breaks Shopify CSV imports

The checker finds these automatically and tells you exactly which row and cell to fix.

Header mismatch

Find headers that were renamed, merged, or exported from another platform.

Required fields

Catch missing Handle, Title, Vendor, price, and core variant fields.

Spreadsheet cleanup

Spot encoding and quote problems caused by Excel or Google Sheets.

Known header fixes

Auto-rename supported header variants when the intent is clear.

HandleTitleVendorVariant SKUVariant BarcodeVariant PriceOption fields
How it works

Check Shopify product CSV headers before import

Shopify's product CSV template uses exact column names like 'Variant Price' and 'Image Src'. If you exported from another platform, renamed a column in Excel, or used a supplier template, the headers will not match and Shopify will either reject the file or silently ignore those columns. This checker compares your headers against the Shopify template, flags mismatches, and renames safe ones automatically.

Shopify-style header review

Detect missing and renamed columns across core product, variant, barcode, price, and inventory fields.

fantastic-bronze-lampPrice
mediocre-leather-plate✓ OK
copper-benchBarcode

Required field reporting

Get row-level warnings for missing values that should be present before upload.

Auto-fix preview

$20,0320.03
FANTASTIC LAMP!fantastic-lamp
“Greatâ€"Great"

Clean template export

Download a clean CSV after safe header and formatting fixes are applied.

B2 · Variant Price · error
Currency symbol in price field
E4 · Handle · error
Invalid handle format
Questions and answers

Frequently asked questions

Common questions about Shopify CSV templates.

Does column order matter in a Shopify product CSV?

No. Shopify matches columns by name, not position. You can reorder columns freely, but the names must match exactly — including capitalisation and spacing.

What happens to columns Shopify does not recognise?

Shopify silently ignores unknown columns. They do not cause an error but the data is not imported. This checker flags column names that look like Shopify fields but are slightly off, such as 'Price' instead of 'Variant Price'.

Can it rename incorrect headers automatically?

Yes. When a header mismatch is unambiguous, such as 'SKU' instead of 'Variant SKU', the checker renames it in the clean CSV output.

Which columns are required versus optional?

Handle and Title are required for every product's first row. Variant Price, Variant SKU, and Vendor are strongly recommended. Option and inventory columns are only needed when you use those features.