In Progress

Parse emails and update database via API + PHP

We use a reservation system to manage a car rental business.

We receive a lot of email confirmations from several websites, and until now we need to manually add the new customer data and the reservation/booking one by one.

We need a PHP code that read the emails from a pop3 account and parse/read the content and add the customer data to the customers table (if customer does not exist). Then add the reservation to the system. The current reservation system provides a clear API that will be used.

In case of any failure to add customers or to add the reservations/bookings for any reason, an email must be sent to the appropiate address to inform about the issue for manual addition and later script fixing.

The script must be done in PHP and runs via a cron in one of our servers. Must be coded in a strong and clear modular way, with clear functions/procedures and further easy to modify and add new reservation sites.

This is the API doc:

[login to view URL]

Work must be done in 1 week


Emails come from several websites where final customers book cars (named OTAs) like All emails with booking information from same website/OTA have same format. It is necessary to parse the email to obtain the most data as possible: driver name, phone, email, pick up date, drop off date, car type....

It is necessary a table for OTAs: OTA name, email, commission, subject in email, km/day

First step is to check if driver exists. If not, must be added. If yes, create the reservation for the client. It seems it is possible to create driver and booking in one shot with /car-rental/reservations/confirm (see API)

To create a reservation it is not trivial, since sometimes customer request extras like additional km, or child seats that must be added. May be a table will be needed here to connect text in the email with a extra in the API

The requested car model name not always has exact correspondence, We need a table with text file with 2 fields: car model as indicated in the email and car model code in our booking system. For example: "C3 Aircross" and "22" being 22 the car model code in our reservation system.

Some times the client cancels the reservation, then we must be able to cancel it (client can remain): /car-rental​/reservations​/{reservation_id}​/cancelled in API. There is a field with OTA reservation code. Then it is necessary to retrieve the reservation_id by searching by the OTA reservation code. If a OTA reservation code is not present, then we must locate the reservation for such client with same dates.

When a new OTA appear, must be easy to add a new one, and script must warn via email if unable to process an email due to unknown OTA or unknown format.

A lot of emails regarding a reservation are sent, then only the email with specific subject must be processed for each OTA (OTAs send a lot of emails, not only reservations, but we must to process only the email with bookings and with bookings cancelations.

We can start with 4 milestones: 1) Setup tables and 1 OTAs and read emails+assign fields to vars inside PHP. 2) Use API to create customers/bookings and cancel bookings 3) Setup the rest of OTAs 4) Final tests

Mysql database that can be maintained via phpmyadmin in first version (we will need future improvements, OTA adding...) that will be covered in next project.

For example a future improvement will be to send an SMS+email to the customer via smtp and twilio API with some instructions to the customer (arrival instructions, create a form to request data to complete the customer data to avoid loosing time in the office). Now customers come to the office and our employees and they lost time requesting more data that the OTAs do not collect. We can send an SMS/email with a link to a form in our server to fill the customer data that is left blank by the OTA.

Skills: PHP, MySQL, Software Architecture, HTML, Linux

See more: update database php, use database multiple php scripts, php message board reply update database, update database closed php, php script sample car rental, code update database mysql php, parse xml response file api php, update database email php, update database hour php, update database mysql php, php update database api, agemni database api php, api rest php update database, can update database onclick php, parse emails to database

About the Employer:
( 39 reviews ) Valencia, Spain

Project ID: #31857486

Awarded to:

(45 Reviews)

57 freelancers are bidding on average $535 for this job

(379 Reviews)
(522 Reviews)
(252 Reviews)
(258 Reviews)

Hello, Warm Greetings!!   I read your job description completely and I found my skills relevant to your project. I am a professional web developer with 5 years of programming experience for a multitude of different t More

$500 USD in 7 days
(84 Reviews)
(183 Reviews)

I can set up a PHP script to receive emails and extract the information. Then put it into your system using the API. My average project completion time is within 3-5 hours on the same day. The skills I have include PHP More

$500 USD in 1 day
(268 Reviews)
(164 Reviews)

Hello! I Hope you are doing well! I have read your project carefully , can you please come in chat box to discuss the project i am available and ready to start the project I am good at : - Custom PHP, Laravel,NodeJ More

$340 USD in 7 days
(91 Reviews)

Hi I AM READY TO START NOW I read through the job details carefully and I am absolutely sure that we can do the project very well. In a nutshell, I'm a freelancer with more than 7 years of work experience. in BOTH More

$550 USD in 7 days
(117 Reviews)

Hi There, I am experienced in such custom made services and working since last 7 years please allow me to work on this and i can easily deliver this project within time and cost. I am available and can start working More

$490 USD in 5 days
(112 Reviews)
(32 Reviews)

✔️ Hey There, I already worked on similar projects to this one and I assure you 100% what you are looking for.✔️ I am working as a Wordpress expert for last 5 years so I assure you a satisfied job and on time completio More

$250 USD in 5 days
(117 Reviews)

Hi, I will develop the php application that can be run by cron. The application will read the emails using pop3. It will add customer data to the customer table in the database and will add the reservation by using the More

$750 USD in 15 days
(46 Reviews)

+++++++++++++++++++++++++++++++++++ Hello There, Hope you are doing well I have checked about your requirements and my skills are a match.  I have relevant 5+ years of expertise in website development, mobile devel More

$500 USD in 7 days
(30 Reviews)

Hi. Hope you are doing well. I have high level expertise in PHP. I have done a similar email in the past where I read the emails from POP3 account and parsed it and then blocked that user email accordingly. This seems More

$250 USD in 3 days
(117 Reviews)

I am expert in php and mail handling using php code. Here is my proposal for this project: 1. I will develop a code using php that will parse the mails using pop3. 2. It will check all unread mails and check for reser More

$600 USD in 2 days
(137 Reviews)
(10 Reviews)
(46 Reviews)

Hello Employer, Based on your requirements, I am available and ready to start working with you and complete all of your work-related to PHP, Laravel, JS, HTML 5, bootstrap, and I have Graphic, UI/UX design skills. I More

$750 USD in 7 days
(25 Reviews)