Structure mistakes we see most
These are the patterns that quietly explode one product into many:
Common Scenarios:
- Handle with trailing spaces or different casing between rows (T-Shirt vs t-shirt).
- Variant rows that omit the Handle entirely, relying on Title matching that never happens.
- Option columns filled inconsistently - some rows use Option1, others skip to Option2.
- Blank Handle on every row when the file should have a generated handle from Title.
Check the structure before Shopify splits it
ShopTools' validator groups rows by Handle, reports rows that break the group, and repairs common structure damage like casing and trailing spaces.
Features:
- Handle consistency check: Flags casing, spacing and missing-handle rows
- Option alignment: Detects rows using different Option columns for the same attribute
- Auto-normalize: Repairs trailing spaces and case inconsistencies