Why does my Shopify CSV import keep dropping variants for no reason?
If your CSV import is silently dropping variants or extra images, the cause is almost always a missing or inconsistent Handle value on the follow-up rows.
What's going on
You bulk-uploaded a product CSV with multiple variants (or extra images) per product, but after the import finishes, some variants are just missing. There's no error dialog pointing at a specific row — the product simply comes in with fewer variants or images than the file contained, or a whole variant block silently disappears.
This happens because Shopify's product CSV format links rows together by the value in the Handle column. The first row of a product carries the full product data (title, description, vendor, tags), and every additional row for that same product — another variant combination or another image URL — has to repeat that identical Handle value while leaving Title and the other product-level fields blank. If a follow-up row has a blank Handle, a Handle that doesn't exactly match the row above it, or a Title filled in when it shouldn't be, the importer can't tell it belongs to the existing product group and drops or misfiles it instead of adding it as a new variant.
Because the import doesn't always throw a hard error for this, it's easy to assume the CSV is corrupt or the importer is buggy, when the real issue is almost always the row structure of the file.
Why it happens
Shopify's CSV format doesn't use a separate product ID column to group rows — it groups them by the literal Handle text value plus which columns are populated on each row. That makes the format stricter about repetition than many spreadsheet exports people are used to, where each variant might get a blank or auto-incremented ID instead of a repeated text value.
Exports from other platforms, or CSVs assembled by hand in Excel or Google Sheets, often fill in the Handle only on the first row of each product for readability, leaving it blank on the rows below since the product is 'obviously' the same one to a human reader. The importer doesn't infer that continuation — it needs the value repeated literally on every row.
5 ways to fix it
Repeat the Handle on every variant and image row — this is the actual fix
Open your CSV and check the Handle column: it must contain the exact same value on every row belonging to a product, whether that row is a variant (different size or color) or an extra image. Only the first row for a product should have Title, Description, Vendor, and Tags filled in; every later row for that product should leave those blank but repeat the Handle and fill in the Option Name/Value columns plus that variant's SKU, price, and image URL. If a row has a Handle that doesn't match the group above it, or a blank Handle, the importer can't tell it belongs to the existing product, so it gets dropped instead of attached as a new variant.
Watch for a Title filled in on variant rows, not just a missing Handle
A common mirror-image mistake causes the same symptom: filling in the Title column on rows that are supposed to be variants of an existing product. When Title is present, the importer treats the row as the start of a new product, and if that Handle already exists elsewhere in the file, the row can get skipped as a conflicting duplicate. Only the first row of each product group should have a Title; every variant row after it needs Title left blank.
Export a real sample from your store and compare row structure before re-uploading
Rather than editing a hand-built spreadsheet blind, select a few of your existing multi-variant products from the Products page and export just those to CSV. Open that file next to yours and match its row pattern: repeated Handle, blank Title and Description on variant rows, Option Name/Value filled in on every row. This built-in export is the most reliable template to copy, since it reflects whatever column set your store's import currently expects.
Check the Option Name columns too, not only the Handle
The importer also needs the Option Name (for example Size or Color) repeated on every row, not just the Handle. A row with the correct Handle but a blank Option Name or Value can still fail to attach as a variant. Check both columns together on any row that got skipped before you re-import.
For recurring bulk imports, a dedicated import app can enforce the format for you
If you're regularly pulling variant and image data from a POS system, spreadsheet, or another platform, hand-formatting the repeated-handle structure every time is easy to get wrong. A CSV import app from the Shopify App Store can validate the file and auto-repeat handles before upload. That's worth the cost only if imports are frequent; for a one-time cleanup, fixing the CSV by hand against an exported sample is usually faster.
Bottom line
This is a formatting requirement of Shopify's CSV import, not a bug, so the free fix — repeating the Handle and Option Name on every row, checked against an exported sample file — resolves it completely for most one-off imports. Reach for a dedicated import app only if you're doing this kind of bulk variant or image import repeatedly and want the format enforced automatically.
Browse the rest of the problem library, run a free storefront scan to catch issues like this automatically, or email us and we'll work out a custom solution for it.