Jump to content
Harald Ponce de Leon

Looking For Testers: New PayPal App

Recommended Posts

@@Harald Ponce de Leon

 

Few more anomalies:

 

First: Had another occurrence of a paid order vanishing - not because of status_id / admin timeout.  No idea what's happening here.  When I query the DB for the invoice id from the paypal email, and the paypal app logs, the order simply does not exist anywhere in the database, in any table.  The only place it shows up on the site at all is in the app log and the email from PayPal.

 

2nd: had an order where customer funding was on hold with paypal,...status within the order was "Pending", but it showed up in the orders list with the status assigned to "New Orders" per the app.  If I hadn't been unusually observant, I could have shipped an unpaid order.  How is the app supposed to handle a paypal payment status of 'pending' as opposed to 'completed'?  Does it distinguish?  See the image below:

 

post-292008-0-02736800-1424818783_thumb.jpg

 

3rd issue:  Had email open when a paypal payment notification hit my inbox.  That prompted me to check the orders list, as it was nearing the cutoff for same-day shipping time.  There was no order...and it didn't show up for several hours after the payment cleared.  I'm not sure if that is really a 'problem' but should it take that long for the IPN to hit the site and set new order status?  And could this be part of the process of vanishing orders?

Share this post


Link to post
Share on other sites

I have this working with paypal standard.

 

When I try to make it work with paypal express - it brings me over to paypal - shows the low order fee, but not the shipping?  Seems to be forcing me to use Paypal shipping information.

 

Questions:

 1 - Should I be seeing the my shipping quote  on the first paypal page?  I don't - I do see the low order fee.

 

I have the obsficated log at http://xtronics.com/uploads/temp-file.txt

 

 

 

 


------------------------------------------------------------------------

The first panacea for a mismanaged nation is inflation

of the currency; the second is war. Both bring a
temporary prosperity; both bring permanent ruin.
Ernest Hemingway
------------------------------------------------------------------------

Share this post


Link to post
Share on other sites

OK - after much searching: there is a setting on the shopping cart side that says:

 

 

Instant Update

Enable this to have PayPal retrieve a list of shipping rates after the customer has selected their shipping address during the Express Checkout flow.

 

This should say :

Instant Update

Enable this to have PayPal CREATE a list of shipping rates after the customer has selected their shipping address during the Express Checkout flow.


------------------------------------------------------------------------

The first panacea for a mismanaged nation is inflation

of the currency; the second is war. Both bring a
temporary prosperity; both bring permanent ruin.
Ernest Hemingway
------------------------------------------------------------------------

Share this post


Link to post
Share on other sites

I have gotten both Paypal standard and express working with the app - now attempting to get 'log-in with paypal' going.

For some reason, it uses another set of credentials - and one needs to create a REST app[sic].

The documentation has few clues, but I found one can go to
https://developer.paypal.com/webapps/developer/applications/myapps
and navigate to the REST API - then on the top click on dashboard.


One creates a sandbox account (it picks an email for you - that you might have to get to work? and there is a phone number on the account ?? nothing makes a lot of sense here)

Then you create an  API call osc and that is pretty much where I'm stuck - there are a large number of options (see attached picture) and there is an URL they are looking (calling it a webhook fails to illuminate) I would like to know what to put there.

 

post-56838-0-96990800-1426123487_thumb.png

There are about 50 settings - I'm not sure what they should be - I think that it will use paypal-express to check-out - but there is not documentation I've found.  It appears that some of these settings are for yet another payment system?

Any hints here would be welcome. ( a list from someone with a working system?)

On the OSC side - there are check-boxes and buttons to set - It seems clear that the buttons are something you are going to want regardless (so why make it optional?). It is not clear if the check-boxes for the account information would need be set or if they would cause some problem if they are set?
 


------------------------------------------------------------------------

The first panacea for a mismanaged nation is inflation

of the currency; the second is war. Both bring a
temporary prosperity; both bring permanent ruin.
Ernest Hemingway
------------------------------------------------------------------------

Share this post


Link to post
Share on other sites

@@Harald Ponce de Leon

 

Finding another problem that's intermittent.  There are some instances where a customer makes an order, and stock gets decremented twice.  I just happened to be watching as this happened.  A customer bought 4 of an item...inventory qty was 7 before the sale.  After the sale, inventory was -1.

 

Normally, I see the customer's return from PayPal, with PayPal [Transactions], then our status update: "PayPal Complete" and then 15-20 sec later, there will be an entry for the IPN:  PayPal [Transactions].  When I get a double decrement, I see the customer's return, then the IPN, then TWO status entries for "PayPal Complete."

 

The logs don't show any duplicity.  I don't understand what's happening, except it looks like the customer return and the IPN hit us at the same time.

 

This is wrecking inventory.

Share this post


Link to post
Share on other sites

This is also causing stock to go into negative figures, and in such cases, setting product to inactive.  This, in spite of the fact that I have :

 

       // if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) {
       // tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
       // }
 
In both catalog/checkout_process.php & catalog/includes/modules/payment/paypal_standard.php

Share this post


Link to post
Share on other sites

