Preconditions Magento 2.2.0, no special setup Installed as defaults, just
Go to Advanced - Developer - Grid Settings; Set Asynchronous Indexing to " Enable"; Flush cache; Go to database table "sales_order_grid". You can truncate this ...
Alternative Solution: Also a good idea to truncate eav_entity_store table and other sales table:
[Note] : Please take database backup prior to executing these queries. I went through all tables and came up with following list of tables that should be truncated ...
Use RAW SQL QUERIES instead as we can't delete the order from the grid using the
When you enter into backend sales order grid, unfortunately you won't find
indexes (if you want your orders number start back to 1 TRUNCATE TABLE
Moments later, I received an email from an Administrator explaining that he was trying to customise the columns on their Sales Order Grid page - When all of a ...
edited Aug 2 '17 at 10:34
Magento 2 truncate customers, products, reviews and orders table - magento2- truncate.sql.