Change currency but keep store prices

Hi, I need to change the default currency but keep the current store prices the same, for example, if an item is 3.99 in USD and I change it to EURO as default, the price changes to reflect the EURO but I would like all the stores prices to stay as they were. Is there any way at all to keep the prices as they are and change the default currency?

Thank you.

The fact that this does not make commercial sense, does not mean it can't be done.

But I have to ask...

If I price my goods in UK Sterling, then want to reflect the same numerical value for Zambian Kwatcha... I will surely become backrupt overnight.

1 UK Pound will buy me about 8,000 Zambian Kwatcha. So I will be making a loss of about 99.99% if I sell a product valued at £1, and the buyer decides to swop to Kwatchas and pay 1 Kwatcha.

But if you are insistent, all you need do is give all currency values the same value: 1.000000000 in the currencies section of the admin panel, and then to make sure you never do a currency update.

Ok, thank you very much indeed.

It's just that our store has been undercharging for some time now and we wanted to change to EUROS and keep the same price for all products in the store, there's far too many to change manually!

You should not use a screwdriver to hammer in a nail... Don't manipulate the CURRENCY function to effect a PRICE CHANGE.

You will end up in a mess...

If you need to globally increase your prices all by the same factor, then a simple SQL command (run through "Install SQL Patches") will achieve this in under 1 second.

If, for example, you wanted to increase ALL product prices by 15%, then just run the following line in the "Install SQL Patches" feature (ADMIN >>> TOOLS >>> Install SQL Patches).

UPDATE products SET products_price = products_price * 1.15;

(This says... "Go into the products table in the database and find the field with prices, then take the existing price and multiply it by 1.15")

ALL your product prices will then be 15% higher than they are now.

Thank you very much schoolboy, I will do that then.

If at any point I wanted to undo the price increase how would I go about reversing it?

Thanks for your time.