[Skip to main content](#vessel-content) # Sales reports for multi currency store ## - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 7 years 2 months ago - 7 years 2 months ago [\#310711](#310711) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") *[Sales reports for multi currency store](/forum/36-reports-statistics/898255-sales-reports-for-multi-currency-store#310711 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.2.22 Hi, We have a store that's set up to be multi-currency. We're trying to set up a table-based report to give some top-level info: * The total value of sales last month * The total value of sales in 2 cateories This has all been relatively straight forward, however, the results we get look to be in random currencies: How should this type of report behave with a multi-currency store? should it convert the values to the main store currency which is £? or does this work some other way? Thanks Kevin")* was created by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* -- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.2.22 Hi, We have a store that's set up to be multi-currency. We're trying to set up a table-based report to give some top-level info: - The total value of sales last month - The total value of sales in 2 cateories This has all been relatively straight forward, however, the results we get look to be in random currencies: [ ![screenshot-shop.newmodelarmy.org-2019.09.10-13_58_41.png](/forum/attachment/47658) ](/forum/attachment/47658 "...0-13_58_41.png") How should this type of report behave with a multi-currency store? should it convert the values to the main store currency which is £? or does this work some other way? Thanks Kevin - [ ![screenshot-shop.newmodelarmy.org-2019.09.10-13_58_41.png](/forum/attachment/47658) ](/forum/attachment/47658 "...0-13_58_41.png") [ ](/forum/attachment/47658?download=1 "...0-13_58_41.png") Last edit: 7 years 2 months ago by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgyNTUtc2FsZXMtcmVwb3J0cy1mb3ItbXVsdGktY3VycmVuY3ktc3RvcmU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 7 years 2 months ago [\#310712](#310712) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sales reports for multi currency store](/forum/36-reports-statistics/898255-sales-reports-for-multi-currency-store#310712 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.2.22 Hi, We have a store that's set up to be multi-currency. We're trying to set up a table-based report to give some top-level info: * The total value of sales last month * The total value of sales in 2 cateories This has all been relatively straight forward, however, the results we get look to be in random currencies: How should this type of report behave with a multi-currency store? should it convert the values to the main store currency which is £? or does this work some other way? Thanks Kevin")* Hi, If you edit the settings of one of the rows, you should have a setting to select the currency to take into account. I would recommend to select only one currency for each row. That way, you'll get a sum of all the orders in one currency. If you don't select any currency, or select several, then it will sum the amounts in different currencies together and the currency used for the display will be the one from the first order taken into account, so you don't want to do that if you have several currencies for your orders. The following user(s) said Thank You: [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgyNTUtc2FsZXMtcmVwb3J0cy1mb3ItbXVsdGktY3VycmVuY3ktc3RvcmU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 7 years 2 months ago [\#310757](#310757) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Replied by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* on topic *[Sales reports for multi currency store](/forum/36-reports-statistics/898255-sales-reports-for-multi-currency-store#310757 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.2.22 Hi, We have a store that's set up to be multi-currency. We're trying to set up a table-based report to give some top-level info: * The total value of sales last month * The total value of sales in 2 cateories This has all been relatively straight forward, however, the results we get look to be in random currencies: How should this type of report behave with a multi-currency store? should it convert the values to the main store currency which is £? or does this work some other way? Thanks Kevin")* Thanks, Nicolas, That's what I've ended up doing. Best KH Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgyNTUtc2FsZXMtcmVwb3J0cy1mb3ItbXVsdGktY3VycmVuY3ktc3RvcmU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)