Hotel Bidding System Errors and Warnings Codes Guide

Introduction

This guide is designed to provide Skyscanner hotel partners with detailed explanations of the error and warning codes that may appear in notifications regarding their submitted bidding files and multiplier files.

Understanding this information will facilitate quick identification of issues, ensuring a smooth operation for your hotel bidding.

User Guidance for Error and Warning Resolution

Step-by-Step Troubleshooting

1. Identify the Issue: Match the error or warning code from your notification to the descriptions provided in this guide.
2. Understand the Error/Warning: Read the detailed description and provided examples, or contact your account manager to understand scenarios for each error/warning that has occurred with your submission.
3. Implement Corrections: Take corrective actions on the bidding file.
4. Re-upload: Upload the revised file to the directory with your account.

Errors Overview

Base Bid File and Multiplier File Pre-Check Errors

Error Code	Error Type	Description
SKY_BID_001	Invalid File Name	Invalid file name. Please refer to the Naming rules for Partner bidding files. The correct format for the Base Bid file is {partner_name}_bidfile_{YYYYMMDD}.csv, and for the Multiplier file, it should be {partner_name}_multiplierfile_{YYYYMMDD}.csv.
SKY_BID_002	Invalid File Type	File type not specified. Only CSV files are accepted.
SKY_BID_003	Non-CSV Format	Non-CSV file format detected.
SKY_BID_004	File Size Too Big	File size exceeds the allowed limit.
SKY_BID_005	Encoding Error	File encoding error encountered.
SKY_BID_006	Missing Mandatory Columns - Base Bid	Missing mandatory columns in the base bid file (e.g., Hotel ID, Campaign, or Group Column).
SKY_BID_007	Missing Mandatory Columns - Multiplier	Missing mandatory columns in the multiplier file (e.g., Group Column, Campaign Column, Start & End, Multiplier Type, or Multiplier Value).
SKY_BID_008	Unsupported Mandatory Columns - Base Bid	Unsupported mandatory columns in the base bid file (e.g., Hotel ID, Campaign, or Group Column)
SKY_BID_009	Unsupported Mandatory Columns - Multiplier	Unsupported mandatory columns in the multiplier file (e.g., Group Column, Campaign Column, Start & End, Multiplier Type, or Multipier Value).
SKY_BID_010	Duplicated Mandatory Columns - Base Bid	Duplicated mandatory columns in the base bid file (e.g., Hotel ID, Campaign, or Group Column).
SKY_BID_011	Duplicated Mandatory Columns - Multiplier	Duplicated mandatory columns in the multiplier file (e.g., Group Column, Campaign Column, Start & End, Multiplier Type, or Multiplier Value).
SKY_BID_012	Mismatched Campaign Column and Group Column - Base Bid	The Campaign Column and Group Column do not match up in the base bid file.
SKY_BID_013	Not Find Bid or Multiplier Files	The file name format may be non-compliant or no file in SFTP.

Base Bid File Errors

The base bid file errors target the specific aspects of your base bid specification:

Error Code	Error Type	Description
SKY_BID_101	Invalid Market Name	Incorrect market two-digit country code as specified by the Skyscanner country code list.
SKY_BID_102	Invalid Platform Name	Platform name does not match the specified options ('Mweb', 'App', 'Desktop').
SKY_BID_103	Invalid Group Name	Group name provided does not match the expected format (e.g., ‘US_Desktop_Group’).
SKY_BID_104	Invalid Character	File contains invalid characters (e.g., spaces, hyphens, asterisks).
SKY_BID_105	Invalid Base Bid Value	Base bid value is negative or non-integer.
SKY_BID_106	Invalid Group Value	The group number should be an integer between 1 and 10.
SKY_BID_107	Invalid Hotel ID	Hotel ID contains invalid characters (characters other than numbers, hyphens, and alphabets).
SKY_BID_108	Duplicated Base Bids	A single hotel appears multiple times within the same campaign-group in the bid file.

Multiplier File Errors

The multiplier file errors target the specific aspects of your multiplier specification:

Error Code	Error Type	Description
SKY_BID_201	Invalid Multiplier Type Name	Invalid multiplier type name detected.
SKY_BID_202	Invalid Campaign Name	Invalid campaign name as per base bid file specification.
SKY_BID_203	Invalid Group Name/Value	Invalid group name or value as per base bid file specification.
SKY_BID_204	Invalid Character	File contains invalid characters (e.g., spaces, hyphens, asterisks).
SKY_BID_205	Invalid Start/End Value	Invalid start or end value.
SKY_BID_206	Invalid Multiplier Value	Invalid multiplier value.
SKY_BID_207	Multipliers Overlap	Overlap in multiplier values due to start/end value conflicts.

Warnings Overview

Warnings for Base Bid and Multiplier Crosscheck

These warnings don't pause the process but are important for quality control:

Error Code	Error Type	Description
SKY_BID_1001	Base Bids & Multipliers Not Match	Missing multiplier(s) detected (set to 1).
SKY_BID_1002	Redundant Multipliers	Redundant multipliers detected.
SKY_BID_1003	GMB violation within ECT	GMB violation of base bid - less than 5 pence.
SKY_BID_1004	GMB violation Exceed ECT	GMB violation of base bid - exceeds ECT.
SKY_BID_1005	Base Bid Value Below Minimum Threshold	Base bid value is below 5 pence.
SKY_BID_1006	Base Bid Value Exceeds Upper Bound	Base bid value exceeds 15 GBP.
SKY_BID_1007	Multiplier Value Exceeds Upper Bound	Invalid multiplier value (e.g., blank, negative, zero, exceeds 10, not a numeric value).
SKY_BID_1008	Hotel ID Not Mapped	Bidding Ignored: Hotel ID(s) are not mapped with Skyscanner hotel ID(s) (e.g., duplicated, " "invalid, not found).
SKY_BID_1009	End Value is Out of Range	The multiplier end value is out of range and will be adjusted down to the maximum allowed value

Continuous Improvement

We are committed to improving Skyscanner hotel partners' experience and welcome feedback on the bidding ingestion process and this guide.

For further assistance or to resolve any uncertainties, please contact our support team.