How to Match Supplier Products Without a Shared GTIN

The same industrial fitting appears as a manufacturer part number, a buyer code inherited from a 2011 ERP migration, a distributor SKU, and a free-text description. None of them is a GTIN. Product matching without GTIN is therefore not an exceptional workflow; for many industrial catalogs, it is the normal case.

The safe approach is to assemble multiple pieces of evidence, normalize them into comparable values, and make uncertainty explicit. No single weak field should be allowed to stand in for identity.

Understand what each identifier proves

Read GTIN vs MPN vs SKU before designing a rule that treats these identifiers as interchangeable.

A seven-step matching workflow

1. Preserve every source record and identifier

   Keep the raw supplier row, source file, supplier SKU, import time, and previous identifiers. Normalization should add comparable fields, not destroy the original evidence.

2. Resolve brand and manufacturer identity

   Map spelling variants, legal entities, house brands, and acquired brands to stable organization identities. An MPN comparison is unsafe if ABC, A.B.C. GmbH, and a distributor private label have not been resolved correctly.

3. Normalize part numbers carefully

   Compare case, whitespace, and punctuation-insensitive forms while retaining the original. Never remove characters blindly: a suffix can encode voltage, size, material, region, or revision.

4. Standardize units, dimensions, and packaging

   Convert comparable measurements to canonical units and separate product dimensions from pack dimensions. Distinguish each, inner, case, and pallet so a case of 12 is not merged with one item.

5. Extract category-specific specifications

   Thread, diameter, pressure, material, voltage, power, and compliance ratings are stronger evidence than generic words in a title. Define which fields establish identity for each product family.

6. Generate and score plausible candidates

   Retrieve candidates using several routes — manufacturer plus partial MPN, category plus dimensions, historical cross-reference, or normalized specifications — then score agreements and contradictions.

7. Apply decision bands and review ambiguity

   Auto-accept only high-confidence pairs with no identity-critical contradiction. Send the uncertain middle to a reviewer and reject weak candidates. Store the evidence and reason with the decision.

Evidence that becomes important when GTIN is absent

For a fastener, diameter, length, thread form, pitch, material, grade, finish, and package quantity jointly carry identity. For a motor, voltage, phase, power, frame, speed, and mounting matter. The evidence model must change by category.

Historical identifiers are particularly valuable. A superseded MPN, old buyer code, or supplier cross-reference can connect records that appear unrelated today. Preserve those aliases in a canonical product record instead of overwriting them with the latest value.

Separate sameness from relatedness

Matching systems frequently damage catalogs by treating every useful relationship as a merge.

This is entity resolution: deciding what real-world entity a record refers to and what relationship connects it to other entities, rather than merely finding similar strings.

Validate the process

Create labeled examples by supplier and category, then track precision, recall, false-merge rate, review rate, and “no candidate found” rate. Sample auto-accepted decisions continuously. A supplier feed can change column semantics or packaging conventions without warning, so last month’s safe threshold may not remain safe.

Write accepted links back with the supplier identifier, canonical product identifier, decision status, confidence, evidence, and rule or model version. That audit trail makes later correction possible without losing source history.

Related resources

FAQ