How to Automate Shopify Sales Reports using the API

Understanding Shopify Sales Reporting via API

Setting Up Shopify API Authentication for Sales Reports

Sales reporting requires read access to orders data. For ShopifyQL analytics queries, you additionally need the read_analytics scope. Create a custom app from the Shopify Dev Dashboard with these scopes.

1. 1Go to dev.shopify.com and create a custom app.
2. 2Enable Admin API scopes: read_orders, read_analytics, read_reports.
3. 3Install the app and copy the generated access token.
4. 4Store as SHOPIFY_ACCESS_TOKEN environment variable.
5. 5Register a webhook for BULK_OPERATIONS_FINISH to avoid polling bulk operation status.
6. 6Set your shop domain: export SHOPIFY_SHOP_DOMAIN='yourstore.myshopify.com'

1import os
2import requests
3
4SHOP_DOMAIN = os.environ['SHOPIFY_SHOP_DOMAIN']
5ACCESS_TOKEN = os.environ['SHOPIFY_ACCESS_TOKEN']
6
7GQL_URL = f'https://{SHOP_DOMAIN}/admin/api/2026-04/graphql.json'
8HEADERS = {'X-Shopify-Access-Token': ACCESS_TOKEN, 'Content-Type': 'application/json'}
9
10# Test: fetch last 3 orders with revenue data
11q = '{ orders(first: 3, sortKey: CREATED_AT, reverse: true) { edges { node { id name totalPriceV2 { amount currencyCode } createdAt } } } }'
12resp = requests.post(GQL_URL, json={'query': q}, headers=HEADERS)
13print(resp.json())

Key endpoints

1{"query": "{ orders(first: 250, query: \"created_at:>=2026-04-01 AND created_at:<2026-05-01 AND financial_status:paid\") { edges { node { id name totalPriceV2 { amount currencyCode } subtotalPriceV2 { amount } totalTaxV2 { amount } lineItems(first: 10) { edges { node { title quantity originalUnitPriceV2 { amount } } } } createdAt } } pageInfo { hasNextPage endCursor } } }"}

1{"data": {"orders": {"edges": [{"node": {"id": "gid://shopify/Order/12345", "name": "#1001", "totalPriceV2": {"amount": "145.50", "currencyCode": "USD"}, "subtotalPriceV2": {"amount": "130.00"}, "totalTaxV2": {"amount": "15.50"}, "lineItems": {"edges": [{"node": {"title": "Blue Widget", "quantity": 2, "originalUnitPriceV2": {"amount": "65.00"}}}]}, "createdAt": "2026-04-15T10:30:00Z"}}], "pageInfo": {"hasNextPage": true, "endCursor": "abc123"}}}}

1{"query": "mutation { bulkOperationRunQuery(query: \"{ orders(query: \\\"created_at:>=2026-04-01\\\") { edges { node { id name totalPriceV2 { amount currencyCode } createdAt lineItems { edges { node { title quantity } } } } } } }\") { bulkOperation { id status } userErrors { field message } } }"}

1{"data": {"bulkOperationRunQuery": {"bulkOperation": {"id": "gid://shopify/BulkOperation/11223", "status": "CREATED"}, "userErrors": []}}}

1{"query": "{ currentBulkOperation { id status errorCode objectCount url } }"}

1{"data": {"currentBulkOperation": {"id": "gid://shopify/BulkOperation/11223", "status": "COMPLETED", "errorCode": null, "objectCount": "1543", "url": "https://storage.googleapis.com/shopify-tiers.../bulk-123.jsonl"}}}

Step-by-step automation

1curl -X POST 'https://mystore.myshopify.com/admin/api/2026-04/graphql.json' \
2  -H 'X-Shopify-Access-Token: shpat_your_token' \
3  -H 'Content-Type: application/json' \
4  -d '{
5    "query": "{ orders(first: 250, query: \\"created_at:>=2026-04-01 AND created_at:<2026-05-01 AND financial_status:paid\\") { edges { node { id name totalPriceV2 { amount currencyCode } createdAt lineItems(first: 10) { edges { node { title quantity originalUnitPriceV2 { amount } } } } } } pageInfo { hasNextPage endCursor } } }"
6  }'

1# Start bulk operation
2curl -X POST 'https://mystore.myshopify.com/admin/api/2026-04/graphql.json' \
3  -H 'X-Shopify-Access-Token: shpat_your_token' \
4  -H 'Content-Type: application/json' \
5  -d '{
6    "query": "mutation { bulkOperationRunQuery(query: \\"{ orders(query: \\\\\\"created_at:>=2026-04-01 AND financial_status:paid\\\\\\") { edges { node { id name totalPriceV2 { amount currencyCode } createdAt } } } }\\") { bulkOperation { id status } userErrors { field message } } }"
7  }'

1# Send formatted report to Slack
2curl -X POST 'https://hooks.slack.com/services/YOUR/SLACK/WEBHOOK' \
3  -H 'Content-Type: application/json' \
4  -d '{
5    "text": "Weekly Sales Report",
6    "blocks": [{
7      "type": "section",
8      "text": {"type": "mrkdwn", "text": "*Revenue*: $12,450.00\n*Orders*: 87\n*AOV*: $143.10"}
9    }]
10  }'

1# Trigger via cron job or GitHub Actions
2# Example: run daily at 8am UTC
3# 0 8 * * * python /path/to/automate_shopify_reports.py

Complete working code

This script fetches the previous week's paid orders from Shopify GraphQL, aggregates revenue and top products, and posts a formatted summary to Slack. Designed to run as a weekly cron job.

