challenge
Farmashop is a pharmacy retail chain with thousands of employees and more than 100 locations throughout Uruguay. In addition to their physical stores, they offer an ecommerce platform to purchase products online; sadly, the delivery for these purchases wasn’t efficient and that tarnished the customer experience. They had problems such as branches assigning deliveries independently, which meant there would be a drugstore with more orders than they could manage while a nearby store had delivery associates with no orders to fulfill. They reached out to us looking for a solution to improve the ecommerce delivery service and avoid losing loyal clients to other online retail options.
solution
We worked with the goal to dynamically optimize routing to deliver the ecommerce orders placed by customers. The process included creating a web app for managing the orders and a mobile app where delivery people can access the pickup and delivery information for each day. First, we set up the backend for route planning: we started by managing simple plans with a few deliveries and later we increased the complexity by adding more factors. Then, we started with the development of the web and the mobile app in order to move forward with the frontend as well and deliver the MVP. The entire process was enhanced by our design team, who conducted user interviews and testing sessions to make sure we were building the right solution.
results
We were able to create the right data sets for better usability – considering the many variables such as a vehicle’s capacity, timelines, locations and more. Using Celery and Google solutions such as OR-Tools, Maps and Distance Matrix, we created a solution that helped with synergy across all platforms and correct management of the many asynchronous tasks involved. Farmashop improved their customers’ experience – they can now use a seamless solution with reduced wait times and reliable delivery dates – and their internal logistics process (costs in gas and customer service have gone down). Since the platform can be scaled, it’s now being implemented in almost all of the stores. Initial metrics already pointed out we helped Farmashop achieve between 50% and 66% time reduction in the different delivery options offered to customers.
Want to learn more? Let’s talk.
Sparq Transforms Strategic IT Operations for 3PL
When a leading 3PL needed to free up their internal engineering teams for growth initiatives, we stepped in with seamless, scalable support. By managing over 30 essential applications across their ecosystem, Sparq helped reduce operational strain, improve performance, and save the client $250,000 annually.
Aligning Data and Teams to Meet a Critical Retail Deadline
Facing a critical reporting deadline, this global athletic apparel brand’s FP&A team needed an enhanced structure to guide decisions during peak season. Learn how we brought clarity, connection, and speed so they could deliver insights when they mattered most.
Scaling Global Retail Brand Operations with Digital Asset Management System
A global athletic apparel brand was losing time and momentum managing creative assets across a number of disconnected tools. Teams couldn’t reliably find, share, or reuse content, which slowed delivery and made it hard to maintain consistency at scale. They needed a secure, unified system that could keep up with a global brand and actually help their teams move faster.
Enhanced Insights and Data-Driven Decision Making for Center Street Lending
Center Street Lending provides smarter loans for residential real estate investors in 42 states. Their internal teams relied on visualizations to make data-driven decisions within their loan programs, but their data sources were fragmented and not automated. Learn how we helped establish a single source of truth for streamlined communication between stakeholders and teams, while improving the accuracy and accessibility of key organizational metrics and KPIs.