Client currency issue for new registers WHMCS 8

[Inna]

Hello,

I'm not sure why this happens, but I'll try to explain it with an example.

 

I use WHMCS 8 (upgraded from version 7 to 8 recently), and I use one currency in fact. In the past the way I used to change prices was to have two currencies (USD and ABC for example), so I set the prices in USD and set conversion rate for ABC to 20, so that 1USD=20ABC. Now whenever inflation happens in my country, I just update the conversion rate and run Update Product Prices button Currencies settings. After prices are updated, I remove manually USD from database (which id is 1), so I only have one row (ABC with id 2).

In WHMCS 7, whenever a client registers and as the only currency is ABC, so whenever a client registers, its currency is set to id 2 (and I see that in database). But the issue happened after upgrading to version 8 with the exact same settings.

The issue is, client registers and the only dropdown option for currency is ABC, so he has no other choices. He registers with no issue, but in database I see its currency is set to id 0. The other issue related to this is when I want to add an order for him, the prices are fetch in WHMCS Admin in ABC prices (for example VPS1 plan with price 10000 ABC) is shown as 10000 (without any suffix/prefix), and other options like OS (free), Extra HDD and things like them that are dropdown menus, are not loaded (when I click on them it seems they have no options to see).

Now I refer to Profile page in Admin area, and I see currency is set to ABC (while in database it is id 0). When I click on Save Changes button with no changes, the problem solves. Currency id of this client changes to 2 in database, and without refreshing Add Order page, if I change the product and then go back to VPS1 or any other plan. Dropdown menu's options are loaded fine and other things related to it works fine.

I also should note that if both of above cases, I've added an order. The Order Confirmation email when id is 0, the price is like 10000.00, while when currency id is set to 2, it is 10,000 ABC (note the differences in format).

Default value of id 2 in database is set as 1 (which is to default currency).

 

I hope I explained it clear, as I did my best.

Would you please advise me where the problem is and how to solve that?

[Inna]

I also should mention that this issue is in the order form of Client Area too.

In https://mysite.com/store/ the clients can see the prices with format 10,000 ABC fine and there's no problem, but when they advance to the link like https://mysite.com/cart.php?a=confproduct&i=0, they see 10000.00.

I tried adding USD with id 1 in database and keeping ABC as id 2, and now in store link, the client can choose between USD and ABC and 10,000 ABC shows fine.

It seems the issue when I have only one currency (id 2, conversion rate 1, default 1), the suffix/prefix and format are not loaded, while having two currencies work fine.

I did remove all rows having `currency` 1 in tblpricing database, clearing cache and then check again, but it was still 10000.00.

[Inna]

It's solved by manipulating currencies and pricing table.