Home

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.

Data Synchronization between website and Marketplace

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

The new backend has successfully automated many of the production steps, promoting efficiency and allowing internal leadership to focus elsewhere. Brainvire Infotech's accessibility, reliability, and strong customer service continue to impress.

Adam Gansky

Founder - 3d Innovation

224 Reviews

“The new backend has successfully automated many of the production steps, promoting efficiency and allowing internal leadership to focus elsewhere. Brainvire Infotech’s accessibility, reliability, and strong customer service continue to impress.”

Adam Gansky

Chief Commercial Officer, Novelty Product Manufacter

7 years ago

Similar Case Study

European Brand Enters into Ecommerce with Magento Store

Brainvire Develops a Customized Room Planner for Purchasing Home Furni...

An Order Tracker Streamlines Two Magento Portals Under One Roof

Tech Stack

About Client

About Product

The Challenges

Data Synchronization between website and Marketplace

Solution

The Challenges

Handling Two Databases

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

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

Result

Product Screens

Client Testimonials

Similar Case Study

Irving, USA

Mississauga, Canada

Dubai, UAE

Irving, USA

Plano, USA

New York, USA

UAE

Kuwait

Saudi Arabia

Singapore

Mumbai, India

Ahmedabad, India