Tribhuvan University Faculty of

Humanities and Social Sciences

Online Grocery Shop

A PROJECT REPORT

Submitted to Department of
Computer Application

In partial fulfillment of the requirements for the Bachelors in Computer Application

Submitted by Sujan Dheke

Under the Supervision of

Abhimanyu yadav

November 13, 2024

 Tribhuvan University Faculty of
Humanities and Social Sciences

SUPERVISOR’S RECOMMENDATION

I hereby recommend that this project prepared under my supervision by ___Abhimanyu

yadav __ entitled “Online grocery shop” in partial fulfillment of the requirements for
the degree of Bachelor of Computer Application is recommended for the final evaluation.

Mr. ABHIMANYU YADAV

SUPERVISOR

i
 Tribhuvan University Faculty of
Humanities and Social Sciences
Kathmandu Bernhardt College

LETTER OF APPROVAL

This is to certify that this project prepared by Sujan Dheke entitled “Online
Grocery shop” in partial fulfillment of the requirements for the degree of Bachelor
in Computer Application has been evaluated. In our opinion it is satisfactory in the
scope and quality as a project for the required degree.

………………………………………….. ……………………………………………..
Mr. Abhimanyu yadav Mr. Abhimanyu yadav
Supervisor Supervisor

………………………………………….. ………………………………..
Internal Examiner External Examiner

ii
 ABSTRACT

The online grocery shopping platform provides a convenient and efficient way for users
to purchase groceries and household essentials through a digital interface. By integrating
robust features such as product search, category-based browsing, personalized
recommendations, secure payment options, and delivery scheduling, the platform
addresses the growing demand for seamless shopping experiences.

The system leverages advanced technologies such as collaborative filtering to offer

personalized product suggestions based on user preferences and purchase history. A user-
friendly interface, built with responsive design principles, ensures accessibility across
devices, while the backend, powered by a reliable database and frameworks like Django,
manages inventory, orders, and user data in real time.

Additionally, the platform includes an admin panel for managing product listings,
tracking orders, and ensuring operational efficiency. Designed to cater to the dynamic
needs of modern consumers, this solution reduces the time and effort associated with
traditional grocery shopping, while also offering businesses a scalable and sustainable e-
commerce solution.

Keywords: online grocery shop, html,JavaScript, php, mysql

iii
 ACKNOWLEDGEMENT

We are thankful to all those who directly and indirectly guided and helped us to make this
project successful. A special gratitude to our semester project supervisor Mr.
Abhimanyu yadav whose guidance and suggestion were important factors for
completing this project more efficiently.
Kind opinions, suggestions, feedback and appropriate guidelines from our teachers,
friends and parents helped us to sharpen our knowledge and try new things in our project.
Our special thanks are due to the staff and management team of Kathmandu Bernhardt
college for providing necessary resources and suitable environment to conduct the
project. In the end, we would like to appreciate everyone who were connected with us to
make this project possible by providing support, motivation and their valuable time.

iv
 Table of Contents
ABSTRACT........................................................................................................................iii

ACKNOWLEDGEMENT...................................................................................................iv

