Hello,
The osclass website seems to get a lot of spam users but luckily I've had it on verify your account before its active... is there a way i can delete inactive users by bulk? I have about 100k spam users to get rid of. Butler plugin doesn't seem to be doing it for me.

Kind Regards

DELETE FROM oc_t_user WHERE b_active = 0;

Run that query and it solves this.

Did you check the butler plugin settings? Because is working fine for me

how to run that code where to run that code


DELETE FROM oc_t_user WHERE b_active = 0;

Run that query and it solves this.

You should remove account at least few days old.
Maybe you can use oc-admin feature in Tools > Data clean up

Inactive users
Remove users those has registered more than 7 days ago did not activated their account.
Total number of users matching criteria: 55