Finding Duplicate SKUs Before a Catalogue Import
Duplicate identifiers can turn a routine update into an ambiguous matching exercise. Find and resolve them before a bulk import, rather than letting the import decide which record wins.

Separate exact duplicates from formatting differences
Preserve the original identifier while checking spaces, letter case and leading zeros. Two visually similar values may be different identifiers, so do not normalise them without an agreed rule. Group duplicates and inspect the related products or variants to understand why they exist.
Practical checklist
- Keep the untouched source export.
- Check blank identifiers separately.
- List every record sharing an identifier.
- Approve corrections before applying them.
How to review the result
A matching rule is ready when every update either identifies one intended record or enters an exception queue. Ambiguous matches should never be silently accepted.