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;
}
CommentFileSizeAuthor
#7 Picture 20.png178.65 KBarcaneadam
#2 61978.patch991 bytesarcaneadam

Comments

arcaneadam’s picture

Are you using the standalone mailchimp module or the Email Marketing Framework version?

arcaneadam’s picture

Assigned: Unassigned » arcaneadam
StatusFileSize
new991 bytes

Also 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

The add-on isnt showing up in the mailchimp account after installing this module

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.

thill_’s picture

Where do I enable the thing in the mail chimp account? I cant find it. I have plenty of order data, on the site.

arcaneadam’s picture

It 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/

arcaneadam’s picture

Status: Active » Closed (fixed)
thill_’s picture

Status: Closed (fixed) » Active

You 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?

arcaneadam’s picture

StatusFileSize
new178.65 KB

It on step two when you are setting up a campaign. screenshot attached

arcaneadam’s picture

Title: Invalid argument supplied for foreach() in /uc_mailchimp/uc_mailchimp.module on line 298 » Enabling the MailChimp Ecommerce Add-on
thill_’s picture

I 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

arcaneadam’s picture

I'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.

thill_’s picture

Status: Active » Closed (fixed)

Ok many orders have went through without the php error.

BenK’s picture

Subscribing....