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;
find some magento simple technical solution easly get solution with wide explanation. how we can use the solution code. Here i am posting what i faced issues and found issues solving solution. Magento is most powerful eCommerce frame work. working in magento framwork finding soluiotn and sharing technical knowledge here.