Press Ctrl / CMD + C to copy this to your clipboard.
Copied to clipboard
Flag this post as spam?
This post will be reported to the moderators as potential spam to be looked at
Topic author was deleted
Sep 16, 2015 @ 20:46
uWebshopOrders table rapidly fills with INCOMPLETE orders
My uWebshopOrders table in the database seems to be rapidly filling with incomplete orders. These have an orderStatus of "Incomplete" and an orderNumber like "[INCOMPLETE]-62988".
It seems like there are around 10 incomplete orders written each minute.
Some of these orders are created when people are on the site and adding things to their basket, but there is nowhere near enough traffic to be creating this many incomplete orders. It looks more like some process is constantly adding new records to the table.
I'm struggling to track down the root cause of this. Has anyone experienced this? Any pointers?
uWebshop use "Incomplete" order to save the temporary basket. It contains information about product, customer's info of the current user(or guest) that in order processing. Each "Incomplete" order is created for each user order product, it will be reset after user complete the order process. Admin will not see these order in the back office. The "uniqueId" of "Incomplete" order will be stored in cookies "OrderId{StoreName}" ({StoreName} is the name of current store). When cookies is expired, new "Incomplete" order will be created.
It seems uWebshop does not delete these order automatically. I use a schedule task to delete expired "Incomplete" order in my project.
May this answer help you to know the cause. Hope you find the best solution for youself :)
I've done as you've suggested, Steven. A nightly SQL job to clear out any "Incomplete" orders seems to be keeping it down to size.
I still find it a little strange how many new "Incomplete" orders are created, but as long as they're not needed for anything, there's no harm in a little housekeeping job.
Topic author was deleted
uWebshopOrders table rapidly fills with INCOMPLETE orders
My uWebshopOrders table in the database seems to be rapidly filling with incomplete orders. These have an orderStatus of "Incomplete" and an orderNumber like "[INCOMPLETE]-62988".
It seems like there are around 10 incomplete orders written each minute.
Some of these orders are created when people are on the site and adding things to their basket, but there is nowhere near enough traffic to be creating this many incomplete orders. It looks more like some process is constantly adding new records to the table.
I'm struggling to track down the root cause of this. Has anyone experienced this? Any pointers?
uWebshop use "Incomplete" order to save the temporary basket. It contains information about product, customer's info of the current user(or guest) that in order processing. Each "Incomplete" order is created for each user order product, it will be reset after user complete the order process. Admin will not see these order in the back office. The "uniqueId" of "Incomplete" order will be stored in cookies "OrderId{StoreName}" ({StoreName} is the name of current store). When cookies is expired, new "Incomplete" order will be created.
It seems uWebshop does not delete these order automatically. I use a schedule task to delete expired "Incomplete" order in my project.
May this answer help you to know the cause. Hope you find the best solution for youself :)
Comment author was deleted
I've done as you've suggested, Steven. A nightly SQL job to clear out any "Incomplete" orders seems to be keeping it down to size.
I still find it a little strange how many new "Incomplete" orders are created, but as long as they're not needed for anything, there's no harm in a little housekeeping job.
Thanks!
is working on a reply...