Hello everybody, in the product list I would like to add a new column (supplier).
I saw the query that is used at the moment and on db I did the test by adding what I needed.
Now my doubt is how to go about adding the LEFT JOIN to make sure it is correctly added to the current selection.
I found a guide that said to take action in the file override / controllers / admin / AdminProductsController.php
Here inside the __construct () function I added the following code:
parent :: __ construct ();
$ this -> _ join. = 'LEFT JOIN `pr_manufacturer` m ON p.`id_manufacturer` = m.id_manufacturer';
$ this-> fields_list ['manufacturer'] = array ( 'title' => $ this-> l ('Manufacturer'), 'filter_key' => 'm! name' );
I also deleted the cache / class_index.php file I don't see the new column added yet.
Can anyone help me figure out where to act or if I was wrong to write the code?
Thanks in advance