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.
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.
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.
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
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.
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.
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.
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?
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?
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.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.