Browse All

How to Scale Your Category Reviews When Your Assortment Doubles

How to Scale Your Category Reviews When Your Assortment Doubles

Written by

Linda George

Solutions Consultant

Table of contents

Category

Learning Series

How to Scale Your Category Reviews When Your Assortment Doubles



The merch team reorganized and you came out of it owning a division.

‍

Eight categories now, where you used to own two. Same monthly review, same room, same people asking how it is trading. What changed is that you can no longer answer the way you used to, which was to simply know the products.

‍

With two categories you knew them. You could name the top ten styles in each, say which one was soft, and say why. Eight categories is several hundred choices, and nobody knows several hundred choices. So you do what everyone does in the first few months. You present the category number.

When a Blended Category Number Stops Describing Your Business

The category number is an average across businesses that do not behave alike.

‍

Your ecommerce channel and your stores have different sell-through curves, different size profiles, and different return rates. Wholesale is different again. Blend them into one figure and it describes none of them.

One category, three different businesses

Year-over-year sales change, blended vs. split by channel

Categoryblended

+4%

Ecommerce

+17%

Stores

−3%

Wholesale

−2%

The blend says up four. The channels say one is growing fast and two are shrinking.

Illustrative data

That blend hides four things worth naming:

  1. A channel growing fast enough to carry a category that is otherwise flat.
  2. A channel shrinking under cover of the category's total.
  3. Inventory sitting in the wrong channel for where the demand actually is.
  4. A return rate concentrated in one channel, dragging net sales while gross looks fine.

None of that shows up until someone splits it. And when your business was ninety percent stores, the blend was close enough to true that it did not matter. At forty percent ecommerce it is not an approximation. It is a different number.

The Blend Survives Until the First Direct Question

You present the category as up four. Someone asks whether that is stores or online. You do not know, and now the rest of your read is in question too, including the parts that were right.

Scrolling the Plan is Not a Read

The instinct is to open the plan and look at products. Three hundred rows sorted by sales tells you the top sellers, which you mostly knew. It does not tell you where the category is heavy, because the products with the most inventory are rarely the ones with the most sales, and no single sort shows you both.

Asking the Planner Don’t Scale

It works for one. Do it eight times before every review and you have spent two days of someone else's week assembling a story you are going to tell in twelve minutes.

Preparing a Category Read You Can Defend

The goal is not to know every product again. It is to know the shape of each category well enough that no reasonable question catches you flat. Five checks, and you can run all of them in Excel.

Split By Channel Before You Say a Number Out Loud

Every figure you plan to present gets split first. If the channels disagree, that disagreement is the story, and it is a better story than the blended one.

Read Top Down and Stop Where the Story Changes

Division, then department, then category, then class. At each level look at which child is gaining or losing share. Stop descending when you find the level that explains the movement. Starting at product means getting lost in three hundred rows before you know what you are looking for.

Compare the Sales Picture Against the Inventory Picture

This is the check that finds money, and it is the one most people skip because it takes two passes instead of one:

The Trapped Money Test

Rank the category's products by sales, then rank the same products again by units on hand. The names near the top of the second list and the bottom of the first are where your capital is stuck. That gap is working capital you can free without making a single new decision about what is selling.

Same products, ranked two ways

Where the sales list and the stock list disagree, capital is stuck

By salesBy units on hand

Classic Crew Tee1

Slim Chino2

Linen Shirt3

Fleece Pullover4

Denim Jacket5

Cargo Short6

Quilted Vest7

Wool Overshirt8

1Quilted Vest

2Wool Overshirt

3Classic Crew Tee

4Cargo Short

5Slim Chino

6Linen Shirt

7Fleece Pullover

8Denim Jacket

Bottom of the sales list, top of the stock list: working capital you can free without a new buying decision.

Illustrative data

Look At Returns At The Category Level, Not Just The Company Level

A category can look healthy on gross sales and be a genuine problem on net. Return rate concentrated in one category, or one channel inside it, is invisible in a company-wide figure and obvious in a category-level one.

Walk In Knowing the One Product That Explains the Number

Whatever the category did, some small group of styles did most of it. Know which ones and be ready to name them. The question after "how is it trading" is always "what is driving that," and an answer with a style name in it lands differently than an answer with a percentage in it.

Those Five Checks are The Whole Discipline

And they aren’t hard. They are just five checks times eight categories times channel splits, every month, which is where they quietly stop happening.

Why the discipline breaks down

5checks
×
8categories
×
3channels
=
120cuts / month

What gets dropped first

Drops 1stChannel split

Doubles or triples the work

Drops 2ndInventory rank

Needs a second pass on the same data

What's leftBlended number

The one you started with

The first thing to go is the channel split, because it doubles or triples the work. The second is the inventory ranking, because it needs a second pass on data you already looked at once. What is left is the blended number you started with.

Toolio gives you any level of the hierarchy already assembled, filtered to a channel, with the products sized by sales or by inventory so the trapped-money comparison is a toggle rather than a second export, and the drill from division down to a single style keeps your place on the way back up.

Relevant Blog Posts