Flag slow-moving bottles before they tie up your cash
Every Monday, WebRun opens City Hive, identifies products that have not moved in 60 days or longer, ranks them by inventory value tied up, logs the list in Google Sheets, and posts a prioritized slow-mover flag to your Slack channel so you can act before they age further.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically identify slow-moving inventory in my liquor store?
WebRun scans City Hive every Monday for products with no sales in 60 or more days, ranks them by the inventory value they are tying up, logs the list in Google Sheets, and posts the top slow movers to Slack. Your team reviews the flag and decides on markdowns or promotions before cash stays locked up longer.
- Slow movers surface every Monday before they age further
- Inventory value tied up is visible at a glance by SKU
- Markdown decisions are data-driven rather than gut-feel
Built for liquor store buyers · bottle shop owners · wine and spirits managers · beverage retail operators
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.cityhive.netin a real browser with your saved login - no setup, no API keys. -
1
City Hive - scan for aged slow-moving products
cityhive.net
WebRun opens City Hive to scan for aged slow-moving products. - Open City Hive and navigate to the inventory or sales report
- Filter to products with zero units sold in the past 60 days
- Capture the product name, SKU, current stock count, unit cost, and days since last sale
- Calculate the total value tied up for each line
Done when Every slow-moving product is listed with its inventory value and days since last sale.
-
2
Google Sheets - log and rank the slow-mover list
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log and rank the slow-mover list. - Open the slow-mover log sheet
- Append this week's list with the date, product, SKU, stock, days stagnant, and inventory value
- Sort by total inventory value descending to surface the costliest slow movers first
Done when This week's slow-mover list is logged and ranked in Google Sheets.
-
3
Slack - post the weekly slow-mover flag
slack.com How to Automate Slack
WebRun opens Slack to post the weekly slow-mover flag. - Post the top ten slow movers to the buying or management channel, ordered by inventory value
- Include the days since last sale and value tied up for each
- Add a link to the full Google Sheets log for the complete list
Done when Management has this week's top slow movers in Slack for markdown or promotion planning.
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
Can I change the 60-day threshold for what counts as a slow mover?
Yes. Tell WebRun the number of days that fits your buying cadence, such as 30 or 90, and it will apply that cutoff when scanning City Hive each week.
Does it apply any markdowns or price changes automatically?
No. WebRun flags the slow movers and reports them to your team. Any markdown or pricing change is made by your staff in City Hive after reviewing the list.
What about seasonal products that are expected to sit?
You can exclude specific SKUs or categories in your settings. WebRun will skip those products and focus the report on items you actually want to move.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.