Overview
Accurate data is the backbone of any successful Shopify store. However, discrepancies often arise when comparing third-party analytics with Shopify’s native reports. One of the most common points of confusion is how returns and multi-channel exchanges are attributed.
This article will help you:
Distinguish between Order-Level and Transaction-Level dimensions.
Understand why your previous reports may not have matched Shopify’s internal dashboards.
Learn how to use our new dimensions to achieve 1:1 data parity with Shopify.
Section 1: The Difference Between Order and Transaction Attribution
In the world of Shopify, an "Order" is the initial event, but a "Transaction" can happen at any point in the lifecycle of that order (such as a refund or an exchange).
Order-Level Attribution: This focuses on the origin of the sale. If a customer buys a shirt online, that order is forever tagged as "Online Store." Any subsequent activity is tied back to that original source.
Transaction-Level Attribution: This focuses on where the action happened. If that same customer returns the shirt at your physical boutique (Point of Sale), the return transaction is tagged as "POS," even though the original order was "Online."
Section 2: Mapping Our Dimensions to Shopify
To give you more flexibility, we have updated our data schema. We now offer two sets of dimensions. Using the "Sales Channel" dimensions (without the "Order" prefix) will ensure your reports match Shopify exactly.
Dimension Type | Our Dimension Name | How it Behaves | Matches Shopify? |
Legacy / Origin |
| Attributes everything to the original source. | No |
New / Real-time |
| Attributes each event to its specific location. | Yes |
Pro Tip: If you are trying to reconcile your end-of-month books with Shopify’s "Sales by Channel" report, always use Sales Channel Title or Sales Channel Handle.
Section 3: Real-World Example: The "Online-to-In-Store" Return
Let’s look at how a single order appears in your reports depending on which dimension you choose.
Scenario: A customer buys a $100 jacket on your website (Online). Two days later, they return it at your physical storefront (POS).
Using
Order Sales Channel:The $100 Sale is attributed to Online Store.
The -$100 Return is attributed to Online Store.
Result: Your Online Store revenue is accurate, but your POS team doesn't get "credit" (or the debit) for processing the return.
Using
Sales Channel(New):The $100 Sale is attributed to Online Store.
The -$100 Return is attributed to Point of Sale.
Result: This matches Shopify’s logic and accurately reflects the workload and cash flow of your physical location.
Conclusion
Choosing the right dimension depends on your goal. Use Sales Channel if you want to see which channels are driving your initial customer acquisitions. Use our new Order Sales Channel dimensions if you need to reconcile your finances or match Shopify’s native reporting.
By utilizing these new dimensions, you can eliminate "data drift" and ensure your team is making decisions based on the most granular information available.