How to add another currency in Customer & Business Manager of Parallels Plesk Panel (former Plesk Billing or ModernBill)

Created:

2017-06-05 05:24:54 UTC

Modified:

2017-06-05 05:24:54 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to add another currency in Customer & Business Manager of Parallels Plesk Panel (former Plesk Billing or ModernBill)

Applicable to:

  • Plesk
  • Plesk Billing

Resolution

Though Customer & Business Manager might not include some of the world currencies out of the box, any currency can be easily added. Please follow the intructions below:

1. Enter the host where Customer and Business Manager (formerly known as Plesk Billing or ModernBill) installed

2. Connect to Plesk Billing database. Execute the command below if Customer and Business Manager is installed on Unix machine (root access is required):
# /usr/share/plesk-billing/billing-db

In Windows first of all run

> "%plesk_bin%\dbclient.exe" --direct-sql --sql="select admin_password from databaseservers order by id asc limit 1"

to find out a password for Customer and Business Manager database. Then run:
>"%plesk_dir%\mysql\bin\mysql -uadmin –p<cbm_db_password> billing

3. Now you see MySQL client prompt. You can validate the connection by executing the query below
mysql> select * from currencies;
and getting output like
+-------------+---------------+--------------------+
| currency_id | currency_code | currency_name      |
+-------------+---------------+--------------------+
| AUD         | 036           | TRANS_CURRENCY_AUD |
| CAD         | 124           | TRANS_CURRENCY_CAD |
| EGP         | 818           | TRANS_CURRENCY_EGP |
| EUR         | 978           | TRANS_CURRENCY_EUR |
| GBP         | 826           | TRANS_CURRENCY_GBP |
| HKD         | 344           | TRANS_CURRENCY_HKD |
| JPY         | 392           | TRANS_CURRENCY_JPY |
| MXN         | 484           | TRANS_CURRENCY_MXN |
| RUB         | 643           | TRANS_CURRENCY_RUB |
| SEK         | 752           | TRANS_CURRENCY_SEK |
| SGD         | 702           | TRANS_CURRENCY_SGD |
| USD         | 840           | TRANS_CURRENCY_USD |


4. Insert the new currency. You will need 3-letter currency code (like USD for United States Dollar or PHP for Philippine Peso, etc), 3-digit numeric code (like 840 for United States Dollar or 608 for Philippine Peso) and currency name. Currency codes can be obtained from ISO 4217 (specifying wrong code may cause improper showing currency symbol and other issues). Below is a sample query:
mysql> replace into currencies (currency_id, currency_code, currency_name) values ('PHP', 608, 'Philippine peso');

Have more questions? Submit a request
Please sign in to leave a comment.