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

Language

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.

Sales Report

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.

Product List


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

Inventory Report

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byRuth Jama (not verified)on Sun, 05/13/2018 - 16:41

Hoping that I can make this project as a reference for my thesis. Thank You

Thank you for this.. btw the customer ledger is not responding, can you tell me how to fix it?
Submitted byAnonymous (not verified)on Sun, 05/17/2020 - 11:38

nice
Submitted byKumail Mehdi (not verified)on Fri, 08/14/2020 - 02:57

hi then Cashier click on checkout button anter customer name and price then save then show its error if cash= Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1364 Field 'due_date' doesn't have a default value in /opt/lampp/htdocs/sales/pages/cashier/savesales.php:31 Stack trace: #0 /opt/lampp/htdocs/sales/pages/cashier/savesales.php(31): PDOStatement->execute(Array) #1 {main} thrown in /opt/lampp/htdocs/sales/pages/cashier/savesales.php on line 31 and else credit then this erroe =. Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1364 Field 'amount' doesn't have a default value in /opt/lampp/htdocs/sales/pages/cashier/savesales.php:23 Stack trace: #0 /opt/lampp/htdocs/sales/pages/cashier/savesales.php(23): PDOStatement->execute(Array) #1 {main} thrown in /opt/lampp/htdocs/sales/pages/cashier/savesales.php on line 23
Submitted byHackio (not verified)on Thu, 12/31/2020 - 00:09

A nice project
Submitted byKevin0809 (not verified)on Mon, 03/15/2021 - 14:58

Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in C:\xampp\htdocs\sales\pages\view_exproduct.php:91 Stack trace: #0 C:\xampp\htdocs\sales\pages\view_exproduct.php(91): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\sales\pages\view_exproduct.php on line 91 Sir can you help me fix this issue? Nice system.

Add new comment