Home  /  Case Studies  /  Auto-Parts Inventory
Case study · AutoCount

Stock counts you can trust — straight off the scanner.

A regional auto-parts distributor was running inventory on a spreadsheet that was always days behind the shelf. We replaced it with AutoCount: scan-in, scan-out, live counts and low-stock alerts at the counter.

Client: A regional auto-parts distributor (name withheld by request) Industry: Automotive parts · wholesale & counter retail Product: AutoCount, branded & deployed
Live
counts update the moment a part is scanned in or out — no end-of-day reconciliation
1
source of truth for stock, shared across the counter instead of a file one person edits
Auto
low-stock alerts fire before fast movers hit zero, instead of being noticed too late

The problem

The distributor moves thousands of SKUs across a busy counter and a back warehouse. Inventory lived in a spreadsheet — updated by hand, usually at the end of a shift, and only by whoever remembered. By the time a count was typed in, the shelf had already moved on.

That gap costs money in two directions at once. Fast-moving parts hit zero without warning, so a customer at the counter got "we'll have to order that in" — and often went down the road instead. Meanwhile slow movers quietly piled up in the back, tying up cash in stock nobody was tracking. Nobody trusted the number in the spreadsheet, so staff walked the aisles to check — which is exactly the manual work the spreadsheet was supposed to remove.

These are the classic inventory mistakes: no real-time count, no reorder trigger, and a single fragile file standing in for a system.

What we built

AutoCount, deployed for the counter

Barcode scan-in / scan-out

Parts are scanned as they arrive and as they sell. The count changes at the moment stock moves — not hours later when someone updates a file.

Live counts, fast lookups

Staff at the counter can look up any part and see a number they can trust, instantly — no walking the aisle to double-check.

Low-stock alerts

When a fast mover drops below its threshold, AutoCount flags it — so reordering happens before the shelf is empty, not after a lost sale.

One shared source of truth

Everyone reads and writes the same live inventory instead of passing around a spreadsheet that only one person can safely edit.

Built for the parts counter

The workflow is shaped around how a parts business actually runs — quick scans, quick lookups, minimal typing during a rush.

Their brand, their data

Deployed under the distributor's brand, with the inventory data theirs to keep — a system they own, not a subscription that owns their stock.

AutoCount — barcode-driven inventory with live counts, as deployed for the auto-parts distributor (shown here with demo data)
AutoCount — barcode scan-in/scan-out with live counts and low-stock alerts, the same product we deployed for the distributor, shown here with demo data. Try the live demo ↗

The outcome

The core change is trust: the number on the screen now matches the shelf, because it updates the instant a part is scanned. That single shift removes the guesswork behind every other decision — what to reorder, what's overstocked, whether to promise a customer a part is in.

Low-stock alerts turn reordering from a reactive scramble into a routine: fast movers get topped up before they run out, so the counter says "yes, we have it" more often. And because everyone works from the same live count, staff stop walking the aisles to verify a spreadsheet they didn't believe.

What we won't claim: we're not publishing the distributor's stock value, sales or shrinkage figures — those are theirs, and this write-up is anonymized at their request. The honest, structural win is that a fragile end-of-day spreadsheet became a live system the whole counter can trust.

Still running inventory on a spreadsheet?

Book a free 15-minute strategy call. We'll look at how you track stock today and show you what a live, barcode-driven system would change — honestly, including whether it's worth it yet.