Having different prices for different countries

Hi

We are extending our webstore to Europe and need to have different price for that , so far we had prices in USD for canada and US , so I know that there is rates to convert usd to Euro ,but we don't want to use that , what we want to do is basically having different prices for Europian customers.
So what I was thinking was to add a new field for Euro price in the productVariant table in the database ,
and when showing the price depending on which country is the customer registered from , they will see the price for that country.

I need to know is this the only solution or there are other alternatives that are easier to do,
Considering that there will be a lot of changes needed to a whole bunch of files and the database structure as well.
Has anybody ever done this or something similar to this ?

[email protected] wrote:
Here are my 2 cents: I would use tiered (evene if they are not tiered) prices (allways in USD) by customer role ("North American" and Europeean) and define (with some customization) the corresponding role when customer registers/updates his information.
Another simple way is to have 2 stores one for Europe in euros and the other for Northamerica and at entrance customer decides which one to visit (Amazon does that).In this manner you can even have different products, shipping/payment methos, etc.

Thank you so much, I used your first solution and it works for me . I think your solution is really easy and should work fine in future too.