Smart Inventory Management System

A robust inventory management backend built with Flask and MySQL, featuring an integrated Machine Learning module for sales demand forecasting. This system helps store owners manage products, track sales, monitor stock levels, and predict future inventory needs using historical data.

🚀 Features

• Product Management: CRUD operations for inventory items (SKU, Barcode, Stock, Price).
• Sales Tracking: Record sales transactions and automatically update stock levels.
• Supplier Management: Maintain a database of suppliers.
• Analytics Dashboard: Real-time stats on total sales, inventory value, and low-stock alerts.
• Demand Forecasting (ML):
  • Uses Linear Regression to predict future product demand.
  • Generates 7-day sales forecasts based on historical data.
  • Auto-generates features like lag variables and rolling averages.
• Database: Relational schema with support for Users, Sales, Stock Movements, and Predictions.

🛠️ Tech Stack

• Language: Python 3.x
• Framework: Flask
• Database: MySQL
• Machine Learning: Scikit-Learn, Pandas, NumPy
• API: RESTful JSON API

📂 Project Structure

Smart Inventory Management System /
├── backend/
│   ├── app.py                 # Main Flask application entry point
│   ├── api_routes.py          # API endpoints definition
│   ├── requirements.txt       # Python dependencies
│   └── ml_model/
│       ├── data_generator.py  # Script to generate dummy testing data
│       └── train_model.py     # ML training and prediction script
├── database/
│   └── database_schema.sql    # MySQL database creation script
└── .gitignore