{"id":1760,"date":"2021-05-09T13:34:20","date_gmt":"2021-05-09T13:34:20","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/uncancel-order-directly-from-database-in-magento\/"},"modified":"2025-05-22T10:32:05","modified_gmt":"2025-05-22T05:02:05","slug":"uncancel-order-directly-from-database-in-magento","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/uncancel-order-directly-from-database-in-magento\/","title":{"rendered":"How to Uncancel Order Directly From Database in Magento"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The default Magento does not allow the admin to uncancel an order.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, sometimes the admin is compelled to uncancel an order in Magento 1 or Magento 2 store.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, if the customer places an order and completes the payment from their side but the order gets cancelled due to a technical glitch!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Such a thing may happen while using hosted payment methods where the customer is redirected to the hosted payment gateway and returns to Magento store after payment is done. If there is an issue in the hosted page, the customer returns to the Magento store and their order is considered complete, which actually is not the case.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Integration with third party payment gateways may sometimes cause such a problem but in such case, the admin can&nbsp;<em><strong>uncancel order directly from database in Magento<\/strong><\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may use the below solution even when you mistakenly cancel an order from the backend.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Such human errors or technical glitches are going to happen but here\u2019s the way back so as to not make your customer angry and not affect your customer service adversely!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Method to Uncancel Order Directly From Database in Magento:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Go to your store\u2019s database.<br>2. Open the&nbsp;<strong>\u201csales_flat_order\u201d<\/strong>&nbsp;table<br>3. Change the \u201cstate\u201d and \u201cstatus\u201d column to&nbsp;<strong>\u201cpending_payment\u201d<\/strong>&nbsp;from \u201cCancelled\u201d as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/04\/Annotation-on-2021-03-16-at-11-05-14-1024x398.png\" alt=\"How to Uncancel Order Directly From Database in Magento\" class=\"wp-image-14682\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Don\u2019t forget to share this post with Magento Community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Continue Reading:<\/strong>&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/how-to-cancel-order-in-magento-2\/\">How to cancel order in Magento 2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The default Magento does not allow the admin to uncancel an order. However, sometimes the admin is compelled to uncancel an order in Magento 1&#8230;<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1760","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1760"}],"version-history":[{"count":2,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1760\/revisions"}],"predecessor-version":[{"id":14335,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1760\/revisions\/14335"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}