This is a Stock Management System in PHP and
MySQL
Database. This is a web-based application that provides an online and automated platform for shops or businesses. This project can manage the company’s Purchase Orders, Receiving, Back Orders, returns, and Sales Records. The application has a pleasant user interface with the help of Bootstrap Library and AdminLTE template. This has also user-friendly functionalities.
About the Stock Management System
I developed this project using the following:
- XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
- PHP Language
- MySQL Database
- HTML
- CSS
- JavaScript
- jQuery
- Ajax
- Bootstrap
- AdminLTE
- and some other plugins/libraries.
This Stock Management System can be only accessed by 2 types of users which are the System Admins and Staff. The Admin User can access and manage all the pages, forms, and features do the web application does while the Staff Users have limited access only.
The Stock Records such as the Purchase Order, Receiving, etc. in this project have print features for each record. Talking about the flow of this project, first, the admin users must populate all the important lists which are the supplier list and the item list. Next, users will create a Purchase Order Record for a supplier. After that, users can receive the items in each purchase order which means PO Record is required in order to add stock of the item. Then, when receiving the items when the supplier will only deliver some of the items or not complete, the system will automatically create a new Back Order Record for the items that are not delivered yet. BO records work like the Purchase Order Record. Next, when the received items have problems, issues, or etc., the management can create the Return Record and upon saving this file, the system will also automatically deduct the damaged items to the stock availability. Lastly, the sales record is the record of the company for stocks that have been purchased by their clients or customers. Each stock listed in the sales record will also be deducted from the stock availability.
Features
- Secure Login and Logout
- Manage Supplier List (CRUD)
- Manage Item List (CRUD)
- Manage Purchase Order Records
- Create New
- Edit Record
- View Record
- Print Record
- Delete Records
- Manage Receiving Records
- Receive From PO (Purchase Order)
- Automatically Creates New Back Order for Lacking Items/Stocks
- Edit Record
- Print Record
- Automatically adds to Item stock availability
- Delete Record
- Manage Back Order Records
- View Record
- Receive BO
- Print Record
- Manage Return Records
- Create New Records
- View Record
- Edit Record
- Print Record
- Delete Record
- Automatically updates the stock availability upon saving
- Manage Sales Records
- Create New Records
- View Record
- Edit Record
- Print Record
- Delete Record
- Automatically updates the stock availability upon saving
- Manage Users list (CRUD)
- Manage Account Details/Credentials
- Manage System Information
Dashboard Page
How to Run ??
Requirements
- Download and Install any local web server such as XAMPP/WAMP.
- Download the provided source code zip file. (download button is located below)
Installation/Setup
- Open your XAMPP/WAMP’s Control Panel and start Apache and MySQL.
- Extract the downloaded source code zip file.
- If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP’s “htdocs” directory. And If you are using WAMP, paste it into the “www” directory.
- Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
- Create a new database naming sms_db.
- Import the provided SQL file. The file is known as sms_db.sql located inside the database folder.
- Browse the Stock Management System in a browser. i.e. http://localhost/sms/.
Default Admin Access Information
Username: admin
Password: admin123
DEMO VIDEO
Stock Management System in PHP & MySQL with Source Code
Leave a Reply