Thank you for the information. As a temporary fix I found one method by using cart rule I can provide them 2% discount after increasing the product price.

Dear Team,

If I select the Payment method Credit card/Paypal, in Admin panel 2% Extra amount should be added. Screenshot attached for reference. Please let me know how can we achieve this.

You can set the default status to "Checked In" in the system.
How can I do it in the system. I could not see any option in the system

Dear Faiz, thank you very much. Happy new year !!!

Dear Team,

Please let me know Can we set Default Order Status as "Checked In" and how? Attached image for reference!

Dear Team,

From admin panel booking section how many members can login at a time and book the rooms. One thing observed is if one member booked the room the same room is available for booking for the other user at same time(even its added in the cart).

Ok sure. the thing is I gave new FTP details as old server is gone.

@Faiz I have sent the details

Also, tested with 1000 records database and its working fast. But the database with 8000 record the above search page is slow.

Dear Team, We have one guest house with nearly 250 rooms. While searching perticular this room mysql taking more than 100% CPU usage and page loading slowly take to 7 to 8 seconds. Is there any remedy for this?
Note: Other guesthouse with less rooms working fast

Steps to duplicate the issue.

1. Login to admin area and click on "Book now"
2. Select the From and To date.
3. Select the Guest house name and click on "Search".

server: Ubuntu 18.04
mysql 5.7
PHP 5.6