Allow Out of Stock Order on old products.

[imi.mehesz]

Hy,

 

I add hundred of products in admin. Now the client request is, to allow Out of Stock order.

 

It's simple, i configure this here: Preferences -> Products and change the Allow ordering of out-of-stock products status to Yes.

 

My problem is, this change not applied to old products. If i check all products added before this setting, the default status under  Quantities section is When out of stock: Deny orders.

 

If i add a new product, the change will applied.

 

How can i change this status on all old products, added before set the Out of Stock order setting.

 

Thanks,

Imi

[polosat]

You can update your products directly in database. Use phpMyAdmin to execute the following query:

UPDATE `ps_product`
SET `out_of_stock` = 2;
UPDATE `ps_stock_available`
SET `out_of_stock` = 2;

Change "ps_" to your prefix and don't forget to create a backup:)