Auto-Generate a Purchase Order When Stock Drops Below Reorder Point
An n8n workflow that checks inventory levels, and when an item falls below its reorder point, drafts a purchase order to the right supplier with the reorder quantity and emails it for approval — so you never stock out because someone forgot to reorder.
- 1
Check stock
A
Schedule Triggerreads your inventory table (Sheets, or your store/ERP API) with current stock, reorder point, reorder qty and supplier. - 2
Find items to reorder
A
Filterkeeps products where current stock is below the reorder point. - 3
Draft the purchase order
A
Setnode builds a PO per supplier with items and quantities; group multiple items to the same supplier into one PO. - 4
Send for approval
A
Gmailnode emails the PO to your buyer (or straight to the supplier once trusted), and logs it so you don't double-order next run.
Frequently asked questions
How is the reorder quantity decided?
Each product row holds a reorder point and a reorder quantity (or a target stock level the workflow tops up to). When current stock dips below the point, the PO uses that quantity. You can later make it demand-based, but a fixed reorder qty is reliable and simple to start.
Does it order automatically?
No — it drafts the PO and emails it for approval by default, because auto-ordering can be costly if data is wrong. Once you trust it, you can flip the approval step to auto-send POs under a certain value.