Author Topic: PayPal not setting orders to Confirmed  (Read 2217 times)

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2998
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: PayPal not setting orders to Confirmed
« Reply #15 on: June 06, 2020, 09:09:04 am »
What are your status in paypal payment configuration to allow ipn updates ?

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Gingerweb

  • Jr. Member
  • **
  • Posts: 60
  • A beginner
Re: PayPal not setting orders to Confirmed
« Reply #16 on: June 06, 2020, 09:12:20 am »
What are your status in paypal payment configuration to allow ipn updates ?

Jörgen @ Kreativ Fotografi

Hi thanks for having a look, see attached screenshot of the config, i have tried lots of options, sandbox and live

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9779
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: PayPal not setting orders to Confirmed
« Reply #17 on: June 06, 2020, 10:01:10 am »
Quote
I can confirm that the response is 200 though

then this confirms all OK from the paypal end and the reception of the IPN

is the IPN response logged in the  #_virtuemart_payment_plg_paypal table?

Personally I wouldn't use the sandbox  .. just make a 1p product with free shipping as a test
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

Gingerweb

  • Jr. Member
  • **
  • Posts: 60
  • A beginner
Re: PayPal not setting orders to Confirmed
« Reply #18 on: June 06, 2020, 14:56:56 pm »
Quote
I can confirm that the response is 200 though

then this confirms all OK from the paypal end and the reception of the IPN

is the IPN response logged in the  #_virtuemart_payment_plg_paypal table?

Personally I wouldn't use the sandbox  .. just make a 1p product with free shipping as a test

Thanks - yes i have done exactly that and there is an entry in that table referencing this 1p sale (it is still "pending")

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2998
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: PayPal not setting orders to Confirmed
« Reply #19 on: June 06, 2020, 21:31:35 pm »
If You look at order datails is there only ONE DateAdded/ShopperNotified/OrderStatus/Comment entry for each order ?
And this entry sais Pending ?
You should have two entries for a PayPal purchase, Pending and Confirmed.

Turn on PayPal debug and debug to file.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Gingerweb

  • Jr. Member
  • **
  • Posts: 60
  • A beginner
Re: PayPal not setting orders to Confirmed
« Reply #20 on: June 06, 2020, 23:10:53 pm »
If You look at order datails is there only ONE DateAdded/ShopperNotified/OrderStatus/Comment entry for each order ?
And this entry sais Pending ?
You should have two entries for a PayPal purchase, Pending and Confirmed.

Is this in Orders? There appears to be only one entry for each test order and everything says "pending"

Turn on PayPal debug and debug to file.

Code: [Select]
PayPal request::
Array
(
        [cmd]   ⇒   _ext-enter
        [redirect_cmd]   ⇒   _xclick
        [paymentaction]   ⇒   sale
        [upload]   ⇒   1
        [business]   ⇒   shopemail@domain.co.uk
        [receiver_email]   ⇒   shopemail@domain.co.uk
        [order_number]   ⇒   6DN3021
        [invoice]   ⇒   6DN3021
        [custom]   ⇒   e6c1efc39293032a880513d6823ed60b
        [currency_code]   ⇒   GBP
        [address_override]   ⇒   0
        [first_name]   ⇒   test
        [last_name]   ⇒   test
        [address1]   ⇒   test
        [address2]   ⇒ 
        [zip]   ⇒   test
        [city]   ⇒   test
        [state]   ⇒   EN
        [country]   ⇒   GB
        [email]   ⇒   email@myemail.co.uk
        [night_phone_b]   ⇒   test
        [return]   ⇒   https://foam-o.co.uk/index.php?option=com_virtuemart&view=vmplg&task=pluginresponsereceived&on=6DN3021&pm=4&Itemid=567
        [notify_url]   ⇒   https://foam-o.co.uk/index.php?option=com_virtuemart&view=vmplg&task=notify&tmpl=component&lang=
        [cancel_return]   ⇒   https://foam-o.co.uk/index.php?option=com_virtuemart&view=vmplg&task=pluginUserPaymentCancel&on=6DN3021&pm=4&Itemid=567&lang=
        [rm]   ⇒   2
        [bn]   ⇒   VirtueMart_Cart_PPA
        [no_shipping]   ⇒   0
        [no_note]   ⇒   1
        [image_url]   ⇒   https://foam-o.co.uk/images/stories/virtuemart/vendor/paypal-smaller-logo-foam-o.jpg
        [item_name]   ⇒   Order   Number:   6DN3021
        [amount]   ⇒   0.01
)

