Change thousands products currency at once, according to specified exchange rate

[AzMandius]

Hello,
I currently have thousands of products in euro. I use only one currency in my shop.
I am about to move my shop to a different country where USD are only used. I would like to switch shop from euro to USD completely, no multi-curency selection on front-end. Creating a US dollars currency in virtuemart is not hard, but going through each product manually and changing product currency from euro to USD, considering that i have thousands of items, is insane.
My question is: is there a plugin or SQL command that would allow me to change currency for all products at once from euro to USD according to a specified exchange rate?
Thanks a lot and holiday greetings everyone.

[jenkinhill]

On the Shop/Vendor tab change the shop currency to USD. The existing cost prices in the BE will show the price in Euro, but is converted into USD for other BE prices and display n USD on the front end.

[GJC Web Design]

but your product price will need to change as well or are u keeping a 1:1 €->$ price ?

then just in the xxxx_virtuemart_product_prices .. backup first

UPDATE `xxxx_virtuemart_product_prices` SET `product_currency`= 144

[jenkinhill]

The product prices are automatically converted to the USD prices according to the exchange rates - which may change daily. I have used this for a client store where he buys almost all products in Euros, but retails only in GBP. He just has to enter the Eu cost price when entering products and VM does the conversions. Or for products bought in GBP he sets the cost currency for that product to GBP.

[AzMandius]

but your product price will need to change as well or are u keeping a 1:1 €->$ price ?

No, unfortunately is not 1:1, so i guess I'll experiment with jenkinhill's suggestion.
Thank you guys I'll get back as soon as I'll complete the change.

[GJC Web Design]

you can also do a multiply query directly in the DB

[AzMandius]

Thanks a lot everyone, jenkinhill your advice worked perfectly.
Regards.