PHP Script to Sync Salesforce and MailChimp

CLOSED
Bids
22
Avg Bid (USD)
$888
Project Budget (USD)
$250 - $750

Project Description:
I am looking to partner with a talented PHP developer who can write a script which will sync the contact data in our Salesforce database with our MailChimp account. The script should run automatically every night (I will likely add a Cron Job within our cPanel), so that the data is always up-to-date.

Here is a rough outline of how the script should work:

1) Connect to Salesforce via an API

2) Query the contact data which match one of three designated record types (these can be hard-coded)

3) If the "last modified" date of the contact is more recent than the "Last Synced" field (this is a custom field that I will create), the script should transfer that contact information into MailChimp.

4) Once the transfer is complete, the script should update the "Last Synced" field for that contact; nothing will happen to contacts which were not synced

5) The script should send me an email letting me know that the synced was successful. If any errors occurred, the email should mention that.

I am not set on this process -- happy to hear your suggestions!

Something to mention: for each contact, the following information needs to be transferred into MailChimp:

1) First Name
2) Last Name
3) University
4) Status
5) Email Address
6) Grade Level

#3, #4 and #6 are custom fields that I have in Salesforce. Moreover, "University" (#3) is actually a custom object of its own, so when you export it, you just get a series of letters and numbers. In MailChimp, however, I want to see the actual NAME, so the script has to also somehow convert those letters/numbers into the corresponding university name. Think of it as a massive find & replace. Same idea with "Status", which is actually just the record type. I want each record type converted into its corresponding label, e.g. "Active," "Inactive," or "Alumni."

Thank you for your consideration, and I look forward to reading your proposals!

Skills required:
CRM, PHP, Salesforce.com
Hire lukaspleva
Project posted by:
lukaspleva United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 257
in 5 days
$ 263
in 3 days
Hire rajeshsonisl
$ 1030
in 5 days
Hire NishantBamb
$ 631
in 10 days
$ 515
in 10 days
$ 736
in 5 days
$ 6183
in 30 days
$ 600
in 17 days
$ 444
in 7 days
$ 789
in 7 days