Do you want to know more?
We are at your service!
Data entryInitially each of the thousands of Colmar stores in the world was manually recorded in an excel file (transcribing and normalizing the address), which was then used as a data entry from the official website. This approach could generate a high error rate and typo, as well as a disproportionate expenditure of time and energy.
User ExperienceEvery time a potential customer made a search on the map the system was forced to make a call to Google to get the broadside of all the stores. The user, therefore, was faced with a messy map in which the shops were displayed in a chaotic way regardless of their location, thus giving them a negative, confusing and unfunctional experience. Once Google’s monthly call plan credit was consumed, it was no longer possible to view any information on the map.
SolutionAfter carrying out the swot analysis and a feasibility study, WWG has implemented digital transformation processes that have greatly optimized the workflow of Colmar leading to save time, money and resources. First of all, was introduced the automation of the data entry, eliminating all manual and superfluous processes but always maintaining the centrality of the data. Interactions now only occur between ERP, Google Maps and the e-commerce platform. The store geolocation process has also been automated: the initial geocoding through calls to Google Maps takes place only at the time of first insertion in the ERP or in the case of changes in the address. To optimize the costs of the plan’s calls, the application logic was moved from Google’s Apis to the backend, taking advantage of DB’s native geospatial queries. Finally, to improve the UX of the map was introduced the cluster logic, which shows the stores grouped according to their density on the territory, so that the user visualizes only the stores of his potential interest.
- Colmar was able to save a total of 320 hours per year that were previously used to generate store locations, select active ones and assign them a category.
- It was possible to reach zero downtime for calls to Apis, which before were so numerous to overcome the free platform ceiling. The company has thus saved over 20 million.