Need to re sync merge fields

The only way to do this would be match the merge fields in mailchimp's settings, set the list to required, ensure sync is done during cron, and reset the MC user's table. As you can see, not really a case the module is easily designed to handle.

I tried the above and it doesnt work

We added a new merge field, and now we want a token to map to it. It works fine, when we go to the individual account and save - but why its it updating all the existing accounts when I rebuild the table?

I made in mandatory, rebuilt the table, ran cron, but the new merge field is not updated.

This is very important, we need to be able to add a new mergefield at anytime, its silly that we cannot do that. As it stands now, either plan you mailchimp newsletter perfectly for the next 10 years, cuz you are not going to be able to go back and update a new merge field later. This doesnt make any sense.

Merge fields from tokens do not upate as well unless one goes to the newsletter subscription and resave. This is silly. Merge fields become outdated and there is no way to update unless one goes individually into each account.

IMHO, this is a huge problem. There is no way to share data consistently between both mailchimp and drupal. Most people never go back and change their mailchimp settings, so if they update their user role, phone number, or anything else, these fields are NEVER updated on mailchimp unless one goes to the newsletter subscription and save again.

If this module pretends to link Drupal accounts and Mailchimp list, this lack of feature is almost a bug, agree.
I have just lost a couple of days figuring this out...

This Mailchimp module is really as great as the Mailchimp service, I just hope that the merge variables will be fixed on next release.
Thanks.

Yeah. Its a pity - I like Mailchimp but this inability for Drupal and Mailchimp to communicate effectively and reliably is killer.

Anybody know if Constant Contact has these kinds of silly issues with Drupal?

I'm having this issue as well, except it's with First and Last name profile fields. First and Last name fields update when creating new users, not when syncing during cron runs. loubabe - Am we doing something wrong or do we need to throw money at this?

I agree. I would throw a little money to get mailchimp module fields syncing perfectly with mailchimp. It should do it with every cron run, when a user resaves his account info (not just when we change newsletter settings), and with a synch all feature - so if someone ones to ensure that everything is synched, we can do it all at once.

If Drupal fields and Mailchimp can synch up with 100% reliability, this would be a HUGE PLUS for the module.

I would throw in money for this ASAP. Like tomorrow.

Would it be possible (and simple) to add a hook to the user profile form so that when a user saves his profile the merge fields are updated?

That's exactly how the module works when your list is set to required.

Hey gang - The issue with required fields not syncing during cron was addressed in this commit, http://drupal.org/commitlog/commit/5104/f3e26ea360fd467267dd95262595aeed.... Hope that take care of the issues seen on this thread.

I needed to re-sync the merge fields for a required list for all existing users, after we updated our list settings in MailChimp and added new fields. Our list does not use cron-based syncing, although perhaps that would be easier. I was able to accomplish this instead using a short php script that basically just loaded and saved every user. I put the script into the Drupal root and then ran the script using drush scr command:

<?php

$i = 301; // Set the first user's id that you want to update.
$j = 442; // Set the last user's id that you want to update.
while ($i <= $j) {
  $account = user_load($i);
  if ($account) { // Check if user exists for that id.
    user_save($account);
    echo 'saved uid:' . $i . ',';
  } else {
    echo 'not found uid:' . $i . ',';
  }
  $i++;
}

?>

Kind of hacky but it worked. Ideally it would be great to have a nice UI for batch updating / re-indexing users who are subscribed to MailChimp.

Looks like someone else came up with a similar workaround, basically re-saving all the users: #840996-15: Handle user updates for lists being set as compulsory

You could also try re-syncing all users automatically during cron: #1471128: Rebuild the MailChimp users table automatically during cron when the pending queue is empty