The same supplier, under four names

Grainger shows up four times, across three ERP systems, as one company. It’s the clearest example of a problem buried in almost every vendor master: your real suppliers are hiding behind their own variant names.

Here’s a pattern we see in nearly every vendor file we load. One well-known supplier — take Grainger, the industrial and MRO distributor almost every company buys from — appears not once but several times:

• W.W. Grainger Inc — in SAP, $3.8M
• Grainger Industrial Supply — in Oracle, $2.5M
• WW Grainger — in JD Edwards, $1.6M
• Grainger — a second Oracle record, $697K

Four records. Three systems. One company. $8.5M of spend that, on your reports, looks like four unremarkable mid-size relationships instead of one supplier worth a conversation.

Why this happens — and why it stays hidden

Duplicates aren’t a sign of a sloppy team. They’re the natural result of how vendor data gets created: different buyers set up the same supplier at different times, business units run their own ERP instances, acquisitions bring their own vendor masters, and nobody ever reconciles the names. “Inc” versus “LLC,” abbreviations, a division name instead of the parent — each one spawns a new record.

It stays hidden because every report you run inherits the split. Sort your vendors by spend and the four Graingers sit in four different places, each too small to notice. The duplication is invisible precisely where you’d look for it.

Your biggest supplier can hide in plain sight, split across four rows that each look ordinary.

What dedup actually buys you

Rolling variant names into one true supplier isn’t a data-hygiene nicety. It changes the numbers you make decisions on:

• Your counts get real. “How many vendors do we have” stops being inflated by duplicates.
• Your leverage appears. That $8.5M is one negotiation, not four — and one master agreement can cover all three ERP entities.
• Your risk gets visible. Concentration you couldn’t see because it was spread across names comes into focus.

SpendAware matches variant names across SAP, Oracle, JD Edwards and more, ranks the worst offenders, and rolls each group into a single supplier — so the first time you open the duplicate report, you find out which supplier you’re really biggest with. Often it’s not the one you’d have named.