Forums / Setting Up Categories, Products, Attributes / bulk update price

bulk update price

Results 1 to 2 of 2

8 Dec 2013, 10:10 PM

New Zenner

I want to change prices of products marked at $22 to $25 I am using this

UPDATE products SET products_price = 25 WHERE products_price = 22; ,

but prices are not changing.... umm any idea?

all my products are priced by attributes

if SQL is not the answer to this, then is there any other solution?

Thanks

8 Dec 2013, 10:23 PM

New Zenner

Re: bulk update price

YAY!!!!!!!! did it!!!
UPDATE products_attributes SET options_values_price = '25.0000' WHERE options_values_price = '22.0000';