project –fashion store
BY-Nishiket yadav
CERTIFICATE
CLASS: XII YEAR:2021-22
This is to certify that Fashion Store Project is successfully
completed by Nishiket Yadav of Class: XII, from2021-22 batch
This project was solely completed and code by Nishiket Yadav
Head Teacher External Internal Examiner
Signature: Examiner (Subject Teacher)
Date: / / 21 Department of: COMPUTER SCI.
Principal
Acknowledgement
I, Nishiket Yadav of class XIIth would like to express my
sincere gratitude to my computer science teacher [Link],
PGT COMPUTER SCIENCE, for her vital support, guidance and
encouragement – without which this project would not have
come forth.
We would also like to express my gratitude to my
school Poddar Brio International for letting me use the school
laboratory
INDEX
[Link] Content [Link]
1 Brief 1
overview of
project
2 Input data 2
3 Software 3
and
hardware
requirement
4 Need for 4
computerati
on
5 Advantage 6
of project
6 Limits of 7
project
7 Source code 7
of project
8 Output 23
screen
9 Future 27
enhancemen
t of project
10 Bibliography 29
BRIEF OVERVIEW OF
PROJECT
The main objective of the python project on
fashion store management is to manage the
details of sales, discounts, payments,
products, and inventory digitally. The project
is totally built at administrative end and only
administrator is guaranteed the access. The
purpose of the project is to build an
application program to reduce the manual
work for managing the sales, discounts, stock,
and payments. It tracks all the details about
stocks, products, and inventory; it also prints
various reports as per input given by the user.
INPUT DATA AND
VALIDATION OF PROJECT
1. All the fields such as sales payments
discounts are validatedanddoesnot take
invalid values.
2. Each form of sales, discounts, stock
cannot accept the blankvalues.
3. Avoiding errors in data.
4. Controlling amount of input.
SOFTWARE AND
HARDWARE
REQUIREMENTS:
Data file handling has been effectively used in the
program. The data baseis a collection of interrelated
data to serve multiple applications. That is database
programs create files of information. So we see that
filesareworked with most, inside the program.
DBMS: The software required for the management
of data is called as DBMS. It has 3 models:
Relation model
Hierarchical model
Network model
RELATIONAL MODEL: It’s based on the concept
on relation. Relation is the table that consists of rows
and columns. The rows of the table are called tuple
and the columns of the table are called attribute.
Numbers of rows in the table is called as cardinality.
Number of columns in the table is called as degree.
HIERARCHICAL MODEL: : In this type of model,
we have multiple records for each record. A particular
record has one parent record. No chide record can
exist without parent record. In this, the records are
organized in tree
NETWORK MODEL: In this, the data is
represented by collection of record sand relationship is
represented by ink or association.
CHARACTERISTICS OF DBMS:
• It reduces the redundancy
• Reduction of data in inconsistency
• Data sharing
• Data standardization
DIFFERENT TYPES OF FILES: -BASED
ON ACCESS:
• Sequential file
• Serial file
• Random (direct access) file BASED ON STORAGE:-
• Text file
• Binary File
NEED OF
COMPUTERISATION
Over the decades computers and fashion have developed
gradually, changed with time, taste and trend. But nobody
knew that a time will come when both these fields will
complement each other so well. Today fashion design has
reached new heights by computer aided methods of design.
As a result of which, computer industry has got its new
customer. Computer technology is making waves in the
fashion design zone. From determining textile weaves to
sizing designs; computers are a vital component of the
fashion industry. Computer aided design (CAD) programs
reduce the demand for manual sketches. New software
programs continue to replace old manual skills. Going by the
wayside are "old fashioned" flat pattern construction, pencil
sketching and traditional math-based pattern sizing. Those
who lag in math and falter at sketching can now breathe a
little easier. Manually figuring size adjustments and cutting
pattern piece sins tils that knowledge. Software programs
constantly evolve. A program used today may be obsolete
within several years. Being trained on today's software does
not guarantee it will be used when you are ready to go out
into the field. Understanding calculations is timeless, as is
computer competency. Software, however, shifts rapidly
1. It generates the report on sales, discounts and
stocks.
2. Provides filter report on payments, inventory and
products.
3. We can easily export PDF on sales, products and
stocks.
4. Applications can also provide excel export for sales
and discounts.
5. It deals with monitoring the information and
transactionof products.
6. It increases the efficiency of managing sales and
discount.
7. It has higher efficiency of editing, adding and
updating of records.
8. Provides the searching facilities on various factors.
1. Excel export has not been developed for stocks and
products.
2. The transactions are executed in offline mode only.
3. Online transactions for sales, discounts, or other
data modificationsare not possible.
4. Offline reports of sales, products, discounts and
stocks cannot begenerated due to batch mode
execution.
Source code screening…
DBMS: MySQL
Host: local host
User: root Pass:
root Database:
fashion Table Structure: (Images Bellow)
1. Product table
2. Purchase table
Note: In Purchase table take the purchase ID as varchar (16)
3. Stock table
4. Purchase table
Note: In Purchase table take the sale_id as varchar (16)
Python code:
import os
import platform
import [Link]
import pandas as pd
import datetime
mydb=[Link](host="localhost",\
user="root",\
passwd="root",\
database="fashion")
mycursor=[Link]()
def AddProduct():
L=[]
stk=[]
pid=input("Enter the Product ID : ")
[Link](pid)
IName=input("Enter the Product Name : ")
[Link](IName)
brnd=input("Enter the Product Brand Name : ")
[Link](brnd) fr=input("Enter Male/Female/Kids :
")
[Link](fr)
sn=input("Enter Winter/Summer : ")
[Link](sn)
rate=int(input("Enter the Rates for Product :"))
[Link](rate)
product=(L)
sql="Insert into product
(product_id,PName,brand,Product_for,Season,rate)valu
es(%s,%s,%s,%s,%s,%s)"
[Link](sql,product)
[Link]()
[Link](pid)
[Link](0)
[Link]("No")
st=(stk) sql="insert into stock(item_id, Instock, status)
values(%s,%s,%s)"
[Link](sql,st)
[Link]()
print("One Product inserted ")
def EditProduct():
pid=input("Enter product ID to be edited : ")
sql="select * from product where product_id=%s"
ed=(pid,)
[Link](sql,ed)
res=[Link]()
for x in res:
print(x)
print("")
fld=input("Enter the field which you want to edit :
")
val=input("Enter the value you want to set : ")
sql="Update product set " + fld +"='" + val + "'
where product_id='" + pid + "'"
sq=sql
[Link](sql)
print("Editing Don : ")
print("After correction the record is : ")
sql="select * from product where product_id=%s"
ed=(pid,)
[Link](sql,ed)
res=[Link]()
for x in res:
print(x)
[Link]()
def DelProduct():
pid=input("Enter the Product)id to be deleted : ")
sql="delete from sales where item_id=%s"
id=(pid,)
[Link](sql,id)
[Link]()
sql="delete from purchase where item_id=%s"
[Link](sql,id) [Link]()
sql="delete from stock where item_id=%s"
[Link](sql,id) [Link]()
sql="delete from product where product_id=%s"
[Link](sql,id)
[Link]()
print("One Item Deleted")
def ViewProduct():
print("Display Menu: Select the category to display
the data")
print("1. All Details")
print("2. Product Name:")
print("3. Product Brand:")
print("4. Product For:")
print("5. Product Season:")
print("6. Product ID:")
x=0
ch=int(input("Enter your choice to display : "))
if ch==1:
sql="select * from product"
[Link](sql)
res=[Link]()
for x in res:
print(x) x=1
elif ch==2:
var='PName'
val=input("Enter the name of Product : ")
elif ch==3:
var='brand'
val=input("Enter the name of Brand : ")
elif ch==4:
var='Product_for'
val=input("Enter Male/Femal/Kids : ")
elif ch==5:
var='season'
val=input("Enter the Season : ")
elif ch==6:
var='product_id'
val=input("Enter the Product_id : ")
if x==0:
sql="select * from product where " + var + " = %s"
sq=sql
tp=(val,)
[Link](sq,tp)
res=[Link]()
for x in res:
print(x)
def PurchaseProduct():
mn="" dy=""
now=[Link]()
purchaseID="P"+str([Link])+str([Link])
+str([Link])+str([Link])+str([Link] e)
+str([Link])
L=[]
Lst=[]
[Link](purchaseID)
itemId=input("Enter Product ID : ")
[Link](itemId)
itemNo=int(input("Enter the number of Items : "))
[Link](itemNo)
sql="select rate from product where product_id=%s"
pid=(itemId,)
[Link](sql,pid)
res=[Link]()
for x in res:
print("rate is : ", x)
amount=x*itemNo
print("Amount is :", amount)
[Link](amount)
mnth=[Link]
if mnth<=9:
mn="0"+str(mnth)
else:
mn=str(mnth)
day=[Link]
if day<=9:
dy="0"+str(day)
else:
dy=str(day)
dt=str([Link])+"-"+mn+"-"+dy
[Link](dt)
tp=(L)
sql="insert into
purchase(purchase_id,item_id,no_of_items,amount,Purchas
e_date)values(%s,%s,%s,%s, %s)"
[Link](sql,tp)
[Link]()
sql="Select Instock from stock where item_id=%s"
[Link](sql,pid)
res=[Link]()
status="No"
for x in res:
print(x)
instock=x[0]+itemNo
if instock>0:
status="Yes"
[Link](instock)
[Link](status)
[Link](itemId)
tp=(Lst)
sql="update stock set instock=%s,status=%s where
item_id=%s"
[Link](sql,tp)
[Link]()
print("1 Item purchased and saved in Database")
def ViewPurchase():
item=input("Enter Product Name : ")
sql="select product.product_id,
[Link],[Link],purchase.no_of_items,purcha
se.purchase_date,[Link] from product INNER
JOIN purchase ON product.product_id=purchase.item_id
[Link]=%s"
itm=(item,)
[Link](sql,itm)
res=[Link]()
for x in res:
print(x)
def ViewStock():
item=input("Enter Product Name : ")
sql="select
product.product_id,[Link],[Link],\
[Link] from stock, product where \
product.product_id=stock.item_id and [Link]=%s"
itm=(item,)
[Link](sql,itm)
res=[Link]()
for x in res:
print(x)
def SaleProduct():
now=[Link]()
saleID="S"+str([Link])+str([Link])+str([Link])
+str([Link])+str([Link])+str ([Link])
L=[] [Link](saleID)
itemId=input("Enter Product ID : ")
[Link](itemId)
itemNo=int(input("Enter the number of Items : "))
[Link](itemNo)
sql="select rate from product where product_id=%s"
pid=(itemId,)
[Link](sql,pid)
res=[Link]()
for x in res:
print("The rate of item is :",x)
dis=int(input("Enter the discount : "))
saleRate=x[0]-(x[0]*dis/100)
[Link](saleRate)
amount=itemNo*saleRate
[Link](amount)
mnth=[Link]
if mnth<=9:
mn="0"+str(mnth)
else: mn=str(mnth)
day=[Link]
if day<=9:
dy="0"+str(day)
else:
dy=str(day)
dt=str([Link])+"-"+mn+"-"+dy
[Link](dt)
tp=(L)
sql="insert into sales (sale_id, item_id,no_of_item_sold,\
sale_rate,amount,date_of_sale) values(%s,%s,%s,%s,%s,%s)"
[Link](sql,tp)
[Link]()
sql="Select Instock from stock where item_id=%s"
[Link](sql,pid)
res=[Link]()
for x in res:
print("Total Items in Stock are : ",x)
instock=x[0]-itemNo
if instock>0:
status="Yes"
tp=(instock,status,itemId)
sql="update stock set instock=%s,status=%s where
item_id=%s"
print("Remaining Items in Stock are : ",instock)
[Link](sql,tp)
[Link]()
def ViewSales():
item=input("Enter Product Name : ")
sql="select product.product_id,
[Link],[Link],\
sales.no_of_item_sold,sales.date_of_sale,[Link] \
from sales, product where
product.product_id=sales.item_id \ and [Link]=%s"
itm=(item,)
[Link](sql,itm)
res=[Link]()
for x in res:
print(x)
def ViewSales():
item=input("Enter Product Name : ")
sql="select product.product_id,
[Link],[Link],\
sales.no_of_item_sold,sales.date_of_sale,[Link] \
from sales, product where
product.product_id=sales.item_id \ and [Link]=%s"
itm=(item,)
[Link](sql,itm)
res=[Link]()
for x in res:
print(x)
def MenuSet():#Function For The SFashion Store System
print("Enter 1 : To Add Product ")
print("Enter 2 : To Edit Product ")
print("Enter 3 : To Delete Product ")
print("Enter 4 : To View Product ")
print("Enter 5 : To Purchase Product")
print("Enter 6 : To View Purchases")
print("Enter 7 : To View Stock Detials")
print("Enter 8 : To Sale the item")
print("Enter 9 : To View Sales Detials")
try: #Using Exceptions For Validation
userInput = int(input("Please Select An Above Option: "))
#Will Take Input FromUser except ValueError:
exit("\nHy! That's Not A Number") #Error Message
else:
print("\n") #Print New Line
if(userInput == 1):
AddProduct()
elif(userInput == 2):
EditProduct()
elif (userInput==3):
DelProduct()
elif (userInput==4):
ViewProduct()
elif (userInput==5):
PurchaseProduct()
elif (userInput==6):
ViewPurchase()
elif (userInput==7):
ViewStock()
elif (userInput==8):
SaleProduct()
elif (userInput==9):
ViewSales()
else:
print("Enter correct choice. . . ")
MenuSet()
def runAgain():
runAgn = input("\nwant To Run Again Y/n: ")
while([Link]() == 'y'):
if([Link]() == "Windows"):
print([Link]('cls'))
else:
print([Link]('clear'))
MenuSet()
runAgn = input("\nwant To Run Again Y/n: ")
runAgain()
Output of code… :
Main menu:
Add product:
Edit product:
Delete product:
View product:
Purchase product:
View purchase:
View stock details:
Sale item:
View sales details:
Future enhancements
1. The process of gathering information, diagnosing the
problems, then interpreting facts is known as System analysis
.It includes recommending system improvements needed,
based on the same data.
2. The system is observed as a whole; the inputs need to be
identified firstly before tuning them and then the system is
subjected to study as a whole to identify the problem areas.
3. Although tunings any system as a whole is a complex
procedure, but tuning individual statements is not the best as
something that is correct for one input may hurt another
inputs performance.
4. The solutions are given as a proposal. The suggestion is
revised on user request and optimal changes are made. This
loop terminates as soon as the user is gratified with the
proposal.
5. So on the whole, system analysis is done to improve the
system performance by monitoring it and obtaining the best
through put possible from it.
6. It would provide more and more details of products which
the consumer or the user wants.
Bibliography
SITES REFFERED FOR SOME BASIC
INFORMATON:
1. [Link]
2. [Link]
BOOKS REFFERED:
1. Introduction to Python (class:xi),SumitaArora
2. Introduction to python(class:xii),SumitaAroraand Preeti
Arora
77