To create a support ticket, start a search

Orders Grid: Adding all products names in one column


- 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 add.png in the 'Add a field' panel and enter the following information:

What is the field ID?: orderproductsnames


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

Field name: Products

Table: enter: special

Refresh combinations: keep 'no'

Type: only display


  • From the Advanced Properties panel:

 SQLSelectDataSelect :


return ' , (SELECT GROUP_CONCAT(product_name SEPARATOR "<br/>") 
            FROM `ps_order_detail` od where od.id_order = o.id_order) as orderproductsnames ';


  • Exit the editing window and add the field to your grids