top of page
Assortment Background

Key Features



Why use an Assortment solution

  • Create Assortments – National, Segment, Fixture Size Break or Store Specific

  • Optimise the Customer Offer to the Shopping Mission using Segmentation or Assortment Rules

  • Represent Category Strategy whilst respecting Buyer Commercial Agreements

  • Represent groups of products using Rules

  • Consider Regional Product Swap

  • Ensure Local Products are appearing in the right store

  • Report across Products, Stores, Distribution, & Financials

Key objectives in determining your assortment

  • Delivering Customer Requirements

  • Maintaining Category Strategy

  • Maximising Sales and Profit

  • Achieving Commercial Objectives

What can we deliver?

  • Level 1 Assortment

  • The recommendation for product list/delist by store or stores is suggested

  • Projection Opportunity - based on criteria defined by the user

  • Full results recommendations and interactive Excel workbook

  • Level 2 Assortment

  • Inventory and product rules based recommendation at all stores, selected stores or selected clusters

  • Recommendations on what products to add / remove based on rules, including new products

  • Report on store attributes for existing stores

  • Optional Clustering. Clients can use their own clustering (if available) or we can build this for you

  • Full results recommendations and interactive Excel workbook



Why use a Clustering solution

  • Ability to cluster at at a single category or multiple category levels

  • Enhance customer satisfaction through correct store or cluster product ranging

  • Determine successful products in clusters

Why we use a "bottom up" approach

  • Store clusters have traditionally been determined using "Top Down" attributes such as Geographical Regions, Store Size, Sales Value, Store Locality, Demographics or Supply Chain Depots. However, this approach may only result in operational savings and may not meet consumer expectations.

  • The "Bottom Up" attributes analyse the product sales mix by examining Category, Sub Category, and Sector attributes, among others. This analysis reveals product trends, consumer behaviour, shopping missions, and localized/regional assortments.

  • Not only will this achieve operational savings, but will also satisfy consumer expectations.

What can we deliver?

  • Clustering

  • Our solution utilizes a bottom-up approach to group stores based on the user-nominated sales mix.

  • The k-means method is utilized to identify the grouping of stores

  • The solution allows for the creation of several clusters by utilising product attribute drivers specified by the user.

  • The solution can identify the most accurate cluster by evaluating the proximity of stores to the cluster's centre.

  • Clusters can be named by users, and changes can be made manually or excluded.



  • Utilizes bottom-up approach and K-means method 

  • Automatically groups stores based on selected attribute drivers 

  • Enables Store Clustering by grouping stores with similar characteristics


Compare the Assortment Project Levels

  • Assortment options available for both entry level and advanced users 

  • Rules-based options tailored to individual needs and data availability 

  • Applicable across multiple trade channels, with comparison section for evaluation


Arrange a free consultation

  • Reach out to us for a discussion regarding your requirements and desired results. 

  • We can assist with data cleaning and provide expertise in Assortment and Clustering goals.

  • Our assistance is available regardless of your current stage.

bottom of page