Automated Cin7 Dead Stock Report
On the first Monday of each month, WebRun opens Cin7, identifies every SKU that has had zero sales in the past 90 days but still carries stock on hand, calculates the holding cost for each, writes a ranked dead-stock report to Google Sheets, and posts a Slack summary so your team can plan clearance or return decisions.
How do I automatically find dead stock in Cin7 and plan clearance before holding costs grow?
WebRun opens Cin7 on the first Monday of each month, finds every SKU with no sales in 90 days but positive stock on hand, and ranks them by total cost value. The dead-stock list is written to Google Sheets with suggested disposal actions and a Slack summary, so your team can clear holding costs before they compound.
- Dead stock identified monthly before holding costs compound further
- Team receives a cost-ranked clearance list in Google Sheets automatically
- Disposal decisions backed by data on days since last sale and total value
Built for inventory managers · wholesale distributors · ecommerce operators · supply chain planners
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 - identify zero-sales SKUs with stock on hand
cin7.com
WebRun opens Cin7 to identify zero-sales SKUs with stock on hand. - Open Cin7 and pull all active SKUs that have stock on hand greater than zero
- Check sales order history for the past 90 days for each SKU
- Flag any SKU with zero sales in the 90-day window as dead stock
- Capture SKU, product name, stock quantity, cost price, total stock value, and last sale date
Done when Every SKU with no sales in 90 days and positive stock is listed with its cost value.
-
2
Google Sheets - log dead-stock report
google.com
WebRun opens Google Sheets to log dead-stock report. - Open the dead-stock Google Sheet
- Write this month's dead-stock SKUs sorted by total stock value descending
- Add a suggested action column: supplier return for items under 120 days old, clearance sale for older stock
Done when The dead-stock sheet is updated with this month's candidates and suggested disposal actions.
-
3
Slack - post monthly dead-stock summary
slack.com
WebRun opens Slack to post monthly dead-stock summary. - Post a monthly dead-stock summary to the inventory Slack channel
- Include total number of dead SKUs, total cost value tied up, and a link to the Google Sheet
Done when The team has a Slack notification with the headline figures and a link to the full report.
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 discount or list the dead stock for sale?
No. WebRun identifies dead-stock candidates and logs them to Google Sheets for your team to decide what to do. Clearance pricing or supplier return negotiations are human decisions.
Can I change the 90-day no-sales window?
Yes. Tell WebRun your preferred dead-stock definition during setup and it will use that number of days instead of the 90-day default.
What if a SKU has a valid reason for no sales, such as seasonality?
WebRun surfaces all SKUs matching the criteria. Your team reviews the sheet and can exclude known seasonal SKUs or add a note before taking action.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.