Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this community
I am facing a very serious issue with Magento 1.9 website. This has happened a couple of times. Customer places the order, they even get an email confirming the order but the order does not show in the Magento admin panel.
Could you please help shade some light as to what could have caused this?
Thanks
First of all check, any custom extension blocks your order to save grid. Also, you can add the following event:
<sales_order_save_after>
<observers>
<sr_sales_order_save_after>
<class>sr_magentocommunity/observer</class>
<method>salesOrderSaveAfter</method>
</sr_sales_order_save_after>
</observers>
</sales_order_save_after>
add the following code in your observer
/**
* @param Varien_Event_Observer $observer
*/
public function salesOrderSaveAfter(Varien_Event_Observer $observer)
{
$order = $observer->getEvent()->getOrder();
if($order && ($orderId = $order->getId())) {
Mage::getModel('sales/order')->getResource()->updateGridRecords([$orderId]);
}
}
sales_flat_ordertable and if everything works correctly insales_flat_order_gridtoo. If you have the order only insales_flat_orderand not insales_flat_order_gridthe approach proposed by @Sohel Rana should work for new orders (although you should identify the problem!). For ald orders you can copy orders fromsales_flat_ordertosales_flat_order_gridusing SQL. If you don't have the orders insales_flat_orderit looks like a greater problem in your store.