Try the Demo

Magento

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.

 
 
Posted: September 20 2007
   |  top
 
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

 
 
Posted: September 20 2007
   |  top  |  # 1 
 
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_data` SET `value` = 'GBP' WHERE `config_id` =135;
UPDATE `core_config_data` SET `value` = 'GBP' WHERE `config_id` =134;
UPDATE `core_config_data` SET `value` = 'GBP' WHERE `config_id` =136;
UPDATE `core_config_data` SET `value` = 'GBP' WHERE `config_id` =733;
UPDATE `core_config_data` SET `value` = 'GBP' WHERE `config_id` =734;
UPDATE `core_config_data` SET `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.

 
 
Posted: October 3 2007
   |  top  |  # 2 
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
Install successful but minor problem
THere is no "install" folder in the "zip" files...