This topic can no longer be replied to because it has been locked.

Guest user not change state
Gravatar
Joined: 2017-12-15
Posts: 24
Hello, from a month if a guest user signup to newsletter form (I have double opt-in active) the user is imported to mailchimp list without problems but the state in Magento Newsletter Subscription is not "Subscribed" but remain "Not Activated".

Magento 1.9.3.2 and Mailchimp for Magento v1.1.13.

Here a screenshot of the issue: https://prnt.sc/mcyoc0

And here the screenshot for extension configuration: https://prnt.sc/mcyqfs

Could I have information about it?

Thanks in advance
Gravatar
Joined: 2018-08-14
Posts: 249
Hi Daniele,

Thanks for contacting us.

Please check if the webhook was created to do this access to the Mailchimp account-> Lists there select the list then access to settings-> webhooks there you should see the URL for the webhook.

Please check if the cronjob for the webhooks is running correctly to do this run the next query on the database and send me the result:
select * from cron_schedule where job_code = "mailchimp_process_webhook_data";
Gravatar
Joined: 2017-12-15
Posts: 24
Hi Lucia,
the webhook under Mailchimp Settings List was created and the cronjob from what I can see it works properly, here the results:

"206","subscribe","2019-01-03 11:44:54","a:8 {s:2:""id"";s:10:""16a17ccb5b"";s:5:""email"";s:27:""********@gmail.com"";s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:11:""*.*.*.*"";s:9:"
"ip_signup"";s:14:""*.*.*.*"";s:6:""web_id"";s:9:""148935521"";s:6:""merges"";a:27:
{s:5:""EMAIL"";s:27:""********@gmail.com"";s:7:""WEBSITE"";s:1:""1"";s:7:""STOREID"";s:1:""1"";
s:9:""STORECODE"";s:2:""it"";s:6:""PREFIX"";s:0:"""";s:5:""FNAME"";s:0:"""";s:5:""MNAME"";s:0:"""";s:5:""LNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";s:6:""CGROUP"";s:13:""NOT LOGGED IN"";
s:3:""DOB"";s:0:"""";s:7:""BILLING"";s:0:"""";s:8:""SHIPPING"";s:0:"""";s:3:""TAX"";s:0:"""";s:9:""CONFIRMED"";s:0:"""";
s:9:""CREATEDAT"";s:0:"""";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";
s:8:""BCOUNTRY"";s:0:"""";s:10:""BTELEPHONE"";s:0:"""";s:8:""BZIPCODE"";s:0:"""";s:8:""SCOMPANY"";s:0:"""";
s:8:""SCOUNTRY"";s:0:"""";s:10:""STELEPHONE"";s:0:"""";s:8:""SZIPCODE"";s:0:"""";s:3:""DOP"";s:0:"""";}s:7:""list_id"";
s:10:""397b0fd361"";}","1"

I can't understand why from about a month this issue occur.

NOTE: This only occur when under Customer > Newsletter "Confirmation request" is set to yes for the double opt-in.

I'm waiting for your feedback.

Thanks
Gravatar
Joined: 2018-08-14
Posts: 249
Hi Daniele,

I will try to reproduce this.
Please run the next query on the database and send me the result:
select * from mailchimp_webhook_request;
Gravatar
Joined: 2017-12-15
Posts: 24
Hi Lucia,

With that query I got these results.

Here the results (I obscured emails and ip addresses, if u need I can send other information to you if you can send to me an email address.

"206","subscribe","2019-01-03 11:44:54","a:8:{s:2:""id"";s:10:""16a17ccb5b"";s:5:""email"";s:27:""********@gmail.com"";s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:11:""*.*.*.*"";
s:9:""ip_signup"";s:14:""*.*.*.*"";s:6:""web_id"";s:9:""148935521"";s:6:""merges"";a:27:{s:5:""EMAIL"";s:27:""********@gmail.com"";s:7:""WEBSITE"";s:1:""1"";s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";s:2:""it"";
s:6:""PREFIX"";s:0:"""";s:5:""FNAME"";s:0:"""";s:5:""MNAME"";s:0:"""";s:5:""LNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";
s:6:""CGROUP"";s:13:""NOT LOGGED IN"";s:3:""DOB"";s:0:"""";s:7:""BILLING"";s:0:"""";s:8:""SHIPPING"";s:0:"""";s:3:""TAX"";s:0:"""";
s:9:""CONFIRMED"";s:0:"""";s:9:""CREATEDAT"";s:0:"""";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";
s:0:"""";s:8:""BCOUNTRY"";s:0:"""";s:10:""BTELEPHONE"";s:0:"""";s:8:""BZIPCODE"";s:0:"""";s:8:""SCOMPANY"";s:0:"""";
s:8:""SCOUNTRY"";s:0:"""";s:10:""STELEPHONE"";s:0:"""";s:8:""SZIPCODE"";s:0:"""";s:3:""DOP"";s:0:"""";}s:7:""list_id"";
s:10:""397b0fd361"";}","1"


"207","subscribe","2019-01-03 23:11:15","a:8:{s:2:""id"";s:10:""16a17ccb5b"";s:5:""email"";s:27:""********@gmail.com"";s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:11:""*.*.*.*"";
s:9:""ip_signup"";s:14:""*.*.*.*"";s:6:""web_id"";s:9:""148935521"";s:6:""merges"";a:27:{s:5:""EMAIL"";s:27:""********@gmail.com"";s:7:""WEBSITE"";s:1:""1"";s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";s:2:""it"";
s:6:""PREFIX"";s:0:"""";s:5:""FNAME"";s:0:"""";s:5:""MNAME"";s:0:"""";s:5:""LNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";s:6:""CGROUP"";
s:13:""NOT LOGGED IN"";s:3:""DOB"";s:0:"""";s:7:""BILLING"";s:0:"""";s:8:""SHIPPING"";s:0:"""";s:3:""TAX"";s:0:"""";s:9:""CONFIRMED"";s:0:"""";
s:9:""CREATEDAT"";s:0:"""";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";s:8:""BCOUNTRY"";
s:0:"""";s:10:""BTELEPHONE"";s:0:"""";s:8:""BZIPCODE"";s:0:"""";s:8:""SCOMPANY"";s:0:"""";s:8:""SCOUNTRY"";s:0:"""";
s:10:""STELEPHONE"";s:0:"""";s:8:""SZIPCODE"";s:0:"""";s:3:""DOP"";s:0:"""";}s:7:""list_id"";s:10:""397b0fd361"";}","1"


"208","subscribe","2019-01-11 18:24:10","a:8:{s:2:""id"";s:10:""7dbebce842"";s:5:""email"";s:15:""********@live.it"";s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:12:""*.*.*.*"";
s:9:""ip_signup"";s:14:""*.*.*.*"";s:6:""web_id"";s:9:""149026181"";s:6:""merges"";a:27:{s:5:""EMAIL"";s:15:""********@live.it"";s:7:""WEBSITE"";s:1:""1"";s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";s:2:""it"";
s:6:""PREFIX"";s:0:"""";s:5:""FNAME"";s:0:"""";s:5:""MNAME"";s:0:"""";s:5:""LNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";
s:6:""CGROUP"";s:13:""NOT LOGGED IN"";s:3:""DOB"";s:0:"""";s:7:""BILLING"";s:0:"""";s:8:""SHIPPING"";s:0:"""";s:3:""TAX"";s:0:"""";s:9:""CONFIRMED"";s:0:"""";
s:9:""CREATEDAT"";s:0:"""";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";s:8:""BCOUNTRY"";
s:0:"""";s:10:""BTELEPHONE"";s:0:"""";s:8:""BZIPCODE"";s:0:"""";s:8:""SCOMPANY"";s:0:"""";s:8:""SCOUNTRY"";s:0:"""";
s:10:""STELEPHONE"";s:0:"""";s:8:""SZIPCODE"";s:0:"""";s:3:""DOP"";s:0:"""";}s:7:""list_id"";s:10:""397b0fd361"";}","1"


"211","subscribe","2019-01-30 15:33:09","a:8:{s:2:""id"";s:10:""70a033ed74"";s:5:""email"";s:25:""danieletest2323@gmail.com"";s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";
s:12:""93.66.77.126"";s:9:""ip_signup"";s:14:""93.186.248.117"";s:6:""web_id"";s:9:""149271957"";s:6:""merges"";a:27:{s:5:""EMAIL"";s:25:""danieletest2323@gmail.com"";s:7:""WEBSITE"";s:1:""1"";s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";
s:8:""Italiano"";s:5:""FNAME"";s:3:""hhh"";s:5:""LNAME"";s:3:""hhh"";s:6:""CGROUP"";s:8:""Generale"";s:7:""BILLING"";
a:6:{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";
s:7:""country"";s:2:""US"";}s:8:""SHIPPING"";a:6:{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";
s:7:""country"";s:2:""US"";}s:3:""TAX"";s:16:""********************"";s:9:""CONFIRMED"";s:0:"""";s:9:""CREATEDAT"";
s:25:""2019-01-30T15:31:56+01:00"";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";
s:8:""BCOUNTRY"";s:6:""Italia"";s:10:""BTELEPHONE"";s:3:""123"";s:8:""BZIPCODE"";s:5:""27100"";s:8:""SCOMPANY"";
s:0:"""";s:8:""SCOUNTRY"";s:6:""Italia"";s:10:""STELEPHONE"";s:3:""123"";s:8:""SZIPCODE"";s:5:""27100"";s:3:""DOP"";
s:0:"""";s:6:""PREFIX"";s:0:"""";s:5:""MNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";s:3:""DOB"";s:0:"""";}s:7:""list_id"";
s:10:""397b0fd361"";}","1"

"212","unsubscribe","2019-01-30 15:34:34","a:9{s:6:""reason"";s:6:""manual"";s:2:""id"";s:10:""70a033ed74"";s:5:""email"";s:25:""danieletest2323@gmail.com"";
s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:12:""*.*.*.*"";s:9:""ip_signup"";s:14:""93.186.248.117"";s:6:""web_id"";
s:9:""149271957"";s:6:""merges"";a:27{s:5:""EMAIL"";s:25:""danieletest2323@gmail.com"";s:7:""WEBSITE"";s:1:""1"";
s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";s:8:""Italiano"";s:5:""FNAME"";s:3:""hhh"";s:5:""LNAME"";s:3:""hhh"";
s:6:""CGROUP"";s:8:""Generale"";s:7:""BILLING"";a:6{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";
s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";s:7:""country"";s:2:""US"";}s:8:""SHIPPING"";a:6:{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";
s:7:""country"";s:2:""US"";}
s:3:""TAX"";s:16:""********************"";s:9:""CONFIRMED"";s:0:"""";s:9:""CREATEDAT"";s:25:""2019-01-30T15:31:56+01:00"";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";s:8:""BCOUNTRY"";
s:6:""Italia"";s:10:""BTELEPHONE"";s:3:""123"";s:8:""BZIPCODE"";s:5:""27100"";s:8:""SCOMPANY"";s:0:"""";s:8:""SCOUNTRY"";
s:6:""Italia"";s:10:""STELEPHONE"";s:3:""123"";s:8:""SZIPCODE"";s:5:""27100"";s:3:""DOP"";s:0:"""";s:6:""PREFIX"";s:0:"""";
s:5:""MNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";s:3:""DOB"";s:0:"""";}s:7:""list_id"";s:10:""397b0fd361"";}","1"

"213","unsubscribe","2019-01-30 15:35:00","a:10:{s:6:""action"";s:6:""delete"";s:6:""reason"";s:6:""manual"";s:2:""id"";s:10:""70a033ed74"";s:5:""email"";
s:25:""danieletest2323@gmail.com"";
s:10:""email_type"";s:4:""html"";s:6:""ip_opt"";s:12:""*.*.*.*"";s:9:""ip_signup"";s:14:""*.*.*.*"";s:6:""web_id"";
s:9:""149271957"";s:6:""merges"";a:27{s:5:""EMAIL"";s:25:""danieletest2323@gmail.com"";s:7:""WEBSITE"";s:1:""1"";
s:7:""STOREID"";s:1:""1"";s:9:""STORECODE"";s:8:""Italiano"";s:5:""FNAME"";s:3:""hhh"";s:5:""LNAME"";s:3:""hhh"";
s:6:""CGROUP"";s:8:""Generale"";s:7:""BILLING"";a:6:{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";
s:7:""country"";s:2:""US"";}s:8:""SHIPPING"";a:6:{s:5:""addr1"";s:3:""abc"";s:5:""addr2"";s:0:"""";s:4:""city"";s:5:""pavia"";s:5:""state"";s:5:""pavia"";s:3:""zip"";s:5:""27100"";
s:7:""country"";s:2:""US"";}
s:3:""TAX"";s:16:""********************"";s:9:""CONFIRMED"";s:0:"""";s:9:""CREATEDAT"";s:25:""2019-01-30T15:31:56+01:00"";s:6:""GENDER"";s:0:"""";s:9:""DISGRPCHG"";s:0:"""";s:8:""BCOMPANY"";s:0:"""";
s:8:""BCOUNTRY"";s:6:""Italia"";s:10:""BTELEPHONE"";s:3:""123"";s:8:""BZIPCODE"";s:5:""27100"";s:8:""SCOMPANY"";
s:0:"""";s:8:""SCOUNTRY"";s:6:""Italia"";s:10:""STELEPHONE"";s:3:""123"";s:8:""SZIPCODE"";
s:5:""27100"";s:3:""DOP"";s:0:"""";s:6:""PREFIX"";s:0:"""";s:5:""MNAME"";s:0:"""";s:6:""SUFFIX"";s:0:"""";s:3:""DOB"";s:0:"""";}
s:7:""list_id"";s:10:""397b0fd361"";}","1"


