Overview

Type

Web Application

Industry

commerce and Enterprise Resource Planning (ERP)

Tech Stack

express.js

React

Business
Requirements

Create a Seamless Inventory and Sales Order Management Solution for an Ecommerce Business

The client, an ecommerce business with multiple franchises and branches, required a comprehensive platform to efficiently manage inventory and synchronize sales orders across various locations. The aim was to create a web-based application that could seamlessly integrate their online store with Ostendo ERP, providing a centralized solution for handling inventory, customers, and sales data in real-time.

Visit the website ⟶

Solution

Development Process

To address the client’s needs, we developed and deployed a scalable web-based application that integrates with Ostendo ERP. The solution was designed to provide separate sites for each branch, allowing both customers and employees to place orders directly through the portal. The integration facilitated real-time synchronization of sales orders with the main warehouse, ensuring accurate and up-to-date inventory management.

Key features of the platform included managing synchronization of customers, products, stock levels, and pricing between the online store and Ostendo ERP. It also allowed for generating custom reports in CSV and JSON formats, providing valuable insights into products and sales orders. An admin portal was also included, enabling efficient order tracking, approval or rejection of orders, and payment deductions on orders.

The backend was developed using Express.js and MongoDB, with Passport.js for secure authentication. For the frontend, we utilized React to create a dynamic and user-friendly interface. Stripe API was integrated for seamless payment processing. The solution was deployed using AWS EC2 and managed via cPanel for easy administration and scaling.

Key Features:

  • Seamless Integration: Facilitated real-time synchronization of sales orders, customers, products, stock levels, and pricing between the online store and Ostendo ERP.
  • Inventory Management: Enabled efficient management of inventory data across multiple branches, ensuring accurate and timely updates.
  • Custom Reports: Generated detailed reports in CSV and JSON formats, providing insights into products and sales performance.
  • Admin Portal: Provided functionalities for order tracking, administrative approval or rejection, and automatic payment deductions on approved orders.

Tools & Technologies

Performant Tech Stacks. Reliable Tracking

We focused on combining tech stacks that are stable and work seamlessly together. All the tools were selected based on a thorough analysis of the client’s requirements for responsiveness, data management, and security.

  • Backend:
    • Express.js, MongoDB, Passport.js (authentication)
  • Frontend:
    •  React
  • Payment Integration:
    • Stripe API
  • Deployment:
    • AWS EC2, cPanel

Solution

The Emerch platform successfully streamlined inventory management and automated sales order synchronization across multiple franchise and branch operations. The integration with Ostendo ERP enabled real-time data updates, reducing the complexity of managing separate inventory systems. The system’s robust user account controls and custom reporting capabilities provided greater transparency and improved coordination among branches, resulting in a more efficient and scalable ecommerce operation.