Ops · n8n

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.

difficulty Intermediatesetup 50 minresult Items below reorder point trigger a ready-to-approve purchase order to the correct supplier
  1. 1

    Check stock

    A Schedule Trigger reads your inventory table (Sheets, or your store/ERP API) with current stock, reorder point, reorder qty and supplier.

  2. 2

    Find items to reorder

    A Filter keeps products where current stock is below the reorder point.

  3. 3

    Draft the purchase order

    A Set node builds a PO per supplier with items and quantities; group multiple items to the same supplier into one PO.

  4. 4

    Send for approval

    A Gmail node 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.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.