CRE Loaded Community

We are having a problem when some customers place a second order immediately after placing an order.
The second order will have the same order number as the previous order on the customer's invoice.
We receive the payment but there is no record of the second order in the database.

So it's a duplicate order (ie same stuff) then? Who are you hosted with and are they (or you) running any 'page optimization' mods like mod_pagespeed on the server?

Simon

No. not a duplicate order.
I will try to explain better.

Customer John Smith comes to my shopping cart and wants to place two separate orders.
The first order is going to be shipped to himself.
John completes the first order and is given order number 2111.
After completing the first order he begins placing a second order that he will have shipped to his grandmother.
John completes the second order and is given order number 2111 for the second order as well.
I receive the payment for both orders.
However only the first order shows up in the database.
The only record of the second order is the fact that I have received payment for both orders.

I hope I explained clearly.

Not really - still sounds weird. So obvious problem then is sessions not being reset, causing the same order number to be reused:

What payment module are you using for this result? Does it work if you tried test orders like this using say money order or bank transfer? At least you'd narrowed it down if one of them works.
Also check sessions settings in the admin >> configuration >> sessions - only thing 'true' usually is 'prevent spider sessions.'

Simon

I have everything false in sessions.

I believe that most if not all of these problem orders were paid through paypal.

And your paypal account settings are correct in your paypal account and in the module itself? Synchronise invoices is off, for example? Aggregate cart (not itemized)?

Simon

I have done some additional testing and have determined that the problem is in fact the PayPal payment module.
Authorize.net payment module works as it is supposed to.

After making the payment with paypal module and returning to the shopping cart the items are still in the shopping cart and the same order number will be used on the next order.

Here is a screen shot of my paypal module settings.

I am also looking at my paypal settings.

Should Auto Return be on or off?
Should Payment Data Transfer be on or off?

Are there any other settings that could be causing this?

I tried switching to POST for Return URL Behavior but the cart was still not cleared upon return.

I tried Auto Return and Payment Data Transfer on the paypal web site but it did not clear the cart upon return either.

Do you have a Return URL specified in your pp account? And the email address your using is the SAME in the module as it is in the pp account? Tried rmeoving and reinstalling the module itself?

Simon

I have tried it with a return URL and without a return URL.
I can't see a difference.


Yes



I guess I will try that. Do you know if there is a better paypal module available now?

I'm assuming you've been talking about Paypal Website Standards module - if so, have a look at the file:
/includes/modules/payment/paypal.php for this line (around 254):


and change it to this:

Also in the same file file this line (around line 320):

and add this in above it:

These changes are taken from the 6.4.1a CE version PP WSP module. Try these and see what happens.

Simon

I tried editing the file as you stated but it did not resolve the problem.

However, I have noticed one other peculiar thing about this problem.

When I pay for the first order and return to the shopping cart, the order IS recorded in the database but the items are STILL in my shopping cart.

When I pay for the second order and return to the shopping cart, the order is NOT recorded in the database but the items are CLEARED from the shopping cart.

Tried using the Paypal Sandbox - a testing area for paypal. Also have you contacted Paypal re this?
Not all PP problems are the module - if you can't get the sandbox to work through your store, then it could well be a server config and / or PP account issue.

Simon