VCT @ Import products and prices from Excel_v9.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Product ID	Product Code	Brand	Visited Areas	Supplier ID	Supplier Name	Supplier Product Code	Product Name	Category	Country Area	Charge nights	Rating	Type	Duration days	Duration nights	Book daily	Book day of week	Has Occupancy	Max Age C	Max Age I	Max Age B	Min Age S	Embark Address ID	Embark location	Disembark Address ID	Disembark location	Create voucher	Order Text	Order Remarks	Number OF Seats	Max Persons	GroupCode	Has Allotments	Show Availability when B	Exclude FromTotal	Remarks	Catalog page	Flag	Budget	Publish On Web	GPS Location	Voucher Text	Voucher Remarks	Travel Remarks	Source	Backoffice Reference	Host2Host	Print	SeoFriendlyName	Locked	Block Date Begin	Block Date End	Block Date Type	Block Date Description	Block Days	Block Days Type	Block Days Start Time	Block Days End Time	Block Days Time Type	Price ID	Season begin	Season end	Book begin	Book end	Price type 1	Price type 2	Price type 3	Price type 4	Price description	typeDescription	Is per person	One time charge	Buy unit price	Buy tax code	Buy tax percentage	Buy Comission Percentage	Buy currency code	Buy currency exchange rate	Buy price included tax	Buy other unit price	Buy other tax code	Buy other tax percentage	Buy other Comission Percentage	Commision paid on price excluding tax	Sell unit price	Sell tax code	Sell tax percentage	Sell Comission Percentage	Sell currency code	Sell currency exchange rate	Sell price included tax	Profit percentage	Margin percentage	Remarks	Min Pax	Max Pax	Min A	Max A	Max C	Max I
2	0 or empty for new product foreach distinct "Product Code" >0 for existing product to be updated; if no product found, ignore the row		List<String> All product_brands codes separated by comma. When import delete existing product_brands and import provided ones. When cell empty delete existing ones from VCT.	List<String> All product_visited_areas codes separated by comma. When import delete existing product_visited_areas and import provided ones. When cell empty delete existing ones from VCT.	Supplier ID added - VCT product list will display the Supplier ID so that the Operator can add it to the excel Supplier Name - in case there is no Supplier ID but there is a Name, a new Supplier will be created and the ID assigned to product - supplier_id. In case both ID and Name are added - ID will be assigned, Name should be ignored. In case no ID nor Name is added - supplier_id will be NULL.				choicelist code	choicelist code	(true/false)	choicelist code	ARRANGEMENT, ITINERARY, BOTH	important for packages – 10 days that may mean 8 nights because of travel – numeric value	important for packages – 10 days that may mean 8 nights because of travel – numeric value	(true/false)	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	(true/false)	numeric value	numeric value	numeric value	numeric value	Embark Address ID added - VCT product list will display the Address ID so that the Operator can add it to the excel When Embark Address ID provided: search for address - if found, then set it to product.embarkAddress and product.embarkLocation = product.embarkAddress.name - if not found, then product.embarkAddress = null and product.embarkLocation = column Y (Embark location) When Embark Address ID not provided: - product.embarkAddress = null and product.embarkLocation = column Y (Embark location)		Disembark Address ID added - VCT product list will display the Address ID so that the Operator can add it to the excel When Disembark Address ID provided: search for address - if found, then set it to product.disembarkAddress and product.disembarkLocation = product.disembarkAddress.name - if not found, then product.disembarkAddress = null and product.disembarkLocation = column AA (Disembark location) When Disembark Address ID not provided: - product.disembarkAddress = null and product.disembarkLocation = column AA (Disembark location)		(true/false)	string value	string value	numeric value	numeric value	string value	(true/false)	(true/false)	(true/false)	string value	numeric value	string value	string value	true/false	string value	string value	string value	string value	string value	string value (this value is unique)	(true/false)	(true/false)	string value (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)	(true/false)	YYYY-MM-DD 2019-01-01	YYYY-MM-DD 2019-01-31	ENUM field where value must be one of the following: END, BEGINOREND, INRANGE	string value	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	ENUM field where value must be one of the following: BEGINDAYINDAYS, ENDDAYINDAYS, BEGINDAYNOTINDAYS, ENDDAYNOTINDAYS, BOTHINDAYS, BOTHNOTINDAYS	HH-MM 00:00	HH-MM 23:59	ENUM field where value must be one of the following: BEGIN, END	0 or empty for new price >0 for existing price to be updated; if no price found, ignore the row	YYYY-MM-DD 2019-01-01	YYYY-MM-DD 2019-01-31	YYYY-MM-DD 2019-01-01	YYYY-MM-DD 2019-01-31	choicelist code	choicelist code	choicelist code	choicelist code	string value	string value	(true/false)	(true/false)	numeric value	Search for Tax by name(code), percentage and type contains 'B'; if no Tax found save a new tax with type 'B'		numeric value	1. search currency by code and exchangeRate like "provided_value%" if currency found -> set currencyID = id of found currency; set currencyCode = provided currency code; set currencyExchangeRate = exchange rate from found currency if no currency is found → go to point 2 2. search currency by code and valid at import date if currency found -> set currencyID = id of found currency; set currencyCode = provided currency code; set currencyExchangeRate = exchange rate from found currency if no currency is found -> create new currency record: currencyCode = provided currency code; currencyExchangeRate = provided currency exchangeRate season_begin = season_begin from provided price; season_end = null; archived = false	numeric value	numeric value	numeric value	Search for Tax by name(code), percentage and type contains 'B'; if no Tax found save a new tax with type 'B'		numeric value (represents percentage value)	(true/false)	numeric value	Search for Tax by name(code), percentage and type contains 'S'; if no Tax found save a new tax with type 'S'		numeric value (represents percentage value)	1. search currency by code and exchangeRate like "provided_value%" if currency found -> set currencyID = id of found currency; set currencyCode = provided currency code; set currencyExchangeRate = exchange rate from found currency if no currency is found → go to point 2 2. search currency by code and valid at import date if currency found -> set currencyID = id of found currency; set currencyCode = provided currency code; set currencyExchangeRate = exchange rate from found currency if no currency is found -> create new currency record: currencyCode = provided currency code; currencyExchangeRate = provided currency exchangeRate season_begin = season_begin from provided price; season_end = null; archived = false	numeric value	numeric value	numeric value (represents percentage value)	numeric value (represents percentage value)	string value	numeric value	numeric value	numeric value	numeric value	numeric value	numeric value
3	product.id	product.productCode	product.productBrands	product.visitedAreas	product.supplier	product.supplier.customer.companyName1	product.supplierProductCode	product.name	product.category	product.countryArea	product.chargeNights	product.rating	product.type	product.durationDays	product.durationNights	product.bookDaily	product.weekDays	product.hasOccupancy	product.maxChildAge	product.maxInfantAge	product.maxBabyAge	product.minSeniorAge	product.embarkAddress	product.embarkLocation	product.disembarkAddress	product.disembarkLocation	product.createVoucher	product.orderText	product.orderRemarks	product.numberOfSeats	product.maxPersons	product.groupCode	product.hasAllotments	product.showAvailabilityWhenBooking	product.excludeFromTotal	product.remarks	product.catalogPage	product.flag	product.budget	product.publishOnWeb	product.gpsLocation	product.voucherText	product.voucherRemarks	product.travelRemarks	product.source	product.backofficereference	product.host2Host	product.print	product.seoFriendlyName	product.locked	product.blockDateBegin	product.blockDateEnd	product.blockDateType	product.blockDateDescription	product.blockDays	product.blockDaysType	product.blockDaysStartTime	product.blockDaysEndTime	product.blockDaysTimeType	price.id	price.seasonBegin	price.seasonEnd	price.bookBegin	price.bookEnd	price.priceType1	price.priceType2	price.priceType3	price.priceType4	price.description	price.typeDescription	price.isPerPerson	price.oneTimeCharge	price.buyUnitPrice	price.buyTax.name	price.buyTax.percentage	price.buyCommissionPercentage	price.buyCurrency.code	price.buyExchangeRate	price.buyTotalPrice	price.otherCostUnitPrice	price.otherCostTax.name	price.otherCostTax.percentage	price.otherCostCommissionPercentage	price.commissionPaidOnPriceExTax	price.sellUnitPrice	price.sellTax.name	price.sellTax.percentage	price.sellCommissionPercentage	price.sellCurrency.code	price.sellExchangeRate	price.sellTotalPrice	price.profit	price.margin	price.remarks	price.minPersons	price.maxPersons	price.minAdults	price.maxAdults	price.maxChildren	price.maxInfants
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100