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.
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.
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
irc.freenode.net #opencart
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
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
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
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
Who is online
Users browsing this forum: Baidu [Spider] and 35 guests