To create a support ticket, start a search

Products Grid: Add a field from ps_product table (with yes/no choice)

Prerequisites:

- Store Commander version 2014-03-12
- SC Grids Editor Pro Add-on - version 1.0
- The field needs to exist in your database
- The field needs to exist in Prestashop Product Class to be used in your Front Office templates (optional) 

 

Target:

We would like to add the field 'BIO Label' to be able to differencate the product type in the grids.

We will then be able to:

- use the filters in the grids to optimize the selection of products
- mass-edit this field using Store Commander's copy/paste option by language used on the store
- 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?: BIO Label (should be exactly the name as it is in the database).

 

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

Field name: BIO Label

Table: product

Refresh combinations: keep 'no'

Type: multiple choice

 

If you wish to add a yes/no option, go to the advanced properties panel and add:

List of choice: 

return array(1=>_l('Yes') , 0=>_l('No'));

 

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

- Select the grid where the field should be displayed

- Drag/drop the filed in this grid

To use the choice list, select 'multiple choice' in the Type column (Type A) for your field.