Page 4 of 6

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Mon Feb 21, 2011 11:38 pm
by Qphoria
Transaction Method:
- Sale means the payment is processed immediately and put into your account
- Authorize means the payment is held, but must manually be accepted by you within 3 days

Order Status:
- These are the order statuses that you want the order to be based on the event from paypal. Typically "Completed" is your final successful payment, so for tangible goods it would be Processing and for downloads it would be Completed
- The rest of the statuses are just mapping paypal's status to opencart's status. They are mostly one for one the same. (pending = Pending, Denied = Denied, etc)

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Tue Feb 22, 2011 12:38 am
by Qphoria
Well this is a limitation of the current download "Status" flag in opencart. You would need to set the status of download products to "Processing". But then if you change it to "Shipping" it removes the download access. I will be changing the download status to be a multiselect box so you can choose multiple states that a download is allowed to be enabled from to fix this in an upcoming version of opencart

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Sat Mar 05, 2011 10:32 am
by philbydevil
speedingorange wrote:Im Currently running paypal 1.4.2 and am finding it REALLY slow to respond between checkout/confirm page and paypal. (40 secconds+)

Would upgrading fix this?

I intend to upgrade anyhow but i want to know if this could be an issue that wont be resolved by upgrading.
I can't answer this, but this is a good little mod to let people realise that their order is being processed:

http://forum.opencart.com/viewtopic.php ... 63#p113291

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 11, 2011 6:07 am
by Qphoria
UPDATED FIRST POST (new_pp_standard_1493.3.zip)

Ok I think I fixed the issue with ATTN: Manual Verification blah blah needed

Also included:
- Uses billing address if shipping is not required
- Price mismatch check using mc_gross_1 instead of mc_gross as that includes the paypal fee

I've been running this for a few days now on my site with no issue. I've tested addresses with funky characters like

Code: Select all

Test & SÖns
12 rue du Général de Gaulle
And they no longer fail the verification.

Let me know if you have any problems.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Sat Mar 12, 2011 2:57 am
by Qphoria
ash_in99 wrote:I updated with latest version yesterday and today first time got this error emails.... when anyone bought the product.

PP_Standard - Possible Scam: IPN/PDT Price "19.00" does not match OpenCart Total "58.0000". Order needs manual verification.

PP_Standard - IPN/PDT Auto-Verification Failed. This is often caused by strange characters in the customer address or name. Verify manually.




2 products added by buyer.... 19 is correct value in Euro and 58 is correct order total in USD.

Buyer paid me in Euro, so that is the problem?

Address contains the word Coruña
hmmm.. yea the euro to usd would be an issue
But i'd hoped the other issue with auto-verification was fixed.
Can you tell me, in the data that comes with that email, do you see "charset=UTF-8"

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Sat Mar 12, 2011 5:38 am
by Qphoria
ash_in99 wrote:No UTF-8, contains this... charset=windows-1252

and some other info is...

DEBUG GET VARS::route=payment/pp_standard/pdt
tx=2F589133WF011xxxx
st=Completed
amt=42.00
cc=EUR
cm=pJOo
item_number=
ok then it looks like maybe there is an extra step needed. The "charset" field may not be overriding correctly. Try this.

Go here:
https://cms.paypal.com/us/cgi-bin/?cmd= ... min_custom

And scroll down to the section about changing your charset from windows-1252 to utf-8
Then goto History->IPN history
and resend that transaction again. If you have paypal debug enabled you should be able to see it hit the system log and see IPN: Verified or IPN: Invalid

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 7:11 am
by MattW
I've updated to the latest version this morning, and the first transaction done has come back with 2 manual verifications needed.

Code: Select all

PP_Standard - Possible Scam: IPN/PDT Price "7.50" does not match OpenCart Total "17.5000". Order needs manual verification

