Jump to content
Christopher Short

Newsletter Cleanup

Recommended Posts

Posted (edited)

I sent a newsletter out today, and have over 2000 bounces. One person emailed me, pissed, because they never signed up. When I looked in the db at their email address, they have over 50 signups, all from different IP address. Is there a way to fix these type of registrations?

Edited by Christopher Short

Share this post


Link to post
Share on other sites

To fix them? I am not sure if there is a way to differentiate legit rows in the database table CubeCart_newsletter_subscriber. Perhaps you can make a judgement call for any row that doesn't have a customer_id number greater than zero.

CubeCart now has a "double-opt-in" feature. In admin, Store Settings, Extra tab, check the box for "Marketing Double Opt-in".

Share this post


Link to post
Share on other sites
6 minutes ago, bsmither said:

To fix them? I am not sure if there is a way to differentiate legit rows in the database table CubeCart_newsletter_subscriber. Perhaps you can make a judgement call for any row that doesn't have a customer_id number greater than zero.

CubeCart now has a "double-opt-in" feature. In admin, Store Settings, Extra tab, check the box for "Marketing Double Opt-in".

They all have id numbers greater than zero...and mostly Russian ip addresses.

Well, when I went to the subscribers tab, most of the people have a 0 for id, but I recognize a bunch of the addresses. I guess I need to purge the list completely and let people resubscribe. Isn't there supposed to be a remove me link in the emails by the way?. 

Share this post


Link to post
Share on other sites

In the Newsletter template, yes, there is a link to unsubscribe. In admin, Email Templates, Email Templates tab, edit the Default Newsletter template.

"when I went to the subscribers tab"

Subscriber's tab?

Share this post


Link to post
Share on other sites

The email field should be unique so there shouldn't be any duplicates. That combined with double opt in should prevent bounces (unless the address has since expired).

Share this post


Link to post
Share on other sites
5 hours ago, bsmither said:

In the Newsletter template, yes, there is a link to unsubscribe. In admin, Email Templates, Email Templates tab, edit the Default Newsletter template.

"when I went to the subscribers tab"

Subscriber's tab?

There is a table in the database labeled subscriber

Share this post


Link to post
Share on other sites
Posted (edited)

There is not a UNIQUE key on the 'email' column in CubeCart_newsletter_subscriber table.

Prior to CC607, Newsletter->subscribe(), there was a check for an existing email prior to an insert.

Then in CC607+, Newsletter->subscribe(), the code first deletes all records having that email address, then inserts a fresh record.

However, not until CC620, this code had a lettercase fault allowing emails with capital letters to be inserted multiple times.

Edited by bsmither

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...