Thanks in advance.
Gravatar
Joined: 2017-12-15
Posts: 24
Hi Lucia,

now I got other problems but I can't understand why because I did not made any changes to Magento, I have only updated your extension a week ago from version 1.1.10 to 1.1.13 and yesterday to version 1.1.14

The problems are many.

If extension enabled:

1) (this is the problem explained in prevous posts) if a guest user register to newsletter and confirmation email in magento settings and double opt-in in mailchimp settings are active the status in magento list of the users remain "Not active" instead of "Subscribed" even after confirmation, but they are subscribed in mailchimp correctly

2) if confirmation email in magento settings and double opt-in in mailchimp settings are active if a user go to register an account to the site and check the checkbox field to register to the newsletter they are not subscribed anymore to the magento list but, in addition to the new account confirmation email, 2 identical mailchimp confirmation email are sent, and after they confirmed they are subscibed to the mailchimp list correctly but the state in magento newsletter list remain "Not active" instead of "Subscribed", and the other problem is that in customer account information the newsletter checkbox field is not checked.

If I dasable double opt-in from mailchimp list and confirmation email from magento settings the users are subscribed correctly in magento list too BUT I need the double opt-in in order to reduce the subscriptions spam, or at least that magento send the confirmation email but if I disable double opt-in from mailchimp settings magento not send the newsletter confirmation email.

