Store Clustering for Apparel Brands: How to Group Locations for Smarter Planning and Allocation

What store clustering solves

Store clustering is the practice of grouping retail locations into clusters based on shared demand characteristics — so you can plan localized assortments at the cluster level rather than at each individual store.

The alternative approaches both have problems:

• →One assortment for all stores: Simple to plan but ignores real demand differences. Your urban flagship and your suburban outlet have different customers, different price sensitivity, and different size distributions. Treating them the same guarantees excess in one and stockouts in the other.
• →Unique assortment per store: Perfectly localized but impossible to plan at scale. If you have 20 doors, you can't build 20 unique assortment plans, 20 OTB budgets, and 20 allocation models.

Clustering sits in the middle: group stores with similar demand patterns together, plan at the cluster level, then allocate within clusters based on volume.

Clustering approaches

Approach 1: Volume-based clustering (simplest)

Group stores by sales volume into 3 tiers:

• →Tier A (top 20% by revenue): Widest assortment, deepest inventory, first to receive new styles
• →Tier B (middle 50%): Core assortment, moderate depth
• →Tier C (bottom 30%): Narrower assortment, shallow depth, last to receive seasonal newness

Pros: Simple, easy to implement, requires no customer data analysis.

Cons: Ignores why stores perform differently. A Tier B store in an urban market and a Tier B store in a suburban market may have the same revenue but need very different assortments.

Approach 2: Demographic clustering

Group stores by customer demographics:

• →Urban professional: Higher price point tolerance, smaller sizes, trend-forward
• →Suburban family: Mid-price, full size range, classic styles
• →College/young adult: Lower price point, trend-driven, fast-turning fashion
• →Tourist/resort: Seasonal peaks, broader size range, impulse purchases

Pros: Captures real differences in customer behavior.

Cons: Requires customer data analysis. Demographic assumptions can be wrong.

Approach 3: Demand-pattern clustering (most accurate)

Group stores by actual sales data patterns:

1. →Pull sell-through by category by store for the last 2–4 seasons
2. →Identify which stores sell similar category mixes at similar rates
3. →Group stores with correlated demand patterns

Two stores with correlated demand — even if they're in different cities — should be in the same cluster. A store in downtown Seattle and a store in downtown Portland may share more demand characteristics with each other than either shares with a suburban store in its own metro area.

Pros: Based on actual behavior, not assumptions.

Cons: Requires data analysis (but it's not complicated — correlation analysis in Excel works fine for 10–30 stores).

Approach 4: Hybrid clustering

Combine volume + demand pattern + strategic importance:

| Cluster | Volume | Demand pattern | Strategic role | |---------|--------|----------------|----------------| | Flagship | Top 10% | Full category | Brand experience, test new concepts | | Urban core | Mid-high | Trend-forward, smaller sizes | Drive full-price sell-through | | Suburban core | Mid | Classic + trend, full size range | Volume driver | | Outlet/off-price | Varies | Carryover + excess | Margin recovery |

This is the most practical approach for growing brands with 10–30 stores.

How clustering changes your planning

Assortment width by cluster

• →Flagship: 100% of assortment
• →Urban core: 80% — exclude extreme price points and niche categories
• →Suburban core: 70% — focused on proven categories and core styles
• →Outlet: 40% — carryover styles, markdown inventory, core basics only

Size curve by cluster

Size demand varies by location. Urban stores typically skew smaller (XS/S/M). Suburban stores have a flatter distribution. Outlet stores may skew toward extreme sizes (what's left from other clusters).

Build cluster-level size curves from sell-through data. This alone can reduce size-based excess by 10–15%.

Depth by cluster

Higher-volume clusters get deeper inventory per style. Lower-volume clusters get narrower assortment with moderate depth. The relationship should be inverse:

• →Flagship: Wide assortment, moderate depth (showcase breadth)
• →Suburban core: Narrower assortment, deep inventory (focus on what sells)

Allocation logic

Initial allocation follows cluster rules. In-season reallocation (transfers between stores) should happen within clusters first — a transfer from one urban core store to another urban core store is more likely to sell than a transfer from urban core to outlet.

Getting started with 10–20 stores

Step 1: Pull data

Export sell-through by category by store for the last 2 seasons. You need: units sold, units received, sell-through rate, and average selling price — by category, by store.

Step 2: Visual grouping

Before running any analysis, look at the data. Can you see obvious groupings? Do certain stores consistently sell more outerwear? Do certain stores have higher sell-through rates? The human eye is surprisingly good at spotting patterns in a well-organized table.

Step 3: Formal clustering

For a more systematic approach:

1. →Calculate category contribution by store (what % of each store's sales comes from each category)
2. →Rank stores by similarity of category contribution
3. →Group stores with similar profiles

In Excel, you can do this with a simple correlation matrix. In practice, 3–5 clusters capture 85–90% of the meaningful variation.

Step 4: Validate and adjust

Test your clusters against one season of actual data. Did stores within the same cluster perform similarly? If one store consistently deviates from its cluster, it may need to be reassigned.

When clustering doesn't help

• →Fewer than 8 stores: Not enough data or variation to form meaningful clusters. Plan individually.
• →Pure DTC brand: No physical stores means no location-based clustering (though you can cluster by customer segment for marketing purposes).
• →Pop-ups and temporary locations: Too short-lived to cluster. Plan each as a one-off.

Further reading

• →Localized Assortment Planning — from clustering to cluster-specific assortments
• →Allocation and Replenishment Best Practices — allocating within clusters
• →Size and Pack Optimization — cluster-specific size curves
• →Omnichannel Assortment Planning — clustering across channels
• →Customer-Centric Merchandise Planning — using customer data to inform clustering