Automated rfxcel Short-Dated Inventory Clearance
Every Monday, WebRun opens rfxcel, finds lots inside your short-dated clearance window, builds a list in Google Sheets of customers who regularly buy that SKU, and drafts a limited-time clearance offer to each eligible customer in Outlook for your review.
How do I clear short-dated pharmaceutical inventory before it expires?
WebRun finds lots inside your short-dated clearance window in rfxcel every Monday, matches each one against customers who regularly buy that SKU in Google Sheets, and drafts a limited-time clearance offer to the top-ranked customer in Outlook for your review. Nothing is sent to a customer until you approve it, so short-dated stock moves before it becomes a write-off.
- Short-dated stock reaches likely buyers before it becomes a write-off
- Every clearance offer is ranked by the customer's actual buying history
- No offer goes out to a customer without your review
Built for pharmaceutical wholesalers · drug distributors · inventory control managers · sales operations teams
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.rfxcel.comin a real browser with your saved login - no setup, no API keys. -
1
rfxcel - find lots inside the clearance window
rfxcel.com
WebRun opens rfxcel to find lots inside the clearance window. - Open rfxcel and pull lots expiring within your clearance window, typically under 60 days
- Exclude any lot already committed to an existing order
- Capture the SKU, lot number, quantity, and expiry date for each
Done when Every uncommitted short-dated lot is captured with its quantity and expiry date.
-
2
Google Sheets - match lots to eligible customers
google.com
WebRun opens Google Sheets to match lots to eligible customers. - Look up which customers have ordered that SKU in the past 12 months
- Rank eligible customers by order volume for that SKU
- Log the proposed discount and quantity available for each match
Done when Every short-dated lot has a ranked list of eligible customers with a proposed offer.
-
3
Outlook - draft the clearance offer
microsoft.com
WebRun opens Outlook to draft the clearance offer. - Draft a limited-time clearance offer to each eligible customer with the discount and expiry date stated plainly
- Send the top-ranked customer for each lot first
- Leave every offer unsent in your drafts folder for review
Done when A draft clearance offer is ready for every short-dated lot, none sent without your 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 email customers a discount offer without me approving it?
No. WebRun drafts every clearance offer and leaves it unsent in Outlook. You choose the final discount and send it yourself.
How does it pick which customers to offer stock to?
It ranks customers by how much of that SKU they have bought in the past 12 months, so the offer goes to the accounts most likely to take the volume.
What is the clearance window it uses?
60 days by default. Tell WebRun your own cutoff and it will use that instead. Any lot already committed to an existing order is excluded automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.