global stock update

[bigbadboy]

Can't find the answer to this anywhere so I thought I'd ask.

What's the easiest way to globally update the stock quantity.
I have around 500 products.
The products will never run out or will have different quantities so the easiest is to set all to '1'

What I don't want to do is go through each one individually and update the quantity.

Is there a way to do this via PHPMyAdmin (easy populate doesn't work for some reason).

[Ajeh]

You could run this in the Tools ... Install SQL Patches ...

This will set all Product Quantity to 1:

UPDATE products SET products_quantity = 1;

[bigbadboy]

Ah! Excellent (as usual).

Thanks loads.