Online Shopping System.docx

A
Project Report on
Online Shopping Management System
Submitted to
Savitribai Phule Pune University
In the partial fulfillment of the requirement of the award of the degree of
Bachelor of Business Administration- Computer Application,
TYBBA - CA, Sem V
Academic Year 2023-24
By
POOJA PAWAR
&
PRAJAKTA INGLE
Under the guidance of
Prof. Sachin Ponde
Through
Alandi (D)- Pune 412105

Alandi (D) - Pune 412105
CERTIFICATE
Department of Computer Application
This is to certify that Ms. Pooja Pawar , Exam Seat No. (TA052), & Ms. Prajakta
Ingle , Exam Seat No. (TA050), of TYBBA-CA, Sem V, has successfully completed
project work entitled Online Shopping Management System in the partial fulfillment of
the requirement of the degree of Bachelor Of Business Administrator-Computer
Application for the Academic Year 2023-24
Mr. Sachin Ponde Dr. Vikas Mahandule
Project Guide Head of the Department
Internal Examiner External Examiner

ACKNOWLWDGEMENT
The words are not enough to express my thanks to Dr. B. B. Waphare, Principal,
MIT Arts Commerce and Science College Alandi (D) for providing me with the
opportunity to avail the excellent facilities and infrastructure of the institute.
It is my proud privilege to express my profound gratitude to Dr. Vikas Mahandule,
HOD, Computer Application Department, for his astute guidance, constant
encouragement and sincere support throughout my academic course.
I thanks to my honest gratitude to Prof. Sachin R. Ponde for her inspiration,
constructive suggestions and affectionate guidance in my project work completion.
Last but not the least, I express my sincere thanks to all my dear friends and family
members for their constant motivation, moral support and invariable direction throughout
my life.

DECLARATION
We, Pooja Pawar & Prajakta Ingle, hereby declare that this project work entitled
Online Shopping Management System submitted at MIT, Arts Commerce and Science
College, Alandi(D), (Affiliated to Savitribai Phule Pune University) is a record of original
work done by me under the supervision and guidance of Prof. Sachin R. Ponde,
Department of Computer Application.
Signature :
1) Name of Student : Pooja Pawar
Exam Seat No.:
2) Name of Student : Prajakta Ingle
Exam Seat No.:
Place : Alandi (D), Pune
Date :

Index
Chapter No. Chapter Title Page No.
CHAPTER 1 INTRODUCTION
1.1 Problem Statement
1.2 Objective and Goals
1.3 Project Scope and Limitations
CHAPTER 2 SYSTEM ANALYSIS
2.1 Existing System
2.2 Project Perspective and Features
2.3 Functional Requirement
2.4 Hardware & Software Requirement
CHAPTER 3 SYSTEM DESIGN
3.1 E-R Diagram
3.2 Data Flow Diagram
3.3 Data Dictionary
CHAPTER 4 FORM DESIGN (with input values)
CHAPTER 5 REPORTS
CHAPTER 6 CONCLUSION & RECOMMENDATION
CHAPTER 7 FUTURE SCOPE
CHAPTER 8 BIBLIOGRAPHY

INTRODUCTION
Online Shopping is the form of electronic commerce that allow customers to
buy goods or service directly from the seller over the internet. Online shopping
definitely a great way to shop with everything available on the websites.
 Nowadays, online shopping occupying an essential part of shopping , big and
small companies or store need to have its commercial websites, any serious
business can’t be improved and reaches all over the world unless it has
websites, even most families , clubs and pets ,snacks do, too.
 These project is aimed at developing a web application that depicts online
shopping of mobiles and purchasing using payment gateway.
 Using these software , companies can Improve the efficiency of their services.
Online shopping is one of the application to improve the marketing of the
company’s product.
 The application involves all the features of the online shopping.
 The project of online shopping system is very helpful for where the customer
can directly buy the product or items form home through internet connection
on mobile or a system.
 These system helps to choose products faster and easier at one place.

Problem Statement
The current shopping system is critical to set up online shops, customers to
browsers through the shop and a system administrator to approve and reject request
for new shop and maintain lists of categories. This is small scale project for online
shopping system.
The basic idea behind is that the candidate can buy product from anywhere
during any time by using their card number and password provided to them. The
database will maintain the product detail information. Customer can view their
product detail using the card details.
In every shop when we are entering the shop we see their number of product
that’s very difficult to choose or select timing. You cannot see the all cloths form the
all sides. Online shopping is a big shop which maintain the whole records of all the
products.
Reliability:
 As the existing system is maintained manually work as tasking stock,
