Import data into VikBooking

  • Resolved chill4

    (@chill4)


    10 months, 3 weeks ago

    Dear VikBooking Team!

    We are working on setting up VikBooking and we are looking forward to a new era for our London hostel. My question today: I have an Excel with “Check-In date”, “Check out date”, “Guest name”, “Room number”. I could provide other fields if needed.

    Can I somehow import this into the database? If we make the shift from our old (terrible) booking system, we need to have the already made bookings for the forthcoming 12 months inside of VikBooking.

    If this is not possible, is that something that can be done by you? We would happily pay for that favor because doing this manually would cost us…. a lot of time.

    Cordially,

    Andrej

    • This topic was modified 10 months, 3 weeks ago by chill4.
    • This topic was modified 10 months, 3 weeks ago by chill4.
Viewing 1 replies (of 1 total)
  • Plugin Author e4jvikwp

    (@e4jvikwp)

    10 months, 2 weeks ago

    Hello Andrej,

    Thanks for your message. We understand the situation, but unfortunately it is not possible to import bookings into the database from an Excel list. This is because there is no parsing system available, and then the IDs of your listings should be somehow mapped.

    Ideally, the best solution to import bookings is through the Channel Manager, but of course this requires the Pro/commercial version of VikBooking, our complementary plugin Vik Channel Manager, and an active E4jConnect subscription for at least one API channel, like Booking dot com, Airbnb, Hostelworld etc.. The Channel Manager could download via API your active bookings and import them into your website with VikBooking. Alternatively, if the bookings you need to import do not come from OTAs, then the iCal protocol could be used to import them, but reservations would need to be available on remote calendar URLs, whether they are Google Calendar URLs, Apple Calendar URLs, or third-party URLs.

    Instead, if the Excel list is the only solution for you, then a PHP script is probably required to build and execute the necessary database queries to import the reservations in VikBooking.

    If you are using our full solution (VikBooking + E4jConnect Channel Manager), then I guess you can try to contact our team through our websites so that we can see if we are available for building a one-time script in PHP that reads the booking details from an Excel file (better if it’s a CSV file, but exporting Excel files to CSV should not be a problem) to import them into your website database with VikBooking.

    The VikWP Team

Viewing 1 replies (of 1 total)

The topic ‘Import data into VikBooking’ is closed to new replies.