These set of scripts are for Magento 1. For Magento 2, see this Gist.
Last active
December 29, 2023 09:51
-
-
Save leek/1219708 to your computer and use it in GitHub Desktop.
Magento 1 - Delete All Test Data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS=0; | |
-- Customers | |
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`; | |
TRUNCATE `customer_entity`; | |
TRUNCATE `customer_entity_datetime`; | |
TRUNCATE `customer_entity_decimal`; | |
TRUNCATE `customer_entity_int`; | |
TRUNCATE `customer_entity_text`; | |
TRUNCATE `customer_entity_varchar`; | |
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; | |
-- Search | |
TRUNCATE `catalogsearch_query`; | |
TRUNCATE `catalogsearch_fulltext`; | |
TRUNCATE `catalogsearch_result`; | |
ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1; | |
ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1; | |
ALTER TABLE `catalogsearch_result` AUTO_INCREMENT=1; | |
-- Polls | |
TRUNCATE `poll`; | |
TRUNCATE `poll_answer`; | |
TRUNCATE `poll_store`; | |
TRUNCATE `poll_vote`; | |
ALTER TABLE `poll` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_answer` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_store` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_vote` AUTO_INCREMENT=1; | |
-- Reports | |
TRUNCATE `report_viewed_product_index`; | |
ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; | |
-- Newsletter | |
TRUNCATE `newsletter_queue`; | |
TRUNCATE `newsletter_queue_link`; | |
TRUNCATE `newsletter_subscriber`; | |
TRUNCATE `newsletter_problem`; | |
TRUNCATE `newsletter_queue_store_link`; | |
ALTER TABLE `newsletter_queue` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_subscriber` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_problem` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_queue_store_link` AUTO_INCREMENT=1; | |
-- Wishlist | |
TRUNCATE `wishlist`; | |
ALTER TABLE `wishlist` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS=0; | |
TRUNCATE `log_customer`; | |
TRUNCATE `log_visitor`; | |
TRUNCATE `log_visitor_info`; | |
TRUNCATE `log_visitor_online`; | |
TRUNCATE `log_quote`; | |
TRUNCATE `log_summary`; | |
TRUNCATE `log_summary_type`; | |
TRUNCATE `log_url`; | |
TRUNCATE `log_url_info`; | |
TRUNCATE `sendfriend_log`; | |
TRUNCATE `report_event`; | |
TRUNCATE `dataflow_batch_import`; | |
TRUNCATE `dataflow_batch_export`; | |
TRUNCATE `index_process_event`; | |
TRUNCATE `index_event`; | |
ALTER TABLE `log_customer` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor_online` AUTO_INCREMENT=1; | |
ALTER TABLE `log_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `log_summary` AUTO_INCREMENT=1; | |
ALTER TABLE `log_url_info` AUTO_INCREMENT=1; | |
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1; | |
ALTER TABLE `report_event` AUTO_INCREMENT=1; | |
ALTER TABLE `dataflow_batch_import` AUTO_INCREMENT=1; | |
ALTER TABLE `dataflow_batch_export` AUTO_INCREMENT=1; | |
ALTER TABLE `index_event` AUTO_INCREMENT=1; | |
-- | |
-- Enterprise Edition | |
-- | |
TRUNCATE `enterprise_logging_event`; | |
TRUNCATE `enterprise_logging_event_changes`; | |
ALTER TABLE `enterprise_logging_event` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_logging_event_changes` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS = 0; | |
TRUNCATE TABLE `catalog_product_bundle_option`; | |
TRUNCATE TABLE `catalog_product_bundle_option_value`; | |
TRUNCATE TABLE `catalog_product_bundle_selection`; | |
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_text`; | |
TRUNCATE TABLE `catalog_product_entity_tier_price`; | |
TRUNCATE TABLE `catalog_product_entity_varchar`; | |
TRUNCATE TABLE `catalog_product_link`; | |
TRUNCATE TABLE `catalog_product_link_attribute`; | |
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_link_type`; | |
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_super_attribute`; | |
TRUNCATE TABLE `catalog_product_super_attribute_label`; | |
TRUNCATE TABLE `catalog_product_super_attribute_pricing`; | |
TRUNCATE TABLE `catalog_product_super_link`; | |
TRUNCATE TABLE `catalog_product_enabled_index`; | |
TRUNCATE TABLE `catalog_product_website`; | |
TRUNCATE TABLE `catalog_product_entity`; | |
-- Inventory/Stock | |
TRUNCATE TABLE `cataloginventory_stock_item`; | |
TRUNCATE TABLE `cataloginventory_stock_status`; | |
-- Categories | |
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`; | |
TRUNCATE TABLE `catalog_product_relation`; | |
TRUNCATE TABLE `catalog_product_flat_1`; | |
TRUNCATE TABLE `catalog_category_flat_store_1`; | |
TRUNCATE TABLE `catalog_category_flat_store_2`; | |
TRUNCATE TABLE `catalog_category_flat_store_3`; | |
-- Tags | |
TRUNCATE `tag`; | |
TRUNCATE `tag_relation`; | |
TRUNCATE `tag_summary`; | |
ALTER TABLE `tag` AUTO_INCREMENT=1; | |
ALTER TABLE `tag_relation` AUTO_INCREMENT=1; | |
ALTER TABLE `tag_summary` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS = 1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS=0; | |
TRUNCATE `sales_payment_transaction`; | |
TRUNCATE `sales_flat_creditmemo`; | |
TRUNCATE `sales_flat_creditmemo_comment`; | |
TRUNCATE `sales_flat_creditmemo_grid`; | |
TRUNCATE `sales_flat_creditmemo_item`; | |
TRUNCATE `sales_flat_order`; | |
TRUNCATE `sales_flat_order_address`; | |
TRUNCATE `sales_flat_order_grid`; | |
TRUNCATE `sales_flat_order_item`; | |
TRUNCATE `sales_flat_order_status_history`; | |
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_order_payment`; | |
TRUNCATE `sales_flat_quote_payment`; | |
TRUNCATE `sales_flat_quote_shipping_rate`; | |
TRUNCATE `sales_flat_shipment`; | |
TRUNCATE `sales_flat_shipment_item`; | |
TRUNCATE `sales_flat_shipment_grid`; | |
TRUNCATE `sales_flat_shipment_track`; | |
TRUNCATE `sales_flat_invoice`; | |
TRUNCATE `sales_flat_invoice_grid`; | |
TRUNCATE `sales_flat_invoice_item`; | |
TRUNCATE `sales_flat_invoice_comment`; | |
TRUNCATE `sales_order_tax`; | |
TRUNCATE `sales_order_tax_item`; | |
-- Recurring Profiles | |
TRUNCATE `sales_recurring_profile`; | |
TRUNCATE `sales_recurring_profile_order`; | |
-- Reports | |
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 `coupon_aggregated`; | |
TRUNCATE `review`; | |
TRUNCATE `review_detail`; | |
TRUNCATE `review_entity_summary`; | |
TRUNCATE `rating_store`; | |
-- | |
-- Enterprise Edition | |
-- | |
TRUNCATE `enterprise_reward`; | |
TRUNCATE `enterprise_reward_history`; | |
TRUNCATE `enterprise_customer_sales_flat_quote_address`; | |
TRUNCATE `enterprise_customer_sales_flat_quote`; | |
TRUNCATE `enterprise_customer_sales_flat_order_address`; | |
TRUNCATE `enterprise_customer_sales_flat_order`; | |
ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_order_tax_item` AUTO_INCREMENT=1; | |
-- | |
-- Enterprise Edition | |
-- | |
ALTER TABLE `enterprise_reward` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_reward_history` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_quote_address` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_order_address` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_order` AUTO_INCREMENT=1; | |
TRUNCATE `eav_entity_store`; | |
ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi thanks for such nice code snippet.
But this give error on indexing process after truncate catalog table.
I have find out this code to truncate successfully catalog table.
Please update code accordingly.
`SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE
catalog_product_bundle_option
;TRUNCATE TABLE
catalog_product_bundle_option_value
;TRUNCATE TABLE
catalog_product_bundle_selection
;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_text
;TRUNCATE TABLE
catalog_product_entity_tier_price
;TRUNCATE TABLE
catalog_product_entity_varchar
;TRUNCATE TABLE
catalog_product_link
;TRUNCATE TABLE
catalog_product_link_attribute
;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_link_type
;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_super_attribute
;TRUNCATE TABLE
catalog_product_super_attribute_label
;TRUNCATE TABLE
catalog_product_super_attribute_pricing
;TRUNCATE TABLE
catalog_product_super_link
;TRUNCATE TABLE
catalog_product_enabled_index
;TRUNCATE TABLE
catalog_product_website
;TRUNCATE TABLE
catalog_product_entity
;TRUNCATE TABLE
cataloginventory_stock
;TRUNCATE TABLE
cataloginventory_stock_item
;TRUNCATE TABLE
cataloginventory_stock_status
;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
,entity_type_id
,attribute_set_id
,parent_id
,created_at
,updated_at
,path
,position
,level
,children_count
) VALUES (1, 3, 0, 0, '2012-06-17 22:20:47', '2012-06-17 22:20:47', '1', 0, 0, 1), (2, 3, 3, 1, '2012-06-17 22:20:47', '2012-06-17 22:20:47', '1/2', 1, 1, 0);INSERT INTO
catalog_category_entity_int
(value_id
,entity_type_id
,attribute_id
,store_id
,entity_id
,value
) VALUES (1, 3, 67, 0, 1, 1), (2, 3, 67, 1, 1, 1), (3, 3, 42, 0, 2, 1), (4, 3, 67, 0, 2, 1), (5, 3, 42, 1, 2, 1), (6, 3, 67, 1, 2, 1);INSERT INTO
catalog_category_entity_varchar
(value_id
,entity_type_id
,attribute_id
,store_id
,entity_id
,value
) VALUES (1, 3, 41, 0, 1, 'Root Catalog'), (2, 3, 41, 1, 1, 'Root Catalog'), (3, 3, 43, 1, 1, 'root-catalog'), (4, 3, 41, 0, 2, 'Default Category'), (5, 3, 41, 1, 2, 'Default Category'), (6, 3, 49, 1, 2, 'PRODUCTS'), (7, 3, 43, 1, 2, 'default-category');INSERT INTO
catalog_product_link_type
(link_type_id
,code
) VALUES (1, 'relation'), (3, 'super'), (4, 'up_sell'), (5, 'cross_sell');INSERT INTO
catalog_product_link_attribute
(product_link_attribute_id
,link_type_id
,product_link_attribute_code
,data_type
) VALUES (1, 1, 'position', 'int'), (2, 3, 'position', 'int'), (3, 3, 'qty', 'decimal'), (4, 4, 'position', 'int'), (5, 5, 'position', 'int');INSERT INTO
cataloginventory_stock
(stock_id
,stock_name
) VALUES (1, 'Default');SET FOREIGN_KEY_CHECKS = 1;`
Thanks