Ways the pair gets broken
The mismatch usually enters the file in these patterns:
Common Scenarios:
- A row where Option1 Name is filled but Option1 Value is empty - the most common case.
- A parent product row that carries Option names but no values.
- A supplier file with Option columns that only partially match the Shopify header names.
Catch the blank cells before Shopify does
ShopTools validates the option-name/value pairs across every row and flags the exact cells that will trigger this error - so you fix the blanks instead of the symptoms.
Features:
- Option pair validation: Checks Name/Value pairs across all rows
- Row-level reporting: Points to the exact row and cell that is broken
- Repair suggestion: Fills values from sibling rows where the pattern is clear
Fix in three passes
- Filter every row that has an Option Name without a matching Value.
- Fill the missing values - or if the row is a parent, leave both empty.
- Verify the file with a validator before re-uploading.
Before and after
- Before: Option1 Name: Size, Option1 Value: (empty) After: Option1 Name: Size, Option1 Value: L
- Before: Error: Variant option is missing (whole file rejected) After: Import success: 3 size variants
Who sees this error
- Stores with many variants: More variant rows means more chances for a blank cell
- Supplier and migration files: External files frequently drop option values
Frequently Asked Questions (FAQ)
- What exactly is a variant option?
- An attribute-value pair that defines a variant - Color: Red, Size: L. Both halves must be present for Shopify to build the variant.
- Can I import a product without options?
- Yes - but then Option1 Name and Option1 Value must both be empty. A half-filled pair triggers the error.
- Why does one bad row reject everything?
- Shopify imports the file as a batch. Any row that fails validation blocks the whole upload.
- How do I find the broken row quickly?
- Filter for rows where Option1 Name is filled but Option1 Value is empty, or use a validator that reports the row number.