Product Grid: Adding 'ID default category'

Target

We'd like to add the 'Default category' in the product grids

Setup

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

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

Field name: ID default category
Table: Another table
Type: Just display

In the Advanced Properties panel on the right handside:

- select the menu SQL Select and enter:

return ', prs.id_category_default AS id_category_default';

Exit the editing window.

The new field is now present in the list of available fields and you can add it to your product grids.