Auto parts inventory management: what the system must do
Auto parts inventory management means knowing which parts you hold, which bin each one sits in and where every unit went, in a trade where part numbers get replaced, one part is sold under several numbers, and the old part you take off a vehicle is worth money. A spare parts inventory management system that ignores those three things gets worked around in a notebook.
This guide covers both kinds of parts business: those where parts go out on jobs and work orders (repair shops, fleet and plant maintenance parts rooms) and those that sell over a counter or online. It explains how parts stock works, what a system must do about each piece of it, where a spreadsheet stops, and what to ask before you buy software.
Jump to: part numbers · supersessions · cores · reorder points · returns · spreadsheets · choosing software
Two kinds of parts business
Parts leave a stockroom on a job or on a sale: a repair order for a customer's car, a work order against your own truck or machine, or a counter or online sale. The mechanics below apply to all of them; what changes is what each movement points at.
| Repair shop | Fleet or maintenance parts room | Parts counter | Online parts seller | |
|---|---|---|---|---|
| Stock leaves on | A repair order | A work order on your own vehicle or machine | A counter sale or account invoice | A shipped order |
| Each issue must record | The job, so the part gets billed | The asset, so the cost lands on the right vehicle or machine | The customer and the price charged | The order, and the vehicle the part was sold to fit |
| The expensive mistake | A part fitted and never billed | A critical spare missing while a machine is down | Shelves filling with slow movers | Returns of parts listed for the wrong vehicle |
"Spare parts inventory" often means the second column: parts held to keep your own vehicles or equipment running, costed to an asset rather than sold.
If you sell parts, especially online, you also need fitment data: which vehicles each part fits. In North America that data moves through the supply chain in the Auto Care Association's ACES and PIES standards, ACES for fitment and PIES for product information. Fitment is catalogue work. A stock system tells you what you have and where; it does not tell you what fits a 2014 pickup.
Part numbers and your SKU
One physical part usually carries several numbers:
- The OE number (original equipment, often written OEM): the vehicle manufacturer's number, the one a dealer's parts counter uses.
- Aftermarket numbers: each brand that makes a replacement gives it its own number.
- Your SKU (stock-keeping unit): your own code for one item you stock.
Nothing stops two brands using the same digits for different parts, so the unique key is brand plus number. A common fix is a short brand prefix called a line code; ALLDATA's shop software, for example, documents line codes as three-character part-number prefixes.
Here is one stocked item with every number it needs (the numbers are made up):
| Field | Example | What it's for |
|---|---|---|
| SKU | FLT-0412 | Your key: never changes, never reused |
| Brand and part number | Brand A 57045 | What you order, receive and claim warranty against |
| OE number | OE 1234-567 | What the customer or the old box quotes |
| Cross-references | Brand B 8817, Brand C PF-77 | Equivalents you could fit instead |
| Old numbers | Brand A 57040 | Superseded numbers that should still find this item |
Pick one SKU rule and keep it: either the brand plus its number, which is readable at the counter, or an internal code with those numbers stored against it, which survives a change of brand. Mixing the two is how one part becomes three rows. Either way, search has to find the item from any number in that table, because people type whatever is printed on the box in their hand.
Supersessions: when a number is replaced
A supersession is a manufacturer retiring a part number and pointing it to a new one, usually after an engineering change, a new supplier or a tidy-up of the range. What matters for stock is direction:
- Two-way: old and new are fully interchangeable, often just new packaging. Stock under both numbers is one pool.
- One-way: the new part fits wherever the old one did, but not the reverse. Old stock can still go on vehicles built before the change, unless a recall or stop-sale notice says otherwise, so it can't simply be merged into the new number.
Supersessions also chain: A is replaced by B, then B by C. A customer reading A off an old box needs to land on C, and the person serving them needs to know whether the two Bs on the shelf can still go out.
So a parts system has to:
- Follow the chain from any old number to the current one in one search.
- Show old and new stock together, with the direction, so old stock goes first where that's allowed.
- Stop reordering the old number. Windward's System Five, for example, documents separate settings for whether a related part can be sold and whether it can be ordered.
- Carry the sales history forward to the new number.
- Relabel the bin: the new number on the label, the old one in small print until the old stock is gone.
The fourth is the easiest to miss. Reorder points come from past demand, and that demand sits under the old number:
| Number | Status | On hand | Sold in the last 12 months |
|---|---|---|---|
| 4410-A | Replaced by 4410-B, two-way | 3 | 22 |
| 4410-B | Current | 6 | 4 |
On its own history, 4410-B looks like a slow mover selling four a year. Its real demand is 26, and a reorder point set from 4 empties the shelf while customers are still asking for it. (The figures are an example.)
Interchange and cross-reference
Interchange, or cross-reference, links different numbers that do the same job: an aftermarket part against the OE number, or one brand's part against another's. Nothing is retired. Both numbers stay current, each with its own cost, price and warranty.
Much of the data comes from the brands: the PIES standard has an interchange segment in which a manufacturer links its part numbers to OE numbers and to similar aftermarket numbers. Treat a cross-reference as a strong lead, not a guarantee, and compare connectors, threads, mountings and flow or rotation direction before the part goes on.
For stock, a search by any number should show every equivalent you hold, with bin and quantity: Brand A is out, but there are two of Brand B in C-11. Keep the stock separate by brand, though. Equivalent is not identical, pooling hides which part was fitted and what it cost, and the warranty belongs to the brand that went on the job, so record that number.
Cores and core charges
A core is the used part you take off the vehicle, when that part can be rebuilt or recycled. California's Bureau of Automotive Repair describes a core charge as a deposit held for the return of the used part, and lists batteries, water pumps, alternators, brake master cylinders and air conditioning compressors among its examples. Core charges can apply to new parts as well as remanufactured (rebuilt) ones.
One core-charged part creates debts in both directions:
| Step | What moves | Who owes what |
|---|---|---|
| Buy a remanufactured alternator | The unit arrives | You owe the supplier the price plus the core charge |
| Fit it to a customer's car | The new unit goes out on the job; the old one comes off | The customer owes you the core charge, unless you keep the old unit |
| Put the old unit on the core shelf | It waits in a bin | The supplier will owe you a credit once you send it back |
| Send it back with a return authorisation (the supplier's approval number) | The core goes to the supplier | The credit is pending, not received |
| The supplier inspects it | Accepted, or rejected as damaged or incomplete | Credit issued, or the core charge becomes a cost |
The return and the credit are separate events, and money disappears between them: cores pile up in a corner, miss the supplier's return window, and the deposits are never recovered. So track three numbers per supplier: cores owed, cores waiting on the shelf, and credits claimed but not yet received. A core is never sellable stock, so it must not count as available or inflate your stock value.
Paperwork matters too. California's bureau says a core charge must be disclosed to the customer and itemised separately on the estimate. Check the rules where you operate.
Bins and shelf locations
A bin is the smallest place a part lives: a shelf position, a drawer, a box on a rack. Its code should say where to walk, and a common scheme is aisle, bay, shelf and position: B-04-2-C is aisle B, bay 4, shelf 2, position C. Label every bin with its code and the part it holds. Three rules keep bins honest:
- One home bin per part per location, plus any overflow the system knows about. "None in the home bin" and "none in the building" are different answers.
- The bin belongs to the location. The same part can sit in B-04-2 in the main store and in drawer 3 on a service van.
- Receiving isn't finished until the part is in its bin. A box on the receiving bench is in stock on paper and missing on the shelf.
Min/max and reorder points
A reorder point is the stock level that triggers an order. For steady sellers it is the usage you expect while waiting for a delivery, plus a buffer called safety stock: daily usage × lead time in days + safety stock, where lead time is the gap between ordering and delivery.
If you fit about 3 of one oil filter a day, the supplier takes 2 days and you keep 4 spare for a busy day, the reorder point is 3 × 2 + 4 = 10. The maximum, or "order up to" level, sizes each order: at 30, every order brings you back to about ten days' worth. That pair is what parts people mean by min/max. Parts break the formula in two places.
Slow movers. Many parts sell only a few times a year, and averages lie at that volume: a part sold 4 times a year averages a third of one a month, which rounds to nothing. Use a minimum of 0 and a maximum of 1: keep one, and reorder when it goes. Decide what to stock by how often a part is asked for, not how many units moved. One customer buying eight spark plugs is one request; eight customers buying one each is eight.
Dealer parts systems formalise this as phase-in and phase-out rules: stock a part once it has sold a set number of times in a period, and drop it when demand falls below a threshold. Each invoiced instance is called a hit, and one dealer system's documentation offers an option to count lost sales, the requests you couldn't fill, as hits. Record them: without lost sales, your history misses every customer who walked away. As an example of a common single test, a parts consultant writing in WardsAuto gives three months with sales within a nine- or twelve-month period.
Critical spares. In a maintenance parts room, some parts move once in two years and still belong on the shelf, like the hydraulic pump for your only loader. Their minimum comes from what a day of downtime costs, not from usage. Mark them critical, so nobody tidying the slow movers deletes them.
| Kind of part | Rule | Why |
|---|---|---|
| Fast mover, such as a common oil filter | Reorder point from usage × lead time + safety stock | Demand is steady enough to average |
| Slow mover, asked for a few times a year | Min 0, max 1, once it passes a phase-in rule | One on the shelf covers the next request |
| Critical spare | Min 1, whatever the usage | Running out costs downtime, not a sale |
| One-off | Special order per job | One request isn't demand |
Special orders for one job
A special order is a part you don't stock, bought for one job. One that nobody collects is among the quickest ways to make dead stock, so:
- Attach it to the job when you order it, not when it arrives.
- Treat it as reserved on arrival, not available. If it shows as free stock, someone fits it to another vehicle and the original customer waits again.
- Check the return terms first. Some suppliers refuse returns on special orders or charge a restocking fee, which decides whether you take a deposit.
- Set a chase date. If it hasn't been fitted or collected by then, return it while you still can, or move it into stock on purpose.
- Count repeats. The same part special-ordered three times in a few months is a candidate for the shelf, which is what a phase-in rule catches.
Returns to vendor and warranty returns
A return to vendor is a part going back unused: the wrong part, ordered in error, damaged in transit, or overstock. Suppliers usually want a return authorisation and set a return window. The part leaves your stock when it ships, but the money comes back later as a credit, so "returned" and "credited" are separate checks.
A warranty return starts with a fitted part that failed. The vehicle comes back, a replacement goes out on a warranty job, and the failed part is held for the supplier's claim, to be shipped back or scrapped on their say-so. Until the claim settles, it is in the building and worth nothing to you.
Both lead to the most useful idea in parts inventory: on hand is not the same as available.
| State | Can it go on a job or a sale? |
|---|---|
| Available | Yes |
| Reserved for a special order | Only that job |
| Waiting to go back to a supplier | No |
| Failed, held for a warranty claim | No |
| Core waiting to be returned | No |
All five sit on your shelves. A system that keeps one quantity per part mixes them, and tells a technician a part is in stock when the only one there is broken.
Dead stock and cycle counts
Dead stock is stock that hasn't moved in a long time, often taken as a year. In parts rooms it comes from superseded numbers nobody sold down, special orders nobody collected, parts for vehicles that have left local roads, and bulk buys made for a discount. Age stock by its last movement (under 6 months, 6 to 12, over 12) and review the oldest group every quarter: return it if your supplier accepts stock returns, sell it at a discount, or scrap it and record why.
Instead of one annual stocktake, cycle count by bin: count a few bins every day or week so each bin comes round several times a year, and count expensive and fast-moving parts more often. Three habits make the counts worth trusting:
- Count blind. The counter sees the bin and the part, not the quantity the system expects.
- Freeze the bin, or note the time. A part issued between counting and posting looks like a loss.
- Review variances (counted minus expected) before they post, and read them in pairs. Two extra in one bin and two missing from the next often means a part was put away in the wrong place, not stolen.
What a spreadsheet handles, and where it breaks
A well-built spreadsheet runs a small parts room for longer than most people expect, as long as it logs movements instead of storing a quantity: every receipt, issue, return and count is a new row, and stock on hand is calculated from the log. Our free inventory spreadsheet works that way. It records received, issued-to-job, sold, returned, adjusted, counted and transfer rows, works out stock for up to five locations, keeps a reorder list that counts open purchase orders as already on order, and has a stock count sheet. It has no bin column, so add one to the Items sheet if each part has a single home bin. Inventory management in Excel covers the structure and the general ways spreadsheets fail. For parts specifically:
| Parts job | In a spreadsheet | Where it breaks |
|---|---|---|
| Brand, OE, old and cross-reference numbers | One column each | A lookup searches one column, so finding a part by any of six numbers takes six lookups |
| Supersessions | A "replaced by" column | Each link in a chain is another lookup, and sales history stays under the old number |
| Cores | A separate item for each core | Cores owed and credits pending are balances with suppliers, not shelf counts |
| Bins | A bin column | Fine for one home bin; overflow and a different bin at each location don't fit one row per part |
| Special orders | A received row, then an issue row with the job number | Nothing stops the part going out on a different job first |
| Returns and warranty | A movement type and a note | Pending credits live somewhere else, and nothing reminds you |
A spreadsheet is enough while you have one location, a few hundred stocked parts and one person keeping it current, and while special orders, cores and warranty claims are rare enough to track on the job. Our template holds 500 items and 5,000 movements, which a busy parts room can fill within months.
Where parts stock should live
Start with the system you already run. Parts stock works best inside the software that holds the jobs, because that is where issues get attached to work. The examples below come from each vendor's own website, checked on 23 October 2026. They are illustrations, not recommendations, and we have not tested them.
| If you are | Look first at | Example |
|---|---|---|
| An independent repair shop | Your shop management software's inventory module | Tekmetric lists restocking suggestions against a minimum stocking level you set, search by bin number, and ordering through PartsTech and Nexpart |
| A fleet maintenance team | Your fleet maintenance software | Simply Fleet lists parts linked to work orders, batch tracking, several stockroom locations and reorder point notifications |
| A plant or facilities maintenance team | A CMMS (computerised maintenance management system) | Facilio lists automated stock checks and reservations, part requests from technicians' phones, and lot and expiry tracking |
| A dealership parts department | Your DMS (dealer management system) parts module | Autosoft DMS lists special orders created as the invoice is created, scan-and-return lists and warranty tracking |
| A parts store | Point-of-sale software built for parts | Windward System Five documents preceding, equivalent and superseding parts, with separate controls for selling and ordering |
Check fleet software closely: when we counted what 60 fleet management products document, only 14 covered parts inventory and purchasing.
A standalone inventory app fits when none of those does: a parts room with no system behind it, shop software with a stock module too thin to trust, or a seller who invoices from an accounting package.
We're building one of these ourselves: an inventory app that starts from your spreadsheet, in early access and not for sale yet. It is our product, so weigh it like any other. For a parts room, it issues stock to a job or customer, takes returns back from the job and shows what each job used and what it cost. It keeps a bin for each item at each location, records every stock change with who, when and why, lists items at their reorder point, drafts purchase orders in each supplier's pack sizes, handles partial deliveries, and runs stock counts by location or bin on a phone, with barcode scanning. You bring your sheet in as a CSV and can export items, stock and history as CSV at any time. It does not handle supersessions, interchange or cores, has no serial numbers or catalogue lookup, and does not connect to shop management software, a DMS or QuickBooks. Returns to vendor, warranty claims and special orders reserved for one job have no dedicated workflow yet either. If those are central to your parts room, it is not the right tool yet.
Questions to put to any parts system
- Can I find a part by its brand, OE, old or cross-referenced number in one search?
- Does a superseded number's sales history move to the new number, and can old stock be sold but not reordered?
- Does it track cores owed to each supplier, and credits not yet received?
- Can a special order be reserved for one job?
- Does it separate available stock from stock waiting to go back or held for a warranty claim?
- Can staff count blind, by bin, on a phone?
- Does it record lost sales?
- Can I export everything, including movement history, if I leave?