Magento 2.x – Rebuild sales_order_grid table
If you are working on the sales order grid, for instance adding a new column, you will see that you need to keep beside the sales_order table, the sles_order_grid one, where all the display information is being shown.
To do so without waiting the corresponding cronjob, you need to follow up a couple of steps:
- Go to Advanced – Developer – Grid Settings
- Set Asynchronous Indexing to “Enable”
- Flush cache
- Go to database table “sales_order_grid”. You can truncate this table or remove only orders during some period where orders missing (from X day to current day).
- php bin/magento cron:run
And that’s it, your sales_order_grid table should now be updated.