PROJECT REPORT
Title Of The Project :
“ONLINE SHOPPING SYSTEM”
For
TYBBA(CA) – Sem V
Submitted By
Raj Masurkar & Tanish Narang
INDEX
[Link] Particulars Page No.
1 Abstract 3–4
2 Introduction 5–6
3 Literature Review 7–9
4 Background of the Project 10
5 Objectives and Motivation 11
6 System Analysis 12 – 13
7 Requirement Analysis 14 – 15
1. ABSTRACT
The rapid expansion of the e-commerce sector has completely transformed the way in
which customers shop and businesses operate. Over the past decade, digitalization has
reshaped retail into a technology-driven process. Customers today expect instant access,
wide product availability, personalized shopping experiences, and secure transactions.
Unfortunately, a significant number of small and medium-sized businesses continue to
rely on outdated manual methods such as paper records, shop-only sales, and inefficient
inventory management. These methods limit business growth, create inefficiencies, and
reduce customer satisfaction.
The Online Shopping System presented in this project aims to bridge this gap by
introducing an affordable, scalable, and practical solution for small businesses. The
system is built using Python Flask for backend processes, SQLite for data storage, and
HTML/CSS for frontend design. Customers benefit from features such as registration,
login, browsing products by categories, searching items by name, managing a cart,
placing orders, and tracking their purchase history. Administrators benefit from a secure
admin panel that allows them to manage products, categories, and view orders, providing
a centralized digital platform for their business.
The significance of this project lies in its ability to enhance customer convenience while
increasing business efficiency. Customers can avoid limitations like geographical barriers
and restricted store hours, while administrators gain accurate and structured sales data.
This leads to better decision-making, improved inventory tracking, and reduced
operational costs. The system also lays the foundation for future extensions such as
payment gateway integration, delivery tracking, discount systems, and AI-based
recommendations.
Overall, this project demonstrates how even small-scale enterprises can adopt digital
transformation to remain competitive in today’s economy. By merging modern
technology with practical business needs, the Online Shopping System ensures
transparency, accessibility, and reliability, making it a powerful tool for digital retail.
2. INTRODUCTION
Shopping has been one of the most fundamental human activities, and its evolution has
closely mirrored technological development. Traditional shopping, for decades, revolved
around customers physically visiting markets, shops, or malls, comparing products, and
making purchases. While this method emphasized human interaction, it also created
limitations. Customers had to travel, spend time browsing manually, and depend on store
timings. Businesses also faced hurdles in keeping accurate records and scaling their
operations.
With the advent of the internet, e-commerce platforms revolutionized the shopping
experience. Customers could now shop at their convenience, compare products instantly,
and enjoy doorstep delivery. Giants such as Amazon, Flipkart, and Myntra proved how
digital platforms could completely transform retail. Yet, the majority of small businesses
could not afford to create or maintain complex online platforms. As a result, they risked
being left behind in the digital revolution.
The Online Shopping System proposed in this project serves as a bridge for small and
medium-sized enterprises. It offers a web-based, lightweight, and scalable platform that
provides customers with the ability to browse, search, and purchase products digitally.
Administrators can maintain their inventory, view sales records, and ensure data security
without needing high-level technical expertise. The system makes use of Python Flask as
a flexible backend, SQLite for database storage, and HTML/CSS for building an intuitive
user interface.
The significance of the system extends beyond convenience. In the current era, where
customers expect real-time access and businesses need data-driven decision-making, such
a system ensures transparency and efficiency. For students and academic purposes, this
project serves as a model to understand real-world application of concepts such as
authentication, database management, and system scalability.
This project highlights how digital transformation can be implemented affordably and
practically, enabling smaller enterprises to compete with larger retailers by providing
similar levels of convenience and reliability.
3. LITERATURE REVIEW
Early research in retail management emphasized the heavy reliance on manual methods.
Kotler [2000] discussed how physical retail models were heavily dependent on human
interaction and record-keeping, which often introduced inefficiencies. Similarly, Laudon
& Traver [2007] identified that manual systems caused poor scalability and difficulties in
managing large product catalogs.
The rise of e-commerce introduced new dimensions to retail. According to Turban et al.
[2015], digital marketplaces extended business reach globally, enabled real-time
customer interactions, and provided a wide variety of products. E-commerce platforms
quickly became essential for customer satisfaction, reshaping how businesses approached
sales. More recent studies by Laudon & Guercio Traver [2021] confirm that digital
shopping has become the backbone of the retail industry, with millions of users relying
on online systems for everyday purchases.
A critical element of e-commerce success lies in product discovery and filtering.
Aggarwal [2018] highlighted that customer satisfaction improves significantly when
users can search by categories, prices, or brand names. Ricci, Rokach, & Shapira [2015]
expanded on this by stressing the importance of recommender systems, which personalize
product suggestions and increase conversion rates. The Online Shopping System in this
project incorporates basic search and category-based browsing, aligning with these
principles.
The role of structured databases has also been a focal point in literature. Coronel &
Morris [2016] explained that databases ensure accuracy and scalability, while Elmasri &
Navathe [2017] emphasized their role in supporting transactional integrity. SQLite, being
lightweight and efficient, is particularly suited for small-scale systems like the Online
Shopping System proposed in this project.
Security remains one of the most discussed challenges in e-commerce. Siau & Shen
[2003] argued that customer trust is the most important factor for successful adoption.
Gupta & Kohli [2006] further emphasized the importance of secure authentication and
encryption. Without strong security, even the most feature-rich platforms risk losing
customer confidence.
Large e-commerce players have already adopted AI-driven personalization, digital
payments, and logistics management. However, Singh & Hess [2017] pointed out that
these complex systems are often unaffordable for SMEs. The need for simple,
customizable, and affordable platforms continues to drive the demand for lightweight
solutions like the Online Shopping System.
In conclusion, the literature establishes several key points:
• Traditional systems were inefficient [Kotler, 2000; Laudon & Traver, 2007].
• E-commerce platforms enhanced convenience and global reach [Turban et al., 2015;
Laudon & Guercio Traver, 2021].
• Search and recommendation systems boost sales [Aggarwal, 2018; Ricci et al., 2015].
• Databases ensure structured, reliable operations [Coronel & Morris, 2016; Elmasri &
Navathe, 2017].
• Security is critical to trust [Siau & Shen, 2003; Gupta & Kohli, 2006].
• SMEs require lightweight systems [Singh & Hess, 2017].
The Online Shopping System aligns with these principles by combining affordability,
usability, and scalability.
4. BACKGROUND OF PROJECT
Historically, retail transactions have been rooted in face-to-face exchanges. Customers
visited stores, physically compared products, and made purchases. Businesses maintained
manual billing systems and stock registers. While sufficient for small-scale operations,
these methods lacked accuracy, introduced errors, and were not capable of scaling with
growing customer bases.
With increasing internet penetration and smartphone usage, digital platforms emerged as
the preferred mode of shopping. Customers now expect transparency, convenience, and
instant access. Businesses unable to adapt face declining sales, poor customer retention,
and loss of competitiveness.
The Online Shopping System was developed to address these challenges. It is
lightweight, cost-effective, and practical for small businesses. By digitizing key processes
such as registration, product browsing, order placement, and inventory management, the
system reduces operational inefficiencies and improves customer satisfaction. Unlike
large-scale platforms, it requires minimal infrastructure, making it ideal for SMEs and
academic applications.
The project thus combines practical business requirements with modern technological
solutions, creating a platform that is both relevant and impactful.
5. OBJECTIVES AND MOTIVATION
The project’s objectives and motivations are summarized below:
● • Implement an Online Shopping System using Flask, SQLite, HTML, and CSS.
● • Provide essential features like secure login, browsing, cart, and order history.
● • Allow administrators to manage products and categories efficiently.
● • Bridge the gap between offline inefficiencies and digital retail opportunities.
● • Demonstrate an affordable solution suitable for SMEs and academic purposes.
6. SYSTEM ANALYSIS
System analysis is essential to understand existing challenges and propose a better
solution.
Existing System: Many SMEs still depend on offline methods. Customers must
physically visit shops, while business owners use paper records or spreadsheets. This
leads to inefficiencies such as lack of product search, absence of digital order history, and
poor customer engagement.
Proposed System: The Online Shopping System provides digital features like registration,
browsing, cart management, order history, and admin management. It centralizes records
in SQLite, ensuring accuracy and efficiency.
Feasibility Study:
• Technical: The system uses Flask, SQLite, and HTML/CSS, which are lightweight and
open-source.
• Operational: The interface is user-friendly and requires no technical expertise.
• Economic: Development costs are minimal since the system uses free, open-source
technologies.
Benefits:
• For Customers: 24/7 shopping, reliable order history, personalized accounts.
• For Admins: Centralized control, real-time inventory updates, reduced manual errors.
• For Businesses: Efficiency, scalability, and readiness for future expansion.
7. REQUIREMENT ANALYSIS
Requirement analysis identifies what the system must do and how it must perform.
Functional Requirements:
• Customers: Registration, login, product browsing, search, cart, order placement, order
history.
• Admins: Secure login, manage products, edit details, delete outdated items, view orders.
Non-Functional Requirements:
• Usability: Clean, responsive design.
• Reliability: Accurate and consistent data.
• Availability: Accessible at all times.
• Scalability: Ability to support more users and products.
• Compatibility: Works across browsers and devices.
Performance Requirements:
• Pages should load within 3–4 seconds.
• Database queries must return results within 1–2 seconds.
• System should support at least 100 users simultaneously.
Security Requirements:
• Authentication and authorization for customers and admins.
• Password hashing and input validation.
• Protection against SQL injection and cross-site scripting.
• Regular backups and recovery measures.