This is a core system designed to centralize key business flows from customer management to order management.
- Public URL: Demo
(Auto-login as a guest user)
- Links orders and purchases, allowing management of gross profit per project.
- Suitable for businesses like wholesalers or dropshipping companies that don’t hold inventory.
Developed to streamline operations and leverage data effectively after the inefficiencies caused by using Excel for sales history and unnormalized data. This system centralizes business processes to improve sales performance.
- User Management: Employee registration, permissions, and termination management.
- Business Partner: Managing information for suppliers and customers.
- Contacts: Managing customer information linked to business partners.
- Leads: Tracking the origin of customer leads.
- Billing: Managing billing addresses with potential integration to accounting software.
- Shipping Addresses: Managing delivery addresses linked to business partners.
- Order Management: Linking orders with purchases for centralized management.
- Inquiries: Tracking customer inquiries and responses.
- Sales History: Logging sales-related interactions with customers.
- PHP: 8.2.9
- Laravel: 10.28
- React: 18.2
- AWS (EC2, Route53)
- MySQL: 8.0.36
- nginx: 1.22.1
- Docker (Development environment)
- Environment Setup
- Table Definitions
- ER Diagram:
- Infrastructure Diagram:
- Register and manage business partner information with multiple contacts and shipping addresses.
- View orders with sales/purchase details and manage gross profits.
- Track customer inquiries and select customer information asynchronously.
Ensured high scalability and maintainability with normalization and proper table segregation.
- Asynchronous data retrieval for managing master data during entry.
- Customizable inquiry types based on user needs.
- Responsive design for mobile compatibility.
- Simplified product registration in a single screen.
- Date range picker for easy filtering.
- Commit Messages: Followed AngularJS’s prefix rule for easy-to-understand commit messages.
- Commit Granularity: Ensured changes are related and easily understood during code reviews.
- Git Workflow: Used GitHub flow with branches, push, PR, and merge processes.
- Coding Standards: Followed back-end PRS-12 and front-end Google HTML/CSS guidelines. Applied ESLint and EditorConfig for consistency.
- API Integration with Accounting Software: Developing an API to synchronize billing master data and automate reconciliation tasks.
- Quotation Generation: Automatically generating quotations linked with business partners, inquiries, and orders.