Drop-down Currency Box

[jeffuk123]

Hi

 

I would like to change the drop-down currency box to display GBP at the top, please can you help?

 

Thank you,

Jeff

[dmnalven]

Have you set GBP to be the default at admin Configuration -> Localization -> Currencies ?

 

Or are you trying to reorder the additional choices?

[cevenson]

I have a similar problem

 

USD is at the top but my default currency is New Zealand Dollars

 

Does any one know how to re-order the list?

[failsafe]

It looks like the currencies are listed in the order that they appear in the database, so getting the order you want is as simple as reordering the database currencies table. If you have access to phpMyAdmin you could just update the database using the raw SQL commands something like this...

 

TRUNCATE TABLE `currencies`;
INSERT INTO `currencies` VALUES (0, 'New Zealand Dollar', 'NZD', 'NZ$', '', '.', ',', '2', 2.70830011, '2008-09-16 13:17:31' );
INSERT INTO `currencies` VALUES (0, 'Australian Dollar', 'AUD', 'AU$', '', '.', ',', '2', 2.20700002, '2008-09-16 13:19:21' );
INSERT INTO `currencies` VALUES (0, 'Euro', 'EUR', '€', '', '.', ',', '2', 1.25899994, '2008-09-16 13:19:20' );
INSERT INTO `currencies` VALUES (0, 'British Pound', 'GBP', '£', '', '.', '', '2', 1.00000000, '2008-09-16 13:19:20' );
INSERT INTO `currencies` VALUES (0, 'US Dollar', 'USD', '$', '', '.', ',', '2', 1.79709995, '2008-09-16 13:19:19' );

Specifying an index of 0 for each line means SQL auto-increment will apply the new lines starting at 1, then 2, etc. The order in the pull down menu would then reflect the order you put above. As far as I can see, osC uses the 3 letter currency code and not the index in the database to record info about currencies, so this should work even for a shop that's been running for ages.

 

Make sure you put the exchange rates for your default currency though (or update them in the admin back office straight afterwards). The ones listed above are for GBP as my shop is UK based. :)

[cevenson]

Cool. I'll give it a try tomorrow