Inventory SKU Cleanup Agent

import requests, json, pandas as pd

API_INVENTORY = "https://api.example.com/v2/inventory/skus"

def fetch_sku_master():
    resp = requests.get(API_INVENTORY)
    return resp.json().get("skus", [])

def detect_duplicates(skus):
    df = pd.DataFrame(skus)
    dupes = df[df.duplicated(subset=["product_name"], keep=False)]
    return dupes.to_dict("records")

def flag_inactive(skus, months=6):
    flagged = []
    for s in skus:
        if s.get("last_sale_days", 999) > months * 30:
            flagged.append(s)
    return flagged

skus = fetch_sku_master()
dupes = detect_duplicates(skus)
inactive = flag_inactive(skus)
report = {
    "total_skus": len(skus),
    "duplicates": len(dupes),
    "inactive": len(inactive),
    "cleanup_ready": len(dupes) + len(inactive) > 0
}
print(json.dumps(report))