MYTH #4: I can localize my merchandise by clustering based on store attributes
TRUTH: Grouping stores together seasonally based on store size, geography or sales performance will only deliver average results at best. Retailers can hone the localization of their stores with intelligent clustering at lower levels of merchandise including merchandise attributes and the actual current performance of products.
Clustering stores that performed in similar ways still perpetuates the problems associated to the use of aggregated data. Instead of pretending you have, say, 1,000 stores that all perform alike, you now pretend that in each of maybe 10 different store groups, you now have around 100 homogeneous stores. The reality we know is that every store performs differently. Though it is not realistic to manage the creation of an assortment plan for each of your stores, you can begin to step in the direction of localization by creating merchandise specific clusters that group products together based on their true historical demand (including lost sales).
For example, if your clusters were ranked from A to F by volume of sales per category, one store could be an A level in women’s jeans. However, if you went one level lower to womens fashion jeans or even lower to womens fashion jeans by True Religion, for example, you could see that store move to an F in fashion jeans but a C in True Religion jeans. By going across the chain and identifying which merchandise performs at which level at each store, you can send a more accurate volume of each product to each store. The more specific you can be by product and attribute cluster, the closer you can get to creating a localized plan for every store in your chain. And the more constantly you update those clusters, by week or month at least, the truer you will stay to actual store demand.
Three major problems to look out for in clustering
With few exceptions, the vast majority of clustering has three major problems associated with the process. These three issues are seriously inhibiting the retailer from truly localizing their stores.
- Clusters are almost always based on historical sales performance alone.
- Clusters are typically locked in for a season or similar time period. If the recent economic climate has taught us anything, it is that store behavior changes and it changes rapidly.
- Clusters that group an entire store are incredibly inaccurate, even clustering by department or category won’t achieve the goal of true localization. Significant value can be gained if stores are clustered at or near the individual product level based on merchandise and location attributes which have been proven to have a direct correlation to product behavior. This must be executed using historical, current and expected product demand.
Plan for future demand, utilize historical demand
Clustering based off history alone is a mistake that almost every retailer makes. But the typical merchandiser does not have much of a choice. History is the only thing that they have at their fingertips on which to cluster. But, this means of clustering misses the quite obvious fact that product performance last year will not equate to product performance this year. It also misses the not so obvious fact that each store likely missed sales opportunities during periods of stock-outs. That’s why history is not the best base for clustering products together. A consideration of expected future behavior must be made alongside a historical adjustment for what could have happened in the past, had the inventory been there to meet demand. Clustering on a trend or, better yet, a forecast at the merchandise level is a better way to cluster products.
Stores are dynamic
The second issue mentioned is that clusters are typically created and locked in for a season or more. An individual store that performed as an A cluster last year during the spring season in women’s tops will be clustered again as an A store for the entire spring season this year. However, we know that store will frequently not repeat the same performance year over year especially with same or similar products across all departments. Stores need to be able to move within a cluster to more closely align their actual performance with unique merchandise.
If stores don’t move with their performance, they aren’t being localized. Stores will underperform and be left with merchandise to markdown or overperform and stock out. If, however, stores actual current product performance defines and modifies the cluster and thereby their merchandise levels and breadth of assortment, these problems are less likely to happen and the store is being localized more effectively. By doing that, we are continuously introducing small amounts of change into the way that products are being assorted into stores, which is more manageable and timely in reacting to the way that customers are really acting in the stores. That’s an incredibly powerful piece of the merchandising puzzle.
The best way for stores to be localized given that it is impractical to expect an individual assortment per store is by having dynamic clusters. The assortment planning process should include a periodic review of each store’s product performance versus the product’s cluster and make a recommendation to move a store to a different cluster or modify it’s depth based on a variety of criteria. This allows merchants to fine tune the assortment that will perform best in a store given the store’s behavior right now, not last year.
Clustering at the merchandise level
The last issue is clustering by attributes or merchandise rather than by merchandise hierarchy alone.Clustering solely on store attributes, geography and demographics misses a significant opportunity for store localization based on how merchandise attributes collectively perform at an individual store.
An example of this can be found in price point. Let’s look at jeans again. If you cluster jeans based on the price tier (for example: A through F by sales volume), the stores that perform best with higher priced jeans would be assigned the A cluster grade within that product category, whereas a store that has mediocre performance for high priced jeans would be given a store grade F, which would equate to a lower level of inventory sent for that price tier – or perhaps even changing how much of that product the store is eligible to carry. This is even more accurate than grouping the stores based on demographics such as income level. Just because a store is in a nicer neighborhood does not mean that higher priced merchandise will sell better in that store. Honestly, if the retailer creates product-specific clusters with stores that actually perform better in the type of merchandise, the demographic information hardly matters!
In Summary
Today, nobody expects every store to receive its own assortment plan. Every store, however, can receive its own localized, unique assortment even when clusters are being utilized.
Recap:
- Cluster on more than just volume and history but include demand, both past and future in the clustering equation.
- Constantly update the store cluster assignments based on actual store behavior.
- Create localized clusters based on how merchandise attributes collectively perform at an individual store.
By following these guidelines, a merchant can have a positive impact on their chain’s performance and will be able to create localized plans for the individual stores.
Beyond clustering, executing at the SKU level: Quantum’s approach
Dynamic SKU level awareness //
Q serves as a comprehensive demand platform for retailers. It calculates demand and selling behavior for each product, at every store individually, and does not dilute the sku/store demand signals through traditional averaging and aggregating techniques. Q dynamically creates unique SKU/store profiles, for topics including seasonality, day of week, time of day, life-cycle, etc., and manages against supply and demand side events and constraints. This enables Q to make the atomic level adjustments necessary to capture extra full prices sales while greatly reducing inventory investment.
Continuous learning //
Unlike other solutions, the value and intelligence of Q constantly improves as Q learns from product behaviors. Item profiles in Q are constantly updated by the system whenever new data is available, allowing it to accurately predict how that product will act with the knowledge of how it has acted before, while taking into consideration how it is acting now. This constant learning is unlike anything offered by other vendors.
Real demand visibility //
Q gives you visibility of the real demand in your stores now. With the understanding of lost sales for every product, Q prevents you from missing opportunities so you can capitalize on every potential sale. Q learns from how your product is moving right now, so you do not need a year’s worth of data to predict how a product will perform. By continuously tracking 35 performance metrics, such as: average demand, average sales, seasonal affects to product life-cycle patterns, shelf life, maximum sales per day, average inventory by date, in stock and in transit, this lets retailers calculate potential consumer activity and demand every day.
Download a PDF of this blog series HERE»
Sign up to receive updates throughout the series.
To learn more about clustering with localization, visit: http://quantumretail.com/2010/08/24/the-profit-lab-clustering-with-localization-in-mind/
Debunking the cluster myth in allocation: http://quantumretail.com/2010/06/04/the-profit-lab-the-cluster-myth/

