Skip to main content

Sales and Inventory System for Grocery Store

Language


The CURE Grocery Sales and Inventory System with source code 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 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

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?

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Project
Yes