CHAPTER 1: INTRODUCTION`.......................................................................................8

1.1 Introduction................................................................................................................8

1.2 Problem Statement.................................................................................................8

1.3 Objectives..............................................................................................................8

1.4 Scope and Limitation.............................................................................................9

1.6 Development Methodology...................................................................................2

1.7 Report Organization...............................................................................................2

CHAPTER 2: ACKGROUND STUDY AND LITERATURE REVIEW...........................4

2.1 Background Study.................................................................................................4

2.2 Literature Review..................................................................................................4

CHAPTER 3: SYSTEM DESIGN AND ANALYSIS.........................................................6

3.1 System Analysis.........................................................................................................6

3.1.1 Requirement Analysis..........................................................................................6

3.2 Feasibility Analysis....................................................................................................8

3.2.2 Process Modeling (DFD)...................................................................................10

System Design................................................................................................................12

3.2.3 Architectural Design..........................................................................................12

3.2.4 Database Schema Design...................................................................................13

3.2.5 Interface Design (UI/UX)..................................................................................14

Figure 7: Home page of online grocery page.................................................................14

3.2.5 Physical DFD.....................................................................................................16

3.3 Algorithm Details.....................................................................................................18

Content-Based Filtering Algorithm............................................................................18

CHAPTER 4: IMPLEMENTATION AND TESTING......................................................20

v
 4.1 Implementation.........................................................................................................20

4.1.1 Tools Used (CASE Tools, Programming Languages, Database Platforms).....20

4.1.2 Implementation Details of Modules..................................................................21

4.2 Testing.................................................................................................................21

4.2.1 Test Cases for Unit Testing...............................................................................22

4.2.3 Test Cases for System Testing...........................................................................23

CHAPTER 5: CONCLUSION AND FUTURE RECOMMENDATION.........................27

5.1 Learn / Outcome.......................................................................................................27

5.2 Conclusion................................................................................................................27

5.3 Future Recommendation...........................................................................................27

APPENDICES
REFERENCES

vi
Figure 1: Use Case Diagram of online grocery shop 7
Figure 2 ER Diagram of Online grocery shop 9
Figure 3:Level-0 DFD of Online grocery shop 10
Figure 4:Level-1 DFD of Online grocery shop 10
Figure 5: Architectural Design of online grocery shop 12
Figure 6: Database Schema Design of online grocery shop 13
Figure 7: Home page of online grocery page 14
Figure 8:Sign in page of online grocery page 14
Figure 9:register and signup page of online grocery shop 15
Figure 10: shop page of online grocery shop 15
Figure 11:Admin dashboard of online grocery shop 16
Figure 12:Context diagram of online grocery shop 17
Figure 13: 1st Level DFD of OGS 18

LIST OF FIGURES
 CHAPTER 1: INTRODUCTION`

1.1 Introduction
A grocery shop, also known as a supermarket or grocery store, is a retail establishment
that offers a broad range of food and household products essential for daily living. These
stores are often divided into various sections, each dedicated to specific categories such as
fresh produce, dairy, meats, bakery items, packaged goods, beverages, and cleaning
supplies. Customers can find everything from fruits, vegetables, and freshly baked bread
to frozen meals, canned goods, and personal care products. In addition to food, many
grocery shops also carry household essentials like detergents, paper products, and
toiletries, making them a one-stop shop for most of a household's needs.

1.2Problem Statement

Customers may feel overwhelmed by the vast number of product options available in
grocery stores, leading to frustration and indecision, as they struggle to make quick
purchasing decisions.

• The absence of an efficient admin login system hampers the store’s ability to manage
inventory and customer orders, making it difficult to optimize stock levels, oversee
delivery or pickup bookings, and ensure a smooth shopping experience.

• Shoppers may spend excessive time searching for specific products or deals, which can
negatively impact their overall shopping satisfaction and reduce the convenience of the
grocery shopping process.

• Customers may overlook essential items or promotions they would benefit from, as
these products may be buried among numerous other options, resulting in missed
opportunities for better choices and deals.

1.3Objectives

 To implement a personalized product recommendation system using collaborative

filtering based on user purchase history and preferences.
 • To provide an auto-suggestion feature using a trie data structure to help customers
quickly find grocery items as they type in the search bar.
• To ensure real-time inventory tracking and updates, informing customers of
product availability to avoid out-of-stock disappointments.
• To integrate secure payment gateways that support multiple payment methods,
ensuring safe and smooth transactions for users.

1.4Scope and Limitation

Scopes: a) The system will provide an admin login feature that allows administrators to
manage product inventory, update listings, and monitor customer orders.
b) The online grocery shop will offer a user-friendly and intuitive interface, enabling
customers to easily browse, search, and purchase grocery items.
c) The platform will implement a personalized product recommendation system based on
customer purchase history and preferences, enhancing the shopping experience.
d) The system will offer real-time inventory updates to inform customers of product
availability and prevent ordering out-of-stock items.
e) An auto-suggestion feature will assist users in quickly finding grocery items as they
type in the search bar.

Limitations: I. New customers with no purchase history may receive less accurate
product recommendations initially until the system gathers enough data on their
preferences.
II. Handling large amounts of real-time inventory data and high traffic during peak
shopping hours could cause occasional slowdowns in system performance.
III. The recommendation engine may become computationally intensive for very large
datasets, impacting the speed of generating personalized suggestions.
1.6 Development Methodology
The Online Grocery Shop is constructed using the Waterfall methodology, the process is
more structured and linear. Unlike the Agile model, which allows flexibility and iterative
development, the Waterfall model requires that each phase be completed before moving
on to the next. The project begins with thorough planning and gathering of requirements,
followed by a detailed design phase, where every aspect of the platform is mapped out.
After the design is finalized, the development team moves on to implementing the
platform's features, such as building the user interface, integrating payment systems, and
setting up the backend for inventory management.