I should have pointed this out earlier, but when double decrements occur, both the customer return and the IPN have the exact same timestamp, to the second.

 

post-292008-0-27123100-1427136447_thumb.jpgpost-292008-0-87403800-1427136459_thumb.jpg

Share this post


Link to post
Share on other sites

@@Supertex

 

@@Harald Ponce de Leon

 

New module is working GREAT!

 

Especially, I like the "Pending Reason" info.

 

But I have a request:  Add "force address override" field to the configuration options?  

 

I've had to go in and set this = zero in the code each time I've updated, else certain customers get the following message when they try to submit payment:

 

"Unable to process payment.  Please contact the merchant as the shipping address provided by the merchant is invalid, and the merchant has requested that your order must be shipped to that address."

 

+1 !!!

 

 

Can you also tell me/us in which file you need to make this change?

 

Thanks!

 

Malcolm


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites

Line 747 of catalog/includes/modules/payment/paypal_standard.php

 

That is assuming you're using the 'standard' module, and you're aware of the consequence of allowing shipment to a non-verified address.

Edited by Supertex

Share this post


Link to post
Share on other sites

Hello Mr. Harald,

We are in India and we have installed this App recently.

We are having the following issues:

1. PayPal Balance is not showing up for the Live Account; it is showing the Balance only for the Sandbox Account:
Live: xxxxx
Error: The PayPal balance could not be retrieved. Please try again.
Sandbox: xxxxx
USD: $....
Log detail is as follows:
Request
USER     xxxxx
PWD     xxxxx
SIGNATURE     xxxxx/cert_key_pem.txt
VERSION     204
METHOD     GetBalance
RETURNALLCURRENCIES     1
Response
TIMESTAMP     2017-07-08T15:23:54Z
CORRELATIONID     86f5a89392345
ACK     Failure
VERSION     204
BUILD     29297572
L_ERRORCODE0     10002
L_SHORTMESSAGE0     Security error
L_LONGMESSAGE0     Security header is not valid
L_SEVERITYCODE0     Error

2. PayPal Express Checkut is showing error for the Live Account even though we are able to place the order through the same with our Sandbox Account:
shopping_cart.php?error_message=Security header is not valid
Log detail is as follows:
Request
VERSION     204
METHOD     SetExpressCheckout
PAYMENTREQUEST_0_PAYMENTACTION     Sale
RETURNURL     xxxxx/ext/modules/payment/paypal/express.php?osC_Action=retrieve
CANCELURL     xxxxx/ext/modules/payment/paypal/express.php?osC_Action=cancel
BRANDNAME     xxxxx
SOLUTIONTYPE     Sole
USER     xxxxx
PWD     xxxxx
SIGNATURE     xxxxx/cert_key_pem.txt
PAYMENTREQUEST_0_CURRENCYCODE     USD
PAYMENTREQUEST_0_SHIPTONAME     xxxxx
PAYMENTREQUEST_0_SHIPTOSTREET     xxxxx
PAYMENTREQUEST_0_SHIPTOSTREET2     
PAYMENTREQUEST_0_SHIPTOCITY     xxxxx
PAYMENTREQUEST_0_SHIPTOSTATE     LA
PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE     US
PAYMENTREQUEST_0_SHIPTOZIP     71203
PAYMENTREQUEST_0_AMT     265.56
PAYMENTREQUEST_0_CUSTOM     2114999024071893
Response
TIMESTAMP     2017-07-08T11:45:38Z
CORRELATIONID     b2d0111077be4
ACK     Failure
VERSION     204
BUILD     35915193
L_ERRORCODE0     10002
L_SHORTMESSAGE0     Security error
L_LONGMESSAGE0     Security header is not valid
L_SEVERITYCODE0     Error

PayPal Standard Checkout is working fine in our website.

Please let us know as to what to do in this regard.

Thanks,

Lakshmanan

 

 

Share this post


Link to post
Share on other sites

I have a nearly similar problem like @celexel.

The App v. 5.0.18 ist working. OsC is 2.3.4. is also working perfect.
The SSL-Test for cURL and "whatever" was successfull. The site itself dont has https.

I 'm using "Login with Paypal" and "Payments Standard".
All is fine.
But I cant retrieve the balance from my PP-Acc.
I can see the amount in the Sandbox.

The log shows me:

Request
USER 	xxx
PWD 	xxx
SIGNATURE 	xxx
VERSION 	204
METHOD 	GetBalance
RETURNALLCURRENCIES 	1
Response
TIMESTAMP 	2017-07-17T13:33:01Z
CORRELATIONID 	ee46b82e4d84
ACK 	Failure
VERSION 	204
BUILD 	29297572
L_ERRORCODE0 	10002
L_SHORTMESSAGE0 	Security error
L_LONGMESSAGE0 	Security header is not valid
L_SEVERITYCODE0 	Error

Has anybody suggestions, please?

Share this post


Link to post
Share on other sites

cURL Version: 7.53.1
cURL SSL Version: OpenSSL/1.0.1e

Default Setting: Success
TLS v1.2: Success

Share this post


Link to post
Share on other sites

Another mismatch value issue:
PayPal refund value (-146.86) does not match order value (146.86)

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×