Hi Shopify,
We are reconciling between Shopify showing on Order details vs Shopify Analytics, and the “returns amount” is not matched.
We ask AI support and no explanation fair to explain what is number of Shopify Analytics showing on reports.
This is details example:
Shopify store: ergonofis-desks
On Order details, Shopify showed: -$316.37 CAD (1 CAD = 0.696185 USD) → -$220.25 USD
On Shopify Analytics: -$288.54 CAD
Query:
FROM sales
SHOW returns
GROUP BY order_name WITH TOTALS, CURRENCY ‘CAD’
HAVING returns != 0
SINCE 2025-01-01 UNTIL 2025-01-31
ORDER BY returns DESC
VISUALIZE returns TYPE table
So my questions:
1/ Where and how returns Shopify calculated number on Shopify Analytics?
2/ Why have discrepancies between order details and Shopify Analytics? Shopify managed all raw data and still create discrepancies reports vs real number, how we can use Shopify data to make decissions?
3/ This is not 1 case only, alot of orders we extracted from Shopify REST API and have discrepancies, Shopify API = Shopify order details but <> Shopify Analytics.
Please help.