VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: drukman2000 on July 18, 2013, 12:15:46 PM

Title: Duplicate Orders
Post by: drukman2000 on July 18, 2013, 12:15:46 PM
Hi,

For each on-line order two lines are added at the Back-end under the Order List section.
Each line has it's unique Order Number.
Is this a known issue & is there a way to fix this ?
Thanks -Drukman.

Joomla 2.5.9
Virtuemart 2.0.20b
Title: Re: Duplicate Orders
Post by: AH on July 18, 2013, 13:16:04 PM
seacrh the forum for your payment method

But I have not seen this as an issue
Title: Re: Duplicate Orders
Post by: drukman2000 on July 18, 2013, 13:33:04 PM
Quote from: Hutson on July 18, 2013, 13:16:04 PM
seacrh the forum for your payment method

But I have not seen this as an issue

At start it was PayPal.
Than changed to SystePpay.
It's the same with both.....duplicate orders !

Thanks -Drukman.
Title: Re: Duplicate Orders
Post by: drukman2000 on July 22, 2013, 13:06:05 PM
Quote from: Hutson on July 18, 2013, 13:16:04 PM
seacrh the forum for your payment method
But I have not seen this as an issue

Actually you are wrong.
You even replied to a Topic on this matter. -))

http://forum.virtuemart.net/index.php?topic=113902.0
Drukman.



Title: Re: Duplicate Orders
Post by: AH on July 22, 2013, 15:11:47 PM
This was NOT an issue as far as I can tell.

The post has not been replied to after my  response.

Therefore my suggestion that this is not a bug/issue still stands.


Title: Re: Duplicate Orders
Post by: drukman2000 on July 22, 2013, 18:10:43 PM
Quote from: Hutson on July 22, 2013, 15:11:47 PM
This was NOT an issue as far as I can tell.
The post has not been replied to after my  response.
Therefore my suggestion that this is not a bug/issue still stands.
Already corresponding with few other users that experience the same problem.....
None of them will agree with you.
Looks like it was implemented the same way as with an older vm version:
In previous version it was a matter of "select": http://www.joomlahackers.net/virtuemart-tutorials/virtuemart-duplicate-orders.html
Drukmam.
Title: Re: Duplicate Orders
Post by: AH on July 22, 2013, 18:21:29 PM
VM 1.5 and VM2 are completely different systems

I use both, but clearly there appears to be something that you can fix.

When you have sorted it out it would be good if you Post your solution here to help others.
Title: Re: Duplicate Orders
Post by: drukman2000 on July 22, 2013, 18:24:37 PM
Quote from: Hutson on July 22, 2013, 18:21:29 PM
VM 1.5 and VM2 are completely different systems
I use both, but clearly there appears to be something that you can fix.
When you have sorted it out it would be good if you Post your solution here to help others.
THAT'S OUR INTENTION.
Title: Re: Duplicate Orders
Post by: drukman2000 on July 29, 2013, 03:05:12 AM
Quote from: Hutson on July 22, 2013, 18:21:29 PM
VM 1.5 and VM2 are completely different systems
I use both, but clearly there appears to be something that you can fix.
When you have sorted it out it would be good if you Post your solution here to help others.

Hi,

Here is the solution....
Whenever emails are set at the same time BOTH to "Confirmed" & "Confirmed by shopper" - the system will create duplicate orders.
Just avoid this situation.

Thanks - Drukman.
Title: Re: Duplicate Orders
Post by: AH on July 29, 2013, 22:36:03 PM
Thank you for updating the forum.

I will see if I can replicate the problem.
Can you show us  a pcik of your config for status code and checkout e-mail settings?
Title: Re: Duplicate Orders
Post by: drukman2000 on July 30, 2013, 06:36:45 AM
Hi Huston,
What were you asking for at the last line you wrote ?
Thanks - Drukman.
Title: Re: Duplicate Orders
Post by: AH on July 30, 2013, 10:48:17 AM
Hi druk

I was asking for you to post the settings you had that made the order double up

e,g, the order statuses and the checkout email settings

