Category products don't match database

[Oak & Aspen]

Hi,

I have a script that deletes specific entries from [prefix]_category_product ( => removes products from a category) using SQL.

Though the changes are successfully made in the database and in the Prestashop admin interface, they don't show on the frontend. Some products which have been removed from a category still appear in it.

I don't think it's a caching issue because emptying the Prestashop cache and the browser cache doesn't work, and they don't disappear after a few days/weeks. If I add and remove the products using the admin interface it works. What am I doing wrong ?

[Janett]

Due to index of ps_facetedsearch module