Improve Send Mass Email

8 years ago
Because of the size of our subscription list, the "send mass email" function usually stop before getting to the end of the list (is usually 24hrs for some strange reason)

Currently we have no way to restart the mass email and only send to those who haven't been sent an email already.

We could add a column to the newslettersubscription table that has ID of last campaign that was sent to (LastCampaignSentTo). Then for the "send mass mail" function have a condition that excludes subscriptions where they have already been sent the current campaign

Where LastCampaignSentTo <> CurrentCampaignID

This way any subsriber will never be sent an email from the same campaign twice.

Darren
8 years ago
Even if we have such LastCampaignSentTo column. What if a campaign was already successfully sent and then a store owner edited it and want to send it one more time? He'll just not be able to do it with this implementation

P.S. I'm sure that it's highly recommended to your mail services such as MailChimp if you have a large subscription list.
8 years ago
Hi Andrei,

Thanks for your view

a.m. wrote:
He'll just not be able to do it with this implementation


Unless you have a "reset" button. Update table subscription. Set LastCampaignSet = null

Mailchimp is expensive. It's difficult to get an account without spending a lot on data cleansing and I'm sure this feature would be useful to those who have lists of all sizes as a way to verify the whole list has been sent an email.

Darren
8 years ago
wunpac wrote:
Unless you have a "reset" button. Update table subscription. Set LastCampaignSet = null

I think it would be too complex and unclear for store owners. But we could rewrite "send campaign" functionality to placing all emails in a queue (like all other emails are usually send). In this case all of them will be sent sooner or later. I've just created a work item
8 years ago
a.m. wrote:
Unless you have a "reset" button. Update table subscription. Set LastCampaignSet = null
I think it would be too complex and unclear for store owners. But we could rewrite "send campaign" functionality to placing all emails in a queue (like all other emails are usually send). In this case all of them will be sent sooner or later. I've just created a work item


I think they are queued already anyway. That is how we can work out where to restart the campaign from. There is just no simple way to see which subscribers have been sent an email for those with less technical knowledge.
8 years ago
I'd advise hooking into a email marketing campaign tool. Email marketer by Interspire. It provides a richer set of tools for the running of email marketing campaigns.

We can provided a hosted and supported version of this product and integrate with Nop or provide guidance. As well as provide help with the tool eg design of email templates and training.
8 years ago
daveb wrote:
I'd advise hooking into a email marketing campaign tool. Email marketer by Interspire. It provides a richer set of tools for the running of email marketing campaigns.

We can provided a hosted and supported version of this product and integrate with Nop or provide guidance. As well as provide help with the tool eg design of email templates and training.


Could you send me examples of your work
8 years ago
wunpac wrote:
I think they are queued already anyway. That is how we can work out where to restart the campaign from. There is just no simple way to see which subscribers have been sent an email for those with less technical knowledge.

You're right. They are already queued (I looked into another method). How many subscriptions do you have?
8 years ago
a.m. wrote:
I think they are queued already anyway. That is how we can work out where to restart the campaign from. There is just no simple way to see which subscribers have been sent an email for those with less technical knowledge.
You're right. They are already queued (I looked into another method). How many subscriptions do you have?


500k on the list I'm sending to this month
8 years ago
wunpac wrote:
500k on the list I'm sending to this month

I'm absolutely sure that you should use email service provider (ESP) such as MailChimp in this case. I would start using it even if I have 10K subscribers. Otherwise, most of your emails will be marked by spam. I also do not think that nopCommerce can handle such amount of subscribers right now. If you do not want to use ESP, then I would recommend you writing some simple and fast console application which will send all emails.