Newsletter-Only Subscriptions for v1.3x

I've upgraded the original 1.2.7 Subscribe! contribution, merged in the 1.2.7 newsletter_unsubscribe contribution, and added quite a number of new features of my own.

The end result is Newsletter Subscribe V2.0

Please let me know what you think and report any problems you may have.

-Ng_

The contribution is now in the downloads section, under 'Other Modules'. Updates will be placed there, so please download from that section.

Thank you for the quick approval!

-Ng_

Hello All,

This mod sounds brilliant, so I had to try it. So far, I am at the install stage on the Subscription Manager. This is what comes back when I press the button:

1146 Table 'thegemtr_zc2.query_builder' doesn't exist
in:
[DELETE FROM query_builder WHERE query_description = 'Returns name and email address of all Customer Account subscribers and all Newsletter-Only subscribers.']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I am not sure what to do, I am guessing it could be a SQL setup thing. Any help would be gratefully received.

Regards,

Russ

It would have been a pleasant first to discover all the testing actually uncovered everything. sigh I forgot to hold update the database installation so it calls for the table name (prefix + query_builder). Give me 10 min and I'll post an upgrade.

I was about to install this add-on. I guess it is a good idea I checked the support forum first :) Thank-you Notgoddess for this add-on, it looks like a good module. When you say you're going to upload an update, is that going to be on the downloads page or this thread? Is there going to be a second file on the download page? Thanks again.

I've uploaded the updated contribution but updates have to be reviewed by the staff.
You can wait until you see version 2.0.1 or grab it from my website:
http://www.notgoddess.com/scripts/newsletter-subscribe

Hiya,

Thanks for getting back to me. Just to say it is working A.O.K and is chuffing brilliant!!

Regards,

Russ

I found one typo in this excellent contribution. A SQL error appeared when I deleted a customer account.

admin/customers.php

On line 343, change

where customer_id = '" . (int)$customers_id . "'");

to

where customers_id = '" . (int)$customers_id . "'");

(changed customer_id to customers_id)

alanpace:

I found one typo in this excellent contribution.
Thank you for finding that!

I've added the correction and upgraded the version to 2.0.2

-Ng_

Thanks for the contribution NG. I am looking to do a mass import of newsletter only subscribers. Is there an easy way to do this?

Thanks

mocha:

Thanks for the contribution NG. I am looking to do a mass import of newsletter only subscribers. Is there an easy way to do this?
It would depend upon format of your list (sql, txt, xsl, csv, etc). if you email me a copy of the list (or part of it) I can build something for you.

I'll end with this caveat -not because I think you are intending it, but others might.
admin-added subscriptions are auto-confirmed, but please please do not use this as a way to send people unsolicited spam (like using a list you bought somewhere).

-Ng_

Thanks for the offer NG. The list format is flexible, at the moment it is an excel file with just the username and the email address. Also with the sidebox, I cannot find where to change it so the sidebox title is just "Newsletter" and is not a link.

Okay, well the easiest way (other than having me code an interface :) would be to turn the excel into a sql file:

Copy the email address column and save as a txt file (separate with commas).

Open that file in your favorite text editor.

Add to the beginning of the file (replace tbl_name with your subscribers table name, including prefix):
INSERT INTO tbl_name (email_address) VALUES(

Use the find/replace command:
find: , [that's a comma]
replace with: '), ('

If the editor supports adding newlines you might use:
replace with: '),\n ('

At the end of the file you should have: lastemail@address
Add to end: '); so it is: lastemail@address');

You are trying to end up with:
INSERT INTO tbl_name (email_address)
VALUES([email protected]), ([email protected]),
([email protected]), ([email protected]);

Save the resulting file (as .sql or .txt) and use the sql patches feature in the Tools menu to upload/run it. If you have hundreds of names you may need to break into a few files.

-Ng_

mocha:

Also with the sidebox, I cannot find where to change it so the sidebox title is just "Newsletter" and is not a link.
? The 'Subscribe' sidebox title is not a link by default. Are your other sideboxes
linked? It might be a feature you have enabled somewhere.

[edit: found it]
edit /includes/modules/sideboxes/YOUR_TEMPLATE/subscribe.php
and add this somewhere:

  $title_link = false;

Let me know if that works and I'll include it in the next update.

-Ng_

Does this work on the latest version of Zen Cart?
I want to make sure I din't miss anything here.

Thanks,
Kelly

sleepless:

Does this work on the latest version of Zen Cart?
I want to make sure I din't miss anything here.

Thanks,
Kelly

Yes, this runs with zencart 1.3.x (1.3.0 and 1.3.0.1).

Make sure you download the updated version from the contributions section, and you .might. need to apply the patch in the post above yours (I'm still seeing if it's needed before I update again).

Please let me know how you like it, if there's anything you'd like changed/added (even if it's a 'well it would be nice if...' because you can bet others are thinking the same thing).

-Ng_

Thanks for the quick reply.

I had the original and removed it a while back. One feature that I did like was adding a query to send emails to test account only before sending them to actual customers. Will this enable me to do that as well?
If not, that would be a nice addition.

Thank you in advance! :)

Kelly

sleepless:

One feature that I did like was adding a query to send emails to test account only before sending them to actual customers. Will this enable me to do that as well?

I'm not .quite. sure if I understand you. You can of course create a subscription using an email address...you can email them directly, but there is no query set so you have the option to send the newsletter to one address first-I didn't see anything like that in the original, either, although perhaps I worked from a different version than you had.

Is this what you are wishing? I believe it should be easy enough to add-we'd just add a query to pull the admin email address and add that as an option in the 'send to' list.

Let me know if that's what you had in mind.

-Ng_

I have the sql for it somewhere. If I find it I will email or post it so you can see if it will work. It wasn't included in the original. It was something someone posted as an add on.

Thanks,
Kelly

Check out these posts. There are a number of various solutions for test accounts. I didn't want to post the code in case someone thought it was okay to use.
http://www.zen-cart.com/forum/showthread.php?t=13836&page=2&highlight=newsletter+test

Thanks,
Kelly