E-commerce & Dropshipping · n8n

Update Inventory Automatically When Goods Are Received

Keep stock accurate — when a goods receipt is logged against a purchase order, automatically increment inventory and close the PO.

difficulty Intermediatesetup 40 minresult Inventory updates the moment stock arrives, keeping counts accurate without manual entry.
  1. 1

    Capture the Receipt

    Add a Webhook node fed when a goods receipt is logged with the PO number and quantities.

  2. 2

    Match the PO

    Add a Google Sheets node finding the purchase order and its expected quantities.

  3. 3

    Update Inventory

    Add a Google Sheets node incrementing stock for each received SKU and marking the PO fulfilled.

  4. 4

    Confirm to the Team

    Add a Slack node posting what was received and any short-shipped items.

  5. 5

    Activate and Test

    Activate the workflow and log a test receipt. Confirm inventory increments and the PO closes.

Frequently asked questions

What about partial receipts?

Track received-so-far quantities so partial deliveries update stock and keep the PO open for the remainder.

Can I flag over-receipts?

Yes — compare received against ordered and alert when quantities exceed the PO.

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.