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?