1.7 Report Organization

Chapter 1: Introduction

This chapter introduces the concept of the online grocery shop, outlining its significance
in today’s digital world. It discusses the reasons for the rise of online grocery shopping,
including convenience, time-saving, and the increasing reliance on e-commerce
platforms. The chapter also highlights the key problems the system aims to solve, such as
the inefficiency of traditional grocery shopping, challenges in inventory management, and
the need for better customer experience in online shopping. Additionally, it outlines the
objectives of the project, the scope, and limitations of the system, and provides an
overview of what each subsequent chapter will cover.

Chapter 2: Background Study and Literature Review

This chapter reviews the existing literature on e-commerce and online grocery platforms.
It explores various aspects such as online shopping trends, customer behavior, and
challenges faced by online grocery shops, such as delivery logistics, inventory
management, and customer retention. It also examines relevant studies, technology
frameworks, and platforms used in the development of similar systems. The review
highlights the gaps in current systems and how the proposed online grocery shop aims to
address these challenges through innovative solutions, such as better search functionality,
personalized recommendations, and optimized delivery options.

2
Chapter 3: System Analysis and Design

In this chapter, the focus is on analyzing and detailing the requirements for the online
grocery shop. It explains the core features that must be included, such as product catalog,
shopping cart, user account management, secure payment systems, and delivery tracking.
It also explores additional features that can enhance the user experience, like product
search, recommendations, and subscription-based delivery options. The chapter presents
the system design, detailing the architecture, database structure, and how various
components interact, including front-end and back-end elements. It also covers user
interface design, ensuring that it is simple, intuitive, and responsive across devices.

Chapter 4: Implementation and Testing

This chapter discusses the actual development of the online grocery shop. It includes a
detailed explanation of the tools and technologies used, such as programming languages
(e.g., JavaScript, Python), frameworks (e.g., React, Django), and databases (e.g., MySQL,
MongoDB). The chapter also explains the implementation of key features, such as
shopping cart management, product filtering, user authentication, and payment
integration. Furthermore, it covers the testing phase, including unit testing, integration
testing, and user acceptance testing (UAT). The results from these tests are summarized,
highlighting any challenges encountered during implementation and how they were
resolved.

Chapter 5: Conclusion and Future Recommendations

The final chapter provides a summary of the findings from the development and
implementation of the online grocery shop. It evaluates the success of the system in
meeting the goals outlined in the introduction, such as improving shopping efficiency and
offering a smooth user experience. The chapter also highlights any limitations that were
encountered, such as scalability issues or challenges in managing large product catalogs.
Additionally, the chapter offers suggestions for future improvements and research, such
as integrating artificial intelligence for predictive inventory management, enhancing
customer personalization through data analysis, or exploring new delivery methods to
improve logistics.

3
4
 CHAPTER 2: ACKGROUND STUDY AND
LITERATURE REVIEW

2.1 Background Study

The study of existing online grocery shop systems reveals a variety of approaches
employed by leading platforms such as Amazon Fresh, Walmart Grocery, Instacart, and
Tesco. Each platform uses different strategies to optimize the shopping experience for
users. Amazon Fresh employs a combination of user data analytics and machine learning
algorithms to recommend products based on previous shopping behavior, dietary
preferences, and search history. Walmart Grocery focuses on enhancing user convenience
by offering a highly organized product catalog, personalized discounts, and integrating
local store inventory data to offer relevant recommendations. Instacart uses collaborative
filtering techniques to suggest products based on similarities in users' shopping patterns,
as well as personalized grocery lists tailored to individual tastes and preferences. Tesco's
online platform uses both machine learning and AI-powered recommendation engines,
considering factors like past purchases, seasonal trends, and real-time promotions to
optimize the shopping experience.

By examining these platforms, researchers can assess the strengths and weaknesses of
various recommendation and delivery systems. For example, while Amazon Fresh excels
in personalized product suggestions through detailed user behavior analysis, platforms
like Instacart and Walmart focus more on streamlining the shopping and delivery process.
Understanding these approaches helps inform the design and implementation of effective
strategies for building a comprehensive and user-friendly online grocery system,
enhancing customer satisfaction and operational efficiency.

2.2 Literature Review

