1. Pull stock from each channel. Shopify storefront, Amazon Seller Central, Fulfil or your WMS. Whatever channels carry the SKU, the flow connects to each one.
2. Standardize the SKU. Normalize casing, strip channel prefixes, and map between code systems so the same SKU lines up across rows.
3. Join on SKU. One row per SKU with one column per channel. Plus the reorder threshold from your master table.
4. Compare against threshold. Flag any SKU below its reorder point, with the gap in units and days of cover.
5. Push the alert. A Slack message to your planning channel with the flagged SKUs, sorted by urgency.
6. Run on a schedule. Hourly during peak, daily off-peak, or on a trigger when a channel finishes syncing.