Free and Premium WordPress Plugins & Themes Forums WordPress Plugins Hotel Booking Is there a way to bulk import rates?
- This topic has 22 replies, 12 voices, and was last updated 3 months, 2 weeks ago by Susan B.
- February 16, 2021 at 1:32 pm #1075494[email protected]Participant
Is there a way to bulk import rates or manipulate the rates through an API or even PHP/Wordpress functions?
Basically the situation is we have a separate channel manager system we use to manage bookings on Expedia and others. When we make pricing updates we’d like everything to match and not have to manually update Hotel Booking rates through the WordPress interface.
It would also give me the ability to make my own dynamic rates, or even program last minute deals automatically if I’m able to change the rates in Hotel Booking.
Thank you!February 16, 2021 at 11:59 pm #1075769Andre FloresModerator
Unfortunately, there is no such option in the Hotel Booking plugin. We do have a similar feature request and I have added you up-vote to it. Currently we are collecting a feedback from our users regarding this matter and in case there are more requests, we might consider adding this feature in one of the plugin future updates.
AndreFebruary 25, 2021 at 10:56 am #1080658S. Siroco-Gemelos22ParticipantThis reply has been marked as private.March 14, 2021 at 12:37 am #1089284Parede FlatsParticipant
Rate setup Motopress
Bom dia Andre,
to setup a rate to accommodate the different possibilities and seasons requires a long process. It is admin intensive and to maintain is the other side.
I think Mogopress should re-think the way rates are added mainly for extra guests.
I think the rate for extra guests as a one off fee per extra guest taking in consideration if you want to include children for this calculation or not.
THis happens with other booking systems and it makes it much more easy to manage. See example below from one of you competitors:March 15, 2021 at 1:41 am #1089694Andre FloresModerator
Thank you for your suggestion, it is much appreciated. We might take it into consideration for future plugin updates.
AndreMarch 16, 2021 at 11:39 pm #1091046Martin FourdrignierParticipant
I found this topic as I was just about to open one on this point. You can count me as an upvote Andre, but I am surprised not to be able to edit this directly in the SQL database or in MPHB files. Where are the rates data stored?
Because I don’t care if it is not user-friendly and if I have to go edit the SQL database directly, as long as I avoid filling 7 seasons for 80 properties… It’ll take ages.
Many thanksMarch 18, 2021 at 1:16 am #1091716Andre FloresModerator
Thank you for your up-vote, it has been counted.
The Rates appear to be a custom post type, so they are stored in the the wp_options table.
Basically, the plugin was not built to have an ability to export/import rates.
AndreMarch 25, 2021 at 10:45 pm #1095566Parede FlatsParticipant
from @Martin’s suggestion, I wouldnt mind to edit from SQL as well.
I have actually tried it! hOwever found it so complex to edit and mirror or adapt to other rooms
I only have to fill 3 properties (80 properties is a no end job!! )
Thank youMarch 26, 2021 at 12:04 am #1095575Kris KjerrumgaardParticipant
Here is another upvote. Bulk edit or an import/export function is really needed.
Thank you in advance!March 29, 2021 at 11:31 pm #1097245Andre FloresModerator
Thank you for your up-vote, it has been counted as well.
AndreSeptember 21, 2021 at 2:35 am #1188668Anthony RiadParticipant
I’d like to add to that.
If there is no way to import or sync, then can we build formulas in the rate variations section?
So for example:
If a room is set for 2 adults and 2 children as the top rate, and the variations then are 1-0, 2-0, 1-1, 1-2, 2-2. Having this amount of variation for every season for 15 room types for 200+ rooms can be a very tedious task, especially when you want to control your rates and do revenue management.
So my suggestion is that if you can’t import or sync, then why not only fill the top rate (2-2) and put a value for a single room (75%) and a triple room (140%) and a child rate (50% of the adult rate) for example and have admins be able to modify those levers to avoid having to also type in each variation after having to calculate it in a massive excel sheet.
Would love to hear your thoughts on this.
A. RiadSeptember 24, 2021 at 1:59 am #1190339Andre FloresModerator
Thank you for your suggestion, we will definitely take it into consideration and I will make sure to pass this information for further investigation to our developers. They might use this information for future reference when decide to perform changes to the way rates are calculated.
AndreNovember 18, 2021 at 5:26 am #1216357Gundula UrayParticipant
UPVOTE please – as Anthony says this is NOT NMAINTANABLE while it is a standard feature on all booking sites (airbnb, booking.com etc)
example and potential way to make it at least a slightly easier:
Pleae into a “0 to X” amount of children. example:
Current MOTOPRESS implementation: an apartment/chalet/hut that can take up to 10 guestst I have to enter EACH of these variations here an example for 5 Adults :
ADULTS | CHILDREN
This is just ONE singele variation!! I have to repeat the same with even more variations for Adults 1 and adults 2 and adults 3 and adults 4 and adults 6 and adults 7 and adults 8 and adults 10. I have 6 seasons in total with Winter peak/ winter non peak / summer peak / summer non peak / spring / autumn so you have to multiply that by 6!!
Dear MOTOPRESS Team this is not maintanable!
Please intro a field where I can enter
ADULTS | Children
This is a STANDARD feature on all booking sites like airbnb, booking.com etc etc…..
Please consider this as a MUST HAVE have.
PeterNovember 23, 2021 at 4:39 am #1218805Andre FloresModerator
Thank you for your feedback, it is much appreciated.
AndreJune 16, 2022 at 4:43 am #1318284Sylvain DeschampsParticipant
It’s been more than a year and upvoted many times, is there an update on this feature….?
- You must be logged in to reply to this topic.