Automated Dispensary Stock Alerts
Every morning, WebRun opens Flowhub, scans current stock levels across all SKUs, flags any product below your reorder threshold, appends the details to a Google Sheet, and posts a draft reorder list to Slack so your buyer can act before shelves run empty.
How do I get automated low-stock alerts for my dispensary?
WebRun connects to Flowhub each morning, scans every active SKU against your reorder thresholds, and logs flagged items to Google Sheets. It then posts a draft reorder list to your Slack channel so the buyer can review and act before stock runs out, without any automatic ordering.
- Never miss a low-stock SKU before the selling day starts
- Buyers open Slack to a ready-to-action reorder draft each morning
- Persistent shortages are flagged in Sheets for supplier follow-up
Built for dispensary buyers · inventory managers · cannabis retail operators · dispensary general 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
app.flowhub.comin a real browser with your saved login - no setup, no API keys. -
1
Flowhub - scan current stock levels
flowhub.com
WebRun opens Flowhub to scan current stock levels. - Open Flowhub and navigate to the inventory section
- Pull current quantity-on-hand for every active SKU
- Compare each SKU against your configured reorder threshold
- Collect the SKU name, category, current quantity, and threshold for each flagged item
Done when Every SKU below threshold is listed with its current quantity and reorder details.
-
2
Google Sheets - log flagged SKUs
google.com
WebRun opens Google Sheets to log flagged SKUs. - Open the dispensary stock-alert log in Google Sheets
- Append a new row for each flagged SKU with date, name, category, quantity, and threshold
- Mark any SKU that has been below threshold for two or more consecutive days
Done when All flagged SKUs are logged with today's date and stock details in the sheet.
-
3
Slack - post draft reorder list
slack.com
WebRun opens Slack to post draft reorder list. - Draft a reorder message listing each flagged SKU with quantity and suggested order amount
- Post the draft to the inventory Slack channel for manager review
- Never place or confirm an order without explicit staff approval
Done when The draft reorder list is posted to Slack and ready for buyer review.
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 place a reorder automatically?
No. WebRun drafts the reorder list and posts it to Slack for your buyer to review. No order is placed or submitted without a staff member approving and acting on the draft.
How do I set the reorder threshold for each SKU?
Thresholds are read from your Flowhub inventory settings. Update the par level for any SKU in Flowhub and the next morning run will automatically use the new value.
What if a SKU is flagged every day because supply is delayed?
The Google Sheets log marks items below threshold for multiple consecutive days, so your buyer can see persistent shortages at a glance and prioritise supplier follow-ups.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.