Remove "Home" category from products

[AndersHelbo]

Hi

 

Is there a way - maybe in MySQL - to remove "Home" category from all the products that might have this category attached?

[NemoPS]

Via sql, I guess the query would be DELETE * FROM ps_category_product WHERE id_category = 2
Given that 2 is the home category id, otherwise use yours

[AndersHelbo]

Via sql, I guess the query would be DELETE * FROM ps_category_product WHERE id_category = 2

Given that 2 is the home category id, otherwise use yours

 

Thanks a lot. I will try this one.

[Marleon]

On 4/11/2016 at 12:41 PM, NemoPS said:

Via sql, I guess the query would be DELETE * FROM ps_category_product WHERE id_category = 2
Given that 2 is the home category id, otherwise use yours

This helped me, but unfortunately in the products section I still see HOME.

But if you go into product properties, then everything is fine. Clearing cache on website  and in browser does not change anything.

All should be Moto-Atv, the first one was changed manually

Do you have any idea what should be the problem here?

Prestashop 8.1.3