Duplicate SKUs are quietly destroying your inventory reports
How duplicate and inconsistent item records create phantom shortages and overages, and the cleanup process that removes them for good.
Published 2026-03-18 · 5 min read
The phantom variance
When the same product exists under three codes, stock gets received against one and issued against another. One code shows an impossible shortage, another an unexplained overage, and the net is roughly zero.
Teams then spend days investigating a variance that never physically happened.
What a cleanup actually involves
Matching near-identical records across name, pack size, barcode and supplier code, choosing a surviving master, and logging every merge so history stays traceable.
- Normalise names to one convention
- Verify units of measure and conversion factors
- Merge duplicates with a full audit log
- Rebuild categories around how you buy and sell
Do it before the count, not after
Cleaning first means counters record against one correct code, and the variance register reflects real differences rather than data noise.
Need this done properly?
Book a free assessment and get a tailored count plan.