Magento 2 test data clean using my sql query

Before runing this query please take your database backup.You may face too many redirect issue in category admin view. So that error please check any third party module is using the category data or not for ex.. mageplaza seo, amasty xsearch this type of module may cause some issue in category view page.

Delete all customers at once.

SET FOREIGN_KEY_CHECKS=0; -- Customers 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_visitor`; TRUNCATE TABLE `persistent_session`; TRUNCATE TABLE `product_alert_price`; TRUNCATE TABLE `product_alert_stock`; TRUNCATE TABLE `vault_payment_token`; TRUNCATE TABLE `vault_payment_token_order_payment_link`; ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1; ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1; ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1; ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1; ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1; ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1; ALTER TABLE `customer_entity` AUTO_INCREMENT=1; ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1; ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1; ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1; ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1; ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1; ALTER TABLE `customer_grid_flat` AUTO_INCREMENT=1; ALTER TABLE `customer_log` AUTO_INCREMENT=1; ALTER TABLE `customer_visitor` AUTO_INCREMENT=1; ALTER TABLE `persistent_session` AUTO_INCREMENT=1; ALTER TABLE `product_alert_price` AUTO_INCREMENT=1; ALTER TABLE `product_alert_stock` AUTO_INCREMENT=1; ALTER TABLE `vault_payment_token` AUTO_INCREMENT=1; ALTER TABLE `vault_payment_token_order_payment_link` AUTO_INCREMENT=1; -- Wishlist TRUNCATE TABLE `wishlist`; TRUNCATE TABLE `wishlist_item`; TRUNCATE TABLE `wishlist_item_option`; ALTER TABLE `wishlist` AUTO_INCREMENT=1; ALTER TABLE `wishlist_item` AUTO_INCREMENT=1; ALTER TABLE `wishlist_item_option` AUTO_INCREMENT=1; -- Newsletter TRUNCATE TABLE `newsletter_subscriber`; TRUNCATE TABLE `newsletter_queue`; TRUNCATE TABLE `newsletter_queue_link`; TRUNCATE TABLE `newsletter_queue_store_link`; TRUNCATE TABLE `newsletter_problem`; ALTER TABLE `newsletter_subscriber` AUTO_INCREMENT=1; SET FOREIGN_KEY_CHECKS=1;

Delete all logs at once.

SET FOREIGN_KEY_CHECKS=0; TRUNCATE TABLE `report_event`; 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`; ALTER TABLE `report_event` AUTO_INCREMENT=1; ALTER TABLE `report_compared_product_index` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_daily` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_monthly` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_yearly` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; SET FOREIGN_KEY_CHECKS=1;

Delete all sales order at once.

SET FOREIGN_KEY_CHECKS=0; 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 TABLE `paypal_payment_transaction`; TRUNCATE TABLE `paypal_settlement_report`; TRUNCATE TABLE `paypal_settlement_report_row`; ALTER TABLE `gift_message` AUTO_INCREMENT=1; ALTER TABLE `quote` AUTO_INCREMENT=1; ALTER TABLE `quote_address` AUTO_INCREMENT=1; ALTER TABLE `quote_address_item` AUTO_INCREMENT=1; ALTER TABLE `quote_id_mask` AUTO_INCREMENT=1; ALTER TABLE `quote_item` AUTO_INCREMENT=1; ALTER TABLE `quote_item_option` AUTO_INCREMENT=1; ALTER TABLE `quote_payment` AUTO_INCREMENT=1; ALTER TABLE `quote_shipping_rate` AUTO_INCREMENT=1; ALTER TABLE `reporting_orders` AUTO_INCREMENT=1; ALTER TABLE `sales_bestsellers_aggregated_daily` AUTO_INCREMENT=1; ALTER TABLE `sales_bestsellers_aggregated_monthly` AUTO_INCREMENT=1; ALTER TABLE `sales_bestsellers_aggregated_yearly` AUTO_INCREMENT=1; ALTER TABLE `sales_creditmemo` AUTO_INCREMENT=1; ALTER TABLE `sales_creditmemo_comment` AUTO_INCREMENT=1; ALTER TABLE `sales_creditmemo_grid` AUTO_INCREMENT=1; ALTER TABLE `sales_creditmemo_item` AUTO_INCREMENT=1; ALTER TABLE `sales_invoice` AUTO_INCREMENT=1; ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1; ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1; ALTER TABLE `sales_invoice_comment` AUTO_INCREMENT=1; ALTER TABLE `sales_invoice_grid` AUTO_INCREMENT=1; ALTER TABLE `sales_invoice_item` AUTO_INCREMENT=1; ALTER TABLE `sales_order` AUTO_INCREMENT=1; ALTER TABLE `sales_order_address` AUTO_INCREMENT=1; ALTER TABLE `sales_order_aggregated_created` AUTO_INCREMENT=1; ALTER TABLE `sales_order_aggregated_updated` AUTO_INCREMENT=1; ALTER TABLE `sales_order_grid` AUTO_INCREMENT=1; ALTER TABLE `sales_order_item` AUTO_INCREMENT=1; ALTER TABLE `sales_order_payment` AUTO_INCREMENT=1; ALTER TABLE `sales_order_status_history` AUTO_INCREMENT=1; ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1; ALTER TABLE `sales_order_tax_item` AUTO_INCREMENT=1; ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1; ALTER TABLE `sales_refunded_aggregated` AUTO_INCREMENT=1; ALTER TABLE `sales_refunded_aggregated_order` AUTO_INCREMENT=1; ALTER TABLE `sales_shipment` AUTO_INCREMENT=1; ALTER TABLE `sales_shipment_comment` AUTO_INCREMENT=1; ALTER TABLE `sales_shipment_grid` AUTO_INCREMENT=1; ALTER TABLE `sales_shipment_item` AUTO_INCREMENT=1; ALTER TABLE `sales_shipment_track` AUTO_INCREMENT=1; ALTER TABLE `sales_shipping_aggregated` AUTO_INCREMENT=1; ALTER TABLE `sales_shipping_aggregated_order` AUTO_INCREMENT=1; ALTER TABLE `tax_order_aggregated_created` AUTO_INCREMENT=1; ALTER TABLE `tax_order_aggregated_updated` AUTO_INCREMENT=1; ALTER TABLE `paypal_payment_transaction` AUTO_INCREMENT=1; ALTER TABLE `paypal_settlement_report` AUTO_INCREMENT=1; ALTER TABLE `paypal_settlement_report_row` AUTO_INCREMENT=1; SET FOREIGN_KEY_CHECKS=1;

Delete all products at once.

SET FOREIGN_KEY_CHECKS=0; -- Products 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`; ALTER TABLE `cataloginventory_stock_item` AUTO_INCREMENT=1; ALTER TABLE `cataloginventory_stock_status` AUTO_INCREMENT=1; ALTER TABLE `cataloginventory_stock_status_idx` AUTO_INCREMENT=1; ALTER TABLE `cataloginventory_stock_status_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_category_product` AUTO_INCREMENT=1; ALTER TABLE `catalog_category_product_index` AUTO_INCREMENT=1; ALTER TABLE `catalog_category_product_index_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_compare_item` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_option` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_option_value` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_price_index` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_selection` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_selection_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_bundle_stock_index` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_datetime` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_decimal` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_gallery` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_int` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_media_gallery` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_media_gallery_value` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_media_gallery_value_to_entity` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_media_gallery_value_video` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_text` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_tier_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_entity_varchar` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav_decimal` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav_decimal_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav_decimal_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_eav_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_opt_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_opt_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_sel_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_sel_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_bundle_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_cfg_opt_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_cfg_opt_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_downlod_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_downlod_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_final_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_final_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_opt_agr_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_opt_agr_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_opt_idx` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_opt_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_price_tmp` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_tier_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_index_website` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_link` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_link_attribute_decimal` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_link_attribute_int` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_link_attribute_varchar` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option_title` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option_type_price` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option_type_title` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_option_type_value` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_relation` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_super_attribute` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_super_attribute_label` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_super_link` AUTO_INCREMENT=1; ALTER TABLE `catalog_product_website` AUTO_INCREMENT=1; ALTER TABLE `catalog_url_rewrite_product_category` AUTO_INCREMENT=1; ALTER TABLE `downloadable_link` AUTO_INCREMENT=1; ALTER TABLE `downloadable_link_price` AUTO_INCREMENT=1; ALTER TABLE `downloadable_link_purchased` AUTO_INCREMENT=1; ALTER TABLE `downloadable_link_purchased_item` AUTO_INCREMENT=1; ALTER TABLE `downloadable_link_title` AUTO_INCREMENT=1; ALTER TABLE `downloadable_sample` AUTO_INCREMENT=1; ALTER TABLE `downloadable_sample_title` AUTO_INCREMENT=1; ALTER TABLE `product_alert_price` AUTO_INCREMENT=1; ALTER TABLE `product_alert_stock` AUTO_INCREMENT=1; ALTER TABLE `report_compared_product_index` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_daily` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_monthly` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_aggregated_yearly` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; -- Reviews TRUNCATE TABLE `rating_option_vote`; TRUNCATE TABLE `rating_option_vote_aggregated`; TRUNCATE TABLE `review`; TRUNCATE TABLE `review_detail`; TRUNCATE TABLE `review_entity_summary`; TRUNCATE TABLE `review_store`; ALTER TABLE `review` AUTO_INCREMENT=1; ALTER TABLE `review_detail` AUTO_INCREMENT=1; ALTER TABLE `review_entity_summary` AUTO_INCREMENT=1; ALTER TABLE `review_store` AUTO_INCREMENT=1; ALTER TABLE `rating_option_vote` AUTO_INCREMENT=1; ALTER TABLE `rating_option_vote_aggregated` AUTO_INCREMENT=1; SET FOREIGN_KEY_CHECKS=1;

