Curtain Crafts Inventory System
liveInventory and sales system for a multi-branch retail business
Overview
Curtain Crafts Inventory System replaces a multi-branch retail business's Excel-based stock and sales tracking with a real database system used daily by staff, managers, and the owner.
Problem
The business tracked stock and sales across multiple branches using Excel. This meant no real-time visibility into stock levels between branches, manual pricing updates prone to error, no accountability for who made a given sale, and no way for the owner to check business status without being on-site.
Solution
A database-backed inventory and sales system that replaced the Excel workflow entirely. Every sale is tied to the staff member who made it, supporting accountability and audit tracking. Role-based access controls what staff, managers, and the owner can each see and do, and stock updates are reflected in real time across branches instead of being reconciled manually at the end of the day.
Features
- Role-based access for staff, managers, and owner
- Per-sale user attribution for accountability and audit tracking
- Real-time stock visibility across branches
- Automated pricing logic, removing manual price entry errors
- Mobile access for the owner to check business status remotely
My Role
Built the system end-to-end: the data model for inventory and sales, role-based permission logic, and the migration path from the existing Excel-based tracking to the new database system, including getting staff onto the new workflow without disrupting daily sales.
Architecture
The system is built on Node.js with MongoDB as the data store, modeling branches, staff, inventory items, and sales as related collections. Every sale record is linked to the staff member who created it and the branch it occurred at, which is what makes per-sale accountability and audit tracking possible. Stock levels are updated transactionally as part of the sale flow so branch-level inventory stays accurate in real time rather than being batch-reconciled.
Technical Stack
Engineering Challenges
The hardest part was migrating an established business from an Excel workflow to a live database system without disrupting daily operations across multiple branches. This meant designing a data model that mapped cleanly to how staff already worked — so the new system felt like a faster version of their existing process, not a foreign tool — then layering in role-based access and audit tracking so the change improved accountability instead of just changing the interface.
Impact
Full migration from Excel to a database-backed system. Real-time stock visibility, automated pricing, improved accuracy across branches, and mobile access that lets the owner check business status without visiting in person.