currency problem

Started by tanviet12, October 13, 2013, 08:36:13 AM

tanviet12

Hi all,

My Hostbill default currency is VND (Vietnam Dong, 21000 VND = 1 $). When i use Paypal for checkout, the amount ( VND) doesn't convert to $ and it wrong. I try create additional currencies  USD (In Setting --> General Setting --> Additional Currencies) but I cannot assign rate with value 0.000047619 ( 1 VND = 0.000047619 USD). I found type of colum rate in table hb_currencies is decimal(10,4) :-[ .

mysql> describe hb_currencies;
+--------------+---------------+------+-----+---------+----------------+
| Field        | Type          | Null | Key | Default | Extra          |
+--------------+---------------+------+-----+---------+----------------+
| id           | int(11)       | NO   | PRI | NULL    | auto_increment |
| code         | varchar(4)    | NO   | UNI | NULL    |                |
| sign         | varchar(4)    | NO   |     | NULL    |                |
| iso          | varchar(4)    | NO   |     | NULL    |                |
| rate         | decimal(10,4) | NO   |     | 1.0000  |                |
| last_changes | datetime      | NO   |     | NULL    |                |
| update       | tinyint(1)    | NO   |     | 1       |                |
| enable       | tinyint(1)    | NO   |     | 1       |                |
| format       | varchar(16)   | NO   |     | NULL    |                |
+--------------+---------------+------+-----+---------+----------------+

Can everybody help me use paypal and add new USD currency?

Thanks in advance!

tanviet12