An Order Tracker Streamlines Website And Marketplace Under One Roof

Tech Stack

Angular
Community Edition
Lumen API
MongoDB
MySQL

About Client

The client is New York, the USA based, a leading manufacturer and supplier of 3D laser etched crystals. It has 30+ retail centers across the country and the business is rapidly growing on ecommerce due to innovative gift and decoration products. The products are the great combination of imagination and technology. The products are comprised of personalized and crystalized memories in terms of photos and words in a variety of lightning crystals. This business has become very popular in quite a shorter time. Because of the huge user base, order and shipment flow, the client is now strengthening its back-end and front-end systems.

About Product

As mentioned above, the client required a robust back-end system to streamline the processes after the product purchase. The product named 3D Tracker is an order tracker system consisted of 50+ product status. A scheduler module is developed especially to pull orders in a more synchronized format. There was a system where the website data was used to be captured in M1 database and the data coming from marketplace was in M2 database. So a special extension was developed to bring both the data under one roof in order to process order smoothly. A full-fledged dashboard was developed with a customized block of status, status-wise percentage, rework orders, supply orders, status-wise orders etc. Moreover, the search mechanism was engineered with pre-filled search criteria in order to make the product searching easy for the user. Overall, an order tracker system helped client via keeping everything under one roof so that client could determine overall strategies for marketing and sales.

before

The Challenges

before-ring

Data Synchronization between website and Marketplace

The client website was developed using Magento 1. The order data falls under that database. Plus, the data coming from Marketplaces falls in Magento 2. The client required the synchronization of both the database.

Brainvire’s data experts and developers sat together, analyzed and identified the order data behavior patterns and came up with the Magento extension that maintains a sync between both the data. In addition to that, the auto refresh module was also developed to take data update at regular intervals.

Solution

The Challenges

Handling Two Databases

The system was built for handling orders from 2 Magento portals. One was built in Magento 1 and another one in Magento 2. Both were having different database architecture and schema and as per requirement, the data required to be copied on another common database which needed to be able to handle both of these database records. Plus, the system was having many users and require to make a flow smooth with a large number of data.

The development team understood the each and every collaboration with the APIs and came up with a robustly integrated module that communicates with third-party systems and delivers the accurate results to clients on screen.

Data Synchronization between website and Marketplace

The client website was developed using Magento 1. The order data falls under that database. Plus, the data coming from Marketplaces falls in Magento 2. The client required the synchronization of both the database.

Brainvire’s data experts and developers sat together, analyzed and identified the order data behavior patterns and came up with the Magento extension that maintains a sync between both the data. In addition to that, the auto refresh module was also developed to take data update at regular intervals.

Dynamic Dashboard

The client required two types of rich dashboards – admin dashboard and local dashboard. Moreover, the client needed a clickable thing which means that by clicking on the particular column of the report, the detailed report gets be displayed on the screen.

Brainvire’s efficient and experienced developers, first of all, designed the dashboard as per client requirements and crafted a fully functional module. As a result, the developers came up with many feature-rich reports such as design reports, add-on reports, QA approved reports, Sales reports, damage reports, and rework reports. Using Angular JS at the front end, the developers developed clickable orders on the dashboard, when clicked opens a detailed version of the report.

Advanced Search Functionality

The client asked the search mechanism with pre-filled data in order to simplify the search functionality. There needed asynchronous calls to the database to filter the products as per user enters the letters.

Brainvire’s Angular JS experts crafted an advanced search function which continuously interacts with the database as user types in the search bar. Brainvire’s experienced QA team ensured that every single product can be accessible via pre-filled search functionality.

Handling Two Databases

The system was built for handling orders from 2 Magento portals. One was built in Magento 1 and another one in Magento 2. Both were having different database architecture and schema and as per requirement, the data required to be copied on another common database which needed to be able to handle both of these database records. Plus, the system was having many users and require to make a flow smooth with a large number of data.

Data Synchronization between website and Marketplace

The client website was developed using Magento 1. The order data falls under that database. Plus, the data coming from Marketplaces falls in Magento 2. The client required the synchronization of both the database.

Dynamic Dashboard

The client required two types of rich dashboards – admin dashboard and local dashboard. Moreover, the client needed a clickable thing which means that by clicking on the particular column of the report, the detailed report gets be displayed on the screen.

Advanced Search Functionality

The client asked the search mechanism with pre-filled data in order to simplify the search functionality. There needed asynchronous calls to the database to filter the products as per user enters the letters.

Handling Two Databases

The system was built for handling orders from 2 Magento portals. One was built in Magento 1 and another one in Magento 2. Both were having different database architecture and schema and as per requirement, the data required to be copied on another common database which needed to be able to handle both of these database records. Plus, the system was having many users and require to make a flow smooth with a large number of data.

Result

Enhanced Performance
Incorporated Angular JS and Lumen API significantly speed up the performance
Data Synchronization
An auto scheduler framed resulted in a strong synchronization between Magento 1 and Magento 2 data
Streamlined Order Management
A scheduler and 50+ status restructured the order flow process
Higher Revenue Generation
Eased out order flow ultimately lead to customer satisfaction and by that higher sales

Product Screens

Client Testimonials

I would recommend Brainvire to anyone. They’re a very talented group of software engineers. They’ll tackle any challenges and take scope changes in stride. Along with their responsiveness, their team is communicative and dedicated.

Mike Luhtanen

Founder - Creative LLC

152 Reviews

“They handle all their work with a personal touch, which encourages a continued long-term partnership.Their deliverable are reliable thanks to vigorous QA testing. I would recommend Brainvire to anyone. ”

Mike Luhtanen

Founder, Creative LLC

5 months ago