Products Grid: Adding a field from ps_product_lang table

Prerequisites

• 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 'shipping info' allowing the display of specific information on the product page.

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 in the 'Add a field' panel and enter the following information:

What is the field ID?: shipping_info (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: shipping info
Table: product_lang
Type: Text
Refresh combinations: No

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.