Flag expiring lots before they become write-offs
Every Monday, WebRun opens rfxcel, pulls every lot expiring within the next 90 days, logs the SKU, lot number, and days remaining to a Google Sheet, and posts your warehouse team a Slack list ordered so the soonest-to-expire stock gets picked first.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track pharmaceutical lots before they expire?
WebRun scans rfxcel every Monday for lots expiring within 90 days, logs the SKU, lot number, quantity, and days remaining to a Google Sheet, and posts your warehouse team a ranked Slack list with the soonest-to-expire stock at the top. That gives ops time to prioritize first-expire-first-out picking or a clearance run before anything actually expires.
- Warehouse ops sees the full 90 day expiry watchlist every Monday
- Soonest-to-expire lots are ranked first for FEFO picking
- Nothing expires unnoticed since every lot stays on the list until resolved
Built for pharmaceutical wholesalers · drug distributors · warehouse operations teams · inventory control 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
www.rfxcel.comin a real browser with your saved login - no setup, no API keys. -
1
rfxcel - find lots nearing expiry
rfxcel.com How to Automate rfxcel
WebRun opens rfxcel to find lots nearing expiry. - Open rfxcel and pull current on-hand inventory by lot
- Filter to lots expiring within the next 90 days
- Capture the SKU, lot number, quantity on hand, and expiry date for each
Done when Every lot expiring in the next 90 days is captured with its quantity and expiry date.
-
2
Google Sheets - log the expiry watchlist
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the expiry watchlist. - Log each expiring lot to the tracking sheet with days remaining
- Sort the sheet so the soonest-to-expire lots sit at the top
- Mark any lot that was already flagged last week as still open
Done when The expiry watchlist sheet reflects this week's lots in first-expire-first-out order.
-
3
Slack - alert warehouse ops
slack.com How to Automate Slack
WebRun opens Slack to alert warehouse ops. - Post the top of the watchlist to the warehouse ops channel
- Flag any lot expiring within 30 days on a separate line
- Link back to the full sheet for the rest of the list
Done when Warehouse ops has this week's expiry watchlist and the 30-day flags in Slack.
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
How far out does it look for expiring lots?
90 days by default, so warehouse ops has time to prioritize picking, run a clearance, or plan a return well before anything actually expires.
Does it change anything in my inventory system?
No. It only reads lot and expiry data from rfxcel. Moving, quarantining, or writing off stock is still a decision your team makes.
What happens to a lot that expires without being sold?
It stays on the watchlist with an overdue flag until you resolve it in rfxcel, so nothing quietly drops off the list unaddressed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.