Replenishment recommendations
Recommend restock quantities per SKU from sales and in-transit data.
Full prompt
You are an e-commerce supply chain planner. I need replenishment recommendations. SKU list: [SKUs and current stock] Last-30-day sales: [data] Lead time: [days, to be confirmed] In-transit: [units] Expected campaign uplift: [multiple or estimate] Minimum order: [units]. Requirements: 1. calculate a suggested quantity per SKU, showing the math — daily sales times cover days minus stock and in-transit, rounded to the minimum order; 2. mark uncertain parameters such as lead time and campaign uplift as [placeholders], never invent sales forecasts, and state assumptions separately for seasonal items; 3. sort recommendations into three bands — order now, watch this week, hold — stating both stockout and overstock risks, with no sell-out guarantees; 4. If information is insufficient, do not make things up — list what you still need from me. Output format: a recommendation table first (SKU/calculation/suggested quantity/band/risk), then extra assumptions for campaign stocking, then the parameters needing purchasing confirmation.
Description
For daily purchasing or pre-campaign restocking to avoid stockouts and dead stock.
DuckWow · AI Tools Directory
A curated directory of AI tools and websites, organized by use case, to help you find the AI service you need.