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
Capture the Receipt
Add a
Webhooknode fed when a goods receipt is logged with the PO number and quantities. - 2
Match the PO
Add a
Google Sheetsnode finding the purchase order and its expected quantities. - 3
Update Inventory
Add a
Google Sheetsnode incrementing stock for each received SKU and marking the PO fulfilled. - 4
Confirm to the Team
Add a
Slacknode posting what was received and any short-shipped items. - 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.