Author Topic: Some orders did not change statuses despite payments being captured in Paypal  (Read 470 times)

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
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!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9037
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27501
  • Always on vacation
    • Jenkin Hill Internet
@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.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.6.1.10121 on Joomla 3.9.11 PHP 7.0.33
Testing 3.6.1.10129 on Joomla 3.9.11

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
Some orders did not change statuses despite payments being captured in Paypal
« Reply #3 on: September 03, 2019, 09:07:36 am »
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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9037
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Quote
So 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
Quote
So 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.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2943
  • VirtueMart Version: 3.6.0
Quote
it 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

regards
A

Joomla 3.9.8
php 7.1

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9037
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
and as the error says ... paypal didn't answer.... that puts it straight back in PPals court
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
Quote
it 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.

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9037
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: Some orders did not change statuses despite payments being captured in Paypal
« Reply #10 on: September 04, 2019, 18:05:07 pm »
Check IPN provider IP
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

txkeyboards

  • Beginner
  • *
  • Posts: 20
  • A beginner
Re: Some orders did not change statuses despite payments being captured in Paypal
« Reply #11 on: September 10, 2019, 04:48:11 am »
Check IPN provider IP

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