E-commerce & Dropshipping · n8n
Track Actual Supplier Lead Times to Sharpen Reorder Timing
Reorder with real data — measure each supplier's actual delivery time versus promised and use it to set smarter reorder points.
difficulty Advancedsetup 40 minresult Reorder timing reflects real supplier performance, reducing both stockouts and excess inventory.—
- 1
Capture PO and Receipt Timing
Add
Webhooknodes recording when each PO is placed and when goods arrive. - 2
Compute Actual Lead Time
Add a
Codenode calculating real lead time and comparing it to the promised time. - 3
Update the Averages
Add a
Google Sheetsnode maintaining a rolling average lead time per supplier. - 4
Flag Slipping Suppliers
Add a
Slacknode alerting when a supplier's actual lead time worsens. - 5
Activate and Test
Activate the workflow and log a test PO cycle. Confirm lead time is computed and stored.
Frequently asked questions
How does this improve reordering?
Set reorder points on real lead times plus a buffer, so stock arrives before you run out.
What about seasonal slowdowns?
Track lead time over time so you can anticipate and buffer for known busy periods.
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.