How to prepare a weekly wine order using sales, stock and events

Preparing the weekly wine order does not mean replacing everything that went down. It means deciding what the restaurant needs until the next delivery, with enough protection for real demand and without turning the cellar into idle capital. The manager's judgement still matters, but it works better when it starts from a visible calculation.

Minimum data required

For each wine, collect usable stock, recent sales, days until the next delivery and units per case. Then add the exceptions: bookings, events, menus, list changes, promotions, supplier outages and stock already on order.

A calculation the team can review

A practical base is: recent daily demand × coverage days + safety stock − available stock − inbound orders. Round the result to the supplier's pack size. This is not an automatic command. It is a proposal that a manager adjusts when operational knowledge is not yet in the data.

Separate rotation from noise

One unusual sale does not make a wine a fast mover. Compare several weeks, separate bottle and glass sales, and identify whether demand is stable or event-driven. For by-the-glass wines, include open bottles and actual yield per bottle; otherwise the suggested order can be too high.

Set coverage by the wine's role

Not every wine needs the same buffer. Entry wines, by-the-glass selections and key pairings need stronger continuity. Prestige or discovery bottles can operate with lower coverage. The Wine Library helps assign that role instead of applying one rule across the list.

Exceptions that change the order

Before confirming, review events, terrace demand, holidays, menu changes, supplier availability, volume discounts and storage limits. A lower case price is not a saving if the wine takes months to move. Capital and storage space are part of the cost.

What a useful planner should return

The result should show current stock, observed pace, target coverage, suggested quantity, pack size, reason and confidence level. It should also separate “order now”, “watch” and “do not replenish”. That lets the team review exceptions in minutes.

How SAVia connects the process

SAVia can use available sales, stock and operational context to prepare a proposal and explain each quantity. The manager confirms it, adjusts supplier availability and keeps the decision traceable. Automation reduces repetitive work; it does not invent events or replace missing source data.

Frequently asked questions

Which sales period should I use? Combine a recent window with a longer one. The recent window catches change; the longer one prevents reacting to a single service. How much safety stock is enough? It depends on delivery frequency and reliability, the role of the wine and demand variability. Use the [weekly order planner](/en/tools/weekly-wine-order-planner), then explore [SAVia](/en/product/savia), [stock and rotation](/en/article/wine-library-by-the-glass-stock-rotation), the [Wine Library](/en/wine-library) and [demo](/en/demo).