 |
|
Adding Currencies
In the management interface, go to:
System Dashboard > System > Database > Raw Database Admin
Then access the Submit Raw SQL Statement function. For each currency you wish to add, execute the following SQL statements, one at a time, replacing the string 'AUD' with the abbreviation for the currency, and 'Australian Dollars' with the name of the currency:
INSERT INTO core_settings VALUES('core.currcdp.AUD', 'Australian Dollars (AUD): Decimal Character', 'core', 'Currency Settings: Conversions and Symbols', 'TEXTBOX-REG', '', '1', '.', 'Enter the decimal character for the Australian Dollars (AUD) currency. This character is used in amounts shown in the Australian Dollars (AUD) currency.')
INSERT INTO core_settings VALUES('core.currconv.AUD', 'Australian Dollars (AUD): Conversion Rate', 'core', 'Currency Settings: Conversions and Symbols', 'TEXTBOX-REG', '', '1', '1.000', 'Enter the conversion rate for the Australian Dollars (AUD) currency. This rate is used with amounts stored in the Base Currency to arrive at an amount for this currency to display to customers. Calculation: (Base x Rate = Display)')
INSERT INTO core_settings VALUES('core.currcth.AUD', 'Australian Dollars (AUD): Thousands Character', 'core', 'Currency Settings: Conversions and Symbols', 'TEXTBOX-REG', '', '1', '.', 'Enter the thousands character for the Australian Dollars (AUD) currency. This character is used in amounts shown in the Australian Dollars (AUD) currency.')
INSERT INTO core_settings VALUES('core.currsym.AUD', 'Australian Dollars (AUD): Currency Symbol', 'core', 'Currency Settings: Conversions and Symbols', 'TEXTBOX-REG', '', '1', 'AUD', 'Enter the currency symbol for the Australian Dollars (AUD) currency. This symbol is appended to amounts shown in the Australian Dollars (AUD) currency.')Once you've finished, access:
System > Component > Settings > Currency Settings: Conversions and Symbols
To manage the new currency you've added.
ClickCartPro 7 and EuropaCart 7 - System Component
ClickCartPro 7 and EuropaCart 7 - Website Component