Oza Posted September 3, 2014 Share Posted September 3, 2014 Hello, I'd like to get a list of customers who registered but never bought anything. I found this add-on http://addons.oscommerce.com/info/6576 and I run it on my test website, I got time out error and had to kill the query to get the website back up :( Has anyone used it before? Does anyone know if there is a better one that would actually work ? Cheers O. Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted September 3, 2014 Share Posted September 3, 2014 @@Oza have a look at the free mailbeez mod - one of the functions is to email customers who have not purchased Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Oza Posted September 3, 2014 Author Share Posted September 3, 2014 I'm more interested in removing them from my mailing list, but I will have a look, thanks Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 3, 2014 Share Posted September 3, 2014 See the Database Optmizer. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
MrPhil Posted September 3, 2014 Share Posted September 3, 2014 @@Oza have a look at the free mailbeez mod - one of the functions is to email customers who have not purchased Be careful... does this mod check that the customer has explicitly consented to receive marketing email? If not, you might be in trouble for spamming. If they have not consented, and signed up quite a while ago but never ordered anything, just delete them from your database. Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted September 3, 2014 Share Posted September 3, 2014 @@MrPhil yes it only mails newsletter subscribers Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
burt Posted September 3, 2014 Share Posted September 3, 2014 You can run a SQL direct on the DB to nuke these apparently useless "customers", I posted a SQL that does it some time ago - see if you can find it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.