Thanks
Title: Re: Duplicate Orders
Post by: drukman2000 on July 30, 2013, 14:52:24 PM
Quote from: Hutson on July 30, 2013, 10:48:17 AM
Hi druk

I was asking for you to post the settings you had that made the order double up

e,g, the order statuses and the checkout email settings

Thanks

order status = pending
email settings is not relevant since it wasn't possible to configure any with that version.
Title: Re: Duplicate Orders
Post by: Milbo on August 02, 2013, 14:30:46 PM
I do not understand this "Confirmed" & "Confirmed by shopper"

Do you mean, you set some orders to confirmed and others to "confirmed by shopper" and then you used the update button and all of them are doubled?
Title: Re: Duplicate Orders
Post by: drukman2000 on August 03, 2013, 07:30:25 AM
Quote from: Milbo on August 02, 2013, 14:30:46 PM
I do not understand this "Confirmed" & "Confirmed by shopper"

Do you mean, you set some orders to confirmed and others to "confirmed by shopper" and then you used the update button and all of them are doubled?

No.
When shopper is set to get emails at a "Confirmed" & "Confirmed by shopper" statuses - than when a new order is received - two identical orders are created including the same items - but with different order number.
Drukman.
Title: Re: Duplicate Orders
Post by: drukman2000 on August 11, 2013, 09:06:09 AM
Quote from: Milbo on August 02, 2013, 14:30:46 PM
I do not understand this "Confirmed" & "Confirmed by shopper"
Do you mean, you set some orders to confirmed and others to "confirmed by shopper" and then you used the update button and all of them are doubled?

Just found another configuration that cause duplicate orders to appear....

The next configuration causes Duplicate Orders to appear:

1. "agreed" uder the Shopper Fields is mandatory & published.
2.  "Show Terms of Service on the cart/checkout?" is active.

Checked with Firefox & Chrome.
Can someone confirm this problem ?
For now we must deactivate TOS on checkout.

Drukman.
Title: Re: Duplicate Orders, error due to qued request ?
Post by: Jörgen on August 11, 2013, 11:05:58 AM
Hell Drukman

Are sure that You are getting duplicate orders for every order done with this configuration ?

Because of this behaviour shows with different configurations, then the problem is maybe not only connected to the configuration. It could be some kind of timing issue with the sql sequences storing these orders. This configuration generates maybe several updates of the order data that could give these problems.

I am currently using the old VM 1.1.3 and with CertiTrade card payment I get duplicate orders from time to time.
I suspect that this is a timing problem together with a heavily loaded sql server. I am not reporting a bug with the older VM 1.1 I am only trying to give You another view of this bug in VM 2.x.

This could be happening when the customer several times repeatedly presses the button on Certirades safe website that sends them back to my webshop.
My guess is that several requests of storing the updated data for the purchase are getting processed. There are probably checks that should prevent this, but i guess that they must be done before the first request is stored in the database.

I have actually had an order that got three copies (with consecutive ordernumbers), a total of four orders !

I could confirm this behaviour at that time. But later I couldn´t repeat the behaviour and because of this I stopped looking for the bug. I still happens, but I now simply erase the duplicate order and tell the customer that money has only been transferred once and that it otherwise is OK.

This could also be the case here. A check that  the order actually doesn´t already exists under a different ordernumber performed when updating payment data could prevent this.

This is of curse only an educated guess, but maybe someone could check if my theory pans out.

my two cents

Jörgen @ Kreativ Fotografi

Title: Re: Duplicate Orders
Post by: drukman2000 on August 11, 2013, 11:35:24 AM
Quote from: Jörgen on August 11, 2013, 11:05:58 AM
Hell Drukman

Are sure that You are getting duplicate orders for every order done with this configuration ?

Because of this behaviour shows with different configurations, then the problem is maybe not only connected to the configuration. It could be some kind of timing issue with the sql sequences storing these orders. This configuration generates maybe several updates of the order data that could give these problems.

I am currently using the old VM 1.1.3 and with CertiTrade card payment I get duplicate orders from time to time.
I suspect that this is a timing problem together with a heavily loaded sql server. I am not reporting a bug with the older VM 1.1 I am only trying to give You another view of this bug in VM 2.x.

