[Note]: Please take database backup prior to executing these queries. I went through all tables and came up with the following list of tables that should be ...
Labels: magento2
// delete all order items $items = $order->getAllItems(); foreach ...
Magento 2 truncate customers, products, reviews and orders table - magento2- truncate.sql.
After a fresh installation, there will be test orders in your Magento backend.
SET FOREIGN_KEY_CHECKS=0;. -- Customers. TRUNCATE TABLE ` customer_address_entity`;. TRUNCATE TABLE ` customer_address_entity_datetime`;.
Here is the post that help you to clear Magento 2 test data such as:
Magento, by default, does not let admin delete the orders entirely from the backend.
Magento database and you need to do a bit
TRUNCATE ` sales_flat_quote_address_item`;