To create a support ticket, start a search

Products Grid: Add a column displaying a product feature (read only)

Prerequisites:

- Store Commander version 2014-03-12
- SC Grids Editor Pro Add-on - version 1.0

 

Target:

We would like to add a column displaying values of a specific feature in the products grid.

We will then be able to:

- use the filters in the grids to optimize the selection of products
- rapidly export the products grid with this field

 

Setup:

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?: myfeature

 

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

Field name: Delivery

Table: enter: special

Refresh combinations: keep 'no'

Type: multiple choice

 

  • From the Advanced Properties panel:

SQLSelectDataSelect :

 

return ' , (SELECT fvl.value FROM `ps_feature_product` fp 
LEFT JOIN `ps_feature_value_lang` fvl 
ON (fp.id_feature_value=fvl.id_feature_value and fvl.id_lang=2)
where fp.id_feature = 3 
and fp.id_product = p.id_product) 
as myfeature ';

 

In this instance, we use feature ID3. You can change the feature by looking for its ID in the Features panel (SC Catalog>Features)

 

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