Automated Cin7 Stockout Risk Watchlist
Every morning, WebRun opens Cin7, calculates days of stock remaining for each active SKU based on recent sales velocity, and writes every high-risk item to a Google Sheet watchlist sorted by days until stockout.
How can I automatically identify which SKUs are at risk of stocking out in the next two weeks?
WebRun opens Cin7 every morning, computes days of stock remaining for every active SKU using 30-day average sales velocity, and writes all items under 14 days of cover to a Google Sheet watchlist sorted by urgency. Buyers see the risk before orders are missed and can act while lead times still permit.
- At-risk SKUs identified up to two weeks before a stockout
- Buyers open a sorted watchlist each morning rather than hunting through Cin7 manually
- Stockout-driven lost sales reduced by acting inside the supplier lead time
Built for inventory planners · ecommerce sellers · wholesale distributors · 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 days of stock remaining per SKU
cin7.com
WebRun opens Cin7 to calculate days of stock remaining per SKU. - Open Cin7 and pull current stock on hand for all active SKUs
- Read each SKU's average daily sales over the past 30 days from Cin7 sales history
- Divide stock on hand by average daily sales to compute days of cover
- Flag any SKU with fewer than 14 days of cover as high risk
Done when Every active SKU has a calculated days-of-cover figure and risk flag.
-
2
Google Sheets - log stockout-risk watchlist
google.com
WebRun opens Google Sheets to log stockout-risk watchlist. - Open the designated stockout-risk Google Sheet
- Clear the previous run's rows and write today's flagged SKUs, sorted by days until stockout ascending
- Include columns for SKU, product name, stock on hand, avg daily sales, days of cover, and reorder quantity
Done when The watchlist sheet is refreshed with today's at-risk SKUs sorted by urgency.
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 place purchase orders automatically when stockout risk is high?
No. WebRun writes the risk watchlist to Google Sheets for your team to review. Placing orders remains a human decision, so no spend is committed without approval.
How does it calculate days of cover?
It divides current stock on hand by the 30-day average daily sales rate pulled from Cin7 sales history. Items with no recent sales are excluded from the risk calculation.
Can I change the 14-day threshold?
Yes. Tell WebRun your preferred lead-time window during setup, and it will flag SKUs below that number of days of cover instead of the default 14 days.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.