- Store Commander version 2014-03-12
- SC Grids Editor Pro Add-on - version 1.0
We would like to add a column displaying the names of all products in an order.
We will then be able to:
- use the filters in the grid to filter the products keeping one line per order
- rapidly export the orders grid with a line including all products of that order
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?: orderproductsnames
Field name: Products
Table: enter: special
Refresh combinations: keep 'no'
Type: only display
return ' , (SELECT GROUP_CONCAT(product_name SEPARATOR ' <br/>') FROM `ps_order_detail` od
where od.id_order = o.id_order) as orderproductsnames ';