Delete all categories at once.

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE catalog_category_entity; TRUNCATE TABLE catalog_category_entity_datetime; TRUNCATE TABLE catalog_category_entity_decimal; TRUNCATE TABLE catalog_category_entity_int; TRUNCATE TABLE catalog_category_entity_text; TRUNCATE TABLE catalog_category_entity_varchar; TRUNCATE TABLE catalog_category_product; TRUNCATE TABLE catalog_category_product_index; INSERT INTO `catalog_category_entity` (`entity_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES ('1', '0', '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '1', '0', '0', '1'), ('2', '3', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '1/2', '1', '1', '0'); INSERT INTO `catalog_category_entity_int` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES ('1', '69', '0', '1', '1'), ('2', '46', '0', '2', '1'), ('3', '69', '0', '2', '1'); INSERT INTO `catalog_category_entity_varchar` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES ('1', '45', '0', '1', 'Root Catalog'), ('2', '45', '0', '2', 'Default Category'); SET FOREIGN_KEY_CHECKS = 1; DELETE FROM url_rewrite WHERE entity_type = 'category';

Delete all sales rule at once.

SET FOREIGN_KEY_CHECKS=0; TRUNCATE TABLE `salesrule`; TRUNCATE TABLE `salesrule_coupon`; TRUNCATE TABLE `salesrule_coupon_aggregated`; TRUNCATE TABLE `salesrule_coupon_aggregated_order`; TRUNCATE TABLE `salesrule_coupon_aggregated_updated`; TRUNCATE TABLE `salesrule_coupon_usage`; TRUNCATE TABLE `salesrule_customer`; TRUNCATE TABLE `salesrule_customer_group`; TRUNCATE TABLE `salesrule_label`; TRUNCATE TABLE `salesrule_product_attribute`; TRUNCATE TABLE `salesrule_website`; SET FOREIGN_KEY_CHECKS=1;