Purging anonymous users not having ordered more frequently

[WylieE]

I orginally added my question to an existing thread, but this may be a sufficiently distinct question to merit its own thread.

My question: Is it possible to have anonymous users that have NOT placed an order to be deleted at a faster rate than anonymous users that HAVE placed an order?

We have anonymous user maintenance set to save for 45 days. Most of our products are custom builds and it is not uncommon for a customer to make additions to an order during the production process. Our production cycle averages 4-6 weeks, but can stretch to 8-10 weeks. It looks like an anonymous customers card info is being deleted along with the rest of the anonymous account info.

We have a large number of tire-kickers (400k+ for the last 45 days). There are currently over 700K users in our users table and this is impacting performance. We need to keep the information on anonymous users that have placed a record, but we need to purge the tirekickers at a faster rate. Can this be done? Are there possible negative repercussions to this?

Thanks,

[mazhar]

You can keep your standard time span for anonymous users removal at 45 days while on the other hand you can setup your custom timed event as described here http://wiki.ablecommerce.com/index.php/ ... med_Events

Finally you need to write some code against that custom event to look for anonymous users and remove them if they have no order associated.

[WylieE]

Good to know.

If I purge the ac_Users table of anonymous accounts (having placed no orders) do I run the risk of creating orphan data anywhere? (ie. ac_basketitems)

[mazhar]

That's a good question. When removing those users first remove baskets and wishlists for each user and then drop user it self.

[foodsleuth]

Is this something that must be done manually (ie: removal of baskets, wishlists) for anonymous users? or does able do this automatically based on the storage dates?