Update Market Code
The Change Market Code utility, Utilities>Update Market Code, gives a property the capability to change market codes, create uniformity of market codes across all products, and update existing market codes. Market codes that already exist can be used or new market codes can be configured. See the below diagram for further reference to this process.
After configured, the existing market codes are replaced on a one-to-one basis. For example, Market Code ABC is to replace Market Code MNO in all instances when running this utility. But this replacement will only happen on a per property code level. So if the market codes are updated for one property, they will not be updated at another property.
When using an external system to connect to the PMS module, the Update Market Code utility does not provide synchronization/updates to these external systems. These updates will have to be done by the property themselves. As far as updating separate Opera products, if all of the products are running from within the same environment (i.e. schema), then market codes will update across the multiple Opera products by running the utility in one product. However, if these products are running in separate environments (i.e. multiple schemas or using an interface to pass data), then each product should be updated as a separate system.
Note: Market Code Updates only occur for Future Reservations that are not checked in and for Future Cancellations and No Shows. Reservations with a status of Departed or Still In-House will not be affected by this utility.
Note: Users at this property need to be logged off the system before this utility is ran.
Property. Select the down arrow to choose the property in which the market codes need to be changed for.
Once a market code is selected in either the Existing Code column or in the New Code column, it will no longer be displayed in the list of values to be selected.
Existing Code. After selecting the New button, choose the existing market codes to be updated from the multi-select list of values.
New Code. Select the down arrow to choose the new market code that all the existing market codes will be updated to.
Note: If all of the market codes are selected for the existing codes column, the following prompt is displayed to warn that no market codes exist to be selected.
Status. Displays a status of Complete or Error. If the status is Complete, then a list of tables accessed and the number of records updated are displayed in the large status description field at the bottom of the screen. But if Error is displayed, then a detailed error message will be displayed.
New. Opens a multi-select list of market codes to choose either the existing market codes or the new codes to be updated to.
OK. Select to update the selected market codes with the new market codes for the property. After selecting the OK button, a warning is displayed.
Close. Exits out of the Change Market Code utility functionality.
See Also