Describe when someone would need this information. For example "when connecting to wi-fi for the first time".
- Clearing all products
- Clearing all reviews
- Clearing all customers
- Clearing all attributes
- Clearing all attribute sets
- Clearing all categories
- Clearing all search results
- Clearing all orders, shipments, transactions etc.
- Reset all ID counters
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `PREFIX_catalog_product_bundle_option`; TRUNCATE TABLE `PREFIX_catalog_product_bundle_option_value`; TRUNCATE TABLE `PREFIX_catalog_product_bundle_selection`; TRUNCATE TABLE `PREFIX_catalog_product_entity_datetime`; TRUNCATE TABLE `PREFIX_catalog_product_entity_decimal`; TRUNCATE TABLE `PREFIX_catalog_product_entity_gallery`; TRUNCATE TABLE `PREFIX_catalog_product_entity_int`; TRUNCATE TABLE `PREFIX_catalog_product_entity_media_gallery`; TRUNCATE TABLE `PREFIX_catalog_product_entity_media_gallery_value`; TRUNCATE TABLE `PREFIX_catalog_product_entity_text`; TRUNCATE TABLE `PREFIX_catalog_product_entity_tier_price`; TRUNCATE TABLE `PREFIX_catalog_product_entity_varchar`; TRUNCATE TABLE `PREFIX_catalog_product_link`; TRUNCATE TABLE `PREFIX_catalog_product_link_attribute`; TRUNCATE TABLE `PREFIX_catalog_product_link_attribute_decimal`; TRUNCATE TABLE `PREFIX_catalog_product_link_attribute_int`; TRUNCATE TABLE `PREFIX_catalog_product_link_attribute_varchar`; TRUNCATE TABLE `PREFIX_catalog_product_link_type`; TRUNCATE TABLE `PREFIX_catalog_product_option`; TRUNCATE TABLE `PREFIX_catalog_product_option_price`; TRUNCATE TABLE `PREFIX_catalog_product_option_title`; TRUNCATE TABLE `PREFIX_catalog_product_option_type_price`; TRUNCATE TABLE `PREFIX_catalog_product_option_type_title`; TRUNCATE TABLE `PREFIX_catalog_product_option_type_value`; TRUNCATE TABLE `PREFIX_catalog_product_super_attribute_label`; TRUNCATE TABLE `PREFIX_catalog_product_super_attribute`; TRUNCATE TABLE `PREFIX_catalog_product_super_link`; TRUNCATE TABLE `PREFIX_catalog_product_website`; TRUNCATE TABLE `PREFIX_catalog_category_product_index`; TRUNCATE TABLE `PREFIX_catalog_category_product`; TRUNCATE TABLE `cataloginventory_stock_item`; TRUNCATE TABLE `cataloginventory_stock_status`; TRUNCATE TABLE `cataloginventory_stock`; TRUNCATE TABLE `PREFIX_catalog_product_entity`; INSERT INTO `PREFIX_catalog_product_link_type`(`link_type_id`,`code`) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell'); INSERT INTO `PREFIX_catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal'); INSERT INTO `cataloginventory_stock`(`stock_id`,`website_id`,`stock_name`) VALUES (1,0,'Default'); |
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `PREFIX_rating_option_vote`; TRUNCATE TABLE `PREFIX_rating_option_vote_aggregated`; TRUNCATE TABLE `PREFIX_review`; TRUNCATE TABLE `PREFIX_review_detail`; TRUNCATE TABLE `PREFIX_review_entity_summary`; TRUNCATE TABLE `PREFIX_review_store`; |
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE `PREFIX_customer_address_entity`; TRUNCATE `PREFIX_customer_address_entity_datetime`; TRUNCATE `PREFIX_customer_address_entity_decimal`; TRUNCATE `PREFIX_customer_address_entity_int`; TRUNCATE `PREFIX_customer_address_entity_text`; TRUNCATE `PREFIX_customer_address_entity_varchar`; TRUNCATE `PREFIX_customer_entity`; TRUNCATE `PREFIX_customer_entity_datetime`; TRUNCATE `PREFIX_customer_entity_decimal`; TRUNCATE `PREFIX_customer_entity_int`; TRUNCATE `PREFIX_customer_entity_text`; TRUNCATE `PREFIX_customer_entity_varchar`; ALTER TABLE `PREFIX_customer_address_entity` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_address_entity_datetime` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_address_entity_decimal` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_address_entity_int` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_address_entity_text` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_address_entity_varchar` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity_datetime` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity_decimal` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity_int` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity_text` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_customer_entity_varchar` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `PREFIX_catalog_category_entity`; TRUNCATE TABLE `PREFIX_catalog_category_entity_datetime`; TRUNCATE TABLE `PREFIX_catalog_category_entity_decimal`; TRUNCATE TABLE `PREFIX_catalog_category_entity_int`; TRUNCATE TABLE `PREFIX_catalog_category_entity_text`; TRUNCATE TABLE `PREFIX_catalog_category_entity_varchar`; TRUNCATE TABLE `PREFIX_catalog_category_product`; TRUNCATE TABLE `PREFIX_catalog_category_product_index`; INSERT INTO `PREFIX_catalog_category_entity` (`entity_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES (1, 0, 0, '2016-05-09 08:03:52', '2016-05-09 08:03:52', '1', 0, 0, 1), (2, 3, 1, '2016-05-09 08:03:52', '2016-05-09 08:03:52', '1/2', 1, 1, 0); |
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE `PREFIX_sales_order`; TRUNCATE `PREFIX_sendfriend_log`; TRUNCATE `PREFIX_wishlist`; TRUNCATE `PREFIX_report_event`; ALTER TABLE `PREFIX_sales_order` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_sendfriend_log` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_wishlist` AUTO_INCREMENT=1; ALTER TABLE `PREFIX_report_event` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `PREFIX_catalogsearch_fulltext_scope1`; TRUNCATE TABLE `PREFIX_catalogsearch_fulltext_scope2`; TRUNCATE TABLE `PREFIX_search_query`; |
TRUNCATE `PREFIX_eav_entity_store`; ALTER TABLE `PREFIX_eav_entity_store` AUTO_INCREMENT=1; |