← All guides
Auto aftermarket · July 21, 2026

Auto parts interchange and cross-reference numbers in QuickBooks

A single brake rotor can carry four different part numbers: the OEM's, an aftermarket maker's, an interchange cross-reference, and a supersession number after the original was discontinued. Your customers order in whichever one they happen to know. Your QuickBooks catalog knows exactly one of them, yours. Every emailed PO is a translation problem, and right now a person at the counter is solving it line by line.

Four numbering systems, one part

TypeWhat it isExample a buyer might send
OEMOriginal manufacturer's numberThe number stamped on the factory part
AftermarketAn alternate maker's equivalentA Wix, Bosch, or Dorman number for the same fit
InterchangeA cross-reference from one brand to anotherA competitor line the buyer's system spit out
SupersessionThe current replacement for a discontinued partAn old number that was superseded two revisions ago

All four point at the same shelf location in your warehouse. None of them is your SKU. When a fleet account emails a 20-line PO mixing OEM numbers, a couple of interchange numbers, and one part they've been ordering by its pre-supersession number since 2019, someone translates all 20 to your catalog before an Estimate exists.

Why this is the real bottleneck

Counter staff are fast because the translations live in their heads. That's also the problem: it's 9 to 14 minutes per PO of skilled work that doesn't scale, doesn't transfer when someone quits, and stalls the moment your best parts person takes a day off. The lookup catalog on their second monitor answers "what fits." It does nothing about the emailed order that's already sitting in the inbox in the customer's numbering, waiting to become a QuickBooks Estimate.

How cross-reference matching closes it

The fix isn't another catalog. It's a cross-reference that learns your customers' numbering and applies it automatically. SideQuest for auto parts distributors reads the PO email from Gmail and runs each line through a matching cascade: exact SKU first, then a learned cross-reference, then a fuzzy description match against your QuickBooks catalog. The first time a customer's interchange number or a superseded PN lands, your CSR assigns it to your SKU once. That mapping is saved. Every later PO from that customer with the same number matches the line at full confidence, and a note can flag on the draft when a buyer used a legacy or superseded number so nothing ships wrong.

The mechanism underneath is the same auto-learning cross-reference that powers the whole matcher, described in what a good PO match looks like. For auto parts it just happens to solve OEM-to-aftermarket and supersession translation as a side effect: they're all customer-part-to-your-SKU mappings.

What a mixed parts PO looks like going through it

A 20-line PO from a repair-shop account: twelve lines in OEM numbers you've mapped before (auto-match), four aftermarket numbers the fuzzy matcher catches from descriptions, two interchange numbers, and two parts ordered by a superseded PN. The twelve resolve instantly. The fuzzy and interchange lines come in flagged with your best-guess SKU for a one-click confirm. The two superseded lines resolve to your active SKU with a note. You approve, and QuickBooks has the Estimate before the parts are pulled. Next PO from that account, the interchange and superseded lines match clean too, because the first pass taught them.

What it doesn't do

SideQuest isn't a parts catalog and won't tell you what fits a 2019 Silverado. Keep your lookup tools. It works the intake side only: the emailed PO, the buyer's numbers, your QuickBooks catalog, a drafted Estimate you approve. Lookup and intake are different jobs; this is the second one.

FAQ

How do interchange numbers get matched to QuickBooks items?

A cross-reference maps each buyer part number to your SKU the first time you assign it, then applies it automatically on every later order from that customer.

OEM vs aftermarket vs interchange vs supersession?

OEM is the factory number, aftermarket an alternate maker's equivalent, interchange a brand-to-brand cross-reference, supersession the replacement for a discontinued part. One part can carry all four.

Does it replace my parts catalog?

No. Catalogs answer "what fits." SideQuest handles intake: turning the emailed PO's numbers into a matched QuickBooks Estimate. They run side by side.

Counter staff translating part numbers all day?

SideQuest reads emailed parts POs, learns your customers' OEM, aftermarket, interchange, and superseded numbers, and drafts the QuickBooks Estimate. Free for 25 POs a month.

Start free →