Daily low-stock reorder recommendations for Adobe Commerce
Every weekday at 9am, spot Adobe Commerce products running low, rank them by how many days of stock you have left, and post a reorder plan to Slack.
Integrations
Adobe Commerce (Magento)
Slack
Google Sheets
Type
Categories
- Operations
Every weekday at 9am, run Adobe Commerce Get Low Stock Items to pull the list of products that are at or below their reorder threshold. This is the starting set of SKUs the ops team needs to think about restocking today.
For each low SKU, call Adobe Commerce List Order Items with a searchCriteria filter on sku and created_at covering the last 30 days. Sum the ordered quantity across those line items and divide by 30 to get a daily sales velocity for that product. Then compute days of cover as current on-hand quantity divided by daily velocity (treat zero-velocity SKUs as a very large days-of-cover so they sort last, and flag them as slow movers rather than urgent reorders).
Once every SKU has a velocity and days-of-cover figure, have the AI rank the full list ascending by days of cover (smallest first, i.e. most urgent) and draft a short reorder recommendation per SKU: suggested purchase quantity sized to restore roughly 30 days of cover plus a small safety buffer, plus a one-line rationale calling out anything unusual (recent spike, near-zero velocity, seasonal item).
Post the ranked list to a Slack channel using Slack Send a Message. Format it as a readable digest: a headline with today's date and total number of at-risk SKUs, then one bullet per SKU with product name, SKU, on-hand quantity, 30-day velocity, days of cover, and suggested purchase quantity. Put the most urgent SKUs at the top.
Append the same rows to a Google Sheets tab called Reorder Log using Google Sheets Append Values, one row per SKU with columns for date, product name, SKU, on-hand quantity, 30-day velocity, days of cover, and suggested purchase quantity. Rows should always append to the end of the existing table so the ops team keeps a full audit history of every reorder recommendation the workflow has made.
If Get Low Stock Items returns no SKUs, still post a short Slack confirmation for the day ("No products below reorder threshold this morning") and skip the Google Sheets append.
What it does
- Pulls every Adobe Commerce product that is at or below its reorder threshold each weekday morning.
- Looks at the last 30 days of sales for each low SKU to work out how fast it is actually moving.
- Uses AI to rank the list by days of stock remaining and suggest a purchase quantity per product.
- Posts the ranked reorder plan to a Slack channel and appends the same rows to a Google Sheets log so ops has an audit trail.
What you’ll need
- An Adobe Commerce (Magento) store with reorder thresholds configured on the products you want to monitor.
- A Slack workspace and the channel you want the morning reorder alert posted to.
- A Google Sheet named something like Reorder Log with columns ready for SKU, quantity on hand, sales velocity, days of cover, and suggested reorder quantity.
How to customize it
- Change the schedule if 9am on weekdays does not match your buying rhythm — daily, twice a week, or a different hour all work.
- Adjust the sales window from 30 days to something shorter for fast-moving inventory or longer for slow sellers.
- Point Slack and Google Sheets at different destinations, or tune the reorder formula (target days of cover, safety stock buffer) to match your purchasing policy.
Use cases
- Notifications & Alerts
- AI Reports
