How to map your Expedia direct channel manager integration using the Expedia Extranet and Mews Operations

Mapping your Expedia direct channel manager integration means linking your Expedia room types and rates to their matching categories and rates in Mews. As a property employee setting up the integration, you do this to ensure availability, pricing, and reservation data sync correctly between Expedia and Mews Operations. You complete this process during your property's onboarding or when updating your channel setup. You manage the mapping using the Expedia Extranet and the Mews Operations integration settings.

 

For example, you have a "Standard Double" room in both Expedia and Mews. If a customer books this room on Expedia, the mapping informs the system to create a booking for this exact room in Mews.

 

Prerequisites

Most setup steps take place the day before your Go Live date but reviewing them in advance helps ensure a smooth transition.

 

Before you start mapping your Expedia integration:

Make sure you’re not actively changing any rates in Expedia. Rate changes during mapping can cause sync issues.

 

Firstly, check the following:

 

1. Pricing model: In your Expedia Extranet, confirm that your pricing model is set to Per-day pricing. If it isn’t, ask your Expedia contact to switch it. Note: If your property is switching from occupancy-based pricing to per-day pricing, Expedia requires a manual transfer of data. This process must be scheduled with your Market Manager. You also need to create new rate plans, because you cannot change the pricing model on existing ones. Learn more in the Expedia help article Pricing models

2. Content match: Align the following settings between Mews and Expedia:

  • Rates
  • Inventory
  • Room categories
  • Payment and cancellation policies
  • Age categories

3. Download the mapping file: Once your setup is updated, download the mapping file from your Expedia Extranet. You’ll typically find it under Analytics or Inventory, but this may vary.

4. Locate your hotel ID: Copy your Property ID/Hotel ID from the Extranet.

5. Set all payment automations in Mews to Manual. Learn more in our help article How to create a payment policy in Mews Operations. Note: If you import prepaid reservations and automations are active, Mews attempts to take payments again.

6. Under General settings, uncheck the option to Send payment failed email. Learn more in our help article Setting up your property account. Note: This helps avoid confusion during import and prevents unnecessary emails to guests.

 

 

 

Step 1: Set up in Mews

1. In Mews Operations, go to the main menu Main menu icon in Mews Operations  > Marketplace.

2. Search for Expedia, then click Explore.

3. Select the correct service. Note: You can set up only one Expedia integration per service.

4. Click Connect integration.

5. In Marketplace > Expedia integration, click Edit.

 

Step 2: Prepare for mapping

Follow these steps to get your file ready:

 

Step 1: Format your Excel file

1. Open the Excel file from Step 1.

2. Select Column A.

3. Go to the Data tab and click Text to Columns.

4. Choose Delimited, then click Next.

5. Select Comma, then click Finish.

 

Step 2: Understand how to map your rates

Follow these instructions carefully to avoid synchronization issues:

 

  1. Map one rate per space category.
  2. Map only active rates. Note: If all your rates are inactive, you must map them to sync your reservations.
  3. If a reservation uses an inactive rate, map that rate as well. Note: You can leave inactive rates unsynchronized unless they are used in upcoming or current reservations.
  4. When mapping Expedia Collect rates, review both rate types:
    • You might see duplicate rates with similar names—one ending in "A."
    • You only need to map one of the duplicate rates.
  1. Identify if the Expedia rate is set to sync or not:
    • For example:
      • SELL + Derived + Yes: The rate syncs as Expedia Collect.
      • LAR + Derived + Yes: The rate does not sync as Expedia Collect.

 

 

Step 3: Know which rates to map

  • Hotel Collect: Look for Expedia rates ending in "A". If the Interface Rates column shows Yes, map this rate.
  • Expedia Collect: Look for standalone rate codes (not "A") marked as Yes in the Interface Rates column. These must also be mapped, but as unsynchronized.

 

Step 3: Configure General Expedia integration settings

Note: Do not enable the integration yet.

To configure you general Expedia integration settings:

  • Channel manager code: Copy and paste your Hotel ID from Extranet.
  • Responsible department: Select the role for assigning who manages errors. If left blank, the system creates tasks that are unassigned.
  • Notification email: Add an email address for alerts. Note: This does not include reservations.

 

Step 4: Enable Operations

Before enabling the integration, set up your operations. These actions happen automatically once you enable the integration's general settings.

  • Download future reservations: Imports existing upcoming bookings from Expedia. Note:
    • Keep disabled until testing is complete.
    • Check the box when:
      • You’ve finished pushing your rates and availability.
      • You’ve tested the connection.
      • You’re ready to enable the integration.
  • Download reservations: Fetches new reservations from Expedia after you go live.
  • Upload availability, rates & restrictions: Syncs updates from Mews to Expedia.

