Changing "available for order" status to group of products

[angel_aparicio]

I have a Prestashop 1.5. I need to put as unavailable for order all products from certain categories. I can do this in the backoffice, but there are a lots of products. I have tried this query in the database:

 

UPDATE ps_product SET available_for_order = 0 WHERE id_category_default IN ( 31, 24, 26, 54 );

 

It doesn't work. The products are still available for orders. Can I do this without change manually each products in the backoffice?

 

Thanks.

 

[angel_aparicio]

Ok, I need to update the table ps_product_shop:

 

UPDATE ps_product_shop SET available_for_order =0 WHERE id_product IN (
SELECT id_product
FROM `ps_product`
WHERE id_category_default
IN ( 31, 24, 26, 54 )
);

[csschopper.com]

Hi,

 

You need to Join  2 tables product_shop & product then will have to update product_shop table.

 

Thanks

Alok

[csschopper.com]

You already did it. .. great