Stock levels are monitored against real sales velocity, and the team is alerted before popular products run out — so reordering happens calmly and on time.
Typical results
Daily
stock check against real sales velocity
100%
of the catalog monitored automatically
Ready
reorder list attached to every alert
Figures reflect typical results for this kind of automation.
The challenge
Best-selling items kept selling out unexpectedly, leading to lost sales and last-minute, rushed orders to suppliers.
Before and after
Stockouts on key products per month
−45%Rushed last-minute supplier orders per month
−88%Days of warning before a product runs out
The automation
We built an automation that checks inventory daily, compares it to each product's sales rate, and sends a low-stock alert plus a ready-to-use reorder list.
How it works
- 01
Track stock
Inventory levels are monitored continuously across every product.
- 02
Read sales velocity
Real sales speed is compared against current stock to predict when items will run out.
- 03
Alert the team
A low-stock alert is sent before popular products run dry.
- 04
Build the reorder list
A ready reorder list is generated so the warehouse team can restock calmly and on time.
Starts from
- Stock levels
- Sales rate
Delivers
- Low-stock alert
- Reorder list
The impact
Stockouts on key products fell by around 45%, and the team now reorders calmly and on time.
Questions about this automation
How does the automation decide when stock is low?
Each day it divides current stock by the product's recent average daily sales to estimate how many days of cover are left. When that drops below the supplier's lead time plus a safety buffer, the product is flagged. Slow sellers and new products without much sales history can use a fixed minimum instead.
Where do the alerts and the reorder list arrive?
Alerts usually go to email, Slack or WhatsApp, whichever the warehouse team already watches. The reorder list arrives as a Google Sheet grouped by supplier, with the suggested quantity, current stock and last order date for each item, so the team can review it and place orders in a few minutes.
What is needed from the store to get started?
Read access to the store or inventory system for stock levels and order history, plus a list of suppliers with lead times and minimum order quantities. A few months of sales history makes the estimates more accurate. Simple automations like this are usually live within days.