- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a multiple store setup of and each store has a different currency.
How can I bring their sales data into one report and normalize the currency to USD.
Is there a table that has all the currency conversions and update constantly that I can bring in?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi saiadharap71b3,
Thank you for reaching out to us.
Adobe Commerce Intelligence (aka MBI) has a built-it feature to convert currency within Data Warehouse section.
To implement it, you can create calculated column that make use of automatic conversion and store the converted value as an additional column to the same table (for example sales_order).
Adobe Commerce Intelligence Team
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Each of my stores has a differnt currency. How do I bring them all into one report / currency?
It kind of depends if you have multiple currencies or multiple base currencies. In any case, such reporting is best handled by systems outside of Magento. You can use APIs or export your data into your preferred business inteligence system.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Each of my stores has a differnt currency. How do I bring them all into one report / currency?
Hey! So I'm using Adobe BI already, does it have this functionality built in somewhere?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi saiadharap71b3,
Thank you for reaching out to us.
Adobe Commerce Intelligence (aka MBI) has a built-it feature to convert currency within Data Warehouse section.
To implement it, you can create calculated column that make use of automatic conversion and store the converted value as an additional column to the same table (for example sales_order).
Adobe Commerce Intelligence Team