How it’s calculated
Built from
Order.totalPriceSet.shopMoney.amountOrder.cancelledAtRefund.totalRefundedSet or refund transactions
Known caveats
- Legacy order-lifecycle series; use Shopify total sales for store sales conclusions.
Where this appears
- Stores page revenue
- KPI fallback when Shopify analytics is unavailable
Grain and identity
Grain and identity
event; entity: order; same-day fold: sum; additivity: additive.Join and identity keys
- orderId
- eventType
Filters and boundaries
Filters and boundaries
- Organization and store are resolved from the authenticated request.
- Reads use a half-open interval: recorded_at >= start and recorded_at < end.
- ShopifyQL sales values are used as reported; no extra paid-order filter is added by Aloftly.
Timezone, currency, and freshness
Timezone, currency, and freshness
Timezone. ShopifyQL groups by the shop reporting date; Aloftly stores that date as a UTC-midnight label. Order lifecycle events retain their provider timestamp.Currency. Currency values use Shopify shop-money amounts. Aloftly does not perform foreign-exchange conversion; mixed-currency all-store totals must not be interpreted as converted currency.Freshness. Webhook and cursor sync.
Version history
Version history