-
Newsletter Subscriber Discount
The Newsletter Subscriber Discount is now available in the downloads area at
http://www.zen-cart.com/index.php?ma...roducts_id=986
You can offer a percentage discount to your newsletter subscribers whether you use the native Zen Cart newsletter facility or MailChimp.
Extended help on this module is available at
http://www.thatsoftwareguy.com/zenca..._discount.html
That Software Guy
-
Re: Newsletter Subscriber Discount
Thank you for a great contribution that's easy to implement and for the added marketing tip.
Is there a way to exclude gift certificates from the discount?
-
Re: Newsletter Subscriber Discount
I wanted to see if it would be popular before taking the time to add all that infrastructure.
-
Re: Newsletter Subscriber Discount
I understand. Count me in as a fan of this contribution and I'll be waiting as patiently as possible for updates :smile:
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
bandora
Thank you for a great contribution that's easy to implement and for the added marketing tip.
Is there a way to exclude gift certificates from the discount?
My thoughts exactly!
Will look forward to seeing this feature in the near future. :yes:
-
Re: Newsletter Subscriber Discount
Version 1.1 is now available on the download site with product and category exclusion mechanisms. They're the same style as are used in Quantity Discounts. Documentation is on my home page at
http://www.thatsoftwareguy.com/zenca..._discount.html
MailChimp users are particularly encouraged to upgrade since this version contains the new API.
ThatSoftwareGuy
-
Re: Newsletter Subscriber Discount
A couple questions about this...
Is it a one time discount?
Can I put in a dollar amount or just a percentage?
Thank you. Tracy
-
Re: Newsletter Subscriber Discount
Thank you for the update, this is great! :clap:
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
tracyselena
A couple questions about this...
Is it a one time discount?
Can I put in a dollar amount or just a percentage?
Thank you. Tracy
Percent only. Not one time, every checkout.
-
Re: Newsletter Subscriber Discount
Thanks, Software Guy!! Just installed the update. It excludes the gift certificate category beautifully! Your donation is on it's way!!
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
The MailChimp API has been upgraded to the latest (1.1) version. If you are using MailChimp to do your Newsletter Discounts, please upgrade to version 1.2 of this contribution (which contains the new API) at the earliest opportunity; previous versions of the API have been deprecated.
-
Re: Newsletter Subscriber Discount
I was hoping to find a solution to the problem I'm having. I just installed this mod. I think is great like all your other contributions.
I have Easy Sign Up and Login v1.17 (from numinix) installed. In order for my login/create account page to work after items have been added to the cart, either the Newsletter Discount must be uninstalled or the "Display Order Total" of the Fast & Easy Checkout/Easy Sign Up & Login configuration must be set to false.
Does anybody have these two mods working together with both options installed and/or set to true?
Thanks
-
Re: Newsletter Subscriber Discount
I haven't heard of this problem. The best way to get to the bottom of it would be to create a test cart and apply the mods one at a time seeing where things break.
-
Re: Newsletter Subscriber Discount
This is a very nice mod - tried it on a test site and it worked great!
For my purpose; however, I need a fixed amount not a percent.
Would that be an easy alteration to the code you could explain, or will you be coming out with that feature in the near future?
I see a lot of marketing potential with this one.
Thanks,
Beth
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
Sounds like a cool contribution.
But ... (although I'm still setting up my store and haven't actually tried it yet) how is this different from creating a Discount Coupon and inserting the link to it inside the newsletter. ZenCart would be doing my emailing.
-
Re: Newsletter Subscriber Discount
What you're suggesting would certainly be another way of offering a discount to newsletter subscribers.
-
Re: Newsletter Subscriber Discount
... of course, the disadvantage of your approach would be that subscribers could forward the coupon to non-subscribers, and you wouldn't know.
-
Re: Newsletter Subscriber Discount
Good point. Yes, that's what I was looking for.
I knew there had to be a reason for a separate contribution.
-
Re: Newsletter Subscriber Discount
I just installed Mailchimp's Ecommerce 360 plugin into my Zen Cart install and I suspect that there might be a conflict with the Newsletter Discount plugin.
After I installed the Mailchimp plugin, I didn't get any errors reported when I started up my store. What did happen, though, was that the Checkout page failed to completed load when I tried to Checkout. It stopped loading right when it was computing the price (and I assume the discounts). As soon as I removed the Mailchimp 360 plugin files all was well again.
I have sent in a report of this to the MailChimp customer service, but I thought you might like to know that this was my experience.
(And if I had to choose, I'd choose your Newsletter Discount -- thank you for the lovely plugin. :smile:)
Here is the link to their plugin:
http://www.mailchimp.com/plugins/ecomm360.phtml
Cheers,
Alex
-
Re: Newsletter Subscriber Discount
Investigating. Will respond ASAP.
-
Re: Newsletter Subscriber Discount
I'm also right now in email exchange with Mailchimp's API department. I'll let you know if anything comes of that. But part of the issue might be the MCAPI.class.php file -- they place it directly in the /includes folder (not in /includes/classes like Newsletter Discount does), thus leaving two MCAPI.class.php files...
-
Re: Newsletter Subscriber Discount
That's the problem. I thought they fixed that.
The MailChimp guys have their own support thread for MailChimp 360 here:
http://www.zen-cart.com/forum/showthread.php?t=112837
I have posted some remarks in that thread.
-
Re: Newsletter Subscriber Discount
Their new version seems to work -- or at least no longer conflicts with Newsletter Discount -- I installed it and am no longer getting the crashes. So, thank you for getting them on the right track. :smile:
But in testing it, I found something that I had not noticed before. Right now, I am using Newsletter Discount to make certain of my downloadable comics free to my Mailchimp subscribers, thus I have set up one category of products (category "4") to give 100% discount to subscribers.
When I log in as with a subscriber email, everything works great. If I checkout with something from category 4, the plugin subtracts 100% of the product price -- I can see the discount during checkout -- and I can download the comic for free (it skips my one payment solution altogether -- PayPal --and just takes me to Checkout Success for download.)
But I just now tested a product from category 4 with a non-subscriber email. If I checkout with a product that's in category 4, it doesn't show me the discount during checkout -- which is good -- but it still skips my PayPal screen and let's me download the comic without paying! And the order shows up as "cc free" in my orders list -- the same code Newsletter Discount uses for my discounted subscribers! (Both use "cc free", even though I don't have credit card as an activated module, only PayPal. When I uninstalled the credit card module, it now shows "moneyorder free" for those transactions.)
When I change the Newsletter Discount to 50%, this no longer happens. Non-subscribers who checkout with downloadable comics from category 4 are taken to the PayPal screen for payment before they can download comics from this category.
So there seems to be some kind of problem with using a discount of 100%. Did I set things up wrong? Is there a way for this to be fixed?
Please let me know - and thank very much you for the great plug-in!
Alex
P.S. In case it helps, this is the code I used to tell Newsletter Discount to only apply to category 4:
Code:
function exclude_category($category) {
switch($category) {
case 4:
return false;
}
return true;
}
-
Re: Newsletter Subscriber Discount
Have not heard of this problem.
-
Re: Newsletter Subscriber Discount
swguy,
Thank you for your reply. I'm a little unclear as to how to proceed, however.
Should your plugin work in the manner I need it to? That is, should I be able to use a 100% discount with a specific category and have that 100% discount only be applied to newsletter subscribers and not everyone?
If so, are you going to investigate this further?
This is obviously important to me as the discount needs to only apply to newsletter subscribers. Your help in fixing this problem would be greatly appreciated. :smile:
Thank you for your excellent work on this plugin and for your support in helping me troubleshoot this. :smile:
Alex
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
alexwoolfson
Should your plugin work in the manner I need it to? That is, should I be able to use a 100% discount with a specific category and have that 100% discount only be applied to newsletter subscribers and not everyone?
Yes. Please double check your settings under admin->modules->order totals->newsletter discount to be sure you're using mailchimp. Then double check the email address that you think is not subscribed and make sure it's not.
-
Re: Newsletter Subscriber Discount
OK. I double-checked those things.
Under admin->modules->order totals->newsletter discount, my newsletter type is listed as "mailchimp" and I can see that my mailchimp userid and password are filled in correctly.
When I log in with an email address that is on my list and I checkout with one of my downloadable products from category "4", I see the Newsletter Discount line item in the order total subtracting the exact dollar amount from the order total. As the order total then becomes "$0.00", I proceed to Checkout Success without going to PayPal and without having to pay and can download the comic.
http://www.alexwoolfson.com/Order_To...er_Account.jpg
When I log in using an email that I have confirmed is NOT on my list, and I checkout with the same downloadable product from category "4", I do NOT see any Newsletter Discount from the order total. I see the full charge for my product.
http://www.alexwoolfson.com/Order_To...er_Account.jpg
However, if I proceed through Checkout, I am again taken to the Checkout Success page WITHOUT being sent to PayPal and WITHOUT having to pay.
In both cases, the orders show up as "moneyorder free" in my orders screen.
http://www.alexwoolfson.com/Order_Billing_Shipping.jpg
(They were showing up as "cc free" but I uninstalled the credit card module in trying to troubleshoot this.)
Interestingly, if I change my Discount Amount from "100" to "50", then I am sent to PayPal for payment regardless of which email I use (in the case of the Subscriber Email, I receive the expected 50% discount and in the case of the Non-Subscriber Email, I receive no discount.) Thus, it seems that somehow it is the entering of "100" that is causing the problem.
-
Re: Newsletter Subscriber Discount
What flavor of PayPal are you using?
-
Re: Newsletter Subscriber Discount
I am using "PayPal IPN - Website Payments Standard".
-
Re: Newsletter Subscriber Discount
Version of Zen Cart? Have you verified that your copy of ipn_main_handler.php is current and has not been modified?
-
Re: Newsletter Subscriber Discount
I am running
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version 5.2.6
My copy of ipn_main_handler.php is dated 11/27/07 (long before my fresh install of this September) -- I haven't touched or altered it in any way.
-
Re: Newsletter Subscriber Discount
Somehow the order object that's created in ipn_main_handler.php does not contain the correct customer email address, or this address is not getting passed to the order total process function. Don't know why.
You could try printing session variables and the order object after it's instantiated using ipn_debug_email to see what you have if you want to track this down.
-
Re: Newsletter Subscriber Discount
If you think we might be able to get this to work, then I am happy to work with you to track this down. :smile:
Quote:
You could try printing session variables and the order object after it's instantiated using ipn_debug_email to see what you have if you want to track this down.
I'm afraid that I've never done that before. Is it as simple as me turning the debug mode to "Log and Email" in the PayPal module? After doing that, would I just try checking out with one of these 100% discount products and then post the results of the debug file here? (Are there any security concerns -- meaning is there anything from the debug logs I SHOULDN'T post here?)
-
Re: Newsletter Subscriber Discount
OK, I went ahead and turned on the Log and Email debug mode. Here is what happened:
When I used a non-subscriber email account and checked out with an item that would get 100% discount for a subscriber, it skipped PayPal, just like before, even though it did not indicate any discount. More importantly, I didn't get a debug email. It was like PayPal was bypassed altogether when I set my discount to 100%.
Just to check it, though, I then changed the discount amount to 50% while still logged in with this non-subscriber email. I then checked out with the same product. Just like the last time I did this, this time I was taken to PayPal AND a debug email was immediately sent to me.
So the debug feature seems to be working, but it's as if PayPal is bypassed altogether when the Discount Amount is set to 100, so I'm not even getting debug reports in this case.
-
Re: Newsletter Subscriber Discount
In the file includes/modules/order_total/ot_newsletter_discount.php find
function calculate_deductions() {
global $db, $order, $currencies;
right underneath this, add
if (!$this->is_subscriber()) {
return;
}
and retest with 100%.
-
Re: Newsletter Subscriber Discount
:clap: That seems to have done it. I tested with both a subscriber email and a non-subscriber email, with both category 4 products and non-category 4 products and the behavior is exactly as it should be.
I'll keep testing over the next few days to be sure, but everything seems to work now.
Thank you for your help! :smile:
-
Re: Newsletter Subscriber Discount
Well... it's not like I spoke too soon.... the most important thing is working, but I just looked over the order confirmation that is sent to the customer who just had a successful checkout with a free (100% discount) product and under payment method it is says:
Code:
Payment Method
Check/Money Order
Please make your check or money order payable to:
the Store Owner/Website Name
Mail your payment to:
The Yaoi 911™ Store
2370 Market Street
Suite 339
San Francisco, CA
94114
U.S.A.
(206) 202-3243
Your order will not ship until we receive payment.
It seems like it is using Money Order for 100% discounts (and probably would be using Credit Card if I had not uninstalled that module.) It's not the end of the world I suppose but it would probably be a little confusing for the customer. :(
This seems like a much harder fix, but is there a way for Newsletter Discount to use The Zen Cart FREE CHARGE CARD for 100% discount transactions? I think if it did that it would create the order confirmations you would expect in such cases...
-
Re: Newsletter Subscriber Discount
The question of which payment method to use is made by Zen Cart, not the Newsletter Discount.
-
Re: Newsletter Subscriber Discount
Fair enough. I notice that the decision as to order status is made under Admin > GV Coupons > Default Order Status For Zero Balance Orders. Perhaps there is a way to have a default module for zero balance orders as well.
I will ask the gurus elsewhere on this forum if they know the answer and if I find out anything, I'll link back to it here.
Thank you for your help with your plugin,
Alex
-
Re: Newsletter Subscriber Discount
Newsletter Discount 1.3 is now available in the download area with a fix to the problem reported by Alex. This only affects people who are as generous as he is :) offering 100% discounts and payment by PayPal IPN.
-
Re: Newsletter Subscriber Discount
I just installed this module for a client of mine and we're running into an issue. When we setup the Newsletter Discount module to give discounts to Zen Cart newsletter subscribers, the module works great! However, if we change the module to give discounts to MailChimp subscribers the module doesn't recognize us as subscribers and we see no discount.
The user/pass for MailChimp is set up properly, what do you think is causing the error?
-
Re: Newsletter Subscriber Discount
Have you checked your lists in MailChimp to ensure that the corresponding email addresses are in fact subscribers?
-
Re: Newsletter Subscriber Discount
swguy, yes they are all subscribers. Do we need to install your MailChimp sidebox module for it to work? At this point we have pasted a MailChimp sign-up form on it's own page on our site.
-
Re: Newsletter Subscriber Discount
The Newsletter Discount module contains an older version of the MailChimp API; if you are using MailChimp your discounts are not working, please download the new MCAPI.class.php file from the MailChimp downloads page. You want the PHP 4/5 API wrapper. Install the file in includes/classes/MCAPI.class.php.
The MailChimp downloads page is at
http://www.mailchimp.com/api/downloads/
A future version of this contribution will include an updated API. If you are running MC360, you already have an updated API.
Scott
-
Re: Newsletter Subscriber Discount
Hello Software Guy,
I have been racking my brain on this and can't figure it out. I have the module installed and it's great. The problem i'm having is that it is giving the newsletter discount to everyone, even non-subscribed customers. Any ideas?
-
Re: Newsletter Subscriber Discount
First I want to say this newsletter discount mod is great! I've also implemented the SMS On Sale mod and it has come in very handy for my merchant client as well. However, I'm having an intermittent issue w/Newsletter Discount. Every so often an order comes through where the discount % amount is ADDED instead of subtracted from the order subtotal. It just happened on the last order that came through my client's cart. I have not been able to reproduce the problem when sending test orders. This is something that just out of the blue occurs every few orders. All I did was upload the mod and set a 10% discount in the admin panel. What's going on?
-
Re: Newsletter Subscriber Discount
UPDATE: We just discovered that the discount is ADDED when the order changes status from "Pending" to "Processing" - I'm depending on an employee that does data entry and handles the orders to report back to me whenever there are issues, and she just noticed that today when manually fixing one of these orders. So I changed the status of a test order I entered and lo and behold the discount was no longer subtracted but ADDED to my subtotal. How can we resolve this?
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
Let me know if you need more info...
-
Re: Newsletter Subscriber Discount
I'm using Admin->Customers->Orders to change the order status and not seeing a change to the discount.
-
Re: Newsletter Subscriber Discount
Hmmm, interesting. You should be familiar with me, I got you to do a custom store pickup only mod for a pet store. The mod works great BTW and they're very happy. I installed SMS On Sale and Newsletter Discount to the same store. This same store is the one having issues with Newsletter Discount adding the percentage when order status is changed. I've installed a number of mods in this cart, I'll post a list of them b/c maybe a mod is interfering w/the way this one works, but right now I need to catch up on another pressing project.
-
Re: Newsletter Subscriber Discount
I have the same problem when using edit orders, but the newsletter and better together discount both become added not subtracted, and I have to make sure I and the minus sign in everytime before saving
-
Re: Newsletter Subscriber Discount
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
-
Re: Newsletter Subscriber Discount
Hi,
I am using ZC v1.38a and have just installed the Newsletter Discount. Thank you for this great mod!
I am interested in modifying it so that the discount is NOT applied if a coupon is used. I would like all subscribers to get the discount but if a coupon is successfully applied I would like the newsletter discount to says something like "Cannot be used in conjunction with any other discount"...
I was hoping you might be able to point me in the right direction to get started? Off the top of your head would this require alot of changes? Would I be able to create a user exit function for this?
Any help on this subject is greatly appreciated.
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
Hi swguy, quick question?
I have the basic newsletter mod installed, but I like yours, with the discount option.
If I install your newsletter discount mod, would that automatically override the basic newsletter mod that I have on there already or do I need to uninstall it first?
Posted via Mobile Device
-
Re: Newsletter Subscriber Discount
I don't really know anything about the basic newsletter mod so I can't really say.
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
christinapupo
I am interested in modifying it so that the discount is NOT applied if a coupon is used. I would like all subscribers to get the discount but if a coupon is successfully applied I would like the newsletter discount to says something like "Cannot be used in conjunction with any other discount"...
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:
http://www.sardajewelry.com/store/images/before.gif
After any coupon is applied:
http://www.sardajewelry.com/store/images/after.gif
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
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 Code:
<?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>';
?>
-
Re: Newsletter Subscriber Discount
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.
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
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
-
Re: Newsletter Subscriber Discount
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
-
Re: Newsletter Subscriber Discount
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
-
Re: Newsletter Subscriber Discount
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:
<?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>';
?>
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:
-
Re: Newsletter Subscriber Discount
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.
-
Re: Newsletter Subscriber Discount
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:
-
Re: Newsletter Subscriber Discount
The about us template file.
./includes/templates/YOUR TEMPLATE/templates/tpl_about_us_default.php
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
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.
-
Re: Newsletter Subscriber Discount
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
-
Re: Newsletter Subscriber Discount
Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.
-
Re: Newsletter Subscriber Discount
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
Quote:
Originally Posted by
swguy
Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.
-
Re: Newsletter Subscriber Discount
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
-
Re: Newsletter Subscriber Discount
Backup your database.
Google "Change Collation Mysql phpMyAdmin"
Do what it says.
You should do this on the subscribers and configuration tables.
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
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';
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
christinapupo
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
-
Re: Newsletter Subscriber Discount
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.
-
Re: Newsletter Subscriber Discount
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.
-
Re: Newsletter Subscriber Discount
I have tried that. It moves everything around but the newsletter discount is still taken off of the subtotal before the quantity discount.
-
Re: Newsletter Subscriber Discount
I am going crossed eyed. Can someone please help me. I am trying to make this wonderful mod a success for me.
I would like for it not to give a coupon and a newsletter discount at the same time. I truly have no clue where I am going to edit this or what I add to it. I have gone through the forums for hours trying to find a answer.
Any help would be great. Thanks so much.
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
I offer Free Shipping on orders over $47.00 by using the freeoptions shipping module in Zen cart.
With the Newsletter module it appears the freeoptions module (free shipping feature) is being applied before my 5% Newsletter discount.
For instance, they may order 48.00 worth of items but the 5% Newsletter discount takes it below 47.00. But the cart still gives them free shipping. I don't want the free shipping to be evaluated until after the Newsletter discount is applied and the total is THEN above 47.00.
Any help is appreciated.
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
swguy
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.
Any other ideas since this is not working?
-
Re: Newsletter Subscriber Discount
You'd have to write code. I forgot that it totals the cart by itself; there's no easy way to do this without modifying the way it works.
-
Re: Newsletter Subscriber Discount
-
Re: Newsletter Subscriber Discount
I know its me but I have gone through this thread and read the instructions on the sw guy web site. The module when tested works with zen cart newsletter. When I switch over to MailChimp is where I do not see the discounts to MailChimp subscribers.
I have gone and downloaded the latest news letter discount from sw guy and I have gone and downloaded the lates API at MailChimp. I have created a MailChimp Account, created a list to test with. Gone into account and created an API Key labeled zen cart.
In the admin I have installed and switched from zen cart to MailChimp and entered in the username and password.
Where does the MailChimp API key go? I know it says in the installation instructions at step 5
Quote:
"If you are using MailChimp, login to your MailChimp account. At the top of the Mailchimp page is a dropdown called "Account." Select "api keys & info" and add an api key to your account. This is the value you should enter in the "API Key" field in Newsletter Discount config. "
I have looked in the Modules=>Order Total=> Newsletter Discounts and do not see where to place the API Key. I have opened the files provided and still I do not see where to place this key.
Any help in pointing this dummy in the right direction would be appreciated.
-
Re: Newsletter Subscriber Discount
The API key is the last field you should see in admin->modules->order total->newsletter discount on the right hand side where you set the parameters (such as discount).
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
swguy
The API key is the last field you should see in admin->modules->order total->newsletter discount on the right hand side where you set the parameters (such as discount).
Thank you for responding, I thought the same thing, so I am providing a snapshot from the admin ->modules->order total->news letter discount ->configuration. I have removed the username and password.
As you will see in the screenshot there is no input box available to place an API Key under the MailChimp login info.
Screenshot Click here for screenshot of News Letter Admin
I also opened up the ot_newsletter_discount file and looked at the function and did not see it listed.
Quote:
function ot_newsletter_discount() {
$this->code = 'ot_newsletter_discount';
$this->title = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_TITLE;
$this->description = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_DESCRIPTION;
$this->sort_order = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_SORT_ORDER;
$this->include_shipping = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_INC_SHIPPING;
$this->include_tax = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_INC_TAX;
$this->calculate_tax = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_CALC_TAX;
$this->nltype = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_NLTYPE;
$this->discount_amount = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_AMOUNT;
$this->userid = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_MAILCHIMP_USERID;
$this->password = MODULE_ORDER_TOTAL_NEWSLETTER_DISCOUNT_MAILCHIMP_PASSWORD;
$this->credit_class = true;
$this->output = array();
With your response and my conclusion is somehow I have downloaded a wrong version so I'll go back a re-down load again to check to make sure I have your latest version and I'll post back to let you know if I get all the input fields.
again thank you for responding :cool:
I downloaded the latest version listed
Quote:
Author: That Software Guy (swguy)
Version: 1.3
Zen Cart™ Version: v1.3.8
Update added on Nov 13 2008
and see no difference when re-installing it.
-
Re: Newsletter Subscriber Discount
Hmm... I very cleverly didn't release version 2.0 of MailChimp Newsletter Discount after writing it last August. This version has the new API which requires a key, and the setting in admin, and it has the API Key field in admin.
Let me double check this and I'll release this new code shortly.
-
Re: Newsletter Subscriber Discount
Weird. OK, the new version has been released.
Please note that you want to use the API in the contribution, not something you have downloaded which might be more recent and incompatible.
The instructions in the Newsletter Discount version 2.0 download match what's on my website.
Scott
-
Re: Newsletter Subscriber Discount
Quote:
Originally Posted by
swguy
Weird. OK, the new version has been released.
Please note that you want to use the API in the contribution, not something you have downloaded which might be more recent and incompatible.
The instructions in the Newsletter Discount version 2.0 download match what's on my website.
Scott
Thanks Scott, sorry for the trouble but I seem to be good at that LOL
Uninstalled and removed old version, uploaded and replaced with the new version (used the contributions API), re-installed, Yes there is an API Key field Sweet. Tested with MailChimp subscriber account (shows discount)and without MailChimp subscriber account (does not show discount) and works perfectly!
Thanks again Scott and sorry to be a bother!
-
Re: Newsletter Subscriber Discount
LOL not a bother at all - I'm glad the new software is now available.
-
Re: Newsletter Subscriber Discount
How does newsletter discount prevent other discounts from being used?
-
Re: Newsletter Subscriber Discount
It doesn't. Discounts don't know about each other unless custom logic has been added to prevent them being used together on a case by case basis.
-
Re: Newsletter Subscriber Discount
Can you write some for it?
-
Re: Newsletter Subscriber Discount
Those crazy chimps are up to their usual tricks. Please do NOT update to MailChimp API 1.3 on your own; Newsletter Discount AND MailChimp Integration will need updates first. When you do update, both modules need to be updated at the same time; API 1.3 contains breaking changes (wrt existing code).
-
Re: Newsletter Subscriber Discount
Newsletter Discount has been updated to MailChimp API 1.3.
-
Re: Newsletter Subscriber Discount
Anyway to disable? i only see
HTML Code:
This module is installed
true
No option for false