Jump to content

Recommended Posts

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
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".

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?. 

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?

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).

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

Link to post
Share on other sites

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
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...