Newsletter Subscriber Discount

swguy:

The Newsletter Subscriber Discount -
That Software Guy

swguy what a great mod - LOVE IT!!

Please help me - I have added this code where I want it displayed (marketing) (Contact us, Product info, and main page) and it is working fine but for some reason it won't show up on the registration page when I add it to "tpl_modules_create_account.php"

I am using Zen Cart 1.3.8a

<?php
  $value = "ot_newsletter_discount.php"; 
  include_once(zen_get_file_directory(DIR_WS_LANGUAGES . $_SESSION['language'] . 
          '/modules/order_total/', $value, 'false'));
  include_once(DIR_WS_MODULES . "order_total/" . $value);
  $discount = new ot_newsletter_discount();  
  echo '<div class="content" id="discountPolicy">'; 
  echo $discount->get_html_policy();
  echo '<br /></div>'; 
?>

I would have to debug it for you on your site. It's really difficult for me to know what's going with an installation on based on a report on the forum.

chrisnix:

Have installed on v1.3.7 and all appeared ok, but I have discovered that the discount is being aplied to ALL registered customers regardless of whether they are a subscribers or not?

I am using the native newsletter module within zencart v1.3.7.

Any tlps / pointers appreciated.

Thanks in advance

Chris

http://ineedthat.co.uk

:lookaroun Hi
Software guy to the rescue

I use zencart v1.3.8a and having the same problem, coupon is given to everyone - even to people who don't register newsletter.
Don't use mailchamp.

Julie

Actualy it was no connection between the problem and this mod from the software guy

As usual when I don't find a solution for my new zen cart store (new zenner) I solve it myself.

It was in the fast_and_easy_checkout 1.6.2 in the includes/modules/TEMPLATE_NAME/ create_account.php file

There is this row $newsletter = (ACCOUNT_NEWSLETTER_STATUS == '1' ? false : true); now for me it was set to true.

Later in the code it says

if (isset($_POST['newsletter'])) {
$newsletter = zen_db_prepare_input($_POST['newsletter']);
}

so baiscly if customer didn't checked the box it doesn't enter the If condition, and use the default which is funny to be true

I changed it to

Configuration -> Customer Details -> Show Newsletter Checkbox to 1= Display Unchecked

So it will start from false and if customer subscribed then it will be true.

And also changed the text of "Subscribe to Our Newsletter" to be more attractive

did anyone every modify this to offer a $amount off reather than a percentage, it would also be good if the news letter discount can be limited to the first 100 people taking up the offer

Hi swguy

thanks for all these great mods & all your wonderful info :) I'm in the process of installing this one. From your 'read me' installation instructions, could you please explain step 4 further?

*4. If you have an "about us" page or some other page that describes your policies, you can dynamically build a section describing your discounting policies with this code:

Are you referring to the About_Us mod? or just the define pages editor sidebox link "About Us"? What do you mean by 'dynamically build'? What does the code actually 'do'? (sorry if this is really 'obvious' to everyone but me, but I'd love to learn more.)

Thank you so much:smile:

Yes, I was referring to the about us mod. This code reaches into the Newsletter Discount mod and displays information in your about us page about the fact that you have a discount for newsletter subscribers.

Ah - thank you; you've cleared that up for me:smile:
So - what file (in About_us) would the code be inserted into?

Again - many thanks for your time.:hug:

The about us template file.

./includes/templates/YOUR TEMPLATE/templates/tpl_about_us_default.php

wonderful! thank you

The Newsletter Discount mod has been updated to include the latest MailChimp API. Only MailChimp users need upgrade; others are not affected. PLEASE READ THE INSTRUCTIONS CAREFULLY; there are a couple of new steps due to changes in the API. Note that if you are also running MailChimp sidebox, you must upgrade that module too.

Note that you MUST remove and reinstall this module in admin->modules->order total to get the new settings you need.

I've installed this and it has done something to my email database to where I can no longer send emails or even use the newsletter function of my admin. I cannot even export my email addresses. I get this error message everytime I NOW try to use any of my emial capabilities in zen cart:

"1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM subscribers as s LEFT JOIN configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
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 have seen in another thread where someone else was having these issues.

Is there any solution to this? I am in a bit of a panic mode now as my list is getting larger and I need to communicate with them. I cannot even send them direct emails from within the admin of zen cart

Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.

Hi--I never saw this error before I installed Newsletter Discounts and I had tested the built-in email and newsletter functions of Zen Cart.

Re: changing collations. I am pretty tech-saavy so if you could give me an idea of what I would have to do for this. As it stands now I am going to have to go through the laborious task of trying to get my emails out of Zen Cart and use some third party solutions.

Any help would be appreciated.

thanks - Daniel

swguy:

Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.

I really love this module...in our openign week it has been a smash week with all of our customers practically, signign up for the Newletter for an automatic 5% discount.

But I really need to be able to use my newsletter features in ZenCart. When I now go to access any sned mail functions it gives this:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM subscribers as s LEFT JOIN configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
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.

TSG you mention I need to fix collations. I am not a computer newbie by any means but is there any info you or anyone can give to do this. I badly need to start sendign out Newsletter announcements.

Daniel
GotVapes.com

Backup your database.
Google "Change Collation Mysql phpMyAdmin"
Do what it says.
You should do this on the subscribers and configuration tables.

swguy:

Backup your database.
Google "Change Collation Mysql phpMyAdmin"
Do what it says.
You should do this on the subscribers and configuration tables.

Thanks - I actually found a sql patch from DrBytes that I applied in the Tools menu that worked perfectly...

alter table subscribers change email_address email_address
varchar(96) NOT NULL default '' UNIQUE collate 'latin1_general_ci';

christinapupo:

I figured this out fairly quickly. Just add:

   if ($_SESSION['cc_id'] > 0) { 
         return; 
   }

to function process() in ot_newsletter_discount.php...

Before coupon is applied:

After any coupon is applied:

Can you please tell me what line you put this on because I can not get it to work for me at all.
Thank you

Is there a way to make the newsletter discount effective after other discounts, i.e., the quantity discount? I would rather have the newsletter discount be taken off last.

Each of the discounts has a sort order in admin->modules->order total. Just set the sort order of Quantity Discounts to be lower than Newsletter Discount, and it will be done that way.