Re-sync'ing bookings from Myallocator

Hey
We've had to reconnect to booking.com after a change of management, but the amount of time it was offline means that there are a number of bookings which are on booking.com, on Myallocator, but haven't sync'd with Solidres.

Is there a way to do this, so that the missing bookings can be imported easily into Solidres?

Hi,

Please try to contact MyAllocator to see if they can re-send them to Solidres, if they do, those reservations will be added to your site again.

Regards,

Myallocator have replied saying that it's not possible.

I have an excel file of the missing bookings, so have the necessary data available.

If I were to set up a MySQL query, or adapt the excel file in order to insert the data directly into the #_sr_reservations table, would this cause any knock-on issues?

I'm comfortable with MySQL queries, and would base which fields to import according to a previous booking.com record in #_sr_reservations

I don't know if any other tables need to be updated too, specifically if a record is received from booking.com

It would be really helpful if this can be done as we have 120 new bookings to add, plus we have to go through to update any cancelled/amended bookings as well.

Hmmm, the booking csv/xls file download doesn't contain a field for the room type, which means at least part of the process would have to be manual anyway.

It looks like a safer, if slower, bet to do the whole thing manually

Hi,

The actual reservation structure is quite complicated and it is stored in multiple tables, CSV is not a good structure to represent it completely, JSON/XML is better format in this case.

We think you should manually import them from your Excel file in this case.

Regards,

We ended up manually importing and the reservations list is now up-to-date.