Automated Hardware Store Aged Inventory Report
Every Monday, WebRun opens RockSolid MAX, identifies SKUs that have not sold in 90 or more days, calculates the cost tied up in each, and posts a ranked slow-mover report to Slack so you can decide which items to mark down, return, or clear.
How do I identify slow-moving inventory that needs a markdown at my hardware store?
WebRun opens RockSolid MAX every Monday and identifies every SKU that has not sold in 90 or more days. It ranks the list by the capital tied up in each item and posts a clear report to Slack, highlighting priority clearance candidates and suggesting markdown tiers so you can act on aged inventory before it blocks cash flow.
- Aged inventory flagged every Monday before it ties up more capital
- Items unsold for 180-plus days highlighted as priority clearance candidates
- Suggested markdown tiers based on age buckets so decisions are faster
Built for independent hardware stores · hardware store owners · purchasing 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
www.rocksolid.comin a real browser with your saved login - no setup, no API keys. -
1
RockSolid MAX - identify SKUs with no sales in 90-plus days
rocksolid.com
WebRun opens RockSolid MAX to identify SKUs with no sales in 90-plus days. - Open RockSolid MAX and run the inventory movement report
- Filter for SKUs with zero units sold in the past 90 days
- Capture the SKU, description, on-hand quantity, cost per unit, and total cost at hand
- Sort by total cost tied up, highest first
- Flag any item that has been unsold for more than 180 days as a priority clearance candidate
Done when All slow-moving SKUs are listed and ranked by capital tied up.
-
2
Slack - post aged inventory report for markdown review
slack.com
WebRun opens Slack to post aged inventory report for markdown review. - Post a Slack message with the full ranked list of slow-moving SKUs
- Lead with the total capital tied up in aged inventory
- Highlight items unsold for more than 180 days as priority clearance candidates
- Include suggested markdown tiers (10 percent, 20 percent, clearance) based on age buckets
Done when You have a ranked aged-inventory report in Slack with markdown tiers suggested.
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 change any prices or markdowns automatically?
No. WebRun only reports and flags. All price changes are made by your staff in RockSolid MAX after you review the Slack report.
Can I adjust the no-sale threshold from 90 days?
Yes. Tell WebRun your preferred threshold and it will only flag items older than that, so you control which items appear in the weekly report.
Does it account for seasonal items that are supposed to sit until next season?
You can tag seasonal SKUs in RockSolid MAX and tell WebRun to exclude them, so the report focuses only on year-round stock that is genuinely slow-moving.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.