The most common mistakes
Adding variants by CSV fails for a few predictable reasons:
Common Scenarios:
- Using a different Handle for the new variant rows, which creates separate products instead of variants.
- Leaving Option1 Name or Option1 Value empty, which makes Shopify skip the row.
- Reusing an existing SKU and getting the SKU Already Exists error.
- Changing the parent row Title or Body and accidentally overwriting existing data.
Keep existing variants safe while adding new ones
ShopTools checks that variant rows share the parent Handle, have option pairs filled, use unique SKUs and do not overwrite required parent fields. Validate before import so the file adds variants instead of breaking the product.
Features:
- Handle match check: Confirms variant rows belong to the right parent
- Option pair validation: Flags rows missing Option Name or Value
- SKU uniqueness: Prevents duplicate SKUs across old and new variants