> ## Documentation Index
> Fetch the complete documentation index at: https://docs.aloftly.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Total sales

> Shopify-admin total sales: gross plus discounts, returns, shipping, and taxes.

| Contract           | Value                 |
| ------------------ | --------------------- |
| Metric key         | `shopify.total_sales` |
| Source             | Shopify               |
| Status             | active                |
| Type               | source                |
| Semantic version   | 1                     |
| Catalog visibility | Picker-eligible       |

## How it's calculated

```text theme={null}
value = ShopifyQL total_sales, stored verbatim for each day.
```

### Built from

* `ShopifyQL total_sales`

## Known caveats

* Primary store-sales authority.
* The Shopify sync can replace the live partial reporting day; it is not guaranteed to be finalized until the day closes.

## Where this appears

* Overview KPI strip
* Revenue trend and AI commerce datasets

<AccordionGroup>
  <Accordion title="Grain and identity" icon="ruler">
    daily\_snapshot; entity: store; same-day fold: last; additivity: semi\_additive.

    **Join and identity keys**

    * snapshotDate
  </Accordion>

  <Accordion title="Filters and boundaries" icon="filter">
    * 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.
  </Accordion>

  <Accordion title="Timezone, currency, and freshness" icon="clock">
    **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.** Finalized daily snapshot from Shopify.
  </Accordion>

  <Accordion title="Version history" icon="clock-rotate-left">
    | Date       | Change                                                                     |
    | ---------- | -------------------------------------------------------------------------- |
    | 2026-08-03 | Bound the metric to the executable certified semantic release.             |
    | 2026-07-27 | Registered Shopify authority and metric contracts in the semantic catalog. |
  </Accordion>
</AccordionGroup>