To create a support ticket, start a search

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 add.png 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='" . (int)$id_product . "' ";
    $pdt_row = Db::getInstance()->ExecuteS($sql);
    if (!empty($pdt_row[0]["id_product"])) {
        $TODO[] = "UPDATE " . _DB_PREFIX_ . "product SET `".$switchObject."`='" . psql($value) . "' WHERE id_product='" . (int)$id_product . "'";
    }
}

 

You will need to adapt this code to your needs.

 

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