Find more Web Development Remote Jobs posted recently Worldwide

Required Database,sql,Stripe freelancer for Develop simple web app to register guests at a hotel job

Posted at - Nov 26, 2020

Toogit Instant Connect Enabled


We would like to set up a webapp that would guide a guest through the guest registration process at a hotel.

APIs available and to use :
- Hostaway API for pulling customer information and phone number
- RingCentral or Twilio API to send text messages
- Stripe API to collect payment information

If you remember the last time you checked into a hotel, a clerk takes your ID, verifies its you, asks for a credit card, puts a hold on it for incidentals, and gives you your key. End to end we want to automate this process through a webapp.

The process would look something like this:

-> booking confirmation -> text message to guest with link -> agree to terms and conditions -> submit picture of photo ID -> submit selfie -> enter credit card detail -> card is pre-authorized for hold amount -> phone number sent to Keycafe or August to give customer access to keys -> confirmation text sent to customer that verification process is

Upon booking - or 3 days before check-in, whichever comes last-, customer receives an automated text message asking him/her to fill out the pre-registration form.

The text message fields can be auto-generated from the phone number on file, grabbed by Hostaway.

If no number is on file, an email is automatically sent to the team to notify us that "no phone number is present on reservation". This scenario is extremely rare - it would mean that a customer created an account on Expedia/Airbnb/Booking with a phone number that they then removed (a number is required at account creation). Rare, but possible.

The text message link should forward to a link on the apple theory

The guest will then be asked to accept terms and conditions (simple checkbox with type your name field)

Next page will prompt the guest to upload a photo of their picture ID.

Next page will prompt the guest to upload a selfie.

Next page will ask guests to entire a credit card number, with customer name, card number, billing address and cvv. The information should be sent over to Stripe using the Stripe API (the page itself can just be an implantation of a Stripe payment processing). The page should include a required checkbox agreeing to place a $500 hold that will be released at check out. The page should also include a second check box

An automatic hold for $500 should be placed on the card. In the event that there is insufficient funds for $500, a hold for $250 should be placed. In the event there is insufficient funds for $250, an error message should be sent "We were not able to process a hold your card due to insufficient funds. Please try again later. You will not be able to check-in without completing this pre-registration process."

In the event that the guest has not filled out this information 24 hours prior to check-in, a reminder text message is sent 24 hours before check-in. Another reminder is sent 12 hours prior to check-in, and 3 hours prior to check-in.

The selfie, picture ID, and result of the hold should be accessible in a simple table available online (SQL server?). Note : Each property should have an independent sub-site, We want to be able to give the property owner access to the information collected, without needing to give the information to all property owners.

|Guest first | Guest last | picture ID (link) | selfie (link) | Name on card | Hold ? (Yes/No)

About the recuiterMember since May 20, 2018 Rory Millikin
from Polva, Estonia

Skills & Expertise Required

Database sql Stripe 

Candidate shortlisted and hiredHiring open till - Dec 17, 2020

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$347.22
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Web Development category.


Related Jobs


Latest In Database Jobs


Latest In sql Jobs


Latest In Stripe Jobs