Sales and Inventory Management System in PHP and MySQL Download
September 14, 2024
Project: Sales and Inventory Management System in PHP Code Igniter and MySQL with Source Code
About Sales and Inventory Management System
This is a Sales and Inventory Management System project developed using Code Igniter PHP Framework and MDB Bootstrap Template. This project aims to help a particular company manage its sales transactions and stock monitoring. The system stores the product data and relevant information to collect the stocks and sales transactions such as the supplier list, customer list, price list, etc. The system can also create a Purchase Order and received a purchased product to update the stock quantity. Talking about the system’s price management, the system administrator can modify each product’s prices dynamically and has an effective date. This system also generates a simple report for the sales and purchases.
Features of Sales and Inventory Management System
The Sales and Inventory Management System is packed with features that are essential for effective inventory management. Here are some of the standout functionalities:
- User Authentication: Secure login/logout feature to protect sensitive data.
- Dashboard Overview: A dynamic dashboard providing an overview of monthly sales statistics and summaries.
- Supplier Management: Efficient management of supplier information and their associated products.
- Customer Management: Maintain a detailed list of customers and their transaction histories.
- Product Management: Manage product details, including specifications, pricing, and stock levels.
- Purchasing and Receiving Management: Create and manage purchase orders, and track received products.
- Inventory Management: Monitor stock levels and update as sales and purchases occur.
- Price Management: Dynamic adjustment of product prices with the option to set effective dates.
- Salesman Management: Track individual sales performance by managing salesman accounts.
- Reporting Features: Generate detailed sales and purchases reports, aiding in business analytics.
System Architecture and Technologies Used
The Sales and Inventory Management System is built on a powerful tech stack to ensure efficient performance and scalability. Below is a breakdown of the technologies utilized in its development:
- Framework: Code Igniter, a PHP framework noted for its speed and flexibility.
- Database: MySQL, providing a robust relational database for data storage and retrieval.
- Frontend Technologies:
- Bootstrap: For responsive design that ensures usability across devices.
- JavaScript, jQuery, and AJAX: Enhance interactivity and user experience.
Screenshots
The user interface of the Sales and Inventory Management System is designed with the user in mind. It is sleek, intuitive, and responsive. Below are some screenshots demonstrating the various modules within the application:
- Login Screen: Secure access point for users.
- Dashboard: Visual representation of current sales statistics.
- Product Management Page: Interface for adding and modifying product information.
- Sales Report Page: Detailed report generation based on various filters.
Sales and Inventory Management System Flowchart
- Login: Users start by entering their credentials, and the system identifies their role as either Admin (Manager) or Cashier.
- Admin Dashboard: If the user is an Admin, they can manage products, inventory, and generate reports.
- Manage Products: Allows Admins to add or update product details.
- Manage Inventory: Admins can adjust stock by adding or removing items.
- Generate Reports: Admins can create sales and purchase reports.
- Cashier Dashboard: If the user is a Cashier, they process sales transactions.
- Process Sales: Cashiers handle customer sales and record transactions.
sales-and-inventory-management-system-flowchart
Sales and Inventory Management System ER Diagram
- Admin (Manager):
- Handles all purchase transactions, linking them to Suppliers and managing product restocking.
- Each Purchase involves multiple items, represented by the PURCHASE_ITEM entity, which tracks the Product and quantity procured.
- Cashier:
- Records sales transactions linked to Customers through the SALES entity. Each sale can contain multiple PRODUCTS, tracked through SALES_ITEM.
- Product:
- The Product entity connects to both SALES_ITEM and PURCHASE_ITEM, ensuring that the inventory accurately reflects both sales and purchases.
- Customer & Supplier:
- Customers place orders, while Suppliers fulfill purchase requests. Each entity interacts with SALES and PURCHASE, respectively.
sales and inventory management system er diagram
This diagram reflects real-world inter connectivity in inventory management, where each entity has meaningful relationships with others.
Installation and Running the System
Above all, to run this project you must have installed a virtual server i.e XAMPP on your PC. urZONE CPanel optional.
Follow the following steps after Starting Apache and MySQL in XAMPP:
1st Step: Firstly, Extract the file
2nd Step: After that, Copy the main project folder
3rd Step: So, you need to Paste in xampp/htdocs/
Further, Now Connecting Database
4th Step: So, for now, Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: After that, Click on the databases tab
6th Step: So, Create a database naming “sims_db” and then click on the import tab
7th Step: Certainly, Click on browse file and select “sims_db.sql” file which is inside the “db” folder
8th Step: Meanwhile, click on Go button.
After Creating Database,
9th Step: Moreover, Open a browser and go to URL “http://localhost/sims”
**LOGIN DETAILS**
Admin
Username: admin
Password: admin123
Following these steps will set up the system for use on your local environment.
Conclusion
The Sales and Inventory Management System provides a complete solution for businesses looking to automate their inventory and sales tracking. With a user-friendly interface and real-time reporting, businesses can optimize their operational efficiency, reduce stock wastage, and improve overall sales performance.
