Introduction

We all go shopping to buy products of our requirement. We all would have observed
that the shops are moving towards digital systems for bill computation. Shop
management is an application that helps in managing the products and keeping its
count in inventory, maintain shop customer details, worker details, tracking the sales
in the shop.

Objective of the project

To produce a working software which can manage and run the activities done in a
grocery store.

To keep a count of products sold and count of products kept in inventory to restock
them.

To reduce labor and time.

To reduce calculation time on sales report and extensive paperwork so that

administrators can spend their time on monitoring the store and keeping up with
the customer demands.
Proposed system

To keep up with the pace of digitalization and bring about the best results with minimal
mistakes and greater efficiency, one has to upgrade to using data management system for
running one’s grocery store.
Many companies that have created the software have implemented them in the markets
which have received positive feedback and helped in improving the product further.
These have also benefited the organizations and shop owners who use them, making
their work easier and efficient. The software needs to be easy to operate and accessible
through just loading the program in their existing computers.
This lets the owner as well as the country take a step in the modern era of
digitalization and automation, making work fully automated and accessible by the
click of a button.

Problems with existing system

Requires a lot of manpower, even then less efficient.

Consumes a lot of time and renders the processing slow.

Occupies a place to store paperwork and records.

Manual calculations may lead to human error and result into loss.
System development work flow

The products that arrive at the store needs to be loaded into the system’s database.
The products will be entered after accounting for the taxes
applied on each, commission, shelf life and quantity.

After the data has been loaded into the database by the data entry operator, the
products will be stocked on shelf for the customers.

The system is able to enter and display one or all workers details, such as his
name, work, age, contact information. This makes it easy to access their details
and store the same.

The system keeps a track about the customer details about his name, purchase and
contact information.

After a customer has made a purchase, the system can take the input of their final
cost and store them.

It also displays the stock available in a pie chart format for easy analysis.

The manager can have quick access to all his worker, customer, product details…
in a click.
 SOURCE CODE

import mysql.connector as sql

conn=sql.connect(host="localhost", user="root", password="narender1",
database="Grocery_shop")
if conn.is_connected():
print("Connected...")
c=conn.cursor()
def main():
print("Welcome Aryan")
an='y'
while an=='y' or an=='Y':
print('Grocery Shop')
print('1.customer details')
print('2.product details')
print('3.worker details')
print('4.see all customer details')
print('5.see all product details')
print('6.see all worker details')
print('7.see one customer details')
print('8.see one product details')
print('9.see one worker details')
print('10.pie chart for avalibility of stock')
choice=int(input('enter the choice: '))
if choice==1:
cust_namea=input('enter your name: ')
phone_noa=int(input('enter your phone number: '))
sql_insert="insert into customer_details values("+str(phone_noa)+",'"+
(cust_namea)+"'"+")"
c.execute(sql_insert)
conn.commit()
print('data is updated')
an=input("Do you want to make another choice(y/n): ")
elif choice==2:
product_name=input('enter product name: ')
product_cost=float(input('enter the cost: '))
sql_insert="insert into product_details values("+"'"+(product_name)
+"',"+str(product_cost)+")"
c.execute(sql_insert)
conn.commit()
print('data is updated')
an=input("Do you want to make another choice(y/n): ")
elif choice==3:
worker_name=input('enter worker name: ')
worker_work=input('enter worker work: ')
worker_age=int(input('enter worker age: '))
worker_salary=float(input('enter worker salary: '))
 phone_no =int(input('enter worker phone number: '))
sql_insert="insert into worker details values("+"'"+(worker_name)+"',""'"+
(worker_work)+"’, "+str(worker_age)+", "+str(worker_salary) +","+str(phone_no)+")"
c.execute(sql_insert)
conn.commit()
an=input("Do you want to make another choice(y/n): ")

elif choice==4:
t=conn.cursor()
t.execute('select*from customer_details')
record=t.fetchall()
for i in record:
print(i)
an=input("Do you want to make another choice(y/n): ")

elif choice==5:
t=conn.cursor()
t.execute('select*from product_details')
record=t.fetchall ()
for i in record:
print(i)
an=input("Do you want to make another choice(y/n): ")

elif choice==6:
t=conn.cursor()
t.execute('select*from worker_details')
record=t.fetchall()
for i in record:
print(i)
an=input("Do you want to make another choice(y/n): ")

elif choice==7:
a=input('enter customer name: ')
t='select*from customer_details where cust_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print(v)
an=input("Do you want to make another choice(y/n): ")

elif choice == 8:
a = input('enter your product_name: ')
t='select*from product_details where product_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print (v)
 an=input("Do you want to make another choice(y/n): ")

elif choice==9:
a=input('enter worker name: ')
t='select*from worker_details where worker_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print (v)
an=input("Do you want to make another choice(y/n): ")

elif choice==10:
import matplotlib.pyplot as plt
items=('shoes', 'stationary', 'watch', 'house_use' , 'food items')
availability=[156,200,103,206,196]
colors=['red', 'yellow_green', 'blue', 'gold', 'light_coral']
plt.pie(availability, labels=items, colors=colors)
plt.title('availability of items in shop')
plt.show()
an=input("Do you want to make another choice(y/n): ")

else:
exit()

def login(): u_n=input("Enter your Username: ")

pwd=input("Enter your password: ")
while u_n=="Aryan" and pwd=="aryansagar":

main()
else:
ans=input('wrong password, do you want to try again(y/n): ')
if ans=='y' or ans=="Y":
login()

print("Grocery Shop Management System")

print("1. Login\n2. Exit")
ans=int(input("Enter your choice(1/2): "))

if ans==1:
login()
elif ans==2:
exit()
OUTPUT
 HARDWARE AND SOFTWARE REQUIREMENTS
WINDOWS 10 OR ABOVE
PENTIUM
1.OPERATING OR AMD ATHALON
SYSTEM :
1.845 PENTIUM OR 915995 MSI
2. PROCESSOR :
512MB+
3.MOTHERBOARD :
4.RAM SATA 40GB OR ABOVE :
5.HARDIFDISK
REQUIRED :
IF REQUIRED
6.CD/DVD :
7.FLOPPY DRIVE 1.44MB :
8. MONITOR
9.KEYBOARD AND MOUSE
10.PRINTER : IF REQUIRED

SOFTWARE REQUIREMENTS

1.WINDOWS OS
2. PYTHON
3. MYSQL
4.MYSQL PYTHON CONNECTOR
 BIBLIOGRAPHY

 Computer science textbook for class 12th by NCERT

 Computer science with python for class 12thby Preeti Arora