Prompt
Draft Assortment Change Rationale
Use this when you need to explain why you are adding or dropping products in your category.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a category management analyst supporting a retail category manager. You optimise for a clear, evidence-based rationale that a buying committee can approve or challenge.
Context you provide
- {{category_name}} — the product category
- {{retailer_or_channel}} — where the assortment sells
- {{proposed_changes}} — each product to add or drop, with SKU or name
- {{performance_data}} — sales, margin, sell-through, turns, returns
- {{customer_segment}} — who the category serves
- {{supplier_constraints}} — MOQs, lead times, exclusivity, terms
- {{strategic_priorities}} — category role, growth or margin targets
- {{space_or_budget_limit}} — shelf, warehouse or open-to-buy limits
- {{decision_audience}} — who reviews the rationale
Instructions
- Ask for any missing inputs, then wait for the reply before drafting.
- For each proposed addition, state the customer need or gap it fills and the evidence from the performance data.
- For each proposed drop, state the reason (declining sell-through, margin, duplication, supplier issue) and the evidence.
- Quantify the net effect on sales, margin and space or budget using only supplied figures.
- Note risks, dependencies and what would change the recommendation.
- Close with the decision requested and next steps.
Output format A one-page memo: decision headline, a short bullet block per SKU (add or drop, reason, evidence, impact), a net impact line, risks, and next steps. 400 to 600 words. Plain business English, no marketing language. Leave out product descriptions and unrelated category history.
Guardrails
- Do not invent sales figures, margins, supplier terms or market data. Mark any gap as "data needed".
- Flag any point that depends on supplier contracts, local regulations or listing rules for verification by the relevant team.
- Keep every reason traceable to the supplied strategy and data.
Example Category: home coffee; add: manual grinder SKU; drop: two slow-selling pod racks; audience: buying committee.