CPE101 · Engineering Exploration
Web-Based Inventory Management System
A full-stack inventory application for managing product records, monitoring low stock, and sending daily notifications when quantities fall below configured thresholds.
- Status
- Completed
- Role
- Full-stack course project
- Source reviewed
- 31 January 2025
What it solves
A multi-branch inventory tool has to keep product quantities, sales, refills, users, companies, and branch-level notification settings connected. Staff also need early visibility when stock falls below each branch’s configured threshold.
The application combines product and organization management with role-aware administration, stock history, reporting cards, CSV export, and a scheduled notification route that checks every branch and posts low-stock summaries to configured Discord webhooks.
Architecture
- Role-gated Next.js
- Middleware protects App Router pages and directs administrators to their inventory screens.
- Company and branch scope
- Prisma's MongoDB models attach every product and user to a company and branch.
- Daily stock alerts
- Vercel runs a daily route that finds low stock and posts branch-specific Discord reports.
Technology
- TypeScript
- Next.js
- Prisma ORM
- MongoDB
The repository remains the source of truth for implementation details. Inspect the source