CHECK MY IMPORT HELP
Why did my Shopify CSV import delete variants?
October 6, 2026 · Check My Import
A CSV meant to update prices or tags can leave a product with one default variant instead of its previous sizes and colors. The usual cause is missing or changed option data.
The most common cause: option columns were left out
When a CSV updates variant-related data without Option1 name and Option1 value, Shopify can create a new default variant and delete existing variants.
| What the file includes | What can happen |
|---|---|
| Handle, option names and values, and variant columns | Variants can be matched and updated. |
| Handle and variant columns, but no option columns | Existing variants can be replaced by a default variant. |
| Handle and product-only columns | Variants are left as they are. |
Other ways variants get replaced
- Option values or names changed.
- Variant rows were rearranged instead of remaining together beneath the same handle.
- The first row holding option names was removed or changed.
One setting is often blamed but rarely the cause: Overwrite products with matching handles. With it off, matching existing products are skipped; with it on, Shopify applies the column rules above.
How to prevent it
- Export a fresh catalog before every import.
- Keep option columns when touching variant data.
- Do not rename option values unless new variants are intended.
- Test a small group first.
- Compare the export and proposed import before uploading.
If it already happened
- Stop further imports.
- Find the last good export.
- Re-import affected products with option and variant columns included.
- Check inventory and systems tied to variant IDs.
Check your file before importing
Check My Import compares a current export with the file you plan to import and flags missing option columns, blanked fields, zero prices, and variants that could be recreated. It is free during the beta, needs no Shopify connection or account, and does not store your files.