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 |
|
|
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.
