0% found this document useful (0 votes)
2 views24 pages

Bakery Management System Overview

The document outlines a Bakery Management System that includes functionalities for managing products, inventory, sales, and employees. Users can add, view, edit, and delete products and inventory items, as well as record sales and manage employee details. The system is implemented using Python and MySQL, with a simple menu-driven interface for user interaction.

Uploaded by

sanjayark076
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2 views24 pages

Bakery Management System Overview

The document outlines a Bakery Management System that includes functionalities for managing products, inventory, sales, and employees. Users can add, view, edit, and delete products and inventory items, as well as record sales and manage employee details. The system is implemented using Python and MySQL, with a simple menu-driven interface for user interaction.

Uploaded by

sanjayark076
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

kkmkmkmkmmmmmmmmmmmmmmmmmmm

mmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmmmmmmmmmm
mmmmmmmmmmmmmmmmkkkk
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
jjjjjjhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
co
HARDWARE AND SOFTWARE USED

SOFTWARE
[Link]
[Link] PHONE
HARDWARE

PYTHON
MYSQL
PYTHON CONNECTOR 3.10.2
nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
nnnnnnnnnnnnnnnnnnnnn…………………………………
……………………………………………………………………………
……………………………………………………………………………
………………………….,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,……………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
……………………………………………………………………………
…………………………………………………………………………… =
RESTART:
C:\Users\Riyuzaki\OneDrive\Desktop\cs
[Link]
==============================
BAKERY MANAGEMENT SYSTEM
==============================
1. Products
2. Inventory
3. Sales
4. Employees
5. Exit
Enter your choice: 1

--- Products Menu ---


1. Add Product
2. View Products
3. Edit Product
4. Delete Product
5. Back to Main Menu
Enter choice: 1
Enter product name: cake Enter
product price: 70
'cake' added successfully!

enter n to cancel

--- Products Menu ---


1. Add Product
2. View Products
3. Edit Product
4. Delete Product
5. Back to Main Menu Enter choice: 1
Enter product name: tea Enter
product price: 15
'tea' added successfully! enter n to cancel1
Enter product name: puffs Enter
product price: 15
'puffs' added successfully!

enter n to cancel1
Enter product name: bun butter jam Enter
product price: 20
'bun butter jam' added successfully!
enter n to canceln

--- Products Menu ---


1. Add Product
2. View Products
3. Edit Product
4. Delete Product
5. Back to Main Menu
Enter choice: 2

--- Product List ---


ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹15.00
ID: 17 | Name: puffs | Price: ₹15.00
ID: 18 | Name: bun butter jam | Price: ₹20.00
--- Products Menu ---
1. Add Product
2. View Products
3. Edit Product
4. Delete Product
5. Back to Main Menu
Enter choice: 3
--- Product List ---
ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹15.00
ID: 17 | Name: puffs | Price: ₹15.00
ID: 18 | Name: bun butter jam | Price: ₹20.00

Enter product ID to edit: 16


Enter new name: tea
Enter new price: 12 Product
updated!
Enter choice: 4

--- Product List ---


ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹12.00
ID: 17 | Name: puffs | Price: ₹15.00
ID: 18 | Name: bun butter jam | Price: ₹20.00

Enter product ID to delete: 18


---Product deleted!---
==============================
BAKERY MANAGEMENT SYSTEM
==============================
1. Products
2. Inventory
3. Sales
4. Employees
5. Exit
Enter your choice: 2

--- Inventory Menu ---


1. Add Inventory
2. View Inventory
3. Update Inventory
4. Delete Inventory
5. Back to Main Menu
Enter choice: 1

--- Product List ---


ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹12.00
ID: 17 | Name: puffs | Price: ₹15.00

Enter Product ID to add stock for: 14


Enter quantity: 20
Enter expiry date (YYYY-MM-DD): 2026-02-14
Inventory added successfully!

--- Inventory Menu ---


1. Add Inventory
2. View Inventory
3. Update Inventory
4. Delete Inventory
5. Back to Main Menu
Enter choice: 2
--- Inventory List ---
ID: 2 | Product: pastries | Qty: 20 | Expiry: 2026-
02-14

--- Inventory Menu ---


1. Add Inventory
2. View Inventory
3. Update Inventory
4. Delete Inventory
5. Back to Main Menu
Enter choice: 3

--- Inventory List ---


ID: 2 | Product: pastries | Qty: 20 | Expiry: 2026-
02-14

