Dead spares: how to clear slow-moving auto parts stock

Sort every spare by last-sold date into ageing buckets, then clear, return or hold each bucket. A practical guide for auto parts shops and distributors.

To clear slow-moving auto parts stock, first sort every part by the date it last sold, then put each part into an ageing bucket and give each bucket a fixed action: keep watching, push to sell, return to the vendor, or clear at a lower price. The date it last sold matters more than the date you bought it, because it shows whether anyone still wants the part. Once each bucket has its own rule, clearing becomes a routine job you can repeat every month.

Why do spares pile up on the top shelf?

Auto parts collect slow stock more than most trades. One part number fits one model, sometimes one variant within that model, and models get updated. A shop that stocked filters, brake pads and bearings for a car that sold well some years ago may find those parts stop moving as those cars come off the road.

There are other usual causes. A part gets ordered for a customer who never collects it. A distributor offers a scheme and the full case comes in when only two pieces were needed. A superseded part number comes in while the old one is still on the shelf. Each of these looks small. Spread across a few thousand part numbers, it adds up to a lot of money sitting on the top shelf.

How do I build ageing buckets by last-sold date?

Take your item list and, for every part number with stock on hand, record three things: quantity on hand, cost value, and the date it last sold. Then work out how many days it has been since that sale and group the parts.

The bucket boundaries below are a sensible starting point, not a rule. Pick boundaries that fit your trade. A shop selling fast service parts may need tighter buckets than a distributor holding body parts.

Bucket (days since last sale)	What it usually means	Default action
0–90	Moving normally	Hold. Manage with your reorder settings
91–180	Slowing down	Hold, but stop reordering. Check whether demand has moved to a newer part number
181–365	Slow-moving	Push to sell: offer to garages and fleet customers, bundle with fast movers
366–730	Dead in practice	Return to vendor where you can. Clear the rest at a lower price
Over 730, or never sold	Dead	Clear, sell in bulk to a stockist or scrap buyer, or write off with your accountant

Sort each bucket by cost value, highest first. Ten part numbers usually hold most of the money in a bucket, and those are where your time should go first.

What does "clear, return or hold" mean in practice?

Hold means the part stays on the shelf as it is, but you make a decision about it. For the 91–180 bucket, that decision is to stop automatic reordering. If your reorder point was set when the part sold well, it will keep buying stock nobody needs. Our guide to the reorder point formula explains how to set those numbers from recent sales, not old ones.

Return to vendor comes first for the older buckets because, where it is possible, you lose the least money that way. Make a list by supplier, with part number, quantity and the original bill reference, and raise it when you next meet the supplier or their sales representative. Whether a supplier will take a part back, and on what terms, depends on your arrangement with them, so check before you count on it.

Clear means turning the part into cash below its normal price. Some ways to do it:

Offer a priced list to the garages and mechanics you already supply. They often know which older vehicles are still running in your area.
Bundle a slow part with a fast one, such as an old-model gasket set with a commonly used oil.
Sell the lot to another stockist or a parts trader who deals in older models.
For parts with no realistic buyer, sell as scrap and record the write-off properly with your accountant.

Clearance pricing does not need to make a profit. The aim is to get cash back. Money still stuck in a part after two years earns nothing, and the shelf space has a cost of its own.

Can you show a worked example?

The numbers below are illustrative only.

A spares shop runs its ageing report and finds a 366–730 day bucket with 40 part numbers worth ₹2,40,000 at cost. Sorted by value, the top eight part numbers hold ₹1,60,000.

Three of those eight came from one distributor, worth ₹70,000. The owner raises a return request, and the distributor agrees to take back ₹45,000 against credit for future purchases.
Four are bearings and clutch parts for an older model. The owner sends a priced list to twelve garage customers and sells ₹35,000 worth at cost price over the next month.
One is a body panel worth ₹20,000 that nobody wants. It goes to a parts trader for ₹6,000.

From ₹1,60,000 stuck on the shelf, ₹86,000 has come back as cash or credit in one review cycle, and the shelf space is free for parts that sell. The remaining 32 part numbers, worth ₹80,000, get handled in the next cycle.

How do I stop parts sliding back into the dead buckets?

Clearing once is not much use if the same buying habits refill the shelf. A few controls help:

Review reorder settings for anything that moves into the 91–180 bucket. Lower the reorder point or remove it.
Link superseded part numbers. When a manufacturer replaces a part number, record the link so the old stock sells first and you do not reorder both.
Take an advance for special orders. A customer who has paid something is far more likely to collect the part.
Be careful with scheme buying. Work out how many months of stock the scheme quantity covers before you accept it.
Rotate by receipt date. Sell older stock of the same part first so it does not age behind newer receipts. Our post on FIFO, LIFO and FEFO covers the picking rules.

Distributors with several godowns should run the report per location. A part that is dead in one godown may be selling in another, and moving it between your own locations is cheaper than clearing it. The wholesale distributor inventory guide covers multi-location stock in more detail.

Common mistakes when clearing slow stock

Ageing by purchase date. Old stock that still sells ends up in the clearance list, and newer stock that never sold stays off it.
Using one cut-off for everything. A seasonal part such as a wiper blade or an AC component can sit unsold for months and still be healthy. Check last season's sales before you mark it dead.
Clearing at a price based on what you paid. The buyer does not care what the part cost you. Price it at what will sell.
Ignoring part numbers with low value. A part worth only a few hundred rupees still takes up a shelf slot and a line in every stock count.
Skipping the accounting step. Discounted sales and write-offs affect your books and may have tax effects. Ask your CA how to record them before you scrap anything.

When does this approach not apply?

Ageing by last-sold date assumes your sales records are reliable. If counter sales are often not billed or the part master has duplicates, clean the data first. Otherwise the report will show fast-moving parts as dead. The approach also needs adjusting for insurance and accident-repair stock, which may be held on purpose for rare but urgent jobs. Mark those parts as deliberate holds so they stay out of the clearance list.

FAQ

Should I age auto parts by purchase date or last-sold date? Use the last-sold date. A part bought two years ago that sold last week is still moving, while a part bought three months ago that has never sold may already be a problem. Purchase date tells you how old the stock is. Last-sold date tells you whether anyone still wants it.

What should I do with a part that has never sold at all? Put it in a separate never-sold group and age it from the receipt date. If the part came in for one customer's job that fell through, try that customer or a garage that services the same model first. If it was a speculative buy, treat it like your oldest bucket and act on it early.

How often should I re-run the ageing report? Monthly suits most auto parts shops, with a fuller review once a quarter. The monthly run catches parts sliding from one bucket into the next. The quarterly review is when you make the larger decisions, such as bulk clearance or delisting a part line, and correct reorder settings that keep refilling slow items.