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.