QR Code based Customer Billing System for Supermarket Shopping Project

ABSTRACT

The objective of this project is to propose a real-time capturing system that helps consumer billing for hypermart shopping using Quick Response (QR) code in Android smartphones.

EXISTING SYSTEM

Nowadays in most hypermart shops, customers have to take a long queue for billing after shopping and it’s a time-consuming process. Also, users will not be aware of the total bill amount at the time of purchase. Increase time spent at the billing counter and reduces customer satisfaction.

PROPOSED SYSTEM

When a customer entered a shopping mall or a hypermart for shopping, his smartphone will be connected to the hypermart’s server. After the successful connection with the server, he can start purchasing. At the time of shopping, the QR code should be read for bill generation. QR code pattern can be read by android smartphones at the time of adding an item to the cart. The QR code will identify the price of the product and it will automatically calculate the total price according to the quantity of the product in the cart. So QR code verifies products by capturing them through a smartphone, then decodes them and sends them to the server for authentication. When the user finishes his shopping, the total amount will be displayed on his phone as well as the cashier’s monitor. You can also visit & download the PHP, My SQL Application project on Supermarket Inventory Management System.

 This will avoid huge queues and waste of time for billing after shopping. The customer can plan his shopping whether to continue or not by viewing the purchase bills so that he can manage the bill and shopping effectively.

The project consists of two main modules.

Admin module

Admin will add the products with their price, manufacturing details, and quantity information. He can view the billing and purchase details of customers and generate daily, weekly, and monthly billing reports. Admin can add the products with their price, manufacturing details, and stock information without any duplication. Based on the arrival of new stock and purchasing the product from the stock, the stock quantity will be updated. He then generates a QR code for each product. He can view the billing and purchase details of customers. Accordingly, he can generate daily, weekly, and monthly billing reports.

User module

User can plan their shopping using this app. The user can register with the app. When he enters a hypermart, he can scan the QR code of the product and can view the corresponding product details. Then submit the quantity to be taken. He can finally submit his items in the cart to generate the bill and also have the facility to cancel items from the cart. 

This Supermarket Management and Billing System are related to the Customer Billing System for Supermarket Shopping Project. You can also visit & download the Java Application project on Supermarket Management and Billing System

SOFTWARE  REQUIREMENTS

  • Operating system:   Microsoft Windows XP/above, Android
  • Platform:   Net Beans, Eclipse
  • Front End:   JSP, Android
  • Back End:   MySQL

TABLES        

Table 1: Login

Primary key: username

Purpose: To store login details

Column

Type

Description

Username

varchar(50)

 Primary Key, Email id

Password

varchar(50)

 Password, unique password

User type

varchar(50)

 user type

Status

varchar(50)

 Status

Table 2: Customer

Primary key: customer_id

Foreign key: emailid

Purpose: To store customer details

Column

Type

Description

customer_id

int(50)

 Primary Key, customer id

customer_name

varchar(50)

Name of customer

emailid

varchar(50)

 Foreign Key , Email id

Phone_number

bigint(50)

 Phone Number of Customer

address

Text

 Address of Customer

appcode

varchar(50)

 App code

 

Table 3: Category

Primary key: category_id

Purpose: To store category details

Column

Type

Description

category_id

int(50)

 Primary Key, Category id

Categoryname

varchar(50)

 Category Name

 Table 4: stock

Primary key: stock_id

Foreign key: product_id

Purpose: To store stock details

Column

Type

Description

stock_id

int(50)

 Primary Key, Stock id

product_id

int(50)

 Foreign Key, Product id

Stockqty

bigint(50)

Quantity of Stock

Stockdate

date

Stock Added Date

Status

varchar(50)

Status

Table 5: product

Primary key: product_id

Foreign key: category_id

Purpose: To store product details 

Column

Type

Description

product_id

int(50)

 Primary Key, Product id

productname

varchar(50)

Product Name

category_id

int(50)

Foreign key, Category id

Quantity

bigint(50)

Quantity of product

manufacturingdate

date

Manufacturing Date

Expirydate

date

Expiry Date

Price

double

Price of Product

manufacturer

varchar(50)

Manufacturing company

Description

text

About the product

Madein

varchar(50)

Country name

Image

varchar(50)

Image of product

Qrcode

varchar(50)

Quick Response code

Status

varchar(50)

Status

Table 6: cart

Primary key: Cartid

Foreign key: Email

Purpose: To store cart details

Column

Type

Description

Cartid

int(11)

 Primary Key, Cart id

Email

varchar(50)

 Foreign Key, Email

Cdate

date

 

Flag

int(11)

 

Table 7: cart_item

Primary key: cart_item_id

Foreign key: Cartid , product_id

Purpose: To store cart item details

Column

Type

Description

cart_item_id

int(8)

 Primary Key, Cart item id

Cartid

int(8)

 Foreign Key, Cart id

product_id

int(8)

 Foreign Key, Product id

no_of_quantity

int(8)

 Quantity of product

 Table 8: purchase

Primary key: purchase_id

Foreign key: bill_no, Emailed, product_id

Purpose: To store  purchase details

Column

Type

Description

purchase_id

int(8)

 Primary Key, Purchase id

bill_no

int(8)

 Foreign Key, Bill No

Emailed

varchar(50)

 Foreign Key, Emailed

product_id

int(8)

 Foreign Key, Product id

purchase_date

date

 Product Purchased Date

Quantity

bigint(15)

 Quantity of product

Table 9: bill

Primary key: bill_no

Foreign key: Emailed

Purpose: To store bill details

Column

Type

Description

bill_no

int(50)

 Primary Key, Bill No

Emailed

varchar(50)

  Foreign Key, Emailed

Amount

int(50)

 Total Amount

bill_generate_date

date

Date of bill generated

Status

varchar(50)

 Status

Table 10: feedback

Primary key: feedback_id

Purpose: To store feedback details

Column

Type

Description

feedback_id

int(8)

 Primary key, Feedback id

from_id

varchar(50)

 Sender’s id

Message

varchar(50)

 Message

send_date

date

 Feedback send date

Download the complete Android app project on QR Code based Customer Billing System for Supermarket Shopping Project.

Also, Read this Sales Management System for Hypermarkets PHP & MySQL Web Application Project.

Leave a Reply

Your email address will not be published. Required fields are marked *