Change Product Quantity in All Products at once

[LadyMorgana]

Hello!
Is there a function to update the quantity number of all the products at once? I had my website created by another and it came with about 1000+ pre-installed products. They did not enter any quantity amounts for the products. Now that I want to be able to use a "sold out" button instead of the "add to cart" button when a product is out of stock and on backorder, I cannot use that function in the stock area of admin because the products do not have a quantity attached to it, all quantities were left empty.
So to be able to use the "sold out" button I need to give every individual product on our website a quantity number and if I do not have to do that to each product individually and can use a universal function to make all products have a quantity number I would be elated!!!
Does anyone know if that can be done? I think I looked at all options and feel frustrated that I may have to go through each of my products one by one to use that "sold out" choice - UGH!
Thanks!
Bradley

[charmedbytina2]

Have you looked into Easy Populate for this?

http://www.zen-cart.com/index.php?ma...roducts_id=395

Tina

[kobra]

So to be able to use the "sold out" button I need to give every individual product on our website a quantity number

To effectively use this functionality you need to track your stock and entering one universal value defeats this purpose...you need to enter your actual stock so that when you are out it will indicate "Sold Out"

As charmed stated EP is a tool many use for this but can be difficult to grasp how to use at first but there is a support thread with many answers for it

[LadyMorgana]

Thanks for the info.
I do not carry any stock at all, therefore I would not have to worry about tracking actual quantity values. Using a "universal" value for me would work. For me I would use the "Sold Out" button to appear when I am notified by suppliers that an item is on backorder, then I would manually take the quantity to 0 to show the product with a "sold out" button and use the date expected option with it so customers know when it is expected to be back in stock.
I guess maybe my store is unique because I do not carry any stock??

[kobra]

First BACKUP your DB...BACKUP your DB...BACKUP your DB...


Then in your admin > tools > sql patches > paste the following - setting the value to what you want

UPDATE products SET products_quantity = 500;

[LadyMorgana]

Thank you!
That worked beautifully..............

Sorry for the double posting of the question - after I posted I realized there was a different category better suited to post it to.
Bradley

[ksookma]

First BACKUP your DB...BACKUP your DB...BACKUP your DB...


Then in your admin > tools > sql patches > paste the following - setting the value to what you want

UPDATE products SET products_quantity = 500;

THANK YOU!!! this saved me a ton of time because there are 10k items easy populate would have taken forever!