This will reset and remove all your orders, orders history and bestsellers etc. Only run this if you have a backup first or don't care about the data.
answer, I'd also mention the possibility to reset / truncate test customer data:
Reset indexes (if you want your orders number start back to 1.
Step 2. Update the order increment ID for your store. Run this query. UPDATE ...
I went through all tables and came up with the following list of tables that should be truncated in order to clear test data: SET FOREIGN_KEY_CHECKS = 0;.
How to reset test sales/orders and dashboard information in Magento 2.3.2. July 25 2019; 2.3K; 0 Comments. Read this article in other language.
It is not sufficient to clear only the sales_order table, because it will leave orphaned orders information in other tables. It would better to see how does the ...
All data pertaining to orders and search terms (Dashboard) are reset to 0 (zero); Order number prefix with 0, Invoice number prefix with 2, ...
Clearing all orders and related data; Reset all increment Ids. In order to delete those test data, you have to log in to your PhpmyAdmin using root ...
Magento, by default, does not let admin delete the orders entirely from the backend. They can be