My simple BRG tool

    Hide Wikipost
Old Aug 24, 16, 1:53 am   -   Wikipost
Please read: This is a community-maintained wiki post containing the most important information from this thread. You may edit the Wiki once you have been on FT for 90 days and have made 90 posts.
 
Last edit by: d'Yquem
Wiki Link
Print Wikipost

 
Old Jul 23, 16, 2:08 am
  #106  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by helvetic View Post
Yup, have booked two BRGs, one of which I discovered using the tool.

I'm still hitting the hotel name mapping error quite often, unfortunately. Can you shed some light into what's causing it? Perhaps we can find a programmatic solution a bit more efficient than reporting it here every time we see it.
That is awesome! The reason is that the hotel name provide by SPG is different from what it is on hotelscombined.com, for example "sheraton aaa resort & spa" might be "sheraton aaa resort and spa" on hotelscombined.com but "sheraton bbb resort & spa" might be "sheraton bbb resort spa" (without word 'and') on hotelscombined.com. So currently report the error in this thread is the best solution since it would take me too long to look up every hotels listed on SPG. I'm planning to do a big update to update them all by writing scanning program, but I do not start this work yet.

IMPORTANT: DUE TO SOME DOMAIN NAME PROVIDER's ISSUES, I MOVE MY WEBSITE TO http://justbrg.com/ PERMANENTLY

Last edited by uriel888; Jul 23, 16 at 2:26 am
uriel888 is offline  
Old Jul 23, 16, 9:36 pm
  #107  
FlyerTalk Evangelist
 
Join Date: Apr 2009
Location: India
Programs: Bonvoy Ambassador & Lifetime Titanium, IHG Plat, HH Gold, Trident Plat, DL Diamond, AI Maharajah
Posts: 27,913
Originally Posted by uriel888 View Post
^^^Did you successfully discover the BRG and get that approved?
i did, for a stay earlier this week....thanks again for building this tool....^^
Keyser is offline  
Old Jul 27, 16, 12:15 am
  #108  
 
Join Date: Feb 2011
Location: SIN
Programs: Hard to keep one
Posts: 155
tried last night. All Singapore hotels are returning the name match error.
EngOnAPlane is offline  
Old Jul 27, 16, 12:33 am
  #109  
Marriott 10+ Badge
 
Join Date: Jan 2003
Programs: LH SEN***, Bonvoy Ambassador/LT Titanium
Posts: 1,422
I was just looking at London hotels. BRG's are being reported with venere.com. However, because the rates are without taxes at venere.com and the SPG rates are with taxes, it ends up being that the rates are the same.
cbellero is offline  
Old Jul 27, 16, 5:29 am
  #110  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by cbellero View Post
I was just looking at London hotels. BRG's are being reported with venere.com. However, because the rates are without taxes at venere.com and the SPG rates are with taxes, it ends up being that the rates are the same.
Do you mean that the rate on the SPG official website already included tax? ummm... It seems that most countries in EURO will include taxes in the original price. The bad news is that I cannot fix this right now, because to do this then I need to do some researches for every country's tax policy. This will be quite time consuming, but I will put this kinda of bug on my list and fix it after I fix most mapping issues.
uriel888 is offline  
Old Jul 27, 16, 5:31 am
  #111  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by EngOnAPlane View Post
tried last night. All Singapore hotels are returning the name match error.
I'm in progress of a big update that will fix most match errors.
uriel888 is offline  
Old Jul 27, 16, 6:34 am
  #112  
Marriott 10+ Badge
 
Join Date: Jan 2003
Programs: LH SEN***, Bonvoy Ambassador/LT Titanium
Posts: 1,422
Originally Posted by uriel888 View Post
Do you mean that the rate on the SPG official website already included tax? ummm... It seems that most countries in EURO will include taxes in the original price. The bad news is that I cannot fix this right now, because to do this then I need to do some researches for every country's tax policy. This will be quite time consuming, but I will put this kinda of bug on my list and fix it after I fix most mapping issues.
The challenge is that the reference sites may or may not include taxes. And then you do not know which taxes are included. VAT is only one component. There may also be cultural or tourist taxes based upon number of people, number of stars of the hotel, or the city.

Another challenge is that taxes sometimes deviate by city within a country and or the star rating of the hotel.

What I would recommend is that you include a loop in your programming that compares the BRG rate and adds the VAT tax only based upon country. If it is within a chosen percentage of the BRG rate (perhaps 2%), then the BRG rate should get appended with a comment stating the difference may be due to taxes not being included.

