All Collections
Operations
Export and import products and prices from Excel
Export and import products and prices from Excel
Kinga-Laura Ambrus avatar
Written by Kinga-Laura Ambrus
Updated over a week ago

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 may be used for the Import feature as it has the same structure as the import requires.

The import feature is found in main left menu, Products and Prices list when click on edit sign.

Excel file with explanation of fields

See file here

Excel file details

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

You may import at once more products, each product with more than one price.

For importing a product with more then 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 next rows, in case you need to enter 10 prices for the same product - you must copy - paste the same information of all the 13 Product columns in 10 lines and then fill out the Price related columns for each line separately.

When you have finished filling in 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 to be completed 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 for which TRUE or FALSE is required must me completed with 1 of these 2 values, without exception.

Each product has to have at least 1 price for which Season begin/Season end, Book begin/Book end dates must be filled in, otherwise the import will throw an error.


Columns of the excel file explained

Product ID

For new products to be created, this column should be left empty or filled with 0 (zero) as value.

For updating an existing product, the ID of the product from Victoury must be present in this field.

If you fill in the ID and this ID is not found in Victoury, this row will be ignored.

Product Code

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

If no ID is filled in, a new product is created with this Product code.

If no ID is filled in and the product code already exists in Victoury, error is returned.

Product related data update does not happen by identification based on product code.

NOTE: Victoury does not allow duplicate product codes, thus your product codes should be unique.

Brand

The value to be filled in in this column is the code of the brand as it is defined in the Brands Choice list.

Visited Areas

The value to be filled in in this column are the codes of the Visited Areas as it is defined in the Visited_Areas Choice list.

Supplier ID

The value to be filled in this column is the ID of the Supplier

Supplier Name

If there is no Supplier ID filled in the Supplier ID column, but there is a name in the Supplier Name column, a new supplier will be created and the ID of the new supplier is assigned to the product.

In case both, the ID and the Name of the supplier are added – the ID of the Supplier will be assigned to the product and the Name is ignored.

In case no Supplier ID nor Name is added – supplier id will be NULL for this product.

Supplier Product Code

Alphanumeric values and symbols

Product Name

Alphanumeric values and symbols

Category

The value to be filled in this column is the Choice list code from the Product_Category choicelist

Country Area

The value to be filled in this column is the Choice list code from the Country_Area choicelist

Is Package

The values to be filled in this column are true or false. True in case the product is a package, False if not a package.

Charge Nights

The values to be filled in this column are true or false

Rating

The value to be filled in this column is the Choice list code from the Product_Rating choicelist

Type

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

Duration days

Numeric values

Duration nights

Numeric values

Book daily

The values to be filled in this column are true or false

Book day of week

The format of the cell needs to be modified before editing to TEXT instead of NUMBER. 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 to be filled in this column are true or false

Max Age C

Numeric values representing Child maximum age

Max Age I

Numeric values representing Infant maximum age

Max Age B

Numeric values representing Babies maximum age

Min Age S

Numeric values representing Seniors minimum age

Embark Address ID and Embark location

Embark Address ID added in Victoury

When Embark Address ID provided Victoury searches for address

- if the address is found, then it is set for Embark Address and for Embark Location (product embark address name)

- if not found, then product embark Address is not set and product embark Location will be the value from column X (Embark location)

When Embark Address ID not provided:

- product embark Address is not set and product embark Location = column Y (Embark location)

Disembark Address ID and Disembark location

When Disembark Address ID provided Victoury searches for address

- if found, then set it to product disembark Address and product disembark Location ( product disembark location address name)

- if not found, then product disembark Address will not be set and product disembark Location will be the value from column Z (Disembark location)

When Disembark Address ID not provided:

- product disembark Address will not be set and product disembark Location = column AA (Disembark location)

Create voucher

The values to be filled in 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

Allow Overbooking

The values to be filled in this column are true or false

Has Allotments

The values to be filled in this column are true or false

Show Availability when B

(Show Availability when Booking)

The values to be filled in this column are true or false

Exclude FromTotal

The values to be filled in 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 web

The values to be filled in 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 to be filled in this column are true or false

Print

The values to be filled in this column are true or false

SeoFriendlyName

Alphanumeric values and symbols (text)

