Find out how ScraperDev by extracting data about competitors assortments helped an FMCG company optimize its procurement processes.
THE CLIENT STORY
Our client is a significant E-commerce beauty and FMCG products marketplace. Due to the huge variety of SKUs on the marketplace, the company met with risks related to assortment planning. They noticed that some products sold out before demand was met, whole others remained unsold for months. The company approached our ScraperDev team looking for a data-driven stable solution to their stocking issues and eliminating assortment inconsistencies.
Industry: Retail and e-commerce
Cooperation: 2021-2022
Location: France
“Reinventing assortment planning solution based on real-time data on the market”
Improved assortment planning system with the possibility to track real-time data on the market
INTRODUCTION
Retail industry challenges related to the products’ variety
Old-fashioned ways of doing business have now been overtaken by new, faster, and cheaper methods, such as web data scraping. Web scraping is mainly used by e-commerce businesses to monitor competitors’ prices, reviews, and availability. In this case we will highlight another less obvious application of web data scraping, Product Assortment Planning, and Optimization.
In order not to overload the competitors' sites we made sufficient intervals between requests and stretched each scraping session over several hours. We were careful to ensure that there was no critical loading put on the competitors' sites which may adversely affect his business.
THE SOLUTION
Building custom scrapers to organize data collection
We created a stable data pipeline with real-time data on the current inventory of the product. Our client could now track all changes in real time, and all the data we collected could be exported for further use. We checked all stocked products and their prices every day. These checks were done in two ways, firstly by writing directly on the site the quantity in the stock.
Secondly, we wrote a code for algorithm that adds a request to add random numbers of items to the card (for example, 5.000, 30.000, 150.000) to check the “error” which provides data on how many items are specifically on stock now.
THE RESULTS
Our client’s assortment process was improved, and led to increased profits of 47% over the following 4 months, with 85% accuracy in demand predicting
Thanks to ScraperDev we found the cheapest vendor on the market and saved around 70.000$ on the price difference of the product.
We get consistent and accurate data from our target websites and have successfully automated workflows that previously acted as bottlenecks.
We use review monitoring with ScraperDev for trends predicting sessions and to stock trending products. Before scraping our Marketing Team was doing it manually, but we are really happy to outsource it.
In the past, our NGO “Hands of Future” had to do everything manually, from scouring job listings to filling out forms. And now all that happens automatically, leaving us to focus on some of the more human aspects of the project.
Simply AMAZING. Our business was thinking about coding a simple scraper for a project, but finally, we outsourced it to ScraperDev. Worked perfectly. Saves a lot of time. Thanks for that!
A free data sample will be automatically sent to you.
We will contact you to book a termin.