how 2 CHANGE THE PRICE TO MY ENTIRE CATALOG in one shot?

[Guest]

All items are 9.85 and I want to change them to 10 even.

 

I don't want to do it manually 1 by 1 so I thought I'd ask you geniuses how I could perhaps mod the database...

 

any help is appreciated.

 

freshpads.com

[♥Vger]

Access your database via phpMyAdmin (backup database first), run something like this (can't guarantee it) in the SQL window.

ALTER TABLE products SET products_price = '10.00';

 

Vger