[SOLVED] Status set to "none" on PayPal return

-- url of the page with the problem -- : http://vi_nt_ag_e-_pi_ct_ur_es.com/ (please remove underscaores)
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 3.2.0
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : Error_message

When I place an order and check out the running order currently goes like this:

1. When viewing checkout / after loggin in, etc... Click "Finish"
2. The order is placed in the database with status "created"
3. The user is forwarded to PayPal
4. User begins to make payment
5. Finally, when PayPal confirms payment (and before returning to my website) the order status is set to "None"
6. Upon returning to my website the order status is still "None"

With the order status set to "none" no confirmation e-mail is sent and the user cannot access their downloads... what an I doing wrong?

SOLVED!! Please scroll to the bottom to read what my problem was.

OK, a schoolboy error!

In the PayPal plugin config I had neglected to change "verified status" from "none" to "confirmed". I have done that and now I'm a step further... but it's still not fixed.

Now, when an order is finalised the status is "created" as before, however instead of the status being set to "none" when payment is completed, it remains on "created".

??

For the record, my main config settings under Hika > System > Configuration > Main > Order are...

Default order status = created
Payment confirmed order status = confirmed
Invoice order statuses = confirmed,shipped
Cancelled order statuses = cancelled,refunded

These, as far as I recall, are the default settings and have not been amended.

Hi,

Thanks to check in the order if you have paypal logs, or in the report file in Configuration > Main > Files if there is any errors returned.

Hi Xavier

Nothing there I'm afraid. I checked the log file under Configuration > Main > Files and it was empty. I then activated the PayPal plugin "debug" feature, made another transaction, checked the log file again and still it's blank.

I have also tried setting the PayPal plugin "return method" to "No".

I notice in the order details the "last modified" date does not change after the payment has been taken.

According to PayPal the payments are going through successfully.

Incidentally, I recently set up another shop using Hikashop and the PayPal setup works fine. I've been comparing the configuration of the two sites side by side and I can't see any significant differences between them. The main difference between two are the version of Joomla they are running - the shop I am having difficulty with is running the brand new J3.2.0... the functioning shop is running J!3.1.5.

Sorry about all the posts

I'm another step forward... in experimenting I set the PayPal "Pending Status" to "cancelled" instead of just "created". This meant that the statuses for a fresh order and a pending order were now different.

After completing the payment (PayPal said the payment was successful again) the order status has now changed to "Cancelled" - in other words, PayPal thinks the payment has been successful but the message is getting garbled on its way back to HikeShop because it thinks the order is still pending.

Previously in my order histories I was only seeing the fact that each order had been simply created. In this recent test order I now see this... it looks like PayPal is actually returning a "payment status = pending"

