Get a daily Shopify order summary by email

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

STORE = "your-store.myshopify.com"

def gql(query, variables=None):
    resp = http.post(f"https://{STORE}/admin/api/2025-07/graphql.json", json={"query": query, "variables": variables or {}},
                     headers={"X-Shopify-Access-Token": credentials.connection("shopify", "store")})
    return resp.raise_for_status() or resp.json()["data"]

@on_trigger
def run(event):
    day = date.today() - timedelta(days=1)
    orders = gql("""query($q: String!) { orders(first: 250, query: $q) { nodes { totalPriceSet { shopMoney { amount } }
        lineItems(first: 50) { nodes { title quantity } } } } }""", {"q": f"created_at:>={day} created_at:<{date.today()} -status:cancelled"})["orders"]["nodes"]
    revenue = sum(float(o["totalPriceSet"]["shopMoney"]["amount"]) for o in orders)
    top = Counter()
    for o in orders:
        top.update({li["title"]: li["quantity"] for li in o["lineItems"]["nodes"]})
    text = (f"Orders: {len(orders)}\nRevenue: {revenue:,.2f}\nAverage order: {revenue / max(len(orders), 1):,.2f}\n"
            "Top products: " + ", ".join(f"{t} ({n})" for t, n in top.most_common(3)))
    prev = state.get("prev")
    try:
        text += "\n\n" + ai.generate(f"Yesterday {len(orders)} orders, {revenue:.0f}. Day before: {prev}", system="One short sentence comparing the two days.", max_output_tokens=60).text
    except (ai.AINotIncluded, ai.AILimitReached):
        pass
    notify.email_me(f"Shopify {day:%a %d %b}: {len(orders)} orders, {revenue:,.0f}", text)
    state.set("prev", {"orders": len(orders), "revenue": round(revenue)})
    return {"orders": len(orders)}