How to remove products from homefeatured at once?

[David Y.F.]

Hi,

 

I want to remove all my home featured products at once with a sql sentence, because I have more than 3000 products, and I don't know which of them are "featured".

 

Once I remove a product, other appears in its place, over and over.

 

I know that i can go to Catalog->Products->Associations, but this is to do it manually.

 

I need the table in DDBB. I will know how to do the sql sentence, but I can find the table where I have to work.

 

Regards

[vekia]

 

delete * from ps_category_product where id_category=2

 

make sure that your home category has got id_category value equal to 2

[David Y.F.]

delete * from ps_category_product where id_category=2

make sure that your home category has got id_category value equal to 2

 

Hi vekia,

 

First all, thak you very much.

 

You are right, but problems was that I was created a multishop, and then the category related to featured products (home) move on to another id number in the table you point out.

 

Even searching in ps_category_lang, and getting the number of the new category in the new shop, wasn't possible deleting the products with a sentence. I don't know why. ¡PHPMYADMIN get frozen!

 

Finally I reset, uninstall and reinstall the module, and it work nice.

Even more, the translation of that module doesn't working before reinstalling, and work after.

 

Prestashop has some problems when creating a multishop.

 

There are other things that also had to reinstall some modules, in example PayPal module doesn't work properly still I reinstall it again.