Shopify CSV header repair
Shopify CSV Invalid Header Error
This error usually means Shopify cannot match your CSV header row to its exact product import columns. EcomCSVFix fixes casing, hidden BOM characters, extra spaces, and unsupported columns automatically.
What causes this error
- Wrong column name casing, such as "handle" instead of Shopify's exact "Handle" header.
- Extra spaces before or after headers, such as " Title " or "Variant Price ".
- Unsupported custom columns copied from another platform, marketplace export, or supplier sheet.
- A hidden BOM character before the first header, so "Handle" looks correct but is really prefixed by invisible bytes.
How to fix it
Option A: fix it manually
- Open the CSV in Excel or Google Sheets and freeze the first row so you can inspect every header.
- Compare each header against Shopify column names such as "Handle", "Title", "Vendor", "Variant Price", and "Image Src".
- Remove unsupported columns or move that data into valid Shopify metafield/import columns if your store supports them.
- Save or export the file as CSV UTF-8, then import the cleaned file into Shopify again.
Option B: fix it automatically
- Upload your CSV to EcomCSVFix and let it scan the header row for casing, spacing, and BOM problems.
- Download a Shopify-ready CSV with corrected headers and a report showing what changed.
Before and after
handle,title,vendor,variant price
blue-shirt,Blue Shirt,Acme,$19.99Handle,Title,Vendor,Variant Price
blue-shirt,Blue Shirt,Acme,19.99Fix it automatically in 30 seconds
Upload your CSV, let EcomCSVFix repair the broken rows, then download a Shopify-ready file.
Free for up to 5 files/month. No credit card.
FAQ
Why does Shopify reject lowercase headers?
Shopify product imports expect specific column names. "Handle" and "handle" can be treated differently by strict import validation, so exact casing is safest.
Can custom supplier columns stay in the CSV?
Usually no. Columns from dropshippers, ERPs, or marketplaces should be removed unless they map to a Shopify-supported product CSV column or an accepted metafield format.
What is a BOM in a CSV header?
A BOM is an invisible byte marker at the start of some UTF-8 files. If it appears before Handle, Shopify may read the first header as a different value.
Will this change my product data?
The tool fixes the CSV structure and header names while keeping your product fields intact wherever possible.