Automatic Private Label Reorder Alerts
Every morning, WebRun opens JanSanix, checks stock on hand for every private label SKU against its reorder point, drafts suggested reorder quantities in a Google Sheet based on recent usage, and pings purchasing in Telegram with the items that need a purchase order released before they run out.
How do I catch private label stock before it runs out without over ordering?
WebRun watches your private label inventory every morning. It checks stock on hand in JanSanix against each SKU's reorder point, calculates a suggested reorder quantity in a Google Sheet from recent usage, and messages purchasing in Telegram with what is running low. The purchase order itself stays unsubmitted in JanSanix, so nothing gets ordered without a human reviewing it first.
- Private label stockouts get caught before they cost a sale
- Purchasing reviews a ready made reorder list instead of scanning stock reports
- No SKU already on order gets flagged twice
Built for jan-san distributors with a private label program · purchasing managers · inventory planners · warehouse operations
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
cloud9erp.comin a real browser with your saved login - no setup, no API keys. -
1
JanSanix (Cloud 9 ERP Solutions) - check private label stock against reorder points
cloud9erp.com
WebRun opens JanSanix (Cloud 9 ERP Solutions) to check private label stock against reorder points. - Open JanSanix and pull stock on hand for every private label SKU
- Compare it against each item's set reorder point and lead time
- Check for any purchase order already open for that SKU
Done when Every private label SKU below its reorder point is identified, with open orders excluded.
-
2
Google Sheets - calculate suggested reorder quantities
google.com
WebRun opens Google Sheets to calculate suggested reorder quantities. - Calculate a suggested reorder quantity for each flagged SKU based on recent usage
- List the manufacturer or co packer and the last cost paid
Done when Every flagged SKU has a suggested reorder quantity ready for purchasing to review.
-
3
Telegram - alert purchasing to items running low
telegram.org
WebRun opens Telegram to alert purchasing to items running low. - Message purchasing with the list of private label SKUs running low and the suggested quantities
- Leave the purchase order itself unsubmitted in JanSanix for purchasing to review and release
Done when Purchasing has today's reorder list and nothing has been ordered without 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
Does it place the purchase order automatically?
No. It drafts the suggested reorder quantities and leaves the purchase order unsubmitted in JanSanix. Purchasing reviews and releases it.
How does it decide the reorder quantity?
It looks at each SKU's recent usage and lead time in JanSanix, so the suggestion reflects how fast that item is actually moving, not just a fixed minimum.
What if a purchase order is already open for that SKU?
It checks for open orders first and skips any SKU already on order, so purchasing never gets double reorder alerts for the same item.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.