Inventory Management for Specialty Cafés: Beans, Milk, Syrups, and Software
Inventory management for specialty cafés — beans, milk, syrups, and which software actually helps. Practical operational advice.
Inventory in a specialty café is unusually unforgiving. Beans go stale on a sharp curve. Milk dates dictate weekly reorder cycles. Syrups, alt milks, and pastries each have their own logic. Get it wrong and you either run out at 9 AM on a Saturday or write off product at month-end.
The good news: a small café doesn't need enterprise inventory software to run this well. Disciplined par-level management plus one good spreadsheet covers most operations under three locations.
The core concept: par levels
For each item you sell or use, calculate three numbers:
- Par level: the quantity you want on hand at the start of each order cycle.
- Reorder point: the quantity that triggers a new order.
- Order quantity: how much to order each cycle.
For a café ordering coffee twice a week, an item's par might be 8 kg, reorder point at 3 kg, order quantity to bring back to par.
The numbers come from usage: track weekly consumption for four weeks, average it, add a 25% buffer for variability. Recalibrate quarterly as your sales pattern shifts.
Coffee — the freshness constraint
Coffee is the highest-stakes inventory item because of freshness. Specialty roasters typically peak at 7-21 days post-roast for espresso, slightly later for filter. A bag opened on day 30 isn't ruined, but it isn't the experience you're selling.
The discipline:
- Date every bag when it arrives, in marker, on the bag itself.
- FIFO rotation: first in, first out. New bags go to the back of the shelf.
- Order schedule: twice weekly is the standard for most cafés. Tuesday and Friday delivery cycles match most roaster production schedules.
- Par by SKU: calculate par separately for house espresso, house filter, and each single-origin offering. Singles move slower; over-ordering them is the most common waste source.
If you're going through more than 30 kg of coffee per week, you should be on a standing weekly delivery from your roaster. They'll typically offer better pricing for the predictability.
Milk and dairy — the date constraint
Milk has typically 10-14 days from delivery to sell-by. Order frequency matters more than per-order quantity. Three times a week is standard; high-volume cafés go daily.
Plant milks (oat, almond, soy) typically have longer shelf lives in unopened containers but shorter post-open shelf lives. Track open-container dates separately from inventory dates.
Par-level approach for milk:
- Calculate average weekly consumption by milk type.
- Set par at 3-day supply plus 25% buffer.
- Track plant milk separately — over-ordering oat milk is the single most common waste pattern in modern cafés.
Syrups and modifiers — the long tail
Syrups, sauces, and modifier ingredients are typically the most over-stocked category. Most cafés carry 6-12 syrup SKUs but heavily use only 2-3. The unused SKUs become inventory tax.
Strategy:
- Track monthly usage by SKU.
- Drop any SKU with less than two bottles' usage per month — it's not pulling its weight on shelf space and capital.
- Standardise on a single brand where possible. Switching between three syrup brands creates SKU sprawl with no customer benefit.
- Order syrups monthly, not weekly. Shelf-stable items don't need frequent reorders.
Food and pastries — the perishability bell curve
Pastries are the highest-write-off category in most cafés. The math: ordering 20% more than you'll sell guarantees you'll have inventory at close; ordering 20% less guarantees you'll lose sales. Most operators round up — and write off.
The discipline that minimises waste:
- Track daily sell-through by item, by day of week, for one month.
- Set par at 90% of average sell-through, not 110%. You'll occasionally run out late afternoon. That's acceptable.
- Run an end-of-day discount (20-30% off) on perishables in the last hour. Recovers cost on items that would be tomorrow's write-off.
- For very-perishable items (sandwiches, cut fruit), bake demand into the day — don't pre-make for projection, make to order in the afternoon.
Software — what's worth using
Three tiers:
Tier 1 — Spreadsheet (free). A single-location café under $1M annual revenue can manage inventory in Google Sheets. One sheet per category. Weekly count, par-level comparison, order quantity calculated. Total time: 90 minutes per week.
Tier 2 — POS-integrated inventory (low cost). Square for Restaurants and Toast both include basic inventory tracking. Lightspeed's is more sophisticated. For cafés already on these systems, the marginal cost of using the inventory module is low and the time savings versus a spreadsheet are real.
Tier 3 — Dedicated inventory software (paid). MarketMan ($199/mo+), Crunchtime, OpsAnalitica. Worth it when you have 2+ locations, complex food programs, or you've outgrown the POS-integrated option. The decision point is usually around $1.5-2M annual revenue or a second location.
Don't buy enterprise software before you need it. The discipline matters more than the tool.
The weekly inventory rhythm
The pattern that works:
- Sunday or Monday morning: physical count of all categories. 30-45 minutes. One person, ideally the manager or operator.
- Same morning: compare counts to par, calculate orders. 20 minutes.
- Same day: place orders for the week.
- Friday afternoon: check fast-movers (milk, fresh items) and order for the weekend.
Total weekly inventory time: 90 minutes if you're disciplined. The discipline saves you 5-10 hours per month in avoided fire drills (running to the supermarket for oat milk at 8:45 AM, calling the roaster for an emergency drop, writing off 4 kg of stale beans).
What to track monthly
End of each month, calculate three numbers:
- Inventory turnover by category. Cost of goods sold divided by average inventory. Coffee should turn 3-4× per month for a busy café. Below 2×, you're over-stocked.
- Write-off rate. Value of expired/wasted product divided by total purchases. Above 5% is a problem; above 8% is an emergency.
- Stockout incidents. Note any item you ran out of. Patterns indicate par-level adjustments needed.
The cost of bad inventory
For a café doing $750K/year revenue, the difference between good and bad inventory management is typically 2-3% of revenue — $15,000-$22,000/year. That's not a marginal number. It's the difference between a profitable year and a break-even one.
For more on the financial discipline that ties to inventory, see our pieces on profitability and minimising waste.