Volume 8, Issue 5, May – 2023 International Journal of Innovative Science and Research Technology

ISSN No:-2456-2165

Developing Online Shopping Application and

Data Analysis
Sourav Saha1 Rahul Kumar Das2 Suman Modak3
ECE Department, JIS College of ECE Department, JIS College of ECE Department, JIS College of
Engineering, Kalyani Engineering, Kalyani Engineering, Kalyani

Suvarghya Banik Roy4 Subhadip Bhaumik5

ECE Department, JIS College of Engineering, Kalyani ECE Department, JIS College of Engineering, Kalyani

Dr. Indranath Sarkar6 Dr. Bikramjit Sarkar7

Professor Professor
ECE Department, JIS College of Engineering, Kalyani CSE Department, JIS College of Engineering, Kalyani

Abstract:- In this age of the internet, most of the things Keywords:- Web Application, Responsive Design, Frontend
that we have used to doing physically, now are and Backend Development, Data Analysis and Visualization.
automated and internet driven. Because of this revolution
one of the basic jobs like shopping, is getting done by web I. INTRODUCTION
applications. The people of this developed age are
making their day-to-day purchases using online Online shopping web applications have revolutionized
shopping apps. In this paper we have proposed a the way people shop. Online shopping web applications
shopping web application and analyzed various steps of have become increasingly popular over the years, with more
its development. It contains the entire procedure, which and more consumers turning to e-commerce for their
begins with determining the sections of our application. shopping needs. With the rise of e-commerce, consumers
Like here we have login page, catalog page, checkout or can shop for products and services from the comfort of their
payment page and admin control page, developing a own homes. This convenience has made online shopping a
responsive design for frontend and developing a backend popular choice among consumers worldwide [1].
for our application. In front-end Html, Css, Bootstrap
and JavaScript are used and in backend Servlets, JSP, Data analytics is the process of examining large and
SQL, Hibernate and Java programming language are complex data sets to extract valuable insights and
used, there is an extensive discussion about the information [2,3]. In the context of online shopping web
technologies that we have used for frontend and backend applications, data analytics can help businesses understand
development. Open-source data analysis and consumer behavior, preferences, and trends. This
visualization of online shopping apps like Flipkart and information can then be used to improve the shopping
Amazon are added. The analysis was done to check some experience for customers, increase sales, and drive business
information such as what are most selling products, the growth [4]. In recent years, the use of data analytics in
discount rates on these products and the seasonal most online shopping web applications has become a game-
selling products etc. This data will be helpful in changer in the e-commerce industry[5].
determining what are the products that should be kept
in stock for every season and the discount rates on them Objective of this paper is to develop an enriched e-
etc so that the user base can be increased. and we have commerce website in our country that can be largely
mentioned features which would make our web acceptable by the customers.
application unique in case of further development.

IJISRT23MAY2624 www.ijisrt.com 2671

Volume 8, Issue 5, May – 2023 International Journal of Innovative Science and Research Technology
ISSN No:-2456-2165
II. WEB APPLICATION DESIGN

Fig 1 Block Diagram of Proposed Web Application Design

Overall workflow of the shopping application The checkout page will display a summary of the
development has been presented in the flow chart (Fig. 1). items that the user has added to their cart. So, on the
The shopping web app has a Home page where users can checkout page, the user will need to enter their local address
start browsing products. To access the website's features, details for the delivery of the products. Once all the details
users need to register or log in. Once the user enters their have been entered, the user can proceed to the payment
login credentials, they can log in as a normal user or an gateway tocomplete the transaction.
admin user.
If the user logs in as an admin, they will have full
On successful login, the user's username will be control over the website's functionalities. The admin can see
displayed in the top right corner of the page. Additionally, the number of customers who have registered on the
there will be an option for users to log out when they want website, the number of products available on the website,
to exit the website. As a normal user, the user can browse and the number of categories under which the products are
through the various products that are available for purchase. listed. Additionally, the admin can add new products and
The products section will contain all the items that are categories to the website to expand the website's offerings.
available on the website. The user can select the product Both the normal user and admin user can log out of the
they want to buy and add it to their cart. Once the user has website at any time by clicking on the logout button.
added all the products they want to purchase, they can
proceed to the checkout page.

III. DATABASE STRUCTURE DESIGN

Fig 2 User Data

Fig 3 Data Category

IJISRT23MAY2624 www.ijisrt.com 2672

Volume 8, Issue 5, May – 2023 International Journal of Innovative Science and Research Technology
ISSN No:-2456-2165

Fig 4 Product Details

