A single injector may appear under several numbers across OEM catalogues, manufacturer documentation and aftermarket supplier databases.
If these references are stored without identifying their purpose, purchasing and warehouse teams can easily confuse different products.
Establish a Reference Hierarchy
A useful inventory record should separate:
These fields should not be merged into one general product-number column.
Preserve the Replacement History
When a manufacturer changes a reference, retain the original number and the documented replacement number.
Record the source confirming the relationship and any application limitations.
Why This Helps Distributors
A structured record makes it easier to:
Search older customer references.
Compare supplier quotations.
Identify stock under revised numbers.
Investigate incorrect deliveries.
Maintain accurate purchasing history.
The objective is not to collect as many cross-references as possible.
It is to maintain a clear and traceable relationship between each reference and the actual injector it identifies.
A Practical Database Rule
Use one primary inventory record for each controlled product, and store OE numbers, manufacturer numbers, supplier codes and supersession links in labelled fields. A supersession record should include direction, source, revision and applicability rather than a simple unlabeled “equals” sign.
When a cross-reference is withdrawn or corrected, preserve its history and flag affected stock or past quotations for review. This keeps an audit trail without incorrectly merging different injectors.