recording entries of billing may prone to error to human intervention.
Time:
 A lot of time requires checking and generating bill.

Objectives and Goals
 The online shopping system is a web-based application. The purpose of the
application is too automatic and facilitate the whole process of shopping.
 To user can easily add a product or remove a product from the shopping cart.
 To determine the factors and attributes which influence online buying behavior
of consumers.
 To study customers satisfaction with respect to online shopping.
 To study online shopping system models and various factors related to
consumer behavior towards online shopping.
 To developed and easy to use web-based interface where user can search for
product view a complete description of the product and other the product.
 To main objective to increase the quantity of sales by making the new
technology of web pages design more attractive and to search a lot of customers
and company to their location.

Project Scope & Limitations
Purchasing and selling product and service over the internet without the need
of going physically to the market is what online shopping all about. Online shopping
just like a retail store shopping that we do going to the market but it is done through
the internet.
Online shopping store offer product description ,pictures, comparison, price and
much more. For ex. these are amazon.com. Online shopping makes used of digital
technology for managing the flow of information, products and payments between
consumer site owner and suppliers.
LIMITATIONS:
 Lack of interactivity in online shopping.
 Frauds in online shopping.
 You cannot bargain.
 Online shoppers do not have ability to physically inspect or try on the item
being considered for purchase.

SYSTEM ANALYSIS
The process of gathering information, diagnosing the problems, then
interpreting facts is known as System analysis. It also includes recommending system
improvements needed, based on the same data. The system is observed as a whole,
the inputs need to be identified first before turning them and then the system is
subjected to study as a whole to identify the problem areas.
Although tunning any system as a whole is a complex procedure, but tunning
individual statements is not the best as something that is correct for one input may
hurt another input’s performance. 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.
So, on the whole, system analysis is done to improve the system performance
by monitoring it and obtaining the best throughput possible from it. Therefore, system
analysis plays a crucial role in designing any system.

Existing System
The present scenario for shopping is to visit the shops and market manually
and then from the available product list one needs to choose the item he or she wants
and then pay for the same item mainly in cash mode is done, as not every society is
well educated and aware to use net banking or card modes or wallets etc.
This system is not much user friendly as one needs to go to the market
physically and then select items only from the available list. So mostly it is difficult
to get the product as per our desire. Description About the products is less available
and are mostly verbal only. For this type of shopping, one needs to have an ample
amount of free time.
Also, not really good markets exist everywhere, so many times good markets
become out of reach for certain people. In the proposed system customers need not
go to the shops for purchasing the products. He/she can order the product he/she
wishes to buy through the use of this system. The shop owner can be the admin of
the system.
Shop owners can appoint officials particularly to handle this, who will help
the owner in managing the customers and product orders. The system also endorses
a home delivery system for delivering the purchased products.

Project Prospective & Feature
A typical online store enables the customer to browse the firm's range of
products and services, view photos or images of the products, along with information
about the product specifications, features and prices.
Online stores usually enable shoppers to use "search" features to find specific
models, brands or items.
Online shopping system helps to reduce the tension of choosing product. They
can just see the photos ,videos and also reviews of the people to the particular product.
In future online shopping helps the most because you the day by day the life
is going busy so in future people they don’t have enough time to go in the market and
buy the clothes by its so time consuming.
So , you just login into the websites and choose your favorite product and
payment online or after the delivery and also you don’t want to go anywhere you just
place the order and you will get the product at home.

Functional Requirement
# The functional requirement of the online shopping system is:
 Registration:- Customer wants to buy the product then they must be
registered, unregistered user can’t go to the shopping cart.
 Login:- Customer have to login into the system.
 Order Report:- Customer have to order the product.
 Stock Report:- Produce the quantity of the products available and status
of the products.
 Change to Cart:- Changes to cart means the customer after login or
registration can make order or cancel order of the product from the
shopping cart.
 Delivery Report:- List of the products that can be delivered to the
customers.
 Transaction:- Transaction is payment method in which the transfer of
money of buying products. This process is secure and password protected.

Hardware & Software
Requirement
 Hardware Requirement:
1)Minimum 512 MB main memory.
2)Standard Keyboard
3)Mouse
4)Monitor
5)CD-ROM
 Software Requirement:
1)Windows 11
2)Microsoft word
3)Microsoft excel
4)Microsoft access
5)Software Developer

