INTELLIGENT INVENTORY SYSTEM

Submitted by

SAKTHI MEERA S (95072517096)

In partial fulfilment for the award of

the degree of

BACHELOR OF TECHNOLOGY
in
ARTIFICIAL INTELLIGENCE AND DATA SCIENCE

FRANCIS XAVIER ENGINEERING COLLEGE

(Autonomous)
TIRUNELVELI–627003

MAY 2026
 TABLE OF CONTENTS

[Link] TITLE PAGE NO

1. PROBLEM STATEMENT 1

2. ABSTRACT 2

3. OBJECTIVE 3

4. INTRODUCTION 4

5. FLOWCHART 5

6. LIST OF MODULES 6

7. SAMPLE CODE 7

8. RESULTS 12

9. CONCLUSION 15
 PROBLEM STATEMENT

Inventory management is a critical aspect of any business or organization, yet

many small-scale enterprises and individuals still rely on manual methods such as notebooks
or spreadsheets to track their stock. These traditional methods are prone to errors such as
incorrect entries, data loss, duplication, and difficulty in retrieving information quickly.
Additionally, manual systems do not provide real-time updates, making it challenging to
monitor stock levels accurately or identify shortages before they become critical.

Another major issue is the lack of automated alerts for low stock, which can
lead to overstocking or understocking, ultimately affecting business operations and
profitability. Furthermore, manual systems do not support efficient searching, updating, or
deleting of product records, resulting in wasted time and effort. There is a need for a simple,
efficient, and intelligent system that can automate these processes, reduce human intervention,
and provide reliable data management.

The Intelligent Inventory System is designed to address these problems by

offering a structured, automated solution that ensures accuracy, efficiency, and ease of use. In
addition to these challenges, manual inventory systems often lack proper security and backup
mechanisms, increasing the risk of data loss due to unforeseen circumstances. They also fail
to provide meaningful insights or analytics that can help in decision-making and future
planning. As businesses grow, managing inventory manually becomes increasingly complex
and time-consuming, leading to inefficiencies and reduced productivity.

The absence of integration with modern technologies further limits the scalability
of such systems. Therefore, there is a strong need for a computerized solution that not only
manages inventory effectively but also supports future expansion and intelligent decision-
making.
 ABSTRACT

The Intelligent Inventory System is a comprehensive software solution

developed using Python to address the growing need for efficient and automated inventory
management in modern organizations. Inventory control is a critical component of business
operations, as it directly impacts productivity, cost management, and customer satisfaction.
Traditional inventory management methods, which often rely on manual record-keeping or
basic spreadsheet tools, are prone to errors, inefficiencies, and lack of real-time updates.

This project introduces an intelligent and automated system that simplifies the
process of managing inventory by providing a structured and user-friendly interface for
handling product information. The system enables users to add, update, delete, and search for
products while maintaining accurate records in a database. One of the key features of this
system is its ability to generate low-stock alerts, ensuring that users are informed when
inventory levels fall below a specified threshold. This helps prevent stock shortages and
ensures smooth business operations.

Additionally, the system supports data persistence through the use of SQLite,
allowing users to store and retrieve information efficiently. The Intelligent Inventory System
demonstrates how programming and database technologies can be integrated to create a
reliable and scalable solution. It is particularly useful for small and medium-sized enterprises
that require a cost-effective inventory management tool. Overall, this project highlights the
importance of automation in reducing human effort, minimizing errors, and improving
decision-making capabilities in inventory management
 OBJECTIVE

The primary objective of the Intelligent Inventory System is to design and

develop a robust and efficient application that automates the process of inventory management
using Python programming. The system aims to eliminate the limitations of manual inventory
handling by providing a structured and organized approach to storing and managing product
data. One of the key objectives is to ensure accurate and real-time tracking of inventory levels,
enabling users to monitor stock availability and make informed decisions.

The project also aims to implement essential functionalities such as adding new
products, updating existing records, deleting unnecessary entries, and searching for specific
items based on user input. Another important objective is to incorporate intelligent features
such as low-stock alerts, which notify users when the quantity of a product falls below a
predefined threshold. This helps in maintaining optimal stock levels and preventing
disruptions in business operations.

Additionally, the system aims to provide a user-friendly interface that can be easily
understood and used by individuals with minimal technical knowledge. The use of a database
system ensures data persistence, security, and efficient retrieval of information. The project
also focuses on scalability, allowing future enhancements such as graphical user interfaces,
cloud integration, and advanced analytics. Overall, the objective of this project is to create a
reliable, efficient, and intelligent inventory management solution that improves productivity
and reduces manual effort.
 INTRODUCTION

In the modern business environment, efficient inventory management is essential

for ensuring smooth operations and maintaining customer satisfaction. Inventory refers to the
goods and materials that a business holds for the purpose of resale or production. Managing
inventory effectively involves tracking stock levels, maintaining accurate records, and
ensuring that products are available when needed. Traditional methods of inventory
management, such as manual record-keeping, are often inefficient and prone to errors.

With the advancement of technology, there is a growing need for automated

systems that can handle inventory management tasks more effectively. The Intelligent
Inventory System is a Python-based application designed to address these challenges by
providing a digital solution for managing inventory. This system utilizes a database to store
product information, ensuring data consistency and reliability. Users can perform various
operations such as adding new products, updating existing records, deleting items, and
searching for specific products.

