“Validation failed: options are not unique”: duplicate variants in a Shopify CSV

What the message means

Every variant of a Shopify product must have a unique combination of option values. If two rows with the same URL handle both say Color = Ivory and Size = 45 × 45 cm, Shopify can’t tell them apart. The help center lists two causes: duplicate option values on variants, or duplicate product handles.

How duplicates sneak in

• The supplier lists the same item twice, for example once per carton size or once in two price columns.
• An option that exists in the supplier file is missing from the CSV. Two variants that differ only by material look identical if Material isn’t imported as an option.
• Two different products share one handle, often because handles were generated from shortened titles.
• Values that differ only by spacing or case (Blue and blue ) are easy to miss in a spreadsheet; clean them up so each variant is clearly distinct.

Broken: the second row repeats the first variant.

URL handle,Title,Option1 name,Option1 value,Option2 name,Option2 value,SKU,Price
linen-cushion-cover,Linen Cushion Cover,Color,Ivory,Size,45 × 45 cm,CUS-IV-45,32.00
linen-cushion-cover,,,Ivory,,45 × 45 cm,CUS-IV-45B,32.00

Fixed: either delete the duplicate row or add the option that really distinguishes it.

URL handle,Title,Option1 name,Option1 value,Option2 name,Option2 value,Option3 name,Option3 value,SKU,Price
linen-cushion-cover,Linen Cushion Cover,Color,Ivory,Size,45 × 45 cm,Fill,Cover only,CUS-IV-45,32.00
linen-cushion-cover,,,Ivory,,45 × 45 cm,,With insert,CUS-IV-45B,39.00

How to fix it

1. Sort the file by URL handle, then by the option value columns.
2. Look for neighboring rows with identical values in every option column.
3. Delete true duplicates. If they are really different items, add or correct the option that tells them apart (Shopify allows up to three options).
4. If two different products share a handle, give one of them its own handle and move its title to its first row.
5. Import again. Run the file through the free Shopify CSV checker before you import again.

Catch it before importing

The free Shopify CSV checker flags repeated variant combinations (same handle and option values) and duplicate SKUs. When you build the file from a supplier catalog with Sheet2Store, duplicate products and variant combinations are flagged in the review table and must be fixed or excluded before the export unlocks.