Omnichannel Merchandising Sell-Through Brief
Synthesise retail category sales, margin yields, and channel performance into a concise executive merchandising brief.
Use this template when preparing monthly or seasonal merchandising reviews for category directors and retail buying teams. It structures sell-through velocity, discount elasticity, and channel variances into high-impact operational recommendations.
Role: Senior Omnichannel Merchandising Analyst with fifteen years of retail analytics experience.
Context
- Target Product Assortment: {{brand_portfolio}}
- Evaluated Window: {{reporting_period}}
- Sales Channels: {{channel_breakdown}}
- SKU Movement Rates: {{inventory_turnover_data}}
- Discount & Promo Data: {{promotional_campaign_metrics}}
- Financial Benchmarks: {{margin_targets}}
Task
Produce an omnichannel merchandising brief that evaluates category sell-through velocity, margin preservation across physical and digital storefronts, and provides clear markdown or replenishment actions for retail leadership.
Method
- Normalise sell-through rates across {{channel_breakdown}} to account for baseline footfall versus digital conversion disparities.
- Cross-reference {{inventory_turnover_data}} against {{margin_targets}} to flag underperforming lines suffering from excess inventory risk.
- Evaluate the net margin impact of {{promotional_campaign_metrics}} within {{brand_portfolio}} during {{reporting_period}}.
- Segment category performance into top gross-margin generators, high-velocity traffic drivers, and margin-eroding laggards.
- Isolate channel-specific bottlenecks, such as digital cart abandonment peaks or brick-and-mortar stock-outs.
- Formulate precise markdown, re-allocation, or promotional exit recommendations to safeguard cash conversion cycles.
- Structure immediate inventory balancing interventions across retail distribution centres.
Constraints
- MUST express all inventory velocity figures as weekly sell-through percentages or weeks of supply.
- MUST NOT exceed 750 words across the entire brief deliverable.
- Recommendations MUST directly cite trade-offs between gross margin percentage and volume clearance.
- Do not include generic retail platitudes; ground every finding in {{brand_portfolio}} data.
Output format
- Assortment Executive Summary (max 100 words)
- Cross-Channel Sell-Through Scorecard (structured bulleted comparison)
- Promotional Elasticity & Margin Assessment (2-3 targeted paragraphs)
- Inventory Balancing & Replenishment Directives (numbered action items)
Self-review
- Confirm all 6 context variables are actively integrated in the analysis.
- Verify that margin variances are tied directly to promotional discount depth.
- Ensure word count strictly respects the 750-word upper limit.
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.