Admin order grid page and order status

[calamusdesign]

Hi,
we have a problem in the admin order grid page.

For several months we have been working with Magento 2.3.3 without any problem, a couple of days ago after installing a new extension (we tried to remove it but the problem is not solved), in the admin order grid, some orders are not visible. Also in the order page the status can be updated, but in the admin order grid the status is not updated (from processing to complete).

In the frontend site, customers can vew all their orders correctly.

After run "php bin/magento cron:run" also into the admin order grid, all orders are visible and status is updated.

Has anyone had a similar problem?

thanks

Piero

[Manish Mittal · Accepted solution]

Hello @calamusdesign 

This is cause "Grid Settings configuration schedules updates".

The benefits of scheduling these tasks is to avoid the locks that occur when data is saved, and to reduce processing time. When enabled, any updates take place only during the scheduled cron job. For best results, Cron should be configured to run once every minute.

To disable it you can go to

Store>configuration>developer>grid settings> disable

For more:

https://docs.magento.com/user-guide/sales/order-grid-updates-schedule.html

[calamusdesign]

Ok thanks!

works on a local copy in develeop mode, is there a way to fix it in production mode?

thanks thanks thanks

Piero

[Manish Mittal]

@calamusdesign 

Magento recommends using Update on Schedule mode in production, because it stores information about data updates and performs indexation by portions in the background through a specific cron job.

But still you required you can try this command:

php bin/magento config:set dev/grid/async_indexing 0