How it’s calculated
Built from
Refund.totalRefundedSet.shopMoney.amountRefund.transactions[].amountSet.shopMoney.amount
Known caveats
- Use Shopify returns for the ShopifyQL daily-sales breakdown.
Where this appears
- Supporting input; not offered as a standalone dashboard metric
Grain and identity
Grain and identity
event; entity: order; same-day fold: sum; additivity: additive.Join and identity keys
- refundId
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