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;.
This will reset and remove all your orders, orders history and bestsellers etc.
answer, I'd also mention the possibility to reset / truncate test customer data:
This query delelets all customers and orders from your. -- Magento 1.* install. Handy, if you have a bloated. -- Magento database and you need to do a bit.
clean and organized by deleting test orders or abandoned ones from customers.
SET FOREIGN_KEY_CHECKS=0;. -- Customers. TRUNCATE TABLE ` customer_address_entity`;. TRUNCATE TABLE ` customer_address_entity_datetime`;.
Delete mass orders; Ability to delete all; Delete related data safely.
For amateur user who not familiar with coding process, I suggest a great extension that work well on both Magento 1 and 2. Managing orders in ...
Here is the post that help you to clear Magento 2 test data such as: Clearing all products; Clearing all categories; Clearing all customers; Clearing
Enter tracking number reference of Magento. Check. ex. Magento 2 Remove All Customers And Orders : Useful Links ...