Shopify revenue mixing USD, MXN, and EUR

Hi Sam,

Thank you for outling this inquiry- I’ll step in to provide some guidance on this subject!

What you are seeing is expected behavior: Klaviyo treats order value as a number and applies your account’s currency symbol. The currency/$value_currency field provides context, but it doesn’t convert amounts for standard dashboards, campaign or flow revenue, or attribution. So MXN 999 can be added as 999 to USD 34.98. Changing the account currency only changes the displayed symbol. Shopify syncs the value and should label the currency in the event data details, but Klaviyo will not automatically convert prices. 

At this time, there isn’t a Shopify integration setting that automatically converts these orders to USD. To keep international orders in your reporting, normalize their values before reporting on them:

• Use Klaviyo’s Currency converter code recipe (under Data management → Code → Recipes) or another integration/middleware process to convert each order’s value to USD.
  • Code integration: https://marketplace.klaviyo.com/en-us/apps/01hh5gk60cqv7pbd0sw1c2xmng/
  • Guide on Code integration: https://help.klaviyo.com/hc/en-us/articles/18620644491035#h_01JE40E7MAS736ZRPH3Q9V9NN5
• Keep the original amount and currency as separate event properties if you need them for reference.
• Report on the normalized event/metric, and avoid counting both it and the original Shopify event as revenue.

Klaviyo’s account currency setting won’t do the conversion. Benchmarks is a limited exception: it converts order revenue to USD, but that does not fix attributed revenue in standard reporting.

Additionally, historical orders won’t be corrected automatically by adding the converter, and this would only apply to new events. To correct historical reporting, you’d need a carefully planned backfill or rebuild of corrected order events, then use that corrected metric in reports. Since replacing or reimporting order history can affect existing metrics, flows, and segments, validate the approach before changing production data.