Daily Amazon FBA Restock Alert in Slack | Velocity-Aware Inventory Check

Every weekday morning at 8am in my local time, run a low-inventory check across my Amazon FBA SKUs and post a prioritized restock alert to Slack. The agent should reason about which SKUs matter most rather than dumping a flat table.

Trigger: cron, Monday through Friday at 8:00 AM local time.

Step 1. Call Amazon Seller Partner Get Inventory Summaries (FBA Inventory v1) to retrieve fulfillable, inbound, reserved, and unfulfillable quantities for every active SKU. Default marketplace is North America (ATVPDKIKX0DER); let me change this during setup if I sell in Europe or the Far East.

Step 2. Call Amazon Seller Partner Search Orders (Orders v2026-01-01) for the trailing 30 days. Aggregate units sold per SKU across the order line items and divide by 30 to get an approximate daily sales velocity. Skip SKUs with zero sales in the last 30 days from the days-of-cover ranking.

Step 3. For each SKU with non-zero velocity, compute days of cover as fulfillable units divided by daily velocity. Bucket the SKUs: Urgent if under 10 days of cover, Restock Soon if 10 to 21 days of cover. SKUs with more than 21 days of cover should be ignored.

Step 4. Reason about prioritization before writing the message. Rank the Urgent bucket by highest daily velocity first, since those SKUs cost the most in lost sales if they go out of stock. If a SKU already has enough inbound units to cover the 21 day window, note that inbound coverage in the line item and drop it lower in the ranking. If a SKU's recent 7-day velocity looks meaningfully higher than its 30-day average, call that out as a spike.

Step 5. Call Slack Bot Send a Message to post a single summary to the channel I configure (default: #ops-inventory). The top-level message should be a short headline like 'Daily Amazon FBA restock alert: 3 urgent, 7 restock soon'. Then post threaded replies, one for each bucket (Urgent first, then Restock Soon). For every SKU show: SKU, product title, current fulfillable units, daily velocity (units/day), days of cover, and inbound quantity already on the way. Keep the formatting clean with Slack markdown.

Step 6. If no SKUs land in either bucket, post a single message 'All FBA inventory healthy. No restock action needed today.' so I know the check ran, and stop.

Use the slackbot integration (not the user Slack integration), since this is workspace automation that should keep working even if I leave the org.

Additional information

What does this prompt do?

Pulls your current fulfillable, inbound, reserved, and unfulfillable stock from Amazon Seller Central every weekday morning at 8am.
Estimates how fast each SKU is actually selling using your last 30 days of orders, so the alert reflects real demand, not a flat threshold.
Flags SKUs with under 21 days of cover as restock soon and under 10 days as urgent, factoring in any units already inbound.
Posts one ranked Slack summary, grouped into Urgent and Restock Soon buckets, so you know what to reorder first without opening Seller Central.

What do I need to use this?

An Amazon Seller Partner account with access to FBA inventory and orders.
A Slack workspace and a channel where the alert should post.
A few minutes to pick the channel and confirm the days-of-cover thresholds match your reorder lead time.

How can I customize it?

Change the time it runs or the days of the week, for example to include weekends or to run twice a day.
Adjust the urgent and restock-soon thresholds to match how long your supplier or 3PL takes to ship in new units.
Send the alert to a different channel, multiple channels, or as a direct message to whoever owns purchasing.

Frequently asked questions

Does this work for non-FBA inventory?

No. This prompt is built around Amazon's FBA inventory data. If you fulfill orders from your own warehouse, the days-of-cover calculation would need to point at your own stock system instead.

What happens if a SKU has zero sales in the last 30 days?

Those SKUs are skipped from the days-of-cover ranking, since there is no velocity to divide by. They will not appear in the alert so you do not get noise on slow movers.

Will the alert still post if everything is fine?

Yes. You get a short all-healthy note so you know the check actually ran. You can turn that confirmation off when the workflow is generated.

Can I send this to more than one Slack channel?

Yes. After the workflow is generated you can fan out the same summary to additional channels or DM specific people on the purchasing team.

Which Amazon marketplace does it use?

It defaults to North America. If you sell primarily in Europe or the Far East, you can pick the matching marketplace during setup and the workflow will pull inventory and orders for that region.