Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

How to analyze your product assortment

Written by Marco Kastrop on . Posted in Exact Online

To stay competitive in the market as a wholesaler you realize that it is important to keep the right product assortment (on stock) to fit your strategy to maximize your service level to customers and to minimize loss of sales. The big question in that case: ‘What products to keep in my product assortment and with what product levels’? In the end you want more from assortments with products with high volume and / or high profit margins and you do not want to end up with high, expensive and not running stock levels. 

To make the perfect breakdown of your product assortment in Exact Online, you can categorize every item by linking a category from 5 different assortments.  

Some examples of assortment definitions: 

  1. (Statistical) Sales pattern:  – Seasonal product, Slow moving product, Fashion trend product
  2. Product category: – Food, Cooking equipment, Books
  3. ABC analysis qualification: A, B or C

Product assortment definition

Actually you can define any assortment definition. The information starts to be relevant after linking the correct combination to your item master:

Linking item to assortment combinations

After setting up the correct product assortments and items, you can start making your breakdown analysis. To provide useful information related to your product assortment we have extended every overview in Exact Online Logistics with assortment filters. In this way you will be capable of making analysis on any combination of: 

  1. Inventory turnover
  2. Age of inventory
  3. Stock positions (in time)
  4. Sales margin analysis
  5. Purchase volumes

Assortments as filters on overviews

Using these overviews will allow you to make analysis of your product assortment and making the right decisions. Who wouldn’t want to have this kind of strategic information available 24/7 independent of time and place? 

Leave a comment