This Functionality is useful to create/configuring multiple Offers/Specials through one Import File
Steps To Open Import/ Batch Update Offer Functionality
Rate Manager->Offer->Batch Update
Rate Manager->Offer->Batch Update->Download template->Import
After Downloading “Template” [Blank File]
There are two options in the blank Import/sheet Options
Data
Information
In Datasheet you have to add/fill related all data in the Import file columns
Important Informations you have to follow as given in below when you add/fill data in the sheet
Orange Color Column - Mandatory fields and a must needed information
Blue color Column - Mandatory under certain conditions only
Green Color column - Non-mandatory but helpful to give more clear information
While creating the Special[Offer] Import file some important Information [Which data you have to add]
1. "The name of the location in which offer is configured or needs to be configured can be added in 1st column,
After that Parent Offer Name 1, Parent Offer Name 2, Parent Offer Name 3, etc,
[In the screenshot you can see Parent Offer Name 1, Parent Offer Name 2, Parent Offer Name 3
2. You can add the Offer Name and Offer code that you want for your Special/Promotions/offer
3. Offer types means It is a General Type of Offer or Offers With Addon [Package]
4. Policy (Hidden or Open)
Policy (Hidden or Open) when your Offer is “New Import” but if it Existing [Already imported or configured] then needs to be Blank.
5. Location Code Of Accommodation, Parent Accommodation Code, Accommodation Type Code
When We add Location means In which Particular Resorts[Location] you want to Configured that Offer, after that option is Parent Accommodation Type means In which parent Type your bookable type is present/Available for booking[ Tahiti(tah)--> mobile home Tahiti (tahmob)] , Last is Accommodation Type means exactly which type you wanted to give a discount or book that offers/Special [mobile home Tahiti (tahmob)]
6. Arrival Date From-Arrival Date To, Book Date From-Book Date To you have to add for your Offer/Special.
The Arrival From and To is the dates, when a customer comes to that Location for use and the Book date from-To, means when the offer location book by the customer
7. Stay Duration means how many days and which days[Mod, Tue, Wed, Thus, Fri, Sat, Sun] he comes to that location, As mentioned dates, you can add so Rates and Rentability configured as it is and stay duration [Weekend, week, midweek, etc]
8. Select the Type of Rate, Rate, Rate Type Code, which is you want for the Special, Means Type of rate [New Price, Percentage, stay log pay less, etc] Fixed discount or
New price or percentage discount after that Rate[Price of offer], Rate Type code[eur, Doller[bar], rupees[inr], etc] which is base on Location country base.
9. At the time of importing the file, you can also Generate Rentability same as it is mentioned Dates select only the "Y" option.
Note:- If you want to change in Previous Configured or Import Offer then where you already inserted Rentability then for the again same period and offer you don’t need to add Rentability
or select Option of “Generate Rentability” or “Yes” just need that column Blank [Shows in below Screenshot]
FYI:- Already Configured or import offer and you want to change in anything like Rates for that Offer and you selected “Generate Rentability” option is “Yes” then the same Rentabilty is inserted without Blocking old Rentability because you already configured for the same offer with the same parameters.
10. Also you can add parent DC or Particular DC also for Offer, means for which channel through you want to book that offer like [internet, receipt, desk, etc]
11. After all details adding you have to “Import” file
If all data is correct then it shows you Completed otherwise in any error in your file then it shows an Error/Failed and you can download the error file.
You can search your Special/Offer after the Complete message shows in the import batch update offer [Search code, name, code of offer]
After that, you can check all details like Accommodation type[Additions], Rates, Rentability, DCs, etc added properly in all Resorts which is added in Import File
Here you all process related to Offer Import Functionality end.