Deleting large numbers of orders from Magento 2 admin often causes timeouts. You can also delete orders directly through the database. Open phpMyAdmin and run the following two statements:
Proceed at your own risk. Test on a staging system or at least make a complete database backup first!
|
1 2 |
DELETE FROM sales_order WHERE ... ; DELETE FROM sales_order_grid WHERE ... ; |
Clear the Magento 2 cache afterwards and verify that the intended orders were removed.
Deleting orders directly from the database with SQL
Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.