TABLE OF CONTENTS

SER DESCRIPTION PAGE NO

01 ACKNOWLEDGEMENT 02

02 INTRODUCTION 03

03 OBJECTIVES OF THE PROJECT 03

04 PROPOSED SYSTEM 06

05 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) 08

06 PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE 08

07 FLOW CHART 09

08 SOURCE CODE 10

09 OUTPUT 15

10 TESTING 19

11 HARDWARE AND SOFTWARE REQUIREMENTS 20

INSTALLATION PROCEDURE
12 20

13 BIBLIOGRAPHY 21

1|Page
 ACKNOWLEDGEMENT

Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my gratitude
to the people who have been instrumental in the successful completion of this project.

I express my heartfelt gratitude to my parents and teachers for constant

encouragement while carrying out this project.

I gratefully acknowledge the contribution of the individuals who contributed in

bringing this project up to this level, who continues to look after me despite my flaws

sales billing

2|Page
INTRODUCTION

The mobile sales billing is basically a database project done with help of python language.

this project is very useful for the retailers to keep a count on what types of mobiles they have

and how much they sold.

PROPOSED SYSTEM

The proposed system is computerized and has been developed using advance language
therefore it gives more facilities than present system. It provides quick access to any data. In
this system user have to enter the data only once and then it get linked with all files. This
reduces the workload of user and it is also a time saving process.The information about any
Subscriber can be easily retrieved. The system maintains all records easy.

OBJECTIVES AND SCOPE OF THE PROJECT

Billing System Project in Python is an easy python undertaking for novices from

which they can discover ways to develop python language project. This Mobile billing

system can be extremely useful for every one of those understudies,

programmer, software program engineers and python learner students to discover how

the code execute and work inside the program.

3|Page
Description of System

In Mobile Store Management System use to maintain their sales detail in files and folders.
They use to keep the record of product sold, Customers, Suppliers, etc in a register. A
daily register is maintained to keep track of complaints. Preparing report is very time
consuming and tedious task. For searching of single record, whole register is to be searched
which is very time-consuming task.

4|Page
FUNCTIONS AND MODULES USED IN PROJECT
import mysql.connecter:
By importing this package, we are able toestablish the connection between SQL and
Python.
import datetime:
This package provides basic functions for display date related values in the program.
import random:
This package has functionality to generate random numbers and select numbers
within a range.
Admin Functionalities:

o Login module
o Manage Category: Add, update or delete
o Manage Item: Add, update or delete

User Functionalities:

o Registration module
o Login module
o Place Order module
o Shopping Cart module
o Manage profile

Functions

5|Page
connect():
This function establishes connection between Python and MySQL.

cursor():
It is a special control structure that facilitates the row-by-row processing of records in
the result set

The syntax is:

<cursor object>=<connection object>.cursor()

execute():
This function is use to execute the sql query
and retrieve records using python.
The syntax is:
<cursor object>.execute(<sql query string>)

fetchall():
This function will return all the rows from the
result set in the form of a tuple containing the
records.

commit():
This function provides changes in the
database physically.

6|Page
What is sales management
When the goods purchased for selling purposes are sold to customers at a particular
price are termed as sales. In simple words goods sold are called sales.

Sales, in its simplest form, refers to the act of selling a product or service to a
customer. The transfer of ownership is usually completed in exchange for money
or an agreed-upon value.

Sales is not only a basic economic activity but also an integral part of business
operations. It encompasses all the processes involved in persuading and convincing
a potential customer to purchase a product or service.

The sphere of sales is complex and multifaceted, stretching far beyond the mere
exchange of goods and services for money.

It is a comprehensive process that starts from identifying the customer's needs,

presenting the appropriate solution, and culminates in the customer making the
decision to buy.

Wholesale sales involve selling goods in large quantities to retailers or industrial,

commercial, institutional, or professional business users.

The primary purpose of wholesale selling is to enable these entities to resell the
goods to end consumers.

This method is highly prevalent in various industries, ranging from fashion and
food to electronics and automobiles.

Wholesale sales can provide a consistent and substantial stream of revenue,

especially if businesses establish strong relationships with reliable retailers.

