SET @increment_id='100002568'; //replace with your actual order ID SELECT @order_id:=entity_id FROM sales_order_entity WHERE increment_id=@increment_id; DELETE FROM sales_order_entity WHERE entity_id=@order_id OR parent_id=@order_id; DELETE FROM sales_order WHERE increment_id=@increment_id;
Now check your order you will not found the order with the order id “100002568”.
Hope this will be helpful. Thanks and Enjoy the coding.