ACKNOWLEDGEMENT

I WOULD LIKE TO EXPRESS MY SPECIAL

THANKS
OF GRATITUDE TO MY TEACHER MS.POOJA
MA’AM WHO GAVE ME THE GOLDEN
OPPORTUNITY TO DO THIS WONDERFUL PROIECT
ON THE TOPIC "SALES MANAGEMENT SYSTEM''
WHICH ALSO HELPED ME IN DOING A LOT OF
RESEARCH AND I CAME TO KNOW ABOUT S O
MANY NEW THINGS WHICH WERE VERY
INTERESTING. I WOULD ALSO LIKE TO THANK
MY PARENTS WHO HELPED ME A LOT IN
FINALIZING THIS PROIECT WITHIN LIMITED TIME
FRAME.
 OVERVIEW
SALES MANAGEMENT SYSTEM
THE SALES MANAGEMENT SYSTEM (SMS) IS BASICALLY A
DATABASE BASED PROJECT DONE WITH HELP OF PYTHON LANGUAGE.
THIS PROJECT IS VERY USEFULL FOR THE SHOPKEEPERS TO KEEP A
COUNT ON WHAT PROJECT THEY HAVE AND HOW MUCH THEY SOLD.
THIS PROJECT IS MULTIFIELD PROJECT ,SO THAT IT CAN BE MODIFIED
FOR VARIOUS PURPOSES
OBJECTIVES OF THE PROJECT
THE PROJECT IS TO LET US SOLVE THE CHALLENGES OF
MAINTAINING THE RECORDS AND BETTER MANAGEMENT OF
SALES IN BUSINESSES NOWDAYS
TO HELP THEM TO COMPETE IN THIS FAST MOVING SOCIETY
MAKEING BILLING AND MANAGING OLD AND NEW PURCHASE
RECORDS EASIER.
MANAGE THE INVETORY MORE EFFICIENTLY.
GET MORE USERS TO EDUCATE THE BENIFITS OF USING AN POS
SYSTEM.
 NEED FOR
COMPUTARIZATION
THE NEED FOR SALES MANAGEMENT SYSTEM SOFTWARE IN
TODAY'S BUSINESS LANDSCAPE
IN TODAY'S FAST-PACED, COMPETITIVE BUSINESS ENVIRONMENT,
HAVING A ROBUST SALES MANAGEMENT SYSTEM (SMS) IS
ESSENTIAL FOR ACHIEVING SALES GOALS AND MAXIMIZING
EFFICIENCY.
ENHANCED CUSTOMER RELATIONSHIP MANAGEMENT (CRM):
CENTRALIZED CUSTOMER DATA: SMS SOFTWARE PROVIDES A
CENTRALIZED REPOSITORY FOR ALL CUSTOMER INFORMATION,
INCLUDING CONTACT DETAILS, PURCHASE HISTORY, AND
PREFERENCES.
STREAMLINED SALES PROCESSES:
SALES PIPELINE MANAGEMENT: VISUALIZE THE SALES FUNNEL
AND TRACK THE PROGRESS OF DEALS AT DIFFERENT STAGES.
TASK AUTOMATION: AUTOMATE REPETITIVE TASKS LIKE
SENDING FOLLOW-UP EMAILS OR SCHEDULING MEETINGS,
FREEING UP SALES REPS' TIME.
QUOTAS AND TARGETS: SET AND TRACK SALES QUOTAS FOR
INDIVIDUAL REPS AND TEAMS, ENSURING ACCOUNTABILITY
AND MOTIVATION.
 NEED FOR
COMPUTARIZATION
IMPROVED SALES ANALYTICS:
DATA-DRIVEN INSIGHTS: GAIN VALUABLE INSIGHTS INTO SALES
PERFORMANCE THROUGH DETAILED REPORTS AND ANALYTICS.
FORECASTING: ACCURATELY PREDICT FUTURE SALES TRENDS
AND ADJUST STRATEGIES ACCORDINGLY.
PERFORMANCE TRACKING: IDENTIFY TOP-PERFORMING SALES
REPS AND AREAS FOR IMPROVEMENT.
INCREASED EFFICIENCY AND PRODUCTIVITY
TIME MANAGEMENT: OPTIMIZE TIME SPENT ON
ADMINISTRATIVE TASKS, ALLOWING SALES REPS TO FOCUS
ON CLOSING DEALS.
COLLABORATION: FOSTER COLLABORATION AMONG SALES
TEAMS AND DEPARTMENTS THROUGH SHARED INFORMATION
AND TOOLS.
SCALABILITY AND ADAPTABILITY:
GROWTH: SMS SOFTWARE CAN SCALE WITH YOUR BUSINESS AS
IT GROWS, ACCOMMODATING INCREASING CUSTOMER BASES
AND SALES VOLUMES.
CUSTOMIZATION: MANY SMS SOLUTIONS OFFER CUSTOMIZATION
OPTIONS TO FIT SPECIFIC BUSINESS NEEDS AND WORKFLOWS.
 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 ABOVE
