Products Grid: Adding a column 'nb of combinations'

Target

We would like to add a column displaying the number of combinations per product.

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

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

Field name: Nb combinations
Table: Another table
Type: only display

From the Advanced Properties panel on the right handside:

- select the menu SQL Select and enter:

return ' , (SELECT COUNT(id_product_attribute)
            FROM ' . _DB_PREFIX_ . 'product_attribute 
            WHERE id_product = p.id_product 
            ) as nb_combinations';