Shopify CSV import error
“Invalid CSV header: missing headers”: what it means and how to fix it
Why it happens
- The first row isn't the header row. A title, a blank line or notes sit above it.
- A column was renamed, or a required column was deleted.
- There are extra spaces at the end of the first line.
- The file was exported from another platform or app with its own column names.
How to fix it
- Export one product from your store (Products → Export) and copy that file's first row: it's exactly the header row Shopify expects.
- Make sure the header row is the very first line of the file, with nothing above it.
- Open the file in a plain text editor and remove any spaces or commas after the last header.
- Rename your own column names to Shopify's, such as Variant Price rather than Price.
- Save as CSV with UTF-8 encoding and import again.
How Bulkvane handles it
Bulkvane doesn't need an exact header row. It reads its own headers, Shopify's and common aliases such as “SKU” or “Price”, in any order. Columns it doesn't use are listed and ignored before anything changes, and the only requirement is an ID, Handle or Title column. Without one, the check says: “The file needs an “ID”, “Handle” or “Title” column so we know which products to create or update.”
Every file is checked before anything changes, with problems named by row in plain words, and any import can be undone for 30 days. All of Bulkvane's messages are in Errors A–Z.
Questions
Do I need every column in the header row?
Shopify's importer expects its full header row. You can leave cells empty, but keep the columns. Bulkvane only needs the columns you're changing plus an ID, Handle or Title.
Why do I see a “Choose column headings” window?
Shopify shows it when your headers don't match its own. Pick the right Shopify column for each one from the menus, or fix the header row and upload again.
Message, cause and fix from the Shopify Help Center: common product CSV import issues, checked . Still stuck? See Shopify CSV import not working? or ask us.
Preview every change.Undo any import for 30 days.
Install free