Inventory Stock Monitoring Agent

import requests, json, pandas as pd

API_INV = "https://api.warehouse.com/v2/inventory"

def fetch_inventory(warehouse_id):
    resp = requests.get(API_INV, params={"wh": warehouse_id})
    return resp.json().get("items", [])

def categorize_stock(items):
    df = pd.DataFrame(items)
    df["status"] = df["qty"].apply(
        lambda q: "Low Stock" if q < 20
        else "Overstock" if q > 400
        else "OK")
    alerts = df[df["status"] == "Low Stock"]
    return {
        "total_sku": len(df),
        "low_stock": len(alerts),
        "overstock": len(df[df["status"] == "Overstock"]),
        "alerts": alerts.to_dict("records")
    }

report = categorize_stock(fetch_inventory("WH-01"))
print(json.dumps(report))