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?

  • stevenqb 7 posts 119 karma points
    Sep 17, 2015 @ 04:10
    stevenqb
    100

    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

    Oct 12, 2015 @ 15:43

    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!

Please Sign in or register to post replies

Write your reply to:

Draft