Fig. 2,3,4 shows the entities, attributes, and Products associated with it. For example, a smartphone
relationships between the different components of the web product can be associated with only one category, such as
application. "Electronics", but the "Electronics" category can have many
products associated with it, such as smartphones, laptops,
 Entities: and headphones.

 User: In the above image, this relationship is represented

The user entity stores information about the users of by a one-to-many relationship between the Category entity
the web application, including their name, email, password, (represented as the parent entity) and the Product entity
and address. (represented as the child entity). The Category entity has a
primary key attribute called "Category ID", which uniquely
 Product: identifies each category, and the Product entity has a foreign
The product entity stores information about the key attribute called "Category ID" that refers to the Category
products available for purchase on the website, including entity's "Category ID" attribute. This indicates that each
their name, description, price, and image. Product is associated with only one Category. The
relationship is also indicated by the crow's foot notation on
 Category: the Category side, which shows that each Category can have
The category entity stores information about the many Products associated with it.
different categories of products, such as electronics,
clothing, and home goods.  Here are some technical terms that are commonly used
in the design and development of an online shopping
 Relationships: web application:

 Product and Category:  E-R Diagram:

One Category, Many Products: This relationship means An Entity-Relationship diagram is a visual
that each Category can have many Products associated with representation of the data schema used in the web
it, but each Product can belong to only one Category. For application. It shows the different entities, attributes, and
example, the "Electronics" categorycan have many products relationships between them.
associated with it, such as smartphones, laptops, and
headphones, but each product can belong to only one  User Authentication:
category, such as "Electronics". This refers to the process of verifying the identity of
the user trying to access the web application. The user is
 Many Products, One Category: required to enter their login credentials, such as their email
This relationship means that each Product is associated and password, to gain access to the system.
with only one Category, but each Category can have many

IJISRT23MAY2624 www.ijisrt.com 2673

Volume 8, Issue 5, May – 2023 International Journal of Innovative Science and Research Technology
ISSN No:-2456-2165
 User Authorization:  Database Integration:
This refers to the process of determining the access To integrate GPS data in the web application, the
rights of the user once they have been authenticated. The location data of local shops can be stored in the database
system checks the user's access level and determines what along with other shop information such as shop name,
actions they are allowed to perform. address, phone number, and product availability.

 Database:  User Interface:

The database stores all the information related to the The user interface of the web application can be
web application, such as user data, product data, and designed to allow users to search for local shops based on
category data. their location. This can be done by adding a search bar or
map to the website where users can enter their location or
 Backend: use their device's GPS to find nearbyshops.
The backend of the web application is responsible for
processing user requests and returning responses. It interacts  Navigation:
with the database and other external systems to retrieve and Once the user has found a local shop that they want to
process data. visit, the web application can provide navigation directions
to guide the user to the shop.
 Frontend:
The frontend of the web application is responsible for  Mobile App Integration:
displaying the user interface to the user. It interacts with the To enhance the user experience, a mobile app can be
backend to retrieve and display data. developed that utilizes the GPS capabilities of the user's
device. This can provide more accurate location data and a
 Shopping Cart: better user experience for userswho are on the go.
A shopping cart is a temporary storage area where the
user can store items that they wish topurchase. Integrating GPS for local shops in the online shopping
web application can greatly enhance the user experience and
 Checkout: make it easier for users to find the products they are looking
The checkout process is the final step in the shopping for.
process. The user enters their payment and shipping
information and confirms their purchase. IV. SCOPE OF FUTURE EXPANSION

 Payment Gateway: In the future, as online commerce continues to grow,

Online payments that are managed by a payment this website will offer users the option to register as either a
gateway service. It securely processes the user's payment buyer or a seller. The registration page will likely include a
information and authorizes thetransaction. brief explanation of the differences between the two options
so that users can make an informed decision about which
 Session Management: role they want to play.
Session management is the process of managing the
user's session in the web application. It ensures that the user Those who choose to register as buyers will typically
remains logged in and that their session remains active until be able to browse through listings of products or services
they log out or their session expires. and make purchases directly from sellers. They may also
have the option to save items to a wishlist, leave reviews or
Including GPS for local shops in the online shopping ratings for sellers, or track the status of their orders.
web application can provide several benefits for users. By
integrating GPS location data, users can easily find local On the other hand, those who register as sellers will be
shops that carry the products they are looking for, which can able to create listings of their own products or services and
save them time and money on shipping costs. Here are some set prices or terms of sale. They may also be able to manage
technical terms related to integrating GPS data in an online their inventory, process orders, and communicate with
shopping web app: buyers directly through the website. Some platforms may
offer additional tools or resources for sellers, such as
 Geolocation: analytics or marketing assistance, to help them optimize
