Café Inventory Management: How to Never Run Out of Oat Milk Again

Running out of a key ingredient during a rush doesn't just lose one sale — it loses the customer's trust. Here's the dead-simple system that prevents it.

Inventory management sounds like something that requires software, barcode scanners, and a dedicated stockroom person. For a café with 20-50 SKUs, it requires a list, a number, and a rule.

The list is every item you stock. The number is the minimum quantity of each item you need to have on hand before you reorder. The rule is: when stock hits that number, order immediately. Don't wait until tomorrow. Don't wait until it's convenient. Order.

That's the entire system. Everything else is optimization.

Setting Your Reorder Points

The reorder point for each item depends on two things: how fast you use it and how long it takes to get more.

If you go through 4 gallons of oat milk per day and your supplier delivers twice a week (every 3-4 days), your reorder point is at least 16 gallons — four days of supply as a safety buffer. If your supplier is unreliable and sometimes misses deliveries, add another day's worth.

For espresso beans, if you use 5 pounds per day and your roaster delivers weekly with a 2-day lead time, your reorder point is about 15 pounds — enough to survive a delayed delivery.

For cups and supplies, order lead times are usually longer (3-7 days), so reorder points should be higher — typically 1.5 to 2 weeks of supply.

The common mistake is setting reorder points too low. Running lean on inventory feels efficient until you're 86ing lattes at 2 PM on a Saturday. The cost of carrying a few extra bags of beans is nothing compared to the revenue and trust lost from running out.

The Weekly Count

Pick one day per week. Count everything. Update your tracking sheet. Compare current stock to reorder points. Place orders for anything at or below the line.

This takes 20-30 minutes for a typical café. Do it the same day every week, ideally 1-2 days before your major delivery days so orders arrive before you need them.

Some owners count daily for perishables (milk, pastries) and weekly for everything else. That's fine — perishables deserve more attention because they have tighter margins for error.

What to Track

You don't need to track every napkin. Focus on items where running out causes a real problem.

Revenue-critical items are anything you can't make drinks without: coffee beans, milk (every type you offer), cups, lids. If you're out of these, you're effectively closed. These get the tightest reorder points.

Margin items are syrups, sauces, specialty ingredients. Running out of vanilla syrup doesn't close the shop, but it kills your highest-margin drinks. Track these closely.

Operational items are cleaning supplies, sanitizer, paper goods. Running low on these creates health code risk. Track weekly.

The Spreadsheet vs. the Fancy System

You do not need a $200/month inventory management system for a café. A spreadsheet with four columns — Item, Current Stock, Reorder Point, Status — does the job. The status column is a simple formula: if current stock is at or below the reorder point, show a warning. Otherwise, show OK.

The advantage of a spreadsheet over a notebook is the formula. You don't have to compare numbers in your head — the sheet tells you what needs ordering. The advantage over dedicated software is simplicity — you're not managing a system, you're checking a list.

If you want something between a bare spreadsheet and enterprise software, we built an inventory tracker with reorder alerts, supplier connections, and cost tracking into both the Coffee Shop Operations Pack (Notion) and the spreadsheet version (Excel/Google Sheets). The reorder alerts are automatic — when stock drops below your threshold, the status flips to "⚠️ REORDER." No manual checking needed.

But honestly, even a handwritten list on the walk-in fridge door works if you use it consistently. The system matters less than the habit.

Coffee Shop & Café Operations Pack — inventory tracking with reorder alerts, plus 11 more connected templates. $9 launch price. → ops.andyunpacks.com