Changing prices

[Paul...the...first]

Is there a way to increase all of the prices at once. Either by a % or a set amount.

I have 1000 products listed and to increase them one by one is not really a viable option.

[Ajeh]

You can backup your database and use something like:

Change all to $7.79

UPDATE products SET products_price = 7.79;

Add 5% to all prices:

UPDATE products SET products_price = products_price*1.05;

You should then run in the Tools ... Store Manager ... the Update Products Price Sorter ...

The Products Price Sorter is for setting the lowest price of a product to the products_price_sorter field for use on sorting and searches etc.