If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / making the same change to all of my products

making the same change to all of my products

Started by craftzombie on 1 Oct 2011, 2:05 AM · Views: 696

Results 1 to 7 of 7
1 Oct 2011, 2:05 AM
#1
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

making the same change to all of my products

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! :unsure:

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!!

1 Oct 2011, 2:14 AM
#2
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,874
Plugin Contributions:
8

Re: making the same change to all of my products

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.

1 Oct 2011, 2:19 AM
#3
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: making the same change to all of my products

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. :smile:

1 Oct 2011, 3:30 AM
#4
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: making the same change to all of my products

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.

1 Oct 2011, 3:51 AM
#5
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: making the same change to all of my products

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 ;

1 Oct 2011, 5:49 AM
#6
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: making the same change to all of my products

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 ;

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

2 Oct 2011, 8:26 AM
#7
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: making the same change to all of my products

Thank You!!!!!