Upselling and percentages

Hi @Thor, 

I don't think you'll be able to achieve this in Mews natively, you could use the API to export,store & report on some of the data however last time i checked, the employee ID is not provided with the output via the API. 

I don't have any other ideas, perhaps someone else does. 

Hi @Mick 
Thanks for the reply! 🙂
I’ll be sure to do some more digging then. I was hoping not to go through the marketplace as we did manage to get this data in our previous PMS, regardless of how manual that task was.

Good Morning @Thor and @Mick,

I think there is currently no “easy export” available for this.
However, maybe the posting journal can work?

Unfortunately, I cannot think of any other report either.

Hello @Thor,

as @Mick and @MatthiasH said, there is no easy solution at the moment.

For now you can look into the Oaky integration as they have the reporting required for upsell. Once we have full Upsell in Mews then we'll have reporting, but this will still take some time!

Another idea, could you use the action log filtered by employee and the action (space change & re price) to see the upsells that employee did? 

Thank you!

Hi all,

We also use the posting journal and filter for the product and then for the staff.

Unfortunately the action log cannot be exported otherwise we would love to use this report for many functions.  

Hi Thor, 

Could the detailed accounting report not be used for this info?

From what I understand of your original question, the employee adds a product to the reservation and they get a reward which is a percentage of that amount.

In the exported accounting report you will have the name of the creator in column J (the one who added the product) and the net value in column W.

Let me know if I misunderstood the situation

Hello all,

there is a feature request about the export of action log, please make sure to vote for it! 😎

Have a great day!

Hello everyone.
Thanks for the great feedback! 😎 

@MatthiasH 
It seems as if the exported accounting report is the way to go, as @coline.poussiere mentioned, with the creator being labelled in column J. 

@MarketaOupi 
I’ll learn more about the action log to see if I can proceed. We have Oaky at one of the properties I worked at before my current position, but I am almost certain this is optional for each hotel. Working on the prior system, I saw that the complexity of integrating a third-party service as Oaky proves inconvenient for the data we want.

From what I understand now, I need to create a service product for each category;
Upsell / late checkout / early check-in etc. 
And then extract that from the accounting report or possibly the action log. If possible to export, of course. And then have it cleaned and connected to a dashboard in either PowerBI or Tableau.

@MatthiasH 
How could I miss that,
That’s exactly what I am looking for!
 

Above is the export and how it looks if anyone is interested.
Thanks a lot for the help, this is fantastic and simple source data to use for exporting 🤓

Happy to see the possibility to export the Posting Journal is what you were looking for. It is indeed possible to use if the creation date is what is important, rather than the consumption one.