Snippets

Mathias Elle Remove Customer Data from Magento Database

Created by Mathias Elle

File clear Added

  • Ignore whitespace
  • Hide word diff
+SET FOREIGN_KEY_CHECKS=0;
+
+-- Customers
+TRUNCATE `customer_entity`;
+TRUNCATE `customer_entity_datetime`;
+TRUNCATE `customer_entity_decimal`;
+TRUNCATE `customer_entity_int`;
+TRUNCATE `customer_entity_text`;
+TRUNCATE `customer_entity_varchar`;
+
+-- Customer Addresses
+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`;
+
+-- Quotes
+TRUNCATE `sales_flat_quote`;
+TRUNCATE `sales_flat_quote_address`;
+TRUNCATE `sales_flat_quote_address_item`;
+TRUNCATE `sales_flat_quote_item`;
+TRUNCATE `sales_flat_quote_item_option`;
+TRUNCATE `sales_flat_quote_payment`;
+TRUNCATE `sales_flat_quote_shipping_rate`;
+
+-- Orders
+TRUNCATE `sales_flat_order`;
+TRUNCATE `sales_flat_order_address`;
+TRUNCATE `sales_flat_order_grid`;
+TRUNCATE `sales_flat_order_item`;
+TRUNCATE `sales_flat_order_payment`;
+TRUNCATE `sales_flat_order_status_history`;
+
+-- Invoices
+TRUNCATE `sales_flat_invoice`;
+TRUNCATE `sales_flat_invoice_comment`;
+TRUNCATE `sales_flat_invoice_grid`;
+TRUNCATE `sales_flat_invoice_item`;
+
+-- Shipments
+TRUNCATE `sales_flat_shipment`;
+TRUNCATE `sales_flat_shipment_comment`;
+TRUNCATE `sales_flat_shipment_grid`;
+TRUNCATE `sales_flat_shipment_item`;
+TRUNCATE `sales_flat_shipment_track`;
+
+-- Sales Order Tax
+TRUNCATE `sales_order_tax`;
+TRUNCATE `sales_order_tax_item`;
+
+-- Creditmemos
+TRUNCATE `sales_flat_creditmemo`;
+TRUNCATE `sales_flat_creditmemo_comment`;
+TRUNCATE `sales_flat_creditmemo_grid`;
+TRUNCATE `sales_flat_creditmemo_item`;
+
+-- Aggregated report tables
+TRUNCATE `coupon_aggregated`;
+TRUNCATE `coupon_aggregated_order`;
+TRUNCATE `coupon_aggregated_updated`;
+TRUNCATE `report_viewed_product_aggregated_daily`;
+TRUNCATE `report_viewed_product_aggregated_monthly`;
+TRUNCATE `report_viewed_product_aggregated_yearly`;
+TRUNCATE `sales_bestsellers_aggregated_daily`;
+TRUNCATE `sales_bestsellers_aggregated_monthly`;
+TRUNCATE `sales_bestsellers_aggregated_yearly`;
+TRUNCATE `sales_invoiced_aggregated`;
+TRUNCATE `sales_invoiced_aggregated_order`;
+TRUNCATE `sales_order_aggregated_created`;
+TRUNCATE `sales_order_aggregated_updated`;
+TRUNCATE `sales_refunded_aggregated`;
+TRUNCATE `sales_refunded_aggregated_order`;
+TRUNCATE `sales_shipping_aggregated`;
+TRUNCATE `sales_shipping_aggregated_order`;
+TRUNCATE `tax_order_aggregated_created`;
+TRUNCATE `tax_order_aggregated_updated`;
+
+-- Log tables
+TRUNCATE `log_customer`;
+TRUNCATE `log_quote`;
+TRUNCATE `log_summary`;
+TRUNCATE `log_summary_type`;
+TRUNCATE `log_url`;
+TRUNCATE `log_url_info`;
+TRUNCATE `log_visitor`;
+TRUNCATE `log_visitor_info`;
+TRUNCATE `log_visitor_online`;
+
+-- Miscellaneous
+TRUNCATE `catalogsearch_query`;
+TRUNCATE `index_event`;
+TRUNCATE `index_process_event`;
+TRUNCATE `report_event`;
+TRUNCATE `report_viewed_product_index`;
+TRUNCATE `sendfriend_log`;
+TRUNCATE `tag`;
+TRUNCATE `tag_relation`;
+TRUNCATE `tag_summary`;
+TRUNCATE `wishlist`;
+
+SET FOREIGN_KEY_CHECKS=1;