Reset Magento 2 Database and clear all data

Owned by Laszlo Gellai (Unlicensed)
Last updated: Jul 26, 2021
2 min read

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;

Â