The dangerous column combinations
These combinations are the ones that delete variants:
Common Scenarios:
- Variant SKU filled but Option1 Name and Option1 Value both empty.
- Variant Grams (weight) filled without option columns.
- A mix where some rows have options and others do not - the optionless rows get rebuilt.
Catch the data-loss combo before it runs
ShopTools' validator checks every row for the variant-deleting combination - SKU or Weight without option pairs - and reports it before you upload.
Features:
- Variant-delete detection: Flags SKU/Weight rows missing option pairs
- Option pair validation: Confirms Name and Value are always filled together
- Pre-import safety: Runs the check Shopify itself does not warn about