Automated Cin7 Supplier Lead Time Report
Every Monday, WebRun opens Cin7, reads all purchase orders closed in the past 90 days, calculates actual lead time in days per supplier and SKU, and writes an updated lead-time report to Google Sheets so your team can compare against assumed lead times and adjust reorder points.
How can I automatically track actual supplier lead times using Cin7 purchase order data?
WebRun reads all Cin7 purchase orders received in the past 90 days every Monday and calculates actual lead times per supplier and SKU. It writes average, minimum, and maximum lead times to a Google Sheet so your planning team can compare assumed versus real supplier performance and update reorder points accordingly.
- Reorder points based on real lead times, not guesswork
- Supplier performance visible in one Google Sheet updated every Monday
- Lead-time creep caught early before it causes stockouts
Built for supply chain planners · inventory managers · purchasing teams · operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.cin7.comin a real browser with your saved login - no setup, no API keys. -
1
Cin7 - calculate actual lead times from PO history
cin7.com
WebRun opens Cin7 to calculate actual lead times from PO history. - Open Cin7 and filter purchase orders to those closed as received in the past 90 days
- For each order, calculate the difference in days between PO creation date and goods-received date
- Group results by supplier and compute average, minimum, and maximum lead time per supplier
- Also compute lead time at the SKU level for high-velocity items
Done when Every closed PO has an actual lead time calculated, grouped by supplier.
-
2
Google Sheets - log supplier lead-time report
google.com
WebRun opens Google Sheets to log supplier lead-time report. - Open the supplier lead-time Google Sheet
- Write a summary tab with one row per supplier showing average, min, and max lead time
- Write a detail tab with one row per PO line showing SKU, supplier, PO date, received date, and actual days
Done when The lead-time sheet is updated with this week's 90-day actuals for every supplier.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it automatically update the lead times stored in Cin7?
No. WebRun writes the calculated lead times to Google Sheets for your team to review. Updating the lead times in Cin7 is a manual step so your team can validate the data before it influences reorder math.
What does the 90-day window cover?
It captures all purchase orders closed as received in the past 90 days. Older data is excluded to ensure the report reflects current supplier performance rather than historical patterns that may no longer apply.
Can it flag suppliers whose lead times have increased significantly?
Yes. Configure WebRun with a lead-time increase threshold, such as 20 percent, and it will highlight suppliers in the sheet whose recent average is above that variance.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.