UPDATE ps_product SET 'active' = 0 ?

[webbusiness23]

Hi,

 

Does anybody know how to update several products using SQL query?

I need to set them inactive. I tried this query but with no result on front office:

UPDATE `ps_product` SET `active` = 0 WHERE `reference` IN ("product-code-1","product-code-2")

I'd really appreciate your help.

[vekia]

hello

table that you have to alter is ps_product_shop

[samuel89]

Is there a way to do it throught code?

any function like setProductShopActive?

 

Thanks.