Array ( [option] => com_hikashop [ctrl] => checkout [task] => notify [notif_payment] => paypal [tmpl] => component [lang] => en [Itemid] => 126 [mc_gross] => 0.01 [invoice] => 22 [protection_eligibility] => Eligible [address_status] => confirmed [item_number1] => The Signist's Book of Modern Alphabets [payer_id] => KX95SCHXRPUKY [tax] => 0.00 [address_street] => XXXX [payment_date] => 09:31:08 Nov 07, 2013 PST [payment_status] => Pending [charset] => windows-1252 [address_zip] => HD9 1UA [mc_shipping] => 0.00 [mc_handling] => 0.00 [first_name] => XXXX [address_country_code] => GB [address_name] => XXXX [notify_version] => 3.7 [custom] => [payer_status] => unverified [business] => XXXXXX [address_country] => United Kingdom [num_cart_items] => 1 [mc_handling1] => 0.00 [address_city] => XXXX [verify_sign] => XXXX [payer_email] => XXXX [mc_shipping1] => 0.00 [tax1] => 0.00 [txn_id] => 02G96709Y9585660T [payment_type] => instant [last_name] => XXXX [address_state] => [item_name1] => The Signist's Book of Modern Alphabets [receiver_email] => XXXX [quantity1] => 1 [receiver_id] => UQZCL4ST89MAA [pending_reason] => multi_currency [txn_type] => cart [mc_gross_1] => 0.01 [mc_currency] => USD [residence_country] => GB [receipt_id] => 3958-0847-2121-9590 [transaction_subject] => [payment_gross] => 0.01 [ipn_track_id] => f1aa72b26f14f [hikashop_front_end_main] => 1 [view] => checkout ) stdClass Object ( [order_id] => 22 [order_billing_address_id] => 2 [order_shipping_address_id] => 2 [order_user_id] => 3 [order_status] => created [order_type] => sale [order_number] => Z22 [order_created] => 1383845417 [order_modified] => 1383845417 [order_invoice_id] => 0 [order_invoice_number] => [order_invoice_created] => 0 [order_currency_id] => 2 [order_full_price] => 0.01000 [order_tax_info] => Array ( ) [order_discount_code] => [order_discount_price] => 0.00000 [order_discount_tax] => 0.00000 [order_payment_id] => 1 [order_payment_method] => paypal [order_payment_price] => 0.00000 [order_payment_params] => [order_shipping_id] => [order_shipping_method] => [order_shipping_price] => 0.00000 [order_shipping_tax] => 0.00000 [order_shipping_params] => [order_partner_id] => 0 [order_partner_price] => 0.00000 [order_partner_paid] => 0 [order_partner_currency_id] => 0 [order_ip] => 188.223.237.87 ) Array ( [scheme] => https [host] => www.paypal.com [path] => /cgi-bin/webscr [query] => [port] => 443 [host_socket] => ssl://www.paypal.com ) POST /cgi-bin/webscr HTTP/1.1 User-Agent: PHP/5.3.27 Referer: http://vi_nt_ag_e-_pi_ct_ur_es.com/index.php?option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypal&tmpl=component&lang=en&Itemid=126 Server: Apache Host: www.paypal.com Content-Type: application/x-www-form-urlencoded Content-Length: 1261 Accept: */* Connection: close option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypal&tmpl=component&lang=en&Itemid=126&mc_gross=0.01&invoice=22&protection_eligibility=Eligible&address_status=confirmed&item_number1=The+Signist%27s+Book+of+Modern+Alphabets&payer_id=KX95SCHXRPUKY&tax=0.00&address_street=XXXX&payment_date=09%3A31%3A08+Nov+07%2C+2013+PST&payment_status=Pending&charset=windows-1252&address_zip=XXXX&mc_shipping=0.00&mc_handling=0.00&first_name=XXXX&address_country_code=GB&address_name=XXXX¬ify_version=3.7&custom=&payer_status=unverified&business=XXXX&address_country=United+Kingdom&num_cart_items=1&mc_handling1=0.00&address_city=XXXX&verify_sign=AYDz3VVi23rWDCvyhP.w27AHO-M8AN3uHjR1aOs3-h5LjwQR.hyA7em1&payer_email=XXXX&mc_shipping1=0.00&tax1=0.00&txn_id=02G96709Y9585660T&payment_type=instant&last_name=XXXX&address_state=&item_name1=The+Signist%27s+Book+of+Modern+Alphabets&receiver_email=XXXXFc&quantity1=1&receiver_id=UQZCL4ST89MAA&pending_reason=multi_currency&txn_type=cart&mc_gross_1=0.01&mc_currency=USD&residence_country=GB&receipt_id=3958-0847-2121-9590&transaction_subject=&payment_gross=0.01&ipn_track_id=f1aa72b26f14f&hikashop_front_end_main=1&view=checkout&cmd=_notify-validate HTTP/1.1 200 OK Server: Apache X-Frame-Options: SAMEORIGIN Strict-Transport-Security: max-age=14400 Strict-Transport-Security: max-age=14400 Content-Type: text/html; charset=UTF-8 DC: slc-b-origin-www-2.paypal.com Date: Thu, 07 Nov 2013 17:31:12 GMT Content-Length: 8 Connection: close Set-Cookie: cwrClyrK4LoCV1fydGbAxiNL6iG=w3snO82bmxdHNInGGm4ujBX6nU_rNCFgDPTLIcXsvsjkSP49hW9gepBs6uAu2tdMRsEiZCqfQwlVmon4PbmV6Eoy8iKV2JBeQtwSLtEZrdItaDYGOWmVzi6WvRps6LWoP5dQbbEsERnPcKGOPQe5lBOme2eIuqzq_CGmuoewGQd5T_pCbeEucVxiJcOqHe3KWlg9Xua5CEIU9bb3K9bd4v0kANBRR8hGpu237uRSeNqWsX8OVDnFYsSseSmiAa3MCzl25lAwK7X2muS7SbdN_jroEav9bHizOeAVHJl1I2AVGiKGwDlUZGbJ53KmrTs6IcQG4_RSR2gPTYN3k4Q35ofCqkpxVGBXw0qqO19vZ-Kls0ZkErunzS-9-9otfNDCjUzFVaVDCaFFOoNzKBToOUYrJjp_80JIdYAAD4gX7j1_YgfA2E_dhxMQ8tO; domain=.paypal.com; path=/; Secure; HttpOnly Set-Cookie: cookie_check=yes; expires=Sun, 05-Nov-2023 17:31:12 GMT; domain=.paypal.com; path=/; Secure; HttpOnly Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly Set-Cookie: navlns=0.0; expires=Sat, 07-Nov-2015 17:31:12 GMT; domain=.paypal.com; path=/; Secure; HttpOnly Set-Cookie: Apache=10.74.8.134.1383845471674441; path=/; expires=Sat, 31-Oct-43 17:31:11 GMT Set-Cookie: X-PP-SILOVER=name%3DLIVE6.WEB.1%26silo_version%3D880%26app%3Dslingshot%26TIME%3D1607367506; domain=.paypal.com; path=/; Secure; HttpOnly Set-Cookie: X-PP-SILOVER=; Expires=Thu, 01 Jan 1970 00:00:01 GMT Set-Cookie: Apache=10.74.8.63.1383845471668542; path=/; expires=Sat, 31-Oct-43 17:31:11 GMT Set-Cookie: DC=slc-b-origin-www-2.paypal.com; secure Set-Cookie: aksession=1383845772~id=cookieZWTqYeagF4NEcWaaiiWvAvqbaoq9z3Vib6azHcOe/BrvvKbzjD++xONgOf1CeBf+OIm6yDcJqWBLNPWvRAd3LcEituX+EQIwjxAwDq7Sb2w0DdTt776ZQDsGfXmmaN8X3dySrHR38as=; expires=Thu, 07-Nov-2013 17:36:12 GMT; path=/; domain=.paypal.com VERIFIED PayPal transaction id: 02G96709Y9585660T

SOLVED!

I could have tracked this one down a lot sooner if I'd checked in my PayPal account to see what was going on in there!

I am happy to report that both HikaShop and PayPal have been behaving according to the book, and that my configuration of HikaShop was also on the money... the problem was elsewhere.

Basically my problem was this - my PayPal account is in GB£. The payments I wish to take are in US$. When a US$ payment arrives in my PayPal account it automatically goes into pending state... when I checked in my PayPal account I had a bunch of payments waiting to be accepted and converted into GB£.

I solved it simply by creating a UD$ balance within my PayPal account alongside my GB£ balance. This means I can accept automatically payments in either currency.

Interestingly, moments after I added this US$ balance to my PayPal account I checked back in on the order statuses in my HikaShop to discover that every single pending order was now confirmed!