Update new custom field in table from model

[Dev100]

I add custom field "currency_code" to table "catalog_product_entity".

And now I want save data for this field from model.

$product = Mage::getModel('catalog/product')->loadByAttribute('sku', '123456');

// it's work
echo $product->getData('currency_code');
echo $product->currency_code;

$product->setCurrencyCode('EUR');
$product->save();

// after that the field is not updated

[Vimal Kumar]

Hi @Dev100,

Try once using setData method:

$data = array('currency_code'=>'EUR');
$product->setData($data);
$product->save();

I hope it will help you!