url that brought me back to the shop after Paypal payment accepted is :

https://foam-o.co.uk/index.php?option=com_virtuemart&view=vmplg&task=pluginresponsereceived&on=6DN3021&pm=4&Itemid=567

Order is "pending"  :(

Hope this shows you something useful!!
cheers

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9779
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: PayPal not setting orders to Confirmed
« Reply #21 on: June 07, 2020, 11:07:23 am »
Quote
https://foam-o.co.uk/index.php?option=com_virtuemart&view=vmplg&task=pluginresponsereceived&on=6DN3021&pm=4&Itemid=567

just brings up some weird "sitelock" thing.. if I can't reach the site then neither can paypal

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

Gingerweb

  • Jr. Member
  • **
  • Posts: 60
  • A beginner
Re: PayPal not setting orders to Confirmed
« Reply #22 on: June 07, 2020, 11:45:27 am »

just brings up some weird "sitelock" thing.. if I can't reach the site then neither can paypal

FFS im so sorry of course, usually i build these on temp sites where it can be unlocked, this one is a live domain that is locked, i turned it off to test it and it works perfectly!
Thanks John for pointing out my stupidity!

kvo

  • Beginner
  • *
  • Posts: 7
Re: PayPal not setting orders to Confirmed
« Reply #23 on: July 03, 2020, 15:36:56 pm »
I have the same response as Gingerweb.
It may have started after the latest update. I updated to Joomla 3.9.19, VM 3.8.4
I also have another shop, using the same settings that was not affected.
I have tried quiet a few fixes, but no change. Still get Pending as the order status.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9779
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: PayPal not setting orders to Confirmed
« Reply #24 on: July 03, 2020, 15:56:58 pm »
all the information and tests that you need to do are in this thread..  do them and write back here the results...
Because the system works unless there is a problem or misconfiguration of your site .. something, with the information you give, we can do nothing to help...
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

kvo

  • Beginner
  • *
  • Posts: 7
Re: PayPal not setting orders to Confirmed
« Reply #25 on: July 03, 2020, 16:16:48 pm »
I turned on debugs and after placing the order, BEFORE I get to Paypal, the debug shows as below. But the refresh icon keeps spinning and the button that says"The method is in debug mode. Click here to be redirected to PayPal" is not able to be clicked as the page continues to refresh.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9779
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: PayPal not setting orders to Confirmed
« Reply #26 on: July 03, 2020, 16:59:09 pm »
then switch the debug off and just examine the logging
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

kvo

  • Beginner
  • *
  • Posts: 7
Re: PayPal not setting orders to Confirmed
« Reply #27 on: July 03, 2020, 18:14:56 pm »
ok thanks, There is nothing in the paypal_response_invoice or paypal_full_response fields...

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9779
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: PayPal not setting orders to Confirmed
« Reply #28 on: July 03, 2020, 18:48:58 pm »
have u read this post?  your paypal IPN history etc? your IPN response url tested?
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

kvo

  • Beginner
  • *
  • Posts: 7
Re: PayPal not setting orders to Confirmed
« Reply #29 on: July 23, 2020, 15:34:46 pm »
Yes, I've been through everything I can think of.  The IPN history shows all since a month ago status as "Retrying".  My IPN HTTP Response Codes for these failed attempts are 403.