Kryptronic Software Wiki : CCP7AddingCurrencies

Kryptronic Internet Software Solutions
Most recent edit on 2012-01-06 09:23:12 by KryptronicWebmaster

Additions:
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.')
System > Component > Settings > Currency Settings: Conversions and Symbols
To manage the new currency you've added.


Deletions:
INSERT INTO core_settings VALUES('core.currsym.AUD', 'Australian Dollars (AUD): Currency Symbol', 'core', 'Currency Settings: Conversions and Symbols', 'TEXTBOX-REG', , '1', '.', 'Enter the currency symbol for the Australian Dollars (AUD) currency. This symbol is appended to amounts shown in the Australian Dollars (AUD) currency.')
System > Component > Settings
And manage the new currencies under:
Currency Settings: Conversions and Symbols




Oldest known version of this page was edited on 2012-01-06 09:22:12 by KryptronicWebmaster []
Page view:

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', '.', '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

And manage the new currencies under:

Currency Settings: Conversions and Symbols


ClickCartPro 7 and EuropaCart 7 - System Component
ClickCartPro 7 and EuropaCart 7 - Website Component