by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#1858 - Applying cleaned to the Invalid field in Sugar manually

Closed General Question created by SeanHill 5 years ago

We have a list of 'Cleaned' email addresses in Excel. It was generated from a non-mailchimp email marketing service with no integration with Sugar.

To use these with Mailchimp we need the cleaned list to be batch applied to our database, setting the Invalid flag for each address.

What means would you recommend for doing this?

Thank you.

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago


    To clarify: Do you need the Email Addresses to be imported or not? If not, you will need to import them from .csv first. There are really two options for applying the invalid flag to multiple email addresses in Sugar:

    1. You can do it manually by hand, depending on the amount of addresses you have this could be the fastest option.
    2. You can write a query that does it for you. If your numbers are too high, then you will need a query to go find all of the appropriate email addresses to flag.

    Once the flag is applied, then those changes will be pushed to MailChimp on the next sync. If I've misunderstood the question, could you explain in more detail what you are asking for? Thanks!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago

    Hey Sean,

    Have you had any luck with this process? Let us know if you have any questions going forward.

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago


    I'm going to close this case out for now. We are happy to help with any questions you have in the future. You can always start a new thread or reply to this one!

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Nice product and nice team behind it. They helped us with everything we needed in order to get our system working as we wanted to."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.