EC payment received but no order

[carlvt88]

I've searched and found other threads on this, but haven't been able to fix this problem. Occasionally, I receive a payment from PayPal, but an order isn't generated in zencart.

zencart 1.3.7 w/6/17 patches
EC module (debug log to file) and money-order module installed
using ssl on godaddy

Today we received 12 orders, but 14 payments. Yesterday was roughly the same.

Today we received a number of paypal alerts:
ALERT: PayPal Express Checkout Error (10415)
10415 Transaction refused because of an invalid argument. See additional error messages for details. - A successful transaction has already been completed for this token.

Where do I go next? Our selling season is only a few weeks long and we can't afford downtime. If this is a legitimate error from PayPal, shouldn't either the funds *not* go through? Or shouldn't the order be completed?

Please help
Thanks
Carl

[DrByte]

Today we received a number of paypal alerts:
ALERT: PayPal Express Checkout Error (10415)
10415 Transaction refused because of an invalid argument. See additional error messages for details. - A successful transaction has already been completed for this token.

A "token" is generated when the customer begins the checkout process ... it's a unique ID number that identifies your customer's shopping session so that when they come back from the PayPal site their payment details get tied to the active order. Once a payment is made, the token is supposed to be cleared and a new one required in order to do another checkout. It should not be possible to place another transaction using the same token. Even using the browser's "back" button shouldn't be a problem, because Zen Cart deletes the old token upon successful checkout.

The only way I could see it being a problem is if one or more of the PayPal and/or checkout files is altered to not clear out the old token upon completing an order.

Do you have any mods installed that alter *anything* in the checkout flow?

[carlvt88]

Do you have any mods installed that alter *anything* in the checkout flow?

I did a diff on paypalwpp.php from the june 17 patch and found the following code added:

// snippet from help forum to avoid paypal address overwriting
// http://www.zen-cart.com/forum/showth...t=70906&page=2
if(isset($_SESSION['sendto']) && isset($_SESSION['customer_default_address_id'])
&& $_SESSION['sendto'] != $_SESSION['customer_default_address_id'] && isset($_SESSION['customer_id'])){
//This user has selected a shipping address other than their default address book entry
$sql = "SELECT customers_paypal_ec
FROM " . TABLE_CUSTOMERS . "
WHERE customers_id = '".$_SESSION['customer_id']."' ";
$check_customer = $db->Execute($sql);

if (!$check_customer->EOF) {
if ($check_customer->fields['customers_paypal_ec'] != '1') {
//this is not a temporary account so hide the shipping detail on the PayPal screen
$options['NOSHIPPING'] = 1;
}
}
}
// end snippet

paypal.php is identical

I've also installed superorders and the sales report addon, but I don't believe they interfere with this.

For the most part, I suggest to users that they effectively use a guest shopping cart as most of our users proceed to EC, enter a cred card, and have a zen account created for them. Of course, this doesn't always happen.

I put that code in earlier - I don't think I need it and I'll try tomorrow with it removed.

[carlvt88]

Twenty orders and no glitches today

It was an intermittant problem, so I'll continue to monitor, but I'm going to optimistic and say that was the root cause (and hopefully not jinx myself in the process).

Dr. Byte - thanks for the guidance. I really appreciate your help in this forum. Your knowledge (and lack of arrogance) really help make zencart work! (forgive the suck-up - I'm about to launch another thread )

Thanks again,
Carl