Magento 2.2.3: SALES > ORDERS [Status] GRID not updating, all new orders stuck at "Processing" status

[terrybakshi]

After migrating from 2.2.2 to 2.2.3, SALES > ORDERS grid does not update order statuses.
It does updates the status on the invoice, but not on the sales order grid. Now, we are unable to do accurate sort or filter by status.

This issue is not cache related, I successfully tried to clear, flush, re-indexed, restart the server.
Also, I looked in database and found sales_order table has "complete" status, but sales_order_grid still has "processing" status with the same entity_id. Even after manually changing value to "complete" in sales_order_grid, it is still showing "Processing" at the admin "UI".

Preconditions
Magento 2.2.0
PHP 7.0.24
NGINX
Steps to reproduce
Go to: [#260----] ORDER VIEW > Notes for this Order > and set status to "Complete".
After submitting status shows "Complete".
Go to: SALES > ORDERS grid
Expected result
SALES > ORDERS [Status column] where order #260 should be "Complete"
Actual result
SALES > ORDERS [Status column] where order #260 still shows as "Processing"

[magento-engcom-team]

@terrybakshi , thank you for your report. Did you create a custom order status with the Complete label? If not, how did you change the status to "complete", because by default order receives status "complete" automatically after shipment as been created?

[terrybakshi]

yes the order was auto complete after the shipment was created and tracking number was added. That changed the order status in invoice to comeplete but in grid its still showing processing.

[magento-engcom-team]

@terrybakshi , thank you for your report.
We were not able to reproduce this issue by following the steps you provided. Please provide more detailed steps to reproduce or try to reproduce this issue on a clean installation or latest release.

Preconditions
Magento 2.2.2
PHP 7.0.24

Steps to reproduce

1. Go to admin panel.
2. Created order.
3. Invoice order.
4. Go to order grid and verified that the status is "processing".
5. Migrate to magento 2.2.3 version.
6. Go to order.
7. Submit shipment.
8. Go to order grid and verified that the status is "complete".

Notes:
Also, If we create new order in magento2.2.3, changing status for order works correctly.
Please correct our steps in case they are incorrect, or try to reproduce this issue on clean installation.

[Tezus]

Hello,
I fetch same issue in my magento2.2.0 website. let me know i must update my magento2?
Thank You,

[terrybakshi]

@magento-engcom-team magento-engcom-team

May i know what is the best practice for not really a big store we have a small store with 500 to 600 products, should we set the indexing in index management to ON SAVE or ON SCHEDULE.

Thanks

[magento-engcom-team]

@terrybakshi , please refer to the Community Forums or the Magento Stack Exchange site for advice or general discussion about this question.

[jeroenschipper]

@magento-engcom-team,
We experience the same issue. and can confirm that this is still an issue.

Preconditions:
Magento 2.2.3
Async grid enabled
Cron is enabled

Steps te reproduce:

1. Open an invoice that needs to be "captured"
2. capture that invoice
3. Check the state of the invoice in the grid

Expected result:
The status of the invoice is updated in the invoice grid

Actual result
The status of the invoice is not updated.

Can confirm that the status is updated in the sales_invoice table but not in the sales_invoice_grid table.

[jeroenschipper]

@magento-engcom-team Could you give any status updates?

[okorshenko]

@magento-engcom-team give me 2.2.4 instance

[magento-engcom-team]

Hi @okorshenko. Thank you for your request. I'm working on Magento 2.2.4 instance for you

[magento-engcom-team]

Hi @okorshenko, here is your Magento instance.
Admin access: https://i-14406-2-2-4.engcom.dev.magento.com/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

[pascalckunz]

#mhlej18

[magento-engcom-team]

@pascalckunz thank you for joining. Please accept team invitation here and self-assign the issue.

[ghost]

@rrybakshi, thank you for your report.
We were not able to reproduce this issue by following the steps you provided. Please provide more detailed steps to reproduce or try to reproduce this issue on a clean installation or latest release.

[jamieparkes]

Have a similar issue in Magento ver. 2.2.5.

When using a Mass Order Actions extension to process multiple orders, pressing ship creates shipments but status change is delayed by 5-10 minutes.

Can anyone offer any advice on how to resolve this issue?

[ghost]

We are closing this issue due to inactivity. If you'd like to update it, please reopen the issue.