Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET FOREIGN_KEY_CHECKS = 0;
- #Truncate order tables
- TRUNCATE TABLE `gift_message`;
- TRUNCATE TABLE `quote`;
- TRUNCATE TABLE `quote_address`;
- TRUNCATE TABLE `quote_address_item`;
- TRUNCATE TABLE `quote_id_mask`;
- TRUNCATE TABLE `quote_item`;
- TRUNCATE TABLE `quote_item_option`;
- TRUNCATE TABLE `quote_payment`;
- TRUNCATE TABLE `quote_shipping_rate`;
- TRUNCATE TABLE `reporting_orders`;
- TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
- TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
- TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;
- TRUNCATE TABLE `sales_creditmemo`;
- TRUNCATE TABLE `sales_creditmemo_comment`;
- TRUNCATE TABLE `sales_creditmemo_grid`;
- TRUNCATE TABLE `sales_creditmemo_item`;
- TRUNCATE TABLE `sales_invoice`;
- TRUNCATE TABLE `sales_invoiced_aggregated`;
- TRUNCATE TABLE `sales_invoiced_aggregated_order`;
- TRUNCATE TABLE `sales_invoice_comment`;
- TRUNCATE TABLE `sales_invoice_grid`;
- TRUNCATE TABLE `sales_invoice_item`;
- TRUNCATE TABLE `sales_order`;
- TRUNCATE TABLE `sales_order_address`;
- TRUNCATE TABLE `sales_order_aggregated_created`;
- TRUNCATE TABLE `sales_order_aggregated_updated`;
- TRUNCATE TABLE `sales_order_grid`;
- TRUNCATE TABLE `sales_order_item`;
- TRUNCATE TABLE `sales_order_payment`;
- TRUNCATE TABLE `sales_order_status_history`;
- TRUNCATE TABLE `sales_order_tax`;
- TRUNCATE TABLE `sales_order_tax_item`;
- TRUNCATE TABLE `sales_payment_transaction`;
- TRUNCATE TABLE `sales_refunded_aggregated`;
- TRUNCATE TABLE `sales_refunded_aggregated_order`;
- TRUNCATE TABLE `sales_shipment`;
- TRUNCATE TABLE `sales_shipment_comment`;
- TRUNCATE TABLE `sales_shipment_grid`;
- TRUNCATE TABLE `sales_shipment_item`;
- TRUNCATE TABLE `sales_shipment_track`;
- TRUNCATE TABLE `sales_shipping_aggregated`;
- TRUNCATE TABLE `sales_shipping_aggregated_order`;
- TRUNCATE TABLE `tax_order_aggregated_created`;
- TRUNCATE TABLE `tax_order_aggregated_updated`;
- #Truncate Customer tables
- TRUNCATE TABLE `customer_address_entity`;
- TRUNCATE TABLE `customer_address_entity_datetime`;
- TRUNCATE TABLE `customer_address_entity_decimal`;
- TRUNCATE TABLE `customer_address_entity_int`;
- TRUNCATE TABLE `customer_address_entity_text`;
- TRUNCATE TABLE `customer_address_entity_varchar`;
- TRUNCATE TABLE `customer_entity`;
- TRUNCATE TABLE `customer_entity_datetime`;
- TRUNCATE TABLE `customer_entity_decimal`;
- TRUNCATE TABLE `customer_entity_int`;
- TRUNCATE TABLE `customer_entity_text`;
- TRUNCATE TABLE `customer_entity_varchar`;
- TRUNCATE TABLE `customer_grid_flat`;
- TRUNCATE TABLE `customer_log`;
- TRUNCATE TABLE `customer_log`;
- TRUNCATE TABLE `customer_visitor`;
- TRUNCATE TABLE `persistent_session`;
- TRUNCATE TABLE `wishlist`;
- TRUNCATE TABLE `wishlist_item`;
- TRUNCATE TABLE `wishlist_item_option`;
- #Truncate Review tables
- TRUNCATE TABLE `review`;
- TRUNCATE TABLE `review_detail`;
- TRUNCATE TABLE `review_entity_summary`;
- TRUNCATE TABLE `review_store`;
- #Truncate Product tables
- TRUNCATE TABLE `cataloginventory_stock_item`;
- TRUNCATE TABLE `cataloginventory_stock_status`;
- TRUNCATE TABLE `cataloginventory_stock_status_idx`;
- TRUNCATE TABLE `cataloginventory_stock_status_tmp`;
- TRUNCATE TABLE `catalog_category_product`;
- TRUNCATE TABLE `catalog_category_product_index`;
- TRUNCATE TABLE `catalog_category_product_index_tmp`;
- TRUNCATE TABLE `catalog_compare_item`;
- TRUNCATE TABLE `catalog_product_bundle_option`;
- TRUNCATE TABLE `catalog_product_bundle_option_value`;
- TRUNCATE TABLE `catalog_product_bundle_price_index`;
- TRUNCATE TABLE `catalog_product_bundle_selection`;
- TRUNCATE TABLE `catalog_product_bundle_selection_price`;
- TRUNCATE TABLE `catalog_product_bundle_stock_index`;
- TRUNCATE TABLE `catalog_product_entity`;
- TRUNCATE TABLE `catalog_product_entity_datetime`;
- TRUNCATE TABLE `catalog_product_entity_decimal`;
- TRUNCATE TABLE `catalog_product_entity_gallery`;
- TRUNCATE TABLE `catalog_product_entity_int`;
- TRUNCATE TABLE `catalog_product_entity_media_gallery`;
- TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
- TRUNCATE TABLE `catalog_product_entity_media_gallery_value_to_entity`;
- TRUNCATE TABLE `catalog_product_entity_media_gallery_value_video`;
- TRUNCATE TABLE `catalog_product_entity_text`;
- TRUNCATE TABLE `catalog_product_entity_tier_price`;
- TRUNCATE TABLE `catalog_product_entity_varchar`;
- TRUNCATE TABLE `catalog_product_index_eav`;
- TRUNCATE TABLE `catalog_product_index_eav_decimal`;
- TRUNCATE TABLE `catalog_product_index_eav_decimal_idx`;
- TRUNCATE TABLE `catalog_product_index_eav_decimal_tmp`;
- TRUNCATE TABLE `catalog_product_index_eav_idx`;
- TRUNCATE TABLE `catalog_product_index_eav_tmp`;
- TRUNCATE TABLE `catalog_product_index_price`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_idx`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_opt_idx`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_opt_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_sel_idx`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_sel_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_bundle_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_cfg_opt_agr_idx`;
- TRUNCATE TABLE `catalog_product_index_price_cfg_opt_agr_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_cfg_opt_idx`;
- TRUNCATE TABLE `catalog_product_index_price_cfg_opt_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_downlod_idx`;
- TRUNCATE TABLE `catalog_product_index_price_downlod_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_final_idx`;
- TRUNCATE TABLE `catalog_product_index_price_final_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_idx`;
- TRUNCATE TABLE `catalog_product_index_price_opt_agr_idx`;
- TRUNCATE TABLE `catalog_product_index_price_opt_agr_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_opt_idx`;
- TRUNCATE TABLE `catalog_product_index_price_opt_tmp`;
- TRUNCATE TABLE `catalog_product_index_price_tmp`;
- TRUNCATE TABLE `catalog_product_index_tier_price`;
- TRUNCATE TABLE `catalog_product_index_website`;
- TRUNCATE TABLE `catalog_product_link`;
- TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
- TRUNCATE TABLE `catalog_product_link_attribute_int`;
- TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
- TRUNCATE TABLE `catalog_product_option`;
- TRUNCATE TABLE `catalog_product_option_price`;
- TRUNCATE TABLE `catalog_product_option_title`;
- TRUNCATE TABLE `catalog_product_option_type_price`;
- TRUNCATE TABLE `catalog_product_option_type_title`;
- TRUNCATE TABLE `catalog_product_option_type_value`;
- TRUNCATE TABLE `catalog_product_relation`;
- TRUNCATE TABLE `catalog_product_super_attribute`;
- TRUNCATE TABLE `catalog_product_super_attribute_label`;
- TRUNCATE TABLE `catalog_product_super_link`;
- TRUNCATE TABLE `catalog_product_website`;
- TRUNCATE TABLE `catalog_url_rewrite_product_category`;
- TRUNCATE TABLE `downloadable_link`;
- TRUNCATE TABLE `downloadable_link_price`;
- TRUNCATE TABLE `downloadable_link_purchased`;
- TRUNCATE TABLE `downloadable_link_purchased_item`;
- TRUNCATE TABLE `downloadable_link_title`;
- TRUNCATE TABLE `downloadable_sample`;
- TRUNCATE TABLE `downloadable_sample_title`;
- TRUNCATE TABLE `product_alert_price`;
- TRUNCATE TABLE `product_alert_stock`;
- TRUNCATE TABLE `report_compared_product_index`;
- TRUNCATE TABLE `report_viewed_product_aggregated_daily`;
- TRUNCATE TABLE `report_viewed_product_aggregated_monthly`;
- TRUNCATE TABLE `report_viewed_product_aggregated_yearly`;
- TRUNCATE TABLE `report_viewed_product_index`;
- SET FOREIGN_KEY_CHECKS = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement