How to change currency on a placed order?

[Reckie]

Would like to swap the currency on a order that has already been placed as it turns out the reciving country will only accept COD-parcels in their own currency.

 

Ive already got the currency setup within the webshop, just trying to figure out how to change it on an already place order? Could I change this within the database or can it be done from the admin pages?

[Guest]

you can do it from the database via phpmyadmin or whatever client you use

 

 

or an easier alternative is to use the order editor: http://www.oscommerce.com/community/contri...,all/search,eww a while back i had added the ability to edit the currency used on the customer's order

[Reckie]

you can do it from the database via phpmyadmin or whatever client you use

or an easier alternative is to use the order editor: http://www.oscommerce.com/community/contri...,all/search,eww a while back i had added the ability to edit the currency used on the customer's order

 

I use an earlier version of the order editor but will try with phpadmin.

 

Will it recalculate the total based on the new currency or does it just swap the currency?

 

Example

 

Total of 100 USD

change to EUR

will it still say 100 EUR or does it recalculate the sum based on the currency conversion factor?

[Guest]

in order for it to recalculate the order i believe you must also enter the new currency value, which would be in the same table where you would change the currency abbreviation.