In-House Data: Online FMCG Out of Stock analyses

You’re looking at a series of quick in-house-made e-Commerce analyses that we post weekly on our LinkedIn page.
The results come from our data that are collected at every e-point of sale and analyzed by our consultants. 

Throughout the first lockdown that happened at the rise of the Covid-19 crisis, we kept analyzing the situation in different countries and measuring its impact on the global grocery e-commerce market. We still analyse the situation in different countries and different categories during the second lockdown.

 

Out of Stock
Analysis in the US

In the sheet below, you can see an analysis of the water category and a specific water manufacturer at Walmart. As the crisis arrived slightly later in the US, we noticed a high growth of the OOS in week 16 (April 13, 2020 to April 19, 2020).

analysis out of stock Walmart data impact water category COVID-19

Get a global or specific view of how individual brands are performing around key dates. We monitor more than 50 US retailers at more than 32,000 US online stores daily.

#fourthofjuly #4thofjuly #ecommerce 

2nd part of the sheet

Out of Stock
Analysis in the UK

On the right side, you can see the OOS evolution of chocolate and biscuit categories. The out of stock grew significantly in week 12 and continued increasing in week 13. On the left side, an interesting example of a biscuit manufacturer’s OOS per city in week 13. (February 10, 2020 to March 29, 2020)

UK analysis assortment out of stock tesco data impact chocolate biscuit category

In continuing the analysis in this country, the objective was to cross-reference out of stock data with its effect on assortment size. In the sheet below, you can see an analysis of a beer category at Tesco UK.
The OOS seem to be returning to the pre-Covid level and the situation seems to be stabilizing. However, the category size still remains 7% lower. (March 2, 2020 to May 10, 2020)

UK analysis assortment out of stock tesco data impact beer category

In the UK, Ocado’s spirits & beer online categories have reached their out-of-stock peaks during the Christmas holidays due to delivery purchase increase.

Analysis sheet UK out of stock spirits and beer for christmas

Our data analysis includes category-wide out of stock rates throughout Europe and North America. A store-level granular view is also part of our purview.

Grocery - sweet

Out of Stock
Analysis in Belgium

Here is an analysis on a beer category and a specific beer manufacturer at Delhaize Belgium. The out of stock doubled in week 14 and continued growing until week 16. (March 16, 2020 to April 19, 2020)

Belgium analysis out of stock evolution Delhaize data impact beer category

To compare the effect of the first lockdown to the second, we zoomed into the online personal and home care categories have reached the out-of-stock rate peaks between P03 and P04 2020 due to the lockdown.

Analysis sheet Belgium out of stock personal care & home care

Out of Stock
Analysis in France

Welcome to lockdown number 2 in France.
Since there has been a massive OOS on pasta in the first French lockdown, we looked into how is the pasta online category doing now. Lockdown 2 has doubled the out-of-stock rate between weeks 43 and 44, however, it remains dramatically lower than the first lockdown. (October 5, 2020 to November 1, 2020)

The second lockdown has doubled the Out of Stock rate of baby products online in France. The most impacted products in the category were diapers.

Analyse rupture de stock france produits bébé en ligne

Last-minute shopping has dramatically increased the out-of-stock rate on Christmas-related online categories.

Analyse France rupture de stock noel

The first week of february saw increased out of stock rates in spreads and jams, a result of its annual crepe day – la Chandeleur.

Analyse france ruptures stocks pates a tartiner et confitures

Out of Stock
Analysis in Spain

The case of Spain was our first analysis, we found ourselves confronted with an unexpected situation since the example of a chocolate manufacturer was very interesting at Carrefour for the out of stocks. As you can see, it grew significantly in week 12. (February 10, 2020 to March 22, 2020)

Grocery - sweet
spain analysis out of stock carrefour data impact biscuit coffee category

If you want to follow the analysis sheets that comes out twice a week on our linkedin page, you should have a look on our linkedin.

We hope we have brought you new knowledge. This concludes our Out of Stock Analysis page, keep in mind that it is updated day by day to guarantee you all the new trends you see in Out of Stock across the FMCG eCommerce markets.
If you are also interested, we invite you to check out our weekly eRetail Media analysis.

Don't miss a thing !

CPG ecommerce newsletter

Subscribe to our newsletter

Privacy policy

Data collection - Use of cookies - Consent

DataImpact undertakes to ensure that the collection and processing of your data, carried out from the www.dataimpact.io site, comply with the Data Protection Act and the RGPD. This processing is necessary for the execution of our services and the internal functioning of our company. For any information on the protection of personal data, you can also consult the site of the Commission Informatique et Liberté www.cnil.fr.

