Coffee Shop Inventory Management: a simple weekly system that actually sticks

Most independent cafés don't have an inventory problem. They have an inventory rhythm problem. The shelves are full of stuff, the milk fridge is half-empty by Friday, and somehow there's always one SKU you 86 at the worst possible time. This is the simple system that fixes it — without a new POS, without enterprise software, and without a spreadsheet that breaks the moment you hire a new barista.

Why coffee shop inventory is uniquely annoying

Cafés have three SKU groups that behave nothing alike. Beans go stale in 2–3 weeks. Dairy goes off in 5–7 days. Cups and lids last forever but cost real money in bulk. A one-size-fits-all reorder policy fails all three. The fix is to set rules per category, not per shop.

The one formula every owner needs

Par level = average daily usage × days between deliveries × safety factor (1.2–1.4). Example: you use 1.4kg of espresso blend per day, deliveries land Mon/Thu (3-day gap), safety factor 1.25 → par = 5.25kg. When on-hand drops below par, you reorder up to par. That's the whole rule.

Days on hand by category (2026 benchmarks)

• Espresso beans: 7–10 days. Past 14 days off roast you taste the loss.
• Filter / batch beans: 3–5 days. Lower volume, higher freshness sensitivity.
• Dairy & oat milk: 2–3 days. Daily deliveries always beat freezer hacks.
• Syrups: 14–21 days. Long shelf life, but kill slow movers ruthlessly.
• Pastries: 0–1 days. Bake daily or partner with a bakery.
• Packaging: 14–21 days. Bulk pricing wins; just don't over-commit on print runs.

The weekly rhythm that actually sticks

Three habits, same time every week, no exceptions:

• Sunday close: count every SKU in the same unit you order in. 15 minutes max.
• Monday open: one consolidated order per supplier. Fewer mistakes, better prices.
• End of month: recalculate par from last month's actual usage — not gut feel.

"We were 'doing inventory' for years and still ran out of oat milk every Friday. Switching to one count, same time, every Sunday fixed it in two weeks."

The cash cost of 'just in case'

Every extra week of inventory ties up roughly 1.5–2.5% of monthly revenue in cash. On a $50k/month café, two weeks of bloat is $1,500 sitting on shelves instead of in your account. That's the espresso-machine repair fund and the marketing budget — stuck on a back-of-house rack.

When to graduate from a spreadsheet

Spreadsheets work to about 30 SKUs. Past that the count takes longer than the closeout, formulas break, and waste tracking lives in a different file than COGS. That's the moment a real coffee shop inventory management tool earns its keep — low-stock alerts on the dashboard, waste tied to the SKU that caused it, and COGS that updates without copy-paste.

Five rules to keep inventory tight

• Count weekly, same time. Sunday close, every SKU, no exceptions.
• Reorder Monday morning. One consolidated order per supplier.
• Recalculate par monthly. Usage shifts with seasons; pars should too.
• Track waste at the bin. If you don't measure it, you'll order around it.
• Kill slow SKUs ruthlessly. If a syrup hasn't moved in 60 days, it's a candle.

Frequently asked questions

What is coffee shop inventory management? It is the weekly routine of counting on-hand stock, setting par levels per SKU, and reordering before you run out — without tying up cash on extra inventory.

How do you calculate par levels for a café? Par level = average daily usage × days between deliveries × safety factor (1.2–1.4). Example: 1.4kg daily usage, 3-day delivery gap, 1.25 safety → par = 5.25kg.

How often should a coffee shop count inventory? Count every SKU once a week at the same time — Sunday close works for most cafés. Reorder Monday morning. Daily spot-checks for milk and pastries.

What is a good inventory turnover for a coffee shop? Healthy independent cafés turn total inventory 8–12 times per month. Espresso beans should be 7–10 days on hand; dairy 2–3 days; syrups 14–21 days.

When should a café stop using spreadsheets for inventory? Most cafés outgrow spreadsheets around 30–40 SKUs. Past that, the count takes longer than the closeout, formulas break, and waste tracking lives in a different file than COGS.

Where Coffee Shop Dashboard fits

The free Coffee Shop Inventory Management tool calculates par levels and reorder quantities for every SKU in your shop — no signup. The full app ties on-hand, waste and COGS together, so low-stock alerts show up on the dashboard and the daily closeout enforces the weekly rhythm above. Create an account today and stop running out of oat milk on Fridays.