Skip to content

Set up automatic stock reordering so you stop running out

You run out of flour or packaging because reordering depends on someone noticing the shelf is low. A reorder rule fixes the noticing part: when your system forecasts stock dropping below a level you set, it drafts a purchase order to the right supplier for you to review. This guide shows how to set that up, and where the rules need honest attention to keep working.

QITECH · Published · 4 min read
Sources checked

What a reorder rule actually does

A reorder rule keeps forecasted stock above a minimum you choose, without going over a maximum you also set. You set the two numbers per product, based on how the product is replenished. If the product is bought, the rule raises a request for quotation to your supplier; if it is made in-house, it creates a manufacturing order instead. [1]

Our suggestion: start with a small number of products, the ones that hurt most when they run out. Get those rules working for a month, check the orders they draft, then widen the net. Rules that cover everything on day one usually need untangling. [1]

Getting a product ready

Before a rule can work, the product needs to be set up properly in the system. The product type must be set to goods, inventory tracking must be switched on, and for purchased items the purchase option must be enabled with at least one vendor on the vendor pricelist. The system uses the first vendor on that list when it generates a quote, so put your preferred supplier at the top. [1] [2]

We recommend recording each supplier's lead time on the product as well. The forecast that triggers the rule looks ahead using that lead time, so a wrong lead time means orders arrive too late or pile up. Ask your suppliers for realistic delivery times, not the optimistic ones. [1]

Setting the minimum and maximum

The minimum is the floor: when forecasted stock falls below it, a replenishment order is created to bring stock back up to the maximum. The rule works on forecasted stock, not just what is on the shelf right now, so existing incoming orders and confirmed sales are taken into account. [1] [2]

For example, as a hypothetical illustration, say a bakery wants to always keep at least a few bags of flour on hand and never more than a sensible ceiling. You would set the minimum to cover what you expect to use across the supplier's lead time plus a buffer for a late truck, and the maximum to whatever your storeroom and shelf life comfortably hold. When the forecast dips under the minimum, the system drafts the order for the gap up to the maximum. The exact numbers depend on your usage; there is no universal setting. [2]

Fixed minimum and maximum numbers struggle with seasonal swings and short-dated stock. Our advice: review the numbers each season, and keep the buffer wider for long-lead-time suppliers and tighter for daily deliveries. [2]

Pack sizes and rounding

Suppliers often sell in cartons or cases while you count in units. The rule's multiple field handles this: you set the batch size, and the order quantity is rounded up to a batch that meets or slightly exceeds your maximum. That can push stock slightly over the maximum, and the system will flag the possible excess. [1]

We recommend setting the multiple to match how the supplier actually invoices you, such as cases of six or cartons of twelve. It saves your team correcting quantities on every draft order. [1]

Automatic or manual trigger

Rules can trigger automatically or manually. With the automatic trigger, a purchase or manufacturing order is created when the daily scheduler finds the forecast below your minimum, or when a confirmed sale pushes it below. With the manual trigger, low products appear on a replenishment dashboard showing stock, lead times and arrival dates, and a person clicks order when satisfied. The scheduler runs once a day by default. [1] [2]

Our recommendation for most food businesses: start on the manual trigger while you build trust in your stock records, then switch key products to automatic once drafts consistently look right. Rules are only as good as the stock numbers behind them, so pair this with regular cycle counting. [1] [2]

Keep a person in the loop

Automatic does not mean unattended. We suggest a quick daily or weekly review of drafted quotes before they are sent: check the quantity makes sense for the week ahead, the supplier is the one you want, and nothing seasonal has shifted. Confirming a sensible draft takes a minute; catching a bad order after the truck arrives takes far longer. [1] [2]

If you make some items and buy others, you can enable both routes on a product and set a preferred route on the rule. That lets the system pick buying over making, or the reverse, without you deciding each time. [1]

Sources & further reading

  1. Reordering rules — Odoo 20.0 documentation
  2. Configure reordering rules — Odoo 20.0 documentation

Found something that needs updating? Let us know. We welcome corrections.

← More practical guides · Our editorial approach