If that is something doable, I would be willing to provide you with a list of the VAT tax rates within Europe and then also include whether or not the SPG rates include taxes. I just hope that the SPG rates within one country always include or exclude the VAT rates for all SPG hotels in that country.
cbellero is offline  
Old Jul 27, 16, 8:23 am
  #113  
A FlyerTalk Posting Legend
 
Join Date: Apr 2004
Location: GVA (Greater Vancouver Area)
Programs: DREAD Gold; UA 1.021MM; Bonvoy Au-197; PCC Elite+; CWC Au-197; CCC Elite*; WoH Dis
Posts: 50,132
Multiple bad matches for San Francisco search:

Hotel Name: The Park Central San Francisco
Hotel Name: The St. Regis San Francisco
Hotel Name: Four Points by Sheraton Hotel & Suites San Francisco Airport
Hotel Name: Sheraton Sunnyvale Hotel
Hotel Name: Aloft Sunnyvale
mahasamatman is offline  
Old Jul 27, 16, 9:14 am
  #114  
 
Join Date: Jul 2016
Programs: SPG, Asia Miles, Skypass
Posts: 11
Everytime when I try to use the web for brg, I click on the link to BRG site. it pops up the hotelscombine.com, however, it says Your Search has expired due to inactivity. Search again

May I know how to fix it?
a288bennie is offline  
Old Jul 27, 16, 9:53 am
  #115  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by a288bennie View Post
Everytime when I try to use the web for brg, I click on the link to BRG site. it pops up the hotelscombine.com, however, it says Your Search has expired due to inactivity. Search again

May I know how to fix it?
Can you provide your date and destination?
uriel888 is offline  
Old Jul 27, 16, 9:56 am
  #116  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by cbellero View Post
The challenge is that the reference sites may or may not include taxes. And then you do not know which taxes are included. VAT is only one component. There may also be cultural or tourist taxes based upon number of people, number of stars of the hotel, or the city.

Another challenge is that taxes sometimes deviate by city within a country and or the star rating of the hotel.

What I would recommend is that you include a loop in your programming that compares the BRG rate and adds the VAT tax only based upon country. If it is within a chosen percentage of the BRG rate (perhaps 2%), then the BRG rate should get appended with a comment stating the difference may be due to taxes not being included.

If that is something doable, I would be willing to provide you with a list of the VAT tax rates within Europe and then also include whether or not the SPG rates include taxes. I just hope that the SPG rates within one country always include or exclude the VAT rates for all SPG hotels in that country.
You are right, it seems that SPG in some regions and countries will include the VAT rate in the very beginning search, and I will be pretty appreciate if you can provide the list of some countries that will include VAT. Once I have that information it will be a piece of cake to implement the list on the website.
uriel888 is offline  
Old Jul 27, 16, 10:12 am
  #117  
 
Join Date: Jul 2016
Programs: SPG, Asia Miles, Skypass
Posts: 11
Originally Posted by uriel888 View Post
Can you provide your date and destination?

destination: Macao
date : Sep 10 - 11
a288bennie is offline  
Old Jul 27, 16, 10:22 pm
  #118  
 
Join Date: Apr 2015
Location: Brisbane Australia
Programs: BA Gold QFF WP AA EXP Marriott PPE HH Diam
Posts: 99
Sheraton Mirage changed their name. Can you update please. Thanks.

Hotel Name: Sheraton Grand Mirage Resort, Gold Coast
Best Point Usage : Only Points With value($/Point) : 0.0189
Hotel official Price($/day): 227
BRG Rate($/day): Some error when mapping official hotel name to compete site
Moindardt is offline  
Old Jul 28, 16, 5:48 am
  #119  
Original Poster
 
Join Date: Jun 2016
Programs: SPG
Posts: 133
Originally Posted by a288bennie View Post
destination: Macao
date : Sep 10 - 11
I cannot reproduce the bug you have. All BRG links will lead me to the correct sites. Can you provide the hotel you want to BRG?
uriel888 is offline  
Old Jul 28, 16, 12:37 pm
  #120  
 
Join Date: Jul 2016
Programs: SPG, Asia Miles, Skypass
Posts: 11
Originally Posted by uriel888 View Post
I cannot reproduce the bug you have. All BRG links will lead me to the correct sites. Can you provide the hotel you want to BRG?
I guess the BRG rate goes away, right now it says

Some error when mapping official hotel name to compete site
a288bennie is offline  

Thread Tools
Search this Thread
Search Engine: