I am using the fedex shipping method and after generating the shipment,status shows completed in the order view page.But there is still showing 'processing' status in the sales order grid. Please check following screenshot. Can you guys help me!!!!

enter image description here

enter image description here

enter image description here

enter image description here

This order was placed using authorize.net payment method.I have set the processing status when someone place order using authorize payment method. So, How can i set the complete status in the admin grid.Please help!!!!!

  • Hello #sunny Please check your grid override from other 3rd party module or not, otherwise magento default has no issue in a grid...please check it once !!!
    – Dhrumin
    Oct 4 '18 at 6:42
  • Please check this screenshot.nimb.ws/SZmqfb. There should be change the status in the database too while generate the shipment. Oct 4 '18 at 6:45
  • Yes, Here it is processing then please check order view page i think issue on view page, order grid working as per your screenshot. is that right or not?
    – Dhrumin
    Oct 4 '18 at 6:50
  • I have generated the shipment with adding the fedex tracking code.So as per magento standard , if i generate the shipment then order status must change to complete.Please check the same issue in the git magento community. github.com/magento/magento2/issues/14406 Oct 4 '18 at 6:52
  • Yes, it seems it is a bug,.If an order all items invoice are generate and shipment than that order goes to complete state
    – Amit Bera
    Oct 4 '18 at 7:14

Please run below command

php bin/magento cron:run

php bin/magento indexer:reindex

run this in your sql as a temporary solution

UPDATE sales_order_grid as t1 LEFT JOIN sales_order as t2 ON t1.entity_id = t2.entity_id SET t1.status = t2.status WHERE t1.status != t2.status 

This will update orders status in orders grid view

  • Was looking for this. Though to update but then had second thoughts, thanks for sharing. Will definitely run your query now on my live site lol let's see how it goes. Update: ok cool, one record was updated which is the one that was missed. Thanks for your query. Nov 29 '20 at 13:42

I would have suggested php bin/magento indexer:reindex

There is a sales order and sales order grid table. Customers does the same too. A reindex will make sure they are both in sync.

  • 2
    The sales_order_grid table is not generated via index. Last time I checked you could've set it to update async from admin (at least on commerce), crons would take care of it then, and you would see some latency. But last time I checked there was no sales_order_grid index. Jun 17 '19 at 20:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.