Need some help with CB Auto Actions please

Hello all,

I stand to be correct but I think CB Auto Actions is the tool but I can't get my head around how to set it up for the following scenario.

Client offers a free period with a paid for plan. Some users start the process but don't make payment so the transaction is incomplete. The end result is that my client is deleting 20+ users a day (mainly Russian) as the site only wants paid members.

During the process the registrant is added to membership as registered. Whilst they are not enabled and confirmation is pending they appear to be approved. Is it possible to use auto actions to delete the user if they abandon their basket rather than manually delete users each day?

Many thanks
David

We don't provide an auto action for deleting users on purpose as it's too prone to accidentally wiping out your database if misconfigured. It is doable to delete a user from within CB Auto Actions though. You would need to use a Code action with the following.

Global
Triggers: None
Type: Code
User: Automatic
Access: Registered
Allow Direct Access: No (set this after saving the auto action for the first time)
Conditions
Condition 1
Field: confirmed
User: Action User
Operator: Equal To
Value: 0
Condition 2
Field: block
User: Action User
Operator: Equal To
Value: 1
Action
Method: PHP
Code:
That will delete the user if they're unconfirmed and blocked.

Now as for deleting users who abandoned their cart that's a bit more tricky as the basket could be pending. So on top of needing to know which users profiles are not fully registered you also need to know which users either don't have a basket or the basket is still in its initialized state.

The best way to do that is probably the batching feature. Create the following Batch within CB Auto Actions to grab a list of such users.

Global
Users: All Users
Access: Registered
Actions
SELECT_YOUR_DELETE_USER_AUTO_ACTION_HERE
Basic Filter
Filter 1
Field: confirmed
Operator: Equal To
Value: 0
Filter 2
Field: block
Operator: Equal To
Value: 1
Advanced Filter
JOIN: WHERE:
This will batch process through all users that are blocked, unconfirmed, and do not have a basket. CBSubs will expire unpaid baskets based off your CBSubs settings so it's best to just ignore any user without a basket. You'd simply run the batch URL via a CRON cURL GET call on a schedule and it should automatically take care of deleting those users. You can use the Batch feature like this or to do any kind of regular scheduled processing on users.

Please be sure you thoroughly test this on developer environment. A clone of your site. ANYTHING but your live data. Automating the deletion of users is dangerous so again be careful with this.