Magento – Magento 2.2: Order, Invoice, and Shipment do not display in admin grid

invoicemagento2.2order-gridshipment

I added a product to the cart and create order. It displays properly on the front side in "My Order" tab.

But, when I checked in admin side order grid, then records not updated in order grid.

I have also do reindexing and flush cache and also async indexing is disabled. But, there is no any luck working.

Note: When I create invoice or shipment of the previous order, then it's also not created in admin side. But, it's recorded in the database table is already available. Only not display in order grid.

admin/sales/order/view/order_id/`<previous_order_id>`/key

If direct change by order_id, then it'll display. But, record not display in order grid.

The same issue occurred in invoice and shipment.

How to solve it?

Please help me.

Best Answer

I think you have issue in increment_id. So, try to execute this query in your db.

Note : Here, 7 is current store id which receive order data & 1 is default store id .

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;
ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;
ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;
ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;
ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;
ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;
ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;
ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;
ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

So, If you execute this query in your db, then you'll get all new upcoming records will be in order grid.

I think it may be helpful to you.

Related Solutions

Magento – How to remove invoice, shipment and creditmemo from Admin grid in magento1.9.0.1 programmatically

I have got a success after long process/RND and searching on google a lot.

   $orders = Mage::getModel('sales/order')->getCollection()->addFieldToFilter('entity_id', (array) $orderId);
                    foreach ($orders as $o) {
                        //load order object - I know it's not ok to use load in a loop but it should be ok since it's a one time script
                        $order = Mage::getModel('sales/order')->load($o->getId());

                        $invoices = $order->getInvoiceCollection();
                        foreach ($invoices as $invoice){
                            //delete all invoice items
                            $items = $invoice->getAllItems(); 
                            foreach ($items as $item) {
                                $item->delete();
                            }
                            //delete invoice
                            $invoice->delete();
                        }
                        $creditnotes = $order->getCreditmemosCollection();
                        foreach ($creditnotes as $creditnote){
                            //delete all creditnote items
                            $items = $creditnote->getAllItems(); 
                            foreach ($items as $item) {
                                $item->delete();
                            }
                            //delete credit note
                            $creditnote->delete();
                        }
                        $shipments = $order->getShipmentsCollection();
                        foreach ($shipments as $shipment){
                            //delete all shipment items
                            $items = $shipment->getAllItems(); 
                            foreach ($items as $item) {
                                $item->delete();
                            }
                            //delete shipment
                            $shipment->delete();
                        }
                        //delete all order items
                        $items = $order->getAllItems(); 
                        foreach ($items as $item) {
                            $item->delete();
                        }
                        //delete payment - not sure about this one
                        $order->getPayment()->delete();
                        //delete quote - this can be skipped
                        if ($order->getQuote()) {
                            foreach ($order->getQuote()->getAllItems() as $item) {
                                $item->delete();
                            }
                            $order->getQuote()->delete();
                        }
                        //delete order
                        $order->delete();

                        $order_increment_id = $order->getIncrementId();
                        /*if($order_increment_id){
                           $invoice_in_grid = Mage::getResourceModel('sales/invoice_grid_collection')->addFieldToFilter('increment_id',$order_increment_id);
                           $invoice_in_grid->delete(); 

                           $shipment_in_grid = Mage::getResourceModel('sales/shipment_grid_collection')->addFieldToFilter('increment_id',$order_increment_id);
                           $shipment_in_grid->delete(); 
                       }*/

                       $db = Mage::getSingleton('core/resource')->getConnection('core_write');
                        $sales_flat_order_grid = Mage::getSingleton('core/resource')->getTableName('sales_flat_order_grid');  
                        $sales_flat_invoice_grid = Mage::getSingleton('core/resource')->getTableName('sales_flat_invoice_grid');
                        $sales_flat_shipment_grid = Mage::getSingleton('core/resource')->getTableName('sales_flat_shipment_grid');
                        $order_increment_id = $o->getIncrementId();

                        if($order_increment_id)
                        { 
                        /*$query = "DELETE FROM sales_flat_quote WHERE reserved_order_id = ".$o->getId()."; 
                                  DELETE FROM sales_flat_invoice WHERE increment_id = ".$o->getId().";
                                  DELETE FROM sales_flat_invoice_grid WHERE order_id = ".$o->getId().";
                                  DELETE FROM sales_flat_shipment WHERE order_id = ".$o->getId().";
                                  DELETE FROM sales_flat_shipment_grid WHERE order_id = ".$o->getId().";";*/

                        $sql = "DELETE FROM ".$sales_flat_order_grid." WHERE increment_id='".mysql_escape_string($order_increment_id)."';
                                DELETE FROM ".$sales_flat_invoice_grid." WHERE order_id='".mysql_escape_string($o->getId())."'; 
                                DELETE FROM ".$sales_flat_shipment_grid." WHERE order_id='".mysql_escape_string($o->getId())."'";

                        /*$sql = "DELETE FROM ".$sales_flat_invoice_grid." WHERE order_id='".mysql_escape_string($o->getId())."'; 
                                DELETE FROM ".$sales_flat_shipment_grid." WHERE order_id='".mysql_escape_string($o->getId())."'";*/

                        //$db->query("DELETE FROM ".$sales_flat_invoice_grid." WHERE increment_id='".mysql_escape_string($order_increment_id)."'");        
                        $db->query($sql);
                        }
                        //exit;
                        //echo "deleted";
                    }   

                $this->_getSession()->addSuccess($this->__('Order was successfully deleted.'));

This code successfully deletes the order from Sales->Orders Grid, also deletes the invoice from Sales->invoices Grid, and also deletes shipment from Sales->Shipment Grid. For that, some portion it has been deleted from Database tables directly, not with magento code like ...->delete(); I need the code of Magento to delete order, invoice, shipment, also creditmemo from Grid. If any one knows about it, please reply it.

Magento2 – Force Order Status to Processing After Shipment Creation

When you save data from your order model, i think magento will do some kind of validation for your order state and status, to come up with your trouble run this function after you save the order:

    public function updateOrderRaw($orderId){
      $objectManager = \Magento\Framework\App\ObjectManager::getInstance();
      $resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
      $connection = $resource->getConnection();
      $tableName = $resource->getTableName('sales_order');
      $sql = "UPDATE " . $tableName . " SET status = 'delivery', state = 'processing' WHERE entity_id = " . $orderId;
      $connection->query($sql);
    }

the above function will run sql query to update the order status and state from sales_order table

Best Answer

Related Solutions

Magento – How to remove invoice, shipment and creditmemo from Admin grid in magento1.9.0.1 programmatically

Magento2 – Force Order Status to Processing After Shipment Creation

Related Topic