PM SHRI KENDRIYA VIDYALAYA

BERHAMPUR

SESSION: - 2024-2025

A Project Report On
E-COMMERCE (BLUEBERY)

For CBSE 2025 Examination

(As a part of the Computer Science Course(083))

SUBMITTED BY: UNDER THE GUIDANCE OF:

SUBHASMITA PANIGRAHI Mr. Saroj Kanta Misra
(PGT Computer Science)
CLASS: XII-A
ROLL NO :
 Certificate

This is to certify that SUBHASMITA PANIGRAHI

student of class XII A of PM SHRI KENDRIYA
VIDYALAYA BERHAMPUR has done her project
on
E-COMMERCE under my supervision. She has
taken her interest and has shown at most sincerity
in completion of this project. I certified this project
upto my expectation and as per guidelines issued
by CBSE, NEW DELHI

INTERNAL EXAMINER EXTERNAL EXAMINER

PRINCIPAL
 Acknowledgement

It is with pleasure that I acknowledge my sincere gratitude

to our teacher, MR. [Link] who taught and undertook
the responsibility of teaching the subject computer
science. I have been greatly benefited from his classes.

I am especially indebted to our principal

[Link] PRIYA DASH who has always been a
source of encouragement and support and without whose
inspiration this project would not have been a successful I
would like to place record heartfelt thanks to him.

Finally, I would like to express my sincere appreciation for

all the other students for my batch their friendship & the
fine time that we all share together.

NAME : SUBHASMITA PANIGRAHI

CLASS: XII-A
SIGN :
Hardware And Software Required

Hardware
1. PC(Intel i3 processor ,40RAM)
2. Laptop

Software
1. My sql (version 8.0)
2. Python (version 3.13.1)
3. Pyhton Connector Module
 Content

* Introduction_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

* Code_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

* Database_ __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

* Output_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

* Reference_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
 Introduction
The rise of e-commerce has revolutionized the way businesses
interact with customers, providing them with the opportunity to
reach a global market with a seamless online shopping experience.
This project focuses on building an e-commerce website using
Python and MySQL. The website will offer various features such as
product browsing, order management, user and seller interactions,
and feedback collection, all designed to create a smooth and
secure online shopping experience for both customers and sellers.
The goal of this project is to design and implement a fully
functional e-commerce platform where customers can browse
products, place orders, and provide feedback, while sellers can
manage their product listings and receive feedback.
The system will use Python for backend development. MySQL will
serve as the relational database, storing and managing user data,
product details, orders, and other critical information.

SQL Tables and Database Design

The website will rely on six key tables to manage data effectively:

Customers: This table will store details of all registered customers,

including personal information such as name, email, shipping
address, and contact number. It will also track customer activity
and order history.

Columns:customer_ID(PrimaryKey),user_name, password,full_name,
address, phone_number, email_ID
Products: This table will contain information about the products
available on the platform, such as product name, price, brand,
description, stock quantity, and category. It will enable customers
to browse products and make purchasing decisions.

Columns: product_id (Primary Key), category,Name, Quantity,Price,

Brand_Name, seller_id.

Orders: The Orders table will store information about each order
placed by customers, including the products ordered, quantities,
total price, order status, and payment details. This table will help
track order progress from placement to delivery.

Columns: Transaction_id (Primary Key), customer_id (Foreign Key),

product_id(Foreign Key),Date_of_dispatch, quantity,price, ,
Amount.

Feedback: To enhance customer satisfaction, this table will collect

feedback from customers regarding their shopping experience,
product quality, and delivery service. Feedback will be stored with
ratings and comments.

Columns: customer_id (Foreign Key),feedback,Seller_ID, product_id

(Foreign Key), Seller_Name.
Seller: This table will store information about the sellers who list
their products on the platform. Seller data will include business
name, contact information, and product listing details.

Columns:seller_id(PrimaryKey),seller_name,Brand_Name,Username,
Password,Phone_no., email_id.
Sfeedback: Just as customers provide feedback, sellers will also
have the opportunity to provide feedback on their interactions with
customers. This feedback will help improve the quality of service
on both sides of the platform.

Columns: seller_id (Primary Key),Feedback,Rating.

Project objective

Functionalities
The website will include a variety of features to enhance the
shopping experience:

