by Fanatical Labs

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.

Free Trial

By clicking you consent to share your profile with the developer

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

Closed General Question created by SeanHill 8 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

    8 years ago

    Hey,

    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

    8 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

    8 years ago

    Hey,

    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...
Rating
Rating
  • "SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"

    Read More Reviews