- shopify
- product-csv
- csv-import
Fix Common Shopify Product CSV Import Errors

Quick answer
When a Shopify product CSV import fails, start with the exact error and row number. Check the column headers, product handles, variant option combinations, prices, image URLs, and UTF-8 encoding. Fix the affected rows, then import a small sample before retrying the full file.
A product import can fail because of one header, one variant row, or one image URL. Shopify's error message usually tells you where to look, but it doesn't always explain how the rows fit together. Keep a copy of the original file, then find the message you received below. Shopify's common import issues page lists the full set.
"Invalid CSV header: missing headers"
Inspect the first row of the file. Column names are case-sensitive. An extra space, a changed capital letter, or a spreadsheet that saved its own labels can stop Shopify from matching a column. Shopify may offer a Choose column headings screen so you can map mismatched names during import.
Start from a fresh product export or Shopify's sample file when you can. Current exports call the product identifier URL handle; older templates use Handle, and Shopify still accepts the older names. Use one set throughout the file. The product CSV field reference maps every old header to its current name.
"Ignored line because handle already exists"
The full message names the line and the handle, for example Ignored line #-## because handle `example` already exists. A handle identifies a product, so two different products can't share one. Give one of them a new, unique handle.
Repeated handles are expected on a product's later rows. Variant rows and extra image rows reuse the handle and leave Title blank. This error means two rows with a Title claim the same handle.
"Ignored line because it did not contain product data"
A line has a handle but no product data. If it's the first row for that handle, add the product's Title. If it was meant to be a variant or image row, check that it sits under the right product and that its variant or image columns are filled in.
If you're updating products already in the store, match the existing handle exactly, and review the import preview and overwrite choice before committing a large update.
"Validation failed: options are not unique"
Two variants of one product cannot have the same combination of option values. For example, if black-shirt has two rows with Color = Black and Size = M, Shopify cannot tell the variants apart. Find the duplicate rows under that handle and correct the option values or remove the extra row.
Check all the option columns, not just the first one. A second copy of the product elsewhere in the file can also cause this error.
"Validation failed: price can't be blank"
Fill the price on the row Shopify names. Don't assume the price on the first product row covers every variant.
Related columns matter too. An update to a variant field such as SKU or weight also needs the columns that identify the variant, Option1 name and Option1 value. Without them, Shopify can create a default variant and remove the existing ones. Keep those columns in the file even when you only mean to change one field.
"Validation failed: An error occurred while trying to download the image"
An image in a CSV is a URL, not a file attachment. Paste the URL into a private browser window. It should open the image without a sign-in, and the address should begin with https:// (or http://). If it leads to a sharing page or an expired link, upload the image somewhere public and use its direct URL. An image that has been removed since the CSV was exported can also break a later import.
A related message, "Validation failed: getaddrinfo: nodename nor servname provided, or not known", means the URL is missing its https:// prefix or points to a host that doesn't exist.
"Illegal quoting on line"
CSV uses quotation marks to keep commas and line breaks inside a cell. A stray quote in a product description can shift the rest of that row into the wrong columns. Shopify reports it as "Illegal quoting on line" or "Missing or stray quote on line". Smart quotes pasted from a word processor are a common cause, so replace them with straight quotes.
Open the file in a spreadsheet editor or a text editor that understands CSV, repair the affected cell, and export again as UTF-8 CSV with LF line endings. If accented letters or other characters look wrong, fix the file's encoding first; changing a header or a handle won't repair text saved in the wrong encoding.
Check the file before another full import
- Save the original CSV so you can compare any changes.
- Find the first error and inspect the named line plus the product rows around it. Variant and image rows depend on their parent product's handle.
- Fix that error, then scan the same column for repeats. A copied mistake often appears in more than one row.
- Import a small sample of the corrected products. If it works, retry the full file and review the import result.
The free Shopify CSV Validator flags header mistakes, missing or repeated product handles, duplicate variant option combinations, image URLs missing http:// or https://, and smart quotes. It reads both the current and the older header names, and it checks the file in your browser. It does not download images or run Shopify's import rules, so still review Shopify's import preview.
If you imported the file to change prices, the bulk price editing guide covers the columns to keep and the checks to run first.
Once the import goes through, ShopSheets syncs your catalog to a Google Sheet with each product's handle, status, variant count, and tags, so you can confirm the result without exporting again.