Geolocation is the process of identifying the their sales.
geographic location of a user or device using GPS or other
location-based services.  Equal Opportunity for Offline Vendors:
Due to the widespread popularity and accessibility of
 API: e- commerce websites and applications, offline shop
An API (Application Programming Interface) is a set vendors are currently having trouble managing their
of protocols and tools for building software applications. In operations effectively and financially. Due to the fact that
the context of an online shopping web app, an API can be the majority of client traffic is now directed towards online
used to retrieve and display GPS data from external shopping applications, it is extremely difficult for them to
location-based services, such as Google Maps. compete with e-commerce websites.

IJISRT23MAY2624 www.ijisrt.com 2674

Volume 8, Issue 5, May – 2023 International Journal of Innovative Science and Research Technology
ISSN No:-2456-2165
Customers who shop online may encounter a variety this reason, offline store owners who want to boost the
of issues, like obtaining the incorrect item, defective goods, likelihood that their products will sell should put them
late delivery, challenges with replacements or refund online. One can access both online and offline shopping
processing, etc. For these reasons, some people prefer to with the use of this type of website, and offline vendors will
purchase their necessities from offline markets, but they are have an equal opportunity to grow their business.
unable to do so because they lack knowledge of the stores or
locations where they can do so. They ultimately decide to Businesses can open up new growth prospects, reach a
purchase it from online shops. larger market, and offer a smooth purchasing experience that
promotes consumer loyalty and pleasure by investing in the
In this e-commerce website, there will be an option creation of e-commerce websites. So, if you want to grow
from where the user can select their shopping preference your company, think about creating an e-commerce
(Online/offline). This interface allows users to select their website right now.
preferred shopping method by selecting either "Online" or
"Offline" option. Once the user selects their preferred REFERENCES
shopping method, they can click the "Next" button to
proceed with their shopping experience. This interface can [1]. Jill Mosteller, Naveen Donthu, Sevgin Eroglu.
be used in a variety of contexts, such as e-commerce Journal of Business Research. 67,2411-2423.(2014)
websites or mobile apps, physical retail stores, or hybrid [2]. Ruvalcaba, Z., & Boehm, A., “Introduction To The
shopping experiences. Web Development” in murach’s HTML5 and CSS3,
1sted., Fresno, CA: Mike Murach and Associates,
If the user selects online, the process will be the same Inc., 2012, pp. 4-7.
as other websites, but if selected offline, a new window will [3]. S. B. Gupta and A. Mittal, Introduction to Database
open where the user has to type the product name in the Managment System, New Delhi: University of
search box. Then, as a result, it will show the nearby shops Science Press, 2017.
from where the user can get it. It will also display the [4]. Javier Pérez-Hernández, Rocío Sánchez-Mangas.
product price and the rating of the product in different shops. Information Economics and Policy. 23, 202-
Now, the user can compare the price and the rating and 213(2011).
choose the particular shop from where he/she wants to buy it. [5]. Farag, S., Krizek, K. J., & Dijst, M. (2006). E‐
The interface could also display additional information Shopping and its Relationship with In‐store
about each shop, such as its name, address, phone number, Shopping: Empirical Evidence from the Netherlands
hours of operation, and customer ratings or reviews. Users and the USA. Transport Reviews, 26(1), 43–61.
could click on a marker to see this information in a pop-up doi:10.1080/01441640500158496
window or sidebar. [6]. International Journal of Advanced Computer
Research (ISSN (print): 2249-7277 ISSN (online):
In addition to displaying nearby shops, the interface 2277-7970) Volume-4 Number-1 Issue-14 March-
could also provide other features, such as the ability to get 2014
directions to a shop, save favorite shops for future reference, [7]. CIKM '17: Proceedings of the 2017 ACM on
or share shop locations with friends. Conference on Information and Knowledge
ManagementNovember 2017Pages 1299–
After selecting the shop, it will now show the 1308https://doi.org/10.1145/3132847.3132954
distance between the user and the selected shop. By using
GPS tracker, the user can get the route in order to reach the
shop. Overall, the interface should be user-friendly, visually
appealing, and provide the information that users need to
findnearby shops quickly and easily.

V. CONCLUSION

In conclusion, creating an e-commerce website is a

crucial first step for any company seeking to grow its
clientele and boost sales online. When building an e-
commerce website, several elements must be carefully taken
into account, including the platform selection, the site's
design and layout, the security precautions taken, and the
features and functionality necessary to deliver the best user
experience.

Businesses that don't create an e-commerce website

run the danger of falling behind their rivals and missing out
on important chances to engage with customers and make
money given the rising popularity of online shopping. For

IJISRT23MAY2624 www.ijisrt.com 2675