From the POV of CPG manufacturers: Localized Assortment in retail

Reading Time: 4 minutes

Introduction

The landscape of consumer-packaged goods is rapidly evolving, driven by digitally empowered shoppers engaging in cross-channel shopping behaviors. The product route to the consumer is mostly through retailers, who try their best to meet customer needs by playing around with business metrics such as consumer spending, necessitating the localization of assortments. Failure to respond to these demands results in loss of opportunity and reputation (in the long run) for retailers and consumer packaged goods manufacturers, which makes both inseparable.

In the intricate tapestry of retail, each decision made by a packaged goods manufacturer is pivotal. One such critical decision is the assortment of products offered in retail stores, which not only determines the brand’s identity but also its success in the competitive market.

This blog explores the importance of assortment localization, emphasizing the need to understand diverse consumer preferences across categories. It highlights how tailoring assortments to local needs can lead to significant sales growth. The significance of assortment localization, with insights such as varying needs across categories and the potential for significant sales increases through intelligent localization.

The Walmart fiasco

Let’s understand these pointers in detail using a case study where Walmart’s sales dropped for nearly two years, performing worse than their competitors. They expanded the project impact across their stores but later realized their mistake and stopped it. This cost them an estimated $2 billion in lost sales and, consequently, the consumer product manufacturers because they didn’t understand the importance of offering exclusive products to attract shoppers.

Assortment optimization becomes increasingly crucial for retail performance due to the following key challenges in the modern market landscape:

  • Growing SKU complexity: Large brands continually introduce new SKUs, while the proliferation of small brands adds to the assortment. This explosion of product variety increases the complexity of managing assortments effectively.
  • Limited shelf space: Despite the expanding number of products, physical shelf space remains constrained. Retailers face the challenge of maximizing sales within these spatial constraints without compromising the shopping experience.
  • Supply chain complexity: Managing a growing number of SKUs complicates the supply chain, leading to inventory management challenges and increased operational costs. Retailers need to streamline their assortment to optimize supply chain efficiency.
  • E-commerce challenges: In the digital realm, retailers must manage virtual shelves to capture customers’ attention and balance inventory and logistics costs effectively. This requires careful curation of online assortments to drive sales while managing operational expenses.
  • Location-specific dynamics: Each store’s unique characteristics, including size, format, and local demographics, influence product performance. Retailers must tailor assortments to suit the preferences and needs of customers at each location, requiring a nuanced approach to assortment optimization.

The solution: Assortment localization

While there’s no one-size-fits-all solution, manufacturers and retailers need to develop tailored roadmaps by assessing their position and understanding their current capabilities and areas for improvement.

To effectively enhance the assortment localization capabilities, retailers will need to focus on areas such as:

  • Implementing efficient processes to manage the complexity of assortments across multiple markets.
  • Utilizing new data and analytics to identify locally appropriate products across various markets and retailers.
  • Leveraging advanced software tools to generate customized planograms efficiently.

By leveraging data-driven insights and analytics, retailers can address these issues effectively:

  • Systematic delisting: Identifying underperforming products and strategically delisting them can drive sales of higher-margin items, leading to improved gross margins. This process requires sophisticated analytics to pinpoint opportunities for SKU rationalization without sacrificing overall sales volumes.
  • Macro space allocation: Optimizing space allocation within each store involves determining how much space to allocate to each product category. Data analysis helps retailers allocate space based on sales performance, customer preferences, and store-specific dynamics, maximizing the return on shelf space investments.
  • Localization: Tailoring assortments to the unique characteristics of each store location is critical for driving sales and customer satisfaction. By analyzing local market data and customer behavior patterns, retailers can customize SKU mixes to meet the needs of diverse customer segments effectively.
  • Store purchase pattern: Clustering stores based on purchase patterns helps consumer packaged goods manufacturers to share insights with the retailers and leverage the end customer by pushing products that never were in store but could have been bought. Analyzing only store data would not have helped retailers in stock up on products that were not never present in store.

Assortment Management