To construct an efficient online grocery shop, it is essential to review various systems and
technologies that optimize user experience, inventory management, and logistics. One
crucial area of focus is recommendation algorithms, which help provide personalized
product suggestions based on user behavior and preferences. Collaborative filtering is a
popular technique used in online grocery systems to recommend products by analyzing
past user interactions and purchase history. In a study by Adomavicius and Tuzhilin

5
(2005), they discuss the role of collaborative filtering in personalizing product
recommendations, where users who show similar purchasing patterns are more likely to
receive the same product suggestions [1].

Additionally, content-based filtering techniques are also employed, particularly for

grocery items that may have clear attributes such as brand, category, or type of product. A
study by Ramaswamy et al. (2011) emphasizes the effectiveness of content-based filtering
in recommending products based on their characteristics like organic, gluten-free, or
dairy-free, aligning with users’ dietary preferences and health considerations [2]. This
method can be particularly useful for consumers with specific needs or preferences, such
as vegan or low-sugar items. Hybrid recommendation approaches, combining both
collaborative and content-based filtering, are increasingly being adopted by online
grocery shops to enhance the personalization of the shopping experience. A notable
example is the work by Burke (2002), who advocates for hybrid systems that integrate
multiple techniques to overcome the limitations of any single method. Such hybrid
systems can better capture user preferences by considering both the user’s past purchase
behavior and the inherent characteristics of products being sold, resulting in more
accurate and satisfying product recommendations [3].

Moreover, the use of machine learning models in online grocery platforms has gained
traction in recent years. For instance, recommender systems using clustering algorithms
or deep learning models, as discussed by Shankar et al. (2020), are applied to group
similar products or predict future buying behaviors, further refining the personalization of
shopping experiences [4]. These advanced technologies allow grocery platforms to adapt
and evolve based on customer preferences, leading to higher user engagement and
satisfaction.

By examining these systems, it becomes clear that a multifaceted approach combining

collaborative filtering, content-based filtering, and hybrid methodologies is essential for
constructing a robust and user-centered online grocery platform. These strategies allow
grocery platforms to provide tailored recommendations, improve user experience, and
enhance overall satisfaction, making them a key component in the competitive online
grocery shopping market.

6
 CHAPTER 3: SYSTEM DESIGN AND
ANALYSIS

3.1 System Analysis

System Analysis refers into the process of examining a system with the intent of
improving it through better procedures and methods. It is the process of planning a new
system to either replace or complement an existing system. It is therefore the process of
gathering and interpreting facts, diagnosing problems and using the information to
comment on improvements in the system.

3.1.1 Requirement Analysis

Functional Requirement

A functional requirement defines the specific functions of the system. The system
supports both admin and user roles. The functions required during the construction of the
online grocery shop application are as follows:

I. Admin Interface

 Admin Login and Logout system

 Admin can add, update, view, and delete products
 Admin can manage orders and update their status
 Admin can manage inventory and receive low-stock alerts

II. User Interface

 User can see all available products

 User Login and Logout system
 User can search, filter, and browse products
 User can get personalized product recommendations
 User can add products to the cart and proceed to checkout
 User can view order history and track current orders

7


figure 1 Use Case Diagram of online grocery

shop

Non-Functional Requirement
i. Performance Requirements

Speed is a key requirement to many systems. The focus is the website’s load time
should not be more than one second for users. The database shall be able to
accommodate the numerous records.

8
 ii. Safety Requirements

The database might crash at any certain time due to virus or external disturbance.

Therefore, it is necessary to backup database from time to time.

iii. Reliability

The website should offer high degree of reliability. Stable network connection should
be available all the time.

3.2 Feasibility Analysis

This study was undertaken to determine the possibility of either improving the
existing system or to develop a completely new system.

a) Technical Feasibility
For technical feasibility we made sure that the proposed system can be developed
using easily available tools and can be handled in a home environment. Each of
the equipment that we ought to use were affordable and are mostly free of cost.
Hence, we concluded that the system was technically feasible. Operational
Feasibility

For the operational feasibility we focused on the degree to which the proposed
development projects fits in with the existing environment. In this system, all the
features were implemented using its own database. Furthermore, this system were
compatible on all devices. Hence, this system was operationally feasible.

b) Economic Feasibility
The purpose of economic feasibility was to have an analysis of economic benefit
to the organization. Users only need internet facility to access the website. So, the
proposed project was economical and can serve user’s required purpose.

