ngross Posted June 19, 2014 Share Posted June 19, 2014 CubeCart 5 I need to extract a list of Newsletter Subscribers for an external process I am developing. I can get these from the newsletter_subscriber table. However looking at the current contents of newsletter_subscriber, I see that it is littered with spam/spurious entries. A number of entries have customer id values in [customer_id] and a number of entries have a validation value in [validation]. These rows appear to be mutually exclusive. So, I guess I will be selecting the rows with customer_id values, but how then would I identify valid entries for NON customers? Unfortunately I'm guessing there is no way to discriminate between the (valid) non customers and the (spurious) non customers entries? Any ideas? Neil Quote Link to comment Share on other sites More sharing options...
ayz1 Posted June 19, 2014 Share Posted June 19, 2014 Personally I would dump the whole list into Mailchimp and let them clean it up. You can integrate Mailchimp with your newsletter sign up so that it verifies the emails as well. Mailchimp is free for up to 2000 customers and reasonable charges if you have more than that. Quote Link to comment Share on other sites More sharing options...
ngross Posted June 19, 2014 Author Share Posted June 19, 2014 Sounds like a plan ayz1. Many thanks for the reply. Neil Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted June 19, 2014 Share Posted June 19, 2014 There is a Mod that uses MailChimp for the whole newsletter process. I've been using it a long time with no issues. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 19, 2014 Share Posted June 19, 2014 HiV6 when released will include better management tools for the newsletter subscribers - see https://github.com/cubecart/CubeCart/issues/109We are also in the final stages of testing our scheduled sending plugin (throttled sending) of newsletters from within CubeCart which removes the need to use 3rd party services like Mailchimp entirely !ThanksIan Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 27, 2014 Share Posted August 27, 2014 We are also in the final stages of testing our scheduled sending plugin (throttled sending) of newsletters from within CubeCart which removes the need to use 3rd party services like Mailchimp entirely ! Slightly delayed but our Throttled / Batch Sending of CubeCart Newsletters Plugin has been released today ! 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.