Automated Jewelry Low-Stock Reorder Drafts
Every morning, WebRun opens The Edge, finds items at or below your reorder point, groups them by vendor, drafts a purchase order email for each supplier, and logs the pending orders in Google Sheets, leaving every PO unsent for your buyer to review and approve.
How do I automatically create purchase orders when jewelry inventory runs low?
WebRun checks The Edge every morning for items at or below their reorder point, groups them by vendor, and drafts a purchase order email for each supplier in Gmail. All POs are queued for buyer review before sending, and every reorder is logged in Google Sheets, so your store stays in stock without manual inventory checks.
- Low-stock items are flagged and a draft PO is ready every morning before the store opens
- Buyers review one grouped PO per vendor instead of checking inventory manually
- Out-of-stock situations and lost sales are reduced with consistent daily monitoring
Built for retail jewelers · jewelry store buyers · jewelry store owners · jewelry inventory 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.ajsllc.comin a real browser with your saved login - no setup, no API keys. -
1
The Edge - find items below reorder point
ajsllc.com
WebRun opens The Edge to find items below reorder point. - Open The Edge and navigate to the Inventory module
- Filter for items at or below their configured reorder point
- Capture the item description, SKU, current quantity, reorder quantity, and vendor name for each
Done when Every low-stock item is listed with its vendor and reorder quantity.
-
2
Gmail - draft vendor purchase orders
gmail.com
WebRun opens Gmail to draft vendor purchase orders. - Group low-stock items by vendor
- Draft one purchase order email per vendor, listing all items that need restocking with quantities
- Save each PO as a Gmail draft, unsent, for the buyer to review, adjust quantities if needed, and send
Done when A draft PO is ready in Gmail for each vendor with low-stock items, unsent until approved.
-
3
Google Sheets - log pending reorder requests
google.com
WebRun opens Google Sheets to log pending reorder requests. - Append each pending reorder to the purchase order log with item, vendor, quantity, and draft date
- Flag any item that has been below reorder point for more than three consecutive days
- Update the log when orders are confirmed so the team can track what has been sent
Done when The reorder log is updated with today's low-stock items and their draft PO status.
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 purchase orders to vendors on its own?
No. Every purchase order is saved as a Gmail draft. Your buyer reviews, adjusts quantities if needed, and sends each PO. Nothing goes to a vendor without human approval.
How does it know each item's reorder point?
It reads the reorder point you have already set for each item in The Edge. If an item has no reorder point configured, it is excluded until one is set.
What if the same item was already flagged yesterday?
The Google Sheet log tracks items by SKU. WebRun skips items that already have a pending draft PO in the log to avoid creating duplicate orders for the same stock.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.