Some details
E-commerce system for a distribution business which manages products and orders across multiple marketplaces. ZappySales is a platform that optimizes the process of selling high SKU catalog via various marketplace channels.
Challenge:
In dropshipping business, databases powers the system. Our project has one database that combined all the information about orders, clients, and products. When
bulk vendors change the price of the product, the system updated the whole thing. We’ve got a high number of deadlocks as other functions were making requests to the database.Solution:
To overcome the issue we have done database normalisation. Our team created a new database with a clear structure that contained only prices for every item. Therefore, updates were performed separately, not overloading the main database.