DuckOK

Replenishment recommendations

Recommend restock quantities per SKU from sales and in-transit data.

E-commerce

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.

Visit duckwow.com