Disable multiple products - SQL query (Presta 1.6)

[webbusiness23]

Hello,

I need to disable (in my Prestashop 1.6) multiple products using an SQL query.

I've tried this so far: 

UPDATE `ps_product` SET `active` = 0 WHERE `id_product` IN (10548,10554);

The result was: 

"2 rows affected. (Query took 0.0003 seconds.)"

but actually the products are still active.

 

What to do next?

[musicmaster]

You should do the same in ps_product_shop

[webbusiness23]

44 minutes ago, musicmaster said:

You should do the same in ps_product_shop

Thanks, this solved my problem.