Product grid : Add Shop name (multi-store mode)

Prerequisites

Access the PRO section of the tool to add custom fields:

Ensure you select the right grid : ‘Catalog: Products grids’:

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

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

From the Advanced Properties panel on the right handside:

Select the menu SQL select and enter:

return ', GROUP_CONCAT(`shop`.`name` ORDER BY `shop`.`name` ASC SEPARATOR ",") AS shop_name ';

Select the menu SQL Left join and enter :

return ' LEFT JOIN '._DB_PREFIX_.'shop shop ON (prs.id_shop = shop.id_shop) ';

Finally, register the configuration :

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.