Duplicate SKUs in Shopify: why they happen and how to find them
Last updated: 31 July 2026
A SKU is your internal identifier for a specific sellable variant. Shopify treats it as a free-text field and does not enforce uniqueness — you can save the same SKU on a hundred variants and Shopify will not object.
Why duplicates are a real problem
The damage shows up downstream, which is why duplicates often go unnoticed for months:
- Third-party systems — 3PLs, ERPs, accounting and shipping tools — usually key on SKU. Two variants sharing one SKU means those systems cannot tell them apart.
- Inventory sync tools may write a stock level intended for one variant onto another.
- Pick-and-pack errors: a warehouse scanning a SKU has no way to know which of the two variants was ordered.
- Reporting silently merges two products into one line, so your bestseller data is wrong.
How duplicates get created
- Duplicating an existing product to create a similar one — Shopify copies the SKUs along with everything else.
- CSV imports where the SKU column was left as a placeholder or copied down a spreadsheet.
- Manual entry where a pattern like SHIRT-BLU was used for several sizes instead of a per-variant value.
- Merging catalogs from two stores or suppliers that each had their own numbering.
Finding them
This is genuinely hard by hand because a duplicate is a relationship between two variants, not a property of one. Nothing in the Shopify admin surfaces it — you cannot spot it by looking at a product, only by comparing every variant against every other. A CSV export plus a spreadsheet pivot works, and is what most people end up doing.
How Catamend handles it
The duplicate_variant_sku rule groups every variant in your catalog by SKU and reports each group with more than one member, so you see the duplicates as pairs or clusters rather than as a list of individual products.
It is deliberately not auto-fixable. Which of two variants should keep the SKU, and what the other should become, depends on your numbering scheme and on what your warehouse and ERP already reference — a tool guessing at that would create a worse problem than the one it solved. Catamend finds them and shows you the groups; you decide the renumbering.
Catamend also flags variants with no SKU at all (missing_variant_sku), which causes the same downstream problems in a quieter way.
Check your own catalog
Catamend scans every product and variant against 23 checks like this one, ranks what it finds by impact, and applies the safe fixes in one click with a full before-and-after history. Install Catamend from the Shopify App Store.