Automated Beverage Distributor Price List Update Rollout
Every morning, WebRun checks VIP for pending supplier price changes, logs the affected SKUs in a Google Sheets price-change register, notifies the sales team in Slack, and queues a price-update email in Mailchimp for account contacts for a manager to approve and schedule before the effective date.
How do I automatically roll out supplier price list updates to my beverage distribution accounts?
WebRun checks VIP every morning for pending supplier price changes, logs all affected SKUs and deltas in a Google Sheets register, alerts the sales team in Slack, and builds a targeted draft Mailchimp email for affected accounts that a manager approves and schedules before the effective date, so every price rollout is coordinated and nothing surprises an account.
- Every supplier price change captured and logged before the effective date
- Sales team notified in Slack with no manual report pulling
- Account price notices drafted and ready for manager approval with one click
Built for beverage distributors · sales managers · pricing teams · beer and wine wholesalers
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
apps.vtinfo.com/beveragein a real browser with your saved login - no setup, no API keys. -
1
VIP - detect pending price changes
vtinfo.com
WebRun opens VIP to detect pending price changes. - Open VIP and check for pending price changes with an upcoming effective date
- Capture SKU, brand, old price, new price, effective date, and supplier for each change
- Identify which accounts carry each affected SKU based on order history
Done when Every pending price change is captured with SKUs, delta, and effective date.
-
2
Google Sheets - update price-change register
google.com
WebRun opens Google Sheets to update price-change register. - Append each price change as a new row in the price-change register
- Include the SKU, old price, new price, percent change, effective date, and affected account count
- Flag changes greater than 5 percent for management review
Done when Price-change register is updated with all pending changes and flags.
-
3
Slack - alert sales team
slack.com
WebRun opens Slack to alert sales team. - Post a summary of pending price changes to the sales channel
- Call out the effective date and any changes flagged for management review
- Link to the Google Sheets register for the full list
Done when Sales team is notified of pending price changes in Slack.
-
4
Mailchimp - queue account price-notice email
mailchimp.com
WebRun opens Mailchimp to queue account price-notice email. - Build a draft price-notice email campaign in Mailchimp listing the affected SKUs and new prices
- Target the audience to contacts at affected accounts only
- Leave the campaign in draft status for a manager to review, set the send date, and approve
Done when Price-notice email is queued in Mailchimp as a draft for manager approval.
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 send the price notice to accounts automatically?
No. The Mailchimp campaign is built and queued as a draft. A manager reviews it, sets the send date, and approves it. Nothing goes to accounts until a human clicks Send.
How does it know which accounts to notify?
It cross-references each affected SKU against order history in VIP to identify accounts that carry the product, so the notice goes only to contacts who are actually affected.
What if a price change is larger than usual?
Changes exceeding 5 percent are flagged in the Google Sheets register and called out in the Slack alert so management can decide whether to adjust pricing or communicate early.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.