Get yesterday's sales every morning

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

STORE = "your-store.myshopify.com"

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

QUERY = """query($q: String!) { orders(first: 250, query: $q) { nodes {
  displayFinancialStatus displayFulfillmentStatus totalPriceSet { shopMoney { amount currencyCode } }
  lineItems(first: 50) { nodes { title quantity } } } } }"""

@on_trigger
def run(event):
    day = date.today() - timedelta(days=1)
    orders = gql(QUERY, {"q": f"created_at:>={day} created_at:<{date.today()}"})["orders"]["nodes"]
    total = sum(float(o["totalPriceSet"]["shopMoney"]["amount"]) for o in orders)
    paid = sum(o["displayFinancialStatus"] == "PAID" for o in orders)
    fulfilled = sum(o["displayFulfillmentStatus"] == "FULFILLED" for o in orders)
    top = Counter()
    for o in orders:
        for li in o["lineItems"]["nodes"]:
            top[li["title"]] += li["quantity"]
    lines = [f"Orders: {len(orders)}", f"Sales: {total:,.2f}", f"Paid: {paid} · Fulfilled: {fulfilled}", "", "Top products:"]
    lines += [f"  {qty} × {title}" for title, qty in top.most_common(5)]
    notify.email_me(f"Shopify sales for {day}", "\n".join(lines))
    return {"orders": len(orders), "sales": total}