Has anyone seen or written a utility (report, stored proc, task centre) that deletes abandoned shopping carts? I know this can be manually managed through System Setup > Set up commerce web components > Cart manager, but my client has a large number of stale shopping carts (>1 year old), making that Cart manager page unmanageably long.
It seems like a common problem that's likely already solved. Or maybe it's in 15.2? (I haven't found any evidence of it, but I could be wrong.)
Thanks,
Annie
What ill-effects would there be to create a stored proc that is attached to a nightly script that would go into the cart tables and remove the entries? As a side note: where are events stored that are in the "Cart Manager"? I've looked in the CartEvent, CartItem, CartOrder and what I believe are the order eSeries tables Basket_Function, Basket_Meeting tables and don't see any events that are showing up in the Cart Manager listings.
The main disadvantage is that the Cart may sometimes only exist in webserver memory, not in the database. Or, it may exist in both, with the database only serving as a backup of the session-state version.
--
Bruce Wilson
Director, Technical Services
RSM McGladrey, Inc.
Ironically...
Ironically, in iMIS 15.2 ASI has worked to give shopping carts a longer life.
I haven't automated this in the past, but there are a number of options:
None of these are very attractive, or advisable. It's probably better to just have someone catch up and then stay on top of it.
--
Bruce Wilson
Director, Technical Services
RSM McGladrey, Inc.