Export And Import Products And Prices From Excel

The export feature is available in the Prices list, where the system allows exporting the results of a search performed in the list.

The exported Excel file can be used for the Import feature as it has the same structure that the import requires.

The import feature is located in the main left menu, under Products and Prices list, accessible by clicking on the edit sign.

Excel File With Explanations For Fields

See file here

Excel File Details

For each Product detail and Price detail, a column is defined, and the file to be imported must maintain the same structure as in the attached sample.

You may import multiple products at once, each with multiple prices.

For importing a product with more than one price:

• On the 1st row (which is actually the 2nd row in the Excel file, because the 1st row is the header), you must fill in the product details and the details for the 1st price of the product.
• On the following rows, to enter 10 prices for the same product, you must copy and paste the same information for all 13 Product columns in 10 lines and then fill out the Price-related columns for each line separately.

When you have completed the details for the 1st product with all its prices, as explained above, you may add other products with related prices, in the same Excel file.

Important Mention!

For the columns of the Excel file that require completion with TRUE or FALSE values, the column must be formatted as Boolean Value.

First, apply the correct format to the column cells, and after that, type in TRUE or FALSE.

All columns requiring TRUE or FALSE must be completed with one of these two values, without exception.

Each product must have at least 1 price for which Season Begin/Season End, Book Begin/Book End dates must be filled in, otherwise, the import will result in an error.

Columns of the Excel File Explained

Product ID

For new products, leave this column empty or fill it with 0 (zero) as the value.

For updating an existing product, include the product’s ID from Victoury in this field.

If an ID is entered and not found in Victoury, this row will be ignored.

Product Code

If the Product ID column is already filled in, then the product code of the entry found will not be updated; only the rest of the data will be.

If no ID is entered, a new product is created with this Product Code.

If no ID is entered, and the Product Code already exists in Victoury, an error will be returned.

Product-related data update does not occur based on product code identification.

NOTE: Victoury does not allow duplicate Product Codes, thus your codes must be unique.

Brand (ProfitCenter)

Enter the brand code as defined in the Brands Choice List.

Visited Areas

Enter the Visited Areas codes as defined in the Visited_Areas Choice List.

Supplier ID

Enter the Supplier ID.

Supplier Name

If no Supplier ID is entered, but a name is provided in the Supplier Name column, a new supplier will be created, and the new supplier’s ID will be assigned to the product.

If both the ID and the Name of the supplier are entered – the Supplier ID will be assigned to the product, and the Name will be ignored.

If neither Supplier ID nor Name is entered – the supplier ID will be NULL for this product.

Supplier Product Code

Alphanumeric values and symbols

Product Name

Alphanumeric values and symbols

Category

Enter the Choice List code from the Product_Category Choice List.

Country Area

Enter the Choice List code from the Country_Area Choice List.

Charge Nights

The values for this column are true or false.

Rating

Enter the Choice List code from the Product_Rating Choice List.

Type

This can be one of the following values: ARRANGEMENT, ITINERARY, or BOTH.

Duration days

Numeric values

Duration nights

Numeric values

Book daily

The values for this column are true or false.

Book day of week

Before editing, change the cell format to TEXT instead of NUMBER. The value needs to be as 0123456, where 0 = Sunday, 1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5 = Friday, 6 = Saturday.

Has Occupancy

The values for this column are true or false.

Max Child Age

Numeric values representing the maximum age for children.

Max Infant Age

Numeric values representing the maximum age for infants.

Max Baby Age

Numeric values representing the maximum age for babies.

Min Senior Age

Numeric values representing the minimum age for seniors.

Embark Address ID and Embark Location

When the Embark Address ID is provided, Victoury searches for the address:

• If the address is found, it is set for both Embark Address and Embark Location (product embark address name).
• If not found, then the product’s embark Address is not set, and the product’s embark Location will be the value from column X (Embark location).

When the Embark Address ID is not provided:

• The product’s embark Address is not set, and the product’s embark Location = column Y (Embark location).

Disembark Address ID and Disembark Location

When the Disembark Address ID is provided, Victoury searches for the address:

• If found, it sets both the product disembark Address and product disembark Location (product disembark location address name).
• If not found, then the product’s disembark Address will not be set, and the product’s disembark Location will be the value from column Z (Disembark location).

When the Disembark Address ID is not provided:

• The product’s disembark Address will not be set, and the product’s disembark Location = column AA (Disembark location).

Create Voucher

The values for this column are true or false.

Order Text

Alphanumeric values and symbols (text)

Order Remarks

Alphanumeric values and symbols (text)

Number Of Seats

Numeric value

Max Persons

Numeric value

Group Code

Alphanumeric values and symbols

Has Allotments

The values for this column are true or false.

Show Availability when Booking

The values for this column are true or false.

Exclude From Total

The values for this column are true or false.

Remarks

Alphanumeric values and symbols (text)

Catalog Page

Numeric value

Flag

Alphanumeric values and symbols (text)

Budget

Alphanumeric values and symbols

Publish on the Web

The values for this column are true or false.

GPS Location

Alphanumeric values and symbols

Voucher Text

Alphanumeric values and symbols (text)

Voucher Remarks

Alphanumeric values and symbols (text)

Travel Remarks

Alphanumeric values and symbols (text)

Source

Alphanumeric values and symbols (text)

Backoffice Reference

Alphanumeric values and symbols (text) (This is a unique value. Victoury does not allow duplicated Backoffice Reference).

