Driving eCommerce excellence through innovative software development

Bipin Manandhar
Lead Developer

That’s exactly what was required when Proshore helped a scaling eCommerce platform sync thousands of different products and prices from hundreds of catering suppliers with thousands of restaurant owners.

Handling large volumes of product data​

“Multiple buyers are connected to multiple sellers. The challenge with this application was that for each of the thousands of products, there can be a discount or a price change. Every day, each price change has to be reflected on the front end of the website.”

Blinqed is a B2B eCommerce application which connects catering suppliers with restaurant owners, and streamlines the ordering process. It gives buyers the best possible prices, and sellers the flexibility to make their pricing more dynamic. 

Proshore initially came on board to provide Blinqed with the technical expertise they needed to make their application a reality. One of the initial challenges was to import huge volumes of historical product data and pricing from a legacy system into the new software.  As their business rapidly scaled, our attention shifted to how to handle increasing volumes of incoming data, and accelerate pricing updates for users on the front end.

Buyers want the best possible deal on their catering supplies, so the application provides dynamic pricing, which is controlled by the wholesaler. However, due to the sheer quantity of data, the time taken to parse this information was creating a bottleneck between the sellers’ enterprise resource planning (ERP) systems, and the price changes being reflected on the front end of the website. 

That’s when Proshore’s development team as a service stepped up to provide an innovative way of speeding up pricing changes on the front end.

Capacity to handle over 750,000 pricing changes per day

Every hour of every day, product information, including pricing, has to be pulled from multiple ERP systems. This is then reflected on the front end of the website. Data is dynamic and is completely based on buyer and seller activity. However, when a wholesaler has over twenty customers and each one of those has a bespoke catalogue of thousands of products, the amount of data flowing into the system soon stacks up. In terms of pricing change records, the system can handle over 750,000 record updates per day. And it was the parsing of all that product data for each customer that was slowing down the system. Importing and reading huge volumes of data meant that customers didn’t always see the most recent prices in real-time, there would be a delay in loading times – sometimes nearly 30 seconds per order page and occasionally crashing when buyers searched the product listing.  

To tackle the problem:

  • We requested that wholesalers only provide the updated product data, rather than submitting the entire product catalogue. 
  • With the help of a developer based in the Netherlands, we were able to filter the data so that all the relevant changes from an ERP system could be sent in a single file. 
  • We upgraded the AWS relational database based on need. Performance was monitored and queries were optimised to provide better scalability.
  • We also split the database into Reader and Writer instances, making it quicker to read data needed for the front end.   

These improvements reduced the amount of data flowing into the system which needed to be parsed. In turn, this increased the speed at which price changes appeared on the front end. In fact, over time, Proshore’s development team as a service reduced the time taken to parse one dataset from 4 to 5 hours down to under 10 minutes! 

You can learn more about how Proshore helped Blinqed to build and enhance its eCommerce platform by reading our complete case study.

6 minutes

Extra Capacity: 6 Ways To Work Well With Remote Teams

It’s no secret that using offshore developers and remote teams is a cost-effective way for software companies to add extra capacity and accelerate production. Not only does it help reduce…
Haico Duisters
Managing Director
6 minutes

How we built a Powerful and Customizable Dashboard for a Market-Research SaaS

Let’s say you’re looking for a front-end team who can handle a complex and customizable customer-facing dashboard in Angular. Finding the right tech talent locally might be a challenge. But…
Atul Shrestha
Web Developer
6 minutes

Proshore Bootcamp: More than a mentorship program

Proshore Bootcamp was born out of love for two things: IT and Nepal. As part of Proshore’s social mission to create better job opportunities for aspiring IT professionals working in…
Sumit Shrestha
Digital Marketer