Magento 1.9 – How to Add Value in Custom Column of sales_flat_order Table

magento-1.9sales-order

Hi i have made a custom column in sales_flat_order table named final_shipping_amount. When i am loading order its showing my custom column in it. I am trying to add value in my custom column but its not adding value in it here is my code.

$final_shipping = "1.33"
$orderIid = $this->getRequest()->getParam('id');
$orderDataShip = Mage::getModel('sales/order')->load($orderIid);
$orderDataShip->setFinalShippingAmount($final_shipping);
$orderDataShip->save();

Its not saving value in it. i have also tried this way but also its not saving

$final_shipping = "1.33"
$orderIid = $this->getRequest()->getParam('id');
$orderDataShip = Mage::getModel('sales/order')->load($orderIid);
$orderDataShip->setData('final_shipping_amount' , $final_shipping);
$orderDataShip->save();

but its not working.

Best Answer

Try clearing the Magento cache (both the Magento cache and Storage cache)..or you can simply delete the files from var/cache.

Related Solutions

Magento 1.9 – Fix Problem with Custom Column Value Saving

Please try with this code in Observer.php:

public function SaveQuoteBefore($observer){
    $quote = $observer->getEvent()->getQuote();
    foreach($quote->getAllItems() as $item){
        $item->setVendor('Admin');
    }
}

and remove function SaveBefore.In config.xml remove <sales_order_save_before> and add this code in <global>:

<fieldsets>
    <sales_convert_quote_item>
        <vendor>
            <to_order_item>*</to_order_item>
        </vendor>
    </sales_convert_quote_item>
</fieldsets>

Don't forget to Flush Cache and maybe Reindex before using it.

Only recommendation - it's better to not use full table name but $this->getTable('sales/quote_item') and $this->getTable('sales/order_item').

Magento – Update a custom column of sales_flat_order table after order complete in magento

$resource = Mage::getSingleton('core/resource');
$writeConnection = $resource->getConnection('core_write');
$themeTable = $resource->getTableName('sales_flat_order');
$sql = "INSERT INTO " . $themeTable ."(field1, field2) VALUES ('1', 'NameABC')";//insert only
$sql1 = "UPDATE" . $themeTable . "SET vorder_payment_state = 2 WHERE entity_id = ".$orderId;//update
$writeConnection->query($sql);//insert
$writeConnection->update($sql1);//update

Best Answer

Related Solutions

Magento 1.9 – Fix Problem with Custom Column Value Saving

Magento – Update a custom column of sales_flat_order table after order complete in magento

Related Topic