Update Order Total After Order Placement in Magento 1.9

databasemagento-1.9orderstotals

I created a custom charges on order for some specific products, Unfortunately custom charge was not updated in order total like cash on delivery,

Is there any way to update orders totals after order created without cancel order?

Best Answer

I think you can do this just like you would modify any other model instance.

$item = Mage::getModel('sales/order_item')->load(id here);
$item->setPrice(40)->setBasePrice(40)->save();

then

$order = Mage::getModel('sales/order')->load(order id here);
$order->setSubtotal(70)->setBaseSubtotal(70);
$order->setDiscountAmount(7)->setBaseDiscountAmout(7);
$order->setGrandTotal(63)->setBaseGrandTotal(63);
$order->save();

You might also need to change other values like tax, subtotal_incl_tax and others.

But this is a bad practice and you should not do it. It is better just to cancel the order and create a new one.

Related Solutions

Magento – get order totals from $order object

To sum it up, order totals aren't stored on the order object the same way as on the quote object. The reason is that the result of the dynamic quote totals are stored in the order table. You're right in it being a bad thing to get the quote totals from the order, as things like credit memos affect order totals.

The quote totals also has some extra attributes available for tax calculation that doesn't exist in the order totals procedure and that might depend on session variables.

So, bottom line: The order totals is the different values you can get*() from the order object.

The invoice and credit memo can collectTotals() because they subsequently modify the order totals (amount_paid, amount_invoiced, ..). Totals which are in fact values from sales_order_flat.

The block adminhtml/sales_order_totals used in the order view loops over getTotals('') which can cause some terminology confusion. These totals are in fact of type Varien_Object and holds static values from the database. Adding a row in there is possible but not at all as straight-forward as with the quote totals.

Magento – Cancel order and restore products stock qty

Why you use external cancel functionality to load model each time, Magento Provide cancle() function.

Try This code to cancel order:

if(!$order->canCancel()) {
    throw new Exception('Order cannot be canceled anymore.');
}
$order->cancel();
$order->save();

I give you such idea to use cancel() like:-

$orderModel = Mage::getModel('sales/order');
$orderModel->load($orderId);
if(!$orderModel->canCancel()) {
$orderModel->cancel();
$orderModel->setState(Mage_Sales_Model_Order::STATE_CANCELED, true);
$orderModel->save();
}

System->Configuration-> Catalog ->inventory->stock options->Set Items' Status to be In Stock When Order is Cancelled change this value to "No".

You can also stop to decrease the stock quantity on order placed: System->Configuration-> catalog -> inventory->stock options->Decrease Stock When Order is Placed

Best Answer

Related Solutions

Magento – get order totals from $order object

Magento – Cancel order and restore products stock qty

Related Topic