How to troubleshoot issues when importing reservations by template to Mews Operations

Mews Operations

Troubleshoot issues when importing reservations by template in Mews Operations to identify and resolve errors that prevent successful imports. You perform this action during system migration or data updates when an import fails or shows errors in the installation queue in Mews Operations. Use this article when you encounter issues importing stayover reservations or future reservations to Mews Operations from a different property management system.

 

In this article, you can learn about:

 

 

How to troubleshoot issues when importing reservations by template to Mews Operations

Import errors

If there's a problem with your import, check the error report to find out why.

 

To view the report:

  1. In Mews Operations, go to the main menu main menu > Queues > Installations.

  2. Click on the installation code to view the errors. 

 

You can learn about resolving common import errors in the Mews University course.

 

In case the import fails:

  • Review the error details in the installation item
  • Correct the data in the file or the configuration in Mews Operations
  • Upload the corrected file.

 

Errors in the template

Some errors occur because the system does not recognize the information in the template.

 

Common causes of errors include:

  • Incorrect date format
  • The Company tab is not there in the template.
  • Outdated template with incorrect header names
  • Mismatch between the file and how room, rate, or product names appear in Mews.
  • Overbookings or blocked rooms where no space is available for the reservation dates
  • References to entities that do not yet exist in Mews, such as companions, companies, or travel agencies
  • Incorrect country codes, for example, using UK instead of GB

 

Once you fix any errors in your template, upload the corrected file to Mews Operations.

 

ⓘ
Note
  • Some fields are case-sensitive. Make sure values match exactly how they appear in Mews.
  • If you reference other entities, such as companies or travel agencies, create or import them first in a separate file before importing reservations.
  • If during the import process you find an error in Mews Operations, for example, if you misspell a product name when you completed your Mews setup, you can fix the error by updating the information in Mews, then reimporting the template file.

 

Incorrect formatting of dates in the template

Date formatting is a common cause of import errors. If you format the date incorrectly in the Excel, when importing it changes the way a date is stored, and Mews Operations may not read the value correctly. This can cause the import to fail or create incorrect reservation dates.

 

ⓘ
Note
  • The import file requires dates as text in a supported format, such as DD/MM/YYYY. Enter dates in this accepted format and make sure the column is formatted as text. This keeps the date exactly as entered in the file.
  • Check the import template for accepted date formats and examples.

 

  1. Open the import template in Excel.
  2. Select the whole column with the faulty date format, for example, Arrival date.
  3. In the toolbar, click on the Data tab.
  4. In the Data tools section, click Text to columns.

  1. Make sure the Delimited checkbox is selected, then click Next.

  1. Click Next again. 
  2. Under Column data format, select Text.

  1. Click Finish. 

 

Pending status not updating

If the upload status on the Installation queue items screen is in Pending for a long time, contact Mews customer care team so they can investigate.

Note: Do not upload the file again. In case the initial upload was successful, you end up creating a duplicate of your reservations. You then need to manually cancel these, which negatively impacts your cancellation statistics.

 

 

 

Was this article helpful?
00



Feedback