Wholesale Reduction of Prices

I saw a sql command on here earlier to increase all prices at one, which was UPDATE #__hikashop_price SET price_value = price_value * 1.35;

If I wanted to reduce all prices at once, say by 33%, would it be UPDATE #__hikashop_price SET price_value = price_value / 0.33;?

An easier and a lot safer, would be to export products to csv, increase/decrease price, then do an iport; either the cvs back again or just via text import of the product name, prod code and new price.

I tend to agree and that's the way I went. Much more tedious but I keep my master csv accurate, then re-import it.

I think I found the correct query though, I believe to reduce all prices by 33%, it would be UPDATE #_hikashop_price SET price = price*.66;

Thanks.

You will have to use: UPDATE #_hikashop_price SET price_value = price_value*0.66;