Latest order is not showing in admin sales order grid in magento1

Refresh order grid table in Magento 1

Latest order is not showing in admin grid, but it is saving in database and also showing order id in mail.
Recently, we’ve faced a data inconsistency in the Magento sales_flat_order_grid db table.
I’ve developed a shell-script, which will refresh the sales_flat_order_grid table to correspond exactly to the sales_flat_order table:

create file in shell folder orders_grid_update.php place the below code

<?php
/**
 * @author Pawan
 * @copyright Copyright (c) 2018 pawan (https://pawanmagento.blogspot.com/)
 * @package Pawan_Shell
 */
require_once 'abstract.php';
class Pawan_Shell_Free_Order_Grid_Update extends Mage_Shell_Abstract
{
    public function run()
    {
        try {
            Mage::getModel('sales/order')->getResource()->updateGridRecords(
                Mage::getResourceModel('sales/order_collection')->getAllIds()
            );
            echo 'Done!' . PHP_EOL;
        } catch (Exception $e) {
            echo $e->getMessage() . PHP_EOL;
        }
    }
}
$shell = new Pawan_Shell_Free_Order_Grid_Update();
$shell->run();



You can run this script from your Magento installation root directory in the following way:

php shell/orders_grid_update.php
Pretty simple and really efficient. I hope, this little blog post will save you some time.