Try the Demo

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
Magento Team
 
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'
);

 Signature 

http://www.igentics.com

Igentics are Internet Engineers, we like to look at things from a different angle. The end result being a fully integrated system encompassing the whole supply chain from supplier to end user, incorporating all legacy systems and data. This increases profits and reduces cost.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top