Category manager / merchandising analyst
Owns category results: what to keep, widen or drop, how much stock to hold and at what price to sell.
About the role
The category manager, or merchandiser-analyst, is responsible for the category’s result: what to keep in the assortment, what to expand, what to remove, what stock to hold and at what price to sell. The unit of management is not a single model but the category as a portfolio of items: some bring the main margin, others attract traffic, still others are for image.
The role needs the ability to split the assortment into classes (ABC and by sales speed), see price tiers and the position of one’s price in the market, count cannibalization (when a new model eats the sales of its neighbor) and choose analogs. The manager also answers for sizes: the core of the size run sells faster than the edges, and an error here returns as returns. A separate area is card quality and master data, because the category knows which attributes a product must have.
A good category manager thinks in roubles of contribution and stock turnover, not in the number of models.
A working day
The day begins with the category report: sales, margin, stock, full-price share. Then review of items at the extremes: what sells out too fast (risk of an empty shelf), what stands still. In the afternoon the category manager discusses novelties and reorders with the buyer, promotions with marketing, availability with logistics. In the evening checks cards and monitoring of competitor prices.
Documents: the assortment matrix, the classifier and product cards, ABC and size reports, market price analysis, the category purchase plan, lists of items to delist and to add, data on returns and causes.
Typical decisions
- Which items to expand, reduce and delist from the line.
- How many models, colors and sizes to hold so that width does not eat margin and card labor.
- Which price tiers to cover and where price positioning should change.
- What to replace a delisted item with and how not to lose the customer.
- Which size curve to build in and how to use return data by size.
- Which attributes and references are mandatory for a card to pass platforms and labeling.
Study path
- Assortment: width, depth, classes and category roles. Range: width, depth and price tiers
- ABC classes of items: which give the main contribution and which drag stock. ABC analysis of the range
- GMROI shows the margin return on category stock. GMROI: gross profit per unit of stock
- Cannibalization: count how many sales a novelty takes from neighbors. Net effect of a new item: cannibalization
- Master data: the model, colorway, SKU levels and attribute references. Master data: SKU, SKU, barcode
- SKU count and card labor: the price of assortment width in hours and roubles. SKUs, barcodes and the labor of product cards
- Card data quality: completeness, uniqueness, validity, timeliness. Data quality and data owners
- The assortment plan document consolidates the order and decisions of this role. Assortment matrix and assortment plan
- Range and sizes: ABC by contribution, the size curve and the collection mix. Assortment and sizes
- Collection and range: width and depth, sample cost and the season mix. Collection and range
- Discounts, promotions and exit price: when and by how much to cut the price so the right stock remains by the date. Markdown and exit price
- Sizes, stores and range in the season: the size run, clusters and the net effect of a new item. Size runs, stores and range in season
What to understand
- Category contribution
- A category is judged by contribution to revenue and margin, stock turns and GMROI, not by revenue. A large slow category can eat cash.
- ABC and item classes
- ABC splits items by contribution and exposes the tail that does not sell. Classes drive decisions: where depth, where delisting.
- Bestsellers and low sellers
- A bestseller and a low seller are defined relative to the category and period, not by an absolute number. Set the rule in your own data and record it.
- Price tiers and price position
- Price tiers (base, better, best) and market position decide who buys you. Competitor price monitoring gives position, but compare like with like.
- Cannibalization and analogs
- A new style can take sales from a neighbor. Net effect is category growth, not the new style sales.
- Sizes and the core
- The size curve and core sizes answer which sizes to hold deep. A broken run on a selling style is lost sales.
- Classifier and attributes
- Category analytics rests on unified category and attribute reference books. A wrong category in a card spoils every report.
- Categories in contribution roubles
- Contribution to growth and category margin, this year against last, show where development goes. Separate the mix effect from the margin rate effect.
- Style classes
- Bestsellers, lowsellers and no-sale styles need different decisions: reorder, top-up, promotion, delisting. Classify by ABC and sell-through together.
- New styles and carry-over
- The share, yield per style, sell-through and margin of the two groups are compared separately. This is the basis for next collection depth.
- Price monitoring and top-up
- Price position to market and top-up rules by size curve link range with availability. Defects count separately as a category loss.
- Category roles
- A category can be a traffic magnet, a profit core or an image builder. The role sets the margin goal, depth and allowed discount; judging by margin alone breaks the range.
- Sizes and size returns
- A size recommendation tool pays back only when size returns are significant. Estimate the share of such returns and their handling cost first, then decide.
- Card quality and master data
- Attribute completeness (category, size, color, composition) drives search, filters and reports. One size spelled differently splits the stock into parts.
Key measures
| Measure | Formula | How to read |
|---|---|---|
| Category share of revenue and margin | Category revenue ÷ total revenue; margin likewise | A gap between revenue and margin shares flags a problem category. |
| Category GMROI | Category gross profit ÷ average stock at cost | Compare across categories. |
| Category sell-through | Units sold ÷ units received | Read together with discounts. |
| Price position | Your price ÷ market median on comparable styles | No standard norm: decide by brand strategy. |
| Net effect of a new style | New style sales − lost sales of neighbors | A positive effect means the category grew. |
| Width and depth | Number of styles; units per style | Match against the budget and target stock. |
| Category contribution to growth | Category revenue change ÷ brand revenue change | A positive contribution with falling margin needs explaining. |
| Bestseller, lowseller and no-sale shares | Styles of a class ÷ all category styles | A rising no-sale share is a signal to narrow width. |
| Yield per style: new versus carry-over | Group revenue ÷ number of styles in the group | Compare with group margin, not revenue alone. |
| Card completeness | Filled required fields ÷ all required fields | Define required fields by the reports that need them. |
| Size-return share | Returns for size reasons ÷ all returns | A high share makes size recommendation and size charts worthwhile. |
Questions the role asks
- Which items bring revenue and which pile up in stock? ABC analysis of the range
- Which category to widen and which to trim? Post-season review by category, GMROI: gross profit per unit of stock
- Where is our price versus the market? Price position among competitors, Price tiers: good, better, best
- What will a new style add after cannibalization? Net effect of a new item: cannibalization
- How to forecast a new item with no history? Forecast of a new item from analogs
- Are our product categories tagged correctly? Product classifier check
- What did last season show by category? Post-season review by category
- How much money is in leftovers and how much margin does each collection role give? Collection mix: core, fashion, image
- Which category drove growth and which lost margin? Categories: contribution to growth and margin, this year versus last
- Which styles to reorder and which to drop? SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
- Are we pricier or cheaper than the market? Price monitoring by SKU: index to the market, position and price-scraping freshness
- Which role should each category have and what is its goal? Category roles: traffic driver, profit core, image
- Will a size recommendation tool pay back? Size recommendation: payback of the tool
Route through Lab
- Range: width, depth and price tiers
- ABC analysis of the range
- Post-season review by category
- GMROI: gross profit per unit of stock
- Width and depth: budget, models and pieces
- Price tiers: good, better, best
- Price position among competitors
- Net effect of a new item: cannibalization
- Forecast of a new item from analogs
- Size-run completeness and core sizes
- Product classifier check
- Footwear returns: reasons, reverse logistics, the share back on sale and the loss
- Season results: brand, category, SKU
- Categories: contribution to growth and margin, this year versus last
- SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
- New and carryover: share, return per SKU, sell-through and margin
- Working with stock: transfers, top-up, defects, prices, order entry
- Price monitoring by SKU: index to the market, position and price-scraping freshness
- Replenishment by size: what and how much to send to stores by size
- Defects: losses, supplier recovery and a reserve
- Season results of a brand and a category
- Category roles: traffic driver, profit core, image
- Size recommendation: payback of the tool
- Master data: SKU, SKU, barcode
- SKUs, barcodes and the labor of product cards
- Completeness and quality of product master data
- Assortment and sizes
- Collection and range
- Markdown and exit price
- Size runs, stores and range in season
- Buying plan from revenue backwards: revenue → cost → order
- Cost of assortment complexity: the SKU tail
- Size demand corrected for stock-outs
- Buy budget allocation by marginal return
- Reference sell-through curve: season-end projection and gap
- Markdown grid: when and how deep
- Price-cut trigger rules by item
- Promo item selection under a margin-loss budget
First 30 days
- Open the season topic and split categories year on year. Categories: contribution to growth and margin, this year versus last
- Classify styles by ABC and sell-through. SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
- Compare new styles with carry-over. New and carryover: share, return per SKU, sell-through and margin
- Check price position to market. Price monitoring by SKU: index to the market, position and price-scraping freshness
- Check top-up rules. Replenishment by size: what and how much to send to stores by size
- Read the category and attribute references. Category reference book (tree)
- Assign category roles and check the goals. Category roles: traffic driver, profit core, image
- Check card completeness. Completeness and quality of product master data
- Assess whether size recommendation is needed. Size recommendation: payback of the tool
Common mistakes
- Widening a category by revenue without checking turns and margin.
- Defining a low seller by one absolute unit count across categories.
- Comparing price with non-comparable competitor styles.
- Judging a new style by its sales and forgetting the neighbors.
- Explaining category growth by turnover without isolating the mix effect.
- Treating defects as operational noise rather than a category loss.
- Judging all categories by one margin goal regardless of role.
- Keeping sizes and colors as free text without a reference book.
Reports to keep
- Category report: Revenue, margin, turns, discounts, stock by category.
- SKU report: Sales, stock, sell-through, stock age by item.
- Carryover report: Carry-over style sales and stock carried between seasons.
- Season results: Review of the past season by category and style.
- Category report: Category contribution to revenue and margin, discounts, stock, year on year.
- SKU report: Category styles with class, speed and stock.
- Carry-over report: Category carry-over: what to keep.
Data to keep
- Product attributes: category, size, color, composition. PLM and production records; ERP and accounting system
- Size and color reference. PLM and production records
- Stock by size. Warehouse and stock system; ERP and accounting system