Bulk rate uploader
-
- Posts: 25
- Joined: Sun Jan 12, 2014 8:35 pm
The ability to updates rates in a bulk format would be amazing and save a ton of time.
-
- Site Admin
- Posts: 935
- Joined: Fri Mar 02, 2012 1:43 pm
There are functions to upload and download rates using csv files at api.beds24.com
You can edit these files in a spreadsheet and upload them.
You can edit these files in a spreadsheet and upload them.
The comma character is used as the decimal separator here (and in quite a few other countries I believe). Is there a way I can select semicolon as the field delimiter in the CSV files?
I see now that "putRoomDaily CSV" has an option to select semicolon separators; but "getRoomDaily CSV" does not.
I see now that "putRoomDaily CSV" has an option to select semicolon separators; but "getRoomDaily CSV" does not.
-
- Site Admin
- Posts: 935
- Joined: Fri Mar 02, 2012 1:43 pm
putRoomDaily will still need the numbers to be defined with decimal points, not a decimal comma even if the separator is a semi-colon.
If you cannot change your spreadsheet locale to use decimal points, one solution is to open the csv file in a text editor (that does not add formatting) and do a "replace all" to change all comma's to full stops.
If you cannot change your spreadsheet locale to use decimal points, one solution is to open the csv file in a text editor (that does not add formatting) and do a "replace all" to change all comma's to full stops.
-
- Posts: 123
- Joined: Thu Jun 18, 2015 6:27 pm
yes the function to update multiple rates at the same time is a "must".
You have to add it under the Rate tab.
For example I have lots of rates (around 90 for all properties)
When you added a new channel on Chanel list. This channel is automatically added to all rates.
Now I have to go into each rate one by one and deactivate the channel for certain rates (that I dont want to be sent to specific channel).
It is a long process and it is very difficult to navigate trough all that rates that are on the same list.
You have to add it under the Rate tab.
For example I have lots of rates (around 90 for all properties)
When you added a new channel on Chanel list. This channel is automatically added to all rates.
Now I have to go into each rate one by one and deactivate the channel for certain rates (that I dont want to be sent to specific channel).
It is a long process and it is very difficult to navigate trough all that rates that are on the same list.
-
- Site Admin
- Posts: 935
- Joined: Fri Mar 02, 2012 1:43 pm
When we connect to new channels we do default the rates to be sent to that channel. But unless you actually connect to the new channel it makes no difference.zagrebpoint wrote: When you added a new channel on Chanel list. This channel is automatically added to all rates.
Now I have to go into each rate one by one and deactivate the channel for certain rates (that I dont want to be sent to specific channel).
It is a long process and it is very difficult to navigate trough all that rates that are on the same list.
-
- Posts: 123
- Joined: Thu Jun 18, 2015 6:27 pm
I know.
But if I do connect to the channel I have to deactivate all rates that I don't want to be sent to that channel.
For example, I want to connect to Homeaway now and when I do, I will have to click on every rate that I don't want to send to HomeAway.
žIt is a lot of work and clicking and I don't think that it is so hard for you to make some Bulk rate functions.
But if I do connect to the channel I have to deactivate all rates that I don't want to be sent to that channel.
For example, I want to connect to Homeaway now and when I do, I will have to click on every rate that I don't want to send to HomeAway.
žIt is a lot of work and clicking and I don't think that it is so hard for you to make some Bulk rate functions.