Order Confirmation Processing Block .. vs duplicate orders

[DrByte]

DrByte,
The duplicate issue doesn't occur on every order and has occurred in the past when using Authorize.net so I don't think it is related to Paypal. That being said I did look into the things you mentioned.

The solution here is probably for me to switch away from Tableau and use the new one provided in 1.5.5. The problem is that getting my existing site(s) to look the same using a new template isn't a quick fix. I'm also surprised, because I couldn't find any other mention of this issue related to Tableau. I'm going to custom replace the includes/templates/tableau/templates/tpl_checkout_confirmation_default.php and see if that fixes anything.

Good point. It's VERY IMPORTANT that all customizations to your tpl_checkout_confirmation_default.php ALSO be added to tpl_ajax_checkout_confirmation if you're using Authnet AIM or PayPal Pro or any other module that collects card numbers directly on-site, because the ajax template is used to re-draw the page without transmitting the data back and forth to the server, thus avoiding any risk of unsafely handling card data ... but if your templates are out of sync odd things can happen.

[lindasdd]

have you tried placing any test orders? in my experience, duplicate orders are related to problems with sending the order email.

the sequence goes something like this:

- customer hits button to place order
- timeout issue occurs due to email problem
- customer sees error on screen, and browser asks if customer wants to resubmit form.
- customer proceeds to do so; and second order is placed.

ZC does NOT clear the cart after the order gets created: that happens after the email gets sent.

see:

https://www.zen-cart.com/showthread....11#post1312911
https://www.zen-cart.com/showthread....41#post1311441
https://www.zen-cart.com/showthread....45#post1302345

good luck!

I have order confirmation emails send to an admin email as well and emails were received for all orders (meaning the first in the duplicate did not fail - at least for the admin portion). I'm wondering if that means this isn't related to an email failure issue.

[carlwhat]

what are the time differences between the original order and the duplicate orders?

[lindasdd]

what are the time differences between the original order and the duplicate orders?

One this morning was 11 seconds and another was 9 seconds.

[carlwhat]

ok. in my experience, i think we can safely safe it's "probably" not related to an email problem. most of the times when i would see this kind of error, the time differences were significantly greater.

best.

[lindasdd]

It is interesting that non duplicates have an access log like this:
"POST /index.php?main_page=checkout_confirmation
"POST /index.php?main_page=checkout_process
"GET /index.php?main_page=checkout_success&zenid=
"POST /ipn_main_handler.php HTTP/1.1" 200 - "-" "PayPal IPN

Whereas the duplicates are like this:
"POST /index.php?main_page=checkout_confirmation
"POST /index.php?main_page=checkout_process
"POST /ipn_main_handler.php HTTP/1.1" 200 (although the timestamp is actually 5 seconds after the next line item)
"POST /index.php?main_page=checkout_process
"GET /index.php?main_page=checkout_success&zenid=
"POST /ipn_main_handler.php HTTP/1.1" 200

[lindasdd]

I think I have nailed this down to an issue where the processing time for Paypal is so long that every once in awhile someone will navigate away from the page, come back, and resubmit, before Paypal sends back the confirmation.

As a result, the cart isn't cleared and the customer is able to place a duplicate order.

Paypal says they can't speed up processing, so I'm wondering how I could change the 'submitonce()' functionality on the checkout_confirmation button to be a page overlay instead of just a button overlay.

There are a number of examples online, and this functionality is used in the Numinix Fast and Easy Checkout with Ajax module, but I'm trying to figure out a way to apply it to the standard template.

Any help would be appreciated.

[carlwhat]

seems like a lot of work.... have you tried:

https://www.zen-cart.com/showthread....76#post1317476

[lindasdd]

seems like a lot of work.... have you tried:

https://www.zen-cart.com/showthread....76#post1317476

Nice suggestion.

As a result I put this in place:
https://www.zen-cart.com/showthread....00#post1314200

It isn't a total page overlay, but it at least provides the customer a little more feedback by making the 'processing' image larger and visible even when the mouse isn't hovering over the button.

[badarac]

seems like a lot of work.... have you tried:

https://www.zen-cart.com/showthread....76#post1317476

Since implementing that on several client sites they no longer see the duplicate orders. Hope this works for you. Dr B you might want to think about increasing the time in a future update.