Moreover, the cost per unit is generally lower in wholesale sales due to the volume
of products sold, thereby allowing businesses to maximize their profitability.

7|Page
 SYSTEM DEVELOPMENT LIFE CYCLE

FLOW CHART

1.COMMANDED PROGRAM WILL BE EXECUTED IN PYTHON IDLE .

8|Page
 SOURCE CODE

FILE NAME : TABLES

import mysql.connector as sql

conn= sql.connect(host='localhost', user = 'root', password ='manager')
c1=conn.cursor()
c1.execute("create database "+name_of_database)
c1.execute('use {}'.format(puj))
c1.execute("create table stock (product_no int(10) primary
key,product_name varchar(30),cost_per_product int(10),stock
int(10),purchased int(10) );")
c1.execute("create table user(username varchar(255),passwd
varchar(255));")
conn.commit()

FILE NAME : MAIN.py

import mysql.connector as sql

conn= sql.connect(host='localhost', user = 'root', password
='manager',database ='sms')
c1=conn.cursor()
chpasswd='d'
print('''+--------------------------+
/////////////////////////
/////////////////////////
welcome to Game Point
////////////////////////
///////////////////////
+--------------------------+''')
c1.execute('select product_no,product_name from stock;')
peee=c1.fetchall()
peee1=list(peee)
print('''PRODUCT PRODUCT NAME
NO''')

for i in range(0,int(len(peee))):
print(peee[i] )
it=0

9|Page
bill=0
while 5>1:

print("===================================================
========================================")
print("1. CUSTOMER")
print("2. ADMIN")
print("3.EXIT")
loggin=int(input('enter the choice:'))
if loggin==1:
while 3>1:

print("===================================================
========================================")
b=input('product number: ')
c1.execute('select product_name,cost_per_product from stock where
product_no =' + b)
data= c1.fetchall()
data1=list(data[0])
print('product name :', data1[0])
print('cost of the product :', data1[1] )
appr= input('do you want to buy it (Y/N) :')
if appr == 'y' or appr =='Y' :
c1.execute("update stock set stock = stock-1 where product_no= " + b )
c1.execute("update stock set purchased = purchased+1 where
product_no=" + b )
bill+=int(data1[1])
it+=1
print("bought successfully!!!!")
opn = input(" Do you want buy any other thing (Y/N) : ")
if opn == 'y' or opn == 'Y':
continue
elif opn=='n' or opn=='N':
break
elif appr =='n' or appr =='N':
opn = input(" Do you want buy any other thing (Y/N) : ")
if opn == 'y' or opn == 'Y':
continue
elif opn == 'n' or opn =='N':
just=input('MODE OF PAYMENT (Cash/Card):'
print(' BILL')
print(''' GAME POINT
NUMBER OF ITEMS PURCHASED:''',it)

10 | P a g e
 print('''GRAND TOTAL
AMOUNT:''',bill)
print('''MODE OF
PAYMENT:''',just)
print('''*******THANK
YOU*******
*******PLEASE VIST AGAIN*******''')
break
else:
print('####invalid command####')
break
conn.commit()
elif loggin==2:
print("1. veiw stock")
print("2. add stock")
print("3. Adding a new product")
ch=int(input("Enter your choice :"))
if ch==1:
a=input('Enter the product number :')
c1.execute("select * from stock where product_no="+a)
dt=c1.fetchall()
dt1=list(dt[0])
print("product name :",dt1[1])
print("cost per product:",dt1[2])
print("stock available:",dt1[3])
print(" Number items purchased :",dt1[4])
elif ch==2:
prdno=input("Enter the product number of the product for which
the stock is going to be updated:")
upd_value=int(input("enter the number of new stocks came:"))
c1.execute("update stock set stock=stock+" + str(upd_value) + " where
product_no="+prdno)
conn.commit()
elif ch==3:
pno1=input('Enter the product number of new product:')
pna=input('Enter the product name of the new product:')
cst=input('Enter the cost of the product:')
stock12=input('Enter the number of stocks of the new product arrived:')
pch='0'
c1.execute("insert into stock values("
+ pno1 +','+'"'+pna+'"'+','+cst+','+stock12+','+pch+')')
print("Added sucessfully!!!!!!!")
conn.commit()

11 | P a g e
 else:
print('####INVALID OPTION ####')

elif loggin== 3:
print("...QUITING... ")
break

else:
print("###INVALID OPTION####")

FILE NAME: SALES MANAGEMENT SYSTEM

import mysql.connector as sql

import datetime
d_day=datetime.date.today()
d_time=datetime.datetime.now()
conn= sql.connect(host='localhost', user = 'root', password
='manager',database ='sms')
c1=conn.cursor()
print("SALES MANAGEMENT SYSTEM")
print(d_day.day,"/",d_day.month,"/",d_day.year,"
",d_time.hour,":",d_time.minute,)
chpasswd='d'
while 5>1:
print("1.LOGIN")
print("2.REGISTER")
print("3.VEIW ALL USERS")
print("4.EXIT")
choice=int(input('ENTER THE CHOICE:'))

print("===================================================
=========================")
if choice == 1:s

12 | P a g e
 us=input('USERNAME:')
ps=input('PASSWORD:')
c1.execute("select * from user where username = '{}'
and passwd = '{}'".format(us , ps))

data = c1.fetchall()

if any(data) :
import main

else:
print('''..SORRY..
WRONG.......USERNAME OR PASSWORD''')

elif choice == 2:

print("===================================================
========================================")
li=input('ENTER THE NEW USER ID:')
while 8>1:
li2=input('ENTER YOUR PASSWORD:')
li3=input('ENTER YOUR PASSWORD
AGAIN(to confirm):')
if li2== li3:
c1.execute("insert into user
values("+'"'+li+'",'+'"'+li3+'")')
print("ID has been successfully
created:")
conn.commit()
break
elif choice ==3:
c1.execute("select username from user")
data = c1.fetchall()
for row in data : print(row)
elif choice == 4:
print(".......................LOGGING...........OUT................")
break

else:
print('please enter the right option')

13 | P a g e
 OUTPUT

MAIN WINDOW

14 | P a g e
 LOGIN WINDOW

CUSTOMER WINDOW

ADMIN WINDOW

15 | P a g e
 REGISTER WINDOW

16 | P a g e
 VEIW THE USERS WINDOW

EXIITING WINDOW

17 | P a g e
 TESTING
Testing is vital to the success of any system. Testing is done at different stages
within the phase. System testing makes a logical assumption that if all phases of
the system are correct, the goals will be achieved successfully. Inadequate
testing at all leads to errors that may come up after a long time when correction
would be extremely difficult. Another objective of testing is its utility as a user-
oriented vehicle before implementation. The testing of the system was done on
both artificial and live data.

18 | P a g e
 HARDWARE AND SOFTWARE REQUIREMENTS

I.OPERATING SYSTEM : WINDOWS 7 AND ABOVE

II. PROCESSOR : PENTIUM(ANY) OR AMD

ATHALON(3800+- 4200+ DUAL CORE)

III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI

K9MM-V VIA K8M800+8237R PLUS

CHIPSET FOR AMD ATHALON

IV. RAM : 512MB+

V. Hard disk : SATA 40 GB OR ABOV

19 | P a g e
SOFTWARE REQUIREMENTS:

• Windows 7 or above
• Python 3.7 or above
• My sql connector module

INSTALLATION PROCEDURE

STEPS TO INSTALL SALES MANAGEMENT SOFTWARE:

1.FIRST OPEN THE FILE NAMED TABLE AND RUN IT.
2.SECOND OPEN THE SALES MANAGEMENT SYSTEM FILE AND USE IT.

IMPORTANT THINGS TO BE NOTED:

1. THE SALES MANAGEMENT SYSTEM FILE SHOULD BE PLACED AT THE MAIN
PYTHON FILE.
2. FIRST, REGISTER YOUR ACCOUNT.
3.THEN ENTER YOUR PRODUCT DETAILS.

BIBLIOGRAPHY

• Computer science With Python - Class XII By : Sumita Arora

• A Project Report On SALES MANAGEMENT SYSTEM.
By : KISHORE RAJ S
***

20 | P a g e