Customer Interface:
User Authentication: Secure login and registration system.
Product Browsing: Customers can browse products by category,
brand, or search term.
Order Placement: Customers can place orders, view order history,
or cancel or exchange orders.
Feedback: Customers can rate and review products after purchase.
Seller Interface:
Product Listing Management: Sellers can add, update, or remove
products.
Order Management: Sellers can view and manage orders placed for
their products.
Seller Feedback: Sellers can view feedback provided by customers
and rate the customers.
SOURCE
CODE
import [Link] as m
from datetime import date

def welcome():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
print('----------------------------------------------------------------')
print('--------------------------Namaste-----------------------------')
print('************************* Welcome to Blueberry ************************')
print('----------------------------------------------------------------')
print('What is your role: ')
print('Press 1 for SELLER')
print('Press 2 for CUSTOMER')
try:
x=int(input('Enter 1 or 2:'))
except ValueError:
print('Please enter valid input:')
welcome()
else:
if x==1:
scheck()
elif x==2:
identity()
else:
print('Please enter valid input')
welcome()
finally:
[Link]()

def identity():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
print('----------------------------------------------------------------')
print('If already a user,press 1')
print('If new press 2 login to create acc')
try:
x=int(input('Enter 1 or 2:'))
except ValueError:
print('Please enter valid input')
identity()
else:
if x==1:
login()
elif x==2:
create()
else:
print('Enter valid input')
identity()
finally:
[Link]()

def create():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
 n=input('Enter your full name: ')

if [Link]()==False:
name=n
else:
print('Please enter valid Name')
create()
user=input('Enter username:')
password=input('Enter password:')
address=input('Enter address:')
p=int(input('Enter phone:'))
if len(str(p))==10:
phone=p
else:
print('Please enter valid Phone No.')
create()
email=input('Enter email:')
if "@" and "." in email:
[Link]('select max(Customer_ID) from Customers')
x=[Link]()
high=int(x[0])+1
[Link]('insert into Customer values({},"{}","{}","{}","{}",{},"{}")'.format(high,user,password,name,address,phone,email))
[Link]()
else:
print('Please enter valid email')
create()
except ValueError:
print('Please enter valid input')
create()
else:
print('----------------------------------------------------------------')
print('Your account is succesfully created')
print('Your customer ID is:',high)
login()

def login():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
x=input('enter username: ')
y=input('enter password: ')
[Link]('select * from customers;')
data=[Link]()
c=0
for i in data:
if i[1]==x:
c=c+1
if i[2]==y:
menu()
else:
print('Incorrect password')
login()
if c==0:
print('Invalid username')
login()
 except ValueError:
print('Please enter valid input')
login()
finally:
[Link]()

def menu():
print('----------------------------------------------------------------')
print('***************************** MENU *****************************')
print('----------------------------------------------------------------')
print('MENU')
print('PRESS 1 TO SEARCH')
print('PRESS 2 TO VIEW PURCHASE HISTORY')
print('PRESS 3 TO PLACE ORDER')
print('PRESS 4 TO RETURN')
print('PRESS 5 TO CANCEL ORDER')
print('PRESS 6 TO GIVE FEEDBACK')
print('PRESS 7 TO EXIT')
print('----------------------------------------------------------------')
try:
ch=int(input('Enter your choice: '))
except ValueError:
print('Please enter valid output')
menu()
else:
if ch==1:
search()
elif ch==2:
purchase_history()
elif ch==3:
order()
elif ch==4:
product_return()
elif ch==5:
cancel_order()
elif ch==6:
feedback()
elif ch==7:
print('THANK YOU FOR USING BLUEBERRY')
print('----------------------------------------------------------------')
else:
print('Please enter valid output')
menu()

def search():
while True:
print('----------------------------------------------------------------')
print('Press 1 to search via categories: ')
print('Press 2 to search via brands: ')
print('Press 3 to view all products: ')
print('Press 4 to go to previous menu: ')
print('Press 5 to exit: ')
print('----------------------------------------------------------------')
try:
ch=int(input('Enter your choice' ))
except ValueError:
 print('Please enter vaild input')
search()
else:
if ch==1:
category()
elif ch==2:
brand()
elif ch==3:
allproduct()
elif ch==4:
menu()
elif ch==5:
break
else:
print('Please enter valid input')
search()

