PROJECT ON SHOP MANAGEMENT SYSTEM
ACKNOWLEDGEMENT
I express my sincere gratitude to my Computer Science teacher for guiding me through the
completion of this project. I also thank my school principal and my friends for their
continuous support and encouragement. This project, “Shop Management System,” has
helped me understand the real-world application of Python programming and MySQL
database connectivity in automating business processes.
INTRODUCTION
The Shop Management System is a computerized system developed using Python as the
front end and MySQL as the backend. It helps shopkeepers or administrators manage sales,
purchase records, and stock efficiently. The system maintains all essential details like
product names, prices, quantity, supplier details, and customer bills. Manual billing and
inventory management are time-consuming and prone to human errors; hence, automation
is essential for accuracy and time efficiency.
OBJECTIVES OF THE PROJECT
1. To automate shop operations such as billing and stock management.
2. To develop an easy-to-use interface for storing, updating, and retrieving data.
3. To reduce paperwork and manual errors in maintaining sales records.
4. To demonstrate Python–MySQL connectivity for data handling.
5. To help understand real-world software development cycles.
PROPOSED SYSTEM
In traditional shops, all records are maintained manually in registers. This leads to time
wastage, calculation mistakes, and difficulty in searching past transactions. The proposed
Shop Management System overcomes these issues by maintaining data digitally. Whenever
a product is sold, the system updates the stock automatically. Shop owners can view
product details, check low-stock items, and print bills.
Advantages:
- Accurate stock management
- Easy billing
- Faster report generation
- Data security and easy backup
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
The SDLC includes the following phases:
1. Initiation Phase
2. System Concept Development Phase
3. Planning Phase
4. Requirements Analysis Phase
5. Design Phase
6. Development Phase
7. Testing Phase
8. Implementation Phase
9. Maintenance Phase
FLOW CHARTS
Login Flow:
Start → Enter Username/Password → Validate → Main Menu → End
Product Management Flow:
Start → Display Menu → Perform Selected Action → Commit Changes → End
SOURCE CODE (Python + MySQL)
import [Link] as sql
conn = [Link](host='localhost', user='root', passwd='password', database='shopdb')
c1 = [Link]()
print("WELCOME TO SHOP MANAGEMENT SYSTEM")
user = input("Enter Username: ")
pswd = input("Enter Password: ")
if user == "admin" and pswd == "admin123":
print("\nLogin Successful!\n")
while True:
print("1. Add Product")
print("2. View Products")
print("3. Update Stock")
print("4. Delete Product")
print("5. Exit")
ch = int(input("Enter your choice: "))
if ch == 1:
pid = input("Product ID: ")
name = input("Product Name: ")
qty = int(input("Quantity: "))
price = float(input("Price per unit: "))
[Link]("insert into products values(%s,%s,%s,%s)", (pid, name, qty, price))
[Link]()
print("Product added successfully!\n")
elif ch == 2:
[Link]("select * from products")
data = [Link]()
print("\n--- Product List ---")
for i in data:
print(i)
elif ch == 3:
pid = input("Enter Product ID to update: ")
new_qty = int(input("Enter new quantity: "))
[Link]("update products set quantity=%s where product_id=%s", (new_qty, pid))
[Link]()
print("Stock updated successfully!\n")
elif ch == 4:
pid = input("Enter Product ID to delete: ")
[Link]("delete from products where product_id=%s", (pid,))
[Link]()
print("Product deleted!\n")
elif ch == 5:
print("Exiting System... Thank You!")
break
else:
print("Invalid Choice, Try Again.")
else:
print("Login Failed! Please check credentials.")
OUTPUT
Example output:
Login Successful → Add/View/Update/Delete Products
Products displayed from MySQL database.
TESTING
Testing ensures that each function performs correctly.
Testing Methods Used:
- Black Box Testing
- White Box Testing
Result: All modules worked successfully.
HARDWARE REQUIREMENTS
Processor: Pentium or above
RAM: 512MB+
Hard Disk: 40GB+
Monitor, Keyboard, Mouse, Printer
SOFTWARE REQUIREMENTS
Operating System: Windows 7 or above
Python 3.x
MySQL Server
MySQL Connector for Python
Any IDE (IDLE, PyCharm, or VS Code)
BIBLIOGRAPHY
1. Computer Science with Python – Sumita Arora (Class XII)
2. [Link] / [Link] for Python and MySQL tutorials
3. Stack Overflow for debugging and query references