Option columns out of order
Option2/Option3 has values while Option1 is blank.
What is this issue?
Option2/Option3 has values while Option1 is blank.
Option columns out of orderWhy Shopify rejects this
Shopify expects options to be filled sequentially (Option1 then Option2 then Option3).
Shopify-specific note
Shopify groups variant rows by the Handle column value. All rows sharing the same Handle belong to the same product. Option columns (Option1 Name, Option1 Value, etc.) must be consistent across every variant row in the group.
Examples
| Bad value | Good value | Note |
|---|---|---|
Option2 filled but Option1 blank | Option1 filled first, then Option2 | |
Variant row appears before its parent row | Parent row appears directly above variant rows |
Fix in StriveFormats
StriveFormats detects variant structure issues and highlights the rows that are misaligned or missing required option values.
Fix in Excel
- 1In Excel, sort your rows by the parent identifier column (Handle for Shopify, parent SKU for WooCommerce).
- 2Verify the parent row appears before all its variant rows in the sorted result.
- 3For WooCommerce: parent rows should have Type = 'variable'. Variation rows should have Type = 'variation' and the Parent column set to the parent's SKU.
- 4For Shopify: all rows in a product group must share the same Handle. Check that Option1 Name is filled before Option2 Name.
- 5Save as CSV (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, go to Data > Sort range and sort by the parent identifier column (Handle or Parent SKU).
- 2Verify parent rows appear directly before their variant rows.
- 3For WooCommerce: parent rows need Type = 'variable'. Variation rows need Type = 'variation' and Parent = the parent SKU.
- 4For Shopify: all variant rows in a product group must share the same Handle.
- 5Go to File > Download > Comma Separated Values (.csv).
Prevent it next time
- --Always keep parent product rows directly above all their variant rows.
- --For Shopify: use the same Handle value for all rows in one product group.
- --For WooCommerce: parent rows have Type = variable; child rows have Type = variation with Parent = parent SKU.
- --Test with a single product (one parent, two to three variants) before importing your full catalog.
How StriveFormats detects this
StriveFormats groups rows by their parent identifier (Handle for Shopify) and checks that the structure matches the platform's variant model. Orphaned variation rows, missing parent rows, and duplicate option combinations are each flagged separately.