REPLACE INTO Product
(
	ProductID,
	ProductGroupID,
	ProductName,
	ProductDescription,
	Keywords,
	Active,
	Colour,
	Materials,
	IsSale,
	IsNew,
	IsEco,
	IsExpress,
	IsReach,
	ShowOnWeb,
	ImageFileName,
	VideoFileName,
	Dimensions,
	Weight,
	MaximumWeight,
	Volume,
	LogoPosition,
	UVMaximumPrintArea,
	PrintArea,
	PrintCode,
	BrandingMethods,
	Plain100,
	Plain250,
	Plain500,
	Plain1000,
	Screenprint100,
	Screenprint250,
	Screenprint500,
	Screenprint1000,
	UV100,
	UV250,
	UV500,
	UV1000,
	UpsellProductGroupID,
	DownsellProductGroupID,
	TariffCode,
	CountryOfOrigin,
	CarbonGMPerPiece
)
VALUES
(
	'{{{ProductID}}}',
	'{{{ProductGroupID}}}',
	'{{{ProductName}}}',
	TRIM('{{{ProductDescription}}}'),
	'{{{Keywords}}}',
	'{{{Active}}}',
	'{{{Colour}}}',
	'{{{Materials}}}',
	'{{{IsSale}}}',
	'{{{IsNew}}}',
	'{{{IsEco}}}',
	'{{{IsExpress}}}',
	'{{{IsReach}}}',
	'{{{ShowOnWeb}}}',
	'{{{ImageFileName}}}',
	'{{{VideoFileName}}}',
	'{{{Dimensions}}}',
	'{{{Weight}}}',
	'{{{MaximumWeight}}}',
	'{{{Volume}}}',
	'{{{LogoPosition}}}',
	'{{{UVMaximumPrintArea}}}',
	'{{{PrintArea}}}',
	'{{{PrintCode}}}',
	'{{{BrandingMethods}}}',
	IF('{{{Plain100}}}'='','0','{{{Plain100}}}'),
	IF('{{{Plain250}}}'='','0','{{{Plain250}}}'),
	IF('{{{Plain500}}}'='','0','{{{Plain500}}}'),
	IF('{{{Plain1000}}}'='','0','{{{Plain1000}}}'),
	IF('{{{ScreenPrint100}}}'='','0','{{{ScreenPrint100}}}'),
	IF('{{{ScreenPrint250}}}'='','0','{{{ScreenPrint250}}}'),
	IF('{{{ScreenPrint500}}}'='','0','{{{ScreenPrint500}}}'),
	IF('{{{ScreenPrint1000}}}'='','0','{{{ScreenPrint1000}}}'),
	IF('{{{UV100}}}'='','0','{{{UV100}}}'),
	IF('{{{UV250}}}'='','0','{{{UV250}}}'),
	IF('{{{UV500}}}'='','0','{{{UV500}}}'),
	IF('{{{UV1000}}}'='','0','{{{UV1000}}}'),
	IF('{{{UpsellProductGroupID}}}'='', NULL, '{{{UpsellProductGroupID}}}'),
	IF('{{{DownsellProductGroupID}}}'='', NULL, '{{{DownsellProductGroupID}}}'),
	'{{{TariffCode}}}',
	'{{{CountryOfOrigin}}}',
	IF('{{{CarbonGMPerPiece}}}'='', NULL, '{{{CarbonGMPerPiece}}}')
)