Magento 2 || Clean database \ Truncate data until a specific date - mpaz-redstage/magento-snippets GitHub Wiki

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE magento.momentisinventory_inventory_update; #it’s used to log the import status of the inventory CSV from the Momentis Integration
DELETE FROM magento.quote;
DELETE FROM magento.quote_id_mask;
DELETE FROM magento.quote_shipping_rate;
DELETE FROM magento.quote_payment;
DELETE FROM magento.quote_address_item;
DELETE FROM magento.quote_preview;
DELETE FROM magento.quote;
DELETE FROM magento.quote;
SET FOREIGN_KEY_CHECKS =1 ;
DELETE FROM `sales_invoice` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM `sales_invoice_grid` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM `sales_shipment` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM `sales_shipment_grid` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM `magento_rma` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM `magento_rma_grid` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01');
DELETE FROM magento_rma_shipping_label where rma_entity_id in (SELECT entity_id FROM `magento_rma` WHERE order_id in (select entity_id FROM `sales_order` WHERE created_at < '2018-01-01'));
DELETE FROM `customer_entity` where created_at < '2018-01-01';
DELETE FROM `sales_order` WHERE created_at < '2018-01-01';