KENDRIYA VIDYALAYA

NEW BONGAIGAON

COMPUTER SCIENCE
PROJECT WORK

“SHOP MANAGEMENT
SOFTWARE”
 By:-
TUSAR JHA
“XII-A”
 Certificate
This is to certify that the Project / Dissertation entitled
Shop Mangement System is a bonafide work done by
TUSAR JHA of class XII Session 2024-25 in partial
fulfillment of CBSE’s AISSCE Examination 2025 and has
been carried out under my direct supervision and
guidance. This report or a similar report on the topic has
not been submitted for any other examination and does not
form a part of any other course undergone by the
candidate.

Signature of Student Signature of Teacher

Name: Tusar Jha Name: Mr. Amit kumar pandey sir
Cbse Roll No: Designation: PGT(Comp.Sc.)
 ACKNOWLEDGEMENT
I undertook this Project work, as the part of my XII-
Computer science course. I had tried to apply my best of
knowledge and experience, gained during the study and
class work experience. However, developing software
system is generally a quite complex and time-consuming
process. It requires a systematic study, insight vision and
professional approach during the design and development.
Moreover, the developer always feels the need, the help
and good wishes of the people near you, who have
considerable experience and idea.

I would like to extend my sincere thanks and gratitude to

my teacher Mr. Amit kumar pandey. I am very much
thankful to our Principal Mr. Vishal Khare for giving valuable
time and moral support to develop this software.

I would like to take the opportunity to extend my sincere

thanks and gratitude to my parents for being a source of
inspiration and providing time and freedom to develop this
software project.

I also feel indebted to my friends for the valuable

suggestions during the project work .

TUSAR JHA
Class XII --A
 CONTENTS
1. Introduction

2. Objective & Scope of the Project

3. Theoretical Background

4. System Implementation

4.1 The Hardware used

4.2 The Softwares used

5. System Design & Development

5.1 Software Code

5.2 Tables in SQL

5.3 Output of the code

6. References
 INTRODUCTION
Introduction to Shop Management System:-
The Shop Management System is a simple, efficient, and robust
solution designed to streamline of the management of shop
inventory and customer transactions. Developed using Python
and MySQL, this system operates via the command line interface
(CLI) and is divided into two main sections: Admin and Customer.

In the Admin section, the system offers a range of functionalities,

allowing the administrator to manage inventory, including adding
new items, updating prices, and deleting obsolete products.
Additionally, the admin can view a general ledger, which provides
a summary of all transactions, and change the system's password
for enhanced security.

For customers, the system facilitates browsing the available items,

making it easy to view the products on sale. Customers can also
purchase their desired item and pay the cash as amount.
However, this project does not include a direct shopping cart or
payment feature, focusing primarily on inventory and transaction
management for administrative use.

This system leverages Python for back-end logic and MySQL for
database management, ensuring seamless and efficient data
storage, retrieval, and manipulation. The project is designed to be
lightweight and easy to use, making it an ideal tool for small-scale
shops and businesses that seek to automate basic shop
management tasks without the complexity of a graphical user
interface.
Objective of the Project

The primary objective of the Shop Management System is to provide a

streamlined, efficient, and automated approach to managing shop
inventories and customer transactions. The system is designed to help
shop administrators easily control inventory items, update product prices,
and track financial transactions without the need for a complex graphical
user interface. The key objectives of this project include:

1. Efficient Inventory Management: Allow the administrator to add new

items, update product prices, delete items, and display a list of all
available products in the shop.
2. Transaction and Financial Management: Provide the administrator
with a general ledger to keep track of all transactions and item
movements.
3. User Authentication: Ensure secure access for the admin by
implementing a password management feature.
4. Database Integration: Use MySQL for data storage, ensuring that all
items and transactions are stored securely and can be easily retrieved or
modified.
5. Simple and Intuitive Operation: Provide a command-line interface
that allows easy navigation for both admin and customers, making the
system user-friendly.
Scope of the Project
The scope of the *Shop Management System* is designed to meet the basic
needs of inventory and transaction management for small to medium-
sized shops. The system operates in two primary sections: Admin and
Customer.

1. Admin Features:
- Add Items: Admin can add new products to the inventory with details
such as name, price, and quantity.
- Update Prices: Admin can modify the price of existing products.
- Delete Items: Admin can remove obsolete or out-of-stock items from
the inventory.
- Display All Items: Admin can view a complete list of all items in the
store.
- View General Ledger: Admin can generate a report of all transactions
to review financial activity.
- Change Password: Admin can change the system’s password for
security purposes.

2. Customer Features:
- View Items: Customers can browse a list of available products, but
they do not have the ability to modify inventory or make purchases in this
version of the system.
- Add items to bucket: Customers can add their desired items to the
bucket or cart from where they can purchase all their desired item at
once.
- View the items in Bucket: Customers can verify all the items they added
to their bucket.
3. Technology Stack:
- Backend: Python for the business logic and user interaction.
- Database: MySQL for storing item data, transaction records, and other
relevant information.
4. Limitations:
- No Graphical User Interface (GUI): The system does not have a GUI,
and interaction is done through a command-line interface.
- No Direct Purchasing System: While the system supports viewing
items, it does not have an integrated shopping cart or payment system.
- Limited User Roles: The system has only two user roles: Admin and
Customer, with restricted functionality for the customer.

The scope is focused on the administrative management of shop

inventories, ensuring that it provides a functional and reliable solution for
basic shop operations while leaving room for future enhancements, such
as adding a GUI or a customer-facing purchasing system.
Theoretical Background
The Shop Management System is built on the foundation of several core
concepts and technologies that are essential for modern inventory and
transaction management systems. The theoretical background of this
project involves understanding key areas such as database management,
user authentication, inventory management, and programming
fundamentals.