VI. CD/DVD R/W MULTI DRIVE COMBO: (IF BACK UP REQUIRED)
VII. FLOPPY DRIVE 1.44 MB : (IF BACKUP REQUIRED)
VIII. MONITOR 14.1 OR 15 -17 INCH
IX. KEY BOARD AND MOUSE
 aDVANTAGES aND
dISADVANTAGES
ADVANTAGES
CENTRALIZED DATA: PROVIDES A SINGLE PLATFORM TO STORE AND
MANAGE CUSTOMER INFORMATION, SALES DATA, AND INVENTORY.
IMPROVED SALES EFFICIENCY: STREAMLINES SALES PROCESSES,
AUTOMATES TASKS, AND PROVIDES INSIGHTS FOR BETTER DECISION-
MAKING.
ENHANCED CUSTOMER RELATIONSHIPS: ENABLES PERSONALIZED
INTERACTIONS AND BETTER CUSTOMER SERVICE.
SCALABILITY: CAN EASILY ADAPT TO BUSINESS GROWTH AND CHANGING
REQUIREMENTS.
REAL-TIME INVENTORY TRACKING: MONITORS STOCK LEVELS, PREVENTING
STOCKOUTS AND OVERSTOCKING.
DISADVANTAGES
COMPLEXITY: CAN BE COMPLEX TO IMPLEMENT AND LEARN,
ESPECIALLY FOR SMALLER BUSINESSES.
COST: CAN BE EXPENSIVE, ESPECIALLY FOR ADVANCED FEATURES AND
LARGE BUSINESSES.
DEPENDENCY: RELIANCE ON TECHNOLOGY CAN LEAD TO DISRUPTIONS IF
THE SYSTEM FAILS
MAINTENANCE COSTS: REQUIRES ONGOING MAINTENANCE AND
UPDATES TO ENSURE OPTIMAL PERFORMANCE.
TECHNICAL ISSUES: CAN EXPERIENCE TECHNICAL PROBLEMS, LEADING
TO DISRUPTIONS IN OPERATIONS.
 source code
file name:: main
import mysql.connector as sql

conn = sql.connect(host='localhost', user='root', password='GKBH_!@#$%', 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
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,stock 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])
print('stock available:', data1[2])
appr = input('do you want to buy it (Y/N) :')
if appr == 'y' or appr == 'Y':
# Check if enough stock is available
qty = int(input("Enter the quantity you want to purchase: "))
if data1[2] >= qty:
c1.execute("update stock set stock = stock - %s where product_no = %s" % (qty, b))
c1.execute("update stock set purchased = purchased + %s where product_no = %s" % (qty, b))
bill += int(data1[1]) * qty
it += qty
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':
# Payment method should be asked here
 just = input('MODE OF PAYMENT (Cash/Card):')
print(' BILL')
print(''' GAME POINT
NUMBER OF ITEMS PURCHASED:''', it)
print('''GRAND TOTAL AMOUNT:$''', bill)
print('''MODE OF PAYMENT:''', just)
print("PRODUCT NAME:", data1[0])
print('''*******THANK YOU*******
*******PLEASE VIST AGAIN*******''')
break
else:
print("Sorry, not enough stock available for this quantity.")
break
conn.commit()
elif loggin == 2:
print("1. veiw stock")
print("2. add stock")
print("3. Adding a new product")
print("4. Remove stock")
print("5. Remove product")
ch = int(input("Enter your choice :"))
if ch == 1:
for i in range(0, int(len(peee))):
print(peee[i])
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()
elif ch == 4: # Admin stock removal
prdno = input("Enter the product number to remove stock from: ")
quantity = int(input("Enter the quantity to remove: "))

c1.execute("UPDATE stock SET stock = stock - %s WHERE product_no = %s", (quantity, prdno))
conn.commit()
print("Stock removed successfully!")
elif ch == 5: # Remove product
prdno = input("Enter the product number to remove: ")
c1.execute("DELETE FROM stock WHERE product_no = %s", (prdno,))
conn.commit()
print("Product removed successfully!")
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='GKBH_!@#$%', 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. VIEW ALL USERS")
print("4. REMOVE USER") # Added option to remove user
print("5. EXIT")
choice = int(input('ENTER THE CHOICE:'))
print("============================================================================")

if choice == 1:
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 # Assuming 'main' contains your main program logic
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: # Remove user

username_to_remove = input("Enter the username to remove: ")
c1.execute("DELETE FROM user WHERE username = %s", (username_to_remove,))
conn.commit()
print("User removed successfully!")

elif choice == 5:
print(".......................LOGGING...........OUT................")
break

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

file name:: TAbels

import mysql.connector as sql
conn = sql.connect(host='localhost', user='root', password='GKBH_!@#$%', database='sms')
c1=conn.cursor()
c1.execute("create database sms")
c1.execute('use sms')
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()
OUTPUT
OUTPUT
OUTPUT
OUTPUT
 Bibliography

HTTPS://WWW.SALESFORCE.COM/SALES/SALES-
MANAGEMENT/

HTTPS://WWW.W3RESOURCE.COM/

HTTPS://WWW.EXPERTMARKET.COM/CA/POS/POS
-SYSTEM-ADVANTAGES-DISADVANTAGE

HTTPS://WWW.WIKIPEDIA.ORG/

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.