magento clean customers, orders, etc... (truncate tables)

magento-truncate.sql

#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 order
truncate sales_flat_order;
truncate sales_flat_order_address;
truncate sales_flat_order_grid;
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 payment
truncate paypal_payment_transaction;
truncate paypal_settlement_report;
truncate paypal_settlement_report_row;

#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;