#3525 - sync: "cross pollination" between multiple lists
While trying to have multiple lists in mailchimp synced to corresponding target lists on sugarcrm (and with the correct pairings set), I see cyclic updates to all involved lists on both sides until all involved lists have the same set of list members. Email addresses on multiple lists on mailchimp side can maintain different 'Email Marketing' statuses on different lists (read: it can be 'Subscribed' on one list and 'Unsubscribed' on another). Deleting emails from one of the (mailchimp) lists gets synced to suitecrm, and then back to mailchimp on the other list(s). I have no idea if this is related, but I've found multiple occurrences of these two suspicious lines in the suitecrm.log file: * "Mailchimp_Webhooks_Receiver cannot process webhook, no list id is provided" * "SmartList_Mode_All get_initial_sql: cannot generate query, this->metadata is empty"
This situation has already caused financial impact on the mailchimp side (our suitecrm is self-hosted), and has forced us to only maintain one pairing between mailchimp and suitecrm (for the time being) and to keep the other small lists updated with csv exports.