magento-truncate.sql

SET FOREIGN_KEY_CHECKS = 0;

#truncate customers
truncate customer_entity;
truncate customer_address_entity;
truncate log_customer;
truncate salesrule_customer;
truncate salesrule_coupon_usage;
truncate newsletter_subscriber;
truncate persistent_session;
truncate product_alert_price;
truncate product_alert_stock;
truncate wishlist;
truncate wishlist_item;
truncate wishlist_item_option;

#truncate billing aggreements
truncate sales_billing_agreement;
truncate sales_billing_agreement_order;

#truncate quotes
truncate log_quote;
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;

#truncate order
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;
truncate sales_order_aggregated_created;
truncate sales_order_aggregated_updated;
truncate sales_order_tax;
truncate sales_order_tax_item;
truncate tax_order_aggregated_created;
truncate tax_order_aggregated_updated;
truncate sales_recurring_profile_order;
truncate sales_refunded_aggregated_order;
truncate coupon_aggregated;
truncate coupon_aggregated_updated;
truncate coupon_aggregated_order;
truncate sales_billing_agreement_order;
truncate mw_onestepcheckout;

#truncate payment
truncate paypal_payment_transaction;
truncate paypal_settlement_report;
truncate paypal_settlement_report_row;
truncate sales_payment_transaction;

#truncate invoices
truncate sales_flat_invoice;
truncate sales_flat_invoice_comment;
truncate sales_flat_invoice_grid;
truncate sales_flat_invoice_item;
truncate sales_invoiced_aggregated;
truncate sales_invoiced_aggregated_order;

#truncate creditmemo
truncate sales_flat_creditmemo;
truncate sales_flat_creditmemo_comment;
truncate sales_flat_creditmemo_grid;
truncate sales_flat_creditmemo_item;

#truncate shipment
truncate sales_flat_shipment;
truncate sales_flat_shipment_comment;
truncate sales_flat_shipment_grid;
truncate sales_flat_shipment_item;
truncate sales_flat_shipment_track;
truncate sales_shipping_aggregated;
truncate sales_shipping_aggregated_order;

#truncate sales bestseelers
truncate sales_bestsellers_aggregated_daily;
truncate sales_bestsellers_aggregated_monthly;
truncate sales_bestsellers_aggregated_yearly;

#truncate logs
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;
truncate sendfriend_log;
truncate report_viewed_product_index;
truncate report_compared_product_index;
truncate report_event;
truncate index_event;
truncate dataflow_batch_export;
truncate dataflow_batch_import;

SET FOREIGN_KEY_CHECKS = 1;