I need to solve these problems (up to 20 days ago everything worked).

Could you point me to the right direction?

Thanks



Gravatar
Joined: 2018-08-14
Posts: 249
Hi Daniele,

Can you share the URL of your site, please?
Do you have the logs enabled for the extension? If you do please send to my email luciaines@ebizmarts.com any log file located under your var/log folder with MailChimp in it's name. Adding the Magento logs as well will probably add some information.
Magento 1: MailChimp_Errors.log, MailChimp_Failing_Requests.log | exception.log, system.log
Gravatar
Joined: 2017-12-15
Posts: 24
Hi Lucia, I sent an email to your email address.

Thanks in advance
Gravatar
Joined: 2018-08-14
Posts: 249
Hi Daniele,

Thanks for sent all the info, it was helpful we found a bug in the extension that probably is the cause of this issue:
1) (this is the problem explained in prevous posts) if a guest user register to newsletter and confirmation email in magento settings and double opt-in in mailchimp settings are active the status in magento list of the users remain "Not active" instead of "Subscribed" even after confirmation, but they are subscribed in mailchimp correctly
as soon we fix it, i will share the fix here in this thread.

2) if confirmation email in magento settings and double opt-in in mailchimp settings are active if a user go to register an account to the site and check the checkbox field to register to the newsletter they are not subscribed anymore to the magento list but, in addition to the new account confirmation email, 2 identical mailchimp confirmation email are sent, and after they confirmed they are subscibed to the mailchimp list correctly but the state in magento newsletter list remain "Not active" instead of "Subscribed", and the other problem is that in customer account information the newsletter checkbox field is not checked.
about this behavior i was not able to reproduce it, i created an account in your store, but when i tried to subscribe to the newsletter i got the next two messages:
Confirmation request has been sent.
The subscription has been saved.
but i didn't get any confirmation email and i still see the option to subscribe to the newsletter. So i need more information, please send it to the my email:
1. Did you had installed MageMonkey, before install mailchimp for magento?
2. Please send me a complete screenshot of your current configuration settings for the extension.
Gravatar
Joined: 2017-12-15
Posts: 24
Hi Lucia,

I sent to you an email.

Thanks

NEWSLETTER

Subscribe to our newsletter to receive emails and useful news articles