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.