Magento 2 : Sales Order Grid table is empty but data exist in sales_order

Question

Magento 2.3.3 CE

Sales Order Grid table is empty but data exist in sales_order and sales_order_item.

Earlier I have thought that some module issue so I have disabled all but still after running reindex and clear cache its empty.

It seems order details are not added to the sales_order_grid table. Does anyone faced this issue ?

Tried these commands already.

bin/magento indexer:reindex   
bin/magento c:f

Any help appreciated.

have you disabled the Asynchronous indexing under Store > Configuration > Advance > Developer > Grid Settings ? — Kishor Thummar, Mar 3, 2020 at 5:02
Try to disable, clear cache and reindex, Hope it will work for you. — Kishor Thummar, Mar 3, 2020 at 5:16
Ok, I'm adding this as answer, Please accept the answer and upvote, So it will help to others. — Kishor Thummar, Mar 3, 2020 at 5:24

Kishor Thummar · Accepted Answer · 2020-03-03 05:25:30Z

5

Disable Asynchronous indexing under

Store > Configuration > Advance > Developer > Grid Settings

Clear cache and reindex, Hope this will work or you.

answered Mar 3, 2020 at 5:25

Kishor Thummar

2,7521 gold badge7 silver badges14 bronze badges

Add a comment |

1 Answer 1