Gsyfuy

How to invert MapIndexed on a ragged structure? How to construct a tree from rules?

If/When UK leaves the EU, can a future goverment conduct a referendum to join the EU?

Why didn't Khan get resurrected in the Genesis Explosion?

WOW air has ceased operation, can I get my tickets refunded?

What flight has the highest ratio of time difference to flight time?

Why do remote companies require working in the US?

Is there a way to save my career from absolute disaster?

If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?

How to safely derail a train during transit?

Does it take more energy to get to Venus or to Mars?

What is "(CFMCC)" on an ILS approach chart?

Preparing Indesign booklet with .psd graphics for print

What does convergence in distribution "in the Gromov–Hausdorff" sense mean?

Why do airplanes bank sharply to the right after air-to-air refueling?

Can I equip Skullclamp on a creature I am sacrificing?

Why does standard notation not preserve intervals (visually)

How do we know the LHC results are robust?

How to solve a differential equation with a term to a power?

How to avoid supervisors with prejudiced views?

Would a completely good Muggle be able to use a wand?

Elegant way to replace substring in a regex with optional groups in Python?

Real integral using residue theorem - why doesn't this work?

Is 'diverse range' a pleonastic phrase?

Complex fractions

How to delete all orders

0

I want to delete all order from magento 2.2.5
i used that code but it didnt work... any advice?

    SET FOREIGN_KEY_CHECKS=0;



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





SET FOREIGN_KEY_CHECKS=1;

orders sql magento-2.2.5 delete

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  might be helpful please try with this marketplace.magento.com/raveinfosys-deleteorder.html
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  github.com/mageplaza/magento-2-delete-orders
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i used them but it crashes all web...
  
  – darkattack
  Sep 3 '18 at 11:26
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have you checked with the mageplaza extension?
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:56
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeap now all working fine!!! thank you for your advice!!
  
  – darkattack
  Sep 4 '18 at 12:05
  

  
  
  
  

 | 
show 1 more comment

0

I want to delete all order from magento 2.2.5
i used that code but it didnt work... any advice?

    SET FOREIGN_KEY_CHECKS=0;



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





SET FOREIGN_KEY_CHECKS=1;

orders sql magento-2.2.5 delete

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  might be helpful please try with this marketplace.magento.com/raveinfosys-deleteorder.html
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  github.com/mageplaza/magento-2-delete-orders
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i used them but it crashes all web...
  
  – darkattack
  Sep 3 '18 at 11:26
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have you checked with the mageplaza extension?
  
  – Nagaraju Kasa
  Sep 3 '18 at 11:56
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeap now all working fine!!! thank you for your advice!!
  
  – darkattack
  Sep 4 '18 at 12:05
  

  
  
  
  

 | 
show 1 more comment

I want to delete all order from magento 2.2.5
i used that code but it didnt work... any advice?

    SET FOREIGN_KEY_CHECKS=0;



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





SET FOREIGN_KEY_CHECKS=1;

orders sql magento-2.2.5 delete

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

    SET FOREIGN_KEY_CHECKS=0;



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





SET FOREIGN_KEY_CHECKS=1;

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

edited 13 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

asked Sep 3 '18 at 11:18

darkattackdarkattack

898

1 Answer
1

active

oldest

votes

1

Create your own custom module.

And use method delete of class MagentoSalesApiOrderRepositoryInterface.

That would be the safest method to do so.

share|improve this answer

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f240617%2fhow-to-delete-all-orders%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

Create your own custom module.

And use method delete of class MagentoSalesApiOrderRepositoryInterface.

That would be the safest method to do so.

share|improve this answer

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

add a comment | 

1

Create your own custom module.

And use method delete of class MagentoSalesApiOrderRepositoryInterface.

That would be the safest method to do so.

share|improve this answer

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

add a comment | 

Create your own custom module.

And use method delete of class MagentoSalesApiOrderRepositoryInterface.

That would be the safest method to do so.

share|improve this answer

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

share|improve this answer

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661

answered Sep 3 '18 at 12:46

Anshu MishraAnshu Mishra

5,53152661