How can I include original sale currency in my reports?

Shopify Discussion
1

Hello,

I am looking for a report that consists of the story currency and the payment currency. The store is set up with USD currency and the payout is done in CAD. For CAD customers, the sale and payment are done in CAD but they appear as USD when I export the Orders report. Is there any way to include a column for the original sale currency (or the payment currency)?

2

Shopify API provides two numbers shop_money and presentment_money, which means that payment currency is stored and available for reporting.

You can get such reports with our Advanced Reports app

  • our team will configure such a report for you.