Shopify Explorer isn’t configured

Credentials are read from the server environment — nothing is stored in the browser.

Set SHOPIFY_SHOPS to a JSON map of {"shop.myshopify.com": "shpat_…"}, or SHOPIFY_SHOP + SHOPIFY_ACCESS_TOKEN for a single merchant
…or set SHOPIFY_ALLOW_ADHOC_TOKEN=1 to paste a token per run instead of storing any
Optional: SHOPIFY_API_VERSION (default 2026-01) and ENGINE (bulk or paginate)
Restart the server and reload this page

Shopify Explorer

Count or export a merchant’s Shopify orders and their related records for a date range. Counts return inline; exports come back as a CSV + JSONL bundle.

1 Merchant

Shop domain Pick a configured shop, or type any domain. Access token Held in memory for this run only — never written to disk or logs.

2 Window

Date field Window start Window end

Both ends are inclusive. Times are UTC, not the store’s timezone, so a US store sees the boundary days shifted by several hours. Refunds and returns often land weeks after the order — for return-rate work use created_at and an end date far enough back that the return window has closed.

Additional filter (optional) Appended verbatim in Shopify search syntax.

3 What to run

Exact counts past 10,000 Count individual returns Include chargebacks

Nothing is downloaded — this asks “how much is there?” Rows built on order-level fields (return_status, financial_status) count orders, not records; tick Count individual returns for the real return count.

Export

Table	Rows