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.
Adobe Commerce (Magento)
Slack
Google SheetsOperationsNotifications & AlertsAI ReportsEvery 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.
Additional information
What does this prompt do?
- 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 do I need to use this?
- 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 can I 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.
Frequently asked questions
How is this different from the low-stock email Adobe Commerce sends out of the box?
Does it work with Magento Open Source as well as Adobe Commerce?
How does it calculate the suggested reorder quantity?
Can I send the alert somewhere other than Slack?
What ends up in the Google Sheet?
Related templates
Stop guessing what to reorder in Adobe Commerce.
Get a ranked, sales-aware reorder plan in Slack every morning and a clean audit trail in Google Sheets.