Hi,

If a client checkout and is on the PayPal page and cancel there in this case the transaction is added to the database with order_status_id = 0. If the client do this 20 times or 1000 clients do this 20 times the database will explode one day.

But my problem at this point is I use an module which take over the actual orders from the database but this order do not exist!!!! At the store this orders don't show because you might check if the status > than 0.

The order should be added to the database by going to the successful page!!!

Regards

Hermann
Monday, December 14 2015, 11:23 PM
Share this post:

Accepted Answer

Thursday, December 17 2015, 12:49 PM - #Permalink
PS!
But my problem at this point is I use an module which take over the actual orders from the database but this order do not exist!

You should simply change this module to skip orders where order_status_id = 0, that's what I do in my accounting integration.
The reply is currently minimized Show
Responses (4)
  • Accepted Answer

    Thursday, December 17 2015, 12:40 PM - #Permalink
    The order should be added to the database by going to the successful page!!!

    No it should not. The reason is simply that offline payment options sometimes fails, the payment is added, but the order would be missing when callback fails if it's not temporary stored in shop. When it's temporary stored it's easy to recover, handle and deliver it.

    But ... the way it's adding a lot of "missing orders" today is no good, I can agree on that part. It should be only one order saved per session, like in the mod linked to by Denis. Though it could be further improved to only add real order number on success, and also instead save the temp orders to it's own database table etc.

    So for improvement, please vote on those two "ideas":

    https://arastta.org/ideas/idea/43-only-generate-one-temp-order

    https://arastta.org/ideas/idea/44-auto-clean-old-temp-orders-abandoned-carts
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 17 2015, 10:25 AM - #Permalink
    That is how it has been working for years since OpenCart 1.5
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, December 16 2015, 10:04 PM - #Permalink
    Hi Denis, toooooooooooooooooooooooo bad!!!!!!!!! It should Not be that way.

    Regards

    Hermann
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, December 16 2015, 09:49 PM - #Permalink
    Hi Hermann,

    I'm sorry but that is how the system is designed to work. However, you can try the following modification:

    http://forum.opencart.com/viewtopic.php?f=121&t=9192

    Regards
    The reply is currently minimized Show
Your Reply