Quick answer
Group rows by Handle, then compare Option1 Value, Option2 Value, and Option3 Value. Remove or correct rows where the complete combination is duplicated. Do not flag the repeated handle by itself, because multiple variant rows for one product intentionally share the same handle.
What the error means
A product can have variants such as Size and Color, but each combination can appear only once. Two rows for Medium / Black under the same product handle collide even when their SKUs or prices differ.
Fix it step by step
1. Sort or filter by Handle
Keep all rows belonging to the same product together. Do not globally deduplicate handles; a product with several variants correctly repeats its handle.
2. Compare the complete option combination
Check the values across every option column used by that product. Medium / Black and Medium / Blue are unique; two Medium / Black rows are not.
3. Decide which row is correct
If one row is accidental, remove it. If the variants are genuinely different, change an option value so the distinction appears in the product's customer-facing options rather than only in SKU, barcode, price, or inventory.
4. Check blank option values
Multiple rows with the same handle and the same blank/default option values can also collide. Confirm that Option1 Name and Option1 Value are present where variant-dependent columns are used.
5. Be careful when reorganizing option columns
Changing Option1, Option2, or Option3 can recreate variant IDs and disrupt integrations that depend on those IDs. Test a small copy before overwriting an existing catalog.
6. Validate before re-importing
VariantSafe groups rows by handle and reports duplicate option combinations while allowing legitimate repeated handles.
What does not fix the problem
- Changing only the SKU or barcode while leaving the same option combination.
- Deleting every repeated handle.
- Moving values between option columns without reviewing the entire product.
- Assuming rows far apart in the CSV belong to different products when their handles match.
Check the repaired CSV before importing
VariantSafe reads the file locally in your browser and reports exact rows, columns, and safe automatic fixes.
Open the free CSV validatorRelated Shopify CSV guides
- Invalid CSV header: missing headers
- Illegal quoting or stray quote on line
- Options are not unique
- Image URL download error
- Price can’t be blank