(this value is unique, will be generated automatically from the name of the product, when product is saved, if the value of this field is not present)

Locked

The values to be filled in this column are true or false

Block Date Begin

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

Block Date End

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

Block Date Type

ENUM field where value must be one of the following: END, BEGINOREND, INRANGE

Block Date Description

Alphanumeric values and symbols (text)

Block Days

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

Block Days Type

ENUM field where value must be one of the following: BEGINDAYINDAYS, ENDDAYINDAYS, BEGINDAYNOTINDAYS, ENDDAYNOTINDAYS, BOTHINDAYS, BOTHNOTINDAYS

Block Days Start Time

00:00

Block Days End Time

23:59

Block Days Time Type

ENUM field where value must be one of the following: BEGIN, END

Price ID

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

- price ID for existing price to be updated; if no price found, ignore the row

- the ID of the price must be related to the product (to not belong to another product that the one set on the same row).

Otherwise, exception is thrown by the system as priceID does not belong to 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 to be filled in this columns are the Choice list codes for the entries under Price_Type_1

Price type 2

The values to be filled in this columns are the Choice list codes for the entries under Price_Type_2

Price type 3

The values to be filled in this columns are the Choice list codes for the entries under Price_Type_3

Price type 4

The values to be filled in this columns are the Choice list codes for the entries under Price_Type_4

Price description

Alphanumeric values and symbols (text)

typeDescription

Alphanumeric values and symbols

Is per person

The values to be filled in this column are true or false

One time charge

The values to be filled in 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 found a new tax is saved with type 'B'

Buy Commission Percentage

Numeric value

Buy currency code

It is searched the Currency by code, valid at the import time; if no Currency is found, a new Currency is saved

Buy currency exchange rate

Numeric value

Buy price included tax

Numeric value

Buy other unit price

Numeric value

Buy other tax code and Buy other tax percentage

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

Buy Other Commission Percentage

Numeric value (represents percentage value)

Commission paid on price excluding tax

The values to be filled in this column are true or false

Sell unit price

Numeric value

Sell tax code and Sell tax percentage

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

Sell Commission percentage

Numeric value (represents percentage value)

Sell currency code

It is searched the Currency by code, valid at the import time; if no Currency is found, a new Currency is saved

Sell currency exchange rate

Numeric value

Sell price included tax

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

(minim/maximum number of persons)

Numeric value

Min A and Max A

(minim/maximum number of adults)

Numeric value

Max C

(maximum number of children)

Numeric value

Max I

(maximum number of infants)

Numeric value

Max B

(maximum number of babies)

Numeric value

Supplier_price_code

Alphanumeric values and symbols

Duration

Numeric value

FreeSales

The values to be filled in this column are true or false

Embark Address ID and Embark location

Embark Address ID added in Victoury

When Embark Address ID provided Victoury searches for address

- if the address is found, then it is set for Embark Address and for Embark Location (price embark address name)

- if not found, then price embark Address is not set and price embark Location will be the value from column DB (Embark location)

When Embark Address ID not provided:

- price embark Address is not set and price embark Location = column DB (Embark location)

Disembark Address ID and Disembark location

When Disembark Address ID provided Victoury searches for address

- if found, then set it to price disembark Address and price disembark Location (price disembark location address name)

- if not found, then price disembark Address will not be set and price disembark Location will be the value from column DD (Disembark location)

When Disembark Address ID not provided:

- price disembark Address will not be set and price disembark Location = column DD (Disembark location)

Create Automatic order

The values to be filled in this column are true or false

Calc Margin with Buy Ex Tax

The values to be filled in this column are true or false

Catalog Price

Numeric value

Publish On Web

The values to be filled in this column are true or false

Type

ENUM field where 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 value must be one of the following: 0 - for Local or 1 for Host2Host

Auto Sell Tax

The values to be filled in this column are true or false

Start Time

00:00

End Time

23:59

Source Name

Alphanumeric values and symbols

minBookingChangeQuantity

The values to be filled in this column are true or false

minBookingQuantity

Numeric value

Mention!

Import data from excel (import Product/Prices) does not support the below fields

for Product:

- allotment Type

- Asset - by asset ID

- Address - by supplier Address ID

- Trip - by trip ID

for Price:

- Supplier - by supplier ID

- source

Did this answer your question?