Repair Shop Inventory Management: Best Practices

First, decide whether you should hold stock at all

Most inventory advice for repair shops assumes you want a stockroom. For a large share of shops — and the substantial majority of Egyptian ones — that assumption is wrong, and following the advice destroys working capital.

Holding stock costs cash that could be doing something else, and it costs obsolescence: phone parts are perishable in the sense that matters, because demand for a specific model's screen collapses once the model ages out. A shelf of screens for a phone nobody brings in any more is money that has quietly become furniture.

The alternative is to order per job: the customer approves the quote, you buy the part, you fit it. Slower by a day, but the cash stays in the business and nothing goes obsolete on your shelf.

If you order per job, keep a price book

The weakness of ordering per job is that you lose the price history a stock system would have given you. Without it, quoting drifts: staff guess, guess low, and margin quietly disappears on exactly the repairs the shop does most.

Record what you actually paid for each part on each job, and let the last paid price prefill the next time that part comes up. Within a few months a shop holding zero stock has a private price book covering everything it commonly fits — which is the useful half of what inventory management was supposed to provide.

If you do hold stock, derive quantity from movements

The common failure in stock tracking is a quantity field that staff edit directly. It starts accurate, someone corrects it by hand after a miscount, and from then on the number is an opinion.

Record movements instead — purchased, consumed on a job, sold, returned, adjusted — and derive on-hand as their sum. The quantity then always explains itself, and a discrepancy points at a specific missing or wrong movement rather than at nothing in particular.

• Every adjustment needs a reason recorded; unexplained adjustments hide both theft and process failure
• Count a small subset of high-value parts often, rather than everything once a year
• Keep serialized items — devices, boards — tracked individually with a condition and a status, not by count
• Keep the retail catalog separate from repair parts; they have different margins and different reporting

Set thresholds that reflect lead time, not tidiness

A low-stock threshold should be roughly what you expect to use during the time it takes to restock. If a screen takes two days to arrive and you fit about three a week, a threshold of one is too late and a threshold of ten is capital sitting on a shelf.

Thresholds should also be per branch. A part that is comfortably stocked at the main shop is not stocked at all at the second branch, and an alert averaged across both tells nobody anything useful.

Finally, alerts must deduplicate. An alert that repeats every day while stock is low is an alert everyone learns to dismiss, and the one that mattered gets dismissed along with it.

Deal with dead stock deliberately

Every shop that holds parts accumulates some that will never be fitted. The mistake is treating them as still being worth what they cost. They are worth what someone will pay today, which is usually much less and eventually nothing.

1. Review parts with no movement in six months, on a schedule rather than when you happen to notice
2. Sell them at a loss early rather than a bigger loss later — the value only falls
3. Trace each one back to why it was bought; the buying pattern that created it is still running
4. Write off what is genuinely worthless, so reported stock value stops being fantasy

Frequently asked questions

Should a repair shop hold parts in stock?

It depends on model concentration and working capital. Holding stock makes sense for shops doing high volume across a narrow range of models. For shops covering a wide model range or running on thin cash, ordering per job after the customer approves the quote is usually better: it ties up almost no capital and pushes obsolescence risk onto the wholesaler, at the cost of roughly a day's turnaround.

How do you protect margin without holding inventory?

Record the price actually paid for each part on each job, and have the system prefill the last paid price next time. Within a few months this builds a private price book covering the parts you commonly fit, which prevents the quote drift that erodes margin when staff are guessing.

How should on-hand stock quantity be tracked?

Derive it from the sum of recorded movements — purchases, consumption on jobs, sales, returns and adjustments — rather than storing an editable number. A derived quantity always explains itself, and a discrepancy points at a specific missing movement instead of being unexplainable.

What should a low-stock threshold be set to?

Approximately the quantity you expect to use during the restock lead time. If a part takes two days to arrive and you fit three a week, set the threshold around two — not one, which alerts too late, and not ten, which is capital sitting on a shelf. Set thresholds per branch, since stock levels differ by location.