Restock Alerts for Coffee Roasters

Freshness windows: why roasted inventory cannot be your buffer

Every roastery has a freshness standard — a window after roast date inside which it is willing to ship. Whatever yours is, it caps roasted inventory at only a few roast cycles of stock. Holding more roasted coffee does not add safety; it adds future discounting and staff coffee.

That constraint moves the entire buffering job upstream, and it is the reason restock alerts for coffee roasters belong on green stock rather than roasted stock. Green coffee, stored properly, is stable for months, so green is where the safety stock lives, and the roast schedule is the valve that turns it into fresh sellable stock on demand. In practice a small roastery carries days of roasted coffee, weeks to months of green, and reorders green on a lead time measured in weeks. The restock question is therefore always a green-bean question first.

The roast schedule is the metronome for every alert

If you roast Tuesdays and Thursdays, your inventory does not deplete continuously — it steps down at each roast and refills the roasted shelf. Restock alerts for coffee roasters should respect that cadence. A green-bean alert that fires the morning of a roast day is already late: the useful alert fires at least one full ordering cycle before the roast day on which you would otherwise come up short.

The spreadsheet version is a per-origin consumption line: batches per roast day, times charge weight, times roast days per week, gives kilograms of green consumed weekly. A roaster running a 12 kg machine with six batches of a Colombia each week consumes about 72 kg green weekly — roughly a 70 kg sack every seven days, before roast loss even enters the sales math. Lay that consumption against sacks on hand and you get weeks of cover per origin, which is the single number your alerts key off.

Subscriptions make demand semi-predictable — use that

A roastery with 300 active subscriptions knows something most ecommerce brands would pay dearly for: a floor under next month’s demand. Subscription volume is committed, billed on a schedule, and churns gradually rather than collapsing overnight. One-off web orders and wholesale top the floor up with noise, but the floor itself is close to a constant.

Split your forecast into those two layers. The subscription layer converts directly into roast-schedule load: subscriber count, times average bag weight, times shipments per month, allocated across the origins in your subscription blends. The variable layer — one-off retail, gifts, seasonal spikes — is the only part that needs velocity averaging at all. Sizing green purchases against the committed layer plus a measured average of the variable layer is dramatically more reliable than treating all demand as random.

The split also tells you where the sensitivity of restock alerts for coffee roasters belongs. An origin that anchors your subscription blend deserves a wide safety margin and an early alert, because a stockout there breaks promised shipments. A rotating single-origin feature can be allowed to sell through and retire gracefully — that is merchandising, not failure.

Reorder points for green coffee, in a spreadsheet

The reorder point is the arithmetic underneath all restock alerts for coffee roasters, and the formula is standard; only the units are roastery-specific. Per origin: weekly green consumption, times importer lead time in weeks, plus safety stock. If the Colombia burns 72 kg a week, the importer quotes three weeks door to door, and you hold two weeks of buffer against demand bumps and delayed releases, the reorder point is 72 × 3 + 144 = 360 kg — call it five to six 70 kg sacks. When on-hand green touches that line, the purchase order goes out.

Two roastery-specific corrections matter. First, roast loss: green loses weight in the roast, so back-calculate green needs from roasted demand by dividing by your measured yield rather than treating a kilogram sold as a kilogram of green. Second, availability windows: green is an agricultural product, and an origin you buy every month can simply run out at the importer between harvests. For origins you cannot substitute, the alert should really key off the importer’s remaining lots as well as your own floor stock — when a coveted lot runs low upstream, the reorder point logic inverts into “buy what the year needs now.”

ShelfOwl’s free reorder point and safety stock calculators run these numbers per origin, and the latest order date calculator flips the same inputs into a calendar answer: the last day you can order this origin before cover runs out.

Packaging runs out faster than beans

Ask roasters what actually halted shipping last year and the answer is rarely coffee. It is 12 oz bags with the new label design, one-way valves, shipping boxes in the one size the subscription mailer uses, or the labels themselves. Packaging is easy to ignore precisely because it is cheap — nobody watches a line item that costs cents per unit until its absence stops hundred-dollar orders. Complete restock alerts for coffee roasters cover consumables with the same seriousness as beans.

Treat packaging as first-class inventory with its own reorder points: bags per week, boxes per week, label rolls per month, each with its supplier’s real lead time — custom-printed bags can quote lead times as long as your green coffee, and reprints do not ship faster because you are desperate. A packaging stockout and a green stockout look identical to the customer: nothing arrives.

Alert mechanisms, from calendar to email

The mechanism matters less than the trigger math, but each step up buys reliability. A recurring calendar reminder — “check green and packaging levels every Monday” — costs nothing and fails silently the first busy week it is dismissed. Spreadsheet conditional formatting is the natural second step: a cover-in-weeks column per origin that turns amber below four weeks and red below the reorder point, visible every time the sheet is open. Its weakness is the same as the calendar’s: it alerts only when someone looks.

The third step is alerts that come to you. This is the specific gap ShelfOwl’s paid forecaster fills for restock alerts for coffee roasters: export one CSV with your origins, packaging SKUs, stock levels and consumption rates, and it computes the latest safe order date for every line, then sends a per-SKU email reminder as each order-by date approaches. No integrations and no platform migration — a CSV in, dates and reminders out, for 29 dollars a month with a 14-day trial and no card up front.

Whichever mechanism you use, review the trigger inputs quarterly. Roast schedules change, subscriptions grow, importers change transit times — an alert wired to last year’s consumption rate is a quiet way to be surprised twice.