Host2Host

The values for this column are true or false.

Print

The values for this column are true or false.

SeoFriendlyName

Alphanumeric values and symbols (text) (This value is unique and will be generated automatically from the name of the product when the product is saved if the field’s value is not present).

Locked

The values for this column are true or false.

Price ID

The value to be filled in here is 0 (zero) or empty for a new price

• Price ID for existing price to be updated; if no price is found, ignore the row.
• The ID of the price must be related to the product (to not belong to another product other than the one set on the same row).
  Otherwise, an exception is thrown by the system as the PriceID does not belong to the Product.

Season Begin

The correct format is YYYY-MM-DD (2021-01-31).

Season End

The correct format is YYYY-MM-DD (2021-01-31).

Book Begin

The correct format is YYYY-MM-DD (2021-01-31).

Book End

The correct format is YYYY-MM-DD (2021-01-31).

Price Type 1
The values for these columns are the Choice List codes for the entries under Price_Type_1.

Price Type 2
The values for these columns are the Choice List codes for the entries under Price_Type_2.

Price Type 3
The values for these columns are the Choice List codes for the entries under Price_Type_3.

Price Type 4
The values for these columns are the Choice List codes for the entries under Price_Type_4.

Price Description

Alphanumeric values and symbols (text)

Type Description

Alphanumeric values and symbols

Is per Person

The values for this column are true or false.

One Time Charge

The values for this column are true or false.

Buy Unit Price

Numeric value

Buy Tax Code and Buy Tax Percentage

Search for Tax by name (code), percentage, and type contains ‘B’; if no Tax is found, a new tax is saved with type ‘B’.

Buy Commission Percentage

Numeric value

Buy Currency Code

Important: add a valid currency code here as the system does not search in the Currency entity to find a match, it just saves the value added.

Buy Exchange Rate

Numeric value – exchange rate between buy and main currency

Buy Total Price

Numeric value

Other Cost Unit Price

Numeric value

Other Cost Tax Name and Other Cost Tax Percentage

Search for Tax by name (code), percentage, and type contains ‘B’; if no Tax is found, a new tax is saved with type ‘B’.

Buy Other Cost Commission Percentage

Numeric value (represents percentage value)

Commission Paid on Price Excluding Tax

The values for this column are true or false.

Sell Unit Price

Numeric value

Sell Tax Name and Sell Tax Percentage

Search for Tax by name (code), percentage, and type contains ‘S’; if no Tax is found, a new tax is saved with type ‘S’.

Sell Commission Percentage

Numeric value (represents percentage value)

Sell Currency Code

Important: add a valid currency code here as the system does not search in the Currency entity to find a match, it just saves the value added.

Sell Exchange Rate

Numeric value – exchange rate between sell and main currency

Sell Total Price

Numeric value

Profit Percentage

Numeric value (represents percentage value)

Margin Percentage

Numeric value (represents percentage value)

Remarks

Alphanumeric values and symbols (Price remarks text)

Min Pax and Max Pax

(minimum/maximum number of persons)

Numeric value

Min Adults and Max Adults

(minimum/maximum number of adults)

Numeric value

Max Children

(maximum number of children)

Numeric value

Max Infants

(maximum number of infants)

Numeric value

Max Babies

(maximum number of babies)

Numeric value

Supplier Price Code

Alphanumeric values and symbols

Duration

Numeric value

FreeSales

The values for this column are true or false.

Embark Address ID and Embark Location

When the Embark Address ID is provided, Victoury searches for the address:

• If the address is found, it is set for Embark Address and for the Embark Location (price embark address name).
• If not found, then the price embark Address is not set and the price embark Location will be the value from column DB (Embark location).

When the Embark Address ID is not provided:

• The price embark Address is not set and the price embark Location = column DB (Embark location).

Disembark Address ID and Disembark Location

When the Disembark Address ID is provided, Victoury searches for the address:

• If found, it sets both the price disembark Address and price disembark Location (price disembark location address name).
• If not found, then the price disembark Address will not be set and the price disembark Location will be the value from column DD (Disembark location).

When the Disembark Address ID is not provided:

• The price disembark Address will not be set and the price disembark Location = column DD (Disembark location).

Create Automatic Order

The values for this column are true or false.

Calculate Margin with Buy Ex Tax

The values for this column are true or false.

Catalog Price

Numeric value

Publish On the Web

The values for this column are true or false.

Type

ENUM field where the value must be one of the following: V, B, C.

Position

Numeric value

Backoffice Reference

Alphanumeric values and symbols (This is a unique value. Victoury does not allow duplicate Backoffice Reference codes).

Source

ENUM field where the value must be one of the following: 0 – for Local or 1 for Host2Host.

Auto Sell Tax

The values for this column are true or false.

Start Time

00:00

End Time

23:59

Source Name

Alphanumeric values and symbols

Min Booking Change Quantity

The values for this column are true or false.

Min Booking Quantity

Numeric value

Buy Exchange Rate SC

Numeric value – exchange rate between buy and sell currency – in case of sell prices added in foreign currency this is usually different from Buy Exchange Rate field value

Unsupported Fields

Export/Import data from Excel (import Product/Prices) does not support the following fields:

For Product:

• Booking Restrictions
• Allotment Type
• Asset – by asset ID
• Address – by supplier Address ID
• Trip – by trip ID

For Price:

• Supplier – by supplier ID
• Source