SQL query to set all products quantity to 1

[skynetslo]

I've just entered hundreds of items withouth setting their stock. Sincer I want them to allways be in stock I need to set the quantity for each product to 1. Since it's much easier then doing it 1 by 1, how can I do this with sql command?

[RodG]

I've just entered hundreds of items withouth setting their stock. Sincer I want them to allways be in stock I need to set the quantity for each product to 1. Since it's much easier then doing it 1 by 1, how can I do this with sql command?

update `zen_products` set `products_quantity` = 1 WHERE 1 ;

You may need to change " zen_products" if your database uses a different prefix.

If SOME of your products already have quantities, a better command would be

update `zen_products` set `products_quantity` = 1 WHERE products_quantity = 0 ;

Cheers
Rod

[skynetslo]

Thank you very much RodG!

[swguy]

But be sure to turn off Admin->Configuration->Stock->Subtract stock to false.