If you’ve recently changed your shop’s currency in Shopify, you may notice differences between the sales figures shown in the Shopify Platform and those reported in ReportGarden. This is due to the way Shopify handles currency conversions for past orders.
Why the Discrepancy Occurs
Shopify Platform
The Shopify Admin displays all orders—both past and new—in the current shop currency. For older orders placed in a different currency, Shopify automatically converts them to the new currency for display. However, this conversion is internal and not consistently reflected in the data Shopify provides through its API.
Shopify API
When ReportGarden (or any external app) retrieves order data via the Shopify API, it receives the original order values in the currency they were placed in.New orders (after the currency change) are returned in the updated shop currency.
Older orders (before the currency change) are returned in their original currency.
Impact on ReportGarden Reports
Because ReportGarden relies on Shopify’s API, it receives a mix of currencies for orders placed before and after the change. This results in discrepancies when comparing sales figures against the Shopify Admin panel.
It’s important to note that programmatically converting historical orders to the new currency is not reliable, since Shopify does not provide the exact exchange rates it used internally. Attempting to convert these values manually or automatically would lead to inaccuracies.
Key Takeaway
If your Shopify store’s currency has been changed, expect differences between Shopify Admin and ReportGarden reports. These discrepancies are expected behavior due to the way Shopify manages and reports currency conversions.