Details
Date	2015-04-28 11:12:30 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 405 lines
2015-04-28	11:12:30	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-04-28	11:12:30	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-04-28	11:12:47	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-04-28	11:12:47	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-04-28	11:12:47	0	[DEBUG]	Found field delimiter: ;
2015-04-28	11:12:47	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-04-28	11:12:47	0	[QUERY]	SELECT `a`.`csvi_name` FROM `y9zak_csvi_availablefields` AS `a` LEFT JOIN `y9zak_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'product' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-04-28	11:12:47	0	[DEBUG]	Load the fields to process
2015-04-28	11:12:47	0	[DEBUG]	Setup field: product_sku
2015-04-28	11:12:47	0	[DEBUG]	Setup field: product_parent_sku
2015-04-28	11:12:47	0	[DEBUG]	Setup field: custom_title
2015-04-28	11:12:47	0	[DEBUG]	Setup field: custom_value
2015-04-28	11:12:47	0	[DEBUG]	Setup field: custom_ordering
2015-04-28	11:12:47	0	[DEBUG]	Setup field: custom_price
2015-04-28	11:12:47	0	[DEBUG]	Setup field: multi_variant_title
2015-04-28	11:12:47	0	[DEBUG]	Setup field: multi_variant_fields
2015-04-28	11:12:47	0	[DEBUG]	Setup field: COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:47	0	[DEBUG]	Use the file for configuration
2015-04-28	11:12:47	0	[DEBUG]	==========
2015-04-28	11:12:47	0	[DEBUG]	CSVI Pro Version: 6.0
2015-04-28	11:12:47	0	[DEBUG]	PHP version: 5.5.6
2015-04-28	11:12:47	0	[DEBUG]	Action: import
2015-04-28	11:12:47	0	[DEBUG]	Component: com_virtuemart
2015-04-28	11:12:47	0	[DEBUG]	Operation: product
2015-04-28	11:12:47	0	[DEBUG]	Source: fromupload
2015-04-28	11:12:47	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1430219558/child2.csv
2015-04-28	11:12:47	0	[DEBUG]	Load from server:
2015-04-28	11:12:47	0	[DEBUG]	Delete after import: No
2015-04-28	11:12:47	0	[DEBUG]	Load from URL:
2015-04-28	11:12:47	0	[DEBUG]	FTP Host:
2015-04-28	11:12:47	0	[DEBUG]	FTP Port:
2015-04-28	11:12:47	0	[DEBUG]	FTP Root Folder:
2015-04-28	11:12:47	0	[DEBUG]	FTP Filename:
2015-04-28	11:12:47	0	[DEBUG]	Auto detect delimiters: Yes
2015-04-28	11:12:47	0	[DEBUG]	Field Delimiter: comma
2015-04-28	11:12:47	0	[DEBUG]	Text Enclosure:
2015-04-28	11:12:47	0	[DEBUG]	Use file extension:
2015-04-28	11:12:47	0	[DEBUG]	I'm Mac: No
2015-04-28	11:12:47	0	[DEBUG]	Use file for configuration: Yes
2015-04-28	11:12:47	0	[DEBUG]	Add extra fields: No
2015-04-28	11:12:47	0	[DEBUG]	Skip first line: No
2015-04-28	11:12:47	0	[DEBUG]	Overwrite existing data: Yes
2015-04-28	11:12:47	0	[DEBUG]	Skip new items: No
2015-04-28	11:12:47	0	[DEBUG]	Record name:
2015-04-28	11:12:47	0	[DEBUG]	Language: en-GB
2015-04-28	11:12:47	0	[DEBUG]	Category separator: \
2015-04-28	11:12:47	0	[DEBUG]	Append categories: No
2015-04-28	11:12:47	0	[DEBUG]	Import based on: product_sku
2015-04-28	11:12:47	0	[DEBUG]	Unpublish before import: No
2015-04-28	11:12:47	0	[DEBUG]	Recreate alias: No
2015-04-28	11:12:47	0	[DEBUG]	Force stockable parent update: No
2015-04-28	11:12:47	0	[DEBUG]	Use ICEcat data: No
2015-04-28	11:12:47	0	[DEBUG]	Similar SKU search: No
2015-04-28	11:12:47	0	[DEBUG]	Process images: No
2015-04-28	11:12:47	0	[DEBUG]	Location product files:
2015-04-28	11:12:47	0	[DEBUG]	Delete image relations: No
2015-04-28	11:12:47	0	[DEBUG]	Create image name: No
2015-04-28	11:12:47	0	[DEBUG]	Image name based on: product_sku
2015-04-28	11:12:47	0	[DEBUG]	Image name format: jpg
2015-04-28	11:12:47	0	[DEBUG]	Change case: none
2015-04-28	11:12:47	0	[DEBUG]	Fill media fields: No
2015-04-28	11:12:47	0	[DEBUG]	Keep original file: No
2015-04-28	11:12:47	0	[DEBUG]	Convert image type: none
2015-04-28	11:12:47	0	[DEBUG]	Save images on server: No
2015-04-28	11:12:47	0	[DEBUG]	Re-download image: Yes
2015-04-28	11:12:47	0	[DEBUG]	Resize large image: No
2015-04-28	11:12:47	0	[DEBUG]	Full image width:
2015-04-28	11:12:47	0	[DEBUG]	Full image height:
2015-04-28	11:12:47	0	[DEBUG]	Check filetype: No
2015-04-28	11:12:47	0	[DEBUG]	Automatic thumbnail creation: No
2015-04-28	11:12:47	0	[DEBUG]	Thumbnail type: none
2015-04-28	11:12:47	0	[DEBUG]	Thumbnail width: 90
2015-04-28	11:12:47	0	[DEBUG]	Thumbnail height: 90
2015-04-28	11:12:47	0	[DEBUG]	Maximum width resize: 1024
2015-04-28	11:12:47	0	[DEBUG]	Maximum height resize: 768
2015-04-28	11:12:47	0	[DEBUG]	Watermark: No
2015-04-28	11:12:47	0	[DEBUG]	Right margin:
2015-04-28	11:12:47	0	[DEBUG]	Bottom margin:
2015-04-28	11:12:47	0	[DEBUG]	Image:
2015-04-28	11:12:47	0	[DEBUG]	Lines per import: 400
2015-04-28	11:12:47	0	[DEBUG]	Time between imports: 5
2015-04-28	11:12:47	0	[DEBUG]	Override system limits?: Yes
2015-04-28	11:12:47	0	[DEBUG]	Maximum execution time: 60
2015-04-28	11:12:47	0	[DEBUG]	Maximum amount of memory:
2015-04-28	11:12:47	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-04-28	11:12:47	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-04-28	11:12:47	0	[DEBUG]	==========
2015-04-28	11:12:47	0	[DEBUG]	Setting system limits:
2015-04-28	11:12:47	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-04-28	11:12:47	0	[DEBUG]	Setting max_execution_time to 60 seconds
2015-04-28	11:12:47	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-04-28	11:12:47	0	[DEBUG]	Load the custom fields
2015-04-28	11:12:47	0	[QUERY]	SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `y9zak_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X')
2015-04-28	11:12:47	1	[DEBUG]	Use field value for field product_sku
2015-04-28	11:12:47	1	[DEBUG]	Use default value for field product_parent_sku
2015-04-28	11:12:47	1	[DEBUG]	Use field value for field custom_title
2015-04-28	11:12:47	1	[DEBUG]	Use field value for field custom_value
2015-04-28	11:12:47	1	[DEBUG]	Use default value for field custom_ordering
2015-04-28	11:12:47	1	[DEBUG]	Use default value for field custom_price
2015-04-28	11:12:47	1	[DEBUG]	Use field value for field multi_variant_title
2015-04-28	11:12:47	1	[DEBUG]	Use field value for field multi_variant_fields
2015-04-28	11:12:47	1	[DEBUG]	Use default value for field COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:47	1	[DEBUG]	Process line 1
2015-04-28	11:12:47	1	[DEBUG]	Check if the vendor exists
2015-04-28	11:12:47	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AU-14'
2015-04-28	11:12:47	1	[DEBUG]	Load a row
2015-04-28	11:12:47	1	[DEBUG]	Product tax
2015-04-28	11:12:47	1	[DEBUG]	Query for Product
2015-04-28	11:12:47	1	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='2351',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-21 14:54:37',`created_by`='937',`modified_on`='2015-04-28 11:12:47',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AU-14'
2015-04-28	11:12:47	1	[DEBUG]	Check product language entry
2015-04-28	11:12:47	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:47	1	[DEBUG]	Load a row
2015-04-28	11:12:47	1	[DEBUG]	Query for ProductLang
2015-04-28	11:12:47	1	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='
Set of 4 pcs (2 Front / 2 Rear)
Warranty: ONE Year Strut Oil leaking
',`product_desc`='',`product_name`='Audi A4 B5 (2WD) 95~00 K-Sport Coilover Suspension',`metadesc`='Audi A4 B5 (2WD) 95~00 K-Sport Coilover Suspension',`metakey`='audi,a4,b5,2wd,95~00,k-sport,coilover,suspension',`customtitle`='',`slug`='audi-a4-b5-2wd-95-00-k-sport-coilover-suspension' WHERE `virtuemart_product_id`='2351'
2015-04-28	11:12:47	1	[DEBUG]	Checking manufacturer
2015-04-28	11:12:47	1	[DEBUG]	Find the custom field ID
2015-04-28	11:12:47	1	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'product_categories' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	1	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	1	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351 AND `virtuemart_custom_id` = 16
2015-04-28	11:12:48	1	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	1	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('2351','16','COM_VIRTUEMART_CFVALUE_SUSPENSIONS','','0','0','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','')
2015-04-28	11:12:48	1	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	1	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,1,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Size Chart
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Body Style
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Video
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Model
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Engine
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: Year
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: product_categories
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-04-28	11:12:48	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-04-28	11:12:48	1	[DEBUG]	Process multi-variant fields
2015-04-28	11:12:48	1	[DEBUG]	Find the multi variant custom field entry
2015-04-28	11:12:48	1	[QUERY]	SELECT `virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'coilver' AND `field_type` = 'C'
2015-04-28	11:12:48	1	[DEBUG]	Find the multi variant product entry
2015-04-28	11:12:48	1	[QUERY]	SELECT `virtuemart_customfield_id` FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351 AND `virtuemart_custom_id` = 24
2015-04-28	11:12:48	1	[DEBUG]	Store the updated customfield_params
2015-04-28	11:12:48	1	[QUERY]	UPDATE `y9zak_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"COM_VIRTUEMART_CF_EDITION\",\"values\":\"\"}]|clabels=0|options={\"2351\":[\"\"]}|' WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field product_sku
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field product_parent_sku
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field custom_title
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field custom_value
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field custom_ordering
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field custom_price
2015-04-28	11:12:48	2	[DEBUG]	Use default value for field multi_variant_title
2015-04-28	11:12:48	2	[DEBUG]	Use default value for field multi_variant_fields
2015-04-28	11:12:48	2	[DEBUG]	Use field value for field COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:48	2	[DEBUG]	Process line 2
2015-04-28	11:12:48	2	[DEBUG]	Load a row
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	2	[QUERY]	SELECT * FROM y9zak_virtuemart_products WHERE `product_sku` = 'K-AU-14-STREET'
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	2	[QUERY]	SELECT `virtuemart_product_id` FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AU-14'
2015-04-28	11:12:48	2	[DEBUG]	Product tax
2015-04-28	11:12:48	2	[DEBUG]	Query for Product
2015-04-28	11:12:48	2	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3347',`virtuemart_vendor_id`='1',`product_parent_id`='2351',`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-27 18:58:24',`created_by`='937',`modified_on`='2015-04-28 11:12:47',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AU-14-STREET'
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_NO_PARENT_VALUE_FOUND
2015-04-28	11:12:48	2	[QUERY]	SELECT customfield_params FROM y9zak_virtuemart_product_customfields WHERE virtuemart_product_id = 2351 AND customfield_value = 'stockable'
2015-04-28	11:12:48	2	[DEBUG]	Check product language entry
2015-04-28	11:12:48	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3347
2015-04-28	11:12:48	2	[DEBUG]	Load a row
2015-04-28	11:12:48	2	[DEBUG]	Query for ProductLang
2015-04-28	11:12:48	2	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='
Set of 4 pcs (2 Front / 2 Rear)
Warranty: ONE Year Strut Oil leaking
',`product_desc`='',`product_name`='Audi A4 B5 (2WD) 95~00 STREET K-Sport Coilover Suspension',`metadesc`='Audi A4 B5 (2WD) 95~00 STREET K-Sport Coilover Suspension',`metakey`='audi,a4,b5,2wd,95~00,street,k-sport,coilover,suspension',`customtitle`='',`slug`='audi-a4-b5-2wd-95-00-street-k-sport-coilover-suspension' WHERE `virtuemart_product_id`='3347'
2015-04-28	11:12:48	2	[DEBUG]	Checking manufacturer
2015-04-28	11:12:48	2	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	2	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_FRONTMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	2	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	2	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3347 AND `virtuemart_custom_id` = 21
2015-04-28	11:12:48	2	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3347','21','ALUMINIUM','0','0','0','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','1')
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,2,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	2	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	2	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_REARMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	2	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	2	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3347 AND `virtuemart_custom_id` = 22
2015-04-28	11:12:48	2	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3347','22','ALUMINIUM','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','2')
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,2,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	2	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	2	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_INVERTED' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	2	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	2	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3347 AND `virtuemart_custom_id` = 23
2015-04-28	11:12:48	2	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3347','23','STANDARD UPRIGHT','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','3')
2015-04-28	11:12:48	2	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	2	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,2,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Size Chart
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Body Style
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Video
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Model
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Engine
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: Year
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: product_categories
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-04-28	11:12:48	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-04-28	11:12:48	2	[DEBUG]	Process multi-variant fields
2015-04-28	11:12:48	2	[DEBUG]	Load the existing customfield_params for product parent
2015-04-28	11:12:48	2	[QUERY]	SELECT `customfield_params` FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	2	[DEBUG]	Store the updated customfield_params
2015-04-28	11:12:48	2	[QUERY]	UPDATE `y9zak_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"COM_VIRTUEMART_CF_EDITION\",\"values\":\"\\r\\nSTREET\"}]|clabels=0|options={\"2351\":[\"\"],\"3347\":[\"STREET\"]}|' WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field product_sku
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field product_parent_sku
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field custom_title
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field custom_value
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field custom_ordering
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field custom_price
2015-04-28	11:12:48	3	[DEBUG]	Use default value for field multi_variant_title
2015-04-28	11:12:48	3	[DEBUG]	Use default value for field multi_variant_fields
2015-04-28	11:12:48	3	[DEBUG]	Use field value for field COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:48	3	[DEBUG]	Process line 3
2015-04-28	11:12:48	3	[DEBUG]	Load a row
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	3	[QUERY]	SELECT * FROM y9zak_virtuemart_products WHERE `product_sku` = 'K-AU-14-SPORT'
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	3	[QUERY]	SELECT `virtuemart_product_id` FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AU-14'
2015-04-28	11:12:48	3	[DEBUG]	Product tax
2015-04-28	11:12:48	3	[DEBUG]	Query for Product
2015-04-28	11:12:48	3	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3348',`virtuemart_vendor_id`='1',`product_parent_id`='2351',`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-27 18:58:24',`created_by`='937',`modified_on`='2015-04-28 11:12:47',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AU-14-SPORT'
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_NO_PARENT_VALUE_FOUND
2015-04-28	11:12:48	3	[QUERY]	SELECT customfield_params FROM y9zak_virtuemart_product_customfields WHERE virtuemart_product_id = 2351 AND customfield_value = 'stockable'
2015-04-28	11:12:48	3	[DEBUG]	Check product language entry
2015-04-28	11:12:48	3	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3348
2015-04-28	11:12:48	3	[DEBUG]	Load a row
2015-04-28	11:12:48	3	[DEBUG]	Query for ProductLang
2015-04-28	11:12:48	3	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='
Set of 4 pcs (2 Front / 2 Rear)
Warranty: ONE Year Strut Oil leaking
',`product_desc`='',`product_name`='Audi A4 B5 (2WD) 95~00 SPORT K-Sport Coilover Suspension',`metadesc`='Audi A4 B5 (2WD) 95~00 SPORT K-Sport Coilover Suspension',`metakey`='audi,a4,b5,2wd,95~00,sport,k-sport,coilover,suspension',`customtitle`='',`slug`='audi-a4-b5-2wd-95-00-sport-k-sport-coilover-suspension' WHERE `virtuemart_product_id`='3348'
2015-04-28	11:12:48	3	[DEBUG]	Checking manufacturer
2015-04-28	11:12:48	3	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	3	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_FRONTMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	3	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	3	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3348 AND `virtuemart_custom_id` = 21
2015-04-28	11:12:48	3	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3348','21','ALUMINIUM','0','0','0','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','1')
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,3,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	3	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	3	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_REARMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	3	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	3	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3348 AND `virtuemart_custom_id` = 22
2015-04-28	11:12:48	3	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3348','22','ALUMINIUM','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','2')
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,3,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	3	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	3	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_INVERTED' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	3	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	3	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3348 AND `virtuemart_custom_id` = 23
2015-04-28	11:12:48	3	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3348','23','STANDARD UPRIGHT','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','3')
2015-04-28	11:12:48	3	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	3	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,3,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Size Chart
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Body Style
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Video
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Model
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Engine
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: Year
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: product_categories
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-04-28	11:12:48	3	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-04-28	11:12:48	3	[DEBUG]	Process multi-variant fields
2015-04-28	11:12:48	3	[DEBUG]	Load the existing customfield_params for product parent
2015-04-28	11:12:48	3	[QUERY]	SELECT `customfield_params` FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	3	[DEBUG]	Store the updated customfield_params
2015-04-28	11:12:48	3	[QUERY]	UPDATE `y9zak_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"COM_VIRTUEMART_CF_EDITION\",\"values\":\"\\r\\nSTREET\\r\\nSPORT\"}]|clabels=0|options={\"2351\":[\"\"],\"3347\":[\"STREET\"],\"3348\":[\"SPORT\"]}|' WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field product_sku
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field product_parent_sku
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field custom_title
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field custom_value
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field custom_ordering
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field custom_price
2015-04-28	11:12:48	4	[DEBUG]	Use default value for field multi_variant_title
2015-04-28	11:12:48	4	[DEBUG]	Use default value for field multi_variant_fields
2015-04-28	11:12:48	4	[DEBUG]	Use field value for field COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:48	4	[DEBUG]	Process line 4
2015-04-28	11:12:48	4	[DEBUG]	Load a row
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	4	[QUERY]	SELECT * FROM y9zak_virtuemart_products WHERE `product_sku` = 'K-AU-14-CIRCUIT'
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	4	[QUERY]	SELECT `virtuemart_product_id` FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AU-14'
2015-04-28	11:12:48	4	[DEBUG]	Product tax
2015-04-28	11:12:48	4	[DEBUG]	Query for Product
2015-04-28	11:12:48	4	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3349',`virtuemart_vendor_id`='1',`product_parent_id`='2351',`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-27 18:58:24',`created_by`='937',`modified_on`='2015-04-28 11:12:47',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AU-14-CIRCUIT'
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_NO_PARENT_VALUE_FOUND
2015-04-28	11:12:48	4	[QUERY]	SELECT customfield_params FROM y9zak_virtuemart_product_customfields WHERE virtuemart_product_id = 2351 AND customfield_value = 'stockable'
2015-04-28	11:12:48	4	[DEBUG]	Check product language entry
2015-04-28	11:12:48	4	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3349
2015-04-28	11:12:48	4	[DEBUG]	Load a row
2015-04-28	11:12:48	4	[DEBUG]	Query for ProductLang
2015-04-28	11:12:48	4	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='
Set of 4 pcs (2 Front / 2 Rear)
Warranty: ONE Year Strut Oil leaking
',`product_desc`='',`product_name`='Audi A4 B5 (2WD) 95~00 CIRCUIT K-Sport Coilover Suspension',`metadesc`='Audi A4 B5 (2WD) 95~00 CIRCUIT K-Sport Coilover Suspension',`metakey`='audi,a4,b5,2wd,95~00,circuit,k-sport,coilover,suspension',`customtitle`='',`slug`='audi-a4-b5-2wd-95-00-circuit-k-sport-coilover-suspension' WHERE `virtuemart_product_id`='3349'
2015-04-28	11:12:48	4	[DEBUG]	Checking manufacturer
2015-04-28	11:12:48	4	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	4	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_FRONTMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	4	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	4	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3349 AND `virtuemart_custom_id` = 21
2015-04-28	11:12:48	4	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3349','21','ALUMINIUM','0','0','0','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','1')
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,4,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	4	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	4	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_REARMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	4	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	4	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3349 AND `virtuemart_custom_id` = 22
2015-04-28	11:12:48	4	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3349','22','ALUMINIUM','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','2')
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,4,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	4	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	4	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_INVERTED' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	4	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	4	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3349 AND `virtuemart_custom_id` = 23
2015-04-28	11:12:48	4	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3349','23','STANDARD UPRIGHT','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','3')
2015-04-28	11:12:48	4	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	4	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,4,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Size Chart
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Body Style
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Video
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Model
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Engine
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: Year
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: product_categories
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-04-28	11:12:48	4	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-04-28	11:12:48	4	[DEBUG]	Process multi-variant fields
2015-04-28	11:12:48	4	[DEBUG]	Load the existing customfield_params for product parent
2015-04-28	11:12:48	4	[QUERY]	SELECT `customfield_params` FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	4	[DEBUG]	Store the updated customfield_params
2015-04-28	11:12:48	4	[QUERY]	UPDATE `y9zak_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"COM_VIRTUEMART_CF_EDITION\",\"values\":\"\\r\\nSTREET\\r\\nSPORT\\r\\nCIRCUIT\"}]|clabels=0|options={\"2351\":[\"\"],\"3347\":[\"STREET\"],\"3348\":[\"SPORT\"],\"3349\":[\"CIRCUIT\"]}|' WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field product_sku
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field product_parent_sku
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field custom_title
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field custom_value
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field custom_ordering
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field custom_price
2015-04-28	11:12:48	5	[DEBUG]	Use default value for field multi_variant_title
2015-04-28	11:12:48	5	[DEBUG]	Use default value for field multi_variant_fields
2015-04-28	11:12:48	5	[DEBUG]	Use field value for field COM_VIRTUEMART_CF_EDITION
2015-04-28	11:12:48	5	[DEBUG]	Process line 5
2015-04-28	11:12:48	5	[DEBUG]	Load a row
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	5	[QUERY]	SELECT * FROM y9zak_virtuemart_products WHERE `product_sku` = 'K-AU-14-RALLYASPHALT'
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-04-28	11:12:48	5	[QUERY]	SELECT `virtuemart_product_id` FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AU-14'
2015-04-28	11:12:48	5	[DEBUG]	Product tax
2015-04-28	11:12:48	5	[DEBUG]	Query for Product
2015-04-28	11:12:48	5	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3350',`virtuemart_vendor_id`='1',`product_parent_id`='2351',`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-27 18:58:24',`created_by`='937',`modified_on`='2015-04-28 11:12:47',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AU-14-RALLYASPHALT'
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_NO_PARENT_VALUE_FOUND
2015-04-28	11:12:48	5	[QUERY]	SELECT customfield_params FROM y9zak_virtuemart_product_customfields WHERE virtuemart_product_id = 2351 AND customfield_value = 'stockable'
2015-04-28	11:12:48	5	[DEBUG]	Check product language entry
2015-04-28	11:12:48	5	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3350
2015-04-28	11:12:48	5	[DEBUG]	Load a row
2015-04-28	11:12:48	5	[DEBUG]	Query for ProductLang
2015-04-28	11:12:48	5	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='
Set of 4 pcs (2 Front / 2 Rear)
Warranty: ONE Year Strut Oil leaking
',`product_desc`='',`product_name`='Audi A4 B5 (2WD) 95~00 RALLY ASPHALT K-Sport Coilover Suspension',`metadesc`='Audi A4 B5 (2WD) 95~00 RALLY ASPHALT K-Sport Coilover Suspension',`metakey`='audi,a4,b5,2wd,95~00,rally,asphalt,k-sport,coilover,suspension',`customtitle`='',`slug`='audi-a4-b5-2wd-95-00-rally-asphalt-k-sport-coilover-suspension' WHERE `virtuemart_product_id`='3350'
2015-04-28	11:12:48	5	[DEBUG]	Checking manufacturer
2015-04-28	11:12:48	5	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	5	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_FRONTMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	5	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	5	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3350 AND `virtuemart_custom_id` = 21
2015-04-28	11:12:48	5	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3350','21','ALUMINIUM','0','0','0','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','1')
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,5,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	5	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	5	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_REARMOUNT' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	5	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	5	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3350 AND `virtuemart_custom_id` = 22
2015-04-28	11:12:48	5	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3350','22','ALUMINIUM','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','2')
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,5,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	5	[DEBUG]	Find the custom field ID
2015-04-28	11:12:48	5	[QUERY]	SELECT `custom_parent_id`,`virtuemart_custom_id` FROM `y9zak_virtuemart_customs` WHERE `custom_title` = 'COM_VIRTUEMART_CF_INVERTED' AND `field_type` NOT IN ('C','R','Z')
2015-04-28	11:12:48	5	[DEBUG]	Remove existing customfield values
2015-04-28	11:12:48	5	[QUERY]	DELETE FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3350 AND `virtuemart_custom_id` = 23
2015-04-28	11:12:48	5	[DEBUG]	Query for ProductCustomfield
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`disabler`,`override`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`ordering`) VALUES ('3350','23','STANDARD UPRIGHT','0','0','0','','1','2015-04-28 11:12:47','937','2015-04-28 11:12:47','937','0000-00-00 00:00:00','0','3')
2015-04-28	11:12:48	5	[DEBUG]	COM_CSVI_DEBUG_CUSTOMFIELD_QUERY
2015-04-28	11:12:48	5	[QUERY]	INSERT INTO `y9zak_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (131,5,'Product custom field reference added','Success','Added','Product custom fields')
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Size Chart
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Body Style
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Video
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Model
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Engine
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: Year
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: product_categories
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-04-28	11:12:48	5	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-04-28	11:12:48	5	[DEBUG]	Process multi-variant fields
2015-04-28	11:12:48	5	[DEBUG]	Load the existing customfield_params for product parent
2015-04-28	11:12:48	5	[QUERY]	SELECT `customfield_params` FROM `y9zak_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2351
2015-04-28	11:12:48	5	[DEBUG]	Store the updated customfield_params
2015-04-28	11:12:48	5	[QUERY]	UPDATE `y9zak_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"COM_VIRTUEMART_CF_EDITION\",\"values\":\"\\r\\nSTREET\\r\\nSPORT\\r\\nCIRCUIT\\r\\nRALLY ASPHALT\"}]|clabels=0|options={\"2351\":[\"\"],\"3347\":[\"STREET\"],\"3348\":[\"SPORT\"],\"3349\":[\"CIRCUIT\"],\"3350\":[\"RALLY ASPHALT\"]}|' WHERE `virtuemart_product_id` = 2351