Note: Most properties enable all options.

 

Step 5: Configure Additional Options

Pay close attention to:

  • Apply cancellation fee: Uses the policy set in Mews.
  • Create reservation from modification push: Ensures that the integration creates new reservations when bookings in Expedia get modified.

Note: Mews recommends you do not enable this setting. When the system creates a cancellation, it creates a task only. It won’t cancel the reservation automatically.

 

  • Create companions without email
  • Create company and travel agency profiles: Do enable.
  • Enable more granular reporting
  • Use age category in inventory: Do not enable.
  • Use age category in reservations: If enabled, ensure age categories are mapped.

 

Step 6: Add Room Categories

For the room types you want to sell on Expedia, set them up just like rates.

1. Go to Expedia integration > Channel manager categories > + > Add rooms.

  • Space Category Code: Copy this from the mapping file.
  • Select the matching category from the dropdown.

Note: Make sure the number of room types matches exactly what your property has configured in Expedia, using a one-to-one mapping.

2. Click Sync to send availability/ restrictions to Expedia.

3. Click Create, then repeat for all categories.

Note: If you are using age-based pricing, ensure Mews and Extranet have matching age categories.

 

Step 7: Add Rates

You need to mirror the rates you sell on Expedia in Mews. The mapping file includes detailed instructions on which rate you need to map to which room category.

1. Go to: Expedia integration > Channel Manager Rates > + > Add rate.

  • Rate Code: Copy this from the downloaded mapping. Note: It is a numerical code, not the Mews rate name.
  • Select the corresponding rate from the dropdown. Note: These are rates already set up in Mews.
  • Choose:
    • Synchronized: If the rate is Hotel Collect.
    • Unsynchronized: If the rate is Expedia Collect. Note: You can learn more about the difference here.

2. Click Create, then repeat for all rates.

 

Step 8: Link Rates to Room Categories

Note: Do not forget this step!

1. Go to: Channel manager rates > Click the Rate Code.

2. Click the + icon to add a Room Category.

3. Only add room categories that apply to the selected rate. Note: In Expedia, you map one rate to one specific room category only. You cannot use the Connect Connect icon in Mews Operations  feature to plug all room types into one rate as you do with Booking.com.

4. Click Save.

 

Map Age Categories

  • Sync only as many age categories as you use.
  • Select Adult/ Child from the dropdown.

 

Map Travel Agencies

  • For Expedia to correctly collect bookings with billing automations, ensure you create Company and Travel agency contracts.

 

Step 9: Mapping products

Follow these instructions to map products, for example, products packaged as BB:

  1. In Mews Operations, go to the main menu > Marketplace > My subscriptions
  2. Find the integration, then click Edit to go to the settings.
  3. Click Channel manager products.
  4. Click + Channel manager product at the screen’s top right corner.
    • Product code: Enter the unique code provided by your channel manager.
    • Product: Select a product from the drop-down menu.
  1. Click Create.

Repeat steps 4-5 for every product you want to send to Expedia.

 

Step 10: Push data and test the connection

Note:

  • Before continuing, in the Expedia Extranet, change your connectivity provider to Mews.
  • Do not check the Enable box at this stage. You must complete the one-week test period and correct any errors before enabling the Expedia integration.

 

Test the Integration

1. In General Settings > Enabled operations, make sure you selected:

     a. Upload availability

     b. Upload rates

     c. Upload restrictions

2. Push test data:

     a. Click Menu > Manual actions > Push inventory

     b. Choose a short date range, for example, From: Today To: +1 week

Note: This pushes data but does not import reservations.

3. Check for errors:

     a. In Mews Operations, go to the main menu Main menu icon in Mews Operations  > Queues > Channel manager.

     b. Filter dates to match the push.

     c. Check details & fix errors. Note: Hold cursor over status for more information.

 

Before enabling the connection,

  • test for a period of 7 days.

 

If successful, for example, the connection resulted in no mapping errors, Mews advises you to,

  • log in to the Expedia Extranet to compare the availability, rates, and restrictions to those in Mews Operations.

 

Step 11: Enable the Integration & Go Live

Once you enable the integration, based on your selected Enabled Operations, the following happens:

  • Reservations download automatically.
  • Availability and rates upload to Expedia.

 

Note: You need to send the information for the next 365 days. Learn more in our help article Connect and configure your channel manager integration to receive reservations through external channels.

 

Optional final check:

Before enabling, pull a test reservation from Extranet:

  • Click Menu > Manual actions > Download reservations by IDs
  • Check that all details, including Product rules, transferred correctly.

 

You’re now live on Expedia.

 

 

 

Was this article helpful?
00



Feedback