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
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
In Development
Share this post:
Responses (4)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
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
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »