Order Status 0 -> Missing Orders

Hej everyone,

I run a shop on opencart and realized some time ago that my order numbers are not consecutive. Now I saw that there are some orders in the DB that are not shown in the shop (which explains why some customers complain). These orders have the status "0" in the DB. How / why do orders get this status? Which one is this status? How can I prevent this so that I see ALL orders in the backend of my shop?

Thanks & best,
Torge

I have the same issue using Paypal Standard

Depending on your oc version, these orders are "Missing Orders" or "Abandoned Orders" when you filter by status in your sales > orders list.

They result from several things - a payment api call not completing back to your store (like paypal standard), a customer that only goes so far in the order process and doesn't complete the order, etc. There are several threads about the fix for paypal and other payment processors not completing so do a search (this applies if you have received a payment for those orders but they come thru on oc as "missing" or "abandoned"). Otherwise, they are incomplete orders and should not be processed, though you may want to email those customers to see if you can help them complete their order or what the issue might have been.

Hej labeshops,

got you. Great that OC already writes this into the DB...even though I doubt that you're allowed to e-mail these guys in Germany :/

Thank you so much!

Best,
Torge
www.diestadtgärtner.de

You should check you OpenCart error log, it sometimes reveals the issue why PayPal did not change the orderstatus.

Nope, if you are sure you got the IPN set up, I would say, take a look at your Paypal Account IPN history. See what they sent and the response. It's easier to debug this way. If your IPN isn't set up right, your OpenCart won't log anything

There is a extension to show your Abandoned Orders http://www.opencart.com/index.php?route ... ed%20order. The abandoned orders are not necessarily due to some error. I think they also are created if the customer almost put an order but did change it at the checkout.