Mass Ancillary Upload/Update

This functionality allows users to create, edit, and update ancillary services and their associated items in a faster and more efficient way.

The process works similarly to the fare mass upload/update tool, enabling bulk management through structured file uploads.

Before using this feature, it is important to understand its limitations. Since each ancillary service can include multiple service items, it is not possible to add new service items to an existing ancillary structure using the mass upload tool.

To introduce additional service items, users must either:

  • Update the structure manually via the UI
  • Create a new ancillary service structure (including the required items) and deactivate the previous one

☑️ Create the new ancillary / ancillary items structure
☑️ Update the existing ancillary / ancillary items
❌ Add more ancillary items to existing ancillary services structure

a) Mass creation of new ancillary services structure

  1. Go to Marketing > Ancillary Services and select the upload options:
  2. Download the .csv file with the example file structure:
  3. Populate the table based on the example file.
    Important: the file structure contains 2 header rows describing fields in “ancillary services” as well as in sub-panel “ancillary items”. The minimal input would be to provide 2 rows of data (a single ancillary service and a single ancillary item contained within).
  4. Ensure the structure of the provided data matches the example and values do not exceed limits.
ParameterDescription / Accepted Values
Service/Item Active0 (inactive) or 1 (active)
Show on Web0 (inactive) or 1 (active)
Connection Ancillary0 (inactive) or 1 (active)
Show on CRS0 (inactive) or 1 (active)
PNL Baggage Related Service0 (inactive) or 1 (active)
Charge VAT on TAX0 (inactive) or 1 (active)
Date FieldsDD/MM/YYYY (e.g. 01/08/2025). Ensure Excel does not auto-change format
PNL SSR CodeMax 4 characters
ACC CodeMax 4 characters
Selling Options1 = before and after ticketing
2 = only after ticketing
3 = only before ticketing
  1. Once the file is prepared, upload it using the same menu as in step 2. A message should confirm the process was successful.

b) Mass update of existing ancillary services

The process is identical to the mass fare updates. The main difference is the use of ServiceID/ItemID to identify records.

  1. Select the desired ancillaries using filters, then download the .csv file using the “special export” button:
  2. Update the required fields within the file.
  3. Upload the updated file using the Update button:
Have more questions? Submit a request

Comments

Powered by Zendesk