What you can do here
To manage your bookings that are currently not on the PayDocker website, you can upload your offline bookings via a CSV file. We highly recommend proceeding only if you have imported and mapped the property, so that our system can recognise the bookings.
Here are the key functions we will be covering in this article:
- Retrieving CSV template
- Understanding the CSV file
- Validate or Edit uploaded Bookings
- Mirrored bookings
You can also automate part of this process OR Synchronise your bookings automatically through API
How to access
1. Click Import (1), then Bookings (2)
2. Click Import (1) again, and download the CSV template (2).
Once completed, click Import CSV (3) to upload your file onto our system.
Understanding the CSV file
We will break down the CSV into a few sections to try and understand what they mean.
- Part 1: Reservation reference and buyers/properties involved
- Part 2: Reservation information and rates
Part 1: Reservation reference and buyers/properties involved
Here's a quick rundown of all the headers:
| Header | Description |
| Booking ID |
|
| Booking Date |
|
| Category |
|
|
Buyer ID (Optional if you are the buyer) |
|
| Property ID |
|
| Property Name |
|
| Property Country |
|
| Property Email |
|
Part 2: Reservation information and rates
| Header | Description |
| Guest Count |
|
| Room Count | |
| Check-in |
|
| Check-out |
|
| Currency |
|
| Booking Amount |
|
|
Dynamic Percentage (Optional, only if you have variable commission rates) |
|
|
Dynamic Value (Optional, only if you have fixed commission rates) | |
|
Non Refundable Amount (Of the total booking amount) |
|
|
Refundable Amount (Of the total booking amount) |
|
| Cancellation Days |
|
|
FirstNight Amount (Only if If Refundable amount is more than 0) |
|
Validate or Edit uploaded Bookings
Once bookings have been successfully uploaded, you will need to check and validate each booking's details.
During this process, if the booking details are incorrect, you can also edit them. Validated bookings cannot be edited anymore.
How to configure
1. Click on Transactions
2. Click on the icons in Action (1) to view details picked up via our system. If the information is correct, select the respective bookings via the check box (2) and click Validate (3).
Once you have successfully validated the bookings, there will be 1 of 2 results:
1. Eligible transactions
Your imported bookings are confirmed.
2. Uneligible transactions
Uneligible transactions are those that cannot be processed because certain information cannot be synced with the system's configuration.
How to handle errors
Reason for the ineligibility
For bookings that are 'ineligible', there will be a reason for the ineligibility.
Here is what you should do when you see these errors:
| Errors | Reason |
| Unknown ID | ID does not match what is available on our system |
| Balance | There is no balance for the currency OR there is insufficient balances |
How to move ineligible bookings to eligible
Once you have fixed all errors, you can click on the refresh button to reload this process. If all errors are rectified, the booking will move from ineligible to eligible.
Mirroring for bookings
Booking mirroring is an option when there's a 3-way cooperation in a single booking flow. Mirroring reduces the need for duplicated work to happen between the 3 parties for the same booking.
Mirroring would be especially helpful in situations where an agency pays the hotel upfront for a bulk block of rooms (at a discount) and sells them to buyers individually. With booking mirroring, the supplier would not need to duplicate the source transaction (Between hotel & supplier) for all the buyers.
Any booking changes for the source transaction would also be reflected for the mirrored transaction.
For mirroring to happen successfully, these are the important points you should take note of:
- All 3 parties are available on PayDocker
- Bookings from the source transaction is validated on PayDocker
- Mirroring has been enabled in the supplier's account.
- There is an existing partnership (Smart contract) between buyer & supplier
When the mirroring has been successfully activated for this booking, it would create an exact set of booking details (that the supplier has bought from the hotel). The bookings created will be tagged Mirror in orange.
Transactions that failed to mirror successfully would fall into the Uneligible section.
Enable Mirroring automation
1. Go to Settings > Automation > Data Import
Under Mirroring, select configure booking mirroring automation
Synchronise your bookings automatically
To synchronise your online bookings automatically on PayDocker you will need to set up either of these triggers depending on your connectivity with our other products.
1. Click Direct (1) and Push (2)
By setting this up, new, modified or cancelled bookings that will be pushed directly into your dashboard through our Booking API. These bookings will be tagged as Direct and source tagged as API in the booking details.
Once your bookings have been successfully uploaded, please follow the above steps to Validate or Edit uploaded Bookings.
If you are connected to RateDock and would like to synchronise your bookings with RateDock, please follow these steps to set up your API:
2. Click RateDock (1) and Push (2)
By setting this up, new, modified or cancelled bookings on RateDock that will be pushed directly into your dashboard through our Booking API. These bookings will be tagged as Direct and source tagged as API in the booking details.
Once your bookings have been successfully uploaded, please follow the above steps to Validate or Edit uploaded Bookings.