The field has to be present in the database
We would like to import a field in product table.
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 on the right handside:
- select the menu Import Combinations Process and enter:
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.
The new field can now be included in your import mapping.