Overview
The Online Bakery Management System is a comprehensive application designed to manage the operations of an online bakery. This system provides functionality for managing bakery inventory, processing sales, and generating reports. It is built using Python, MySQL for database management, and supports key features for both admin and user roles.
The system is intended to simplify the management of bakery items, track sales, and offer insightful reports on daily and monthly profits. This project is ideal for small-to-medium bakery businesses looking to streamline their operations with an intuitive system that handles inventory, sales, and reporting efficiently.
Features • Inventory Management: • Add, modify, or delete bakery items such as snacks, pastries, chocolates, and dairy products. • Track item details like item number, name, type, price, quantity, manufacturing, and expiry dates. • Sales Management: • Process sales transactions by recording the item number, quantity, price, and calculating the total cost. • Update the stock quantities in real-time as sales are made. • Reporting: • Generate reports on current stock status. • Calculate and display the net profit for a specific day or month. • Admin & User Access: • Admins have full control over the inventory and sales management, including the ability to modify records and generate reports. • Users can view the inventory and make sales without administrative privileges.
Technology Stack • Backend: Python • Database: MySQL • Library: mysql.connector for database interaction, tabulate for displaying tabular data.
Getting Started
To set up the Online Bakery Management System locally, follow these steps:
Prerequisites • Install MySQL and set up the database. • Install Python (3.x or higher). • Install the required libraries:
pip install mysql-connector tabulate
Installation 1. Clone the repository to your local machine:
git clone https://github.com/MaanavKrishna/Online-Bakery-Management-System.git
2. Navigate to the project folder:
cd Online-Bakery-Management-System
3. Set up the MySQL database with the appropriate tables (inventory, sales, etc.) by running the provided SQL scripts or manually using the database commands defined in the Python code.
4. Run the program by executing the Python file:
python bakery_management.py
Database Setup
Ensure that your MySQL server is running and a database called OnlineBakery is created. The program will automatically create the required tables (inventory and sales) if they don’t already exist.
Configuration
You can configure the database connection by modifying the following code in the bakery_management.py file:
mydb = mysql.connector.connect(host="localhost", user="root", passwd="root")
Make sure the host, user, and passwd parameters match your MySQL setup.
Usage
Once the program is running, you’ll be prompted with a main menu offering the following options: • Admin Menu: For administrative tasks such as managing inventory, processing sales, and generating reports. • Add, modify, or delete items in the inventory. • Process and modify sales records. • Generate daily/monthly sales reports and track profit. • User Menu: For regular users to view the inventory and process sales. • Users can make purchases and modify sales data if necessary. • Generate Reports: Allows generating stock reports and calculating net profit for a given time period.
Example Menu Flow:
-------- ONLINE BAKERY -------- Welcome to the Online Bakery System Main Menu: 1. Admin 2. User 3. Generate Report 4. Exit Option:
Use Cases • Bakery Owners/Managers: • Manage the bakery’s inventory, including items such as pastries, cakes, snacks, and beverages. • Add, update, and delete items based on stock availability. • Track daily and monthly sales performance, analyze profits, and adjust pricing accordingly. • Store Clerks or Sales Staff: • Process sales transactions quickly, updating the inventory in real-time. • View the current stock to help customers make informed purchasing decisions. • Modify sales records in case of mistakes or refunds. • Report Generation: • Generate daily or monthly profit reports to assess business performance. • Monitor stock levels and decide which items to restock or discontinue.
Future Improvements
While the Online Bakery Management System already covers essential functionality, here are some features that could be added in the future: • User Authentication: • Implement user login and authentication for both admin and customer roles to ensure secure access. • Inventory Alerts: • Set up notifications or alerts when stock levels for specific items fall below a certain threshold. • Detailed Sales Reports: • Add more detailed reporting options, such as individual item sales breakdown, customer analysis, or order trends. • Web Interface: • Develop a web-based frontend to replace the command-line interface, providing a more user-friendly experience. • Payment Integration: • Add integration with payment gateways (e.g., PayPal, Stripe) for processing online payments. • Multi-Location Support: • Extend the system to handle multiple bakery locations and manage inventory and sales for each location.
Contributing
Feel free to fork this repository, make improvements, and submit pull requests. Contributions are always welcome, especially for enhancing the user interface, improving system efficiency, or adding new features.
License
This project is open-source and available under the MIT License. See the LICENSE file for more details.