Enter Inventory ID to update: 2


Enter new quantity: 28
Enter new expiry date (YYYY-MM-DD): 2025-02-
14
Inventory updated!

--- Inventory Menu ---


1. Add Inventory
2. View Inventory
3. Update Inventory
4. Delete Inventory
5. Back to Main Menu
Enter choice: 4

--- Inventory List ---


ID: 2 | Product: pastries | Qty: 28 | Expiry: 2025-
02-14
Enter Inventory ID to delete: 2 ️
Inventory record deleted!

--- Inventory Menu ---


1. Add Inventory
2. View Inventory
3. Update Inventory
4. Delete Inventory
5. Back to Main Menu
Enter choice: 5
==============================
BAKERY MANAGEMENT SYSTEM
==============================
1. Products
2. Inventory
3. Sales
4. Employees
5. Exit
Enter your choice:3
--- Sales Menu ---
1. Record Sale
2. View Sales
3. Back to Main Menu
Enter choice: 1

--- Product List ---


ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹12.00
ID: 17 | Name: puffs | Price: ₹15.00

Enter Product ID sold: 14


Enter quantity sold: 14
Sale recorded! Total: ₹560.00
--- Sales Menu ---
1. Record Sale
2. View Sales
3. Back to Main Menu
Enter choice: 1

--- Product List ---


ID: 14 | Name: pastries | Price: ₹40.00
ID: 15 | Name: cake | Price: ₹70.00
ID: 16 | Name: tea | Price: ₹12.00
ID: 17 | Name: puffs | Price: ₹15.00

Enter Product ID sold: 16


Enter quantity sold: 30
Sale recorded! Total: ₹360.00
--- Sales Menu ---
1. Record Sale
2. View Sales
3. Back to Main Menu
Enter choice: 2

--- Sales Records ---


ID: 2 | Product: tea | Qty: 30 | Total: ₹360.00 |
Date: 2025-12-12 23:09:50
ID: 1 | Product: pastries | Qty: 14 | Total:
₹560.00 | Date: 2025-12-12 23:09:24

--- Sales Menu ---


1. Record Sale
2. View Sales
3. Back to Main Menu
Enter choice: 3

==============================
BAKERY MANAGEMENT SYSTEM
==============================
1. Products
2. Inventory
3. Sales
4. Employees
5. Exit
Enter your choice: 4

--- Employees Menu ---


1. Add Employee
2. View Employees
3. Edit Employee
4. Delete Employee
5. Back to Main Menu
Enter choice: 1
Enter employee name: kenzo tenma
Enter role (e.g., Baker, Cashier): Baker
Enter salary: 40000
Employee 'kenzo tenma' added successfully!

--- Employees Menu ---


1. Add Employee
2. View Employees
3. Edit Employee
4. Delete Employee
5. Back to Main Menu
Enter choice: 1
Enter employee name: johan liebert
Enter role (e.g., Baker, Cashier): transport manager
Enter salary: 35000
Employee 'johan liebert' added successfully!

--- Employees Menu ---


1. Add Employee
2. View Employees
3. Edit Employee
4. Delete Employee
5. Back to Main Menu
Enter choice: 1
Enter employee name: light yagami
Enter role (e.g., Baker, Cashier): sales executive
Enter salary: 70000
Employee 'light yagami' added successfully!

--- Employees Menu ---


1. Add Employee
2. View Employees
3. Edit Employee
4. Delete Employee
5. Back to Main Menu
Enter choice: 2

--- Employee List ---


ID: 1 | Name: kenzo tenma | Role: Baker | Salary:
₹40000.00
ID: 2 | Name: johan liebert | Role: transport
manager | Salary: ₹35000.00
ID: 3 | Name: light yagami | Role: sales executive
| Salary: ₹70000.00

--- Employees Menu ---


1. Add Employee
2. View Employees
3. Edit Employee
4. Delete Employee
5. Back to Main Menu
Enter choice: 5

==============================
BAKERY MANAGEMENT SYSTEM
==============================
1. Products
2. Inventory
3. Sales
4. Employees
5. Exit
Enter your choice:5 Goodbye!

…………………………………………………………………………
ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ
ㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ
ㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ
ㅤㅤㅤㅤㅤ

BIBILIOGRAPH
1. [Link]
2. [Link]
[Link] ARORA NCERT TEXT BOOK
[Link]

You might also like