Effective assortment management can significantly improve financial performance, as seen in image 1 above. Some of the key improvements that can be noticed would include:

  • Strategic listing of products can increase sales by up to 4 percent.
  • Simplifying the product assortment streamlines the supply chain and reduces operational costs.
  • Retailers can improve margins by up to 0.5 percentage points by optimizing operations and supply chain processes.
  • Understanding product uniqueness helps in deciding which products to keep or delist.
  • Better sourcing can be negotiated, leading to potential cost savings of up to 3 percent.

Conclusion

In a world increasingly characterized by globalization, the importance of maintaining a local touch through assortment localization in retail cannot be understated. It is a powerful strategy that allows retailers and manufacturers to connect with their consumers on a more personal and meaningful level, taking into consideration the cultural, economic, and individual preferences that vary from one locale to another. For consumer product manufacturers looking to stay competitive and relevant in the dynamic retail landscape, investing in assortment localization is not just an option; it’s a necessity. Embracing this strategy with the aid of technological advancements can pave the way for sustainable growth and success. It encourages brands to become more culturally competent, economically aware, and customer centric, and by doing so, it ensures that the local charm is preserved in the global shuffle, making every retail experience unique and every consumer valued.

Reference : https://medium.com/@yulianaz/ignore-the-customer-experience-lose-a-billion-dollars-walmart-case-study-e48219dcdef4

Authors

Shashank Pushp

Solution Architect Fosfor, LTIMindtree

With over a decade of experience in Retail and CPG analytics implementing analytical solutions. His expertise lies in solving complex business problems using advanced analytics and delivering irrefutable value to customers, by getting most of the data. He is a data enthusiast and product evangelist, empowering customers with actionable data stories. When not at work, Shashank explores new travel destinations, reads drama, and watches stand-up comedies.

Shalini Harkar

Solution Architect at Fosfor

With an overall experience of a decade in analytics, Shalini is known for spearheading research initiatives enabling technology adoption. She is the Solutions Architect at Refract, the Fosfor Decision Cloud’s Insight Designer. Shalini is a tech innovation enthusiast and a product geek, empowering customers with innovative product solutions that deliver business outcomes. Outside work, Shalini loves tech-oriented talks over a cup of coffee.

More on the topic

Read more thought leadership from our team of experts

A modern perspective on the data-to-decisions journey

The promise of AI is irresistible – insights that can transform business decisions, increase efficiency, and give companies a competitive edge

Read more

A new way to interrogate your Data Cloud for insights

The ability to swiftly derive insights from data is no longer just an advantage; it’s rather a necessity.

Read more

Culture of curiosity

Remember when the world wide web forever changed how people satisfy their curiosity? It was a watershed moment for humanity and the ways we communicate, do business, innovate, and uncover new insights.

Read more
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. View more
Cookies settings
Accept
Privacy & Cookie policy
Privacy & Cookies policy
Cookie name Active

What is a cookie?

A cookie is a small piece of data that a website asks your browser to store on your computer or mobile device. The cookie allows the website to “remember” your actions or preferences over time. On future visits, this data is then returned to that website to help identify you and your site preferences. Our websites and mobile sites use cookies to give you the best online experience. Most Internet browsers support cookies; however, users can set their browsers to decline certain types of cookies or specific cookies. Further, users can delete cookies at any time.

Why do we use cookies?

We use cookies to learn how you interact with our content and to improve your experience when visiting our website(s). For example, some cookies remember your language or preferences so that you do not have to repeatedly make these choices when you visit one of our websites.

What kind of cookies do we use?

We use the following categories of cookie:

Category 1: Strictly Necessary Cookies

