Hello everyone.
I write my own script to deactivate the products in my shop. SQL:
1) "UPDATE ps_product SET active=0, redirect_type=404 WHERE id_product IN (".implode(',',$itemsDeactivate).")";
2) "UPDATE ps_product_shop SET active=0, redirect_type=404 WHERE id_product IN (".implode(',',$itemsDeactivate).")"; Query works fine, but when I refresh the page these products continue to see.
What am I doing wrong - help.