Stock availability is the degree to which a brand or retailer has inventory of all their listed items to meet customer demand. Product availability becomes even more critical when they have to respond to unforeseen changes in demand and supply. To maintain the ideal stock availability levels for all items, they need robust inventory management tools to ensure real-time updates on current stock and accurate insights into upcoming demand.
However, managing stock availability is not a clear-cut science. Retailers must balance the change in demand and keep stock availability in check.
Why Stock Availability Matters
One of the challenges of running a retail business is to optimize inventory and associated costs. Maintaining stock availability in stores is critical for offline retail businesses. And when selling online, making sure products are available across different retailers and marketplaces can have a huge impact on sales and conversions.
Understocking: It’s when a brand’s product fails to meet consumer demand. If this happens often enough, customers may not return to the brand’s website or app because of the initial experience. Understocking is not a brand’s fault entirely since they might not always be able to anticipate a change in demand. However, it’s about a their ability to adapt to a quick change in the market trends through historical analysis and accurate forecasting.
Overstocking: It’s when a company orders too much inventory. Holding too much stock will lead to higher storage costs, shrinkage, and obsolescence losses. Another loss occurs if the brand can’t quickly sell the items — diminishing the value of the products.
When multiple items are moving through a supply chain, companies can easily run into inventory inaccuracies. Discrepancies between the values of your system and the actual inventory of products can lead to understocking or overstocking. The best way to avoid discrepancies in inventory is to invest in an inventory management tool that gives you real-time updates on your stock. This is applicable for offline retail businesses.
2. Managing eCommerce inventory
Availability at Individual Product Level
Availability at Individual Product level by regions
Effective eCommerce inventory management is as important as making sure products are available in stores. Keeping track of your inventory levels and ensuring that you’re always well-stocked can avoid lost sales and keep your company running smoothly. Brands must ensure their stock is available across all the online platforms they sell. Access to real-time inventory data can help to keep a close eye on stock status across all marketplaces & retailers the product is available. Retailers also need to keep track of market trends to ensure they have the right inventory assortment to match customers’ demands.
3. Understand Consumer Demand
The only way to accurately predict future demand is to rely on historical data about your customer purchase trends. What do your customers purchase during holiday seasons? What are the upcoming trends in your category? Having data-backed answers to such questions will help brands and retailers properly stock up their inventory.
4. Adequate forecasting
Anticipating demand will help determine which products should be stocked during which seasons. Tracking past sales and metrics such as economic conditions, seasonality, peak buying months, and promotions will help brands predict demand. Analyzing such statistics will also help you get insights into the target market.
Availability across regions
5. Improve supplier relationships
It’s important to rely on a supply chain that delivers your shipment promptly. In fact, you should foster close relationships with your suppliers to trim costs and improve stock availability. You should be able to share key details such as future demands, so suppliers can ensure timely delivery.
Availability Analysis across Retailers and Categories
Consequences of Inefficient Inventory Management
What are the effects of overstocking?
Tied-up cash: Money spent on overstocking is tied-up money that your company could have put to better use. You can use it to pay off debts, wages, and rent. Inventory often has a limited shelf life due to material degradation, changing consumer trends, spoilage, and obsolescence.
Poor customer experience: Poor product availability will lead to low customer satisfaction & dropping customer loyalty.
Missed sales: Customers could gravitate towards the competition to make their current purchase if a product is unavailable at your online store. The more freequent the stockouts, the more lost sales.
Conclusion
To avoid the knock-on effects of overstocking and understocking, companies need a real-time view of their inventory, both online & offline. At DataWeave, we help companies decrease their latency period between stock replenishment and efficiently plan their supply chain. If you need help tracking your eCommerce product availability, reach out to the experts at DataWeave to know how we can help!
Last week the DataWeave analytics team identified the states most impacted by the baby formula shortage, only to see feminine hygiene products following similar trends with price increases occurring alongside a supply chain shortage. In this analysis, the team has identified over four hundred feminine hygiene products made available across eighteen retailer and delivery intermediary websites from August 2021 through June 2022, to see how product availability and price changes correlated.
Within the feminine care products analyzed, both tampons and sanitary pads show to have under 58% availability as of June 2022. For sanitary pads, June 2022 shows the lowest level of product availability at around 58%, which has steadily declined each month from August 2021 where product availability started around 69%. Tampons however, reached their lowest level of availability in April 2022 at 45%, and appear to be slowly recovering each month, now reaching around 53% availability in June 2022.
Product Availability for Feminine Care Products – June 2022
The Evolution of the Tampon Shortage by Retailer
Looking at tampons in more detail and at a retail level, we can see how much and how often product availability fluctuated from August 2021 through June 2022 across Kroger, Meijer, Baker’s Plus, Target and Walmart websites. Baker’s Plus, for example, shows the lowest product availability, maintaining an average of around 39% from October 2021 through June 2022. Kroger appears to be a notable exception only facing stock availability issues in March and April 2022, achieving nearly 78% availability in June 2022, which is 16% greater than the other retailers analyzed.
Product Availability for Tampons by Retailer – June 2022
Feminine Care Product Price Changes Over Time
When looking at Pricing Intelligence insights and average price changes occurring alongside declining product availability for tampons and sanitary pads combined, we see a very different story. Tampons have seen steep price hikes from December 2021 onward, increasing the most in June 2022, up 6% compared to prices seen in November 2021. This steep price increase could be attributed to consistently low availability for tampons that has been seen in recent months.
To the contrary, sanitary pads have seen a price reduction of around 1.25% as of June 2022 compared to average prices seen in November 2021. While prices are lower in June 2022 for sanitary pads, the percentage by which they are lower is shrinking in recent months, potentially for the same reasons related to decreasing product availability.
Price Change for Feminine Care Products – June 2022
When looking at month-over-month average price changes for tampons only, we can clearly identify which months had the biggest price changes, noting price hikes that lead to the currently high prices seen in June 2022. In March and May 2022, over 10% of tampons offered had seen a price increase, and around 8% had seen significant price increases of more than 10%.
Month-Over-Month Price Changes for Tampons – June 2022
eCommerce Intelligence Provides Early Visibility to Evolving Trends
Price increases don’t seem to be stopping anytime soon given there was a 3.6% price hike seen on average in May 2022 versus April, with June seeing yet another .6% increase from May’s prices. That being said, as the market evolves and feminine hygiene products stabilize, our team will continue to provide visibility to critical pricing and product availability changes to enable our clients to stay ahead of the curve.
From a baby formula shortage to a tampon shortage, what category will be next to follow the supply chain shortage trend? Follow our blog for access to the latest insights and be sure to reach out to our team if there is any particular category you are interested in tracking next, or for access to more information on our Commerce Intelligence and Digital Shelf solutions.
As the baby formula shortage continues, retailers and brands are working quickly to meet evolving consumer demand, considering supply chain driven headwinds, a baby formula recall, and inflationary-driven impacts. The DataWeave analytics team has actively tracked marketplace changes, alongside reports from the FDA, for the baby formula category at a state-level, and has shared the latest snapshot of product availability through June 7th, 2022, below.
Average Baby Formula Product Availability by State – June 2022
While the U.S. has reached an average of 84% baby formula availability the first week of June 2022, given recent news headlines related to the baby formula shortage, and tracking out of stock encounters by state, we see a continued decline in availability throughout the Midwest versus product availability levels seen in May 2022.
Wisconsin, Michigan, Illinois, Indiana, Ohio, and Kentucky all show average availability for baby formula to be less than 50%, with Wisconsin being impacted the most at less than 18% average availability. While Texas shows an average availability improvement of 3.5% from the first two weeks of May 2022 to the first week of June 2022 as noted in the below chart, availability is also very low overall at less than 60%.
Average Change in Baby Formula Product Availability by State – May 2022 to June 2022
Outside of the Midwest and Texas, the other states for consumers to be cautious in are California, Virginia, and South Carolina as their month-over-month average change in availability also declined 4%, 12.6% and 8.2% respectively. Below is a snapshot of where the baby formula availability average started as of May 1st through the 15th, 2022.
Average Baby Formula Product Availability by State – May 2022
Baby Formula Product Availability Changes – March 2021 through May 2022
At an aggregated level overall, the availability for baby formula was relatively stable across all retailers considered within our analysis from March 2021 through September 2021, but has been on a steady decline ever since, starting at 81.7% availability in September and ending at 53.8% availability in May 2022 as noted in the below chart.
Monthly Average Availability for Baby Formula Across Major Retailer Websites
Looking at baby formula availability at a retail level, we saw yet again not all availability challenges were alike, by month or retailer. Costco.com lead the other retailers within our analysis for greatest average availability from March 2021 through May 2022, but had one of the lowest availability percentages at 62.7% in May 2021, and dropped to the lowest availability of the group in May 2022 at 37.5%.
Average Availability for Baby Formula Across Major Retailer Websites
Baby Formula Prices Increase as Availability Changes
While unnecessary price gouging is prohibited, price increases are still happening at a slow and steady rate across all the accounts included within our Pricing Intelligence analysis given external market factors outside of baby formula recall related stockout scenarios.
Kroger.com experienced the greatest average price increases overall, with the peak being in May 2022 at a 19% increase, 8% higher than other retailers on average, versus prices seen in March 2021 for the same baby formula products. The most significant price hike occurred on Kroger.com from December 2021 to January 2022. Other retailers like H-E-B, Target and Wegman’s have had minimal price changes from March 2021 through May 2022.
Average Price Inflation for Baby Formula, Indexed to March 2021
Address the Baby Formula Shortage With eCommerce Intelligence
As the market continues to evolve and baby formula supply works its way to catching back up to demand, our team will continue providing critical pricing, merchandising, and competitive insights at scale, to enable retailers and brands to develop data-driven growth strategies that directly influence their eCommerce performance, accelerate revenue growth and drive profitability.
Be sure to reach out to our Retail Analytics experts for access to more details regarding the above analysis, or for more information on our Commerce Intelligence and Digital Shelf solutions, and let us know what other category insights you’d be interested in seeing this year.
As inflation continues to hike costs for consumers and supply chains challenge them to maintain loyalty, there is still an active audience willing to pay the ultimate price for the convenience of food and alcohol delivery. That being said, we analyzed 8 popular Retail and Delivery Intermediary websites and 11 popular ‘Cinco de Mayo’ keywords to see which Brands are predicted to win the battle of Digital Shelf Share of Search this holiday.
2022 Cinco de Mayo Share of Search Insights – Top Brands for ‘Cinco de Mayo’
Opportunities for Food & Bev on Cinco de Mayo
While most of our analysis focused on popular Cinco de Mayo food and beverage products, none of these brands populated on either Target (pictured on left below) or Walmart (pictured on right below) page 1 search results for the term ‘Cinco de Mayo’. Keyword search results for this term are dominated primarily by décor brands as indicated below.
Brands Achieving Top Share of Search for Food and Beverage Categories on Cinco de Mayo 2022
Share of Keyword Search Results – Alcohol Category
Three of the most popular alcohol types sought out during Cinco de Mayo are ‘Mexican Beer’, ‘Mezcal’, and ‘Tequila’. Below are the brands dominating Share of Keyword Search results on each of the major retail websites we researched.
AmazonFresh, Meijer, Kroger, and Sam’s Club Share of Search – Beer, Mezcal, and Tequila Keywords on Cinco de Mayo 2022
We also reviewed the same keyword performance across popular delivery intermediaries to see how Share of Keyword Search altered for ‘Mexican Beer’, ‘Mezcal’, and ‘Tequila’. The results are below for TotalWine, Instacart, Drizly and GoPuff:
TotalWine, Instacart, Drizly, and GoPuff of Search – Beer, Mezcal, and Tequila Keywords on Cinco de Mayo 2022
The keyword ‘Agave’ is also a popular search term within the alcohol category during the time leading up to Cinco de Mayo. We reviewed keyword search performance at various zip codes to see how price points that populated on page 1 search results varied given the change in median income. Below are the results:
Share of Search for Alcohol by Price Point and Zip Code on AmazonFresh
Share of Keyword Search Results – Grocery Categories
We also reviewed some of the most popular grocery items purchased during Cinco de Mayo by Keyword Share of Search results to see which brands are primed to win the Digital Shelf this year. Below are the results for Target.com and Walmart.com.
Walmart and Target Share of Search – Food and Beverage Keywords on Cinco de Mayo 2022
Below are the results for the same popular grocery items and alcohol keywords related to Cinco de Mayo and the page 1 results seen for Brand Share of Search on Safeway.com.
Safeway Share of Search – Food and Beverage Keywords on Cinco de Mayo 2022
Access to these types of real-time digital marketplace insights can enable retailers and brands to make strategic decisions and help drive profitable growth in an intensifying competitive environment. Be sure to reach out to our Retail Analytics experts for access to more details regarding the above analysis, and let us know what other holiday insights you’d be interested in seeing this year. Happy Cinco de Mayo!
Business has been anything but usual this holiday season, especially in the digital retail world. The holiday hustle and bustle historically seen in stores was once again occurring online, but not as anticipated given the current strength of consumer demand and the reemergence of COVID-19 limiting in-store traffic. While ‘Cyber Weekend’, Thanksgiving through Cyber Monday, continues to further its importance to retailers and brands, this year’s performance fell short of expectation due to product shortages and earlier promotions that pulled forward holiday demand.
Holiday promotions were seen beginning as early as October in order to compete with 2020 Prime Day sales, but discounting, pricing and availability took an opposite direction from usual. This shift influenced our team to get a jump start on our 2021 digital holiday analysis to assess how drastic the changes were versus 2020 activity, and to understand how much of this change has been influenced by inflationary pressures and product scarcity.
Scarcity Becomes a Reality
Our initial analysis started by reviewing year-over-year product availability and pricing changes from January through September 2021, leading up to the holiday season, as detailed in our 2021 Cyber Weekend Preliminary Insights blog. We reviewed popular holiday categories like apparel, electronics, and toys, to have a broad sense of notable trends seen consistently throughout various, applicable marketplaces. What we found was a consistent decline in product availability over the last six months compared to last year, alongside an increase in prices.
Although retailers significantly improved stock availability in November and early December 2021, even digital commerce giants like Amazon and Target were challenged to maintain consistent product availability on their website as seen below. While small in magnitude, there is also a declining trend occurring again closer toward the end of our analysis period, post Cyber Weekend, across all websites included in our analysis.
Source: Commerce Intelligence – Product Availability insights for Home & Garden, Jewelry & Watches, Clothing & Shoes, Bed N Bath, Lighting & Ceiling Fans categories
Greater Discounts, Higher Prices?
With inflation at a thirty-nine year high, retailers and manufacturers have realized they can command higher prices without impacting demand as consumers have shown their willingness to pay the price, especially when threatened by product scarcity. Our assessment is that while some products and categories have responded drastically, manufacturers’ suggested retail prices (MSRPs) have increased nearly seven percent on average from January to December 2021. MSRP adjustments are not taken lightly either, as this is an indication increased prices will be part of a longer-term shift in product strategy.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com & Target.com each month in 2021 comparing price increases from January 2021 base
Our 2021 pre-Cyber Weekend analysis reviewed MSRP changes for select categories (Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion) on Amazon and Target.com, and found around forty-eight percent of products on Amazon and thirty-five percent of products on Target.com have increased their MSRPs year-over-year, but kept pre-holiday discount percentages the same.
Looking more specifically as to what year-over-year changes occurred on Black Friday in 2021, we observed MSRPs increasing across the board for all categories at various magnitudes. This indicates why 2021 discounts appeared to be greater than or equivalent to 2020 for many categories, when in reality consumers paid a higher price than they would have in 2020 for the same items.
Source: Commerce Intelligence – MSRP Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Black Friday November 27th, 2021, versus average MSRP pricing for the same SKU count from November 20-26th 2021
On Amazon.com, categories like health & beauty have already increase MSRPs by a much greater percentage and magnitude versus Target.com leading up to and during Black Friday 2021, while other categories like furniture have increased MSRPs evenly on average across both retail websites. The below chart cites a few specific examples of year-over-year SKU-level MSRP, promotional price, and discount changes within found within the electronics, furniture, fashion, and health & beauty categories.
Source: Commerce Intelligence – MSRP Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Black Friday November 27th, 2021, versus average MSRP pricing for the same SKUs on Black Friday November 26th, 2020.
Fewer, but Deeper Discounts
From October through early November 2021, fewer products were discounted compared to this same period in 2020, and the few that were saw much deeper discounts apart from the home improvement category. The most extreme example we saw in discounts offered was within furniture where only three percent of SKUs were on discount in 2021 compared to twenty-six percent in 2020. Interestingly, the magnitude of discount was also higher pre-Cyber Weekend 2021 versus 2020, but this trend was not exclusive to furniture and was also seen within electronics, health & beauty, and home improvement.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com & Target.com Pre-Black Friday average selling price during November 20-26th 2021 versus average selling price from November 13-19th 2021 compared to Pre-Black Friday average selling price during November 19-25th 2020 versus average selling price from November 12-18th, 2020.
Within the furniture category, the subcategories offering the greatest number of SKUs with price decreases on Black Friday 2021 were rugs by a wide margin, followed by cabinets, bed and bath, and entertainment units, but the magnitude of discounts offered were all under twenty percent.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020
Accounting for this phenomenon could have been retailers’ attempts to clear inventory for SKUs which hadn’t sold even during the period of severe supply chain shortages. With more products selling at higher prices this year, retailers were also able to use fewer SKUs with greater discounts to attract buyer in hopes of filling their digital baskets with more full-priced goods, helping to protect margins heading in to Cyber Weekend. Scarcity threats also encouraged consumers to buy early, even when not on promotion, to ensure they would have gifts in time for the holidays.
The same trends seen pre-Cyber Weekend 2021 were also seen on Black Friday with a year-over-year decrease in the percentage of SKUs offered on discount versus 2020, and steeper price reductions for the discounted products which can also be attributed to the increase in MSRPs.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020
2021 Black Friday Price Increases?
We all know Black Friday is all about price reductions, discounts and deals and so it’s rare to see actual price increases, yet for Black Friday 2021, trends ran counter to this. We observed price increases across all categories for around thirteen to nineteen percent of SKUs, with an average price increase of around fifteen percent in 2021 versus an average of only two percent in 2020.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020
At an account level, we noticed a few interesting differences happening on Black Friday 2021 versus 2020 regarding category price changes. On Target.com, almost ninety percent of the bed and bath SKUs analyzed had a price change on Black Friday in 2021 versus 2020 with eighty-two percent presenting a higher price year-over-year versus only around seven percent showing a decrease, where on Amazon nearly forty-four percent of bed and bath SKUs showed an increase in price and around thirty-eight percent showed a decrease. Except for the health and beauty category on Target.com, more than half of the SKUs in each category saw a price increase on Black Friday versus a price decrease.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs on Black Friday November 26th, 2020.
The magnitude of year-over-year price changes seen on Black Friday 2021 was significant across all categories, but the magnitude of price increases found on Amazon.com within the health and beauty category outpaced the rest by far. We reviewed three hundred and sixty-five SKUs on Amazon.com within the health & beauty category and saw almost eighty-three percent of them had a price change with around thirty-one percent decreasing prices and around fifty-two percent increasing prices. This means that within the health & beauty category on Amazon.com, more than fifty percent of the SKUs tracked were sold at a one hundred and seventy-six percent higher price on average during Black Friday 2021 versus 2020.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs on Black Friday November 26th, 2020.
The subcategories offering the greatest number of SKUs with price increases on Black Friday 2021 were cameras, followed by men’s fragrances, laptops, and desktops & accessories, but the magnitude of discounts offered were all under ten percent.
Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020
The Aftermath Post-2021 Cyber Weekend
Extending this analysis beyond the holiday weekend, we analyzed price change activity from December third through the ninth across the top US retailers (chart below) and found that price decreases have been very minimal, comparatively speaking. Though there was a spike in number of price decreases from December 8th to the 9th, the percentage of SKUs with price decreases was still very low (less than three percent). We anticipate this trend will continue into 2022.
Source: Commerce Intelligence – Pricing insights for Home & Garden, Jewelry & Watches, Clothing & Shoes, Bed N Bath, Lighting & Ceiling Fans categories
A Sign of Things to Come
A confluence of inflationary trends, product shortages and consumer liquidity have driven many marketplace changes to occur simultaneously. Government programs in the form of stimulus checks, have put extra money in consumers’ hands, and so they’ve been more willing to spend. That, coupled with the shock in the supply chain, has motivated people to buy far ahead of the 2021 holiday season. Hence, retailers have needed to rely much less on across-the-board discounts. Promotions have been more strategic – we’ve seen deeper discounts over fewer products, likely used to draw consumers in to buy certain items, and once they’re there, customers are buying everything else at a non-discount level. When these factors once again normalize, we could see a return to the “race to the bottom” that has occurred since the financial crisis of 2008-2009, but for once, retailers may be able to maintain some pricing power as the 2021 holiday shopping season played out.
Even though performance was not as anticipated and holiday sales did not grow as rapidly as they did in 2020, Cyber Monday was still the greatest online shopping day in 2021. Through it all, retailers managed to keep their digital shelves stocked and orders filled in time for the holidays for the most part, running the risk of housing aged inventory if goods didn’t arrive in time. Despite predictions for steep promotions in January 2022, with supply chains still challenged and inflationary pressures still full steam ahead, we don’t anticipate much in the way of enhanced discounts to continue beyond the holidays.
Access to these types of real-time digital marketplace insights can enable retailers and brands to make strategic decisions like how and when to address inflationary pressures, while also supporting many other day-to-day operations and help drive profitable growth in an intensifying competitive environment. Continue to follow us in the coming weeks for a detailed 2021 year-end review across more retailers and categories. Be sure to reach out to our Retail Analytics experts for access to more details regarding the above analysis.
To make faster, seamless deliveries possible, brands need to tighten their supply chain. The pandemic has put a lot of stress on the global supply chain. The supply shock that began in China in February and the demand shock that followed as the global economy shut down uncovered weaknesses in production strategies and supply chains. Temporary trade restrictions and shortages of pharmaceuticals, critical medical supplies, and other products, further added to the problem.
As a consequence of all this, brands have to reduce or even eliminate their dependence on sources that are perceived as risky and rethink their use of lean manufacturing strategies that involve minimizing the amount of inventory held in their global supply chains. In the post-pandemic world, the supply chain will take center stage, and managing it efficiently with technical support is going to be what gives one brand an upper hand over the others.
1. Micro fulfillment is emerging as the need of the hour
Emerging Micro Fulfillment
Retailers are now faced with unprecedented omnichannel fulfillment complexities. Not only do customers expect faster order fulfillment and delivery, but they’re also opting to ‘buy online and pick up in-store (BOPIS)’ or ‘click-and-collect’. Amazon has spent billions of dollars on building its shipping infrastructure, including its existing operating 175+ fulfillment centers across the world and investing nearly $1.5 Bn to build an air hub in the US. Walmart, on the other hand, is relying on its existing footprint across 5000+ US stores to help deliver online orders faster.
All this is hinting towards micro-fulfillment emerging as a strategy retailers are using to make the fulfillment process more efficient and their supply chain more ready — from receiving an online order to packing it and offering last-mile delivery. This approach will certainly work towards imparting speed to localized, in-store pick-up and combine it with the efficiency of large, automated warehouses. Delivery speed and costs are more important than ever to retain customers and foster brand loyalty. In fact, this will become a big differentiator for grocery e-commerce as the number of people making online grocery purchases has increased drastically the world over and a recent report indicated that in the US, 46% of people use online delivery more now than before the COVID crisis, and 40% use online pickup more.
2. Use big data to tie-in loose nodes
Supply chain management is held at the heart of every successful e-commerce company. Supply Chain efficiency always ensures that the right product reaches the right place at the right time. It ensures cost reduction and enhancement of cash utilization. That is why it is important to stay alert and tie-in all loose ends in the supply chain architecture. Big data can come in handy here and it is that quantitative method and structure that can be used to improve decision-making for all activities across the supply chain. While the role of big data is extremely exhaustive and full-pronged across the entire supply chain design, it is important to understand it in theory in a simplified way so that brands can incorporate it to make their backend operations seamless.
Big data is all about real-time analytics and it primarily does two very important things in making supply chain management easy
It expands the dataset for analysis beyond the traditional internal data held on Enterprise Resource Planning (ERP) and supply chain management (SCM) systems.
Big data apply powerful statistical methods to both new and existing data sources. This helps give structure to new insights. This in turn allows forecasting and helps improve supply chain decision-making capabilities for your brand, all the way from the improvement of front-line operations, to strategic choices such as the selection of the right supply chain operating models.
3. Improve ROI by introducing automation to the mix
Introducing Automation to Improve ROI
Introducing automation will help take care of tasks usually done manually, such as placing orders, processing changes, data entry, and much more. This frees up time and cuts down on human errors leading to error-free, faster processes. Adidas for instance has been able to reduce 60% of its operational supply chain costs just by switching to end-to-end automation. The largest sportswear manufacturer used automation across 400 factories by bringing in standardized, reusable processes to deliver the best results in a cost-effective way across the supply chain, marketing, finance, retail, and eCommerce. On the supply chain part, with automation, the brand was able to globally attend to supply chain service desk management, vendor onboarding, PO change management, Contract form approval, product data verification, and other such tasks in real-time. This highly successful initiative helped the brand save a lot of time, it earlier lost in manually attending to internal processes and reduced the time to market for Adidas by two-thirds. Moreover, automating systems helps cut down slacks and in return allows the supply chain to stay agile and alert for any unforeseen situations. This readiness further boosts the framework towards growth.
4. Eye the future and introduce robotics
Robotics is the next big thing in Future
Autonomous technology is not the next big thing of the future but is the most important thing at present defining the face of the supply chain. Autonomous robots are expected to see strong growth over the next five years. In fact, according to the Boston Consulting Group (BCG),the global robotics market is estimated to reach USD 87 Billion by 2025. It is believed that more than half of this will be allocated for the retail market. In fact, it is not uncommon to find giant beetle-like robots moving around busily with vertical shelves stacked on them inside Amazon’s warehouse in southern New Jersey, US. Tesco for instance uses Radio Frequency Identification (RFID) robots who are used to scan inventories for entire stores in just an hour (as against seven hours for a store employee) with far fewer errors.
Even though every word of this sounds too futuristic to be believable, this is the reality for now and retailers are beginning to realize that innovation must set in holistically and extend far beyond just the warehouse or supply chain.Autonomous mobile robots (AMRs) are fast becoming commonplace in warehouses, helping warehouse workers to fulfill orders quickly and efficiently. There are a few different types of robots that companies are considering, and each has its own unique set of advantages. AMRs in totality enable workers to be more productive due to constant collaboration and promote agility, cutting down on slacks and errors.
A cohesive and well-defined supply chain where you can leave enough room for tweaks in the future owing to evolving trends will surely help you gain an edge over your competitors through the entire lifecycle of your product. Getting a grip over the supply chain is necessary now as, by 2025, many supply chains may shift from global flows of goods and services to national, regional, and local networks of buyers and suppliers. So, integrating the supply chain keeping an eye on the global and local is the real deal!
The explosive growth of online shopping has forced brands to re-examine their e-commerce processes to stay competitive and profitable. In particular, out-of-stocks are a common, costly retail challenge, as product shortages frustrate online shoppers – and even prompt them to leave brands.
According to McKinsey & Company, forty-eight percent of consumers switched to a different brand in 2020 because those products were in stock. Among these consumers, seventy-three percent plan to keep using the new brands, linking product availability gaps to the erosion of sales and loyalty. Conversely, brands with effective inventory planning and replenishment can keep items in stock, drive sales and improve the customer experience.
Retailers like Walmart, collaborating with these brands to meet customer demand, are still facing inventory challenges but, as noted in 2021 Q3 earnings, inventory was up almost twelve percent year-over-year as they worked to stay ahead of increased holiday demand. They have also adjusted in-store operations to accommodate ever-growing e-commerce demands, especially within grocery-centric categories, as digital grocery buyers now amount to more than half the U.S. population.
Maximizing Conversions with Category Insights
Walmart’s dot-com strategy is paying off in spades, considering they surpassed Amazon as the leading U.S. grocery e-commerce retailer in 2020 and grew another forty-one percent in Q3, 2021. Our team has been actively tracking digital shelf analytic KPIs on Walmart.com to identify inventory and promotional performance improvement opportunities at a category level to support brands in capitalizing on these digital growth opportunities.
The latest analysis is summarized below, reviewing average category availability and discount trends occurring each week of the month, from May to August 2021, at a category level. A recent report found the 29th of each month to be the busiest day for online sales because consumers often get paid at the end of the month, which made DataWeave analysts wonder:
Which categories are maximizing their growth potential on Walmart.com and where are the greatest opportunities for improvement during periods of increased demand?
How do increased demand periods (like payday) impact category online availability?
Are category promotions offered at the right times throughout the month to best support demand?
When Seasonal Demand for Groceries and Payday Merge
Across all Walmart.com food categories tracked, Week 5 – where payday commonly falls for most consumers, had the lowest average product availability, while Week 4 had the highest average product availability for all categories except Deli and Fruits and Vegetables. These findings may inspire Walmart’s brand partners to rethink their inventory and assortment planning, replenishment and even pricing efforts to maintain a healthy stock closer toward the end of the month to match higher demand.
The categories with the greatest difference in average availability during Week 5 versus the rest of the month were Snacks & Candy, Beverages and Alcohol, indicating consumers consistently made these types of purchases closest to payday, when income was highest throughout the month. Seasonality is a secondary factor that influenced demand for these items given events like Memorial Day, Fourth of July, Summer Break, and Back-to-School shopping all took place during our analysis. Additionally, most holidays overlapped payday, which also furthered Week 5 demand.
Source: DataWeave Digital Shelf Analytics for Brands – Category average availability percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Coupling availability with discounts allows us to consider whether consumers buy more in Week 5 due to high discounts or increased purchasing power, or both. In reviewing the average category discounts offered within the same grocery-centric categories analyzed above, we found almost every grocery category showed a higher discount in Week 5 compared to the rest of the month, except for Bread & Bakery and Alcohol.
Source: DataWeave Digital Shelf Analytics for Brands – Category average discount percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Regarding Alcohol, during Week 4, when average availability was the highest, the average discounts offered were the lowest. This can indicate inventory was primed for payday shoppers (and the holidays of course). Bread & Bakery offers the greatest average discounts when inventory levels are lowest on average, indicating Week 3 is a great time to stock up, while Week 4 might be a great time to buy the freshest inventory.
The greatest average discounts in Week 5 were in Snacks & Candy, Pantry and Fruits & Vegetables. Deeper discounts for Snacks & Candy in Week 5 may have helped brands compete for consumers’ disposable income despite being a discretionary category. Pantry brands’ discounts may have reflected a need to compete for shoppers’ attention. During this period, consumers were out of the house more and less likely to use these grocery staples compared to earlier lockdown periods and cooler months.
Making Specialty Categories and Health a Priority for Online Shoppers
Interestingly, the only two categories where inventory was higher in Week 5 versus all other weeks each month were ‘Special Diets’ foods and ‘Summer Flavors’, although ‘Special Diets’ foods consistently maintained the lowest level of average availability each week across all food categories analyzed. This consistent lack of inventory could indicate a great opportunity for brands to increase inventory for dietary products sold on Walmart.com.
Source: DataWeave Digital Shelf Analytics for Brands – Category average availability percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
The average availability for ‘Summer Flavors’ foods verifies brands are maintaining a solid replenishment strategy for these seasonal items, and a high likelihood consumers will happily find what they need to plan their Summer gatherings on Walmart.com. One alarming factor we found was the change in average discounts offered during Week 5 versus Weeks 1 through 4, indicating promotions surrounding payday may be driving sales volume versus organic demand.
Source: DataWeave Digital Shelf Analytics for Brands – Category average discount percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Digital Growth Opportunity in Meal Kits and Kids’ Meals
Two categories primed for growth, according to Statista, are meal kits and kids’ food and beverages. Their research indicates retail sales for kids’ food has grown steadily year-over-year since 2013, and a recent report also indicates meal kit sales are expected to more than double 2017 sales in 2022, reaching $11.6 billion in the U.S., spurred by pandemic-induced demand. A concerning find in our research indicates both categories, ‘Easy Meal Solutions’ and ‘Kid Friendly Foods’ on Walmart.com, showed great volatility when it comes to in-stock availability. For example, in Week 1, ‘Easy Meal Solutions’ had an average availability nearly half the average of the rest of the month (around nineteen percent versus nearly thirty-eight percent), and in Week 5, payday week, ‘Kid Friendly Foods’ saw the biggest drop in average availability compared to Weeks 1 through 4 (over sixty-seven percent versus seventy-five percent) indicating supply may not be keeping up with the heightened demand.
Source: DataWeave Digital Shelf Analytics for Brands – Category average availability percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
The heightened average discounts offered during Week 5 for ‘Baby’ and ‘Pets’ items indicate two categories consumers will most likely stock up on during payday.
Source: DataWeave Digital Shelf Analytics for Brands – Category average discount percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Back to School Stock-Outs
U.S. retail sales unexpectedly increased in August, likely boosted by back-to-school shopping and child tax credit payments. Meanwhile, product shortages and other supply chain issues slowed 2021’s back-to-school sales, possibly affecting school supplies’ and clothing availability on Walmart.com. According to our analysis, the average product availability in Walmart.com’s school supplies category fell from over sixty-two percent during Weeks 1 through 4 to nearly forty-two percent in Week 5.
Warmer weather, seasonal events, reduced lockdowns, and vaccination efforts led more Americans to resume in-person socializing, giving reason to update their spring and summer wardrobes. In July, Forbes shared that three-quarters of shoppers are purchasing apparel, accessories and shoes the most. On average, only around sixty-three percent of clothing items were available on Walmart.com during Weeks 1 through 4. However, in Week 5, that figure plummeted to just over thirty-eight percent, the most significant drop among all categories.
Source: DataWeave Digital Shelf Analytics for Brands – Category average availability percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Demand for new fashion remained high throughout this period, seemingly fueled organically, as only moderate additional discounts took place in Week 5, and although the average discount on school supplies was only around twenty-seven percent during Weeks 1 through 4, it surged to just over forty-seven percent in Week 5. Generous additional discounts in Week 5 may have inspired online shoppers to shift spending from clothing to school supplies in late July and August ahead of students’ return to the classroom.
Source: DataWeave Digital Shelf Analytics for Brands – Category average discount percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Prioritizing Product Availability with Digital Advertising Strategies
Seventy-eight percent of B2C marketers increased their 2021 digital advertising spend to fuel online product discoverability (Share of Search), and sales and market share, but out-of-stock experiences simultaneously surged 172% this year from pre-pandemic levels. Paying for ads that drive traffic to your out-of-stock products can be as detrimental to your brand as a bad user experience. Our review of the ‘Featured Products’ sold on Walmart.com show consistent, low-levels of product availability each week throughout the months reviewed.
Source: DataWeave Digital Shelf Analytics for Brands – Category average availability percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
Additionally, the average discount offered on these products tended to be higher than most other categories reviewed, indicating brands participating in the featured product section of the website were not only investing in digital ads, but also doubling down with promotional activity as well.
Source: DataWeave Digital Shelf Analytics for Brands – Category average discount percentages from May to August 2021 between Week 1 (the 1st to the 7th day of the month) and Week 5 (the 29th, 30th and 31st day of the month).
How Brands can Replenish Their Digital Shelf
It is well known just how important it is to have products available during the right time of day, week, month, or season to improve customer satisfaction rates, but with your e-commerce store open 24/7 and omnichannel fulfillment strategies in place, it drastically changes the way in which strategic execution is prioritized for a retailer to reduce basket abandonment and for brands to build loyalty.
Our greatest takeaway from this analysis is realizing how crucial it is for brands to proactively track product availability and competitive pricing insights to stay ahead of the curve and achieve their digital growth goals. Early visibility to stock replenishment could help brands align with heightened cyclical and seasonal demand to avoid out-of-stocks and grow e-commerce sales.
This is why more leading brands now rely on our Digital Shelf Analytics solutions, including Pricing and Availability insights, to keep eCommerce planning agile, to maximize online conversions, and ultimately maintain shopper satisfaction and loyalty.