One of the key features of the system is its ability to generate low-stock alerts,
which helps users maintain optimal inventory levels and avoid shortages. The system is
designed to be simple and user-friendly, making it accessible to a wide range of users. By
automating repetitive tasks and providing real-time insights, the Intelligent Inventory System
enhances efficiency and reduces the chances of errors. This project demonstrates how
programming and database technologies can be combined to create a practical solution for
real-world problems.
 FLOWCHART

Start

Initialize empty product list

User enters choice

Store product in list

Display "Product added successfully"

End
 LIST OF MODULES
1. Database Module
This module is responsible for creating and managing the database using
SQLite. It handles the storage of all product-related information such as
product ID, name, quantity, and price. It ensures data is stored permanently
and can be retrieved whenever required.

2. Product Management Module

This module includes functions to add, update, and delete product records. It
allows users to maintain accurate and up-to-date inventory information by
modifying product details as needed.

3. Display Module
The display module is used to fetch and present all product data from the
database in a readable format. It helps users view the complete inventory list
clearly.

4. Search Module
This module allows users to search for specific products using keywords
such as product name or ID. It improves efficiency by quickly locating
required items.

5. Low Stock Alert Module

This module checks product quantities against a defined threshold and
displays items that are running low. It helps users take timely action to
restock products.

6. User Interface Module

This module provides a menu-driven interface through which users interact
with the system. It handles user input and directs operations based on user
choices.
 SAMPLE CODE
products = []

def add_product():

print("\n--- Add Product ---")

name = input("Enter product name: ")

category = input("Enter category (Stationary/Fruits/Vegetables/Medicine): ")

quantity = float(input("Enter quantity: "))

unit = input("Enter unit (nos/kg/liters): ")

price = float(input("Enter price: "))

product = [name, category, quantity, unit, price]

[Link](product)

print("Product added successfully.\n")

def view_products():

print("\n--- View Products ---")

if len(products) == 0:

print("No products available.\n")

else:

for i in range(len(products)):

p = products[i]

print("ID:", i,

"| Name:", p[0],

"| Category:", p[1],

 "| Quantity:", str(p[2]) + " " + p[3],

"| Price:", p[4])

print()

def search_product():

print("\n--- Search Product ---")

name = input("Enter product name to search: ")

found = False

for p in products:

if p[0].lower() == [Link]():

print("Product found:",

"| Name:", p[0],

"| Category:", p[1],

"| Quantity:", str(p[2]) + " " + p[3],

"| Price:", p[4])

found = True

if not found:

print("Product not found.\n")

else:

print()

def update_product():

print("\n--- Update Product ---")

view_products()
 if len(products) == 0:

return

index = int(input("Enter product ID to update: "))

if index < len(products):

print("Enter new details:")

name = input("New name: ")

category = input("New category: ")

quantity = float(input("New quantity: "))

unit = input("New unit (nos/kg/liters): ")

price = float(input("New price: "))

products[index] = [name, category, quantity, unit, price]

print(" Product updated successfully!\n")

else:

print("Invalid ID.\n")

def delete_product():

print("\n--- Delete Product ---")

view_products()

if len(products) == 0:

return

index = int(input("Enter product ID to delete: "))

if index < len(products):

deleted = [Link](index)
 print(" Product deleted:", deleted, "\n")

else:

print("Invalid ID.\n")

def low_stock():

print("\n--- Low Stock Check ---")

limit = float(input("Enter stock limit: "))

found = False

for p in products:

if p[2] <= limit:

print("Low Stock:",

"| Name:", p[0],

"| Quantity:", str(p[2]) + " " + p[3])

found = True

if not found:

print("No low stock items.\n")

else:

print()

while True:

print("====== Intelligent Inventory System ======")

print("1. Add Product")

print("2. View Products")

print("3. Search Product")

print("4. Update Product")

print("5. Delete Product")

print("6. Low Stock Alert")

print("7. Exit")

choice = input("Enter your choice: ")

if choice == '1':

add_product()

elif choice == '2':

view_products()

elif choice == '3':

search_product()

elif choice == '4':

update_product()

elif choice == '5':

delete_product()

elif choice == '6':

low_stock()

elif choice == '7':

print("Code exited successfully!")

break

else:

print("Invalid choice! Try again.\n"

RESULTS
 CONCLUSION

The Intelligent Inventory System is a successful implementation of

an automated solution for managing inventory using Python and database
technologies. The project effectively addresses the challenges associated with
traditional inventory management methods, such as data inaccuracies, lack of real-
time updates, and inefficient record-keeping. By providing a structured and user-
friendly platform, the system simplifies the process of managing product
information and ensures accurate data handling.
The inclusion of intelligent features such as low-stock alerts
enhances the functionality of the system and supports better decision-making. The
use of SQLite ensures data persistence and security, making the system reliable
for long-term use. This project demonstrates the importance of automation in
improving efficiency, reducing human errors, and enhancing productivity.
Although the current system is designed as a basic application, it provides a strong
foundation for future enhancements such as graphical user interfaces, web-based
platforms, and advanced data analytics.
In conclusion, the Intelligent Inventory System is a valuable tool for
inventory management and highlights the potential of technology in solving real-
world problems. It serves as an excellent example of how programming skills can
be applied to develop practical and effective solutions for everyday challenges.