Reset all prices to zero?

[Cookiepus]

Hello
Wonder if there's any way to do this.
I know how to hide/turn off prices using config/my store/
but i need to reset them all to zero.
doing products one by one at the min.
gonna be here for days
Thanks
Cookie

[Ajeh]

Backup your database ...

If you really want to set ALL Products to the Product Price of $0.00 ... in the Tools ... Install SQL Patches ... you can run:

UPDATE products SET products_price = 0;

Then go to the Tools ... Store Manager ... and run the:
Update Product Price Sorter ...

[Cookiepus]

Thanks Ajeh
that worked great!
you've saved me hours of clicking.
Now, i've just got to turn on 'Product is Call for Price'
on each of my 300 items

if only there was some way.......

Cookie

[Ajeh]

To mark ALL Products as Call for Price use:

UPDATE products SET product_is_call = 1;

[Cookiepus]

WWhooo -hooo!