making the same change to all of my products

[craftzombie]

I am wondering if there is a way to make a single change to all of my products that would produce the same result and if I can do so with a script by entering it into admin>install sql patches. I want to change the quantity of ALL of my products to the same quantity. If it can be done, I am asking if someone who knows how to write such a script would post it here for me because I have no clue!

I normally use Quick Updates to make changes, but since I am looking to make changes to thousands of items, I was wondering if there was a script I could run in admin>install sql patches that would apply these changes to the database quickly. Also, if this can be done with quantity, can it also be done with prices (make all products the same price) and with product descriptions?

Any help is greatly appreciated!!

[gjh42]

Yes, it can be done, easily. I don't have the references here to figure out the exact SQL statement to use, but someone who does can post it.

[craftzombie]

Thanks for responding. I thought that it could be done but I wasn't sure so at least now I know! Hopefully I can get someone to write it up for me.

[craftzombie]

Well, I tried to figure out how to do it myself by following the instructions here, but it didn't work. I got all excited for nothing. Now it's time to take a break and go scream for a while.

[craftzombie]

Okay, instead of screaming, I took a look at the Dual Pricing sql as an example and noticed I was a little off in typing out my code. Once I made a few changes, it worked! I was able to change the quantity of all of my products by entering:

UPDATE `products` SET `products_quantity = 500` ;

[gilby]

Okay, instead of screaming, I took a look at the Dual Pricing sql as an example and noticed I was a little off in typing out my code. Once I made a few changes, it worked! I was able to change the quantity of all of my products by entering:

UPDATE `products` SET `products_quantity = 500` ;

Might work better like this
UPDATE `products` SET `products_quantity` = 500;