How do I export international prices (presentment prices) of Shopify product variants?

If you have International Pricing (Multi-Currency) enabled in Shopify or if you use Shopify Markets, you can export the equivalent variant prices in different currencies as part of your product data export with EZ Exporter.

Please note this will only export the current equivalent prices in the other currencies, it won't export the prices after applying price adjustment rules.

On the Shopify backend, this data is stored in a single field called variants.presentment_prices as JSON data.

To create separate columns for the prices in different currencies, you can use a formula like this under the Calculated Fields section in the Data Settings:

search_attributes({{ variants.presentment_prices }}, "EUR", search_key="price.currency_code", result_key="price.amount")

The above will pull the value of the variant's price in EUR.

To pull the compare_at_price in EUR, just replace price. with compare_at_price.:

search_attributes({{ variants.presentment_prices }}, "EUR", search_key="compare_at_price.currency_code", result_key="compare_at_price.amount")

Simply repeat the formula to export the amount in other currencies, replacing "EUR" with the desired currency code.

The output will look something like this:

At the moment, the Shopify API only supports international pricing by currency code and not by country code.  So it's currently not possible to pull prices based on the country code.  You'll always need to specify the 3-letter currency code.


App: EZ Exporter

Tags: advanced features, product feeds, shopify plus, shopify international pricing, shopify multi-currency, shopify markets