Services · Streamline & Outsource

Item master data deduplication

Get each product down to one record in NetSuite. We match on manufacturer codes, supplier references and barcodes rather than names alone, then consolidate carefully so you end up with a single, clean set of item master data – stock, costing and open demand all carried across safely.

One record per productStock and costing protected
The problem

Duplicate item records hide stock and distort purchasing and forecasting

When the same product sits under two codes, odd things start happening: availability checks miss half the stock, purchasing reorders what’s already on the shelf and demand history splits in two, so forecasts are built on half the picture. Item deduplication is the most demanding of the master-data passes, and it’s worth being clear about why. Matching is complicated by variants and units of measure, merging is complicated by stock, costing and open documents, and getting either wrong costs real money – so the work is planned pair by pair and done carefully.

What we run

How we de-duplicate item master data in NetSuite

Senior consultants oversee the work, and you can see progress as it happens. Approvals and decisions stay with your team.

  • Multi-signal matchingWe combine names, manufacturer codes, supplier references, barcodes and dimensional data, so same-product pairs surface even where naming is inconsistent.
  • Variants told apart from duplicatesSize, grade and pack variants are legitimate separate SKUs, not duplicates. The scoring flags each borderline case and your product owners make the ruling.
  • Stock-and-demand evidenceWe assemble each pair’s on-hand stock, open orders, open POs and costing state before anything moves, so the consolidation plan rests on facts.
  • Consolidation in the right orderOpen documents are redirected and stock is repositioned before the merge or inactivate-and-map runs, because the order of operations is what protects costing.
  • Forecasting repairedDemand history is mapped to the surviving records, so planning sees each product’s full demand signal rather than two halves.
  • New duplicates preventedWe recommend item-creation gates and naming rules, so fewer new duplicate items are created in NetSuite after the cleanup.

Item list full of near-duplicates?

We deduplicate the item master without breaking history. Talk it through with a senior consultant. It’s free, it takes 30 minutes and there’s no sales pitch.

The payoff

What handing it over buys you

Stock and demand sit on one record

Each item is in one place, so the system stops showing shortages while stock is on the shelf.

Purchasing avoids buying the same stock twice

Consolidated visibility prevents reordering what is already in the warehouse.

Forecasts use the full demand history

Mapped demand history gives planning one complete signal per product.

The catalogue is clearer

One code per product means sales quotes the same item everyone else picks.

How handover works

How the de-duplication lands

  1. Detect & score – multi-signal matching passes run first, with variant rulings agreed with product owners.

  2. Plan per pair – stock, demand and costing evidence is assembled for every candidate pair.

  3. Consolidate in sequence – open documents are redirected, stock is repositioned and then the governed merge runs.

  4. Prevent new duplicates – creation gates and naming rules stop new duplicates forming.

Good to know

What to know before you hand it over

  • !Costing effects are assessed before any consolidation. Consolidating items with different costing states moves numbers that finance owns, so the sequenced plan and finance sign-off come before anything else.
  • !Open transactions slow some consolidations. Items live in open orders, POs and works orders, so some consolidations wait for documents to clear or need redirection first. The plan states which applies, pair by pair.
  • !Variant rulings belong to product owners. Whether two records are one product is sometimes a product question, and each case is flagged to whoever owns the range.
Straight answers

Item Master De-Duplication FAQs

How do you find duplicates with completely different names?
Matching focuses on structural attributes rather than product descriptions: manufacturer part numbers, supplier codes, barcodes and physical dimensions. For example, two records labelled ‘Widget 50mm Galv’ and ‘WDG-50 Galvanised’ appear completely different as text, but matching barcodes and part numbers confirm they are identical. Because names are the least reliable signal in an item master, they are given the lowest weight in the algorithm.
What happens to stock on the losing record?
It moves across before the records are consolidated. Stock is repositioned under controlled steps as part of the sequenced plan, with each movement logged, so the on-hand position stays accurate at every point and nothing goes missing between the two records. Counts before and after confirm the totals match.
Is merge always the answer?
No, and that’s a deliberate choice. A full merge suits clean pairs, but where a record carries heavy open history, it’s often safer to inactivate it and map everything to the survivor instead. The evidence pack recommends an approach for each pair, and where one product supersedes another, NetSuite’s substitute item feature handles the handover.

Last reviewed: 21 October 2026 · Written by the Suite Generation team

Ready to hand this one over?

Tell us what you need and the problems you’re seeing, and we’ll scope the work.

Scoping Call — Sitewide

We reply within 24 hours.

or email hello@suitegeneration.net

Suite Generation is an independent, senior-led NetSuite consultancy. Every project is designed and delivered by consultants at or close to solution-architect level. We don’t resell licences or carry partner targets. Our advice is ours, whether you’re implementing NetSuite, rescuing a stalled project or fixing a system that never delivered.

Independent – no licence resellingSenior-led – solution-architect levelTrusted to fix failed implementations
Talk to a solution architect