move all products from a manufactrer in a specific category

[ClémentP08]

Hi,

Here is my issue, I have a lot of product in a 1.7.2 prestashop which are all in a manufacturer.

What I want to do is to select all products from a manufacturer and put em in a specific category

According to my research I don't think there is a way to do it in the BackOffice, I think the only way is to do it by sql request the only problem is that I'm quite new to it, and I don't really know how to do it.

I saw that I have to make change in three table  :

- ps_category_product

- ps_product_shop

- ps_product

 

in the ps_product table I see id_category_default and id_manufacturer fields , except that changing only products in this table is not enough, on the other tables I have id_produit and id_category , but nothing to make the product link to a manufacturer. So I don't really know how to make my request to select all product belongs to a manufacturer to put them in a specific category next .

 

If anyone can help me,

 

thanks. (and sorry for my english)