Shop Management System in Python

Shop Management System is a desktop application that keeps track of all the transactions and generates a bill for all the purchased goods.

Shop management or Store management system is an interesting python project for beginners, where we need to track the inventories, products, sales, etc.

We will use python to develop this interesting project (using tkinter for GUI).

Project Prerequisites

The prerequisites are as follows:
1. Basic concepts of Python
2. Tkinter

Download Code of Shop Management System Python Project

Please download the source code of shop management system: Shop Management System Code

Let’s understand the source code of store management or shop management project:

from tkinter import *
from tkinter import ttk
from tkcalendar import DateEntry
from tkinter import messagebox
import sqlite3  as db

def connection():
    connectObj = db.connect("shopManagement.db")
    cur = connectObj.cursor()
    sql = '''
    create table if not exists sellings (
        date string,
        product string,
        price number,
        quantity number,
        total number
        )
    '''
    cur.execute(sql)
    connectObj.commit()   

connection()     
window=Tk()
window.title("TechVidvan Shop Management Project")
tabs = ttk.Notebook(window) 
root= ttk.Frame(tabs)
root2=ttk.Frame(tabs)

tabs.add(root, text ='Sell') 
tabs.add(root2, text ='Stock') 
tabs.pack(expand = 1, fill ="both") 
  

#----------------------------------------------tab1 ----------------------------------

def GenerateBill():
    connectObj = db.connect("shopManagement.db")
    cur = connectObj.cursor()  

    global billarea
    if p1quantity.get()==0 and p2quantity.get()==0 and p3quantity.get()==0 and p4quantity.get()==0:
        messagebox.showerror("Error","No product purchased")
    else:
        billarea.delete('1.0',END)
        billarea.insert(END,"\t|| TechVidvan Shop Management Project ||")
        billarea.insert(END,"\n_________________________________________\n")
        billarea.insert(END,"\nDate\t Products\tPrice\t   QTY\t Total")
        billarea.insert(END,"\n==========================================")

        price= IntVar()
        price2=IntVar()
        price3=IntVar()
        price4=IntVar()

        print(dateE.get())
        price=price2=price3=price4=0

        if p1quantity.get()!=0:
            price=p1quantity.get()*p1price.get()
            print(price)
            billarea.insert(END,f"\n{dateE.get()}\t Product-1 \t{p1price.get()}\t {p1quantity.get()}\t {price}")

            sql = '''
            INSERT INTO Sellings VALUES 
            (?, ?, ?, ?,?)
            '''
            cur.execute(sql,(dateE.get(),'Product-1',p1price.get(),p1quantity.get(),price))
            connectObj.commit() 

        if p2quantity.get()!=0:
            price2=(p2quantity.get()*p2price.get())
            print(price2)
            billarea.insert(END,f"\n{dateE.get()}\t Product-2 \t{p2price.get()}\t {p2quantity.get()}\t {price2}")

            sql = '''
            INSERT INTO Sellings VALUES 
            (?, ?, ?, ?,?)
            '''
            print(dateE.get(),'Product-2',p2price.get(),p2quantity.get(),price2)
            cur.execute(sql,(dateE.get(),'Product-2',p2price.get(),p2quantity.get(),price2))
            connectObj.commit() 

        if p3quantity.get()!=0:
            price3=p3quantity.get()*p1price.get()
            print(price3)
            billarea.insert(END,f"\n{dateE.get()}\tProduct-3 \t{p3price.get()}\t {p3quantity.get()}\t {price3}")

            sql = '''
            INSERT INTO Sellings VALUES 
            (?, ?, ?, ?,?)
            '''
            cur.execute(sql,(dateE.get(),'Product-3',p3price.get(),p3quantity.get(),price3))
            connectObj.commit() 

        if p4quantity.get()!=0:
            price4=p4quantity.get()*p1price.get()
            billarea.insert(END,f"\n{dateE.get()}\tProduct-4 \t{p4price.get()}\t {p4quantity.get()}\t {price4}")

            sql = '''
            INSERT INTO Sellings VALUES 
            (?, ?, ?, ?,?)
            '''
            cur.execute(sql,(dateE.get(),'Product-4',p4price.get(),p4quantity.get(),price4))
            connectObj.commit() 

        Totalprice=IntVar()
        Totalprice=price+price2+price3+price4

        Totalquantity=IntVar()
        Totalquantity=p1quantity.get()+p2quantity.get()+p3quantity.get()+p4quantity.get()
        billarea.insert(END,f"\nTotal \t \t  \t{Totalquantity}\t {Totalprice}")