def category():
print('PLEASE SELECT FROM FOLLOWING CATEGORIES: ')
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
[Link]('select distinct Category from Products')
data=[Link]()
for i in data:
print(i)
try:
cat=input('Enter category to search')
[Link]('select * from Products where category like "%{}%"'.format(cat))
char=[Link]()
c=0
for i in char:
c=c+1
print('----------------------------------------------------------------')
print('PRODUCT NUMBER ',c)
print('Product ID: ',i[0])
print('Category: ',i[1])
print('Name: ',i[2])
print('Quantity available: ',i[3])
print('Price: ',i[4])
print('Brand Name: ',i[5])
print('Seller ID: ',i[6])
print('----------------------------------------------------------------')
print ('TO PLACE ORDER ENTER 55')
print('TO GO BACK TO PREVIOUS MENU ENTER 77')
ord=int(input('Enter your choice: '))
except ValueError:
print('----------------------------------------------------------------')
print('Please enter valid input')
category()
else:
if ord==55:
order()
elif ord==77:
search()
else:
print('----------------------------------------------------------------')
 print('Please enter valid input')
category()
finally:
[Link]()

def brand():
print('PLEASE SELECT FROM FOLLOWING BRANDS: ')
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
[Link]('select distinct Brand_Name from Products')
data=[Link]()
for i in data:
print(i)
try:
cat=input('Enter category to search')
[Link]('select * from Products where Brand_Name like "%{}%"'.format(cat))
char=[Link]()
c=0
for i in char:
print('----------------------------------------------------------------')
c=c+1
print('PRODUCT NUMBER ',c)
print('Product ID: ',i[0])
print('Category: ',i[1])
print('Name: ',i[2])
print('Quantity available: ',i[3])
print('Price: ',i[4])
print('Brand Name: ',i[5])
print('Seller ID: ',i[6])
print('----------------------------------------------------------------')
print ('TO PLACE ORDER ENTER 55')
print('TO GO BACK TO PREVIOUS MENU ENTER 77')
ord=int(input('Enter your choice: '))
except ValueError:
print('Please enter valid input')
brand()
else:
if ord==55:
order()
elif ord==77:
search()
else:
print('Please enter valid input')
brand()
finally:
[Link]()

def allproduct():
print('Following are all the products available: ')
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
[Link]('select * from Products')
data=[Link]()
c=0
for i in data:
print('----------------------------------------------------------------')
 c=c+1
print('PRODUCT NUMBER ',c)
print('Product ID: ',i[0])
print('Category: ',i[1])
print('Name: ',i[2])
print('Quantity available: ',i[3])
print('Price: ',i[4])
print('Brand Name: ',i[5])
print('Seller ID: ',i[6])
print('----------------------------------------------------------------')
print ('TO PLACE ORDER ENTER 55')
print('TO GO BACK TO PREVIOUS MENU ENTER 77')
try:
ord=int(input('Enter your choice: '))
except ValueError:
print('Please enter valid input')
allproduct()
else:
if ord==55:
order()
elif ord==77:
search()
else:
print('Please enter valid input')
allproduct()
finally:
[Link]()

def purchase_history():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
cust=int(input('Enter your customer id to proceed: '))
except:
print('Enter vaild input')
purchase_history()
else:
[Link]("select * from orders where customer_id={}".format(cust))
data=[Link]()
if len(data)>0:
c=0
for i in data:
c=c+1
print('----------------------------------------------------------------')
print("ORDER NUMBER: ",c)
print("Transaction ID: ",i[0])
print("Product ID: ",i[2])
print("Date of dispatch: ",i[3])
print("Quantity placed: ",i[4])
print("Price: ",i[5])
print("Total Amount: ",i[6])
print('----------------------------------------------------------------')
else:
print('No orders placed')
print('To place order press 22')
 print('To go back to the main menu, press 33')
ch=int(input('Enter your choice: '))
if ch==22:
order()
elif ch==33:
menu()
else:
print('Please enter valid input')
menu()
finally:
[Link]()
menu()

