Post by jdoe » Sun Oct 21, 2012 4:44 am

Having a few issues with orders not appearing in the back-end. My wife is doing test purchases via her Paypal and although the confirmation emails are coming through both to the site and the seller and buyer Paypal accounts, there are no orders AT ALL in either the main Orders list or the Missing Orders filter. Think the IPN thing is working correctly as there are no errors related to the purchases in my error log and Paypal is not reporting anything unusual either. Site is not in maintenance mode so shouldn't be any kind of block. Probbly something fundamental I'm missing, but searching the forum is beginning to give me a headache.
The emails contain order numbers, so am assuming they have id's that are being logged somewhere - can anyone tell me how to find and read the database where these would be kept?
Using very slightly modified default installation (VQmod and a few minor theme tweaks plus Export/Import extension) on Apache with cPanel.
Any help greatly appreciated.

Newbie

Posts

Joined
Sat Oct 13, 2012 9:25 pm

Post by Tcalp » Sun Oct 21, 2012 7:05 pm

If you goto the IPN history panel in PayPal are they reporting a successful delivery or an error ? :)

Increase Page Speed (#1 rated commercial extension on OpenCart Marketplace)
15in1 Essential Extensions Value Pack Premium Customer Testimonials Reward Points Extended Admin Security Lockdown Suite

Image
irc.freenode.net #opencart


User avatar
Active Member

Posts

Joined
Wed Jul 06, 2011 1:49 pm

Post by jdoe » Tue Oct 23, 2012 3:36 am

Here's the info from paypal about the last transaction:

Message ID98C30182EJ782540R

Date/time created 20/10/2012 21:05 BST

Original/Resent Original

Latest delivery attempt date/time20/10/2012 21:05 BST

Notification URL http://chewybuy.com/store/index.php?rou ... d/callback

HTTP response code: 200

Delivery status Sent

No. of retries 0

Transaction ID05H83960TU9610526

IPN type Transaction made

So to me that looks right - and open cart sent both buyer and sender an email with order id to say the transaction had gone through. Just can't see it on the site. Here's the error log from opencart for this transaction:

2012-10-20 21:05:27 - PP_STANDARD :: IPN REQUEST: (i've removed this as it contains email addresses, real world addresses and names - let me know if you really need to see what when on here)
2012-10-20 21:05:27 - PP_STANDARD :: IPN RESPONSE: VERIFIED

why this is on the error log, i'm not sure, as it looks like everything checked out, hence VERIFIED. Let me know if this isn't as straight forward as it looks

Cheers

Newbie

Posts

Joined
Sat Oct 13, 2012 9:25 pm

Post by rfollett » Fri Nov 30, 2012 12:44 am

Did you get an answer to this issue?

I too have the same. Order placed and Paypal working but Order not apearing in Opencart backend?

I too check IPN details and I find this:

Instant Payment Notification (IPN) details

Message ID5R562175YJ966120M

Date/time created29/11/2012 16:23 GMT

Original/ResentOriginal

Latest delivery attempt date/time29/11/2012 16:24 GMT

Notification URLhttps://www.emmamartin.com/index.php?route=paym ... d/callback

HTTP response codeWhat's this?200

Delivery statusSent

No. of retries0

Transaction ID69469578DD273741Y

IPN typeTransaction made

New member

Posts

Joined
Wed Oct 24, 2012 1:09 am

Post by tipud » Tue Jan 22, 2013 9:10 pm

Hi
Has anyone had any solution to this.
I have the same problem outlined above.

Newbie

Posts

Joined
Fri Jul 15, 2011 6:38 pm
Who is online

Users browsing this forum: Baidu [Spider] and 35 guests