A PROJECT REPORT
ON THE TITLE
STORE BILLING SYSTEM
FOR
AISSCE 2022 EXAMINATION
As a part of the Informatics Practices Course (083)
SUBMITTED BY:
Name of the Student:
Under the guidance of
Ms. C.Rampriya MCA M.Phil B.Ed.
PGT in COMPUTER SCIENCE
DEPARTMENT OF COMPUTER SCIENCE
Adithya International School
S.F.NO 222, Lakshmi Nagar, Senamanickenpalayam, Road,
Idigarai, Coimbatore- 641022.
CERTIFICATE
This is to certify that the Project / Dissertation entitled
______________________________is a bonafide work done by
Mr./Ms_______________________ of Class-XII in partial fulfillment of CBSE’s AISSCE
Examination 2021-22 and has been carried out under my direct supervision and guidance.
This report or a similar report on the topic has not been submitted for any other examination
and does not form a part of any other course undergone by the candidate.
_____________________________ _____________________________
Signature of Student Signature of Teacher/Guide
Name: _________________________ Name: Ms.C.Rampriya
Roll No.: _______________________ Designation: PGT in CS
Place: Idigarai, Coimbatore
Date: _____ /_____ /_______
_____________________________
Signature of Principal
MR. MURUGAIAH.M
DECLARATION
I hereby declare that my project on the title
______________________________________________ is submitted in partial fulfillment of
CBSE’s AISSCE Examination 2021-22 and has been carried out by me under the guidance
and supervision of Ms. C.RAMPRIYA
Idigarai, Coimbatore
ACKNOWLEDGEMENT
At the outset, I bow down before the God Almighty for his blessings without which I
would not have completed this endeavor successfully.
I am thankful to MrMURUGAIAH.M, Principal, Kathir Vidyaa Mandhir,
Neelambur, for his approval of the project and his valuable guidance
I gratefully acknowledge my indebtedness to my guide Ms.C.Rampriya, for her
meticulous guidance and constant encouragement throughout my project. I would also extend
my thanks to Ms.Varshini, for all the technical support put forwarded to my work. I would
like to extend my wholehearted gratitude to the Management and all those who have directly
and indirectly helped me during the course of work.
CONTENTS
Abstract
System requirements and Specifications
Coding
Screen shots
Conclusion
Bibliography
ABSTRACT
This system is built for fast data processing and bill generation for
customers. The billing system consists of a sql database and effective front end
designed in python. The billing database is a vast collection of product name,
price and other product specific data. A product when billed is searched from
the database and its price is added to the bill based upon the product quantity.
The system also contains discounts on various products so that the product is
offered at discounted price while billing. The billing system is built to help
stationary shop to calculate and display bills and serve the customer in a faster
and efficient manner. This software project consists of an effective and easy
GUI to help the employee in easy bill calculation and providing an efficient
customer service.
SYSTEM REQIUREMENTS
HARDWARE COMPONENTS
1. VGA Monitor
2. Qwerty keyboard
3. 2 GB RAM
4. 2.6 GHz Processor
5. Graphics card
SOFTWARE COMPONENTS
1. Windows 7
2. Python 3.7 with suitable modules
3. MYSQL 5.5
CODING
import mysql.connector
conn=mysql.connector.connect(user='root',passwd='puc123',host='localhost',dat
abase='store')
myc=conn.cursor()
o="y"
while(o=="y" or o=="Y"):
c=str(input("enter your choice(S\C\E\G\X):"))
#press S for generating stationary bill
#press C for generating clothing bill
#press E for generating electrical appliances bill
#press G for generating grocery bill
#press X to exit from program
if(c=="S" or c=="s"):
print("STATIONARY BILL")
date=input("invoice date:")
impt=int(input("no. of item purchase:"))
print("details of customer")
customer=str(input("customer's name:Mr./Miss:"))
address=str(input("customer's adress:"))
city=str(input("customer's city:"))
state=str(input("customer's state:"))
mobilenumber=int(input("customer's mobile number:"))
total=0
maxitem=41 # maximum number of items can be purchased at a time
if(impt<=maxitem):
for a in range(1,impt+1):
print("serial no:",a)
i=str(input("item:"))
rate=float(input("price of item in rupees:"))
qty=int(input("quantity of item purchased:"))
value=qty*rate # total price of product with no. of quantity
print("Total price:",value) # total amount of particular product
total=total+value # total amount of all products
sql="insert into item (serial_no,item_name,price,quantity) values({},'{}',
{},{})".format(a,i,rate,qty)
myc.execute(sql)
conn.commit()
print("Items Purchased Till Now:")
myc.execute('select * from item')
data=myc.fetchall()
for row in data:
print(row)
print("Total Amount:",total)
gst=28/100
gtax=total*gst #gst taxed amount
price=total+gtax # total amount of all products after adding gst
if(total<100):
print("Final price:",price)
elif(total>=100 and total<=800):
discount=5/100
dprice=total*discount # discount amount
print("Final price:",price-dprice)
elif(total>800 and total<=5000):
discount=15/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>5000 and total<=14000):
discount=20/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>14000):
discount=25/100
dprice=total*discount
print("Final price:",price-dprice)
else:
print(" Sorry You Can Only Buy 41 Items At A Time")
print("STATIONARY BILL")
elif(c=="C" or c=="c"):
print("CLOTHING BILL")
date=input("invoice date:")
impt=int(input("no. of item purchase:"))
print("details of customer")
customer=str(input("customer's name:Mr./Miss:"))
adress=str(input("customer's adress:"))
city=str(input("customer's city:"))
state=str(input("customer's state:"))
mobilenumber=int(input("customer's mobile number:"))
total=0
maxitem=41 # maximum number of items can be purchased at a time
if(impt<=maxitem):
for a in range(1,impt+1):
print("serial no:",a)
i=str(input("item:"))
rate=float(input("price of item in rupees:"))
qty=int(input("quantity of item purchased:"))
value=qty*rate # total price of product with no. of quantity
print("Total price:",value) # total amount of particular product
total=total+value # total amount of all products
sql="insert into item (serial_no,item_name,price,quantity) values({},'{}',
{},{})".format(a,i,rate,qty)
myc.execute(sql)
conn.commit()
print("Items Purchased Till Now:")
myc.execute('select * from item')
data=myc.fetchall()
for row in data:
print(row)
print("Total Amount:",total)
gst=8/100
gtax=total*gst #gst taxed amount
price=total+gtax # total amount of all products after adding gst
if(total<800):
print("Final price:",price)
elif(total>=800 and total<=6000):
discount=5/100
dprice=total*discount # discount amount
print("Final price:",price-dprice)
elif(total>6000 and total<=11000):
discount=15/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>11000 and total<=15000):
discount=20/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>15000):
discount=25/100
dprice=total*discount
print("Final price:",price-dprice)
else:
print(" Sorry You Can Only Buy 41 Items At A Time")
print("CLOTHING BILL")
elif(c=="E" or c=="e"):
print("ELECTRICAL APPLIANCES BILL")
date=input("invoice date:")
impt=int(input("no. of item purchase:"))
print("details of customer")
customer=str(input("customer's name:Mr./Miss:"))
address=str(input("customer's adress:"))
city=str(input("customer's city:"))
state=str(input("customer's state:"))
mobilenumber=int(input("customer's mobile number:"))
total=0
maxitem=41 # maximum number of items can be purchased at a time
if(impt<=maxitem):
for a in range(1,impt+1):
print("serial no:",a)
i=str(input("item:"))
rate=float(input("price of item in rupees:"))
qty=int(input("quantity of item purchased:"))
value=qty*rate # total price of product with no. of quantity
print("Total price:",value) # total amount of particular product
total=total+value # total amount of all products
sql="insert into item (serial_no,item_name,price,quantity) values({},'{}',
{},{})".format(a,i,rate,qty)
myc.execute(sql)
conn.commit()
print("Items Purchased Till Now:")
myc.execute('select * from item')
data=myc.fetchall()
for row in data:
print(row)
print("Total Amount:",total)
gst=18/100
gtax=total*gst #gst taxed amount
price=total+gtax # total amount of all products after adding gst
if(total<1200):
print("Final price:",price)
elif(total>=1200 and total<=4000):
discount=5/100
dprice=total*discount # discount amount
print("Final price:",price-dprice)
elif(total>4000 and total<=7000):
discount=15/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>7000 and total<=12000):
discount=20/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>12000):
discount=25/100
dprice=total*discount
print("Final price:",price-dprice)
else:
print(" Sorry You Can Only Buy 41 Items At A Time")
print("ELECTRICAL APPLINCES BILL")
elif(c=="G" or c=="g"):
print("GROCERY BILL")
date=input("invoice date:")
impt=int(input("no. of item purchase:"))
print("details of customer")
customer=str(input("customer's name:Mr./Miss:"))
address=str(input("customer's adress:"))
city=str(input("customer's city:"))
state=str(input("customer's state:"))
mobilenumber=int(input("customer's mobile number:"))
total=0
maxitem=41 # maximum number of items can be purchased at a time
if(impt<=maxitem):
for a in range(1,impt+1):
print("serial no:",a)
i=str(input("item:"))
rate=float(input("price of item in rupees:"))
qty=int(input("quantity of item purchased:"))
value=qty*rate # total price of product with no. of quantity
print("Total price:",value) # total amount of particular product
total=total+value # total amount of all products
sql="insert into item (serial_no,item_name,price,quantity) values({},'{}',
{},{})".format(a,i,rate,qty)
myc.execute(sql)
conn.commit()
print("Items Purchased Till Now:")
myc.execute('select * from item')
data=myc.fetchall()
for row in data:
print(row)
print("Total Amount:",total)
gst=4/100
gtax=total*gst #gst taxed amount
price=total+gtax # total amount of all products after adding gst
if(total<200):
print("Final price",price)
elif(total>=200 and total<=500):
discount=5/100
dprice=total*discount # discount amount
print("Final price:",price-dprice)
elif(total>500 and total<=900):
discount=15/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>900 and total<=15000):
discount=20/100
dprice=total*discount
print("Final price:",price-dprice)
elif(total>15000):
discount=25/100
dprice=total*discount
print("Final price:",price-dprice)#final price is calculated after adding
gst
else:
print(" Sorry You Can Only Buy 41 Items At A Time")
print("GROCERY BILL")
elif(c=="x" or c=="X"):
exit()
else:
print("PLEASE ENTER A VALID PRODUCT CATEGORY")
print(" S for generating stationary bill")
print(" C for generating clothing bill")
print(" E for generating electrical appliances bill")
print(" G for generating grocery bill")
t=""" ,,,,,,,THANK YOU,,,,,,,
,,,,VISIT US AGAIN,,,,"""
print(t)
o=input("want to run again y/n or Y/N")
SCREENSHOTS
CONCLUSION
The system has been developed with much care and free of errors and at the same
time it is efficient and less time consuming. The entire system is secured. Also the project
helped us understanding about the development phases of a project and software development
life cycle. We learned how to test different features of a project. This project has given us
great satisfaction in having designed an application which can be implemented to include
various kinds of products by simple modifications.
BIBLIOGRAPHY
www.google.com
www.python.org.
www.geeksforgeeks.org
www.stackoveflow.com
Martin Brown and Martin C Brown, “Python: The Complete Reference”,Mc-Graw-
Hill,2001
