I suggest you ...

How do I automatically purge old baskets from the database?

I've just found that we have an enormous ratio of empty baskets to completed orders in our Ucommerce_PurchaseOrder table. Somewhere in the ratio of 1000:1. We now have so many redundant PurchaseOrder Baskets that it is seriously impacting performance across our entire site.

A rough back of the envelope calculation would suggest that every visit to our site automatically generates a new PurchaseOrder with OrderStatusId = 1 (Basket), but these unused baskets never get removed.

Is this expected out of the box behaviour?
Is there a standard uCommerce or Umbraco pattern/pipeline for removing zombie Baskets?
Are there Basket settings we can use to stop this happening, or at least reduce it?

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Dorian Mcfarland shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base