Automated Cin7 Supplier OTIF Scorecard
On the first Monday of each month, WebRun opens Cin7, reviews all purchase orders closed in the past 90 days, calculates on-time delivery rate and in-full fulfillment rate per supplier, and writes a ranked OTIF scorecard to Google Sheets with a Slack summary highlighting underperforming suppliers.
How do I automatically calculate supplier OTIF scores from Cin7 purchase order data each month?
WebRun reads all Cin7 purchase orders closed in the past 90 days on the first Monday of each month, calculates on-time and in-full delivery rates per supplier, and writes a ranked OTIF scorecard to Google Sheets. A Slack summary flags any supplier below 90 percent so your procurement team knows exactly who to call before the next order is placed.
- Supplier OTIF scores calculated and ranked monthly with zero manual analysis
- Underperforming suppliers flagged in Slack before the next order is raised
- Procurement decisions backed by 90-day on-time and in-full data per supplier
Built for procurement managers · supply chain teams · inventory buyers · operations directors
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 on-time and in-full rates per supplier
cin7.com
WebRun opens Cin7 to calculate on-time and in-full rates per supplier. - Open Cin7 and pull all purchase orders closed in the past 90 days
- For each order, check whether the goods-received date was on or before the expected delivery date (on-time)
- Check whether the quantity received matched the quantity ordered (in-full)
- Group results by supplier and calculate on-time rate and in-full rate as percentages
Done when Every supplier with at least one closed PO in the period has an on-time rate and in-full rate.
-
2
Google Sheets - write supplier OTIF scorecard
google.com
WebRun opens Google Sheets to write supplier OTIF scorecard. - Open the supplier OTIF scorecard Google Sheet
- Write this month's results with one row per supplier showing PO count, on-time rate, in-full rate, and combined OTIF score
- Sort by combined OTIF score ascending so lowest performers appear first
Done when The OTIF scorecard sheet is updated with this month's ranked supplier results.
-
3
Slack - post OTIF summary with underperformers
slack.com
WebRun opens Slack to post OTIF summary with underperformers. - Post a monthly OTIF summary to the procurement Slack channel
- Highlight any supplier with combined OTIF below 90 percent as requiring attention
- Include a link to the full Google Sheet scorecard
Done when The procurement team has a Slack summary of OTIF results with underperformers flagged.
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 contact underperforming suppliers?
No. WebRun posts the OTIF scorecard to Google Sheets and flags underperformers in Slack for your procurement team to review. Any supplier outreach is a human decision so no message goes to a supplier without your approval.
How is the combined OTIF score calculated?
WebRun multiplies the on-time delivery rate by the in-full fulfillment rate to produce the combined OTIF score. A supplier who delivers on time but short ships still scores below 100 percent.
Can it compare this month's OTIF to the previous month?
Yes. Configure WebRun to keep a rolling history in the Google Sheet. Each month's results are added as a new row so you can track trend over time and see whether supplier performance is improving or declining.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.