Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Asian currency
 
yewjin
Jr. Member
 
Avatar
Total Posts:  20
Joined:  2007-09-06
Kuala Lumpur, Malaysia
 

First of all I want to say kudos to the people of Magento - I have used a lot of open source e-commerce and Magento exceeds all expectations.

I am living in asia and would like to build an ecommerce site for asia - e.g. thailand. However, I can’t seem to add an additional currency. Is there another way around this?

Appreciate your help and effort.

 
Magento Community Magento Community
Magento Community
Magento Community
 
YoavKutner
Guru
 
Avatar
Total Posts:  491
Joined:  2007-08-08
 

In this version one can only add currencies directly in the database. We will have an admin interface to manage currencies in future releases.

Thanks

yoav

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dan Orsborne
Member
 
Total Posts:  72
Joined:  2007-09-20
 

Here is the SQL script to add a currency to the database:

INSERT INTO `directory_currency_name` (
`
language_code` ,
`
currency_code` ,
`
currency_name` ,
`
output_format` ,
`
format_decimals` ,
`
format_dec_point` ,
`
format_thousands_sep
)
VALUES (
'en''GBP''British Pounds''£%s''2''.'''
);

INSERT INTO `directory_currency` (
`
currency_code
)
VALUES (
'GBP'
);

INSERT INTO `directory_currency_rate` (
`
currency_from` ,
`
currency_to` ,
`
rate
)
VALUES (
'GBP''GBP''1.0000'
), (
'GBP''CAD''2.0403'
), (
'GBP''EUR''0.69351'
)
, (
'GBP''USD''2.0415'
)
, (
'CAD''GBP''0.4901'
)
, (
'EUR''GBP''0.69351'
)
, (
'USD''GBP''0.4898'
)

UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =135;
UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =134;
UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =136;
UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =733;
UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =734;
UPDATE `core_config_dataSET `value` = 'GBP' WHERE `config_id` =735

INSERT INTO 
`directory_country_currency` (
`
country_id` ,
`
currency_code
)
VALUES (
'222''GBP'
);
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top