c) Schedule Feasibility
For the schedule feasibility we calculated the time that would be taken to develop
the software. We made sure that the system would be completed within six
months. The project’s tasks and milestones has been divided as shown in the
given figure below:

9
 3.2.1 Data Modeling (ER Diagram)

Figure 2: ER Diagram of OGS

3.2.2 Process Modeling (DFD)

In this level the whole system is defined as a single process and its relationship with
external entities.

10
In this DFD there are three main external entities:

● Customer

● Admin

Figure 3:Level-0 DFD of OGS

This level breaks the single process into multiple sub processes. The subprocess for
online grocery shop are as follows:

11
Figure 4: Level-1 DFD of OGS

12
System Design

3.2.3 Architectural Design

For Architectural design we focused on how different parts of a system
will work together, what they'll look like, and how they'll communicate.
We made sure that just like an architect plans rooms, doors, and windows
in a house, an architectural design plans components, connections, and
interactions in a computer system.

Figure 5: Architectural Design of OGS

13
3.2.4 Database Schema Design

Figure 6: Database Schema Design of OGS

14
3.2.5 Interface Design (UI/UX)

Figure 7: Home page of online grocery page

Figure 8: sign in page of online grocery shop

15
Figure 9: register and sign up page of online grocery shop

Figure 10: shop page of online grocery shop

16
 Figure 11: Admin Dashboard of online grocery shop

3.2.5 Physical DFD

Zero level DFD or Context diagram

It is a basic overview of the whole system or process being analyzed or modeled. It

is designed at a glance view of product; confirm order showing the system as a
single high-level process.

Figure 12: Context Diagram of OGS

First Level DFD (1st Level)

It shows how the system is divided into subsystems, each of which deals with one or
more of the data flows to or from an external agent and which together provide all
of the functionality of the system as a whole. DFD level 1 provides a more detailed
breakout of pieces of the zero level DFD where we will highlight the main
functionality of Online

17
Grocery shop

Figure 13:1st Level DFD of OGS

18
3.3 Algorithm Details
Content-Based Filtering Algorithm

A. Data Collection

 Collect Product Attributes:

o Gather data for each product available in the grocery shop, such as:
 Category (e.g., Fruits, Vegetables, Beverages, Dairy)
 Brand (e.g., Tropicana, Nestle, Dole)
 Price Range (e.g., Low, Medium, High)
 Product Type (e.g., Organic, Gluten-Free, Vegan)
 Nutritional Information (e.g., Low-fat, Sugar-free)
 User Interaction Data:
o Track user behavior such as:
 Products they viewed
 Products they added to their cart
 Products they purchased
 Search history or products they've shown interest in

B. Feature Extraction and Representation

 Vector Representation of Products:

o Represent each product as a vector of features. For example, a product
may be represented by a vector containing its category, brand, price range,
and other attributes. Each attribute can be numerically encoded, for
example:
 Category: Fruits → [1, 0, 0, 0]
 Brand: Tropicana → [1, 0, 0]
 Price Range: Medium → [0, 1, 0]
 Product Type: Organic → [1]

 User Profile Creation:

o Create a user profile based on their past interactions. This profile may be
a weighted sum of the products they interacted with, where the weights are

19
 determined by the importance of each feature (e.g., user purchases vs.
views).

C. Similarity Calculation

 Calculate Similarity Between Products:

o To recommend products, calculate the similarity between the target
product and all other products in the catalog using a similarity measure,
such as Cosine Similarity

Cosine Similarity Formula:

similarity(A,B)=A⋅B∣A∣⋅∣B∣\text{similarity}(A, B) = \frac{A \cdot B}{|A| \cdot |

B|}similarity(A,B)=∣A∣⋅∣B∣A⋅B

Where:

o AAA and BBB are the feature vectors of two products.

o A⋅BA \cdot BA⋅B is the dot product of vectors AAA and BBB.
o ∣A∣|A|∣A∣ and ∣B∣|B|∣B∣ are the magnitudes (norms) of the vectors.

 Compute Similarity:
o For each product a user has interacted with (viewed, added to cart, or
purchased), compute the similarity with other products in the catalog.
Products with higher similarity scores are more likely to be recommended.

20
 CHAPTER 4: IMPLEMENTATION AND TESTING

4.1 Implementation

