Shopify Sales vs Shopify Sales (Order closed date)
Workspaces often see two Shopify-related metric variants in Reports: Shopify Sales (by creation date — when the order was placed) and Shopify Sales (Order closed date) (by closed date — when the order finalized, typically after fulfillment).
Same underlying data; two different time anchors. They produce different totals for any period that contains orders straddling the two anchors.
Which anchor to use
Section titled “Which anchor to use”| Anchor | Best for |
|---|---|
| Creation date | Operational reporting, marketing attribution (when the customer placed the order) |
| Closed date | Finance reporting, revenue recognition (when the order finalized) |
Match the anchor to whatever your team or stakeholders standardize on.
Why the gap
Section titled “Why the gap”An order placed at 11:59 PM on Monday and closed (fulfilled, shipped) on Tuesday morning:
| Anchor | Monday | Tuesday |
|---|---|---|
| Creation date | $X | $0 |
| Closed date | $0 | $X |
Over long periods, the totals converge. Over a single day or a short window, they can differ noticeably.
Where you’ll see both variants
Section titled “Where you’ll see both variants”Both variants appear in Reports’ metric group picker when the workspace has the appropriate Shopify metric configuration. Use whichever matches the section’s purpose; mark the choice in the section title for clarity (“Shopify Sales (Order date)” vs “Shopify Sales (Closed date)”).
Related: other date anchors
Section titled “Related: other date anchors”The same pattern applies to other ecommerce platforms with multiple time fields. For the general explanation, see Date anchors.