Detect Slow-Moving & Dead Stock
Every Monday, WebRun pulls sales and stock data from NetSuite, calculates days-of-supply and velocity for each SKU, flags slow-movers and dead stock in your tracker spreadsheet, and posts an action list to Slack.
How can I automatically detect slow-moving or dead stock in my inventory?
Every Monday, WebRun pulls sales and stock data from NetSuite, calculates days-of-supply and velocity for each SKU, flags slow-movers and dead stock in your Google Sheets tracker, and posts an action list to Slack - so you can discount, bundle, or return ageing inventory before carrying costs compound.
- Slow-moving SKUs identified weekly before carrying costs compound
- Action list in Slack ready for discounting, bundling, or return decisions
- Dead stock cleared proactively rather than written off at year end
Built for inventory managers · e-commerce operations · retail businesses · warehouse 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
system.netsuite.comin a real browser with your saved login - no setup, no API keys. -
1
NetSuite - pull sales velocity and stock levels
netsuite.com
WebRun opens NetSuite to pull sales velocity and stock levels. - Open Sales → Sales by Item and pull the quantity sold per SKU for the past 90 days
- Pull current on-hand quantity for each SKU from Inventory Management
- Calculate days-of-supply (on-hand ÷ average daily sales) for each SKU
Done when Every SKU has a days-of-supply figure and a movement classification.
-
2
Google Sheets - flag slow-moving and dead SKUs
google.com
WebRun opens Google Sheets to flag slow-moving and dead SKUs. - Open the Slow-Stock Tracker and add this week's data
- Flag SKUs with no sales in 60+ days as Dead Stock and 30–59 days as Slow-Moving
- Calculate the inventory value tied up in each flagged category
Done when Dead and slow-moving SKUs are classified and their tied-up value is calculated.
-
3
Slack - deliver the weekly action list
slack.com
WebRun opens Slack to deliver the weekly action list. - Post the weekly slow-stock digest: number of SKUs flagged, total value tied up, and the top 10 worst offenders by value
- Suggest actions: discount, bundle promotion, or vendor return eligibility
Done when The team has an actionable slow-stock report with value and recommended next steps.
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 markdown or return items automatically?
No - it surfaces the list and suggests actions, but every markdown, bundle, or vendor return decision is yours to make.
What if a SKU is seasonal and naturally has no sales right now?
You can add a 'Seasonal' flag in the Google Sheets tracker and WebRun will skip those SKUs during their off-season.
Can I change the slow-mover and dead-stock thresholds?
Yes - the 30-day and 60-day windows are configurable in the plan. Adjust them to match your product category's typical sales cycle.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.