def order():
print('TO PLACE ORDER ENTER THE FOLLOWING DETAILS: ')
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
cust=int(input('Enter your customer id to proceed: '))
prd=int(input("Enter the product id: "))
to=[Link]()
qty=int(input("Enter quantity of product: "))
[Link]('select quantity from products where product_id={}'.format(prd))
y=[Link]()
x=y[0]
if int(x)>qty:
[Link]('select max(Transaction_ID) from Orders')
x=[Link]()
high=int(x[0])+1
[Link]('select * from products where product_id={}'.format(prd))
data=[Link]()
pid=data[0]
pri=data[4]
amo=pri*qty
print ('Your total amount is: ',amo)
print ('To confirm your order, Press 55')
print ('To search again, Press 22')
ch=int(input('Enter your choice: '))
if ch==55:
[Link]('insert into orders values({},{},{},"{}",{},{},{})'.format(high,cust,pid,to,qty,pri,amo))
[Link]('update products set quantity=quantity-{} where product_id={}'.format(qty,pid))
print('----------------------------------------------------------------')
print('Your order is successfully placed')
[Link]()
print ('Your Transaction ID is: ',high)
print ('Total amount: ',amo)
print ('----------------------------------------------------------------')
print ('NOTE: Please note the transaction id for future references')
print ('To go back to the main menu, Press 1')
choice=int(input('Enter your choice: '))
if choice==1:
menu()
else:
print('Please enter valid input')
order()
 elif ch==22:
search()
else:
print('Please enter valid input')
order()
elif int(x)>1 and int[y][0]<qty:
print('Sufficient quantity is not available')
print('Quantity available: ',int[y][0])
menu()
elif int(x)==0:
print('----------------------------------------------------------------')
print('Out of stock')
menu()
[Link]()
except ValueError:
print('Please enter vaild input')
order()

def product_return():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
cust=int(input('Enter your customer id:'))
pro=int(input('Enter your product id:'))
tra=int(input('Enter your transition id:'))
print('----------------------------------------------------------------')
print('Press 1, If your product is damage:')
print('Press 2,If your product is broken:')
print('Press 3,wrong item:')
print('Press 4,If wrong fitting:')
print('Press 5,If any other reason type below:')
print('----------------------------------------------------------------')
a=int(input("Enter your choice:"))
if a==1 or a==2:
cancel_order()
elif a==3 or a==4:
print("Press 1,If you want to exchange")
print("Press 2,If you want to cancel")
b=int(input("Enter your choice:"))
if b==1:
exchange()
elif b==2:
cancel_order()
else:
print('Please enter vaild input')
product_return()
elif a==5:
c=input("Please enter your reason")
print("Press 1,If you want to exchange")
print("Press 2,If you want to cancel")
d=int(input("Enter your choice:"))
if d==1:
exchange()
elif d==2:
cancel_order()
else:
 print('Please enter vaild input')
product_return()
else:
print('Please enter vaild input')
product_return()
except ValueError:
print('Please enter vaild input')
product_return()
finally:
[Link]()

def exchange():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
cust=int(input('Enter your customer id: '))
pro=int(input("Enter Product Id: "))
print("Press 1, if you want to rebuy the same product")
print("Press 2,if you want to buy anythingelse")
a=int(input("Enter your choice"))
if a==1:
order()
elif a==2:
search()
else:
print('Please enter vaild input')
exchange()
except ValueError:
print('Please enter vaild input')
exchange()
else:
print('Your order is succesfully exchanged')
finally:
[Link]()
menu()

def cancel_order():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
cust=int(input('Enter your customer id: '))
pro=int(input("Enter Product Id: "))
tra=int(input("Enter Transaction ID:"))
[Link]('select * from orders where Transaction_ID={}'.format(tra))
data=[Link]()
if data[1]==cust and data[2]==pro:
[Link]('delete from orders where Transaction_ID={}'.format(tra))
print('Your order is succesfully cancelled')
qty=data[4]
[Link]('update products set quantity=quantity+{} where product_id={}'.format(qty,pro))
[Link]()
menu()
else:
 print('Please enter valid input')
cancel_order()
except ValueError:
print('Please enter vaild input')
cancel_order()

def feedback():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
print('----------------------------------------------------------------')
print('Your valuable feedbacks are always appreciated')
print('Please spare a few moments to give your opinion')
print('To give opinion about our app press 22')
print('To give opinion about a specific product press 33')
try:
ch=int(input('Enter your choice: '))
if ch==22:
print('Give your opinion below')
feed=input('Type your suggestions')
cust=int(input('Enter your customer id: '))
print('Thank You for your feedback ')
[Link]('insert into feedbacks (Customer_ID,Feedback) values ({},"{}")'.format(cust,feed))
[Link]()
menu()
elif ch==33:
print('Give your opinion below')
cust=int(input('Enter your customer id: '))
pro=int(input('Enter the product id: '))
[Link]('select seller_id from products where product_id={}'.format(pro))
data=[Link]()
sell=data[0]
[Link]('select seller_name from products p,seller s where p.seller_id=s.seller_id and product_id={}'.format(pro))
data1=[Link]()
sname=data1[0]
feed=input('Type your suggestions')
print('Thank You for your feedback ')
[Link]('insert into feedbacks values ({},"{}",{},{},"{}")'.format(cust,feed,sell,pro,sname))
[Link]()
menu()
except ValueError:
print('Please enter vaild input')
feedback()

