Exchange rate not saved

  • Posts: 44
  • Thank you received: 1
2 years 4 months ago #343392

-- 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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
2 years 4 months ago #343397

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

Last edit: 2 years 4 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 44
  • Thank you received: 1
2 years 4 months ago #343421

Not saved

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
2 years 4 months ago #343435

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

Last edit: 2 years 4 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
2 years 4 months ago #343442

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.

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
The following user(s) said Thank You: Philip, Alex3

Please Log in or Create an account to join the conversation.

  • Posts: 44
  • Thank you received: 1
2 years 4 months ago #343444

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

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 4 months ago #343454

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.077 seconds
Powered by Kunena Forum