Ditutup

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, 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 pada rata-rata $69 untuk pekerjaan ini

harish1984

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 Lagi

$50 USD dalam 1 hari
(81 Ulasan)
6.3
VnBestSolutions

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 Lagi

$77 USD dalam 1 hari
(152 Ulasan)
6.6
itsoftwarelab

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 Lagi

$111 USD dalam 1 hari
(44 Ulasan)
5.6
richestuser

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 Lagi

$55 USD dalam 1 hari
(67 Ulasan)
5.7
yogeshssanwal

Hi there - My name is Jhalak. I’ve read your [url removed, login to view] 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 Lagi

$25 USD dalam 1 hari
(96 Ulasan)
5.7
darshring

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 Lagi

$200 USD dalam 3 hari
(9 Ulasan)
4.4
foridev

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 Lagi

$25 USD dalam 1 hari
(1 Ulasan)
1.4
VOTIKO

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 Lagi

$10 USD dalam 1 hari
(1 Ulasan)
0.0