StockFlow is a web-based inventory management application designed to help small businesses efficiently manage products, categories, and stock movements. It provides real-time inventory tracking, low-stock alerts, and a user-friendly dashboard for monitoring business operations.
- 📦 Product management (CRUD)
- 🗂️ Category management
- 📥 Stock entry (supplier deliveries)
- 📤 Stock exit (sales)
- 📊 Real-time inventory calculation
⚠️ Low-stock alerts- 📝 Stock movement history
- 📈 Dashboard with inventory insights
- PHP
- MySQL
- HTML5
- CSS3
- JavaScript
- SQL
- Git & GitHub
The application includes tables for:
- Product Categories
- Products
- Stock Movements
It automatically calculates the current stock using SQL aggregation queries and tracks every inventory transaction.
StockFlow/
├── index.php
├── products.php
├── movements.php
├── css/
├── js/
├── assets/
├── database/
└── README.md
- Clone the repository.
- Import the MySQL database.
- Configure the database connection.
- Run the project using XAMPP, WAMP, or Laragon.
- Open the application in your browser.
This project demonstrates:
- CRUD operations
- Relational database design
- SQL JOINs and aggregate queries
- Inventory management logic
- PHP & MySQL integration
- Front-end development
- Back-end development
- Collaborative development using Git and GitHub
This project was developed collaboratively using Git and GitHub, following a version control workflow for feature development, merging, and collaborative coding.