Zen Cart Logo
Forums / General Questions / Order in database but went missing in admin after an error during status udpate

Order in database but went missing in admin after an error during status udpate

Views: 702

Results 1 to 2 of 2
20 Dec 2011, 8:22 AM
#1
anne_badger avatar

anne_badger

New Zenner

Join Date:
Nov 2011
Posts:
4
Plugin Contributions:
0

Order in database but went missing in admin after an error during status udpate

Hi All,

I am posting this in the hope of helping someone else who has the same problem I did. I typed the following post and as I finished I thought of a possible solution, tried it and it worked.> "I have looked at the other threads and can't find one that suits my question, so please forgive me if I have missed something.

Twice now (on different occassions and for no apparent reason) when I have been in the process of updating a status of an order I have gotten an internet error page and the order disappears from the order list in admin. I have checked the database and both orders are still there. The sale still appears in the reports and the client still shows as having ordered in No. of Orders under Customers. For all intents and purposes the orders are there except in admin orders. I assume the order is in some sort of limbo caught between update statuses but it doesn't appear even in the All Orders listing.

I would appreciate any help anyone can give in being able to reinstate the orders in the order list."My solution, which worked for me and may work for you too, in the orders screen (where the order is missing) I typed in the order number (I got it from the original order confirmation) and it opened the order. I updated the status (doesn't matter what to) and pressed teh update button and it is now back on the order list.

I hope this helps someone else. I have posted it because I find it frustrating when people find an answer for their problem but don't post what it was. If this helps you please let me know.

20 Dec 2011, 8:26 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Order in database but went missing in admin after an error during status udpate

Hi Anne,
Yes, that's an ideal fix. On a technical level, the reason the order "went missing" is because somehow it was assigned an invalid order status. When you searched-and-found it by number, and then updated it to a new/valid status, it was then back in line and able to show up in the list properly.
Thanks for sharing your workaround.