Magento 2: How to truncate customers, products, reviews and orders table

NOTE :: Please take database backup prior to executing these queries.

SET FOREIGN_KEY_CHECKS=0;

Truncate order tables

# Clean order history

TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;

TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;

TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

# Clean order infos

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`;

# Clean cart infos

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`;

# Reset indexes (if you want your orders number start back to 1

TRUNCATE TABLE sequence_invoice_1;

TRUNCATE TABLE sequence_order_1;

TRUNCATE TABLE sequence_shipment_1;

TRUNCATE TABLE sequence_creditmemo_1;

DO NOT TRUNCATE / EMPTY THE FOLLOWING :

sales_order_status

sales_sequence_meta

sales_sequence_profile

sales_order_status_label

sales_order_status_state

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_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;

How to Add Magento 2 Sort by Price for Low to High & High to Low Options and name A-Z & Z-A etc sort dropdown

The store design and its navigation must be in such a way that makes it easier for the shopper to find the exact required product and make the shopping process comfortable and enjoyable. Navigation can be made easier and hence improve the shopping experience by offering custom sorting options. The default Magento 2 offers sorting by position, product name, and price A price-sensitive customer may save some clicks by starting with the cheapest products. On the other hand, customers who have a high standard for quality may quickly find their most desired products by sampling from high prices to low prices. To provide such feature in Magento 2 and serve both the type of price-sensitive customers, you can add Magento 2 sort by price for low to high & high to low options. Some people can sort by names A-Z or Z-A, position low to high high to low like this we can improve sales to our site and user can easily find products for implementing this fallow given steps to implement s...

Magento Blog | For Simple Technical Solutions

Search This Blog

Magento 2: How to truncate customers, products, reviews and orders table

Comments

Post a Comment

Popular posts from this blog

Magento 2 product collection Filtering multi-select attribute values

What startSetup() and endSetup() methods actually does?

How to Add Magento 2 Sort by Price for Low to High & High to Low Options and name A-Z & Z-A etc sort dropdown