def view():
    connectObj = db.connect("shopManagement.db")
    cur = connectObj.cursor()  

    sql = 'Select * from Sellings'
    cur.execute(sql)

    rows=cur.fetchall()
    viewarea.insert(END,f"Date\t Product\t  Price of 1\t  Quantity\t  Price\n")
    
    
    for i in rows:
        allrows=""
        for j in i:
            allrows+=str(j)+'\t'
        allrows+='\n'
        viewarea.insert(END,allrows)

dateL=Label(root,text="Date",bg="DodgerBlue2",width=12,font=('arial',15,'bold'))
dateL.grid(row=0,column=0,padx=7,pady=7)

dateE=DateEntry(root,width=12,font=('arial',15,'bold'))
dateE.grid(row=0,column=1,padx=7,pady=7)

l=Label(root, text="Product",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=1,column=0,padx=7,pady=7)

l=Label(root, text="Price",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=1,column=1,padx=7,pady=7)

l=Label(root, text="Quantity",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=1,column=2,padx=7,pady=7)

#----product 1----------------------------------------------------
p1name=StringVar()
p1name.set('Product1')

p1price=IntVar()
p1price.set(100)

p1quantity=IntVar()
p1quantity.set(0)

l=Label(root, text=p1name.get(),font=('arial',15,'bold'),width=12)
l.grid(row=2,column=0,padx=7,pady=7)

l=Label(root, text=p1price.get(),font=('arial',15,'bold'),width=12)
l.grid(row=2,column=1,padx=7,pady=7)

t=Entry(root,textvariable=p1quantity,font=('arial',15,'bold'),width=12)
t.grid(row=2,column=2,padx=7,pady=7)

#----product 2-------------------------------------------------------------
p2name=StringVar()
p2name.set('Product2')

p2price=IntVar()
p2price.set(200)

p2quantity=IntVar()
p2quantity.set(0)

l=Label(root, text=p2name.get(),font=('arial',15,'bold'),width=12)
l.grid(row=3,column=0,padx=7,pady=7)

l=Label(root, text=p2price.get(),font=('arial',15,'bold'),width=12)
l.grid(row=3,column=1,padx=7,pady=7)

t=Entry(root,textvariable=p2quantity,font=('arial',15,'bold'),width=12)
t.grid(row=3,column=2,padx=7,pady=7)

#----product 3----
p3name=StringVar()
p3name.set('Product3')

p3price=IntVar()
p3price.set(300)

p3quantity=IntVar()
p3quantity.set(0)

l=Label(root, text=p3name.get(),font=('arial',15,'bold'),width=12)
l.grid(row=4,column=0,padx=7,pady=7)

l=Label(root, text=p3price.get(),font=('arial',15,'bold'),width=12)
l.grid(row=4,column=1,padx=7,pady=7)

t=Entry(root,textvariable=p3quantity,font=('arial',15,'bold'),width=12)
t.grid(row=4,column=2,padx=7,pady=7)

#----product 4----
p4name=StringVar()
p4name.set('Product4')

p4price=IntVar()
p4price.set(400)

p4quantity=IntVar()
p4quantity.set(0)

l=Label(root, text=p4name.get(),font=('arial',15,'bold'),width=12)
l.grid(row=5,column=0,padx=7,pady=7)

l=Label(root, text=p4price.get(),font=('arial',15,'bold'),width=12)
l.grid(row=5,column=1,padx=7,pady=7)

t=Entry(root,textvariable=p4quantity,font=('arial',15,'bold'),width=12)
t.grid(row=5,column=2,padx=7,pady=7)

#------------------------bill-------------------------
billarea=Text(root)

submitbtn=Button(root,command=GenerateBill,text="Bill",
font=('arial',15,'bold'),bg="DodgerBlue2",width=20 )

submitbtn.grid(row=6,column=0,padx=7,pady=7)

viewbtn=Button(root,command=view,text="View All Sellings",
font=('arial',15,'bold'),bg="DodgerBlue2",width=20 )

viewbtn.grid(row=6,column=2,padx=7,pady=7)

billarea.grid(row=9,column=0)
viewarea=Text(root)
viewarea.grid(row=9,column=2)
#----------------------------------------------tab2 ----------------------------------
def connection2():
    connectObj2 = db.connect("shopManagement.db")
    cur = connectObj2.cursor()
    sql = '''
    create table if not exists stocks (
        date string,
        product string,
        price number,
        quantity number
        )
    '''
    cur.execute(sql)
    connectObj2.commit()   

connection2() 

def addStock():
    global dateE2,qty,name,price

    connectObj = db.connect("shopManagement.db")
    cur = connectObj.cursor()  
    sql = '''
            INSERT INTO stocks VALUES 
            (?, ?, ?, ?)
            '''
    cur.execute(sql,(dateE2.get(),name.get(),price.get(),qty.get()))
    connectObj.commit() 

