🛒 GrocerySync – Smart Grocery Management System

⚙️ Streamline Stock. Automate Billing. Simplify Grocery Management.

---

📖 About the Project

GrocerySync is a Python-based web application designed to automate and simplify grocery store operations — from inventory tracking to billing and reporting.

---

🎯 Key Objectives

• ✅ Eliminate manual stock tracking
• ✅ Reduce billing errors and data mismatches
• ✅ Generate reports for sales and inventory trends
• ✅ Improve efficiency for store administrators
• ✅ Support scalability for growing stores

---

🚩 Problem Statement

Many grocery stores still rely on manual processes for managing inventory, billing, and record-keeping — which leads to stock discrepancies, wastage, and inefficiency. GrocerySync uses an automated system with real-time updates and a user-friendly interface to maintain accurate stock levels, generate bills, and provide insightful reports.

---

💡 Core Features

• 🗂️ Real-time inventory updates
• 🧾 Automated billing system
• 📑 Sales and inventory reports (CSV/PDF)
• 👥 Secure admin login & user profiles
• 📊 Dashboard with key insights
• 🔍 Search and manage products easily

---

⚙️ Tech Stack

Frontend	Backend	Database
Tkinter, PySimpleGUI	Python	MySQL

---

📌 System Overview

✅ ER Diagram

---

📈 Implementation Screenshots

📌 Sign Up Page & Login Page - Register new admin users

---

📌 Dashboard - View inventory and stats

---

📌 Add Item Page - Add new products

---

📌 Selling Page - Process sales & billing

---

📜 Requirements & Setup

Hardware:

• Processor: Intel Core i3 or higher
• RAM: 4GB minimum

Software:

• Python 3.x
• MySQL
• VS Code
• Git & GitHub

Setup:

1. Clone the repo:

   git clone https://github.com/YourUsername/GrocerySync.git

2. Install dependencies:

   pip install -r requirements.txt

3. Setup MySQL database and import provided .sql file.

4. Run the app:

   python app.py

---

📚 References

• Grewal et al., The Evolution and Future of Retailing
• Shawn P. Daly, Student-operated Internet Businesses
• P. Ballon & N. Walravens, Competing Platform Models for Mobile Service Delivery
• I. Geyskens, Retailer Power in the Grocery Industry

---

✅ Conclusion

GrocerySync simplifies grocery store management by automating inventory tracking, billing, and reporting — boosting efficiency and accuracy for store owners.

---

🚀 Let’s Automate Grocery Stores Together!