Stay on top of holiday preorders before you oversell your supply
Every morning during your preorder window, WebRun opens City Hive, tallies the preorder quantities for each product, compares them against your committed inventory in Google Sheets, and posts a capacity status update to Slack showing what is still available and what is close to selling out.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track holiday preorder capacity so I do not oversell my liquor store stock?
WebRun opens City Hive every morning during your holiday preorder window, tallies the preorder quantities for each product, compares them against your committed stock in Google Sheets, and posts a capacity status update to Slack. Your team sees what is available, what is nearly sold out, and what needs action before any product is oversold.
- Preorder volumes are visible against committed stock every morning
- Near-capacity products are flagged before overselling happens
- Management spends seconds reviewing Slack instead of pulling reports
Built for liquor store owners · wine and spirits buyers · bottle shop managers · holiday event 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
www.cityhive.netin a real browser with your saved login - no setup, no API keys. -
1
City Hive - tally current preorder volumes by product
cityhive.net
WebRun opens City Hive to tally current preorder volumes by product. - Open City Hive and navigate to the preorders or orders section
- Filter to the current holiday preorder window
- Capture the total preorder quantity for each product in the window
Done when Today's preorder volumes are totalled for every product in the holiday window.
-
2
Google Sheets - compare against committed stock levels
google.com How to Automate Google Sheets
WebRun opens Google Sheets to compare against committed stock levels. - Open the holiday capacity tracking sheet
- Update each product row with today's preorder count and calculate the remaining capacity
- Flag any product within 10 percent of its committed stock limit as Near Capacity
Done when The capacity sheet is updated with today's volumes and capacity flags.
-
3
Slack - post the daily capacity status update
slack.com How to Automate Slack
WebRun opens Slack to post the daily capacity status update. - Post a daily capacity update to the management channel showing total preorders, remaining capacity per product, and any Near Capacity flags
- Include a link to the Google Sheets tracker for full detail
Done when Management has today's preorder capacity status in Slack with a link to the full sheet.
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
Does it automatically close preorders when stock runs out?
No. WebRun flags products that are near capacity in Slack and updates the tracker. Your team decides when to close a product's preorder window in City Hive.
How do I set the committed stock levels it compares against?
You enter the committed quantities for each product in the Google Sheets tracker before the preorder window opens. WebRun reads those values each morning to calculate remaining capacity.
Can it track multiple holiday products or SKUs at once?
Yes. It tracks every product in the preorder window, so you can manage a full holiday range of wines, spirits, and gift sets from a single daily report.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.