Find good customers who stopped ordering

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!, $after: String) { customers(first: 100, query: $q, after: $after) {
  pageInfo { hasNextPage endCursor }
  nodes { displayName email numberOfOrders amountSpent { amount currencyCode } lastOrder { createdAt } } } }"""

@on_trigger
def run(event):
    cutoff = (date.today() - timedelta(days=90)).isoformat()
    lapsed, after = [], None
    while True:
        page = gql(QUERY, {"q": "orders_count:>1", "after": after})["customers"]
        lapsed += [c for c in page["nodes"] if c["lastOrder"] and c["lastOrder"]["createdAt"][:10] < cutoff]
        if not page["pageInfo"]["hasNextPage"]:
            break
        after = page["pageInfo"]["endCursor"]
    lapsed.sort(key=lambda c: -float(c["amountSpent"]["amount"]))
    lines = [f"{c['displayName']} <{c['email']}>  {c['numberOfOrders']} orders  "
             f"{float(c['amountSpent']['amount']):,.2f}  last {c['lastOrder']['createdAt'][:10]}" for c in lapsed]
    notify.email_me(f"{len(lapsed)} repeat customers gone quiet 90+ days", "\n".join(lines) or "None this month.")
    return {"lapsed": len(lapsed)}