MugTrack is a full‑stack inventory tracker designed for small businesses managing physical products — starting with mugs, but built to scale. It features real‑time updates, form validation, and a PostgreSQL‑backed data flow for reliable inventory management.
- Frontend: React (Vite)
- Backend: Node.js + Express
- Database: PostgreSQL
- Dev Tools: DBeaver, VSCode, Git
- Add mugs with name, material, capacity, stock, and price
- Live polling for real‑time inventory updates
- Form validation with user‑friendly feedback
- Searchable inventory table
- Sales logging with stock reduction
- Low stock alerts
- Multi-user roles (admin, staff)
- Analytics dashboard
- Hosted backend + database
- Clone the repo:
git clone https://github.com/EliConz/mugtrack-inventory-system.git cd mugtrack-inventory-system\ - Install dependencies
npm install
- Set up environment variables
Create a .env file in the root directory with
DATABASE_URL=postgres://user:password@localhost:5432/mugtrack PORT=5000
- Run the frontend & backend from root folder
run npm dev
- Open in browser vist http://localhost:5173/
Pull requests are welcome. For major changes, please open an issue first to discuss what you’d like to change.
This project is licensed under the MIT License.