Whiskey Systems Automated Customer Reorder Reminders
Every Monday, WebRun opens Whiskey Systems and identifies active wholesale accounts whose most recent order is 45 or more days old, logs each at-risk account to a Google Sheet with their last order date and typical order frequency, and queues a personalized reorder reminder email in Mailchimp for review before it goes out.
How do I automatically remind wholesale accounts to reorder from my distillery?
Every Monday, WebRun finds Whiskey Systems wholesale accounts whose last order is 45 or more days old, logs each at-risk account to a Google Sheet with their last-order context, and queues a personalized reorder reminder in Mailchimp for a human to review and approve before any email reaches a customer.
- At-risk accounts identified every Monday before they lapse entirely from the customer list
- Personalized reorder emails queued in Mailchimp reference the account's actual order history
- No email sent to a customer without a human reviewing and approving the campaign list
Built for craft distillery sales managers · wholesale account managers · distillery marketing teams · distribution coordinators
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.whiskeysystems.comin a real browser with your saved login - no setup, no API keys. -
1
Whiskey Systems - find accounts overdue for a reorder
whiskeysystems.com
WebRun opens Whiskey Systems to find accounts overdue for a reorder. - Open Whiskey Systems and navigate to the customer or sales-order history view
- Filter active wholesale accounts whose most recent closed order is 45 or more days in the past
- Capture the account name, contact email, last order date, last SKUs ordered, and typical order frequency if visible
Done when Every account overdue for a reorder is listed with their contact details and last order summary.
-
2
Google Sheets - log at-risk accounts
google.com
WebRun opens Google Sheets to log at-risk accounts. - Open the Reorder Reminder Tracker sheet
- Append each at-risk account as a new row with today's date, last order date, and days since last order
- Note the last SKUs ordered so the reorder email can reference them
- Mark any account that places an order after being logged as converted
Done when The tracker reflects this week's at-risk accounts with their order history context.
-
3
Mailchimp - queue personalized reorder reminder emails
mailchimp.com
WebRun opens Mailchimp to queue personalized reorder reminder emails. - Add each at-risk account to a Reorder Reminder audience segment in Mailchimp
- Queue a personalized email referencing the account's last order and the SKUs they typically buy
- Set the email to draft or pending status so a human reviews the list and approves the send. Do not trigger the campaign automatically.
Done when A personalized reorder reminder is queued in Mailchimp for every at-risk account, pending human 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 reorder emails automatically?
No. WebRun queues the Mailchimp campaign as a draft for your review. A human approves the list and triggers the send so no customer receives a reorder email without a deliberate decision.
How does it know the right SKUs to mention in each email?
It pulls each account's most recent order from Whiskey Systems and references those SKUs in the Mailchimp template. You can provide a personalization template and WebRun will fill in the product details per account.
What if an account is seasonal and only orders at certain times of year?
Mark seasonal accounts with a tag in Whiskey Systems and provide WebRun with the tag name to exclude. Those accounts will be skipped during their off-season and included when they are in their active ordering window.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.