A Robust & User-Friendly Order Management Tool
Inspired by a need for streamlined product and order management, I designed this custom software solution, consisting of a client app, API and database, to integrate seamlessly with the Monday.com platform.
It simplifies tracking and organizing orders, offering a user-friendly interface that leverages the power of Monday.com for enhanced efficiency and collaboration.
How It Works
The Client Application is a React/Next.js app hosted on Vercel. The deployment is embedded within the Monday platform, along with interactive boards that display the order/product information dynamically populated by the API.
When the user: 1) Initiates an order using the Client Application; 2) Changes the status of an order using the Orders board on the Monday platform; or 3) Adds/edits/deletes a product offering using the Products (fragrances) board on the platform, webhooks within Monday are triggered, sending the data to the API hosted on Heroku.
Once an endpoint is hit, the API then leverages the ORM to perform CRUD via T-SQL Stored Procedures executed within the SQL Server database. The data displayed on the Monday boards is also mutated, ensuring consistency.
Technology Stack
The client app is built on React and Next.js, with Monday's Vibe Design library for custom components and Tailwind CSS for layout. The server is built using Node/Express, and leverages various tools to perform robust database CRUD while ensuring efficiency and security.
The Client Application is hosted on Vercel, the API on Heroku and SQL Server database on Microsoft Azure. This deployment stack was chosen for its speed, security, reliability and ease of use.
