Mailchimp will often ping Sugar with activities such as subscribes, bounces, and unsubscribes. If your SugarCRM instance is not publicly available outside your network this will cause Mailchimp to not be able to keep your data up to date in Sugar.
To resolve this while also keeping your data as locked down as possible, we have created a convenient proxy script for your use. Use the 3 steps below to put it into place:
1. Use the code below and make it accessible from outside your network.
**NOTE: Be sure to change the $sugar_url variable in this script**
2. Add this script as a new webhook for each list that syncs to your CRM. (Detailed instructions on how to do that are here.) Be sure to include the request parameters in the webhook url so that the script will forward the data over to SugarCRM. Your webhook should look something like this:
3. Update the 'reverse_proxy' config using the query below:
UPDATE config SET value='https://your-CRM-endpoint' WHERE name='reverse_proxy' AND category='sugarchimp';
Note: If you do not currently have a 'reverse_proxy' config, you can add the name, category, and value with the following:
INSERT INTO config (`category`,`name`,`value`) values ('sugarchimp','reverse_proxy','https://your-CRM-endpoint');