“Ignored line because it did not contain product data”: what it means
Shopify skipped rows because the product they belong to has a URL handle but no title on its first row. Without a title, Shopify has no product to attach the rows to.
Ignored line #-## because it did not contain product dataWhat the message means
Shopify reads a product’s rows from the top. The first row for a handle must contain the product-level data, and at minimum a Title. Shopify’s help center describes the cause as a product that has a handle but no title. When it’s missing, the rows are ignored, and the import summary lists their line numbers.
Common causes
- Rows sorted in the wrong order, so a variant row (with an empty title) comes before the row that has the title.
- A title that was accidentally cleared during editing or by a formula.
- Rows for a product that doesn’t exist yet, written as if you were adding variants to an existing product.
Broken: the variant row comes first.
URL handle,Title,Option1 name,Option1 value,Price
linen-runner,,,Natural,21.00
linen-runner,Linen Table Runner,Color,Sand,21.00Fixed: the row with the title and option name comes first.
URL handle,Title,Option1 name,Option1 value,Price
linen-runner,Linen Table Runner,Color,Sand,21.00
linen-runner,,,Natural,21.00How to fix it
- Note the line numbers in the message or email and find those rows.
- For each handle, make sure the first row has the title, description, vendor and option names.
- If you sorted the sheet, sort by handle and then make sure each product’s title row stays on top.
- Import only the fixed products again. Run the file through the free Shopify CSV checker before you import again.
Catch it before importing
The free checker reports “the first row of a product needs a title” for exactly this situation. When Sheet2Store writes a Shopify CSV, the first row of every product carries the title and product fields automatically.
Frequently asked questions
Were the other products imported?
Yes. Shopify ignores only the listed lines and imports the rest, so fix and re-import just the affected products.
Do variant rows need a title?
No. Only the first row of each product needs one. Later rows with the same handle can leave Title empty.
Can I add variants to an existing product this way?
Only if the product already exists with that handle and you import with “Overwrite products with matching handles” checked. Include the product’s full set of variants to avoid overwriting data unintentionally.
Check your Shopify CSV for free
Upload a product CSV (up to 500 rows) to find missing titles and prices, duplicate SKUs, repeated variant combinations and products not set to draft.