def scheck():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
print('----------------------------------------------------------------')
print('If already a user,press 1')
print('If new press 2 login to create acc')
try:
x=int(input('Enter 1 or 2: '))
except ValueError:
print('Please enter vaild input')
scheck()
else:
if x==1:
slogin()
 elif x==2:
seller()
else:
print('Enter valid input')
scheck()
finally:
[Link]()

def seller():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
name=input('Enter Your Full Name:')
username=input('Enter a Username:')
password=input('Enter a Password:')
bname=input('Enter a Brand Name:')
phone=int(input('Enter your Phone No.:'))
email=input('Enter your email id:')
if "@" and "." in email:
[Link]('select max(Seller_ID) from seller')
s=[Link]()
sid=int(s[0])+1
[Link]('insert into seller values ({},"{}","{}","{}","{}",{},"{}")'.format(sid,name,bname,username,password,phone,email))
[Link]()
else:
print('Please enter valid email')
seller()
except ValueError:
print('Please enter vaild input')
seller()
else:
print('Your account is succesfully created')
print('Your seller ID is:',sid)
slogin()

def slogin():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
x=input('enter username: ')
y=input('enter password: ')
[Link]('select * from seller')
data=[Link]()
c=0
except ValueError:
print('Please enter vaild input')
slogin()
else:
for i in data:
if i[3]==x:
c=c+1
if i[4]==y:
smenu()
else:
 print("Incorrect password")
slogin()
if c==0:
print ('Invalid username')
slogin()
finally:
[Link]()

def smenu():
print('----------------------------------------------------------------')
print('***************************** MENU *****************************')
print('----------------------------------------------------------------')
print('To Add Item, Enter 1')
print('To Delete Item, Enter 2')
print('To update Item, Enter 3')
print('To give feedback, Enter 4')
print('To view your product_id, Enter 5')
print('To exit, Enter 6')
try:
c=int(input('Enter your choice:'))
except ValueError:
print('Please enter vaild input')
smenu()
else:
if c==1:
Adds()
elif c==2:
delete_item()
elif c==3:
update_item()
elif c==4:
sfeedback()
elif c==5:
sview()
elif c==6:
print('THANK YOU FOR USING BLUEBERRY')
print('----------------------------------------------------------------')
else:
print('Enter vaild input')
smenu()

def Adds():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
cat=input('Enter category of product:')
name=input('Enter name of product:')
qyt=int(input('Enter quantity of product:'))
pri=int(input('Enter price of product:'))
sid=int(input('Enter your seller ID:'))
[Link]('select seller_name from seller where seller_id={}'.format(sid))
data1=[Link]()
bname=input('Enter your brand name:')
[Link]('select max(Product_ID) from products')
data=[Link]()
 h=int(data[0])+1
if len(data1)==0:
print("Please enter valid seller_id")
Adds()
else:
[Link]('insert into products values({},"{}","{}",{},{},"{}",{})'.format(h,cat,name,qyt,pri,bname,sid))
[Link]()
print('----------------------------------------------------------------')
print ('Your product ID is ',h)
except ValueError:
print('Please enter vaild input')
Adds()
else:
print('Your product is succesfully added ')
smenu()

def delete_item():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
try:
print('----------------------------------------------------------------')
ch=int(input("Enter product_ID: "))
[Link]('select * from products where product_ID={}'.format(ch))
data=[Link]()
try:
if data[0]==ch:
[Link]('delete from products where product_ID={}'.format(ch))
print('Your produce is succesfully deleted')
else:
print('Please enter valid input')
delete_item()
[Link]()
smenu()
except:
print('Please enter vaild input')
delete_item()
except ValueError:
print('Please enter vaild input')
delete_item()

def update_item():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
print('----------------------------------------------------------------')
print('Press 1, To update price')
print('Press 2, To update quantity')
print('Press 3, To change produce name ')
print('Press 4, To change brand name ')
print('Press 5, To change category ')
try:
ch=int(input('Enter your choice: '))
pid1=int(input('Enter product ID: '))
[Link]('select * from products where product_Id={}'.format(pid1))
data=[Link]()
if len(data)==0:
print('Please enter valid Product_ID')
 update_item()
