Product Import: Importing a field in product table

Prerequisites

• Store Commander version 2015-07-01
• SC Grids Editor Pro Add-on - version 1.2
• The field has to be present in the database

Target

We would like to import a field in product table.

Setup

• To add the field to the list of available fields to import, click on the  in the 'Add a field' panel and enter the following information:

What is the field ID?: my_field (has to correspond exactly to the field name in the table)

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

ID: my_field

Name: my_field

• From the Advanced Properties panel (right hanside) > Import Combinations Process, add the following:

if ($switchObject=='my_field' && $GLOBALS['import_value']!='')
{
$value = $GLOBALS['import_value'];
$sql="SELECT * FROM "._DB_PREFIX_."product WHERE id_product='".intval($newprod->id)."' ";
$pdt_row = Db::getInstance()->ExecuteS($sql);
if(!empty($pdt_row[0]["id_product"]))
{
$TODO[]="UPDATE "._DB_PREFIX_."product SET my_field='".psql($value)."' WHERE id_product='".intval($newprod->id)."'";
}
}

You will need to adapt this code to your needs.

• Exit the editing window and you can use the field in your import mapping