### 1. Inventory Management Systems

Inventory management refers to the process of efficiently overseeing the

constant flow of goods into and out of a business. The primary goal of an
inventory management system is to ensure that the right quantity of
products is available at the right time to meet customer demand while
minimizing excess stock that could lead to waste or unnecessary storage
costs.

- Key Functions of Inventory Management:

- Stock Control: Keeping track of product quantities in stock, including
incoming and outgoing items.
- Product Updates: Maintaining accurate product information, including
prices, descriptions, and stock levels.
- Reporting: Providing real-time reports and analytics regarding stock
levels, product sales, and transactions.

The Shop Management System allows the admin to add, delete, and
update items, which are fundamental operations in inventory
management. It also includes the ability to view the entire inventory,
which is essential for tracking available stock.

### 2. Database Management Systems (DBMS)

- SQL (Structured Query Language): SQL is the standard language for

interacting with relational databases. It allows the system to execute
queries to add, update, delete, and retrieve data from the database.

In the context of the Shop Management System, the database is used to

store critical information such as:
 - Product Information: Item names, prices, quantities, etc.
- Transaction Records: Sales transactions, product updates, and changes
in inventory.
- User Authentication Data: Admin login credentials, including
passwords.

### 3. User Authentication and Security

Since the Shop Management System is designed with an administrative

section that involves managing sensitive data, *user authentication* is a
crucial aspect. Authentication ensures that only authorized users, such as
the admin, can perform tasks like updating inventory, changing prices, or
viewing financial records.

- Password Management: The admin’s password is stored securely, and

the system allows the admin to change it when needed. This ensures that
unauthorized users cannot access the system or make changes to the
inventory and transaction data.

- Security Concerns: The system uses basic text-based authentication

methods (i.e., matching input passwords with stored ones), but in real-
world applications, more advanced encryption methods (such as hashing)
would be used to further secure user data.

### 4. Object-Oriented Programming (OOP)

The Python programming language is used for the backend logic of the
system. Python is well-suited for developing both simple and complex
applications due to its readability, ease of use, and extensive support for
libraries. In this system, Object-Oriented Programming (OOP) principles
are employed to organize the code and ensure maintainability.

- Classes and Objects: The system can be divided into different classes,
such as Item for managing inventory items and Admin for handling
administrative functions. These classes allow for the encapsulation of data
and functions that are related to specific tasks.

- Methods and Functions: Various functions are defined within these

classes to perform tasks like adding new items, updating prices, and
retrieving item lists.
### 5. General Ledger and Financial Management

A general ledger is a comprehensive record of all the financial

transactions within a business. In the context of the Shop Management
System, the general ledger feature helps the admin track all item
transactions, providing insights into the flow of goods and the financial
health of the shop.

- Transaction Tracking: Each time an item is added, updated, or deleted, it

is recorded in the general ledger, providing a historical record of all
changes made to the inventory and prices.
- Reporting: Admins can use the ledger to generate reports, allowing for
better decision-making and understanding of business performance.

### 6. Command-Line Interface (CLI)

Since this Shop Management System does not feature a graphical user
interface (GUI), the interaction is performed through a Command-Line
Interface (CLI). CLI is a text-based interface that allows users to type
commands to perform specific tasks, making it efficient for managing data
in systems where a GUI is unnecessary or too complex.

- Advantages of CLI:
- Simplicity and low system resource usage.
- Faster for experienced users who are familiar with the commands.
- Ideal for automated tasks and background operations.

### 7. Python Programming Language

Python was chosen for the development of the system due to its flexibility,
ease of integration with MySQL, and vast standard library. Python’s
simplicity allows for quick development, while its support for external
libraries such as mysql-connector makes it easy to connect and interact
with the MySQL database.

- Benefits of Python:
- Readable Syntax: Python’s clean syntax makes it easy to understand
and write code, which helps during development and maintenance.
- Cross-Platform: Python can be used across various operating systems,
making the system portable.
- Large Support Community: Python’s extensive community and libraries
ensure that problems can be solved efficiently.
### Conclusion

The Shop Management System incorporates key theoretical concepts from

fields such as inventory management, database management, user
authentication, and object-oriented programming. By integrating these
principles with Python and MySQL, the system offers an efficient, secure,
and scalable solution for managing shop inventories and transactions.
While the system is designed to be simple and command-line based, it
serves as a foundation for more complex systems with additional features
like GUIs and integrated e-commerce functionalities in the future.
 SYSTEM IMPLEMENTATION

The Hardware used:

While developing the system, the used hardware are:

PC with Intel i5 Penta Core processor having 16.00 GB RAM, SVGA and other required
devices.

The Softwares used:

• Microsoft Windows® 11 as Operating System.

• Python 3.13 as Front-end Development environment.

• MySQL as Back-end Sever with Database for Testing.

• MS-Word home and student 2019 for documentation.

SOFTWARE CODE:-
TABLES IN MY SQL:-

1}Login:-

2}Purchase:-

3}Stock:-
Output of the program:-
References

In order to work on this project titled –Shop management system, the following
books and literature are refered by me during the various phases of development of
the project.

(1) The Complete Reference python

-by Shildit
2. MySQL, Black Book

-by Steven Holzner

(2) Understanding SQL
– Gruber
(3) http://www.mysql.org/

(4) Course Book for class XII

(5) Various Websites of Discussion Forum and software development activities.

Other than the above-mentioned books, the suggestions and supervision of my teacher
and my class experience also helped me to develop this software project.