Daily WooCommerce low-stock reorder report in Slack

Every weekday at 6:00am in my local timezone, generate a smart low-stock reorder report from my WooCommerce store and post it to a Slack channel for the operations team. The trigger is a cron schedule.

Step 1 — Find low-stock products. Call the WooCommerce List Products operation and filter to items that are low or near zero stock (stock_status = 'lowstock' and items where stock_quantity is at or below the product's low_stock_amount, plus stock_status = 'outofstock' so we surface anything already at zero). Only include published, in-catalog products. Page through the results until all matching products are collected.

Step 2 — Compute sales velocity for each affected SKU. For each low-stock product, use the WooCommerce List Orders operation to pull orders from the last 30 days with status of 'processing', 'completed', or 'on-hold' (so we count real demand, not cancelled or refunded). Sum the units of that SKU sold across those orders and divide by 30 to get a daily sales velocity. Prefer batching by passing a date filter and iterating, rather than one request per product.

Step 3 — Derive the reorder recommendation. For each product, compute days_of_stock_remaining = current stock / daily velocity (treat zero velocity as 'no recent sales — skip from urgent list'). Compute recommended_reorder_qty = ceil(daily velocity × 30) − current stock, floored at 0. Flag any product with days_of_stock_remaining under 14 as urgent. Exclude products with zero sales in the last 30 days from the urgent list so we don't alert on slow movers.

Step 4 — Post the report to Slack via the Slack Bot Send a Message operation. Ask me for the destination channel during setup. The message should be a ranked table sorted by days_of_stock_remaining ascending (most urgent first), with columns: SKU / product name, current stock, daily sales velocity (rounded to 1 decimal), days remaining, and recommended reorder quantity. Use Slack mrkdwn formatting with a clear header like ':package: Low-stock reorder report — <date>', call out the count of urgent items at the top, and visually mark urgent rows (for example with a 🚨 prefix). If nothing is urgent, post a short 'all clear' message instead so the team knows the workflow ran.

Keep slow movers (zero recent sales) out of the urgent section but optionally include them in a small collapsed 'low stock, no recent sales' footer so they are still visible without being noisy.