1 Project Manager
2 Back-end developers
1 Front-end developers
1 QA
1 Project Manager
2 Back-end developers
1 Front-end developers
1 QA
Java 8, Spring JDBC Template, MS SQL, Jenkins, Amazon API, eBay API, AngularJS
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.
Our goal was to build a system able to buy products from a bulk seller and sell them on various marketplace simultaneously.
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.
Our task was to change the java code for functions dealing with prices in the system. We changed business logic and updated about 1 000 000 items on every marketplace. This challenge allowed us to play with logic and to accelerate connections between stores and system.With new business logic, after the client makes an order, a system in a runtime monitors identical products from all the vendors and assign a request to the one having the lowest price.
The challenge was to dig in the database and save dependencies product names. For example: 'SomeBrandName' has relation to 'SomeNameBrand Inc'. This task was done using SQL. We added two new tables which stored relation between brand names.
We came up with the new business logic to decide which items to keep and which to delete. After determining we removed duplicate items from marketplaces and linked them in our system with remaining ones.
Our team managed to deliver a complex solution for e-commerce workflow automation. The system structure consists of three modules: Module that handles flow between the marketplace and bulk sellers, vendor dashboard and product manager dashboard.
Workflow module orchestrates orders. There are two flows of functions, first of all, the system receives orders from the different marketplace and process them (filter, calculates profit and selects vendor with the most favorable price) and send submitted order to the seller. When the seller formed order and send it to the buyer, the system receives an invoice that further goes to buyer account on the marketplace.
Please, leave your email down below and we will send you our portfolio in PDF format