How to Effectively Cut the Long Tail in Product Assortment
A Data-Driven Approach to Improve Efficiency, Profitability, and Customer Satisfaction- Excessive product assortment leads to inefficiencies, higher costs, and customer decision fatigue.
- Common merchandising mistakes include overestimating demand for niche products, failing to prune underperforming SKUs, and ignoring the Pareto Principle.
- ABC analysis and Stock Health reports provide actionable insights to categorize products by value and optimize inventory levels.
- Shelf Planner’s platform enables data-driven assortment rationalization, reducing the long tail while improving profitability and customer experience.
By Robbie Cleijsen, co-founder of Shelf Planner.
Introduction - The Long Tail Dilemma in Retail
Years ago, when I was still working as a division manager for a Swedish retailer, my manager at the time handed me a copy of Barry Schwarz’ The Paradox of Choice: Why More Is Less.
In this book, Schwarz presents a compelling argument challenging the conventional wisdom that more choices lead to better outcomes.
Although this book was published over 20 years ago, it seems the challenges are still very present today for business of all sizes.
Merchandise planners today face a critical challenge: the tendency to expand product assortments excessively, leading to what is known as “assortment bloat.”
This phenomenon occurs when retailers, in an effort to cater to every possible customer preference, accumulate a vast number of SKUs (stock keeping units).
While this strategy might seem like a good way to boost sales, it often leads to inefficiencies in inventory management higher operational costs and a diminished focus on customers.
The “long tail” of products – those selling in low volumes – demands disproportionate resources relative to their revenue contribution, creating a complex web of challenges.
In this article, we’ll explore how merchandisers can effectively cut the long tail in their product assortment to improve efficiency, profitability, and customer satisfaction.
We’ll also combine industry best practices, and results from our data-driven tools and reports, such as our Stock Health reports and ABC analysis. The goal is to provide a comprehensive, actionable framework that balances theoretical depth with practical solutions.
The Psychology of Choice: Why More Isn’t Always Better
Barry Schwartz’s The Paradox of Choice: Why More Is Less presents a compelling argument that challenges the conventional wisdom that more choices lead to better outcomes.
Schwartz combines research from psychology, economics, and sociology to demonstrate that an overabundance of choices often results in negative psychological consequences, including decision paralysis, increased anxiety, and reduced satisfaction
Choice Overload & Decision Paralysis
When consumers are faced with too many options, they often experience “choice overload,” which impairs their ability to make decisions efficiently.
This phenomenon is particularly relevant in retail environments where customers encounter vast arrays of products. The psychological burden of evaluating numerous alternatives can lead to decision fatigue, causing customers to either delay purchases or select suboptimal products.
Regret and Opportunity Costs
Schwartz also emphasizes the role of regret in consumer decision-making. When customers choose from a large assortment, they are more likely to experience regret over missed opportunities, which diminishes their satisfaction with the chosen product.
This psychological effect underscores the importance of limiting assortment size to reduce the cognitive and emotional costs associated with decision-making
Don’t worry, this isn’t a book review but I wanted to share these findings. They stem from over 30 years of research and we’ve had this knowledge available for more than two decades. Despite this, we still encounter the same challenges. So, let’s explore how we can make things easier.
Implications for Retail Merchandising
The art and science of merchandising reveal that carefully curating product assortments is essential to avoid overwhelming customers. By reducing the number of choices to a manageable level and focusing on high-value, high-demand items, retailers can enhance customer satisfaction, minimize decision fatigue, and boost overall sales performance.
This approach directly supports the broader goal of cutting the long tail in product assortment, ultimately optimizing both efficiency and profitability.
Common Assortment Mistakes: Where Merchandisers Go Wrong
Despite the clear benefits of a leaner assortment, merchandisers often make several common mistakes that lead to assortment bloat and inefficiencies.
Overestimating Demand for Niche Products
One frequent error is overestimating demand for niche or low-volume products. Without data-driven validation, merchandisers may introduce or retain SKUs based on anecdotal evidence or supplier pressures, rather than actual customer demand. This leads to overstocking of slow-moving items, which ties up capital and increases holding costs
'Kill Your Darlings'
Merchandisers often struggle to regularly prune underperforming stock due to emotional attachment to products, supplier relationships or a lack of analytical tools. This leads to a bloated assortment where many products consume resources without significantly boosting revenue.
Therefore, regular review and rationalisation of stock are crucial for maintaining a healthy product portfolio. Essentially, it’s sometimes necessary to “kill your darlings”.
Ignoring the 80/20 Rule (Pareto Principle)
The Pareto Principle states that roughly 80% of effects come from 20% of causes.
In retail, this often translates to 80% of sales coming from 20% of products. Ignoring this principle leads to an inefficient allocation of resources, with too much focus on the long tail of low-selling items rather than optimizing the core bestsellers
Misaligning Assortment with Customer Preferences
Merchandisers sometimes fail to align their assortment with actual customer preferences, either due to inadequate market research or ignoring local tastes.
This misalignment results in stocking items that do not resonate with customers, leading to poor sell-through rates and increased markdowns
The Data-Driven Approach: How Stock Health Reports and ABC Analysis can fix the Problem
To effectively cut the long tail, merchandisers need objective, data-backed insights to inform their decisions. Two powerful tools in this regard are ABC analysis and Stock Health reports, both of which provide structured methodologies to categorize products and optimize inventory levels.
Leveraging ABC Analysis:
An ABC analysis categorizes products into three classes based on their contribution to revenue and profitability:
- Class A
High-value items that contribute significantly to revenue (typically 80% of sales).
- Class B
Mid-tier items with moderate contribution.
- Class C
Low-value items that contribute the least.
This classification helps you identify which products to prioritize, which to re-evaluate, and which to discontinue.
By focusing resources on Class A items, you can ensure high availability and minimize stockouts, while reducing investment in Class C items that contribute little to profitability
An ABC analysis also helps in setting appropriate service levels, negotiating with your suppliers, and optimize your pricing strategies.
It simplifies inventory management by providing clear priorities and reducing complexity in the assortment
Using Stock Health Reports
An ABC analysis categorizes products into three classes based on their contribution to revenue and profitability:
- Stars
High-value items that contribute significantly to revenue (typically 80% of sales).
- Cash Cows
Mid-tier items with moderate contribution.
- Question Marks
Low-value items that contribute the least.
- Dogs
Low-value items that contribute the least.
This classification helps you identify which products to prioritize, which to re-evaluate, and which to discontinue.
By focusing resources on Class A items, you can ensure high availability and minimize stockouts, while reducing investment in Class C items that contribute little to profitability
High Market Share
Low Market Share
High Growth
Low Growth
Stars
Stars
Revenue:
€32,561
Stock On Hand:
653 units
Inventory Share:
6%
Question Marks
Question Marks
Revenue:
€2,698
Stock On Hand:
1,485 units
Inventory Share:
22%
Cash Cows
Cash Cows
Revenue:
€12,563
Stock On Hand:
265 units
Inventory Share:
3%
Dogs
Dogs
Revenue:
€4,698
Stock On Hand:
6,985 units
Inventory Share:
69%
Case Studies: Small Business Success with Dependent Demand Planning
At Shelf Planner, we have been creating benefits for our customer since 2023. We collected some real-world examples to illustrate the transformative impact of dependent demand planning:
These cases underscore the importance of integrating advanced analytics, flexible workforce models, and demand-driven strategies to achieve operational excellence and sustainability.
How to get from a 'bloated' to an 'optimized' Assortment
Metric
From 'Bloated' Assortment ...
... to Optimized Assortment
Numner of SKU's
High (Excessive variety)
Reduced by 10-25%
Profit Margins
Eroding (markdowns, dead stock)
Improved (Focus on Bestsellers)
Operational Complexity
High (complex supply chain)
Lower (simplified management)
Customer Decision Fatique
High (too many choices)
Low (curated selection)
Customer Satisfaction
Lower (overwhelmed customers)
Higher (better product availability)
Time to Market for New Items
Slower (cluttered shelves and locked capital)
Faster (higher sell through and ROI)
Conclusion
By integrating psychological insights, data-driven tools, and strategic merchandising practices, retailers can effectively cut the long tail in their product assortment. This approach not only improves operational efficiency and profitability but also enhances the customer experience by reducing choice overload and ensuring the availability of high-demand products. Shelf Planner’s Stock Health reports and ABC analysis provide the necessary analytics and actionable insights to make this transformation successful.
At Shelf Planner, we believe also small businesses around the world can leverage AI and advanced analytics to reduce waste, prevent stockouts, and improve margins by 10-25%.
Adoption of these tools remains low due to cost, skill gaps, and organizational resistance, but strategic implementation and training can overcome these barriers. Sustainable material choices complement demand planning by reducing long-term costs and environmental impact, aligning with tightening regulations and consumer preferences.
Small businesses that integrate dependent demand planning with sustainable practices will not only enhance operational efficiency and profitability but also build resilience against supply chain disruptions and regulatory changes. This holistic approach positions small businesses to thrive in an increasingly competitive and environmentally conscious marketplace.
Customer testimonials
Hear from our customers
Automated inventory management with Shelf Planner
Shelf Planner’s AI-based inventory management platform supports you with all the tools you need to optimise your business.
