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 5: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,
Torge
xoomit
 
Posts: 7
Joined: Mon Jun 18, 2012 5:09 pm

Re: Order Status 0 -> Missing Orders

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

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

Re: Order Status 0 -> Missing Orders

Postby labeshops » Mon Feb 18, 2013 5: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.
User avatar
labeshops
 
Posts: 3405
Joined: Wed Aug 03, 2011 3:41 pm
Location: Florida, USA

Re: Order Status 0 -> Missing Orders

Postby xoomit » Tue Feb 19, 2013 1: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!

Best,
Torge
www.diestadtg ärtner.de
xoomit
 
Posts: 7
Joined: Mon Jun 18, 2012 5:09 pm

Re: Order Status 0 -> Missing Orders

Postby i2Paq » Tue Feb 19, 2013 2: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 _________________
Our FREE search: Find your answer FAST!.

FREE manuals: ShowMe Guides OpenCart, Opencart Check List and Our Documentation section.

BUGs?: Known BUGS for All OC Versions.

[How to] OC 1.5.4.x en hoger; BTW + Verzend + betaalmethodes.
User avatar
i2Paq
Global Moderator
 
Posts: 10879
Joined: Mon Nov 09, 2009 6:00 am
Location: Winkel - The Netherlands

Re: Order Status 0 -> Missing Orders

Postby MarketInSG » Tue Feb 19, 2013 9: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
MarketInSG
 
Posts: 5232
Joined: Tue Nov 15, 2011 10:53 pm
Location: Singapore

Re: Order Status 0 -> Missing Orders

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

There is a extension to show your Abandoned Orders http://www.opencart.com/index.php?route=extension/extension/info&extension_id=7367&filter_search=abandoned%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.
thbr02
 
Posts: 255
Joined: Wed Jun 22, 2011 9:30 am


Return to General Support

Who is online

Users browsing this forum: gindawg, Lisa WebDesigner, nexgraphics and 70 guests

Hosted by Arvixe Web Hosting