else:
if ch==1:
pri=int(input('Enter price to update: '))
[Link]('update products set Price={} where Product_ID={}'.format(pri,pid1))
[Link]()
print('Price is succesfully updated')
elif ch==2:
qty=int(input('Enter quantity to update: '))
[Link]('update products set Quantity={} where Product_ID={}'.format(qty,pid1))
[Link]()
print('Quantity is succesfully updated')
elif ch==3:
s=input('Enter name of product to update: ')
[Link]('update Products set Name="{}" where Product_ID={}'.format(s,pid1))
[Link]()
print('Name of produce is succesfully updated')
elif ch==4:
brand=input('Enter name of brand to update: ')
[Link]('update Products set Brand_Name="{}" where Product_ID={}'.formate(brand,pid1))
[Link]()
print("Name of brand is succesfully updated")
elif ch==5:
cat=input('Enter category to update: ')
[Link]('update Products set Category="{}" where Product_ID={}'.formate(cat,pid1))
[Link]()
print('Name of category is succesfully updated')
else:
print('Please enter valid input')
update_item()
[Link]()
except ValueError:
print('Please enter vaild input')
update_item()
else:
smenu()

def sfeedback():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
print('----------------------------------------------------------------')
print('Your valuable feedbacks are always valued')
print('Please spare a few moments to give your opinion')
print('Give your opinion below')
try:
feed=input('Type your suggestions: ')
sid=int(input('Enter your seller ID: '))
rating=int(input('Enter rating out of 5:'))
[Link]('insert into sfeedback values ({},"{}",{})'.format(sid,feed,rating))
[Link]()
except ValueError:
print('Please enter vaild input')
sfeedback()
else:
print('Thank You for your feedback ')
print('----------------------------------------------------------------')
 smenu()

def sview():
db=[Link](host='localhost',user='root',password='admin',database='e_commerce')
co=[Link]()
print('----------------------------------------------------------------')
try:
sell=int(input('Enter your Seller_ID: '))
[Link]('select product_id,name from products where seller_id={}'.format(sell))
data=[Link]()
except:
print('Please enter vaild input')
sview()
else:
if len(data)==0:
print('Please enter valid Seller_ID')
sview()
else:
print('Following are your Product_ID: ')
for i in data:
print('Product_ID: ',i[0] ,'Product Name: ',i[1])
print('----------------------------------------------------------------')
[Link]()

welcome()
 MySQL
DATABASES
E-COMMERCE DATABASE:

CUSTOMER TABLE:

FEEDBACK TABLE:
ORDER TABLE:

PRODUCT TABLE:

SELLER TABLE:
SELLER’S FEEDBACK TABLE:
OUTPUTS
CUSTOMER’S OUTPUT
STARTING INTERFACE:

CUSTOMER INTERFACE:

CUSTOMER SIGNUP:
CUSTOMER LOGIN:

CUSTOMER MAIN-MENU:

SEARCH MENU:
SELECTING OF PRODUCT(via CATEGORIES):

SELECTING OF PRODUCT (via BRANDS):

SELECTING OF PRODUCT (via ALL PRODUCTS):
TO PLACE ORDER:

TO VIEW PURCHASE HISTORY:

RETURN OF PRODUCT:
EXCHANGE OF PRODUCT:

TO CANCEL PRODUCT:
TO GIVE FEEDBACK:
TO EXIT :

SELLER’S OUTPUT:

STARTING INTERFACE:
SELLER’S INTERFACE:

SELLER’S SIGN IN:

SELLER’S LOGIN:

SELLER’S MENU:
TO ADD A PRODUCT:

TO DELETE ITEM:
TO UPDATE ITEM:

(UPDATE OF PRICE)

(UPDATE OF QUANTITY)
(UPDATE OF PRODUCE NAME)

TO GIVE FEEDBACK:
TO EXIT:
 REFERENCES:

In order to work on this project titled - E-COMMERCE the following

books and websites are referred by me during the various phases of
development of the project.

1. Computer science with PYTHON (Sumita Arora)

2. [Link]

3. [Link]

4. [Link]

5. [Link]

6. [Link]

Other than the above-mentioned books, the suggestions and

supervision of my teacher and my class experience also helped me to
develop this software project.