← Back to projects

Inventory & Stock Alert System

Overview

Automatically monitors stock levels from Google Sheets or ERP, sends email and WhatsApp alerts when a product falls below the minimum, and triggers an automatic order to the supplier when the critical level is reached.

magazzino-alert.py · scanning inventoryScan
0%
Inventory & Stock Alert System
Monitors stock · alerts on low levels · auto-orders when critical
2 critical2 low stock0 orders sent
Stock levels
Espresso Blend 1kg
8 kgCritical
Min: 20 kg · SKU-001
Packaging boxes (S)
45 pcsLow stock
Min: 30 pcs · SKU-002
Cleaning supplies
120 pcsOK
Min: 50 pcs · SKU-003
Specialty Roast 500g
12 kgCritical
Min: 25 kg · SKU-004
Paper cups 8oz
280 pcsOK
Min: 200 pcs · SKU-005
Milk — full fat
18 LLow stock
Min: 40 L · SKU-006
Automation actions
  • Daily stock scan at 07:00
  • Email alert on low stock
  • Auto-order on critical level
  • Supplier confirmation log
Activity log
Scanning...
Integrates with:
Google Sheets, ERP, email, WhatsApp, supplier APIs

Details

The problem
In shops, bars, restaurants and craft workshops it's common to run out of a key product without noticing in time. Manually checking dozens of items every day is tedious and prone to human error, with the risk of operational stoppages and dissatisfied customers.
The solution
A Python script that runs every morning at 07:00 and reads stock levels from the warehouse Google Sheets (or via API from the ERP). For each product it compares the current quantity with the minimum and critical threshold. If a product is below minimum, it sends an alert email to the manager. If it's at critical level, it automatically generates and sends a pre-filled order to the supplier via email.
How it works
1. Read stock from Google Sheets / ERP via API 2. Compare with minimum and critical thresholds for each SKU 3. Email + WhatsApp alert for products below minimum 4. Auto-generate order for critical products 5. Send order to supplier via email 6. Full log to CSV / Sheets 7. Daily report with warehouse status
Typical results
Near-complete elimination of unplanned stock-outs. Reduction of daily stock check time from 30–45 minutes to zero. Estimated average saving of 15% on emergency procurement costs.