Skip to main content

​
How it’s calculated

​
Built from

  • Bulk order line item originalTotalSet.shopMoney.amount
  • Line item quantity and product/variant identity

​
Known caveats

  • Only the bulk product publisher may write this key.
  • This is gross line revenue. It does not subtract discounts, refunds, or cancellations.

​
Where this appears

  • Top Products revenue
  • Top Products grouping and sorting
One order-time line item. The Top Products read groups rows by product title, then SKU, variant title, or variant id.Join and identity keys
  • HMAC line-item dedupe identity
  • orderToken for distinct-order reads
  • productHandle/productTitle/variantId/variantTitle/SKU for grouping
  • 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. 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. Daily scheduled product bulk sync and deliberate history runs.