About the client

The client is a refreshment group located in the city of Rosario, Sinaloa, western Mexico. Its history begins in Rosario Sinaloa around the year 1880, where there was a boom derived from the activity of the town. El Rosario was the most prosperous town in northwestern Mexico. Within this vortex of development, there were two small soft drink bottlers in this town: La Eureka and La Azteca. The first, owned by Antonio Espinoza de los Monteros, was inside the “Sinaloense” pharmacy and made flavored soft drinks, among which was the house specialty: a fruit drink with a special touch of vanilla called for the owner of this factory: "Tony Co.", a name derived from the diminutive of Antonio "Tony" and "Co.", English abbreviation for Company. La Azteca, for its part, was also dedicated to the production of different flavored soft drinks and was owned by Don Enrique Castañeda. Their main product is a vanilla-flavored soft drink called Toni-Col.

Problem | Need

The client, derived from the situation presented with the pandemic, decides to analyze the creation of an ecommerce platform. After reviewing the implementation times and costs with different providers, decides to analyze alternatives and identifies that Amazon Seller may be a good first option to evaluate the acceptance of the online shop. During this analysis, it in turn identifies that the prices offered by the Amazon logistics platform are unattractive and therefore decides to use third-party logistics. The process of consulting logistics prices and updating products and their corresponding logistics costs is manual.

Solution

Nubiral proposes an AWS-based solution that allows automating these processes through the S3 and lambda microservices. The solution allows the client to automate first the price query process for the different defined routes, possible through the API that EnviaYa makes available. The price of logistics varies depending on the size of the products and the distance to travel. It will be consolidated in a SKU database with the different routes. And secondly, once this information is consolidated, through a CSV, the process of loading the SKUs with the different logistics values will be automated in the Amazon Seller portal. Charging will be done once a day. It is important to highlight that this solution is 100% scalable, allowing the inclusion of new routes or new SKUs at any time.

Results

The customer is now able to update their inventory in the Amazon Seller portal once a day without human intervention. This process previously forced the customer to only update the products and prices once a week, causing losses due to the increase in logistics costs (approximately 25%).