Newsletter-Only Subscriptions for v1.3x

kookiewookie:

When i go to Subscription Manager and sent a email to a newsletter only subscr. it sents the email fine.
BUT when i do select: Newsletter only Subscr. from the newslettermanager i does not send the email for there is a error: No recipient addresses found in header .

Okay, let me verify what you are saying.

1. You have newsletter-only subscribers.

2. You can click on the 'email' button from there and send email to that individual

3. When you go into Tools -> Newsletter Manager, you're picking this option:
   **Newsletter-only Subscribers (#) **
   And that (#) is a number other than 0.

4. When you select that drop-down option and hit 'select' and it goes to the preview screen, you see this in red:
   Customers receiving newsletter: #
   And again that # is greater than 0 and should match the previous #.

5. You click on 'send mail' and that's when you get the error?

And that it's only the **Newsletter-only Subscribers (#) ** one that gives you the error?

I'm not running into issues on my dev site. Even sending to a 0 group goes okay (it just sends 0 emails). It might be an issue with the imported emails.

-Ng_

right!
If i send mail from Subscription manager all goes fine.
If i send from newsletter manager all goes fine with all options BUT
not the particular selection: Newsletters Subscribers Only!
Then all over sudden there is no emailadres in header even when the 'count' says there is at least one.

kookiewookie:

right!
If i send mail from Subscription manager all goes fine.
If i send from newsletter manager all goes fine with all options BUT
not the particular selection: Newsletters Subscribers Only!
Then all over sudden there is no emailadres in header even when the 'count' says there is at least one.

Okay, from some testing we were able to discover it's a sendmail-related error.

I'm working on the issue.

-Ng_

Hopefully you find the solution soon; thank you very much!

Got it. I knew it was my scripting somewhere causing the error but thought it was sendmail related. It's actually in the query string used. It's pulling email_address but it needs to be returned as customers_email_address

Use the sql patch tool to do this update:

  UPDATE query_builder set query_string = 'SELECT email_address as customers_email_address FROM TABLE_SUBSCRIBERS WHERE email_format != ''NONE'' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address'
	WHERE query_string = 'SELECT email_address FROM TABLE_SUBSCRIBERS WHERE email_format != ''NONE'' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address';

Be sure to add your dbprefix if needed.
Or use phpMyAdmin to update it.

I'll fix it in the release.

-Ng_

New version fixing the above issue. Version 2.0.5

On my site or soon in contributions.

-Ng_

works like a charm thanks.

now onto my wishlist...... I am trying to figure out to make the process of dealing with subscribers who sign up after we have sent out the newsletter for the month. Would it be possible to track when a newsletter is sent out (set date) and then have a function where new suscribers who have not gotten that newsletter are tracked and grouped in the dropdown so that I can send them the newsletter, say once a week. When the next newsletter is sent to all subscribers it would reset the tracking.

on to another issue subscribe date. We already went over the subscribe date for customers in the zen_subscribers list. No issue but when I go to subscription manager some of the customers early (by date) on in the list have an odd date of subscrition (11-30-2036). These customers also have the 00-00-0000 date in the DB. I suppose the two are related but it seems to have stopped after one of the updates, not sure which one though since I didn't notice this until today after I updated to 2.05

Regarding the first...I'll see what I can do.

Regarding the second, I'll make the next update add a subscribed date for customers-that should resolve that issue.

Can you do me a favor and add these to the wishlist on my site (just go to the article and add as a comment)-it'll help remind me to get them in rather than relying on my ability to scroll through the posts.

-Ng_

ok added them as comments on your site. :thumbsup:

NG: I'm having an "issue" with my cart -
I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

I don't know if this was tied to having newsletter only subscriptions added to my cart.

If i get a chance, I'll see if I have space & the ability to do a clean install of 1.3.0.2 with to test, but I thought I'd ask here if anyone else can replicate the problem.

Thanks for this module again, btw. It's fantastic :D

woodlandsprite:

I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

That's not good. I'll look into it tonight.

woodlandsprite:

I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

Found it. See the attached new audience.php file (backup your other before replacing tho :)

Also noticed another bug...it was letting me send to non-confirmed subscribers when I selected the 'All Newsletter Subscribers' option. To fix that put this in your sql patch tool (replace zen_ in zen_query_builder with your prefix, if any).

[code]
UPDATE query_builder
SET query_string = 'select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from TABLE_SUBSCRIBERS as s left join TABLE_CUSTOMERS as c on c.customers_id = s.customers_id where
(s.confirmed = 1 or s.customers_id >= 1)'
WHERE query_string = 'select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from TABLE_SUBSCRIBERS as s left join TABLE_CUSTOMERS as c on c.customers_id = s.customers_id';
[code]

I'll get an update out soon as I can (Monday-ish is likely).
-Ng_

NG: You're wonderful. The quick testing done this am indicates it works.
Will upload to my live site later today :D (dont want to risk fumble fingers on the live site ;) )

NG - I have a really silly question. If a newsletter subscriber decides to open an account, is there any way to default their newsletter subscription status to "yes"?
I ask because the default setting on the store for newsletter subscription is No - which seems to override their newsletter subscription status if they have subscribed before becoming a customer.

Just wondering :)
Thanks again for the wonderful mod (and the superfast debug!)
-Stephanie

