Help with SQL query

[Danielle]

Hi everyone,

I have a client who needs to change the prices of about 500 products. All of the products are currently $3.50 and they need to be changed to $4.50. All of the products are listed under one manufacturer. They do not want to change the prices of products from any other manufacturer. Is there an SQL query that they can run to change the price of all products from one manufacturer at one time?

I have this so far:

UPDATE products SET products_price=4.50 where products_price=3.50;

But the problem is it is not limited to a specific manufacturer, so it will change the price of ALL products that are currently $3.50. I'm not sure what I need to add to make it work...

Can anyone help?

Thank you!

[DrByte]

If you know the manufacturers_id for that manufacturer, you can specify that in your WHERE clause as well.

ie:

AND manufacturers_id = 2

[wtashby]

What about a query to increase all of your prices (for the entire cart) by a certain percentage? Say you wanted ALL the prices to go up by, 10% for example? Or 9% or 21%, whatever percentage you needed.

[misty]

What about a query to increase all of your prices (for the entire cart) by a certain percentage? Say you wanted ALL the prices to go up by, 10% for example? Or 9% or 21%, whatever percentage you needed.

http://www.zen-cart.com/forum/showth...d=1#post490420
Previous thread above should help