Sales Index: Definition, Calculation, and Role in Category Management
The sales index (IDV) is the average number of items sold per receipt: items sold ÷ number of receipts. This should not be confused with the average basket size, which measures an amount, not a volume.
It depends on category management decisions (placement, product assortment, cross-merchandising). In pricing, it is used to determine whether a price will result in other items being added to the receipt, provided it is tracked category by category.
The sales index is one of the simplest indicators in retail—and one of the most underutilized.
Many people confuse it with the average basket size. Few people realize that it is influenced by pricing and category management decisions, which cause it to fluctuate.
This guide provides the definition, formula, and pitfalls of this concept, followed by instructions on how to interpret it before making a pricing decision.
What is the sales index?
The sales index (IDV) is the average number of items sold per receipt. It measures the ability of a retail location, department, or category to encourage customers to purchase multiple products in a single checkout transaction.
How to Calculate the Sales Index: Formula and Example
The formula is straightforward:sales ratio = number of items sold ÷ number of receipts. A store that sells 300 items for 120 receipts has a sales ratio of 2.5.
The catch isn't the division; it's what we count as an "item." Is a six-pack of bottles worth one item or six? Is a portion of fruit one line or one kilo?
Depending on the convention used, the same store may report two very different metrics. Our position: establish the rule once and for all, and never compare two scopes that do not follow the same rule.
A Department's Sales Index: Penetration and Depth
At the department level, the index is best understood in two parts: the percentage of receipts that include items from that department (its penetration), and the number of items from that department on those receipts (its depth).
Illustrative example: Out of 1,000 receipts, a department appearing on 300 receipts—with an average of 2 items per receipt—contributes 0.6 points to the store’s index (300 × 2 ÷ 1,000).
This distinction changes how a decision is interpreted. A promotional price primarily affects penetration: it gets the product onto more shopping lists. Placement and product assortment primarily affect depth.
Sales Index vs. Average Cart Value
These two metrics are often confused. The average basket size is a monetary value: total revenue divided by the number of transactions. The sales index is a volume metric: the number of items divided by the number of transactions.
| Dimension | Medium Basket | Sales Index |
|---|---|---|
| What it measures | An amount in euros | A number of articles |
| Related lever | Price, product mix | Product assortment, cross-merchandising |
| Usage in Pricing | Effect of Price on Ticket Value | Effect of Price on the Number of Items |
For a pricer, this distinction is crucial: if a price reduction causes the sales index to rise (excluding bundle offers), it means the rest of the category has followed suit, not just the product whose price was lowered.
The average online shopping cart value in 2025 is expected to decline, while the number of transactions is projected to increase by 11 percent. More transactions, smaller orders: the average shopping cart value alone does not indicate how many items each transaction contains.
(Fevad, 2025 E-commerce Report, February 2026)
A high average cart value can therefore mask a low sales index (few items, but expensive ones), and vice versa.
Why is this a category management metric?
Sales figures are a direct result of category management decisions.
Shelf placement, the breadth of the product assortment, and cross-merchandising between complementary categories determine how many products a customer actually adds to their shopping cart.
An analysis that shows where the profit margin really lies.
The retailer thought it knew its market positioning. The analysis compared its prices to the market, weighted by sales volume, and revealed the margin gap between products exposed to competition and the others.
- Issue
- Assess price positioning relative to the market and identify the " Markup."
- What Has Changed
- An analysis of sales history, a weighted index, and then data-driven management.
These products account for 80% of sales across the entire network.
Sales Management · Network of 90 stores. Case study written by Booper based on an actual client project; the client’s identity has been anonymized.
These few items account for the bulk of the sales: their prices cannot be managed in the same way as those of the rest of the product line.
By sector, a very different reality
There is no such thing as a "good" universal index: it can only be compared when the format and counting conventions are the same.
In the food retail sector, weekly grocery shopping drives the index upward: customers come to stock up their households, not to buy a single item.
In home improvement and gardening, purchases are often tied to a specific project, resulting in fewer visits and a higher average order value.
A lower index does not indicate poorer performance, but rather a different purchasing pattern.
In the fashion and specialty sectors, purchases are often made on a per-item basis: this allows for greater growth potential through cross-merchandising.
The only thing that matters is the sign's path, section by section.
Factors Affecting the Sales Index
Cross-merchandising and product range breadth influence product depth. The fragmentation of purchases across retail chains, on the other hand, occurs outside the store, and price plays a direct role in this.
Some households report that they base their purchasing decisions primarily on purchasing power. A customer who makes such decisions spreads their purchases across different retailers, and each shopping trip involves fewer items.
(EY-Parthenon, “The French People’s Favorite Retailers,” April 2026)
That's where price matters: customers who shop around base their decisions on a few key products, then allocate the rest of their budget accordingly.
Improve sales figures without sacrificing profit margins
The merchandising strategies are well known (bundling complementary products, kits, cross-selling). On the pricing side, a well-positioned loss leader brings other items into the purchase. A blanket discount, however, mainly reduces the margin.
Counterintuitive: A rising sales figure isn't always good news. A "buy one, get one free" promotion automatically inflates it, without any ripple effect: the customer buys the same product three times.
That's why we look at the metric that excludes multi-unit offers—or the number of different items per receipt. It's this metric that tells us whether a price has actually led to a full shopping cart.
In an analysis of a network of 90 stores, the "Price Index "—weighted by sales volume—revealed the margin gap between products facing competition and the others.
At a garden center, an analysis of the product assortment revealed that a small number of SKUs accounted for the bulk of sales and profit margins. The current goal is to reduce the number of SKUs from 20,000 to 12,000, starting by testing price reductions before discontinuing any items.
Booper Team, Price Diagnostics, and Client Projects
A sales index based on a narrower product range is better than one inflated by items with low volume and low margins.
The Connection to Revenue Growth Management
In Revenue Growth Management, the product mix is one of the four levers. The sales index measures whether it has a real impact, department by department.
In pricing, it serves as a check: a price that increases a department's margin but reduces its market penetration has driven customers away, not created value.
A price simulation at the department level. Every price change or promotion is simulated before being implemented: the combined impact on sales, margin, and inventory is analyzed.
Check out the platform on our MPS page —the Booper " Modular Pricing Solution ."
A sales index is tracked when it is monitored by department, distinguished from the average basket size, and calculated excluding bulk promotions.
Is your sales index managed on a category-by-category basis?
Spend 30 minutes with our team to objectively assess where your product assortment is limiting the number of items per receipt.
See also in this feature
- Measuring a Retailer's Price Image: KPIs, Price Index, and KVI
- Perceived Value vs. Actual Value: The Distinction That Should Guide Your Pricing
- Managing Your Price Image with a Tool: What It Measures and What It Doesn't
- Justifying the Price or Explaining the Value: Why Your Approach Makes All the Difference
FAQ
The sales index (IDV) is the average number of items sold per sales receipt. It is calculated by dividing the number of items sold by the number of sales receipts over a given period.
Sales ratio = number of items sold ÷ number of receipts. For example, 300 items sold across 120 receipts results in a sales ratio of 2.5.
First, specify the counting method (batches, items by weight, returns): it affects the result.
The sales index measures the number of items per transaction, while the average basket size measures the amount in euros. A high average basket size can mask a low sales index.
By focusing on cross-merchandising and product bundles, and by simulating the effect of a price change on the entire category before lowering it.
Be wary of bundle offers: they inflate the index without creating a ripple effect.
Divide the number of items on the shelf by the number of bins it contains: this gives you its depth.
When multiplied by the proportion of receipts on which it appears (its penetration rate), it yields its contribution to the store's index.
There is no universal benchmark: the food sector consistently posts higher figures than the home improvement or fashion sectors.
A good index is one that increases within your own scope, section by section, using a consistent counting method.
Sources: Fevad, 2025 E-commerce Report (February 2026) · EY-Parthenon, French Consumers’ Favorite Retailers (April 1, 2026) · Illustrative figures from Booper
Further Reading
Management doesn't approve a price; it approves a trade-off between margin, volume, and price image. Presenting a single recommendation means asking management to trust you. Presenting the cost of each option gives management the information it needs to make a decision.
A sound projection provides a range rather than a single figure, specifies what is being excluded, and anticipates the gap between the projected increase and the actual increase. When compared with actual results, it establishes the credibility of the next projection.
A franchisor cannot impose a minimum resale price: doing so is punishable by law; the franchisor may only recommend a price or set a maximum. A franchisee’s margin is therefore governed by a documented target, defined by network segment and applied uniformly across each segment.
The best indicator of this governance is not adherence to the suggested retail price, but the rate of compliance with it by segment. A suggested retail price that franchisees in a given area do not follow often signals a poorly set price, not a lack of discipline.
Optimix merged with Maxxing in July 2025, and PricingHUB was acquired by Akeneo in June 2026. For their customers, the question of the independence of the pricing roadmap has become a legitimate concern.
What sets a query apart in France isn't the processing speed: it's the native support for French rules, pricing by store or by zone, the validation process, and testing with your own data.