Price relation function is used to manipulate prices synced from the channel manager to an OTA extranet. One of the use cases where you may need to use price relation is when :

Sync a lower / higher price to an OTA compared to the prices on channel manager

There are nine combinations to manipulate price that get synced from channel manager to the OTA

Sync same prices as on CM

No configuration

  • Price on Extranet >> No Information
  • Final Price on Axisrooms >> No Information

Whatever the prices updated in CM, the same prices will be pushed to the OTA's

  •  Commission field will be hidden
  • Tax details field will be hidden 
  • GST won't be applicable

Using Sell Rate

  • Price on Extranet >> Sell Rate
  • Final Price on Axisrooms >> Sell Rate

Whatever the prices updated in CM, the same prices will be pushed to the OTA's i.e. Sell Rate

  • Commission field will be hidden
  • Tax details field will be hidden
  • GST won't be applicable

Update rates inclusive of taxes on channel manager but exclusive of taxes on OTA

  • Price on Extranet >> Sell Rate
  • Final Price on Axisrooms >> Sell Rate Inclusive of Taxes

Prices on Axisrooms will be Sell Rate Inclusive of taxes and prices on extranet will be Sell Rate 

  • Commission field will be hidden
  • Tax details field will be displayed, and if any value entered in tax details then that value will be considered while calculating tax

If “Applicable GST” is selected, then tax will be calculated based on the GST tax structure

Calculation when GST is applied:

Example:
Price on Axisrooms : 3540
Price on Extranet : 3540/1.18 (GST) = 3000

Calculation when normal tax is applied

Price on Axisrooms : 4200
Tax value: 5%
Price on Extranet : 4200/1.05 = 4000,

Calculation when tax config is fetched from the OTA

While fetching configs of a room, some OTA's will be sending the tax value. In this case, tax value will be the tax value fetched at the time of fetching the configs

Price on Axisrooms : 5600
Tax value at the time of fetching the configs is : 12%
Price on Extranet: 5600/1.12 = 5000

Update rates exclusive of taxes on channel manager but inclusive of taxes on OTA

  • Price on Extranet >> Sell Rate Inclusive of Taxes
  • Final Price on Axisrooms >> Sell Rate

Prices on Axisrooms will be Sell Rate and prices on extranet will be Sell Rate Inclusive of Taxes  

  • Commission field will be hidden
  • Tax details field will be displayed, and if any value entered in tax details then that value will be considered while calculating tax
  • If “Applicable GST” is selected, then tax will be calculated based on the GST tax structure

Price Calculation when GST is applied:

Example:
Price on Axisrooms : 7500
Price on Extranet will be : 7500 + 28% (GST) = 9600

Price Calculation when normal tax is applied:

Price on Axisrooms : 8000, Tax value: 5%
Price on Extranet will be: 8000 + 5% = 8400

Calculation when tax config is fetched from the OTA

While fetching configs of a room, some OTA's will be sending the tax value. In this case, tax value will be the tax value fetched at the time of fetching the configs

Price on Axisrooms : 6000
Tax value at the time of fetching the configs is : 12%
Price on Extranet will be: 6000 + 12% = 6720

Update sell rate on channel manager but net rate on OTA

  • Price on Extranet >> Net Rate
  • Final Price on Axisrooms >> Sell Rate

Prices on Axisrooms will be Sell Rate and prices on extranet will be Net Rate

  • There will be a option to enter commission (Commission field will be displayed)
  • Net Rate + Commission = Sell Rate
  • Sell Inclusive of tax + Commission = Net Inclusive of Tax

Price calculation when commission is applied:

Price on Axisrooms (Sell Rate) : 8000
Commission : 3%
Price on Extranet (Net Rate) : 8000 – 3% =  7760

Update net rate on channel manager but sell rate on OTA

  • Price on Extranet >> Sell Rate
  • Final Price on Axisrooms >> Net Rate

Prices on Axisrooms will be Net Rate and prices on extranet will be Sell rate

  • There will be a option to enter commission (Commission field will be displayed)

Price calculation when commission is applied:

Price on Axisrooms (Net Rate) : 8000
Commission : 3%
Price on Extranet (Sell Rate) : 8000 + 3% =  8240

Update net rate on channel manager but sell rate-tax inclusive on OTA

  • Price on Extranet >> Sell Rate Inclusive Tax
  • Final Price on Axisrooms >> Net Rate

Prices on Axisrooms will be Net rate and prices on extranet will be Sell Rate Inclusive Tax

  • There will be a option to enter commission (Commission field will be displayed)
  • There will be a option to enter Tax value 

Price calculation when commission and tax are applied:

Prices on Axisrooms (Net rate) : 8000
Commission : 3%
Tax value : 5%
Price on Extranet (Sell rate Inc Tax) : 8640
-----------
base to be synced : 8000
comm 240   3%
tax 400 . 5%
price on AXR: 8640

Update net rate-tax inclusive on channel manager but sell rate-tax inclusive on OTA

  • Price on Extranet >> Sell Rate Inclusive Tax
  • Final Price on Axisrooms >> Net Inc Rate

Prices on Axisrooms will be Net Inc Rate and prices on extranet will be sell rate inc. of tax

  • There will be a option to enter commission (Commission field will be displayed)
  • There won't be a option to enter tax details

Price calculation when commission is applied:

Price on Axisrooms (Net Inc Rate) : 8000

Commission : 3%

Price on Extranet (Sell Inc Rate) : 8000 + 3% = 8240

Update sell rate-tax inclusive on channel manager but net rate on OTA

  • Price on Extranet >> Net Rate
  • Final Price on Axisrooms >> Sell Rate Inclusive of Taxes

Prices on Axisrooms will be Sell Rate inc taxed and prices on extranet will be Net Rate

  •  There will be a option to enter commission(Commission field will be displayed)
  • There will be a option to enter tax details

Price calculation when commission and tax are applied:

Price on Axisrooms (Sell Inc Tax) : 8000
Commission : 3%
Tax value: 5%
Price on Extranet (Net Rate) : 7390.48
-----------
base to be synced: 7390.48
comm : 228.57 .  3%
tax : 380.95 .  5%
price on AXR : 8000

 

Did this answer your question?