Change Currency After Products Have Been Added

I have begun setting up a site and the client added a range of products and categories before I had set the default currencies etc. All prices are currently in euros. The site should be in £. I then changed this and unpublised all currencies except the £. The problem now is that all products are now shown as free. Is there a way to update all products to £ without manually changing each product?

Dave

Hi there,

You can use a SQL query on you database trought the interface of your phpmyadmin (community.mybb.com/thread-4720.html).
The request will look like this:

UPDATE im4hp_hikashop_price
SET price_currency_id=4

Spot on thanks very much for your help!!!

Dave