Product list, no brands set

[computermp]

Is there a way to figure out which products have "Brand" set or blank,without having to open all the products one by one??

[Ress]

You can try with a SQL query,

SELECT * FROM `ps_product` WHERE `id_manufacturer` = 0;

 

[computermp]

On 3/14/2022 at 10:59 PM, Ress said:

You can try with a SQL query,

SELECT * FROM `ps_product` WHERE `id_manufacturer` = 0;

 

Hi, thanks for your help .. I tried but it doesn't work. Is it possible that I am not able to execute the SQL Query well ... If you like, you could write me a little more in detail how to do it, so I understand if I did well? Anyway thanks anyway.

[Ress]

Hi,

You can add it in prestashop admin, Advanced Parameters -> Database -> SQL Manager -> Add new SQL query, or in phpMyAdmin, select the database and go to the SQL tab.

How did you try to do?

 

Edited March 20, 2022 by Ress (see edit history)

[computermp]

12 hours ago, Ress said:

Hi,

You can add it in prestashop admin, Advanced Parameters -> Database -> SQL Manager -> Add new SQL query, or in phpMyAdmin, select the database and go to the SQL tab.

How did you try to do?

 

Hi, sorry, I tried again and everything worked !! I forgot to change from `ps_product` to` ps4t_product`. Thanks again and see you next time !!