Lighthouse Channel Manager (CM) is hospitality software for hotels to manage their bookings on OTA’s such as booking.com, Expedia and 200+ other booking platforms. The old name of Lighthouse Channel Manager is Cubilis, a product of Stardekk (now part of Lighthouse, which used to be called “OTA Insights”).

This article provides an overview to get started with the Lighthouse Channel Manager (CM) connector in Peliqan. Please contact support if you have any additional questions or remarks.

Remove synced reservations from the queue in Lighthouse CM

Make sure to add the following script to your account, with an hourly schedule, to remove synced reservations from the queue in Lighthouse Channel Manager !

# Run this script with e.g. an hourly schedule.
# It will remove Cubilis synced reservations from the Cubilis "queue".
# So that these reservations will no longer be in the API XML-response.
# Removing from the queue means confirmation of receipt.
# Reservations can be added to the queue again with the "Send to PMS" button in Cubilis (Lighthouse Channel Manager).

cubilis_api = pq.connect('Cubilis')
dbconn = pq.dbconnect(pq.DW_NAME)

bookmark = pq.get_state()
if not bookmark:
    bookmark = '2025-01-01T00:00:00.000000Z'

st.write(f"Removing Cubilis reservations from queue, processed after {bookmark}")

query = f"SELECT id, _sdc_batched_at FROM cubilis.reservations WHERE _sdc_batched_at > '{bookmark}' ORDER BY _sdc_batched_at"
reservations = dbconn.fetch(pq.DW_NAME, query = query)

for reservation in reservations:
    st.write(f"Removing reservation id { reservation['id']} from queue")
    cubilis_api.delete('reservation_from_queue', reservation_id = reservation["id"])
    bookmark = reservation["_sdc_batched_at"]

pq.set_state(bookmark)

Lighthouse Channel Manager (Cubilis)

Remove synced reservations from the queue in Lighthouse CM