Overview

Developed a comprehensive web portal for a leading UK bed manufacturing company to manage products, customers, and orders. The system integrates with Sage200 through API for product pricing management and order flow, providing a seamless experience for managing complex inventory and sales operations.

Key Features

• Product Management: Complete product catalog management with dynamic product generator to streamline product creation process and manage different product configurations
• Customer Management: Comprehensive customer database with order history and relationship tracking
• Order Management: Full order lifecycle management from creation to fulfillment
• Sage200 Integration: Seamless API integration with Sage200 for product pricing management and order synchronization
• Admin Panel: Advanced admin panel features including inventory management and customer/product creation
• Product Generator: Enhanced product generator in phase two to manage pricing dynamically and import pricing data through Excel
• Database Migration: Successfully transferred database from MySQL to MongoDB for improved scalability
• CI/CD Pipeline: Managed CI/CD pipeline using GitHub, Jenkins, and Portainer for automated deployment

Technologies Used

• React: Frontend framework for building interactive user interfaces
• Node.js: Backend runtime environment
• Express.js: Web application framework for Node.js
• MySQL: Initial relational database
• MSSQL: Additional database support
• MongoDB: Migrated database for improved scalability
• GitHub: Version control and code repository
• Jenkins: CI/CD automation server
• Portainer: Container management platform

Challenges and Learnings

One of the key challenges was integrating with the Sage200 ERP system while maintaining data consistency and real-time synchronization. The solution involved creating robust API endpoints with proper error handling and retry mechanisms. Migrating from MySQL to MongoDB required careful data mapping and validation to ensure data integrity throughout the process.

Outcome

The system successfully streamlined operations for the UK bed manufacturing company, reducing manual data entry time by 60% and improving order processing accuracy. The scalable MongoDB architecture supports future growth, and the CI/CD pipeline ensures reliable deployments with minimal downtime.