All templates

Automatic Beverage Distributor Low-Stock Reorder Alerts

Every morning, WebRun opens VIP, scans current inventory levels across all SKUs, identifies any item below its reorder threshold, and posts a prioritized low-stock list to Slack and logs it in Google Sheets for the buying team.

Runs on WebRun · Strict Lockdown policy
Every day at 7:00 AM WebRunorchestrates each step
1 VIP scan inventory levels
2 Slack post low-stock alert
3 Google Sheets log reorder candidates
In short

How do I get automatic low-stock reorder alerts for my beverage distribution inventory?

WebRun opens VIP every morning, scans every SKU against its reorder threshold, and posts a prioritized low-stock list to Slack and logs it in Google Sheets, so your buying team starts the day with a clear, ready-to-act reorder list before any product runs out.

  • Buying team sees low-stock items every morning before stockouts happen
  • Every flagged SKU logged with trend data for threshold tuning
  • No manual inventory export or spreadsheet copy-paste required

Built for beverage distributors · beer and wine wholesalers · spirits distributors · buying teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens apps.vtinfo.com/beverage in a real browser with your saved login - no setup, no API keys.

  2. 1
    VIP - scan inventory levels
    vtinfo.com
    WebRun in VIP: scan inventory levels
    WebRun opens VIP to scan inventory levels.
    • Open VIP and navigate to the Inventory module
    • Pull current on-hand quantities for all active SKUs
    • Compare each SKU against its configured reorder threshold
    • Flag any item at or below the threshold with its on-hand count, threshold, and supplier

    Done when Every SKU below threshold is listed with on-hand quantity, supplier, and urgency.

  3. 2
    Slack - post low-stock alert
    slack.com
    WebRun in Slack: post low-stock alert
    WebRun opens Slack to post low-stock alert.
    • Post the low-stock list to the buying team channel, sorted by urgency
    • Include SKU, brand, current on-hand, and threshold for each flagged item
    • Pin the message so buyers can reference it throughout the day

    Done when Buying team has today's low-stock alert in Slack.

  4. 3
    Google Sheets - log reorder candidates
    google.com
    WebRun in Google Sheets: log reorder candidates
    WebRun opens Google Sheets to log reorder candidates.
    • Append each flagged SKU as a new row with date, SKU, on-hand, threshold, and supplier
    • Update the running reorder log so trends are visible week over week

    Done when All flagged SKUs are logged in the reorder tracking sheet.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
apps.vtinfo.com/beverage
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Low-stock list · Slack
OutputWhat each run produces - A prioritized list of SKUs below reorder threshold, with on-hand counts and supplier details, posted to Slack and logged in Google Sheets.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it place a purchase order automatically?

No. WebRun drafts the reorder list and surfaces it for your buying team to review. No PO is created or sent until a human approves it.

How does it know my reorder thresholds?

It reads the thresholds you have already configured in VIP. You can adjust them in VIP at any time and the next morning run will pick up the new values.

What if a SKU is flagged every day because it is a high-velocity item?

The Google Sheets log tracks how often each SKU appears so you can spot items that need a permanent threshold adjustment or a supplier lead-time conversation.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.