We would like to add a column displaying the Manufacturer associated to products within orders.
We will then be able to:
To add the field to the list of available fields for your products grids, click on the in the 'Add a field' panel and enter the following information:
What is the field ID?: manufacturer_name
Sc creates the field, you now need to populate the grid with:
Field name: Manufacturer
Table: Another table
Type: only display
From the Advanced Properties panel on the right handside:
- select the menu SQL Select and enter:
return ' ,IF(od.tax_rate>0,od.tax_rate,tx.rate) as tax_rate';
- select the menu SQL Left Join and enter:
return ' LEFT JOIN '._DB_PREFIX_.'order_detail_tax odt ON odt.id_order_detail= od.id_order_detail LEFT JOIN '._DB_PREFIX_.'tax tx ON tx.id_tax = odt.id_tax';
Exit the editing window.
The new field is now present in the list of available fields and you can add it to your Order grids.