Reordering rules keep your stock topped up automatically. You set a minimum and maximum quantity per product. When stock drops below the minimum, Odoo raises a purchase suggestion to replenish back up to the maximum.
Download: Reordering rules import template (XLSX)
To set this up for many products at once, use the Excel template. It imports into the stock.warehouse.orderpoint model.
Importing the template
Import the file under Inventory -> Configuration -> Reordering Rules. The headers in the Excel template carry a note for each column explaining what to enter.
Key columns
| Column | Field | What it does |
|---|---|---|
| Product | product_id | The product the rule applies to (required). |
| Warehouse | warehouse_id | The warehouse the rule applies to. |
| Location | location_id | The stock location being monitored. |
| Min quantity | product_min_qty | Below this level a reordering rule triggers. |
| Max quantity | product_max_qty | Odoo replenishes up to this level. |
| Trigger | trigger | Automatic or manual replenishment. |
| Vendor | supplier_id | Optional: the vendor pricelist for the purchase suggestion. |
Getting started
- Fill in the template with a minimum and maximum quantity for each product.
- Import the file under Inventory -> Configuration -> Reordering Rules.
- Check the rules that were created and run a first replenishment to confirm the purchase suggestions are right.
A well-chosen minimum accounts for your lead time: the longer a vendor takes to deliver, the higher your minimum should sit to avoid running out.
Need a hand with your import?
Stuck setting up your reordering rules, or want a tailored template? Book an Odoo scan or get in touch - we will take a look with you.