Schedule reminder emails based on date field in any new row in a db table

I'd like to schedule emails dynamically, based on a custom date field in pre-existing WooCommerce products.

I was already using the WC Follow-Up Emails plugin, but it was wreaking havoc on my page load times, so I figured it'd be fairly easy to come up with a more lightweight version.

In essence, I just need a trigger to check a field in a table any time a new row is added to the table which then schedules an email for X-days before or after that date (which I should be able to configure either in the db or in the WP admin panel). That's it!

If this is something you'd like to do, I welcome any questions you may have, and I'll be reaching out to any finalists before awarding the project (which helps weed out any auto-bidders who just don't respond, and also helps to make sure everyone's on the same page before finalizing the project).

I look forward to working with you!

P.S. I should clarify that the emails are supposed to be sent to email addresses associated with the new row that's inserted (not to one static email address), so an additional query would be needed in order to retrieve that.

Also, as an example, whenever there is a new row inserted into the 'reservations' table, there will also be a wp_rg_lead_id field, and then when your code queries the wp_rg_lead table with that ID number, it will provide a reservation date and email address.

And then I would need to be able to configured ahead of time (either in the code, in the db, or in an admin panel) how many days before and after the reservation date particular emails are sent. There would probably be one or two reminder emails scheduled before the reservation date and one thank-you email schedule after each reservation.

Oh, it's also worth mentioning that I will need to send emails with different text depending on an ID number in the row, so it wouldn't be just one email for all.

Keahlian: MySQL, PHP, WordPress

Lihat lebih lanjut: coldfusion table field, php save current date table field, javascript alternative row color table using classname, database development, woocoomerce, cross browser page alternative row color table, oscommerce table field editor, used products_quantity row products table oscommerce, button generate random letters table field access, date reminder software, php loop table field type, wordpress sort custom field date

Tentang Pemberi kerja:
( 22 ulasan ) Lagrange, United States

ID Proyek: #11720364

8 freelancer menawar dengan rata-rata $69 untuk pekerjaan ini


Hello Sir, I have rich experience in WordPress/MySQL. I have gone through the details specification of the project, I can do this project as I have rich experience in PHP/MySQL expertise since 5+ years and I have do Lebih banyak

$50 USD dalam 1 hari
(81 Ulasan)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Lo Lebih banyak

$77 USD dalam 1 hari
(152 Ulasan)

Hi, We are an experienced and dynamic team of designers/ programmers, expertise in php, wordpress, Html,xHTML, javascript, jQuery (average years of experience of 10 years) and we work independently, efficiently, and Lebih banyak

$111 USD dalam 1 hari
(44 Ulasan)

Hi , I have good experience with WOOCOMMERCE CUSTOMIZATION TASKS. Further I am very much interested to work in your project. I am WOOCOMMERCE , WORDPRESS PLUGIN , WORDPRESS, PHP programmer with more than 4 years Lebih banyak

$55 USD dalam 1 hari
(67 Ulasan)

Hi there - My name is Jhalak. I’ve read your [login to view URL] team has 4 years experience designing and developing mobile apps and Websites.I would approach your project by starting with wireframes and getting the site complet Lebih banyak

$25 USD dalam 1 hari
(96 Ulasan)

How are you? I hope all is well with you. I have checked your project description in carefully, and understood what you want. I have deep passion for and fully experienced in Wordpress. If you kindly give me a ch Lebih banyak

$200 USD dalam 3 hari
(9 Ulasan)

Good day! Ready to work! We can create such script which will email you when a new row are added. We are the team of professional web developers. You can find information about us and our works here: http://foride Lebih banyak

$25 USD dalam 1 hari
(1 Ulasan)

Hello sir, Hope you are doing Well ! :) We are expert in WordPress and We have done this before, So We can help you by implementing the functionality of reminder email as you require. At votiko, we have a prof Lebih banyak

$10 USD dalam 1 hari
(1 Ulasan)