This could be happening when the customer several times repeatedly presses the button on Certirades safe website that sends them back to my webshop.
My guess is that several requests of storing the updated data for the purchase are getting processed. There are probably checks that should prevent this, but i guess that they must be done before the first request is stored in the database.

I have actually had an order that got three copies (with consecutive ordernumbers), a total of four orders !

I could confirm this behaviour at that time. But later I couldn´t repeat the behaviour and because of this I stopped looking for the bug. I still happens, but I now simply erase the duplicate order and tell the customer that money has only been transferred once and that it otherwise is OK.

This could also be the case here. A check that  the order actually doesn´t already exists under a different ordernumber performed when updating payment data could prevent this.

This is of curse only an educated guess, but maybe someone could check if my theory pans out.

my two cents

Jörgen @ Kreativ Fotografi



Jörgen,
My problem happens locally while the order is stored & NOT after the payment is done.
I saw other scenarios that it happened & I think your TIMING db theory might explain it.

Interestingly - it never happened with IE ! only FF & Chrome !
But how this can be tested ? specially when most VM "veterans" posting on the forum says it's an old problem & most of them can't reproduce it !

Drukman.
Title: Re: Duplicate Orders
Post by: Maxim Pishnyak on August 21, 2013, 15:56:59 PM
Quote from: drukman2000 on August 11, 2013, 09:03:21 AM
We are very far from being "bug free" -)).
A bit of searching for 'duplicate order' could give you an answer.
http://forum.virtuemart.net/index.php?topic=114154
http://forum.virtuemart.net/index.php?topic=95380
Title: Re: Duplicate Orders
Post by: drukman2000 on August 21, 2013, 16:40:03 PM
Quote from: Maxim Pishnyak on August 21, 2013, 15:56:59 PM
Quote from: drukman2000 on August 11, 2013, 09:03:21 AM
We are very far from being "bug free" -)).
A bit of searching for 'duplicate order' could give you an answer.
http://forum.virtuemart.net/index.php?topic=114154
http://forum.virtuemart.net/index.php?topic=95380

Jörgen,
I already read these posts before.
Do you find that it gives any new info ?
Drukman.
Title: Re: Duplicate Orders
Post by: Jörgen on August 21, 2013, 16:56:59 PM
He he

...that post was not from me  ;D

Jörgen @ Kreativ Fotografi
Title: Re: Duplicate Orders
Post by: Maxim Pishnyak on August 21, 2013, 17:05:52 PM
Quote from: drukman2000 on August 21, 2013, 16:40:03 PM
I already read these posts before.
Do you find that it gives any new info ?
Is it not clear enough that bad paypal behavior is responsible for observed issue? Alatak confirmed that it's not simple to find workaround for paypal attacks at poor VM orders.
Title: Re: Duplicate Orders
Post by: drukman2000 on August 21, 2013, 17:12:30 PM
Quote from: Maxim Pishnyak on August 21, 2013, 17:05:52 PM
Quote from: drukman2000 on August 21, 2013, 16:40:03 PM
I already read these posts before.
Do you find that it gives any new info ?
Is it not clear enough that bad paypal behavior is responsible for observed issue? Alatak confirmed that it's not simple to find workaround for paypal attacks at poor VM orders.
I tested with other payment methods (Jörgen also isn't using PayPal) - and the problem is there.
So it's definitely VM and not PayPal.
Title: Re: Duplicate Orders
Post by: drukman2000 on August 21, 2013, 17:15:52 PM
Quote from: Jörgen on August 21, 2013, 16:56:59 PM
He he
...that post was not from me  ;D
Jörgen @ Kreativ Fotografi
I know.
But was wondering if you find any new info in those links.
Title: Re: Duplicate Orders
Post by: Maxim Pishnyak on August 21, 2013, 20:16:08 PM
Quote from: drukman2000 on August 21, 2013, 17:12:30 PM
I tested with other payment methods (Jörgen also isn't using PayPal) - and the problem is there.
This is can't surprise me.
http://forum.virtuemart.net/index.php?topic=116110