Skip to main content

Sales and Inventory System for Grocery Store

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, retrieval process will speed up and be able to generate immediate sales and inventory report. 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 be order. These major functions meet the objectives and expectations of the proponents likewise to the user of the CURE Grocery Store.

Product ListThe 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

Instructions

  1. Extract the files into you htdocs folder (if you’re using XAMPP).
  2. Create a database called “inventory” and import the file named “inventory.sql” under the db folder.

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

Add new comment