Digital Merchandising Product Strategy Optimizer
Analyze product portfolios and optimize digital assortments with data-driven category strategies
What You Can Do
You can upload sales data, margin metrics, and customer behavior patterns to uncover hidden performance trends across your product portfolio. Claude analyzes sales velocity, margin contribution, and customer engagement to surface optimization opportunities—identifying which SKUs to promote, bundle, or rationalize. The skill generates actionable category strategies, reorder rate analysis, and competitive positioning recommendations tailored to your digital channels and seasonal opportunities.
Features
Analyze sales velocity, margin contribution, and customer engagement metrics to rank products by strategic value
Identify gaps, overlaps, and redundancies in your product mix and recommend ideal assortment size
Discover product combinations that increase average order value and basket size
Surface traffic-driving products and secondary items that boost conversion and customer lifetime value
Create targeted merchandising plans aligned with seasonal demand patterns and promotional calendars
Map your product mix against competitor offerings to identify differentiation opportunities
Segment products by repeat purchase behavior and develop loyalty-building strategies
Generate prioritized action plans with expected impact on conversion, AOV, and inventory turnover
Example Output
Input: Monthly sales data for a women's athletic apparel category with 127 SKUs, including units sold, revenue, margin %, and repeat purchase rates.
Output:
- Portfolio Health Score: 73/100 — 12% of SKUs underperform and represent 8% of category revenue
- Rationalization Recommendations: Discontinue 8 low-velocity items with <2% repeat rates; consolidate 6 redundant color variants
- Hero Products: Sports bra styles drive 34% of category traffic; recommend homepage placement and cross-sell with leggings
- Bundle Opportunities: Pairing running shorts + compression socks increases AOV by ~18%; recommend "Complete Your Run" bundle
- Seasonal Strategy: Shift 23% of inventory to lightweight fabrics Q2; promote moisture-wicking technology during summer months
- Quick Wins: Feature top 15 products on category landing page; expect 6-8% conversion lift
What's Included
- SKILL.md instruction file with performance analysis framework:
- Portfolio Analysis Template: SKU scoring matrix, velocity thresholds, and margin contribution breakdown
- Category Strategy Worksheet: Seasonal planning calendar, assortment mapping, and competitive benchmarking
- SKU Rationalization Checklist: Criteria for discontinuation, consolidation, and hero product identification
- Cross-Sell & Bundle Framework: Product affinity analysis template and promotional strategy guide
Who It's For
- Digital Merchandisers — Analyze product portfolios and develop category strategies for e-commerce platforms
- Category Managers — Optimize assortments, rationalize SKUs, and align inventory with sales performance
- E-Commerce Managers — Improve conversion rates, AOV, and inventory turnover through data-driven product decisions
- Retail Analysts — Support strategic planning with product performance insights and competitive positioning
- Merchandising Directors — Develop seasonal campaigns and promotional strategies backed by product analytics
Best For
- Portfolio audits and SKU rationalization planning
- Category assortment optimization for digital channels
- Seasonal merchandising strategy development
- Cross-sell and bundling opportunity identification
- Competitive product mix positioning and analysis
- Reorder rate and customer lifetime value assessment by product segment
You might also like
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
by cowork-os
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os
You develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
by cowork-os
You can systematically analyze vendor quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
by cowork-os
You can quantify how customer segments respond to different discount depths and promotional timing by analyzing historical sales data. This skill helps you forecast demand under various discount scenarios, identify which product categories or customer groups are price-elastic versus price-inelastic, and recommend optimal promotional calendars that balance revenue maximization with efficient inventory clearance without training customers to expect constant discounts.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os