Assign Brands and Products

[Algra]

Hello, in my store I have more than 4000 products and 400 of them do not have the assigned brand. How can I filter to see what they are without going one by one?

Prestashop version 1.7

[toup]

Hi

I would probably do the following 

1) create a category (name it however you want) and make it not visible in front, take note if the category ID (let's say it's 123)

2) run this query (of course, replace 123 by whatever your ID is from the previous point) :

insert into ps_category_product (id_product,id_category) select distinct id_product, 123 as id_category from ps_product where id_manufacturer = '';

(it will put all the products without a brand into this new category)

3) use "filter by category" on the products page of the back office and filter by your last created category, it will show you your products without a brand.

4) when you're done, you can delete your now useless category

[innovacy]

Best method I suggest:

-> Create a new brand and call it something like "Unknown brand". Grab the ID, you will need it on the next step.

-> Navigate to "Advanced Parameters > Database" and add a new query. Replace on the following one "<ID>" with just the id from above (using no quotes or anything).

update ps_product set id_manufacturer = <ID> where id_manufacturer = 0; 

-> Once you have added it, execute it.

Now you can navigate to "Brands & Suppliers" and VIEW from there the associated products, which you can edit and re-assign as required. Whenever new products without a brand are added, they can be either assigned to this "placeholder" brand or the query run again. As soon they are assigned properly to another brand, everything is immediately good, nothing to delete or change.

[Algra]

1 hour ago, innovacy said:

Best method I suggest:

-> Create a new brand and call it something like "Unknown brand". Grab the ID, you will need it on the next step.

-> Navigate to "Advanced Parameters > Database" and add a new query. Replace on the following one "<ID>" with just the id from above (using no quotes or anything).

update ps_product set id_manufacturer = <ID> where id_manufacturer = 0; 

-> Once you have added it, execute it.

Now you can navigate to "Brands & Suppliers" and VIEW from there the associated products, which you can edit and re-assign as required. Whenever new products without a brand are added, they can be either assigned to this "placeholder" brand or the query run again. As soon they are assigned properly to another brand, everything is immediately good, nothing to delete or change.

Thanks for your answer, when I send the SQL query I get an error ("SELECT" does not exist.) what should I do

[Algra]

2 hours ago, toup said:

Hi

I would probably do the following 

1) create a category (name it however you want) and make it not visible in front, take note if the category ID (let's say it's 123)

2) run this query (of course, replace 123 by whatever your ID is from the previous point) :

insert into ps_category_product (id_product,id_category) select distinct id_product, 123 as id_category from ps_product where id_manufacturer = '';

(it will put all the products without a brand into this new category)

3) use "filter by category" on the products page of the back office and filter by your last created category, it will show you your products without a brand.

4) when you're done, you can delete your now useless category

Hi, thank you for you answer. When I submit the query I get the following error ("INSERT" is a reserved word. )