Post by crispylettuce » Mon Sep 17, 2012 1:46 am

Update (21.09)This now seems sorted, and near the bottom is a link to a thread which solved the issue for me.



Afternoon,

I have looked at lots of posts and either there are no answers to them, or the answers do not solve my issue..

I have tried to set up my paypal standard for my sites(have multi stores setup), and the orders are going missing.
The payments are going through as my shops PayPal email address says you recieved payment, but its not registering in admin. Also if i log on as the 'customer' who brought the item the order history is empty

set up details,
OC version 1.5.4
Template - Standard
Paypal standard - have set up as per documentation (http://www.opencart.com/index.php?route ... 8_32_35_60)

Here is an piece from the guide for troubleshooting,
Resolving the issue. You still need to fix the actual IPN block issue to prevent this from happening. The issue can be caused by a number of reasons:

Where to begin. First login to your paypal account. Under "History" click on "IPN History". That will take you to a page that has all the IPN callback attempts. Click on the "Message ID" of the transaction you want to check. It will open a page with more details about the message. It will have an "HTTP Response Code" area. If you see blank or anything other than 200, then that means Paypal IPN could NOT reach your site. This usually means a firewall or bad redirect on your host. You can try to contact your hosting provider for help on resolving this. You should also disable your .htaccess file and see if that helps.
I have checked this and it shows the 200 response code, and i have attached the image from it
Screen Shot 2012-09-16 at 18.34.51.png

Screen Shot 2012-09-16 at 18.34.51.png (40.75 KiB) Viewed 22671 times



I am also getting no errors in the vQmod or System Error logs

Has anyone got any ideas or suggestions ?

Assuming i havent missed something, i am correct in setting the Auto Return address as purely http://www.mysite.com dont it, (my current eCommerce site had to specify a 'success page'

Andy
Last edited by crispylettuce on Sat Sep 22, 2012 4:49 am, edited 3 times in total.

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by crispylettuce » Mon Sep 17, 2012 3:43 am

Update: Just disabled All extensions to see if issue, and still the same. Payment processes but there is no order confirmation, Unless i go to the Missing Orderes filter. :(

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by labeshops » Mon Sep 17, 2012 8:53 pm

Somewhere there is a post about a setting in paypal for encoding. I cannot find it off hand, but that and changing my mail setting from stmp to mail is what solved this issue for me.

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by labeshops » Mon Sep 17, 2012 9:03 pm

Ok here is what I followed & it solved the issue - step 11 is I think what did it. http://www.opencart.com/index.php?route ... 8_32_35_60

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by crispylettuce » Mon Sep 17, 2012 10:07 pm

labeshops wrote:Ok here is what I followed & it solved the issue - step 11 is I think what did it. http://www.opencart.com/index.php?route ... 8_32_35_60
Thanks for the tip, will look into this as soon as get chance. Im pretty sure i did this, although i was getting pretty annoyed yesterday so may of messed up.

Wil look into it later when i have more time to double and treble check with a clear head :) then will report back.

Andy

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by crispylettuce » Mon Sep 17, 2012 11:52 pm

Just thought, for the AutoReturn URL if my site in OC is put in the settings as http://mydomain.com. I am correct in putting it in the Return URL as the same, and dont need to put www. in front?


UPDATE: I just doubled checked the settings in PayPal and all is exactly how the guide is set out, and i have doubled checked the email address in OC is set correct and it defiently is. Just check the IPN for the latest 'purchase' and its the same as before still.


Andy

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by crispylettuce » Tue Sep 18, 2012 2:24 am

UPDATE 2: I have just, disabled the SEO links in the (Settings > Server) and put the htaccess file to excatly how it would be from 'new' and just attempeted an order and the payment goes through fine BUT the order still goes missing...

Update 3:
Just done a fresh install on a directory of my domain (eg my domain/shop) and done a sale, and i had the exact same thing again with missing sales.....

To me this must point to EITHER > PayPal Setting > Which i have doubled and trebled check and is as per set up guide OR Something to do with my Host. I have doubled checked it has Curl (like it says in guide) and i have been told its installed and working.

This leave the following options to check (as per guide)
• Port blocking on your server
• Bad .htaccess redirection rules
• Using .htaccess basic authentication login on your server

the bottom two i feel i can rule out, as i put this file back to standard and was the same still. How can i check if a Port is blocking my server?

Andy

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by mrtick » Tue Sep 18, 2012 4:33 am

I've done ALL the fixes and the completed orders are still showing up as "canceled". I just don't know what to do either.

Newbie

Posts

Joined
Sun Sep 09, 2012 1:05 am

Post by Daniel » Tue Sep 18, 2012 5:19 pm

mrtick wrote:I've done ALL the fixes and the completed orders are still showing up as "canceled". I just don't know what to do either.

let me guess? you deleted some of your order statuses. and never re-saved paypal standard order statuses and what they should be set to. so they are coming up as 0 in the order history thereby ending up in missing orders.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by crispylettuce » Tue Sep 18, 2012 5:34 pm

Daniel wrote:
mrtick wrote:I've done ALL the fixes and the completed orders are still showing up as "canceled". I just don't know what to do either.

let me guess? you deleted some of your order statuses. and never re-saved paypal standard order statuses and what they should be set to. so they are coming up as 0 in the order history thereby ending up in missing orders.

Hi Daniel, what do you me by deleted some of your order statuses, and never re saved paypal?

are you referring to the matching the Canceled to canceled, pending to pending etc. If it is this is all set correct for me.

You got any suggestions, as you can see from above i get the 200 response which means it reaches my site??

Andy

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by crispylettuce » Wed Sep 19, 2012 6:40 am

Does anyone know what port could be blocking this from working so I could ask my host to check? (not sure if this is even possible, just trying to think of things)

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by jfincanon » Thu Sep 20, 2012 8:57 pm

*bump*
I'm having the exact same problem and can't find an answer anywhere.

*edit*
I've been looking around online and finding that people have been having this issues since as far back as version 1.3.x. and that it seems there is no real response from anyone at OpenCart in regards to a good solution. Definitely frustrating.

Newbie

Posts

Joined
Thu Sep 20, 2012 8:50 pm

Post by crispylettuce » Thu Sep 20, 2012 10:32 pm

UPDATE:

Been looking around and found somewhere saying PayPal needing port 80 open, and my hosting by Arvixe have assured me that this is open, and fine.

Also looked in the PayPal sandbox site thing(which i know absolutely nothing about), If i go to TEST TOOLS > Instant Payment Notification (IPN) Simulator and if i put my address in like i have done in the paypal settings it comes back as IPN successfully sent. So does this tell me the IPN reaches my site ok???


Andy

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by jfincanon » Fri Sep 21, 2012 2:16 am

Found an answer that worked for me here: http://forum.opencart.com/viewtopic.php?f=21&t=81300

On the IPN settings page of my PayPal account, I changed the notification URL from http://www.mysite.com to http://www.mysite.com/index.php?route=p ... d/callback

I am now getting the order notification email and the order shows up in the admin section of my site.

Newbie

Posts

Joined
Thu Sep 20, 2012 8:50 pm

Post by crispylettuce » Fri Sep 21, 2012 3:36 am

jfincanon wrote:Found an answer that worked for me here: http://forum.opencart.com/viewtopic.php?f=21&t=81300

On the IPN settings page of my PayPal account, I changed the notification URL from http://www.mysite.com to http://www.mysite.com/index.php?route=p ... d/callback

I am now getting the order notification email and the order shows up in the admin section of my site.

just had a read through, and still no luck for me :(

Glad you have yours sorted now :)

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by jfincanon » Fri Sep 21, 2012 11:19 am

...and now mine stopped working again.
Last edited by jfincanon on Fri Sep 21, 2012 7:51 pm, edited 1 time in total.

Newbie

Posts

Joined
Thu Sep 20, 2012 8:50 pm

Post by jfincanon » Fri Sep 21, 2012 12:03 pm

Found something else that seems to have fixed it for good...

"there was a bug in the encryption class of the last one. just re-download it and replace the system > library > encryption.php file."

Link here: http://forum.opencart.com/viewtopic.php ... 40#p332499

Newbie

Posts

Joined
Thu Sep 20, 2012 8:50 pm

Post by crispylettuce » Sat Sep 22, 2012 2:56 am

jfincanon wrote:Found something else that seems to have fixed it for good...

"there was a bug in the encryption class of the last one. just re-download it and replace the system > library > encryption.php file."

Link here: http://forum.opencart.com/viewtopic.php ... 40#p332499

Sounds good......will be looking at this after dinner...fingers crossed :)

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by crispylettuce » Sat Sep 22, 2012 3:45 am

Well it seems fixed...Wahoo....Gonna run some test sales tomorrow and will double check but seems ok...

Thanks to everyone who tried to help with ideas and suggestions etc, especially jfincannon for pointing me to the thread about the encryption.

Active Member

Posts

Joined
Fri Aug 03, 2012 8:54 pm

Post by beachgeek » Fri Nov 09, 2012 9:34 am

I followed the link to the thread you said concerned the encryption.php file for the paypal bug but that thread says nothing about it???
this is the link you listed??

http://forum.opencart.com/viewtopic.php ... 40#p332499

Newbie

Posts

Joined
Tue Aug 02, 2011 1:37 pm
Who is online

Users browsing this forum: No registered users and 5 guests