Update Product-Hotels

NEW METHOD

1. Go to

   https://expediaintegration.zendesk.com/hc/en-us/restricted?return_to=https%3A%2F%2Fexpediaintegration.zendesk.com%2Fhc%2Fen-us

   • Email: it-services-signup@myersmediagroup.com
   • Username: MMG IT
   • Password: markthequark
2. Go to “Hotels”
3. Go to “Hotel Inventory (Hotel ID) List” and download Agency+Merchant for your Point of Sale (four files, everything but descriptions)
4. Go to “Hotel Descriptions & Amenities” and download Agency+Merchant for your Point of Sale (Descriptions file)
5. Import downloaded files manually
   • You should have five .csv.gz files (Added, Deleted, Updated, All and Description)
   • Unzip all files to .csv files
   • Run https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/DataSources/Product/trunk/script/1-download-and-import.pl
     • Note the “Download” and “Unzip” part of the script has been commented out
   • QA to make sure:
     • Product Hotels view to refer to new files
     • Product Hotels synonym to refer to new view
     • dbo.config has new Product Hotels version
6. Clone updated hotels from Primary to 2nd language.
7. Clone updated hotels from Primary to 3rd language.

OLD METHOD (OBSOLETE)

Download and import latest Hotels property data from Expedia API

Run https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/DataSources/Product/trunk/script/1-download-and-import.pl .

This script handles downloading and importing of Hotel Property data.