Community Forums

Order Status 0 -> Missing Orders

General support for technical problems with OpenCart v1.x

Order Status 0 -> Missing Orders

Postby xoomit » Mon Jan 28, 2013 4:57 pm

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,
Posts: 22
Joined: Mon Jun 18, 2012 4:09 pm

Re: Order Status 0 -> Missing Orders

Postby rbosworth » Mon Feb 18, 2013 3:00 pm

I have the same issue using Paypal Standard
Posts: 3
Joined: Mon Feb 18, 2013 8:48 am

Re: Order Status 0 -> Missing Orders

Postby labeshops » Mon Feb 18, 2013 4:21 pm

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.
Running Opencart v2.2 with multi-stores from which has links to all my stores.

User avatar
Posts: 4682
Joined: Wed Aug 03, 2011 2:41 pm
Location: Florida, USA

Re: Order Status 0 -> Missing Orders

Postby xoomit » Tue Feb 19, 2013 12:35 am

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!

www.diestadtg ä
Posts: 22
Joined: Mon Jun 18, 2012 4:09 pm

Re: Order Status 0 -> Missing Orders

Postby i2Paq » Tue Feb 19, 2013 1:17 am

You should check you OpenCart error log, it sometimes reveals the issue why PayPal did not change the orderstatus.
Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

UPGRADE to 2.x: Contemplate before thou begins!

Our FREE search: Find your answer FAST!.

BUGs?: Known BUGS for All OC Versions.

[How to] BTW + Verzend + betaal setup.
User avatar
Global Moderator
Posts: 12197
Joined: Mon Nov 09, 2009 5:00 am
Location: Winkel - The Netherlands

Re: Order Status 0 -> Missing Orders

Postby MarketInSG » Tue Feb 19, 2013 8:55 am

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
User avatar
Posts: 6122
Joined: Tue Nov 15, 2011 9:53 pm
Location: Singapore

Re: Order Status 0 -> Missing Orders

Postby thbr02 » Tue Feb 19, 2013 2:50 pm

There is a extension to show your Abandoned Orders 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.
Posts: 444
Joined: Wed Jun 22, 2011 8:30 am
Location: Sweden

Return to General Support

Who is online

Users browsing this forum: jalgerjr, psxgamer, Yahoo [Bot] and 84 guests

Hosted by A2 Hosting