Display, checkout with different currency than default

[jami1955]

There is plenty on displaying different currencies, but so far I have not encountered this issue: I have product coming exc. fr Europe, and selling in the US. The default currency needs to be US$. But in order for me to update my prices when the exch. rate changes (which is almost daily) I have to go through the entire catalog and change each US$ price to match the new value.

What I would like is to be able to set my default currency to EURO, and then display and checkout only with US$. Then to update the prices when the exchange rate varies, I only go to the currencies page, click once on the "update currencies" button, and finished. Obviously this is to be preferred.
(I already installed the Display Different Currencies mod, but this requires displaying all prices in Euros and requiring the user to manually change it in the currencies menu. Not good.).

Any ideas on this?

thanks,
JSC
using Zen Cart v1.3.8a/v1.3.8

[wayunee]

I have same problem, i have my products from UK in Pounds, but need display it only in Euros.... nobody know any Sql code to solve it?
Thanks.