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
Find and fix in four steps
- Sort your CSV by the Variant SKU column and look for repeated values.
- For each duplicate, decide whether it is a different variant of the same product or a different product entirely.
- Rename with a meaningful suffix - size or color - instead of random digits.
- Re-validate the file before uploading to Shopify.
Before and after
- Before: SKU-100 (Size L), SKU-100 (Size M), SKU-100 (Size S) After: SKU-100-L, SKU-100-M, SKU-100-S
- Before: Import error: SKU already exists - row 147 After: Import success: 3 variants under one product
When this bites
- Stores with inventory sync: Duplicate SKUs corrupt stock levels
- Anyone importing supplier CSVs: Supplier files are the most common source of duplicates
Frequently Asked Questions (FAQ)
- Can two variants of the same product share a SKU?
- No. Every variant needs a unique SKU. Size or color suffixes are the cleanest way to differentiate them.
- What if the SKU is empty?
- Shopify allows empty SKUs but you lose inventory tracking and feed listings. Generate one for every variant.
- Does a duplicate SKU really break my import?
- Yes - Shopify rejects the file. Fixing duplicates before upload saves a failed import cycle.
- How does ShopTools fix duplicates?
- The repair pass detects repeated SKUs and appends a readable suffix to every occurrence after the first.