Strictly necessary cookies are those that are essential for our sites to work in the way you have requested. Although many of our sites are open, that is, they do not require registration; we may use strictly necessary cookies to control access to some of our community sites, whitepapers or online events such as webinars; as well as to maintain your session during a single visit. These cookies will need to reset on your browser each time you register or log in to a gated area. If you block these cookies entirely, you may not be able to access gated areas. We may also offer you the choice of a persistent cookie to recognize you as you return to one of our gated sites. If you choose not to use this “remember me” function, you will simply need to log in each time you return.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
__cfduid Cloudflare Cookie associated with sites using CloudFlare, used to speed up page load times 1 Year
lidc linkedin.com his is a Microsoft MSN 1st party cookie that ensures the proper functioning of this website. 1 Day
PHPSESSID ltimindtree.com Cookies named PHPSESSID only contain a reference to a session stored on the web server When the browsing session ends
catAccCookies ltimindtree.com Cookie set by the UK cookie consent plugin to record that you accept the fact that the site uses cookies. 29 Days
AWSELB Used to distribute traffic to the website on several servers in order to optimise response times. 2437 Days
JSESSIONID linkedin.com Preserves users states across page requests. 334,416 Days
checkForPermission bidr.io Determines whether the visitor has accepted the cookie consent box. 1 Day
VISITOR_INFO1_LIVE Tries to estimate users bandwidth on the pages with integrated YouTube videos. 179 Days

Category 2: Performance Cookies

Performance cookies, often called analytics cookies, collect data from visitors to our sites on a unique, but anonymous basis. The results are reported to us as aggregate numbers and trends. LTI allows third-parties to set performance cookies. We rely on reports to understand our audiences, and improve how our websites work. We use Google Analytics, a web analytics service provided by Google, Inc. (“Google”), which in turn uses performance cookies. Information generated by the cookies about your use of our website will be transmitted to and stored by Google on servers Worldwide. The IP-address, which your browser conveys within the scope of Google Analytics, will not be associated with any other data held by Google. You may refuse the use of cookies by selecting the appropriate settings on your browser. However, you have to note that if you do this, you may not be able to use the full functionality of our website. You can also opt-out from being tracked by Google Analytics from any future instances, by downloading and installing Google Analytics Opt-out Browser Add-on for your current web browser: https://tools.google.com/dlpage/gaoptout & cookiechoices.org and privacy.google.com/businesses
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
_ga ltimindtree.com Used to identify unique users. Registers a unique ID that is used to generate statistical data on how the visitor uses the web site. 2 years
_gid ltimindtree.com This cookie name is asssociated with Google Universal Analytics. This appears to be a new cookie and as of Spring 2017 no information is available from Google. It appears to store and update a unique value for each page visited. 1 day
_gat ltimindtree.com Used by Google Analytics to throttle request rate 1 Day

Category 3: Functionality Cookies

We may use site performance cookies to remember your preferences for operational settings on our websites, so as to save you the trouble to reset the preferences every time you visit. For example, the cookie may recognize optimum video streaming speeds, or volume settings, or the order in which you look at comments to a posting on one of our forums. These cookies do not identify you as an individual and we don’t associate the resulting information with a cookie that does.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
lang ads.linkedin.com Set by LinkedIn when a webpage contains an embedded “Follow us” panel. Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in. When the browsing session ends
lang linkedin.com In most cases it will likely be used to store language preferences, potentially to serve up content in the stored language. When the browsing session ends
YSC Registers a unique ID to keep statistics of what videos from Youtube the user has seen. 2,488,902 Days

Category 4: Social Media Cookies

If you use social media or other third-party credentials to log in to our sites, then that other organization may set a cookie that allows that company to recognize you. The social media organization may use that cookie for its own purposes. The Social Media Organization may also show you ads and content from us when you visit its websites.

Ref links:

LinkedInhttps://www.linkedin.com/legal/privacy-policy Twitterhttps://gdpr.twitter.com/en.html & https://twitter.com/en/privacy & https://help.twitter.com/en/rules-and-policies/twitter-cookies Facebookhttps://www.facebook.com/business/gdpr Also, if you use a social media-sharing button or widget on one of our sites, the social network that created the button will record your action for its own purposes. Please read through each social media organization’s privacy and data protection policy to understand its use of its cookies and the tracking from our sites, and also how to control such cookies and buttons.

Category 5: Targeting/Advertising Cookies

