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

event-observermagento-1.9sales-order

I have a custom column used in sales_flat_order in my code and I just want to update a column value of this table when the order is complete. I have used the event sales_order_save_after and below is the code:

    public function salesOrderSaveAfter(Varien_Event_Observer $observer) {
    $order = $observer->getEvent()->getOrder();
    $orderId = $order->getId();

    $Incid=$order->getIncrementId();

    if ($order->getState() == Mage_Sales_Model_Order::STATE_COMPLETE) {


        $con=Mage::getSingleton('core/resource');
        $write=$con->getConnection('core_write');

        $query= "update `sales_flat_order` set `vorder_payment_state` = 2 where `entity_id`='.$orderId.'";
        $write->query($query);

    }
    }

the column value is not updated.

Best Answer

$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

Related Solutions

Magento – Import sales_flat_order table from one db to another db

You should not attempt to do this via a direct database transfer. If you want to import/export orders you should look at a way to do this programmatically as you will run into issues in the database.

I would recommend this extension to accomplish what you are trying to do

http://www.magentocommerce.com/magento-connect/dataflow-batch-import-export-orders-to-csv-xml.html

How to Update Sales Flat Order Table Status by Payment Method in Magento 1.9

Mujas,you can do this by magento event observer.

Fire an observer on event checkout_submit_all_after and change order status your New Order status.

event Config.xml code look like

<global>
    <events>
        <checkout_submit_all_after>
            <observers>
                <change_order_status>
                    <class>yourmodule/observer</class>
                    <method>CodeOrdeStatus</method>
                </change_order_status>
            </observers>
        </checkout_submit_all_after>
    </events>
</global>

Observer code look like:

public function CodeOrdeStatus($observer)
{
    $order = $observer->getEvent()->getOrder();
    $order = Mage::getModel('sales/order')->load($order->getId());
    // check order is code or not
    if($order->getPayment()->getMethodInstance()->getCode() == "cashondelivery") {
        $order->setStatus("complete");
        $order->save();    
    }
}

Best Answer

Related Solutions

Magento – Import sales_flat_order table from one db to another db

How to Update Sales Flat Order Table Status by Payment Method in Magento 1.9

Related Topic