{"id":472,"date":"2014-10-14T03:52:26","date_gmt":"2014-10-13T21:52:26","guid":{"rendered":"http:\/\/promincproductions.com\/blog\/?p=472"},"modified":"2021-10-23T13:58:00","modified_gmt":"2021-10-23T18:58:00","slug":"magento-change-status-shipped-processed","status":"publish","type":"post","link":"https:\/\/promincproductions.com\/blog\/magento-change-status-shipped-processed\/","title":{"rendered":"Magento 1: Change status from Shipped to Processed"},"content":{"rendered":"
\"In<\/a>
In Magento, changing a shipped status back to processed is not so easy, yet your customers rely on accurate messaging. Find out how to change this status back.<\/figcaption><\/figure><\/div>\n\n\n\n

I ran into a case today where an order got miss-marked in Magneto as being shipped.  The Magento Admin (CE 1.6) doesn’t have an option to change this status back to processed.  So sadly, to get this corrected, you need to go into your database and manually modify two columns.<\/p>\n\n\n\n

If you aren’t familiar with manual DB edit and\/or the potential risk that could come from doing this, consider this your fair warning to tread lightly in here.  You can create more issues quickly than you fix if you make a mistake.<\/p>\n\n\n\n

With that weak disclaimer out there, let’s move forward.  Since all hosting environments are a bit different, it’s up to you to know how to get into your Database, but I generally use PHP MyAdmin.<\/p>\n\n\n\n

Once in, go to the following two tables:<\/p>\n\n\n\n

  • sales_flat_order<\/li>
  • sales_flat_order_grid<\/li><\/ul>\n\n\n\n

    In both of these tables, find the record that matches your order.  In my case, I was able to do a search by the increment_id<\/strong> using the order number.<\/p>\n\n\n\n

    Edit the row for that order, changing the status<\/strong> field to the appropriate value:<\/p>\n\n\n\n

    • processing (new order)<\/li>
    • canceled (canceled order)<\/li>
    • processed (payment processed, order not shipped)<\/li>
    • complete (order shipped)<\/li><\/ul>\n\n\n\n

      In my case, to remove the shipped<\/strong> status, I simply had to change complete<\/strong> to processed<\/strong> in both tables and all was set.<\/p>\n\n\n\n

      I hope this helps!<\/p>","protected":false},"excerpt":{"rendered":"

      I ran into a case today where an order got miss-marked in Magneto as being shipped.  The Magento […]<\/p>\n","protected":false},"author":1,"featured_media":474,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wprm-recipe-roundup-name":"","wprm-recipe-roundup-description":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[46,5],"tags":[],"class_list":["post-472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento","category-website-development"],"jetpack_featured_media_url":"https:\/\/promincproductions.com\/blog\/wp-content\/uploads\/2014\/10\/Magento-Shipped-Status.jpg","jetpack_shortlink":"https:\/\/wp.me\/p4BbcR-7C","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/posts\/472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":3,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":2044,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions\/2044"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/media\/474"}],"wp:attachment":[{"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/promincproductions.com\/blog\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}