Sales and Inventory System for Grocery Store using PHP/PDO Full Source Code

The CURE Grocery Sales and Inventory System will help the business track sales activity easily, inventory and to ensure that transactions are completed correctly. With the use of the system, the retrieval process will speed up and be able to generate immediate sales and inventory reports. The data are being stored in the system’s database. The admin is the only person who can add, edit, and update products and customers while the cashier can only manipulate the collection payments of customers’ purchases.

By checking in the system, it will be easy to identify the number of available products, which products are few, and which is needed to order. These major functions meet the objectives and expectations of the proponents likewise to the user of the CURE Grocery Store.

The following are the modules included in this system:

Front End

• Point of Sale

Back End

Masterfiles:

• Product
• Customer
• Supplier

Transactions:

• Purchase Order
• Customer Ledger

Reports:

• Accounts Receivables Report
• Collection Report
• Sales Report
• Inventory Report
• List of Product Expired
• Report of Returned Products
• Customer Transaction Record

Charts:

• Graph by Category
• Graph For Cash and Credit
• Graph For Losses
• Monthly Sales Chart
• Yearly Sales Chart

How to Run

1. Download the source code and extract the zip file.
2. Download or set up any local web server that runs PHP script.
3. Open the web-server database and create a new database name it "inventory".
4. Import the SQL file located in the db folder of the source code.
5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
6. Open a web browser and browse the project. E.g [http://localhost/sales] /li>

Account Info

Admin

user: admin
pass: admin123

Cashier

user: cashier
pass: 12345