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
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