Is It Possible to Update Order Item Price and Total After Order is Placed

discountgrand-totalorderspricesales-order

Hi want to update order item price and grand total and order details after order is placed.

suppose,I have place an order with item

Item A – order item price $10

Item b – order item price $20

Discount is $5

Grandtotal – $25

Now my order status is pending and want update order item price and other price just like it

Item A – order item price $40

Item b – order item price $30

Discount is $7

Grandtotal - $63

Is it possible?

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)l
$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 – Calculate grand total on order

To calculate and process the grand total you need to follow these

$quote = Mage::getSingleton('checkout/session')->getQuote();
    $address = Mage::getSingleton('checkout/session')->getQuote()->getShippingAddress();
    $address = Mage::getSingleton('checkout/session')->getQuote()->getBillingAddress();
    $quote = $address->getQuote();
    $session= Mage::getSingleton('checkout/session');    
                $items = $session->getQuote()->getAllItems();
        //$items = $quote->getAddressItems($items);
    //echo '<pre>'; print_r($items);

    if(Excellence_Fee_Model_Fee::canApply($address)){
                 //$exist_amount = $quote->getFeeAmount();
                    // $fee = 1000;
                        //$fees = $fee * $result;
                    $balance = 1000;
                        //          $balance = $fee;

                        //$this->_setAmount($balance);
                        //$this->_setBaseAmount($balance);
                        $address->setGrandTotal($balance);

                        $address->setFeeAmount($balance);

                        $address->setBaseFeeAmount($balance);
                        $quote->setGrandTotal($balance);
                        $quote->setBaseGrandTotal($balance);
                        //echo '<pre>'; print_r($quote);
                        $quote->setFeeAmount($balance);
                        //echo '<pre>'; print_r($quote);

                        $address->setGrandTotal($address->getGrandTotal() + $address->getFeeAmount());
                        //echo '<pre>'; print_r($address);
                        $address->setBaseGrandTotal($address->getBaseGrandTotal() + $address->getBaseFeeAmount());
                        //$address->getGrandTotal();
                    //echo '<pre>'; print_r($address);
                    echo  Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal();

This is working on checkout and cart page to update the grandtotal. Hope this will help you and you find a correct solution.

Magento – Grand total update on billing information save in onepage checkout —Magento

Any event of save of checkout_onepage_savePayment does not exit in magento.

There is an events is fire on every controller dispatch.If i guess that billing has been save it checkout/onepage/saveBilling then it dispatch event for this route is

controller_action_predispatch_checkout_onepage_saveBilling

you get data from using :

$this->getRequest()->getPost('billing', array());

checkout object from

Mage::getSingleton('checkout/type_onepage')

Best Answer

Related Solutions

Magento – Calculate grand total on order

Magento – Grand total update on billing information save in onepage checkout —Magento

Related Topic