SYSTEM DESIGN
The system design includes the CLD ,DFD and the ER diagram of the system.
The CLD is the context level diagram which includes the main entities of the system
and the DFD is the data flow diagram which includes that how the data is flow into
the system.
There are levels into the DFD ,first level DFD , second level DFD. The levels of the
DFD are depend on how many date flows are in the system.
The ER diagram show the relation between each entity. In the online shopping
system there are many entities those are depend on each other and they have
connection between them.

Data Dictionary
 Customer
Field
Name
Size Data-Type Constraint Description
Customer_ID 9 Varchar Not Null
Primary Key
Customer
Identification number
Password 8 Varchar Not Null
Primary Key
The password of the
customer
First_name 10 Char Not Null The First name of the
customer
Last_name 10 Char Not Null The Last name of the
customer
Username 10 Varchar Not Null
Primary Key
The username of the
customer
Contact_no 10 Number Not Null The contact number
of the customer
Email_Id 20 Varchar Not Null The Email Id of the
customer
Address 20 Varchar Not Null The address of the
customer
Pincode 8 Number Not Null The pincode of the
area where customer
live.

 Product
Field
Name
Product_ID 9 Varchar Not Null Identification
number of the
product
Product_name 20 Varchar Not Null The name of the
product
Product_price 10 Number Not Null The price of the
product
Product_brand 10 Varchar Not Null The brand of the
product
Product_quality 10 Varchar Not Null The quality of the
product
Product_type 10 Varchar Not Null The type of the
product

 Payment
 Cart
Field
Name
Payment_ID 15 Varchar Not Null Identification number
of the payment
Payment_type 10 Varchar Not Null The type of the order
payment
Payment_amt 10 Number Not Null The price of the
product
Payment_pin 10 Number Not Null The pin number of
the payment
Payment_date 10 Varchar Not Null Date of Payment
Field
Name
Cart_ID 15 Number Not Null
Primary Key
Identification
number of the
customer cart
P_info 10 Varchar Not Null The information of
the products in the
customer cart
Cart_name 10 Varchar Not Null The name of the
customer cart

 Order
Field
Name
order_ID 15 Number Not Null
Primary Key
Identification
number of the
customer order
order_type 10 Varchar Not Null The type of the
products in the
customer order
order_status 20 Varchar Not Null The status of the
product
order_date 10 Date Not Null The date of the
order delivery

Output Screen
 Receipt Screen

REPORT
The project deals with developing an e-commerce websites for online
shopping . It provides the user with a catalogue of different goods and service. The
project include the features and future need of the online shopping system.
This application can be used for any Ecommerce applications. It is easy to use,
since it uses the GUI provided in the user dialog. User friendly screens are provided.
The applications is easy to use and interactive making online shopping a recreational
activity for users. It has been thoroughly tested and implemented.
This is the most important project for save the time of the people and also give
the best quality product into the less cost. The main objective of the project is to make
it interactive and its ease to use. It would make searching, viewing, and selection of
a product easier.

CONCLUSION &
RECOMMENDATION
The “Online Shopping” is designed to provide a web-based application that
would make searching, viewing and selection of a product easier. The search engine
provides an easy and convenient way to search for products where a user can search
for a product interactively, and the search engine would refine the products available
based on the user’s input.
 User Friendly :
The system has got much simplified screen which makes the system fast
enhances quick and accurate data.
 Validation check:
The system has various validation check and it also gives appropriate error
message and provide the necessary help.
 Report generation:
The system can generate various report giving employee details, working driver
details, deleted driver details, printing roster for drivers etc.

FUTURE SCOPE
 Due to time limitation, we could not concentrate on the report facility by the
customers details which is our future aspect.
 And also due to time limitation we could not concentrate on the update stock
to update multiple products.
 As this version occupies more space the next will be quite compact and up to
the mark.
 As competition is increasing we are also increasing the facility.
 We hope we will success in our project.
 Users can have multiple shipping and billing information saved. During
checkout they can use the drag and drop features to select shipping and billing
information.
 The users could subscribe for price alerts, which would enable them to receive
message when price for products fall below a particular level.

BIBLIOGRAPHY
 www.wikipedia.com
 www.SlideShare.com
 www.Acdemia.com
 www.google.com
 www.youtube.com
 Book-Software Engineering (SYBBACA-SEM 3)

Online Shopping System.docx

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Online Shopping System.docx

Similar to Online Shopping System.docx (20)

Recently uploaded

Recently uploaded (20)

Online Shopping System.docx