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.
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
The Currency is searched by code, valid at the import time; if no Currency is found, a new Currency is saved.
Buy Exchange Rate
Numeric value
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
The Currency is searched by code, valid at the import time; if no Currency is found, a new Currency is saved.
Sell Exchange Rate
Numeric value
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
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