Identity of the data owner:

Personal data are collected by : Société par actions simplifiée DataImpact whose registered office is at 39 Rue Lucien Sampaix, 75010 Paris, RCS PARIS 799 367 222 T: +33 (0)1 42 51 87 08

Purpose - use of your data:

DataImpact is likely to collect personal data about you for the purposes necessary for its activity, whether in terms of recruitment, responding to your requests for information, execution and monitoring of service contracts. Types of data collected: DataImpact only collects data that is strictly necessary for the purposes of its activity. The personal data collected can be the following:

-In the context of a request for information (name, first name, email, telephone, company name).

-As part of a recruitment process: (surname, first name, email, telephone, company name), information on the curriculum vitae (marital status, surname, first name, date and place of birth, nationality, professional background, academic background, hobbies)

-If necessary, connection data including your IP address may be collected for purely statistical purposes.

Origin of the data:

The personal data collected by DataImpact are those directly given by the person concerned when using the contact form or surfing on the site www.dataimpact.io.

Intended transfers of personal data to a non-EU Member State:

To date, DataImpact does not transfer, nor envisage any transfer of your personal data to a non-European Union member state.

Retention period of the categories of data processed:

Connection data are kept at the latest within one year after connection to the www.dataimpact.io website.
Data relating to applicants for a post are kept at the latest five years after the last contact, with a view to possible recruitment.

Data of prospects are kept no later than three years after the last contact.

Customer data are kept for the duration of the service contract.

Protection of your data:

DataImpact ensures that its employees and service providers, subcontractors or hosts, also respect the absolute confidentiality of the information provided to them.

We maintain in-house electronic and organizational security measures in relation to the collection, storage, and communication of data.

Your rights under the Data Protection Act:

DataImpact takes all appropriate measures in order to facilitate the exercise of the rights of its clients regarding their personal data (right of access, rectification, deletion, limitation of processing, portability, to define the fate of its data after death).

The information provided in connection with the exercise of these rights is provided in writing or electronically. On request, the information may be provided orally. All requests should be sent by post to 739 Rue Lucien Sampaix, 75010 Paris or to [email protected].

In accordance with the regulations in force, your request must be signed and accompanied by a photocopy of an identity document bearing your signature and specify the address to which the reply should be sent. A reply will then be sent to you as soon as possible and in any event within one month of receipt of the request.

Flows out of your data after your death:

The new article 40-1 of the French Data Protection Act allows individuals to give instructions regarding the storage, deletion and communication of their data after their death.

You can read the procedure relating to these directives by following the following link: “https://www.cnil.fr/fr/ce-que-change-la-loi-pour-une-republique-numerique-pour-la-protection-des-donneespersonnelles#mortnumerique”.

Cookies:

You are informed that, during your visits to the www.dataimpact.io website, a cookie may, if necessary, be automatically installed on your browser software. A cookie is a small file stored on your computer. As such, it is a block of data that does not allow users to be identified but is used to record information relating to their browsing on the site. Cookies are used, on the one hand, to facilitate your navigation on the site and, on the other hand, for statistical purposes. In order to better know the frequentation of the site, we (mainly) measure the number of pages viewed, visitors, visits, as well as the activity of visitors on our site and their frequency of return.

The parameters of the browser software make it possible to inform about the presence of cookies and possibly to refuse them in the manner described at the following address “http://www.cnil.fr/vos-libertes/vos-traces/les-cookies/”.

You have the right to access, withdraw and modify personal data communicated through cookies under the conditions indicated above.

Terms of Service

Article 6 III of the Law of 22 June 2004

Société par action simplifiée DataImpact
39 Rue Lucien Sampaix, 75010 Paris
T: +33 (0)1 42 51 87 08
M: [email protected]
RCS PARIS 799 367 222

Director of publication: Yacine TERKI

Hosting : O2 SWITCH 222 Boulevard Gustave Flaubert 63000 Clermont-Ferrand

Terms and conditions of use:

The information contained and consultable on this site is provided for information purposes by DataImpact. They can be modified at any time without notice. Under no circumstances does it constitute advice or a service of any kind whatsoever. You assume full responsibility for the use of this site or the information it contains.

DataImpact cannot be held responsible for damages related to the consultation or use of the website by the user. Hypertext links may refer to third party sites over which DataImpact has no control.

DataImpact declines all responsibility for the content of these sites. The use of this service is reserved for strictly personal use. Any reproduction or representation, of all or part of the information, brochures or logos contained on the site, on any medium whatsoever, is prohibited. Failure to comply with this prohibition constitutes an infringement that may result in civil and criminal liability of the counterfeiter.