Shopify Product CSV variant grouping issues
What this means
Shopify groups product variants by shared product fields such as Handle and option columns. Sorting or editing the CSV can accidentally split variants, duplicate option combinations, or leave option values without matching option names.
Why it matters before Shopify import
Broken variant grouping can create unexpected products, missing variants, duplicate combinations, or imports that are difficult to repair after the fact.
How to fix it in the CSV
- Keep rows with the same
Handletogether. - Check
Option1 Name,Option1 Value, and any Option2 / Option3 columns. - Make sure each variant combination under the same handle is unique.
- Compare the sorted or edited CSV with the original Shopify export.
Example
| Handle | Option1 Name | Option1 Value | Variant SKU |
|---|---|---|---|
| linen-shirt | Size | Small | LINEN-S |
| linen-shirt | Size | Small | LINEN-S-2 |
In this example, the same product has duplicate option values. One row should usually use a different option value, or the duplicate row should be removed.