INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1089

A Full-Stack Web Solution for Online FMCG (Fast-Moving

Consumer Goods) Management System Using MERN: Design,

Implementation and Evaluation

Harsh Mittal, Dr. Manju Arora

includes modules for real-time stock updates, automated billing, online payment integration, and dynamic reporting dashboards.

With features such as low-stock alerts, and product categorization, the system aims to enhance operational efficiency and reduce

manual effort. Additionally, it supports multi-user roles with secure access control, allowing admins, staff, and suppliers to interact

with the system according to their privileges. By leveraging modern web technologies and cloud-based architecture, the application

ensures high availability, scalability, and data integrity. This solution caters to the needs of retailers, wholesalers, and distributors,

making the management of FMCG products more organized, accessible, and efficient.

Keywords: FMCG Management, Inventory System, Online Billing, Retail Operations, Order Tracking, Web-based FMCG

Software.

I. Introduction

In today's fast-paced and digitally driven marketplace, the need for efficient and intelligent systems to manage retail operations has

dashboards help businesses identify trends, peak sales hours, and best-selling products, facilitating data-driven decision-making.

By leveraging modern technologies such as React.js for the frontend, Node.js/Express for backend services, Tailwind CSS for

responsive design, and cloud-hosted databases like MongoDB or Firebase, the platform ensures high performance, scalability, and

user-friendliness.

Ultimately, this project aims to bridge the gap between traditional retail methods and modern digital solutions. It empowers FMCG

businesses—whether small shops, supermarkets, or wholesale distributors—to operate more efficiently, respond to market demands

quickly, and deliver better service to their customers. In doing so, it lays the foundation for a smarter, more connected, and future-

ready retail ecosystem.

II. Literature Review

The integration of modern information systems and digital technologies into retail and supply chain operations has significantly

(JIT) inventory models and real-time data tracking frameworks, which emphasize minimizing stockholding costs while avoiding

product unavailability. By maintaining accurate stock records, issuing low-stock alerts, and enabling automated reordering, such

systems enhance inventory accuracy and ensure timely replenishment, as supported by findings in retail supply chain literature.

Web-based FMCG platforms benefit from advancements in cloud computing, which offer scalable, secure, and accessible

infrastructures for data storage and application deployment. Authors like Laudon and Laudon have emphasized the importance of

cloud integration in achieving operational efficiency, remote accessibility, and enhanced collaboration among various

INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1090

stakeholders—including retailers, suppliers, and distributors. Modern systems also incorporate online payment gateways (e.g.,

Razorpay, Stripe), automating the billing process and improving customer convenience, a trend supported by recent studies on the

digitalization of retail transactions.

III. Methodology

with modules for inventory, orders, and reports. The application observes key parameters such as stock levels, sales data, order

history, and payment statuses.

System Architecture & Core Components

The core of the system is divided into modular components, ensuring separation of concerns and easy maintainability.

Frontend (User Interface):

Built with React.js and styled using Tailwind CSS for a modern, responsive design.

Provides pages for inventory management, billing, customer/supplier data, and dashboard analytics.

Backend Services:

Developed using Node.js with Express.js, handling all API endpoints and business logic.

Connected to a NoSQL database like MongoDB (or optionally, a relational DB) to store all transactional and product data.

INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1091

Key Functional Modules

Inventory Management:

Add, update, delete products with price, stock level, and category.

Real-time stock tracking with low-stock alerts.

Billing System:

Dynamic billing interface allowing sselection of products, quantity, discounts, and tax calculations.

Auto-generation of invoices with customer details and multiple payment options.

Customer & Supplier Management:

Manage profiles, transaction history, and outstanding balances.

Auto Calculations: GST, subtotal, discounts, and totals are dynamically computed.

Role-Based Access: Separate dashboards and permissions for Admin, Staff, and Suppliers.

Search & Filter: Advanced search by name, category, or stock status to improve navigation.

Testing and Performance Tracking

INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1092

Functional Testing: Each module was tested using tools like Postman (for API) and browser testing (for UI/UX).

Performance Metrics: Monitored system response time, data retrieval efficiency, and billing processing speed.

Scalability Tests: Simulated bulk operations and concurrent users to validate performance under load.

Tools and Technologies Used

Frontend: React.js, Tailwind CSS

Backend: Node.js, Express.js

Database: MongoDB or Firebase

Online Orders to manage e-commerce transactions.

The interface is clean and user-friendly, displaying visually appealing category cards like Fresh Produce, Bakery, and Dairy

Products, making it easy for admins to manage different product types. Navigation links at the top also include access to Reports

and Profile Settings, with a clear Logout button for session control.

Figure 2 User DashBoard

INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1093

This is the User Dashboard of an Online FMCG Shopping Platform, designed for a seamless shopping experience. The interface

highlights a prominent banner with the message "Fresh Groceries – Shop the freshest produce", creating an inviting user

experience.

Users can:

Search for items using a central search bar.

View featured products like Mother Dairy Ghee, Butter, Amul Bread, and Amul Butter.

The layout is clean and visually engaging, with intuitive icons and a cart button for easy order management.

Limitations

The limitations for an FMCG (Fast-Moving Consumer Goods) application or environment could include:

Market Saturation: The FMCG sector is highly competitive, with many brands vying for market share. Over time, product

differentiation becomes harder, and market saturation can reduce profit margins.

Supply Chain Issues: Managing the supply chain effectively is critical for FMCG businesses. Any disruption (e.g., due to

geopolitical events, natural disasters, or transportation issues) can affect inventory and lead to stockouts or delays.

Consumer Behavior Variability: Consumer preferences in FMCG products can change rapidly, making it difficult for businesses

to predict demand. Shifts in consumer trends or behaviors can result in overstocking or understocking of certain products.

Short Product Lifecycles: Many FMCG products have very short lifecycles, requiring constant innovation and new product

development to maintain consumer interest. Failure to keep up with trends can result in lost sales.

performance and adaptability.

The application of AI in FMCG could lead to advancements in demand forecasting, personalized marketing strategies, and supply

chain management, but careful attention is needed to overcome issues like data overload, regulatory compliance, and the need for

constant innovation to keep pace with evolving consumer behavior. By focusing on scalability, sustainability, and data-driven

insights, FMCG companies can enhance their operations and remain competitive in a rapidly changing market.

INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,

MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)

ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue IV, April 2025

www.ijltemas.in Page 1094

Future work in the FMCG space should focus on optimizing these processes, leveraging AI to create more efficient systems, and

continuously adapting to market trends, ensuring better consumer satisfaction and sustained growth.

References

strategies for improvement. Business Strategy and the Environment, 25(6), 389-402. Link: Business Strategy and the

Environment