System implementation is the most crucial phase in any project. During this phase,
designed documents were used to produce code to make the system functional. Efforts
have been made to ensure that the system is simple and user-friendly. For this project,
HTML, CSS, PHP, and MySQL were used to develop the online grocery store.

4.1.1 Tools Used (CASE Tools, Programming Languages, Database Platforms)

The Online Grocery Store is a web-based application designed and developed using the
following technologies:

 HTML and CSS: Utilized to create the front-end user interface.

 PHP: Used to build the back-end, enabling server-side functionality, such as
processing orders and managing users.
 MySQL: Employed to store all information related to products, orders, and user
data.

Technologies in Detail:

 Front-end (HTML, CSS):

o Designed the structure and layout of the website.
o Added responsive design features to ensure compatibility across devices.
 Back-end (PHP):
o Implemented logic for handling product management, order processing,
and user authentication.
o Ensured secure communication between the client-side and the database.
 Database (MySQL):

21
 o Used for storing product details, user accounts, orders, and inventory.

4.1.2 Implementation Details of Modules

The system comprises two main functional modules: Admin Module and User Module.

Admin Module

The Admin Module handles administrative tasks and includes the following
functionalities:

1. Product Management:
o Add, edit, delete, and view product information, including name, price,
category and images.
2. Order Management:
o View all user orders and update their statuses (e.g., pending, shipped,
delivered).
3. User Management:
o Manage user accounts by viewing or updating user details and activity.

User Module

The User Module focuses on user interaction and includes:

1. Product Browsing and Search:

o Allows users to search for products by name, category, or price.
2. Cart Management:
o Enables users to add or remove items from the cart and view the total cost.
3. Order Placement:
o Users can proceed to checkout, provide delivery details, and confirm their
orders.
4. Order History:
o Displays a list of previous orders with their statuses.
5. User Authentication:

22
4.2 Testing

Testing of the online grocery shop system was conducted to ensure it met the project
requirements and functioned as intended. The purpose of testing was to identify errors
and ensure all modules performed as expected. The tests conducted are detailed below:

4.2.1 Test Cases for Unit Testing

In unit testing, individual modules were tested to verify their functionality. Below are the
test cases used for unit testing:

Login Test Cases

Test Case Input Expected Outcomes

Valid Credentials Username: valid_user, Successful login and

Password: valid_password redirection to the
dashboard.
Invalid Credentials Username: invalid_user, Login failure with an error
Password: wrong_password message: "Invalid
username or password."
Non-existent Account Username: Failure with an error
nonexistent_user message: "Account not
found."

Product search case

Test case Input Expected Outcomes

Valid Search Query Search Term: Rice Display of all products

matching the term "Rice."

Invalid Search Query Search Term: Message: "No products

NonExistentProduct found."

23
Empty Search Query Search Term: "" Display of all available
products.

Add To Cart Test Case

Test Case Input Expected Outcomes

Valid Product Addition Product ID: 101, Quantity: Product added to the cart
2 successfully.

Exceeding Stock Quantity Product ID: 102, Quantity: Failure message: "Not
1000 enough stock available."

Invalid Product ID Product ID: 9999 Failure message: "Product

not found."

Rating test case

Test Case Input Expected Output

Successful rating username: valid_user, rating successful

Password:
valid_password,rating:4

Invalid Star Rating Username: valid_user,

Password: valid_password, Failure message saying invalid
Movie: "Inception", Stars: 6 rating

24
 4.2.2 Test Cases for System Testing
In system testing, we check if the system works seamlessly after combining all the
modules. Various verifications ensure the system meets specifications and objectives.
When the final model was tested, the output met the expected requirements.

Test case Objectives steps Expected results

User Ensure users can 1. Navigate to the User account is

Registration register registration page. created, and a

successfully. 2. Fill in the success message is
required fields displayed.
(e.g., name, email,
password).
3. Click the
"Register" button

User Login Verify users can log 1. Go to the login User is redirected to
in to their account. page. the home page with
2. Enter valid a personalized
credentials. greeting or
3. Click the dashboard.
"Login" button.

View Products Ensure users can 1Login. A list of grocery

view a list of 2.Navigate to the items is displayed
available grocery product listing with relevant details
items. page. (name, price,
3. Browse the availability, etc.).
available items.

Add Item to Cart users can add items 1. Select an item The item is added to
to their shopping from the product the cart, and a
cart. list. confirmation

25
 2. Click "Add to message is