def viewStock():
    connectObj = db.connect("shopManagement.db")
    cur = connectObj.cursor()  

    sql = 'Select * from stocks'
    cur.execute(sql)

    rows=cur.fetchall()
    viewarea2.insert(END,f"Date \tProduct\t  Price\t  Quantity\t \n")
    
    for i in rows:
        allrows=""
        for j in i:
            allrows+=str(j)+'\t'
        allrows+='\n'
        viewarea2.insert(END,allrows)

dateL=Label(root2,text="Date",bg="DodgerBlue2",width=12,font=('arial',15,'bold'))
dateL.grid(row=0,column=0,padx=7,pady=7)

dateE2=DateEntry(root2,width=12,font=('arial',15,'bold'))
dateE2.grid(row=0,column=1,padx=7,pady=7)

l=Label(root2, text="Product",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=1,column=0,padx=7,pady=7)

l=Label(root2, text="Price",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=2,column=0,padx=7,pady=7)

l=Label(root2, text="Quantity",font=('arial',15,'bold'),bg="DodgerBlue2",width=12)
l.grid(row=3,column=0,padx=7,pady=7)

name=StringVar()
price=IntVar()
qty=IntVar()

Name=Entry(root2,textvariable=name,font=('arial',15,'bold'),width=12)
Name.grid(row=1,column=1,padx=7,pady=7)

Price=Entry(root2,textvariable=price,font=('arial',15,'bold'),width=12)
Price.grid(row=2,column=1,padx=7,pady=7)

Qty=Entry(root2,textvariable=qty,font=('arial',15,'bold'),width=12)
Qty.grid(row=3,column=1,padx=7,pady=7)

addbtn=Button(root2,command=addStock,text="Add",
font=('arial',15,'bold'),bg="DodgerBlue2",width=20)

addbtn.grid(row=4,column=1,padx=7,pady=7)

viewarea2=Text(root2)
viewarea2.grid(row=5,column=0,columnspan=2)

viewbtn2=Button(root2,command=viewStock,text="View Stock",
font=('arial',15,'bold'),bg="DodgerBlue2",width=20 )

viewbtn2.grid(row=4,column=0,padx=7,pady=7)

mainloop()

Explanation:

Follow TechVidvan on Google & Stay updated with latest technology trends

Tab-1:

Connection: It connects the python program to a database and creates a sellings table with five attributes. Steps for database connectivity:

1. Import sqlite3
import sqlite3  as db

2. Create connection object.
connectObj = db.connect(“shopManagement.db”)

3. Create cursor object
cur = connectObj.cursor()

4. Execute the required query.
cur.execute(sql)

GenerateBill: It is responsible for the following:

When no product is purchased and the software is asked to generate the bill, It displays “Error”, “No product purchased” in a message box.

After checking this condition, it clears the bill area so as to remove any previous bills (if any), and then it adds Shop name and some more headings mentioned in the code itself.

And finally, it adds product name, price per piece, quantity, and total price (price per piece * quantity) if the quantity is greater than zero. Also, this function stores all the valid rows in our database by following the above-mentioned steps.

After all the products it calculates the total amount to be paid and displays it in a separate row.

View: This function reads every row of sellings table and displays all of them on the tkinter window.

After this function, we have created a menu that contains the product name and its price per piece and an entry widget for the user to enter the quantity purchased. Then, we have created a submit button to call GenerateBill function and a view button to call the view function.

Tab-2:

Connection2: It connects our python program to a database and creates a stocks table with four attributes- date, product name, price, and quantity.

Addstock: It stores the data entered by the user in the stocks table by using above discussed database connectivity steps.

viewstock: It simply reads all the rows of stocks table and displays them on the tkinter window.

After this function, we have created some entry widgets for the user to enter the product name, price, and quantity. Then, we have created an add button to call addstock function and a view button to call viewstock function

Shop Management System Project Output

Tab-1:

shop management view bill

Tab-2:

stocks inventory

Summary

We have successfully developed shop management or store management system, where we can track the inventories, products, sales, etc. Based on the requirements you can add more features in this project.

We work very hard to provide you quality material
Could you take 15 seconds and share your happy experience on Google | Facebook


6 Responses

  1. Ankur says:

    I am not much aware about Tkinter. But overall the project looks nice. Good work.

  2. mohnish says:

    yeah same…even i dont know the function of Tkinter. Can u pls elaborate abt it?

  3. ronix bhaskar says:

    how do i connect import sqlite3 as db in pycharm

  4. Rai says:

    Please make on sports shop management

  5. Basavaraj says:

    can explain in details for connecting ms access database and oracle sql

Leave a Reply

Your email address will not be published. Required fields are marked *