1import os, logging, requests
2from datetime import datetime, timedelta
3from collections import defaultdict
4
5logging.basicConfig(level=logging.INFO)
6
7SHOP_DOMAIN = os.environ['SHOPIFY_SHOP_DOMAIN']
8ACCESS_TOKEN = os.environ['SHOPIFY_ACCESS_TOKEN']
9SLACK_WEBHOOK = os.environ['SLACK_WEBHOOK_URL']
10
11GQL_URL = f'https://{SHOP_DOMAIN}/admin/api/2026-04/graphql.json'
12HEADERS = {'X-Shopify-Access-Token': ACCESS_TOKEN, 'Content-Type': 'application/json'}
13
14def get_period():
15    today = datetime.now().date()
16    days_since_monday = today.weekday()
17    last_monday = today - timedelta(days=days_since_monday + 7)
18    last_sunday = last_monday + timedelta(days=7)
19    return last_monday.isoformat(), last_sunday.isoformat()
20
21def fetch_orders(start, end):
22    orders, cursor = [], None
23    while True:
24        after = f', after: "{cursor}"' if cursor else ''
25        q = f'{{ orders(first: 250{after}, query: "created_at:>={start} AND created_at:<{end} AND financial_status:paid") {{ edges {{ node {{ totalPriceV2 {{ amount }} lineItems(first: 10) {{ edges {{ node {{ title quantity originalUnitPriceV2 {{ amount }} }} }} }} }} }} pageInfo {{ hasNextPage endCursor }} }} }}'
26        resp = requests.post(GQL_URL, json={'query': q}, headers=HEADERS)
27        data = resp.json()['data']['orders']
28        orders.extend(e['node'] for e in data['edges'])
29        if not data['pageInfo']['hasNextPage']:
30            break
31        cursor = data['pageInfo']['endCursor']
32        # Respect rate limits
33        throttle = resp.json().get('extensions', {}).get('cost', {}).get('throttleStatus', {})
34        if throttle.get('currentlyAvailable', 1000) < 200:
35            import time; time.sleep(2)
36    return orders
37
38def aggregate(orders):
39    total = sum(float(o['totalPriceV2']['amount']) for o in orders)
40    prod = defaultdict(float)
41    for o in orders:
42        for e in o['lineItems']['edges']:
43            n = e['node']
44            prod[n['title']] += float(n.get('originalUnitPriceV2', {}).get('amount', 0)) * n.get('quantity', 1)
45    top5 = sorted(prod.items(), key=lambda x: x[1], reverse=True)[:5]
46    return total, len(orders), total / max(len(orders), 1), top5
47
48def send_slack(text):
49    requests.post(SLACK_WEBHOOK, json={'text': text})
50
51def main():
52    start, end = get_period()
53    logging.info(f'Fetching orders {start} to {end}')
54    orders = fetch_orders(start, end)
55    total, count, aov, top5 = aggregate(orders)
56    top5_text = '\n'.join(f'  {i+1}. {n}: ${r:,.2f}' for i, (n, r) in enumerate(top5))
57    message = f'*Weekly Sales Report ({start} to {end})*\nRevenue: ${total:,.2f}\nOrders: {count}\nAOV: ${aov:.2f}\n\n*Top Products:*\n{top5_text}'
58    send_slack(message)
59    logging.info('Report sent to Slack')
60
61if __name__ == '__main__':
62    main()

Error handling

Rate Limits for Shopify Sales Reporting API

1import time
2
3def gql_with_throttle_respect(url, headers, payload):
4    resp = requests.post(url, json=payload, headers=headers)
5    if resp.status_code == 429:
6        time.sleep(2)
7        return gql_with_throttle_respect(url, headers, payload)
8    resp.raise_for_status()
9    result = resp.json()
10    throttle = result.get('extensions', {}).get('cost', {}).get('throttleStatus', {})
11    available = throttle.get('currentlyAvailable', 1000)
12    restore_rate = throttle.get('restoreRate', 50)
13    if available < 200:
14        sleep_time = (300 - available) / restore_rate
15        print(f'Throttle low ({available} pts), sleeping {sleep_time:.1f}s')
16        time.sleep(sleep_time)
17    return result

• For stores with >1,000 orders/period, always use bulkOperationRunQuery instead of paginated queries.
• Register the BULK_OPERATIONS_FINISH webhook instead of polling currentBulkOperation — saves API calls and is more reliable.
• Request only the order fields you need — including all order fields inflates query cost significantly.
• Run reports during off-peak hours (early morning) to avoid competing with real-time operations for GraphQL budget.
• Store historical report snapshots — don't re-fetch Shopify data for trend analysis that could be computed from stored data.

Security checklist

Automation use cases

No-code alternatives

Don't want to write code? These platforms can automate the same workflows visually.

Best practices

• For stores with >1,000 orders/period, use bulkOperationRunQuery — it has no rate-limit cost and is orders of magnitude faster than paginating.
• Always filter for `financial_status:paid` unless you specifically want pending or refunded orders in your numbers.
• Subscribe to the BULK_OPERATIONS_FINISH webhook rather than polling — it's one-time setup vs repeated API calls.
• Store report snapshots in a database for historical trend analysis — don't re-query Shopify for last month's data when you already have it.
• Compare bulk result URLs against expected order counts (`objectCount`) before processing — a JSONL with fewer lines than orders indicates a partial failure.
• For real-time dashboards, use paginated queries; for scheduled reports, use bulk operations.
• Bulk operation result URLs are valid for 7 days — download and process promptly.
• Use ShopifyQL (`shopifyqlQuery`) on Standard/Advanced/Plus plans for pre-aggregated analytics data — it's faster than computing aggregations yourself.

Ask AI to help

Copy one of these prompts to get a personalized, working implementation.

Related automations

Explore related guides

Guides from other topics that help with this issue