Closed

PHP MySQL Email Marketing

We have a WordPress site at [url removed, login to view] (Staging) that list concerts using a custom plugin we built (Event Listing). The data is stored in the typical WP methods.

Next we have a newsletter that we create with Active Campaign, using the download version. NOT THE HOSTED version.

[url removed, login to view]

Each subscriber is coded with a unique field that identifies that city they live in. The concert listings are also coded with a unique field where that concert is. So if concertcode = subscriber code then that email newsletter will get that concert name, city,date.

So what seems like needs to happen is we need to run a script the day before we send the newsletter and populate the concert dates into the email marketing software. Then we send the email out and use the mailmerge fields to populate the newsletter. We have determined there is no way to generate the emails and "go get" the data in real time. That also would slow down the sending process and not meet the delivery goals.

We have a staging server with sample subscriber emails ready to use. Knowing how WordPress stores data would be helpful in copying the concert events to the subscriber file.

We require professional coding and commenting of code. This is NOT a WordPress plugin. That is not needed as this script will be executed and only purpose is to populate newsletter mail merge fields. We have already created the fields in the newsletter table and can give you that information.

So writing the script to populate the subscriber fields from WordPress database is what is required. Please let me know questions.

Skills: HTML, PHP, Software Architecture, WordPress

See more: writing down goals, writing a professional email, ready to go newsletter, php send email script, mysql software download, field marketing, event run down, sending live data, marketing newsletter, help me with marketing campaign, event listing, email sending process, email marketing writing, email marketing server, email marketing php, email marketing list, active campaign, send email php mysql, marketing process, wordpress server slow, php campaign, process marketing, mysql populate table, wordpress email download, mysql help table

About the Employer:
( 166 reviews ) Smyrna, United States

Project ID: #4180191

5 freelancers are bidding on average $270 for this job

toinnisfree

pls chk pmb

$250 USD in 4 days
(544 Reviews)
7.9
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$450 USD in 1 day
(387 Reviews)
6.9
jcodemasters

Please check message

$180 USD in 2 days
(46 Reviews)
5.5
webrevolution

Hello, I can do it. I have very Big email infrastructure to support any volume needs you have. I have sent email campaigns of millions of messages per day. So meeting your requirement will be no problem for me. Just More

$350 USD in 1 day
(1 Review)
1.1
sohelonline

I am interested for this project. I have read all of your requirement and Im confident that I can all these. I have experience on HTML, PHP, Software Architecture, Wordpress Though Im new to this site but worked on o More

$30 USD in 3 days
(10 Reviews)
1.0
partsgr12

Please see PM for my understanding of the job. I am confident of doing this job at reasonable time/rate.

$120 USD in 2 days
(0 Reviews)
0.0
jayjagarnath

please see your pm.

$50 USD in 1 day
(0 Reviews)
0.0