Sometimes we needs to reset the complete database of orders and wants to reset the order id to again starts with 1, we can achieve this by executing below set of sql commands.<\/p>\n\n\n\n
Note: Take db backup before execution for safe side, as the below commands will delete all order related data permanently.<\/p>\n\n\n\n
SET FOREIGN_KEY_CHECKS = 0;\n\nTRUNCATE TABLE `quote`;\nTRUNCATE TABLE `quote_address`;\nTRUNCATE TABLE `quote_address_item`;\nTRUNCATE TABLE `quote_id_mask`;\nTRUNCATE TABLE `quote_item`;\nTRUNCATE TABLE `quote_item_option`;\nTRUNCATE TABLE `quote_payment`;\nTRUNCATE TABLE `quote_shipping_rate`;\nTRUNCATE TABLE `reporting_orders`;\nTRUNCATE TABLE `sales_bestsellers_aggregated_daily`;\nTRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;\nTRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;\nTRUNCATE TABLE `sales_creditmemo`;\nTRUNCATE TABLE `sales_creditmemo_comment`;\nTRUNCATE TABLE `sales_creditmemo_grid`;\nTRUNCATE TABLE `sales_creditmemo_item`;\nTRUNCATE TABLE `sales_invoice`;\nTRUNCATE TABLE `sales_invoiced_aggregated`;\nTRUNCATE TABLE `sales_invoiced_aggregated_order`;\nTRUNCATE TABLE `sales_invoice_comment`;\nTRUNCATE TABLE `sales_invoice_grid`;\nTRUNCATE TABLE `sales_invoice_item`;\nTRUNCATE TABLE `sales_order`;\nTRUNCATE TABLE `sales_order_address`;\nTRUNCATE TABLE `sales_order_aggregated_created`;\nTRUNCATE TABLE `sales_order_aggregated_updated`;\nTRUNCATE TABLE `sales_order_grid`;\nTRUNCATE TABLE `sales_order_item`;\nTRUNCATE TABLE `sales_order_payment`;\nTRUNCATE TABLE `sales_order_status_history`;\nTRUNCATE TABLE `sales_order_tax`;\nTRUNCATE TABLE `sales_order_tax_item`;\nTRUNCATE TABLE `sales_payment_transaction`;\nTRUNCATE TABLE `sales_refunded_aggregated`;\nTRUNCATE TABLE `sales_refunded_aggregated_order`;\nTRUNCATE TABLE `sales_shipment`;\nTRUNCATE TABLE `sales_shipment_comment`;\nTRUNCATE TABLE `sales_shipment_grid`;\nTRUNCATE TABLE `sales_shipment_item`;\nTRUNCATE TABLE `sales_shipment_track`;\nTRUNCATE TABLE `sales_shipping_aggregated`;\nTRUNCATE TABLE `sales_shipping_aggregated_order`;\nTRUNCATE TABLE `tax_order_aggregated_created`;\nTRUNCATE TABLE `tax_order_aggregated_updated`;\nTRUNCATE TABLE `gift_message`;\nTRUNCATE TABLE `inventory_reservation`;\nTRUNCATE TABLE `sequence_order_0`;\nTRUNCATE TABLE `sequence_order_1`;\nTRUNCATE TABLE `sequence_creditmemo_0`;\nTRUNCATE TABLE `sequence_creditmemo_1`;\nTRUNCATE TABLE `sequence_invoice_0`;\nTRUNCATE TABLE `sequence_invoice_1`;\nTRUNCATE TABLE `sequence_shipment_0`;\nTRUNCATE TABLE `sequence_shipment_1`;\n\nSET FOREIGN_KEY_CHECKS = 1;<\/pre>\n\n\n\nHope this will be helpful.<\/p>\n\n\n\n
Thanks \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"