Closed

PHP Script to Sync Salesforce and MailChimp

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: CRM, PHP, Salesforce.com

See more: salesforce api php, php sync mailchimp, salesforce php, php salesforce, your account is inactive, this account is inactive, salesforce status, salesforce one, salesforce developer work, salesforce developer job, salesforce developer 1, php developer information, php developer first job, php developer find, php developer contacts, look for script developer, job salesforce developer, i want to know how to write, inactive email account, idea salesforce, how to write a thank you email, how to get a developer job, how to find salesforce developer, how to find developer partner, how to find developer job

About the Employer:
( 1 review ) Chicago, United States

Project ID: #5035627

19 freelancers are bidding on average $635 for this job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$257 USD in 5 days
(236 Reviews)
7.8
sureshdevi

I can create script to extract salesforce customer information with their custom fields data and store it in MailChimp, you can make this script to run through cron job. I will complete this work in 3 days. I will b More

$263 USD in 3 days
(627 Reviews)
7.4
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$1030 USD in 5 days
(436 Reviews)
7.2
NishantBamb

Hello, Already have experience of integrating MailChimp, can surely complete your work within 7-10 days for $600. I hope you have Enterprise or Unlimited edition? I own a company in India and we are authorized Salesfor More

$631 USD in 10 days
(77 Reviews)
7.0
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(154 Reviews)
6.8
vocsowebstudio

Dear Client, I've read your description and get an idea about your requirement. You have a Mail-chimp account. Now Yo wants a Script in PHP which runs automatically every night. - Connect to Sales-force via an API. More

$736 USD in 5 days
(9 Reviews)
6.5
dinastalb

Hello, I am John Profit. I work with my partners Marlen and Van at Netronian Inc., in Orlando, Florida. We have great experience with Magento. 80% of our developed websites are Magento websites. We are the masters More

$6183 USD in 30 days
(12 Reviews)
5.9
bistanil98

Can we discuss this in detail before start this project,to know more about us please check in Private Message. We have a team of professionals,they have more than 11 year of experience,so we can manage this work and More

$600 USD in 17 days
(16 Reviews)
5.5
sourov06

Hi, I am a professional web developer.I worked in a software [url removed, login to view] I have left the job and start as a fulltime freelancer. I am an expert in php.I am expert in mailchimp.I have doing several projects of More

$444 USD in 7 days
(26 Reviews)
5.4
Champian

Let Champian handle this for you. Hi, I am working as a freelancer website designer and developer, I have 5+ years of experience in design and programming joomla, PHP, Wordpress. Here is my profile on Joomlancer More

$789 USD in 7 days
(23 Reviews)
5.3
yurybondarau

I am certified salesforce developer and also have an experience in PHP. I have done the similar work (integration between salesforce and php using salesforce web services) many times.

$444 USD in 14 days
(12 Reviews)
5.2
Reflexlogic

Hello, I have reviewed your requirement completely & have a question. As you informed that we need to contact sales force through API & fetch the records. Do you have access of mailchimp database so that I can More

$463 USD in 10 days
(16 Reviews)
5.1
bluecoded

Hello, We have gone through your [url removed, login to view] you have any time frame for the project?Can we have a discussion? We are a team of 77 people with 4 years of [url removed, login to view] are very good in mobile application develo More

$2061 USD in 25 days
(5 Reviews)
4.9
murtaza1122

Respected Employer, I am a salesforce certified [url removed, login to view] developer. and in my professional career of 2 years i have also been working on both areas business (workflows, assignment rules, lead management etc) an More

$600 USD in 15 days
(9 Reviews)
4.5
VRWebSolutions

VRZ Solutions prides itself for being instrumental in developing global Internet based presence for many small and large businesses. The teams of professionals at the helm of affairs in our company have already c More

$360 USD in 16 days
(2 Reviews)
4.0
jkhantwal

Hi, I have looked at your problem statement and I have a solution with out writing any PHP script. My proposal is to write everything in SalesForce. Would that work for you? If it would work for you then I can sh More

$555 USD in 2 days
(3 Reviews)
4.0
webdevit

php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysq More

$515 USD in 5 days
(5 Reviews)
2.5
blisstech

Warm greetings from Blisslogix Technology solutions Pvt Ltd! I'm Ramya Subramanian, IT SalesHead - Enterprise Mobility & Salesforce Solutions,Blisslogix Technology Solutions Pvt [url removed, login to view] is a 100+ strong IT s More

$555 USD in 3 days
(1 Review)
2.0
getwaysolution

Hi , I am having an Expertise and Hand on Experience in PHP Development .. I would like to work on your project and really interested too. Please find some of the samples worked on & Completed Successfully. More

$736 USD in 15 days
(1 Review)
0.0
getveltrod12

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$515 USD in 20 days
(1 Review)
0.0