DEBUG GET VARS::route=payment/pp_standard/pdt
tx=9V4255497X241894N
st=Completed
amt=17.50
cc=GBP
cm=Zmpk
item_number=
and (I've ************ out some of the personal information)

Code: Select all


PP_Standard - Possible Scam: IPN/PDT Price "7.50" does not match OpenCart Total "17.5000". Order needs manual verification

DEBUG POST VARS::mc_gross=17.50
invoice=192 - Steve Saxby
protection_eligibility=Partially Eligible - INR Only address_status=unconfirmed item_number1=EGR Blanking Plate tax=0.00 item_number2=EGR Cheater payer_id=YTKW4YDZXEJEG
address_street=************
************
payment_date=15:24:25 Mar 16, 2011 PDT
payment_status=Completed
charset=windows-1252
address_zip=************
mc_shipping=0.00
mc_handling=0.00
first_name=Stephen
mc_fee=0.80
address_country_code=GB
address_name=************
notify_version=3.1
custom=Zmpk
payer_status=verified
business=************
address_country=United Kingdom
num_cart_items=2
mc_handling1=0.00
mc_handling2=0.00
address_city=************
verify_sign=Aqku5V-8-slTRLJC8ltdpfG28.UDA6luuVByr6yJMPFkqB4Z5rJVW46C
payer_email=************
mc_shipping1=0.00
mc_shipping2=0.00
txn_id=9V4255497X241894N
payment_type=instant
last_name=Saxby
address_state=
item_name1=EGR Blanking Plate
receiver_email=************
item_name2=EGR Cheater
payment_fee=
quantity1=1
quantity2=1
receiver_id=X4A8G62XPTLFS
txn_type=cart
mc_gross_1=7.50
mc_currency=GBP
mc_gross_2=10.00
residence_country=GB
transaction_subject=Zmpk
payment_gross=

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 7:26 am
by MattW
Qphoria wrote: ok then it looks like maybe there is an extra step needed. The "charset" field may not be overriding correctly. Try this.

Go here:
https://cms.paypal.com/us/cgi-bin/?cmd= ... min_custom

And scroll down to the section about changing your charset from windows-1252 to utf-8
Then goto History->IPN history
and resend that transaction again. If you have paypal debug enabled you should be able to see it hit the system log and see IPN: Verified or IPN: Invalid
Also changed character set to UTF-8 inside PayPal, resent the transaction, and still get the same error.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 9:10 am
by Qphoria
Yea that is a different error.. the fix for that is simple. .I was trying something new but didn't realize paypal split the cost differently. The big issue was the "strange character error" which I think is resolved now

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 9:18 am
by Qphoria
Ok updated the first post to fix the payment mismatch issue.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 4:40 pm
by MattW
Qphoria wrote:Ok updated the first post to fix the payment mismatch issue.
Thanks Qphoria, although it's still not working, I now get the below:

Code: Select all

PP_Standard - Possible Scam: IPN/PDT Price "0" does not match OpenCart Total "17.5000". Order needs manual verification

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 11:08 pm
by Qphoria
MattW wrote:
Qphoria wrote:Ok updated the first post to fix the payment mismatch issue.
Thanks Qphoria, although it's still not working, I now get the below:

Code: Select all

PP_Standard - Possible Scam: IPN/PDT Price "0" does not match OpenCart Total "17.5000". Order needs manual verification
I knew you'd say that :P
Does your IPN message not have a payment_gross field? that's the only way to get a "0" there.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 11:25 pm
by MattW
Qphoria wrote:
MattW wrote:
Qphoria wrote:Ok updated the first post to fix the payment mismatch issue.
Thanks Qphoria, although it's still not working, I now get the below:

Code: Select all

PP_Standard - Possible Scam: IPN/PDT Price "0" does not match OpenCart Total "17.5000". Order needs manual verification
I knew you'd say that :P
Does your IPN message not have a payment_gross field? that's the only way to get a "0" there.
;)
The field is there, but there is no value for it

Code: Select all

charset=windows-1252
payment_gross=
address_status=unconfirmed

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 11:32 pm
by Qphoria
hmm interesting.. do any other fields have the correct amount?

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Thu Mar 17, 2011 11:39 pm
by MattW
mc_gross shows the correct amount

Code: Select all

mc_gross=17.50
Have sent you a PM with the full unedited version to take a look at.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 18, 2011 12:05 am
by Qphoria
ok updated again to check payment_gross or mc_gross. Wish paypal would get their crap together and have some dependable conforming data for everyone. redownload from the first post. Only the catalog/controller/payment/pp_standard.php file has changed

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 18, 2011 12:34 am
by MattW
Thanks, have uploaded that file, and re-sent the IPN.

Haven't had any e-mails telling me they have failed, but haven't seen anything else in the error log either

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 18, 2011 12:38 am
by MattW
Now getting the following when trying to make a payment:

Code: Select all

Parse error: syntax error, unexpected ';' in /home/XXXXXX/public_html/shop/catalog/controller/payment/pp_standard.php on line 612

Code: Select all

} else (
                        $amount = 0;
                )
 
changed to

Code: Select all

} else {
                        $amount = 0;
                }
 
and it's all gone through OK.

Tested purchasing two products from my store, IPN validates now :-)

Many thanks for sorting this.

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 18, 2011 12:44 am
by Qphoria
Ok fixed... first post...
you should never code php on one pc and dos batch on another pc at the same time :P

Re: Paypal Standard Improved Ongoing (v1.4.9.3+)

Posted: Fri Mar 18, 2011 2:29 am
by MattW
New order placed by a customer, all gone through perfectly. Thanks again Qphoria