How can I import bookings into SuperControl?
Booking imports must be carried out by the SuperControl development team. If you want to do a booking import, contact our support team who will quote you a price and arrange to schedule this work for you. Once our developers receive your correctly formatted data they do a test import.
You must ensure all the data is correct before the development team will complete the final import. The process can take time as it relies on you to verify all data is correct before the final import can take place. If any errors are spotted after the final import has happened, additional charges will be incurred.
If you’re new to SuperControl and you want to import bookings into SuperControl then ensure your data is formatted to the specification below:
| Field name | Data type | Notes |
|---|---|---|
| ownerID |
Number |
You can find your owner ID in the top right of your SuperControl account. |
| ownerref |
Number | Your booking numbers. |
| bookingdate |
yyyy-mm-dd |
Date booking placed. If unavailable use arrival date. |
| cottageID |
Number |
The SuperControl property ID (You can view your property ID's in Properties > Edit). Multiple properties can be separated by commas. |
| bookingstartdate |
yyyy-mm-dd |
Arrival date of booking. |
| nights |
Number |
Number of nights. |
| tot_rate |
Number |
Should be the gross price (including any VAT). This should include any refundable deposit. |
| tot_deposit |
Number |
The amount of non-refundable deposit. |
| tot_refundable |
Number |
The amount of refundable deposit. |
| tot_refund |
Number |
Any refunds that have been paid to the customer. |
| dep_paid |
yyyy-mm-dd |
Date deposit paid. |
| bal_paid |
yyyy-mm-dd |
Date balance paid. Note if more than one payment made use the date of last payment. |
| refund_date |
yyyy-mm-dd |
Date when refunds paid. Note if more than one payment made use the date of last payment. |
| vat |
Number |
Note that all figures should be gross. Just add VAT % here. |
| bookingstatus |
Character |
Confirmed / Provisional / Cancelled. |
| adults |
Number |
Number of adults in party. |
| children |
Number |
Number of children in party. |
| infants |
Number |
Number of infants in party. |
| customertitle |
Character |
|
| customerfirstname |
Character |
|
| customerlastname |
Character |
|
| customercompany |
Character |
|
| customeraddress1 |
Character |
|
| customeraddress2 |
Character |
|
| customertown |
Character |
|
| customercounty |
Character |
|
| customerpostcode |
Character |
|
| customercountry |
Two letter ISO country code |
You must use the appropriate "ALPHA 2" ISO country code. Click here to find the correct code. |
| customeremail |
Character |
|
| customertelephone |
Character |
|
| customerfax |
Character |
|
| customermobile |
Character |
|
| customernewsletter |
Booleen 1/0 |
If a person has subscribed to receive mailings enter 1. If they should not receive mailings select 0. |
| sourceID |
Character |
Advertising source. |
| customernotes |
Character |
Appears on booking summary. Do not add private notes. |
| customernotescomments |
Character |
|
| bookingnotes |
Character |
Appears in the booking history. |
| customerrating |
Character |
The columns should match and be listed in the same order as the table above.
The columns must be filled in as much as possible. If a column doesn’t have any data you will need to add a blank space. If there is any vital information missing it may delay the schedule of your import.
0 Comments
How can we make this page better for you?