Auto-Email Suppliers a Reorder When WooCommerce Stock Runs Out
When a WooCommerce product hits zero stock, automatically email the assigned supplier a purchase request with the SKU and reorder quantity.
- 1
Trigger on Stock Changes
Add a
WooCommerce Triggernode for theproduct.updatedevent and filter to items whosestock_quantityhas reached zero. - 2
Look Up the Supplier
Add a
Google Sheetsnode to find the row matching the product SKU, returning the supplier email and default reorder quantity. - 3
Compose the Reorder Email
Add a
Gmailnode addressed to the supplier with the product name, SKU and quantity, subjectReorder request: {SKU}. - 4
Log the Reorder
Add a
Google Sheetsnode appending a row with the date and SKU so you have a purchasing audit trail. - 5
Activate and Test
Activate the workflow and set a test product to zero stock. Confirm the supplier email is drafted and sent, and the log row is added.
Frequently asked questions
What if a product has no supplier mapped?
Add an IF node that routes unmapped SKUs to an internal alert so you can add the supplier before stock issues recur.
Can I set reorder points above zero?
Yes — trigger on a low-stock threshold like 5 units instead of zero so you reorder before fully selling out.