Mryntu

Did anyone know how to remove the Sample data from Database using Mysql script, I know we can remove using CLI, But i need a script to remove in Database.

This is what I have used to clean up test customers & orders:

-- Magento EE 2.1.1 
SET FOREIGN_KEY_CHECKS = 0;

-- Clearing all orders
TRUNCATE sales_bestsellers_aggregated_daily;
TRUNCATE sales_bestsellers_aggregated_monthly;
TRUNCATE sales_bestsellers_aggregated_yearly;

TRUNCATE sales_creditmemo;
TRUNCATE sales_creditmemo_comment;
TRUNCATE sales_creditmemo_grid;
TRUNCATE sales_creditmemo_item;
TRUNCATE sales_invoice;
TRUNCATE sales_invoice_comment;
TRUNCATE sales_invoice_grid;
TRUNCATE sales_invoice_item;
TRUNCATE sales_invoiced_aggregated;
TRUNCATE sales_invoiced_aggregated_order;
TRUNCATE sales_order;
TRUNCATE sales_order_address;
TRUNCATE sales_order_aggregated_created;
TRUNCATE sales_order_aggregated_updated;
TRUNCATE sales_order_grid;
TRUNCATE sales_order_item;
TRUNCATE sales_order_payment;
-- TRUNCATE sales_order_status;
TRUNCATE sales_order_status_history;
-- TRUNCATE sales_order_status_label;
-- TRUNCATE sales_order_status_state;
TRUNCATE sales_order_tax;
TRUNCATE sales_order_tax_item;
TRUNCATE sales_payment_transaction;
TRUNCATE sales_refunded_aggregated;
TRUNCATE sales_refunded_aggregated_order;
-- TRUNCATE sales_sequence_meta;
-- TRUNCATE sales_sequence_profile;
TRUNCATE sales_shipment;
TRUNCATE sales_shipment_comment;
TRUNCATE sales_shipment_grid;
TRUNCATE sales_shipment_item;
TRUNCATE sales_shipment_track;
TRUNCATE sales_shipping_aggregated;
TRUNCATE sales_shipping_aggregated_order;

TRUNCATE tax_order_aggregated_created;
TRUNCATE tax_order_aggregated_updated;
TRUNCATE reporting_orders;

-- EE Only
TRUNCATE magento_customercustomattributes_sales_flat_order;
TRUNCATE magento_customercustomattributes_sales_flat_order_address;
TRUNCATE magento_sales_creditmemo_grid_archive;
TRUNCATE magento_sales_invoice_grid_archive;
TRUNCATE magento_sales_order_grid_archive;
TRUNCATE magento_sales_shipment_grid_archive;


-- Clearing all cart items
TRUNCATE quote;
TRUNCATE quote_address;
TRUNCATE quote_address_item;
TRUNCATE quote_id_mask;
TRUNCATE quote_item;
TRUNCATE quote_item_option;
TRUNCATE quote_payment;
TRUNCATE quote_shipping_rate;

-- EE Only
TRUNCATE magento_customercustomattributes_sales_flat_quote;
TRUNCATE magento_customercustomattributes_sales_flat_quote_address;


-- Clearing all customers
TRUNCATE customer_address_entity;
TRUNCATE customer_address_entity_datetime;
TRUNCATE customer_address_entity_decimal;
TRUNCATE customer_address_entity_int;
TRUNCATE customer_address_entity_text;
TRUNCATE customer_address_entity_varchar;
TRUNCATE customer_dummy_cl;
-- TRUNCATE customer_eav_attribute;
-- TRUNCATE customer_eav_attribute_website;
TRUNCATE customer_entity;
TRUNCATE customer_entity_datetime;
TRUNCATE customer_entity_decimal;
TRUNCATE customer_entity_int;
TRUNCATE customer_entity_text;
TRUNCATE customer_entity_varchar;
-- TRUNCATE customer_form_attribute;
TRUNCATE customer_grid_flat;
-- TRUNCATE customer_group;
TRUNCATE customer_log;
TRUNCATE customer_visitor;
TRUNCATE persistent_session;

TRUNCATE wishlist;
TRUNCATE wishlist_item;
TRUNCATE wishlist_item_option;

-- reviews (be careful...)

TRUNCATE gift_message;
TRUNCATE review;
TRUNCATE review_detail;
-- TRUNCATE review_entity;
TRUNCATE review_entity_summary;
-- TRUNCATE review_status;
TRUNCATE review_store;

-- Clearing log tables
TRUNCATE magento_logging_event;
TRUNCATE magento_logging_event_changes;

SET FOREIGN_KEY_CHECKS = 1;