> ## 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.

# Sales-report orders

> Shopify-admin sales-report order count used by the admin AOV formula.

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

## How it's calculated

```text theme={null}
value = ShopifyQL orders from the sales report for one day.
```

### Built from

* `ShopifyQL orders`

## Known caveats

* Distinct from order-lifecycle shopify.orders.

## Where this appears

* Dashboard builder
* Average order value input

<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.** Not applicable.

    **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>