The add-on isnt showing up in the mailchimp account after installing this module, also getting this error, maybe they are related.
/**
* Implementation of hook_mailchimp_merge_values()
*/
function uc_mailchimp_mailchimp_merge_values($user) {
$sql = 'SELECT billing_first_name first, billing_last_name last FROM {uc_orders} WHERE uid = %d';
$name = db_fetch_object(db_query($sql,$user->uid));
foreach ($name as $key =>$val) {
$out["uc_customer_{$key}"] = $val;
}
return $out;
}
| Comment | File | Size | Author |
|---|---|---|---|
| #7 | Picture 20.png | 178.65 KB | arcaneadam |
| #2 | 61978.patch | 991 bytes | arcaneadam |
Comments
Comment #1
arcaneadam commentedAre you using the standalone mailchimp module or the Email Marketing Framework version?
Comment #2
arcaneadam commentedAlso your are probably getting that error because there are no customers/orders loaded into Ubercart yet. It's my fault for not checking that the return value of the sql actually had a value. I made a patch to fix that if want and will roll it into a new release later today.
Now rereading you issue I'm not sure I understand what your are asking
Are you talking about that it isn't showing up in your Mailchimp account? if so this module doesn't actually enable it on Mailchimps end. You'll have to set it up in your mailchimp account and this module will just catch that info and send sales data back if it is enabled.
Comment #3
thill_ commentedWhere do I enable the thing in the mail chimp account? I cant find it. I have plenty of order data, on the site.
Comment #4
arcaneadam commentedIt works on a campaign by campaign basis. So when you create a new campaign you have to enable it for that campaign. Mailchimp will then tack on a few parameters to all outgoing links in that campaign. This add-on catches those parameters and when someone makes a purchase after clicking a link in your campaign it sends the order data back to MC which then will display that data in the Campaign report there by allowing you to track Ecommerce statistic for each campaign.
For more info on how MailChimps Ecommerce 360 works please visit their site.
http://www.mailchimp.com/blog/ecommerce-tracking-plugin/
Comment #5
arcaneadam commentedComment #6
thill_ commentedYou said you enable it in the campaign, but the blog you pointed me to says it is in the add-on account section. I don't see anywhere in the mailchimp interface to enable it. Can you post a screen shot?
Comment #7
arcaneadam commentedIt on step two when you are setting up a campaign. screenshot attached
Comment #8
arcaneadam commentedComment #9
thill_ commentedI applied the patch and did find the setting, it is not where the article says it is. I added a comment to the article.
I am not sure changing the title was a good idea, others will be searching for the php error about the invalid foreach.
I will close this if I don't get that error again in the next day.
Thanks
Comment #10
arcaneadam commentedI've already released the fix into version 6.x-1.1 of the module so It probably won't be an issue. And the overarching theme of this issue has been MailChimp Account stuff.
Comment #11
thill_ commentedOk many orders have went through without the php error.
Comment #12
BenK commentedSubscribing....