We would like to restrict the display of products in one view. For example, in a view called 'Brand XY' that you would have created beforehand, we would display only products associated to this brand.
Note: with Store Commander's User Permissions, you can allow an employee to modify only products associated to a specific brand and he/she will not have access to any other products.
Type: Display only
return " AND p.id_manufacturer = 3 ";
You will need to adapt this code to your needs. In this example id_manufacturer 3 corresponds to 'Brand XY' as per target.