How to set a whole store with quantity 1000 ?

[lilly06]

Hi

I need help please, as my whole store is set as sold out! my whole quantity for all products are at 0 and i need the exact code for SQL to switch all quantity to 1000

i tried this code:
UPDATE products SET products_quantity = 1000;

bu nothing works.. my store is 1.3.9h i haven't updated it yet


Someone worked on my store for me and this morning the whole quantity changed, and i don't know when this person will be able to help, i need assistance as soon as possible

Thank you for the help!!!

[stevesh]

I got this from RodG in another thread, and it worked on my 1.5.0 test site:

UPDATE `products` SET `products_quantity`= 1000 WHERE 1 ;

[lilly06]

OMG!!! thank you so much!!!!!!!!! it worked like a charm!!! so it also work for 1.3.9h!