This project builds a complete inventory management system using QR codes, Python, and a database.

Perfect for:

• Shops / warehouses
• Office asset tracking
• Home inventory
• Library / equipment logs
• Event management

---

🧠 What You Will Build

Your QR Inventory System will:

✔ Generate QR codes for each product

✔ Scan QR codes to update stock

✔ Maintain a database (CSV/SQLite)

✔ Track product details (name, ID, price, quantity)

✔ Add/Remove/Update inventory

✔ Streamlit Dashboard (optional)

✔ Logging system

---

🧰 Tech Stack

• Python
• qrcode (generate QR codes)
• opencv-python (scan QR codes)
• pyzbar (decode QR codes)
• SQLite/Pandas

Install:

pip install qrcode opencv-python pyzbar pandas

---

📁 Folder Structure

QRInventory/
│── generate_qr.py
│── scan_qr.py
│── inventory.csv
│── qr_codes/

---

📌 1. Inventory File (inventory.csv)

id,name,price,qty
101,Keyboard,800,12
102,Mouse,400,20
103,Laptop,55000,5

---

🧩 2. QR Code Generator (generate_qr.py)

import qrcode
import pandas as pd
import os

df = pd.read_csv("inventory.csv")
os.makedirs("qr_codes", exist_ok=True)

for _, row in df.iterrows():
    data = f"{row['id']}|{row['name']}|{row['price']}|{row['qty']}"
    img = qrcode.make(data)
    img.save(f"qr_codes/{row['id']}.png")

print("QR Codes Generated!")

✔ Each product gets a QR code
✔ Encodes ID, name, price, quantity

---

🧩 3. QR Code Scanner + Inventory Updater (scan_qr.py)

import cv2
from pyzbar.pyzbar import decode
import pandas as pd

def update_stock(product_id):
    df = pd.read_csv("inventory.csv")
    df.loc[df["id"] == int(product_id), "qty"] += 1
    df.to_csv("inventory.csv", index=False)
    print("Stock updated!")

cap = cv2.VideoCapture(0)

print("Scan QR Code...")

while True:
    _, frame = cap.read()
    for code in decode(frame):
        data = code.data.decode("utf-8")
        pid, name, price, qty = data.split("|")
        print(f"Scanned → {name} (ID: {pid})")

        update_stock(pid)
        cap.release()
        cv2.destroyAllWindows()
        exit()

    cv2.imshow("QR Scanner - Press Q to Quit", frame)

    if cv2.waitKey(1) & 0xFF == ord("q"):
        break

cap.release()
cv2.destroyAllWindows()

✔ Scans QR code
✔ Reads product info
✔ Automatically updates database