VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: txkeyboards on July 23, 2019, 19:43:59 PM

Title: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on July 23, 2019, 19:43:59 PM
Hi everyone,

I had a problem with some (about 1 in 20 orders) that did not change statuses even though the payment was captured. The problem is, I am an admin that fulfills orders in the US so I do not have visibility into who paid and when they paid to the owner's Paypal. I never caught it and it is only a 1-2 weeks after that the buyer would contact me to ask why they did not receive any shipping notifications.

My question is where should I start to investigate this problem?

VM: 3.4.2
Joomla: 3.6.2

Thank you!
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: GJC Web Design on July 23, 2019, 21:08:28 PM
start by checking the logging .. any problems with the IPN etc should be logged in  \administrator\logs\paypal.1.log.php etc or where ever your site logging is.

You can also switch on the logging in the paypal plugin but this file can get quite large on a busy site - it will log to the same path

Check also in the Paypal account that the IPNs are being sent and receive a 200 response etc

once your logged in to your account use this url  https://www.paypal.com/us/cgi-bin/webscr?cmd=_display-ipns-history&nav=0.3.5

Do the "failed" ones have any IPN stored against them in the order/DB?

#___virtuemart_payment_plg_paypal  -> paypal_fullresponse  field
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: jenkinhill on July 23, 2019, 23:18:22 PM
@txkeyboards you should also consider updating your Joomla to the current secure version, 3.9.10, as generally VM devs and testers will only use the latest Joomla version.
Title: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on September 03, 2019, 09:07:36 AM
Quote from: GJC Web Design on July 23, 2019, 21:08:28 PM
start by checking the logging .. any problems with the IPN etc should be logged in  \administrator\logs\paypal.1.log.php etc or where ever your site logging is.

You can also switch on the logging in the paypal plugin but this file can get quite large on a busy site - it will log to the same path

Check also in the Paypal account that the IPNs are being sent and receive a 200 response etc

once your logged in to your account use this url  https://www.paypal.com/us/cgi-bin/webscr?cmd=_display-ipns-history&nav=0.3.5

Do the "failed" ones have any IPN stored against them in the order/DB?

#___virtuemart_payment_plg_paypal  -> paypal_fullresponse  field


So I saw that it said Invalid IPN validation: NO ANSWER FROM PAYPAL

What I don't understand is only SOME but not ALL has a problem. I cannot figure it out...is it my hosting problems because so many people tried to order at the same time?...

@jenkin: I have updated to the newest Joomla
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: GJC Web Design on September 03, 2019, 10:48:07 AM
QuoteSo I saw that it said Invalid IPN validation: NO ANSWER FROM PAYPAL

It means what it says and I have seen this at times on various sites ...  but I bet you will never get paypal to admit it is a problem there side

If it continues to be problematic you can disable the IPN source validation in the paypal plugin
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on September 04, 2019, 03:49:43 AM
Quote from: GJC Web Design on September 03, 2019, 10:48:07 AM
QuoteSo I saw that it said Invalid IPN validation: NO ANSWER FROM PAYPAL

It means what it says and I have seen this at times on various sites ...  but I bet you will never get paypal to admit it is a problem there side

If it continues to be problematic you can disable the IPN source validation in the paypal plugin

That is just annoying...it only happens when we have a big sale which is about every 2-3 months but we ALWAYS run into this problem. The reason I mentioned hosting problem because this only seems to be a problem for Virtuemart and Woocommerce but not Shopify.
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: AH on September 04, 2019, 11:40:20 AM
Quoteit only happens when we have a big sale which is about every 2-3 months

That is nothing to do with invalid IPN validation

You can disable IPN IP validation in the plugin - to see if that helps you

Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: GJC Web Design on September 04, 2019, 13:01:06 PM
and as the error says ... paypal didn't answer.... that puts it straight back in PPals court
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on September 04, 2019, 16:38:57 PM
Quote from: AH on September 04, 2019, 11:40:20 AM
Quoteit only happens when we have a big sale which is about every 2-3 months

That is nothing to do with invalid IPN validation

You can disable IPN IP validation in the plugin - to see if that helps you


How do I disable that? Also how will that affect the payment process?

Also I agree with that it shouldn't have anything to do with IPN but suspiciously, it always happens during the time the website has the most traffic.
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on September 04, 2019, 16:43:29 PM
Quote from: GJC Web Design on September 04, 2019, 13:01:06 PM
and as the error says ... paypal didn't answer.... that puts it straight back in PPals court
I already know that's gonna be a time-consuming conversation with them lol
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: GJC Web Design on September 04, 2019, 18:05:07 PM
Check IPN provider IP
Title: Re: Some orders did not change statuses despite payments being captured in Paypal
Post by: txkeyboards on September 10, 2019, 04:48:11 AM
Quote from: GJC Web Design on September 04, 2019, 18:05:07 PM
Check IPN provider IP

done. let's see if it's gonna happen again  :P