Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#3823 - Mass data overwrite with Sugar
Last week I spoke to a member of your team to set up and allow Account data mapping from Sugar to MailChimp. I got around to mapping this data over and it seems to have caused a massive issue within Sugar. It looks as though data has been overridden on a huge number of accounts. Please can we get urgent support with this.
-
"SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
6 years ago
Hello Adam,
I'm sorry to hear about your issue with a mass overwriting of data in Sugar from MailChimp. Can you explain what data at the Account level was overwritten? Whenever you set up the field mapping for the very first time, did you choose to resync the data from MailChimp to SugarCRM? That would have caused the integration to overwrite Sugar data with whatever it finds in MailChimp for those matching records.
Let me know what you think about these pieces.
Regards, Jon
6 years ago
Hi Jon
Thanks for coming back to me. From what I can see, it looks as if Account names have been overwritten in Sugar. I chose to re-sync from SugarCRM to MailChimp.
Regards
6 years ago
Hello Adam,
Since its the Account name that was overwritten, we might be able to resolve the issue via the Audit logs. How many records were affected by the overwrite? When you go to one of your Accounts that was broken, can you go to their History and see the names in the Audit log?
I have an opening tomorrow morning (my time) so I'm going to book a call for us in that slot. If you can see the old Account names, then we can probably get a fix for you with a query.
Let me know what you find and I will see if we can make any progress on a fix prior to a call.
Thanks, Jon
6 years ago
Hi Jon
Thanks for your response.
I'm not completely sure how many records have been affected I'm afraid. We have around 35,000 Accounts and the majority look to have been updated. I have looked in the Audit logs and it looks like a huge amount of different fields have been changed, more than once.
A call would be great. Thank you.
I look forward to speaking with you soon. Adam
6 years ago
Hello Adam,
Great to hear. The new installation will update the functionality so that duplicate data will not overwrite in Sugar. No new queries are needed to be run. Let me know how the installation goes, and feel free to test the MailChimp to Sugar updates afterwards.
Kind Regards, Jon
6 years ago
Hello Adam,
I can indeed extend the trial out to give you time to test everything thoroughly before being charged. I have extended the trial out to Sept. 7th, two more weeks. Let me know if I can help answer any more questions as you get acquainted with the integration.
I'll go ahead and close this case out now.
Kind Regards, Jon
6 years ago
No problem, Adam. I'll go ahead and close this case out now.
Cheers! Jon