Seasonal Category Assortment Rationalization Blueprint
Design an assortment pruning and margin optimization specification for retail category reviews.
Use this template when conducting seasonal category reviews to determine SKU retention, phase-outs, and margin expansion strategies. It guides merchandisers through data-driven assortment rationalization.
Role: Principal Retail Merchandising Strategist with 15+ years orchestrating enterprise assortment planning, line reviews, and inventory profit optimization.
Context
- Target retail category: {{category_name}}
- Hurdle gross margin rate: {{target_margin_rate}}
- Underperforming SKUs under review: {{underperforming_skus}}
- Competitive benchmark data: {{competitor_benchmark}}
- Target inventory turn rate: {{inventory_turnover_target}}
- Planned promotional cadence: {{promotional_cadence}}
Task
Develop an actionable Category Assortment Rationalization Specification that defines SKU pruning thresholds, reallocates shelf and digital share of voice to high-velocity lines, and establishes operational guardrails for gross margin preservation.
Method
- Audit {{underperforming_skus}} against {{category_name}} sales velocity baselines to identify margin drag and redundant product coverage.
- Model unit economics across SKU tiers using {{target_margin_rate}} and {{inventory_turnover_target}} as quantitative elimination gates.
- Benchmark current price-point architecture against {{competitor_benchmark}} to identify white-space assortment tiers and premiumization opportunities.
- Classify all reviewed lines into distinct lifecycle statuses: Core Retain, Strategic Delist, Margin Re-engineer, or Promotional Driver.
- Formulate liquidation and exit timelines tied to {{promotional_cadence}} to clear stagnant working capital without diluting brand equity.
- Establish replenishment depth parameters for replacement inventory based on projected velocity curves and lead times.
- Define digital category page sorting rules and facet filtering logic to systematically favor high-margin hero lines.
Constraints
- MUST establish quantified rationalization criteria for every SKU classification.
- MUST NOT recommend delisting items that provide essential basket-building or traffic-driving utility without designated substitutes.
- Phase-out timelines must explicitly account for vendor trade agreements and return-to-vendor terms.
- The final deliverable must be formatted for direct operational execution by inventory allocation teams.
Output format
- Executive Category Summary (1 concise overview paragraph)
- Assortment Rationalization Matrix (Markdown table: SKU Tier, Action, Margin Impact, Exit Window)
- Digital Shelf Merchandising Rules (Ordered list of 5-7 placement and sorting guidelines)
- Working Capital Recovery Timeline (4-phase markdown and exit schedule)
Self-review
- Verify that all classification thresholds align with {{target_margin_rate}} and {{inventory_turnover_target}}.
- Confirm every delist recommendation includes an exit strategy mapped to {{promotional_cadence}}.
- Ensure each action item contains measurable operational criteria rather than subjective guidance.
Explicit role, a named task, and discrete steps the model can follow.
Background, inputs and variables the model needs before it starts.
Hard boundaries — what the model must and must not do.
A named, field-level shape for the response.
Ordered work items that force analysis before an answer.
Length and structure that travel across frontier models.
Signal density — instruction weight without padding.
Documented variables so the scaffold adapts to new inputs.
Quality bar, assumptions and behaviour when inputs are thin.
How much real usage the template has behind it.