Daily Amazon FBA restock alert in Slack

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.