Cart." displayed.
3. Verify if the item
is added.

View cart Ensure users can 1. Navigate to the A list of all added
view items added to cart page. items with their
their cart. 2. Verify the list of quantities, prices,
items added. and total cost is
displayed.

Remove Item Verify users can 1. Go to the cart The item is

remove items from page. removed from the
the cart. 2. Click the cart, and the total
"Remove" button price is updated
next to an item. accordingly.
3. Confirm the
removal.

Make Payment Ensure users can 1. Proceed to the Payment is

complete the checkout page. successfully
checkout process. 2. Enter payment processed, and an
details. order confirmation
3. Click "Pay message with
Now." details is displayed.

Admin Login Verify admin can 1. Navigate to the Admin is redirected to

log in to the admin login page. the dashboard with
dashboard. 2. Enter valid admin-specific
admin credentials. controls.
3. Click "Login."

View Products Ensure admins can 1. Log in to the A list of all products is
(Admin) view the list of admin dashboard. displayed with options
grocery items. 2. Navigate to the to edit or delete.
"Manage Products"

26
 section.

Edit Product Verify admins can 1. Select a product. Changes are saved,
edit product 2. Click "Edit" and and the product list is
details. modify fields (e.g., updated with the new
price, stock). details.
3. Save changes.

View Orders Ensure admins can 1. Go to the "View A list of orders is

view all customer Orders" section. displayed with
orders. 2. Browse the list relevant details (order
of orders with ID, items, total cost,
customer details. customer name, status,
etc.).

Handle Payments Verify admins can 1. Navigate to the Payment records are
view payment "Payments" displayed with details
statuses. section. (order ID, amount,
2. Check payment status, payment
records linked to method, etc.).
orders.

Error Handling Verify the system 1. Attempt an Appropriate error

handles invalid invalid action (e.g., messages are
inputs gracefully. submit empty displayed, and invalid
forms, enter invalid submissions/actions
payment details). are prevented.
2. Verify system
response.

27
 CHAPTER 5: CONCLUSION AND FUTURE
RECOMMENDATION

5.1 Learn / Outcome

● A project should be completed on given deadline so that customer will
be happy to give a positive response.
● Testing and verification should be done very carefully as it is also the
most important phase of any project.
● Users often think of new ways to improve the products. After all, they
are the ones using them. Therefore, it's wise to continuously reach out
to them to understand their needs and requirements.

5.2 Conclusion
To conclude, this project is very flexible and user-friendly. Most of the requirements have
been fulfilled up to the mark and the requirements which have been remaining, can be
completed with a short extension. This project is developed using MySQL, php1,
HTML,& CSS. The website was tested thus providing maximum load to the server and
was found working fast and effective.

5.3 Future Recommendation

We have designed the online grocery shopping platform to be adaptable for future
enhancements and evolving requirements. The development process followed standard
software development methodologies to ensure scalability and maintainability. Some of
the future recommendations include:

 Addition of New Features: The platform can be extended with advanced

functionalities such as voice search, augmented reality for product visualization,
or health-focused recommendations.
 Multilingual Support: Multilingual capabilities can be added to cater to a
broader audience and improve accessibility for users speaking different languages.
 Integration of AI and Machine Learning: Implementing AI for personalized
product recommendations and demand forecasting can enhance the user
experience and optimize inventory management.

28
 Improved Delivery Systems: Features like drone or autonomous vehicle
deliveries can be integrated to improve efficiency and expand delivery coverage.

29
 APPENDICES
 Frontend overview

Home page

Product page

30
Register page

31
Admin Login page

Admin Dashboard

32
33
 REFERENCES

[1] Mero Kirana. (n.d.). Online grocery shopping in Nepal - Groceries, baby & more. Retrieved
from [https://merokirana.com](https://merokirana.com).

[2] Salesberry. (n.d.). Online shopping in Nepal. Retrieved from

[https://www.salesberry.com.np](https://www.salesberry.com.np).

[3] Daraz dMart. (2023). Grocery shopping in Nepal. Retrieved from

[https://www.daraz.com.np](https://www.daraz.com.np).

[4] Rasan Mart. (n.d.). Online store for groceries and essentials in Nepal. Retrieved from
[https://www.rasanmart.com](https://www.rasanmart.com).

[5] Walmart. (n.d.). Walmart Grocery Delivery & Pickup. Retrieved from
https://www.walmart.com/grocery.