Flag low-stock SKUs and draft your reorder
Every morning, WebRun opens Shopify, reads every SKU's current stock and reorder threshold, logs the flagged items in your reorder sheet, and posts you a Slack alert with a draft purchase order ready to send.
- No credit card
- Under $0.01 per run
- Cancel anytime
Shopify
read stock levels for every SKU
How can I automatically flag low-stock SKUs and draft a reorder in Shopify?
Every morning WebRun opens Shopify, checks every SKU's current stock against your reorder threshold, logs flagged items in your Google Sheets reorder tracker, and posts a Slack alert with a draft purchase order ready for you to send - so you top up before selling out.
- Stockouts caught before they cost you a sale
- Draft purchase orders ready to send the same morning
- Reorder sheet updated automatically every day
Built for ecommerce store owners · Shopify merchants · retail operations teams · small business owners
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
admin.shopify.comin a real browser with your saved login - no setup, no API keys. -
1
Shopify - read stock levels for every SKU
WebRun opens Shopify to read stock levels for every SKU. - Open Shopify Admin and navigate to Products > Inventory
- Filter by 'Low stock' using the saved inventory view
- Capture the SKU, product name, variant, current quantity, and your configured reorder threshold for each flagged item
- Skip SKUs where a draft purchase order was already created this week
Done when All SKUs below their reorder threshold have been collected with their details.
-
2
Google Sheets - log flagged SKUs in the reorder tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log flagged SKUs in the reorder tracker. - Open the Reorder Tracker sheet
- Append a row for each low-stock SKU: product name, SKU, quantity on hand, threshold, and today's date
- Mark each row 'Draft - pending approval' so nothing is sent automatically
Done when Every flagged SKU has a new row in the tracker sheet.
-
3
Slack - send you the reorder draft to approve
slack.com How to Automate Slack
WebRun opens Slack to send you the reorder draft to approve. - Post a summary of this run's low-stock items in your #inventory channel
- Include SKU, quantity, and a suggested reorder quantity for each
- Include a link to the tracker sheet so you can approve and send orders from there
Done when You have received a Slack message with the full low-stock list and reorder draft.
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.
Shopify
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Will it place purchase orders automatically?
No - it only drafts the reorder list and posts it to Slack for your approval. No order is placed or sent until you say so.
How does it know my reorder threshold?
It reads the 'Low stock alert' threshold you have already set on each variant in Shopify Admin. You can override those thresholds in the plan without touching the store.
What if a SKU is already on order?
Add a column in your tracker sheet to mark items 'On order' and WebRun will skip those SKUs on future runs so you don't end up with duplicate reorders.
Related templates
Shopify›Shopify›
Amazon Seller›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.