Exchange rate not saved

-- HikaShop version -- : 4.6.1
-- Joomla version -- : 4.1.5
-- PHP version -- : 8.1

I need to set the exchange rate 0,000043 But when saving it rounds up to 0.00004
I tried different decimal values but it doesn't work.
How to fix it ?

Hello,

I'm sorry for this return, but can you elaborate a little more your context.
For this, provide us these elements :
- Relative settings screenshot
- Details your needs, and what you want to achieved
- List your different test in order to allow us to try to reproduce your issue.

Awaiting your elements to progress on your subject.
Regards

Not saved

Hello,

Please, in order to allow us to analyze directly on your website the issue provide these elements :
- An Url link to your backend access
- Backend user references (with maximum Acl)

=> Use our Contact us form to provide these elements, and don't forget to add an Url to this topic in order to keep the link.
Regards

Hi Alex3,

The reason is the format of the database column, which by default is set to "decimal 16,5", meaning 5 decimals behind the dot.

So, to be able to save exchange rates with more decimals (e.g. 6 decimals as in your example), you'll need to change it in phpMyAdmin -> table "yourprefix_hikashop_currency" -> tab "Structure" -> column "currency_rate". Set it to 16,6 or 16,7 according to your needs, and then you'll be able to save and use an exchange rate of 0.000043 or similar.

Thanks for the answer! but why should I bother with it. Fellow programmers, please fix this.

Hi,

It's not a bug, so there is nothing to fix. It's a design choice we made when we first designed our software that there would be no need for more than 5 decimals for exchange rates.
Now, you're saying that 1 more decimal is needed in some cases. @lousyfool provided you with an easy solution for you to allow for it.

We'll look into changing this for new installations of HikaShop. But even if we add this change in the next version of HikaShop, this would change for you as it will only be for new installations of HikaShop. So you still need to do the modification via PHPMyAdmin if you need to enter more decimals than 5 in that setting.