You're forty minutes into a job, you reach into the bin on the truck for the part you were sure you had, and it isn't there. A coupling, a furnace filter, a box of the right screws, whatever it is. Now you're wiping your hands and doing the math on a run to the supply house.
Problem is, that trip costs you more than the part. Half an hour there, half an hour back, and the customer watching the clock the whole time. Some days you eat it. Other days it pushes the job to tomorrow, and tomorrow's already full.
The parts you run out of are almost never a real surprise once you look. You buy them over and over. The trouble is the pattern lives scattered across a year of invoices and crumpled receipts, and nobody has time to add it all up by hand. That's one job AI is genuinely good at, so let's put it to work.
Start with what you already bought
You don't need a fancy inventory system for this. You need a year of what you already spent, and most of it is sitting in a few places right now.
Pull together whatever shows what you bought and when. The more complete it is, the sharper the pattern comes out.
- Supplier invoices and monthly statements (your plumbing wholesaler, electrical supply, lumber yard, parts store)
- Credit card or bank statements that show the vendor and the amount
- Online purchase history (Home Depot Pro, Amazon Business, your distributor's portal)
- Handwritten receipts from the glovebox, if that's where they live
Export what you can to a spreadsheet, or just drop the PDFs and phone photos into one folder. If an invoice lists line items (part, quantity, price), that's gold, because AI can read those and group them. If all you've got is a total and a vendor name, it still helps, just with less detail.
Let AI find what you buy most, and how fast
Once it's all in one place, you hand it to an AI tool and ask plain questions. Nothing fancy. You want to know what shows up again and again, and how quickly you go through it.
This kind of prompt does the job:
Here are my supplier invoices for the last twelve months. List the parts and materials I bought most often, how many times I bought each one, the total quantity, and roughly how many weeks pass between orders. Sort by how often I reorder.
What comes back is something you can actually read. The half-inch fittings you grab every couple of weeks. The filters you stock up on every fall. The odd specialty item you only buy twice a year, which is worth knowing too, because that's the one you always forget.
Ask follow-ups while you're at it. Which parts did I buy in winter but not summer? Did my fastener spend jump this year? What did I buy once and might be forgetting to restock? The tool is happy to slice it however you ask.
Build a reorder list with rough par levels
A pattern is useful. A short list taped inside the van door is better. So turn the findings into a simple reorder sheet.
For each part you buy regularly, set a par level, the number you want on hand before you'd call yourself low and reorder. You already have a gut feel for this. AI just hands you a starting number based on how fast you actually burn through the thing.
- Take the parts you reorder most often, straight off the list.
- For each one, look at how fast you go through it (the tool estimated this from your buy dates).
- Set a par level a little above what you'd use between supply runs, so a busy week doesn't leave you short.
- Write it as a plain checklist: part, par level, where you buy it.
- Keep it to the fifteen or twenty things you truly run out of. A list of two hundred items never gets checked.
Then check it once a week. Same time every week works best, Friday afternoon or Sunday night, whatever sticks. You glance down the list, see what's below par, and order it before Monday. Figure fifteen minutes.
What AI can't do here (worth being straight about)
Now the honest limit, and it's a big one. AI is reading your invoices, not your truck. It knows what you bought. It has no idea what's physically on the shelf or in the bin this minute.
So this gives you your buying patterns, not your live stock. If you used three of something on a job yesterday and didn't write it down, the AI can't know. It can tell you that you tend to reorder brake pads every three weeks. It can't tell you there are two left in the door panel.
Which means the walk-around is still your job. The weekly check is you putting eyes on the bins, list in hand, confirming what's really there. AI narrows two hundred line items down to the fifteen worth looking at and gives you a sane par number for each. You still do the looking. Anyone selling you 'automatic inventory' from a stack of receipts is selling you something that doesn't exist.
One more caveat. Estimates are estimates. A tool reading a year of spotty receipts will guess wrong now and then, especially on the stuff you buy rarely. Treat the numbers as a strong first draft and adjust as the weeks tell you the truth.
Worth doing this week
No need to build the whole thing at once. Start small and let it earn its place.
- Pick one supplier, the one you spend the most with, and pull their last twelve months of invoices into one folder.
- Hand them to an AI tool and ask for your top fifteen most-reordered parts and roughly how often you buy each.
- Turn that into a one-page reorder list with a rough par level next to each part.
- Tape it where you'll see it, and check it at the same time each week, list in hand, eyes on the actual bins.
- After a month, fix the par numbers that were off. Some will be, and that's fine.
If your invoices are a mess or spread across six vendors and you'd rather not wrestle with it, that's the kind of thing we help Massachusetts shops sort out. Either way, the parts you keep running out of are hiding in plain sight inside what you already spent. Might as well read it.