Identify slow-moving lumber and building materials before they tie up cash
Every Monday, WebRun opens DMSi Agility and identifies all SKUs with no sales activity in the past 90 days, calculates the total inventory value tied up in each slow mover by branch, logs the full list in Google Sheets ranked by carrying cost, and posts a summary to Slack so your purchasing team can act on markdowns, transfers, or vendor returns.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically identify slow-moving lumber inventory in DMSi Agility?
WebRun scans DMSi Agility every Monday for SKUs with no sales in the past 90 days, calculates the total inventory value tied up in each slow mover by branch, logs them in Google Sheets ranked by carrying cost, and posts a summary to Slack so your purchasing team can plan markdowns, inter-branch transfers, or vendor returns to free up working capital.
- Capital tied up in dead stock is visible every Monday morning without a manual report pull
- Inter-branch transfer candidates are identified automatically, reducing cross-location freight
- Purchasing team focuses markdown decisions on the highest-value slow movers first
Built for lumber dealers · building materials distributors · purchasing managers · inventory controllers
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
www.dmsi.comin a real browser with your saved login - no setup, no API keys. -
1
DMSi Agility - identify SKUs with no sales in 90 days and calculate carrying cost
dmsi.com How to Automate DMSi Agility
WebRun opens DMSi Agility to identify SKUs with no sales in 90 days and calculate carrying cost. - Open DMSi Agility and query inventory for SKUs with zero sales units in the past 90 days
- Capture SKU, description, on-hand quantity, unit of measure, average cost, total value, and branch for each item
- Also flag items with sales activity but a declining velocity trend over the same period
Done when All slow-moving SKUs are identified with their on-hand value and branch.
-
2
Google Sheets - log slow-mover list ranked by inventory value
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log slow-mover list ranked by inventory value. - Log every slow mover as a row ranked by total inventory value, highest first
- Add columns for days since last sale, suggested action (markdown, transfer, return), and reviewer notes
- Retain history from prior weeks to track whether items have moved since the last report
Done when Full slow-mover list is logged in Google Sheets, ranked by value, with prior-week comparison.
-
3
Slack - post weekly slow-mover report to purchasing team
slack.com How to Automate Slack
WebRun opens Slack to post weekly slow-mover report to purchasing team. - Post a weekly slow-mover summary to the purchasing Slack channel
- Show total capital tied up in slow movers, number of SKUs flagged, and the top five by value
- Link to the full Google Sheets report for detailed review
Done when Purchasing team has the weekly slow-mover summary and top-five list in Slack.
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 reduce prices or initiate vendor returns automatically?
No. WebRun surfaces the slow movers and ranks them by value. Your purchasing team decides whether to markdown, transfer to another branch, or initiate a return, and takes those actions manually.
Can it vary the lookback window beyond 90 days?
Yes. You can configure the lookback period, such as 60 or 120 days, during setup. WebRun applies your chosen window consistently on every weekly run.
Does it distinguish between slow movers at one branch versus all branches?
Yes. Each slow mover is reported with its branch so the team can see if an item is slow everywhere or only at one location. Items slow at one branch but fast at another are good candidates for an inter-branch transfer.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.