An Order Tracker Streamlines Two Magento Portals Under One Roof
About
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.
Project Highlights
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.
The Challenges
- Data Synchronization between website and MarketplaceThe 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 DashboardThe 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 FunctionalityThe 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 DatabasesThe 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.
Tech Stack
MongoDB
Angular
Community Edition
Lumen API
MySQL
Result
Enhanced Performance
Incorporated Angular JS and Lumen API significantly speed up the performanceData Synchronization
An auto scheduler framed resulted in a strong synchronization between Magento 1 and Magento 2 dataStreamlined Order Management
A scheduler and 50+ status restructured the order flow processHigher Revenue Generation
Eased out order flow ultimately lead to customer satisfaction and by that higher sales
