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))