I am newbie and I want to syncing the booking data between a hotel booking system in my website (Motopress) with booking.com. The idea behind it: Those two apps syncing through iCal and it will only block the calender without send any customers Info.
What I want to achieve: Only send customer data from booking.com to my website, so I will use the booking system in my website as my control center.
Every 5 Minutes:
Check all the booking in Booking.com and retrieve data from it
Update the customers Info (Input Name,Email, etc) for each room_id in Motopress.
Delete a booking in Motopress if the booking in Booking.com was deleted (canceled)
The answer to your question is not simple, nor quick to execute in a workflow.
On the one hand, the synchronization that you mention through .ics is a limitation of the WordPress Motopress plugin. Actually, Booking.com has a well documented API, and even supports launching different events through webhooks. So a Workflow approach could be:
Configure in booking.com a webhook to trigger the workflow when a new booking occurs, data is updated or the booking is cancelled.
Through the booking.com API and with the booking ID from the webhook, retrieve all the booking and customer data.
Create through the MySQL node the query to create, update or delete the reservation in Motopress. In principle, Motopress stores its data in Custom Post Types, so all the information should be stored, both in the wp_posts table and in the wp_postmeta table.
It is difficult to give a better approximation, since I don’t have access to the booking.com API and I have only been able to see how Motopress works in its demo. Even so, there are some points that you should take into consideration, such as creating a custom field in the booking, as well as in the Motopress client to store the ID corresponding to the booking.com API. Otherwise, it will be more complex to find the fields you need to create, update or delete in the WordPress database.
It is not a complex integration, but it is not a workflow that we can recreate in this forum, precisely because of the lack of access to the applications you want to connect.
I hope that at least, it serves you as a guide when planning your initial workflow.
