Changing thousands of items to one price

[travben1955]

I sell basically one item on the net but I have over 5000 items of the same product and wish to decrease the cost by $2.00. Do I have to edit each item or is there a way to change that field for the whole inventory automatically. As you might guess, mannually would take days of several people working.

 

Thanks for any help.

[swguy]

In phpMyAdmin, you can run the SQL query:

 

update products set products_price = products_price - 2;