Orders Grid: adding 'Ecotax' field

Target

We would like to add the ecotax field within the order interface.

Setup

To add the field to the list of available fields for your grids, click on the  in the 'Add a field' panel and enter the following information:

What is the field ID?: ecotax

Sc creates the field, you now need to populate the grid with:

Field name: ecotax
Table: product
Type: only display

From the Advanced Properties panel on the right handside:

- select the menu SQL Select and enter:

return ' ,p.ecotax';

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.