The actual currency conversion values are stored in the currencyvalues table in the database.
Each row in this table represents a different currency.
The currency that has "1"in the conversionvalue field is the default currency and controls the master rate. So if your site is to display in Canadian dollars, then you would set the conversionvalue for Canadian to 1.
You can edit and add currency values to this table by entering your shop administration and going toAdvanced Settings > International >View/Edit Currency.
This page allows you to add a new currency or view and edit the existing currencies. The fields in the currency table are as follows:
|
cid |
The short name for this currency (eg. USD or AUD). |
|
Fullunitname |
The long name for this currency (eg. US Dollars or Australian Dollars). |
|
Conversionvalue |
The conversion rate to calculate this currency. |
|
Currencysymbol |
The symbol for this currency (eg. AU$ or £). |
|
Theimage |
The patch to the image of the flag for this currency. |
|
Hide |
True/False, whether this currency should be displayed on your site. |
Note: You can bulk update your table “Currencyvalues” by clicking on the Misc >Bulk Update link at the topmenu. This allows you to update all of your currencies at once.
Note: You can import new currencies into the currencyvalues table by going to Misc >Bulk Import. To see what the table needs to look like, you can export the currencyvalues table first as a csv file. X-Rates has an export to Excel feature that allows you to quickly copy and paste the rates into your csv file.