How duplicates get into your file
Duplicate SKUs rarely start as typos. They usually come from one of these:
Common Scenarios:
- Copied rows: a supplier CSV where variant rows were duplicated and the SKU copied with them.
- Imported from another platform: Amazon or Etsy exports reuse the same item code across listings.
- Generated SKUs colliding: a generator that ignores color or size and produces the same code for two variants.
Let the validator find them for you
ShopTools' validator scans every row and flags duplicate SKUs - both within one product and across products - and the repair pass appends a readable suffix automatically.
Features:
- Duplicate detection: Flags repeated SKUs across the whole file
- Auto-suffix repair: Appends -1, -2 or size-based suffixes to keep codes readable
- Pre-import check: Runs the same uniqueness rule Shopify enforces