Kryptronic Info Center

The Info Center has articles on everything you need to get your site up and running with Kryptronic software. Hundreds of articles are available which contain tips, tricks, software updates and release notes, and everything you ever wanted to know about eCommerce, but were afraid to ask...

Kryptronic

Site Doctor: Adding Currencies

Adding currencies to the online store is quick and easy using the management interface.

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

INSERT INTO core_selectcustom VALUES('core.currency.AUD','core','core.currency','Australian Dollars','AUD','1')

Once you’ve finished, access:

System > Component > Settings > Currency Settings: Conversions and Symbols

To manage the new currency you’ve added.

Kryptronic: Security. Stability. Reliability