My SQL Query to deactivate products in my shop.

[adrianwalerczak]

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.

[rocky]

Do you have caching enabled on the Advanced Parameters > Performance tab? If so, you'll need to click the "Clear cache" button.

[adrianwalerczak]

It works. Cool.

But I have to click on the "clean cache". How to do that work automatically in my script?

[adrianwalerczak]

https://www.prestashop.com/forums/topic/343407-clear-smarty-cache-automatically/

 

It works :)

THX