Skip to main content

Simple Grocery Store Sales And Inventory System using PHP/MySQL with Source Code

Language

PROJECT: Grocery Store Sales and Inventory System Using PHP/MySQL

About The Project

The Grocery Store Sales and Inventory System is a simple PHP project with source code, This Sales and Inventory System  will help grocery stores to manage their inventory stock and monitor their sales daily. The grocery store daily sales will be stored in the system and can be easy to track and be monitored. This simple project will calculate the product stock available for the grocery store automatically so the admin or the owner of the store can check if a certain product needed to be restocked.

The source code itself is easy to customize for any enhancement or modification to cater the daily process of a certain grocery store that is related to their inventory and sales management or also any other process they want to be added to the system.  The Simple Grocery Store Sales and Inventory System have 2 types of user which are the admin and the cashier. The Admin can of can manage all in an aspect of the system and the cashier can only manage the sales and view the inventory for stock monitoring.

Features

  • Login Page

    • The page where users will enter their credentials to access the Sales and Inventory System of the store.
  • Home Page
    • The page where the user will be redirected by default after logging into the system.
  • Category Page
    • The page where can admin manage the list of product categories of a certain grocery store have.
  • Product Page
    • The page where the admin can manage all the products of the store in the system.
  • Supplier List Page
    • The page where all suppliers of the grocery store are listed and can be managed only by the system admin.
  • Customer List Page
    • The page where all customers of the grocery store are listed and can be managed by admin.
  • Receiving Page 
    • This the page where the admin will encode the grocery store purchases in order to restock a product in inventory and monitoring.
  • Inventory Page
    • The page were all products of the grocery store are listed with the count of stock that has been purchased from the store and stock that has been purchased from the supplier and the total stock that are available.
  • Sales Page
    • The page where can admin and cashier will encode and the purchases of a certain customer from the store to allow the system recalculate the inventory stock of the grocery store. On this page where can also the customer purchases can be printed or as the unofficial receipt of the transaction between the customer and the grocery store.
  • Users Page
    • The page where  can admin managed all the system users.

How to Run the Project

  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 sales_inventory_db.
  4. Import the SQL file located in the database 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-inventory-system-using-php] 

Default Admin Access:

USERNAME: admin

PASSWORD: admin123

The Grocery Store Sales and Invnetory System source code was developed using HTML, CSS, PHP, MySQL, JavaScript (jQuery and Ajax) and Bootstrap for the design. In this project, all forms is being submitted using Ajax for better user interaction of the user when using the sales and inventory system.

I hope this simple Grocery Store Sales and Inventory System project will help you with what you are looking for. Feel free to download the source code and enhance or modify it in the way you want.

Enjoy!

Explore on this website for more Source Code and Tutorials.

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 byTimothy Bagona (not verified)on Fri, 10/23/2020 - 01:38

Thank you for the code but I encountered a problem. When I'm about to edit or delete an item in the product list on #11 and above, the edit and delete button is not functioning. What is the possible problem here? I'm using xampp. Thank you very much if you or anyone will reply on my problem.

Add new comment