Product Custom Tab/Field - not updating

[paddle07]

Hi

 

I build a custom products field module following this tutorial:

http://nemops.com/prestashop-products-new-tabs-fields/

 

I added the shop id as I'm using multistore.

 

Everything works fine until I want to update an existing product… as soon as I edit a product (e.g. price or quantity) and save it (either with save and stay or save) the content of the custom field turns blank. The content of the custom field is only saved correctly when I click on the “custom-field-Tab” before I save e.g. a new price…

 

Here's my hookActionProductUpdate code:

public function hookActionProductUpdate($params)
		{
		    // get all languages
		    // for each of them, store the new field
		    $id_product = $params['product']->id;
		    $id_shop = $this->context->shop->id;
		    
		    $languages = Language::getLanguages(true);
		    foreach ($languages as $lang) {
		        if(!Db::getInstance()->update('product_lang', array('custom_field'=> pSQL(Tools::getValue('custom_field_'.$lang['id_lang']))) ,'id_lang = ' . $lang['id_lang'] .' AND id_shop = ' .$id_shop. ' AND id_product = ' .$id_product ))
		            $this->context->controller->_errors[] = Tools::displayError('Error: ').mysql_error();
		    }
		}

Thanks!

[bellini13]

you are probably erasing the content in the database when you click on save.

 

The product tabs are probably not being loaded unless you click on the tab.  Prestashop uses ajax to load the tab data when you click on the tab.

 

So if you do not click the tab, then the content is blank, and clicking on save will execute your hook and your hook is saving blank to the database.

[nozzula]

Hi, here  a solution is proposed by Jeff (see comments)

 

I've found how to solve your bug in hookActionProductUpdate, you've to check if POST vars are set before save it with Tools::getIsset.

public function hookActionProductUpdate($params)
{
// get all languages
// for each of them, store the new field

$id_product = (int)Tools::getValue('id_product');

$languages = Language::getLanguages(true);
foreach ($languages as $lang) {
if (Tools::getIsset('custom_field_'.$lang['id_lang']))
if(!Db::getInstance()->update('product_lang', array('custom_field'=> pSQL(Tools::getValue('custom_field_'.$lang['id_lang']))) ,'id_lang = ' . $lang['id_lang'] .' AND id_product = ' .$id_product ))
$this->context->controller->_errors[] = Tools::displayError('Error: ').mysql_error();
}

}