Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Currency problem : Changed default currency to EUR but price stay same with EUR


pardesi

Recommended Posts

Hello,

 

I want to chaneg my default currency to EUR but when I do so in Admin/currency it do chaneg my default currency but it dont convert the prices it is still showing old prices with Eur currency. How to convert then and keep euro ?

 

Thanks for your help

Link to comment
Share on other sites

The different currencies are all related to the default currency. For that reason there are the factors for each currency to convert the prices into another currency. So the default currency has always factor 1.0000. If you want to use EUR as default, you have to enter the prices in EUR.

 

But since you're in need of converting them use the following SQL statement within your database management tool:

 

UPDATE products SET products_price = products_price * 1.0987

 

where the number in the last place is the conversion factor.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...