We use tracking and targeting cookies, or ask other companies to do so on our behalf, to send you emails and show you online advertising, which meet your business and professional interests. If you have registered on our websites, we may send you emails, tailored to reflect the interests you have shown during your visits. We ask third-party advertising platforms and technology companies to show you our ads after you leave our sites (retargeting technology). This technology allows us to make our website services more interesting for you. Retargeting cookies are used to record anonymized movement patterns on a website. These patterns are used to tailor banner advertisements to your interests. The data used for retargeting is completely anonymous, and is only used for statistical analysis. No personal data is stored, and the use of the retargeting technology is subject to the applicable statutory data protection regulations. We also work with companies to reach people who have not visited our sites. These companies do not identify you as an individual, instead rely on a variety of other data to show you advertisements, for example, behavior across websites, information about individual devices, and, in some cases, IP addresses. Please refer below table to understand how these third-party websites collect and use information on our behalf and read more about their opt out options.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
BizoID ads.linkedin.com These cookies are used to deliver adverts more relevant to you and your interests 183 days
iuuid demandbase.com Used to measure the performance and optimization of Demandbase data and reporting 2 years
IDE doubleclick.net This cookie carries out information about how the end user uses the website and any advertising that the end user may have seen before visiting the said website. 2,903,481 Days
UserMatchHistory linkedin.com This cookie is used to track visitors so that more relevant ads can be presented based on the visitor’s preferences. 60,345 Days
bcookie linkedin.com This is a Microsoft MSN 1st party cookie for sharing the content of the website via social media. 2 years
__asc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Day
__auc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Year
_gcl_au ltimindtree.com Used by Google AdSense for experimenting with advertisement efficiency across websites using their services. 3 Months
bscookie linkedin.com Used by the social networking service, LinkedIn, for tracking the use of embedded services. 2 years
tempToken app.mirabelsmarketingmanager.com When the browsing session ends
ELOQUA eloqua.com Registers a unique ID that identifies the user’s device upon return visits. Used for auto -populating forms and to validate if a certain contact is registered to an email group . 2 Years
ELQSTATUS eloqua.com Used to auto -populate forms and validate if a given contact has subscribed to an email group. The cookies only set if the user allows tracking . 2 Years
IDE doubleclick.net Used by Google Double Click to register and report the website user’s actions after viewing clicking one of the advertiser’s ads with the purpose of measuring the efficiency of an ad and to present targeted ads to the user. 1 Year
NID google.com Registers a unique ID that identifies a returning user’s device. The ID is used for targeted ads. 6 Months
PREF youtube.com Registers a unique ID that is used by Google to keep statistics of how the visitor uses YouTube videos across different web sites. 8 months
test_cookie doubleclick.net This cookie is set by DoubleClick (which is owned by Google) to determine if the website visitor’s browser supports cookies. 1,073,201 Days
UserMatchHistory linkedin.com Used to track visitors on multiple websites, in order to present relevant advertisement based on the visitor’s preferences. 29 days
VISITOR_INFO1_LIVE youtube.com 179 days
Third party companies Purpose Applicable Privacy/Cookie Policy Link
Alexa Show targeted, relevant advertisements https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: http://www.bluekai.com/consumers.php#optout
Eloqua Personalized email based interactions https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: https://www.oracle.com/marketingcloud/opt-status.html
CrazyEgg CrazyEgg provides visualization of visits to website. https://help.crazyegg.com/article/165-crazy-eggs-gdpr-readiness Opt Out: DAA: https://www.crazyegg.com/opt-out
DemandBase Show targeted, relevant advertisements https://www.demandbase.com/privacy-policy/ Opt out: DAA: http://www.aboutads.info/choices/
LinkedIn Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://www.linkedin.com/legal/privacy-policy Opt-out: https://www.linkedin.com/help/linkedin/answer/62931/manage-advertising-preferences
Google Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Facebook Show targeted, relevant advertisements https://www.facebook.com/privacy/explanation Opt Out: https://www.facebook.com/help/568137493302217
Youtube Show targeted, relevant advertisements. Show embedded videos on LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Twitter Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://twitter.com/en/privacy Opt out: https://twitter.com/personalization DAA: http://optout.aboutads.info/
Save settings
Cookies settings