Definition
Part number cross-referenceA record pairing two identifiers for one item, or for two interchangeable items. A list of these pairs is a cross-reference table, or an interchange list when it covers other brands.
Types of part number cross-reference
Most distributors work with several kinds at once.
| Type | What it links | Usually kept in |
|---|---|---|
| Customer cross-reference | A customer’s own part number to your SKU | The ERP’s customer item table, spreadsheets, reps’ memory |
| Manufacturer cross-reference | The manufacturer’s part number to your article number | Your item master or product data |
| Competitor cross-reference (interchange) | Another brand’s part number to your equivalent | Manufacturers’ charts and lookup tools, supplier interchange lists, your own tables |
| Supersession | A discontinued part number to its replacement | Manufacturer notices, your item master |
What is a competitor cross-reference?
A competitor cross-reference maps another brand’s part numbers to the equivalent products in your range. Manufacturers publish them to win buyers over from rival brands. Wholesalers build their own too, because customers name the brand they bought last time rather than the one the wholesaler carries.
An equivalent is not always identical. Good lists separate direct replacements from nearest equivalents, and the rep still checks size, material, finish, rating class, required approvals and pack size. If the customer chose the brand on purpose, ask before substituting.
Why do distributors need part number cross-references?
Enquiries seldom arrive in your article numbers. Buyers paste codes from their own purchasing system, contractors write a competitor’s code, consultants’ schedules list manufacturer numbers. Every such line needs a cross-reference before it can be priced, and the lists that hold them are usually incomplete, so code-heavy enquiries wait for the one rep who knows the account. It is the step any quote automation has to get right. The customer’s side is covered under customer part number.
How to cross-reference a part number
- Work out whose number it is: the customer’s, a manufacturer’s or a competitor’s. Prefix and wording (“our ref”, a brand name) usually tell you.
- Look it up in the matching list: the customer cross-reference, your product data, or a competitor chart or supplier interchange list.
- Check it has not been superseded: an old number may point to a discontinued item; quote the replacement and say so.
- Match on specification when no list has it: size, material, standard, rating class, finish.
- Check the equivalent against the line and tell the customer about any difference.
- Record the pair for the next enquiry.
Example: four codes in one enquiry
An industrial supplies distributor gets a short enquiry by email.
Email from a maintenance buyer
- MT-20784 x 30 (our part no.)
- FLX 6510-10 filter element x 4
- 70-2215-08 hose fitting x 16
- ZT-118 adaptor x 4
| Customer wrote | Kind | Proposed product | Score | Based on |
|---|---|---|---|---|
| MT-20784 | Customer’s own | 3318420 Push-in fitting 8 mm x G1/4, nickel-plated brass | 97 | Pair learned from an earlier quote |
| FLX 6510-10 | Competitor’s | 5206510 Hydraulic return filter element, 10 µm | 90 | Your supplier interchange list maps it to your element |
| 70-2215-08 | Manufacturer’s | 2812208 Hose fitting JIC 37° female 1/2" | 95 | Manufacturer number in your product data |
| ZT-118 | Not recognised | Placeholder code | 0 | In no list and too little on the line; marked for the rep |
Illustrative example: the codes, products and scores are invented. Lines scoring under 80 are marked for review.
How ERP Agent uses cross-references when quoting
ERP Agent identifies the right products in your own catalogue from what the customer wrote: their own part numbers, manufacturer numbers, competitor codes or a plain description. Competitor codes are mapped from cross-reference data set up for your company, such as supplier interchange lists or pairs in your past quotes. The agent learns the pairs your team sends.
Every line shows the customer’s original next to the proposed product, with a match score from 0 to 100; lines under 80 are marked. By default, a person approves before the quote or order lands in your ERP, CRM or other system. More on customer and competitor part number cross-reference.
Built on your own equivalences
ERP Agent works from the cross-reference lists, supplier interchange data and past quotes you already have, so every equivalent it proposes is a product you want to sell. A code that is in no list is identified from the rest of the line, and a line it cannot place goes on your placeholder code for review instead of being guessed.
