Email a weekly Wix Stores sales summary

from collections import Counter
from datetime import datetime, timezone, timedelta
from clickruntime import on_trigger, credentials, http, state, notify

SITE_ID = "your-site-id"

@on_trigger
def run(event):
    since = (datetime.now(timezone.utc) - timedelta(days=7)).isoformat()
    orders, cursor = [], None
    while True:
        paging = {"limit": 100, **({"cursor": cursor} if cursor else {})}
        resp = http.post("https://www.wixapis.com/ecom/v1/orders/search",
                         headers={"Authorization": credentials.secret("WIX_API_KEY"), "wix-site-id": SITE_ID},
                         json={"search": {"filter": {"createdDate": {"$gt": since}, "status": "APPROVED"}, "cursorPaging": paging}})
        resp.raise_for_status()
        body = resp.json()
        orders += body.get("orders", [])
        cursor = body.get("metadata", {}).get("cursors", {}).get("next")
        if not cursor:
            break
    revenue = sum(float(o["priceSummary"]["total"]["amount"]) for o in orders)
    currency = orders[0]["currency"] if orders else ""
    products = Counter()
    for o in orders:
        for i in o["lineItems"]:
            products[i["productName"]["original"]] += i["quantity"]
    prev = state.get("prev") or {}
    state.set("prev", {"orders": len(orders), "revenue": revenue})
    top = "\n".join(f"{n}. {name}: {q}" for n, (name, q) in enumerate(products.most_common(5), 1))
    text = (f"Orders: {len(orders)} (previous week {prev.get('orders', 'n/a')})\n"
            f"Revenue: {currency} {revenue:,.2f} (previous week {currency} {prev.get('revenue', 0):,.2f})\n"
            f"Average order: {currency} {revenue / len(orders) if orders else 0:,.2f}\n\nTop products\n{top or 'No sales'}")
    notify.email_me(f"Wix sales last week: {len(orders)} orders, {currency} {revenue:,.2f}", text)
    return {"orders": len(orders), "revenue": revenue}