Easy Fill Products Quantity?

[scottct1]

Hi there, I have a big store with lots of items.

 

Up until now we have not been using product quantites in our store, however now we are getting a very popular product and will be getting a limited supply and we want to make sure we don't get more orders then we have stock.

 

All the times in our store now have nothing listen in the Products Quantity box.

 

If I go into the stock control panel and turn on Check stock level, Subtract Stock, & Allow Checkout and someone orders any of the items which have nothing listed in the product quantity box they are allowed to buy it, however after they check out that item is removed from the store. (The Green Indicator in the Catalog turns to RED)

 

So my question is, is there any way to populate the Product Quantity for every item to a certain number (such as 1000)? Maybe a mysql query? Any ideas?

[Enrico]

I would use phpMyAdmin, but I am not a sql expert. Pretty easy to use.

 

Anyone else??

[♥yesudo]

Try:

 

UPDATE `products` SET `products_quantity` = '1000';