It should merge the two accounts-if the person forgot to check the 'newsletter' box it should still keep their subscription, but I'll check and include a fix if needed.

-Ng_

Thanks NG -
I did a test on my mirror and it seems to be working as you describe.
There may have been some other confusion going on as we were trying to do some specialized setup for that particular customer.

Hey, NotGoddess!!

First off, thanks for what seems to be a great contribution!! (I know it's going to make my life easier, that's for sure).

I just had one question (& as I'm still pretty wet behind the ears with regards to PHP, I hope you can take a sec to help me figure it out):

Given the design of my site, I don't have room to put the full "Newsletter: Enter Email Address (& select HTML or Text-Based)" form on my main page (nor am I using sideboxes, so that approach is out)...so I'm looking at using one of the Define pages as an 'E-List' page. I'm planning to write some body copy, then I want to have the form, along with subscribe/unsubscribe buttons underneath.

My question for you: As a starting point, will I be able to just copy the newsletter_subscribe_mod code from the tpl_header.php example & paste it into the Define Pages page (and tweak the text a bit to make sure it says what I need it to say)? Or will I need to get in and rewrite some of the paths to allow the PHP to find the right way to the functions needed?

...or is there an easier way you'd suggest to do this?

It's probably a simple thing - I just don't understand PHP enough yet to figure out how you're calling the directories up to find the right code.

Thanks for helping a newbie out!

Actually it's pretty easy...if you look at the tpl_subscribe.php in the templates/ dir you'll get an idea (it uses a defined page too). I can do a workup later tonight for you if needed.

-Ng_

NotGoddess:

Actually it's pretty easy...if you look at the tpl_subscribe.php in the templates/ dir you'll get an idea (it uses a defined page too). I can do a workup later tonight for you if needed.

-Ng_

Thanks, NG! I'm looking into it...we'll see if my 'PHP Coder' hat fits me well enough today to make it work...otherwise, I might take you up on your offer to do a workup of it.

Thanks again!

Okay. Hrmph. I'm looking over it, and I'm still not getting how it works. (And even though I've backed up, I don't want to lose track of what I'm working with & somehow mess up the whole thing.)

So I hate to do this, but might I take you up on that offer of doing a workup that would work the way I need it to? I'm just not good enough yet to understand it...and while I firmly believe in learning by doing, I just want to be DONE with this, at this point.

Basically, I'm trying to create a page something like the top of this page:

http://www.glarkware.com/elist.shtml

(Just the top part - although their way of being able to 'subscribe' to a product that's out of stock is pretty cool... But I'll just wait a year (or 5) 'til I'm a bit more familiar with the inner workings of Zen Cart, then I'll try & tackle that one myself.) :smile:

I've got the layout part down...I just need to be able to have the subscribe and unsubscribe buttons on the same page, under the field.

If there's anything you could do to look into it, I'd really appreciate it.