Details
Date	2015-06-30 16:25:06 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 1098 lines
2015-06-30	16:25:06	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	1	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	1	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	3	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	3	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	5	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	5	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	7	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	7	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	9	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	9	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:25:06	11	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:25:06	11	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	1	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	1	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	3	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	3	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	5	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	5	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	7	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	7	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	9	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	9	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:34:22	11	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-06-30	16:34:22	11	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:16:25	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-07-02	18:16:25	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:17:06	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-07-02	18:17:06	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:17:06	0	[DEBUG]	Found field delimiter: ,
2015-07-02	18:17:06	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-02	18:17:06	0	[QUERY]	SELECT `a`.`csvi_name` FROM `w3094_csvi_availablefields` AS `a` LEFT JOIN `w3094_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-07-02	18:17:06	0	[DEBUG]	Load the fields to process
2015-07-02	18:17:06	0	[DEBUG]	Field name: product_sku
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 2 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: product_parent_sku
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 1 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: product_name
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 3 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: category_path
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 4 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: product_price
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 6 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: product_override_price
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 5 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: published
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 11 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: multi_variant_title
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 8 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	Field name: multi_variant_fields
2015-07-02	18:17:06	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 7 ORDER BY `csvi_templatefields_rule_id`
2015-07-02	18:17:06	0	[DEBUG]	==========
2015-07-02	18:17:06	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-02	18:17:06	0	[DEBUG]	PHP version: 5.4.42
2015-07-02	18:17:06	0	[DEBUG]	Action: import
2015-07-02	18:17:06	0	[DEBUG]	Component: com_virtuemart
2015-07-02	18:17:06	0	[DEBUG]	Operation: product
2015-07-02	18:17:06	0	[DEBUG]	Source: fromupload
2015-07-02	18:17:06	0	[DEBUG]	Load from computer: /home/mynewsit/public_html/lambretta/tmp/com_csvi/1435860993/MV-Product.csv
2015-07-02	18:17:06	0	[DEBUG]	Load from server:
2015-07-02	18:17:06	0	[DEBUG]	Delete after import: No
2015-07-02	18:17:06	0	[DEBUG]	Load from URL:
2015-07-02	18:17:06	0	[DEBUG]	FTP Host:
2015-07-02	18:17:06	0	[DEBUG]	FTP Port:
2015-07-02	18:17:06	0	[DEBUG]	FTP Root Folder:
2015-07-02	18:17:06	0	[DEBUG]	FTP Filename:
2015-07-02	18:17:06	0	[DEBUG]	Auto detect delimiters: Yes
2015-07-02	18:17:06	0	[DEBUG]	Field Delimiter: comma
2015-07-02	18:17:06	0	[DEBUG]	Text Enclosure:
2015-07-02	18:17:06	0	[DEBUG]	Use file extension:
2015-07-02	18:17:06	0	[DEBUG]	I'm Mac: No
2015-07-02	18:17:06	0	[DEBUG]	Use file for configuration: No
2015-07-02	18:17:06	0	[DEBUG]	Add extra fields: No
2015-07-02	18:17:06	0	[DEBUG]	Skip first line: Yes
2015-07-02	18:17:06	0	[DEBUG]	Overwrite existing data: Yes
2015-07-02	18:17:06	0	[DEBUG]	Skip new items: No
2015-07-02	18:17:06	0	[DEBUG]	Record name:
2015-07-02	18:17:06	0	[DEBUG]	Language: en-GB
2015-07-02	18:17:06	0	[DEBUG]	Category separator: /
2015-07-02	18:17:06	0	[DEBUG]	Append categories: No
2015-07-02	18:17:06	0	[DEBUG]	Import based on: product_sku
2015-07-02	18:17:06	0	[DEBUG]	Unpublish before import: No
2015-07-02	18:17:06	0	[DEBUG]	Recreate alias: No
2015-07-02	18:17:06	0	[DEBUG]	Force stockable parent update: No
2015-07-02	18:17:06	0	[DEBUG]	Use ICEcat data: No
2015-07-02	18:17:06	0	[DEBUG]	Similar SKU search: No
2015-07-02	18:17:06	0	[DEBUG]	Process images: Yes
2015-07-02	18:17:06	0	[DEBUG]	Location product files:
2015-07-02	18:17:06	0	[DEBUG]	Delete image relations: No
2015-07-02	18:17:06	0	[DEBUG]	Create image name: No
2015-07-02	18:17:06	0	[DEBUG]	Image name based on: product_sku
2015-07-02	18:17:06	0	[DEBUG]	Image name format: jpg
2015-07-02	18:17:06	0	[DEBUG]	Change case: none
2015-07-02	18:17:06	0	[DEBUG]	Fill media fields: No
2015-07-02	18:17:06	0	[DEBUG]	Keep original file: No
2015-07-02	18:17:06	0	[DEBUG]	Convert image type: none
2015-07-02	18:17:06	0	[DEBUG]	Save images on server: No
2015-07-02	18:17:06	0	[DEBUG]	Re-download image: Yes
2015-07-02	18:17:06	0	[DEBUG]	Resize large image: No
2015-07-02	18:17:06	0	[DEBUG]	Full image width:
2015-07-02	18:17:06	0	[DEBUG]	Full image height:
2015-07-02	18:17:06	0	[DEBUG]	Check filetype: No
2015-07-02	18:17:06	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-02	18:17:06	0	[DEBUG]	Thumbnail type: none
2015-07-02	18:17:06	0	[DEBUG]	Thumbnail width: 90
2015-07-02	18:17:06	0	[DEBUG]	Thumbnail height: 90
2015-07-02	18:17:06	0	[DEBUG]	Maximum width resize: 1024
2015-07-02	18:17:06	0	[DEBUG]	Maximum height resize: 768
2015-07-02	18:17:06	0	[DEBUG]	Watermark: No
2015-07-02	18:17:06	0	[DEBUG]	Right margin:
2015-07-02	18:17:06	0	[DEBUG]	Bottom margin:
2015-07-02	18:17:06	0	[DEBUG]	Image:
2015-07-02	18:17:06	0	[DEBUG]	Lines per import: 1000
2015-07-02	18:17:06	0	[DEBUG]	Time between imports: 5
2015-07-02	18:17:06	0	[DEBUG]	Override system limits?: No
2015-07-02	18:17:06	0	[DEBUG]	Maximum execution time:
2015-07-02	18:17:06	0	[DEBUG]	Maximum amount of memory:
2015-07-02	18:17:06	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-02	18:17:06	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-02	18:17:06	0	[DEBUG]	==========
2015-07-02	18:17:06	0	[DEBUG]	Load the custom fields
2015-07-02	18:17:06	0	[QUERY]	SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `w3094_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X')
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	1	[DEBUG]	Use default value for field product_parent_sku
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field category_path
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	1	[DEBUG]	Use default value for field multi_variant_title
2015-07-02	18:17:06	1	[DEBUG]	Use field value for field multi_variant_fields
2015-07-02	18:17:06	1	[DEBUG]	Process line 1
2015-07-02	18:17:06	1	[DEBUG]	Check if the vendor exists
2015-07-02	18:17:06	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	1	[DEBUG]	Load a row
2015-07-02	18:17:06	1	[DEBUG]	Processing item: AC-T1
2015-07-02	18:17:06	1	[DEBUG]	Product tax:
2015-07-02	18:17:06	1	[DEBUG]	Query for Product
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','AC-T1','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	1	[DEBUG]	Check product language entry
2015-07-02	18:17:06	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	1	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt' AND `virtuemart_product_id` != 784
2015-07-02	18:17:06	1	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt' AND `virtuemart_product_id` != 784
2015-07-02	18:17:06	1	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (784, 'test-t-shirt')
2015-07-02	18:17:06	1	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	1	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt' WHERE `virtuemart_product_id`='784'
2015-07-02	18:17:06	1	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	1	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 784 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	1	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('784','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	1	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	1	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,1,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	1	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	1	[DEBUG]	Find the multi variant custom field entry
2015-07-02	18:17:06	1	[QUERY]	SELECT `virtuemart_custom_id` FROM `w3094_virtuemart_customs` WHERE `custom_title` = '' AND `field_type` = 'C'
2015-07-02	18:17:06	1	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	1	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"784\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	1	[DEBUG]	Checking category
2015-07-02	18:17:06	1	[DEBUG]	Check if category path exists: Test T Shirts
2015-07-02	18:17:06	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `w3094_virtuemart_categories` AS `c` LEFT JOIN `w3094_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `w3094_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Test T Shirts' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2015-07-02	18:17:06	1	[DEBUG]	COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2015-07-02	18:17:06	1	[QUERY]	DELETE FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	1	[DEBUG]	COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
2015-07-02	18:17:06	1	[QUERY]	SELECT COUNT(*) AS total FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 784 AND `virtuemart_category_id` = 11
2015-07-02	18:17:06	1	[DEBUG]	COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
2015-07-02	18:17:06	1	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('784','11')
2015-07-02	18:17:06	1	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2015-07-02	18:17:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('784','11')
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	2	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	2	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	2	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	2	[DEBUG]	Process line 2
2015-07-02	18:17:06	2	[DEBUG]	Load a row
2015-07-02	18:17:06	2	[DEBUG]	Processing item: AC-T1-Blue-small
2015-07-02	18:17:06	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	2	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	2	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	2	[DEBUG]	Product tax:
2015-07-02	18:17:06	2	[DEBUG]	Query for Product
2015-07-02	18:17:06	2	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-Blue-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	2	[DEBUG]	No parent found
2015-07-02	18:17:06	2	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	2	[DEBUG]	Check product language entry
2015-07-02	18:17:06	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 785
2015-07-02	18:17:06	2	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	2	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-small' AND `virtuemart_product_id` != 785
2015-07-02	18:17:06	2	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	2	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-small' AND `virtuemart_product_id` != 785
2015-07-02	18:17:06	2	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	2	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (785, 'test-t-shirt-blue-small')
2015-07-02	18:17:06	2	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	2	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-small' WHERE `virtuemart_product_id`='785'
2015-07-02	18:17:06	2	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	2	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 785 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	2	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	2	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('785','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	2	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	2	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	2	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,2,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	2	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	2	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	2	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	2	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	2	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"785\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	3	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	3	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	3	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	3	[DEBUG]	Process line 3
2015-07-02	18:17:06	3	[DEBUG]	Load a row
2015-07-02	18:17:06	3	[DEBUG]	Processing item: AC-T1-blue-med
2015-07-02	18:17:06	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	3	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	3	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	3	[DEBUG]	Product tax:
2015-07-02	18:17:06	3	[DEBUG]	Query for Product
2015-07-02	18:17:06	3	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-blue-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	3	[DEBUG]	No parent found
2015-07-02	18:17:06	3	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	3	[DEBUG]	Check product language entry
2015-07-02	18:17:06	3	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 786
2015-07-02	18:17:06	3	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	3	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-medium' AND `virtuemart_product_id` != 786
2015-07-02	18:17:06	3	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	3	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-medium' AND `virtuemart_product_id` != 786
2015-07-02	18:17:06	3	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	3	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (786, 'test-t-shirt-blue-medium')
2015-07-02	18:17:06	3	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	3	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-medium' WHERE `virtuemart_product_id`='786'
2015-07-02	18:17:06	3	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	3	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 786 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	3	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	3	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('786','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	3	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	3	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	3	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,3,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	3	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	3	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	3	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	3	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	3	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"786\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	4	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	4	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	4	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	4	[DEBUG]	Process line 4
2015-07-02	18:17:06	4	[DEBUG]	Load a row
2015-07-02	18:17:06	4	[DEBUG]	Processing item: AC-T1-blue-large
2015-07-02	18:17:06	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	4	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	4	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	4	[DEBUG]	Product tax:
2015-07-02	18:17:06	4	[DEBUG]	Query for Product
2015-07-02	18:17:06	4	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-blue-large','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	4	[DEBUG]	No parent found
2015-07-02	18:17:06	4	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	4	[DEBUG]	Check product language entry
2015-07-02	18:17:06	4	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 787
2015-07-02	18:17:06	4	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	4	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-large' AND `virtuemart_product_id` != 787
2015-07-02	18:17:06	4	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	4	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-large' AND `virtuemart_product_id` != 787
2015-07-02	18:17:06	4	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	4	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (787, 'test-t-shirt-blue-large')
2015-07-02	18:17:06	4	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	4	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Large',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-large' WHERE `virtuemart_product_id`='787'
2015-07-02	18:17:06	4	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	4	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 787 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	4	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	4	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('787','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	4	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	4	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	4	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,4,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	4	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	4	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	4	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	4	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	4	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"787\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	5	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	5	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	5	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	5	[DEBUG]	Process line 5
2015-07-02	18:17:06	5	[DEBUG]	Load a row
2015-07-02	18:17:06	5	[DEBUG]	Processing item: AC-T1-blue-xl
2015-07-02	18:17:06	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	5	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	5	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	5	[DEBUG]	Product tax:
2015-07-02	18:17:06	5	[DEBUG]	Query for Product
2015-07-02	18:17:06	5	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-blue-xl','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	5	[DEBUG]	No parent found
2015-07-02	18:17:06	5	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	5	[DEBUG]	Check product language entry
2015-07-02	18:17:06	5	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 788
2015-07-02	18:17:06	5	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	5	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-xl' AND `virtuemart_product_id` != 788
2015-07-02	18:17:06	5	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	5	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-xl' AND `virtuemart_product_id` != 788
2015-07-02	18:17:06	5	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	5	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (788, 'test-t-shirt-blue-xl')
2015-07-02	18:17:06	5	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	5	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue XL',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-xl' WHERE `virtuemart_product_id`='788'
2015-07-02	18:17:06	5	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	5	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 788 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	5	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	5	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('788','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	5	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	5	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	5	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,5,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	5	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	5	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	5	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	5	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	5	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"788\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	6	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	6	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	6	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	6	[DEBUG]	Process line 6
2015-07-02	18:17:06	6	[DEBUG]	Load a row
2015-07-02	18:17:06	6	[DEBUG]	Processing item: AC-T1-red-small
2015-07-02	18:17:06	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	6	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	6	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	6	[DEBUG]	Product tax:
2015-07-02	18:17:06	6	[DEBUG]	Query for Product
2015-07-02	18:17:06	6	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-red-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	6	[DEBUG]	No parent found
2015-07-02	18:17:06	6	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	6	[DEBUG]	Check product language entry
2015-07-02	18:17:06	6	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 789
2015-07-02	18:17:06	6	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	6	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-small' AND `virtuemart_product_id` != 789
2015-07-02	18:17:06	6	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	6	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-small' AND `virtuemart_product_id` != 789
2015-07-02	18:17:06	6	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	6	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (789, 'test-t-shirt-red-small')
2015-07-02	18:17:06	6	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	6	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-small' WHERE `virtuemart_product_id`='789'
2015-07-02	18:17:06	6	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	6	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 789 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	6	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	6	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('789','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	6	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	6	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	6	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,6,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	6	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	6	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	6	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	6	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	6	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"789\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	7	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	7	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	7	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	7	[DEBUG]	Process line 7
2015-07-02	18:17:06	7	[DEBUG]	Load a row
2015-07-02	18:17:06	7	[DEBUG]	Processing item: AC-T1-red-med
2015-07-02	18:17:06	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	7	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	7	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	7	[DEBUG]	Product tax:
2015-07-02	18:17:06	7	[DEBUG]	Query for Product
2015-07-02	18:17:06	7	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-red-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	7	[DEBUG]	No parent found
2015-07-02	18:17:06	7	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	7	[DEBUG]	Check product language entry
2015-07-02	18:17:06	7	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 790
2015-07-02	18:17:06	7	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	7	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-medium' AND `virtuemart_product_id` != 790
2015-07-02	18:17:06	7	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	7	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-medium' AND `virtuemart_product_id` != 790
2015-07-02	18:17:06	7	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	7	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (790, 'test-t-shirt-red-medium')
2015-07-02	18:17:06	7	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	7	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-medium' WHERE `virtuemart_product_id`='790'
2015-07-02	18:17:06	7	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	7	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 790 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	7	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	7	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('790','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	7	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	7	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	7	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,7,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	7	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	7	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	7	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	7	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	7	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"790\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	8	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	8	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	8	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	8	[DEBUG]	Process line 8
2015-07-02	18:17:06	8	[DEBUG]	Load a row
2015-07-02	18:17:06	8	[DEBUG]	Processing item: AC-T1-red-large
2015-07-02	18:17:06	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	8	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	8	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	8	[DEBUG]	Product tax:
2015-07-02	18:17:06	8	[DEBUG]	Query for Product
2015-07-02	18:17:06	8	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-red-large','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	8	[DEBUG]	No parent found
2015-07-02	18:17:06	8	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	8	[DEBUG]	Check product language entry
2015-07-02	18:17:06	8	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 791
2015-07-02	18:17:06	8	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	8	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-large' AND `virtuemart_product_id` != 791
2015-07-02	18:17:06	8	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	8	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-large' AND `virtuemart_product_id` != 791
2015-07-02	18:17:06	8	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	8	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (791, 'test-t-shirt-red-large')
2015-07-02	18:17:06	8	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	8	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Large',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-large' WHERE `virtuemart_product_id`='791'
2015-07-02	18:17:06	8	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	8	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 791 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	8	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	8	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('791','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	8	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	8	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	8	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,8,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	8	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	8	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	8	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	8	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	8	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"791\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	9	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	9	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	9	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	9	[DEBUG]	Process line 9
2015-07-02	18:17:06	9	[DEBUG]	Load a row
2015-07-02	18:17:06	9	[DEBUG]	Processing item: AC-T1-white-small
2015-07-02	18:17:06	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	9	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	9	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	9	[DEBUG]	Product tax:
2015-07-02	18:17:06	9	[DEBUG]	Query for Product
2015-07-02	18:17:06	9	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-white-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	9	[DEBUG]	No parent found
2015-07-02	18:17:06	9	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	9	[DEBUG]	Check product language entry
2015-07-02	18:17:06	9	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 792
2015-07-02	18:17:06	9	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	9	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-small' AND `virtuemart_product_id` != 792
2015-07-02	18:17:06	9	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	9	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-small' AND `virtuemart_product_id` != 792
2015-07-02	18:17:06	9	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	9	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (792, 'test-t-shirt-white-small')
2015-07-02	18:17:06	9	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	9	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt White Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-white-small' WHERE `virtuemart_product_id`='792'
2015-07-02	18:17:06	9	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	9	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 792 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	9	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	9	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('792','0','19.99','1','11.00','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	9	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	9	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	9	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,9,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	9	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	9	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	9	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	9	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	9	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"792\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field product_sku
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field product_name
2015-07-02	18:17:06	10	[DEBUG]	Use default value for field category_path
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field product_price
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field published
2015-07-02	18:17:06	10	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:17:06	10	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:17:06	10	[DEBUG]	Process line 10
2015-07-02	18:17:06	10	[DEBUG]	Load a row
2015-07-02	18:17:06	10	[DEBUG]	Processing item: AC-T1-white-med
2015-07-02	18:17:06	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	10	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:17:06	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:17:06	10	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:17:06	10	[DEBUG]	Product tax:
2015-07-02	18:17:06	10	[DEBUG]	Query for Product
2015-07-02	18:17:06	10	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','784','AC-T1-white-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-02 18:17:06','708','2015-07-02 18:17:06','708','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	10	[DEBUG]	No parent found
2015-07-02	18:17:06	10	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:17:06	10	[DEBUG]	Check product language entry
2015-07-02	18:17:06	10	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 793
2015-07-02	18:17:06	10	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	10	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-medium' AND `virtuemart_product_id` != 793
2015-07-02	18:17:06	10	[DEBUG]	Check if the product slug exists
2015-07-02	18:17:06	10	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-medium' AND `virtuemart_product_id` != 793
2015-07-02	18:17:06	10	[DEBUG]	Insert the dummy entry for the product language
2015-07-02	18:17:06	10	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (793, 'test-t-shirt-white-medium')
2015-07-02	18:17:06	10	[DEBUG]	Query for ProductLang
2015-07-02	18:17:06	10	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt White Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-white-medium' WHERE `virtuemart_product_id`='793'
2015-07-02	18:17:06	10	[DEBUG]	Finding a product_price_id
2015-07-02	18:17:06	10	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 793 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-02	18:17:06	10	[DEBUG]	Query for ProductPrice
2015-07-02	18:17:06	10	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('793','0','19.99','1','11.00','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-02	18:17:06	10	[DEBUG]	Checking manufacturer
2015-07-02	18:17:06	10	[DEBUG]	No custom available fields found
2015-07-02	18:17:06	10	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,10,'Product price added','Success','Added','Product prices')
2015-07-02	18:17:06	10	[DEBUG]	Process multi-variant fields
2015-07-02	18:17:06	10	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:17:06	10	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:17:06	10	[DEBUG]	Store the updated customfield_params
2015-07-02	18:17:06	10	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"793\":[]}|' WHERE `virtuemart_product_id` = 784
2015-07-08	15:14:16	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-07-08	15:14:16	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-08	15:15:26	0	[DEBUG]	Clean up old logs. Found 1 logs and threshold is 25 logs
2015-07-08	15:15:26	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-08	15:15:26	0	[DEBUG]	Found field delimiter: ,
2015-07-08	15:15:26	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-08	15:15:26	0	[QUERY]	SELECT `a`.`csvi_name` FROM `w3094_csvi_availablefields` AS `a` LEFT JOIN `w3094_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-07-08	15:15:26	0	[DEBUG]	Load the fields to process
2015-07-08	15:15:26	0	[DEBUG]	Field name: product_sku
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 2 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: product_parent_sku
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 1 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: product_name
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 3 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: category_path
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 4 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: product_price
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 6 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: product_override_price
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 5 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: published
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 11 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: multi_variant_title
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 8 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	Field name: multi_variant_fields
2015-07-08	15:15:26	0	[QUERY]	SELECT `csvi_rule_id` FROM `w3094_csvi_templatefields_rules` WHERE `csvi_templatefield_id` = 7 ORDER BY `csvi_templatefields_rule_id`
2015-07-08	15:15:26	0	[DEBUG]	==========
2015-07-08	15:15:26	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-08	15:15:26	0	[DEBUG]	PHP version: 5.4.42
2015-07-08	15:15:26	0	[DEBUG]	Action: import
2015-07-08	15:15:26	0	[DEBUG]	Component: com_virtuemart
2015-07-08	15:15:26	0	[DEBUG]	Operation: product
2015-07-08	15:15:26	0	[DEBUG]	Source: fromupload
2015-07-08	15:15:26	0	[DEBUG]	Load from computer: /home/mynewsit/public_html/lambretta/tmp/com_csvi/1436368509/MV-Product.csv
2015-07-08	15:15:26	0	[DEBUG]	Load from server:
2015-07-08	15:15:26	0	[DEBUG]	Delete after import: No
2015-07-08	15:15:26	0	[DEBUG]	Load from URL:
2015-07-08	15:15:26	0	[DEBUG]	FTP Host:
2015-07-08	15:15:26	0	[DEBUG]	FTP Port:
2015-07-08	15:15:26	0	[DEBUG]	FTP Root Folder:
2015-07-08	15:15:26	0	[DEBUG]	FTP Filename:
2015-07-08	15:15:26	0	[DEBUG]	Auto detect delimiters: Yes
2015-07-08	15:15:26	0	[DEBUG]	Field Delimiter: comma
2015-07-08	15:15:26	0	[DEBUG]	Text Enclosure:
2015-07-08	15:15:26	0	[DEBUG]	Use file extension:
2015-07-08	15:15:26	0	[DEBUG]	I'm Mac: No
2015-07-08	15:15:26	0	[DEBUG]	Use file for configuration: No
2015-07-08	15:15:26	0	[DEBUG]	Add extra fields: No
2015-07-08	15:15:26	0	[DEBUG]	Skip first line: Yes
2015-07-08	15:15:26	0	[DEBUG]	Overwrite existing data: Yes
2015-07-08	15:15:26	0	[DEBUG]	Skip new items: No
2015-07-08	15:15:26	0	[DEBUG]	Record name:
2015-07-08	15:15:26	0	[DEBUG]	Language: en-GB
2015-07-08	15:15:26	0	[DEBUG]	Category separator: /
2015-07-08	15:15:26	0	[DEBUG]	Append categories: No
2015-07-08	15:15:26	0	[DEBUG]	Import based on: product_sku
2015-07-08	15:15:26	0	[DEBUG]	Unpublish before import: No
2015-07-08	15:15:26	0	[DEBUG]	Recreate alias: No
2015-07-08	15:15:26	0	[DEBUG]	Force stockable parent update: No
2015-07-08	15:15:26	0	[DEBUG]	Use ICEcat data: No
2015-07-08	15:15:26	0	[DEBUG]	Similar SKU search: No
2015-07-08	15:15:26	0	[DEBUG]	Process images: Yes
2015-07-08	15:15:26	0	[DEBUG]	Location product files:
2015-07-08	15:15:26	0	[DEBUG]	Delete image relations: No
2015-07-08	15:15:26	0	[DEBUG]	Create image name: No
2015-07-08	15:15:26	0	[DEBUG]	Image name based on: product_sku
2015-07-08	15:15:26	0	[DEBUG]	Image name format: jpg
2015-07-08	15:15:26	0	[DEBUG]	Change case: none
2015-07-08	15:15:26	0	[DEBUG]	Fill media fields: No
2015-07-08	15:15:26	0	[DEBUG]	Keep original file: No
2015-07-08	15:15:26	0	[DEBUG]	Convert image type: none
2015-07-08	15:15:26	0	[DEBUG]	Save images on server: No
2015-07-08	15:15:26	0	[DEBUG]	Re-download image: Yes
2015-07-08	15:15:26	0	[DEBUG]	Resize large image: No
2015-07-08	15:15:26	0	[DEBUG]	Full image width:
2015-07-08	15:15:26	0	[DEBUG]	Full image height:
2015-07-08	15:15:26	0	[DEBUG]	Check filetype: No
2015-07-08	15:15:26	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-08	15:15:26	0	[DEBUG]	Thumbnail type: none
2015-07-08	15:15:26	0	[DEBUG]	Thumbnail width: 90
2015-07-08	15:15:26	0	[DEBUG]	Thumbnail height: 90
2015-07-08	15:15:26	0	[DEBUG]	Maximum width resize: 1024
2015-07-08	15:15:26	0	[DEBUG]	Maximum height resize: 768
2015-07-08	15:15:26	0	[DEBUG]	Watermark: No
2015-07-08	15:15:26	0	[DEBUG]	Right margin:
2015-07-08	15:15:26	0	[DEBUG]	Bottom margin:
2015-07-08	15:15:26	0	[DEBUG]	Image:
2015-07-08	15:15:26	0	[DEBUG]	Lines per import: 1000
2015-07-08	15:15:26	0	[DEBUG]	Time between imports: 5
2015-07-08	15:15:26	0	[DEBUG]	Override system limits?: No
2015-07-08	15:15:26	0	[DEBUG]	Maximum execution time:
2015-07-08	15:15:26	0	[DEBUG]	Maximum amount of memory:
2015-07-08	15:15:26	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-08	15:15:26	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-08	15:15:26	0	[DEBUG]	==========
2015-07-08	15:15:26	0	[DEBUG]	Load the custom fields
2015-07-08	15:15:26	0	[QUERY]	SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `w3094_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X')
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	1	[DEBUG]	Use default value for field product_parent_sku
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field category_path
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	1	[DEBUG]	Use default value for field multi_variant_title
2015-07-08	15:15:26	1	[DEBUG]	Use field value for field multi_variant_fields
2015-07-08	15:15:26	1	[DEBUG]	Process line 1
2015-07-08	15:15:26	1	[DEBUG]	Check if the vendor exists
2015-07-08	15:15:26	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	1	[DEBUG]	Load a row
2015-07-08	15:15:26	1	[DEBUG]	Processing item: AC-T1
2015-07-08	15:15:26	1	[DEBUG]	Product tax:
2015-07-08	15:15:26	1	[DEBUG]	Query for Product
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','AC-T1','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	1	[DEBUG]	Check product language entry
2015-07-08	15:15:26	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	1	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt' AND `virtuemart_product_id` != 804
2015-07-08	15:15:26	1	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt' AND `virtuemart_product_id` != 804
2015-07-08	15:15:26	1	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (804, 'test-t-shirt')
2015-07-08	15:15:26	1	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	1	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt' WHERE `virtuemart_product_id`='804'
2015-07-08	15:15:26	1	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	1	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 804 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	1	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('804','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	1	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	1	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,1,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	1	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	1	[DEBUG]	Find the multi variant custom field entry
2015-07-08	15:15:26	1	[QUERY]	SELECT `virtuemart_custom_id` FROM `w3094_virtuemart_customs` WHERE `custom_title` = '' AND `field_type` = 'C'
2015-07-08	15:15:26	1	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	1	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"804\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	1	[DEBUG]	Checking category
2015-07-08	15:15:26	1	[DEBUG]	Check if category path exists: Test T Shirts
2015-07-08	15:15:26	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `w3094_virtuemart_categories` AS `c` LEFT JOIN `w3094_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `w3094_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Test T Shirts' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2015-07-08	15:15:26	1	[DEBUG]	COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2015-07-08	15:15:26	1	[QUERY]	DELETE FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	1	[DEBUG]	COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
2015-07-08	15:15:26	1	[QUERY]	SELECT COUNT(*) AS total FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 804 AND `virtuemart_category_id` = 11
2015-07-08	15:15:26	1	[DEBUG]	COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
2015-07-08	15:15:26	1	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('804','11')
2015-07-08	15:15:26	1	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2015-07-08	15:15:26	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('804','11')
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	2	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	2	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	2	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	2	[DEBUG]	Process line 2
2015-07-08	15:15:26	2	[DEBUG]	Load a row
2015-07-08	15:15:26	2	[DEBUG]	Processing item: AC-T1-Blue-small
2015-07-08	15:15:26	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	2	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	2	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	2	[DEBUG]	Product tax:
2015-07-08	15:15:26	2	[DEBUG]	Query for Product
2015-07-08	15:15:26	2	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-Blue-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	2	[DEBUG]	No parent found
2015-07-08	15:15:26	2	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	2	[DEBUG]	Check product language entry
2015-07-08	15:15:26	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 805
2015-07-08	15:15:26	2	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	2	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-small' AND `virtuemart_product_id` != 805
2015-07-08	15:15:26	2	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	2	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-small' AND `virtuemart_product_id` != 805
2015-07-08	15:15:26	2	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	2	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (805, 'test-t-shirt-blue-small')
2015-07-08	15:15:26	2	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	2	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-small' WHERE `virtuemart_product_id`='805'
2015-07-08	15:15:26	2	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	2	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 805 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	2	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	2	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('805','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	2	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	2	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	2	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,2,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	2	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	2	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	2	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	2	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	2	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"805\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	3	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	3	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	3	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	3	[DEBUG]	Process line 3
2015-07-08	15:15:26	3	[DEBUG]	Load a row
2015-07-08	15:15:26	3	[DEBUG]	Processing item: AC-T1-blue-med
2015-07-08	15:15:26	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	3	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	3	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	3	[DEBUG]	Product tax:
2015-07-08	15:15:26	3	[DEBUG]	Query for Product
2015-07-08	15:15:26	3	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-blue-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	3	[DEBUG]	No parent found
2015-07-08	15:15:26	3	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	3	[DEBUG]	Check product language entry
2015-07-08	15:15:26	3	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 806
2015-07-08	15:15:26	3	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	3	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-medium' AND `virtuemart_product_id` != 806
2015-07-08	15:15:26	3	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	3	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-medium' AND `virtuemart_product_id` != 806
2015-07-08	15:15:26	3	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	3	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (806, 'test-t-shirt-blue-medium')
2015-07-08	15:15:26	3	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	3	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-medium' WHERE `virtuemart_product_id`='806'
2015-07-08	15:15:26	3	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	3	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 806 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	3	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	3	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('806','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	3	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	3	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	3	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,3,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	3	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	3	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	3	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	3	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	3	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"806\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	4	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	4	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	4	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	4	[DEBUG]	Process line 4
2015-07-08	15:15:26	4	[DEBUG]	Load a row
2015-07-08	15:15:26	4	[DEBUG]	Processing item: AC-T1-blue-large
2015-07-08	15:15:26	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	4	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	4	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	4	[DEBUG]	Product tax:
2015-07-08	15:15:26	4	[DEBUG]	Query for Product
2015-07-08	15:15:26	4	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-blue-large','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	4	[DEBUG]	No parent found
2015-07-08	15:15:26	4	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	4	[DEBUG]	Check product language entry
2015-07-08	15:15:26	4	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 807
2015-07-08	15:15:26	4	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	4	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-large' AND `virtuemart_product_id` != 807
2015-07-08	15:15:26	4	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	4	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-large' AND `virtuemart_product_id` != 807
2015-07-08	15:15:26	4	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	4	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (807, 'test-t-shirt-blue-large')
2015-07-08	15:15:26	4	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	4	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue Large',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-large' WHERE `virtuemart_product_id`='807'
2015-07-08	15:15:26	4	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	4	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 807 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	4	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	4	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('807','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	4	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	4	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	4	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,4,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	4	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	4	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	4	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	4	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	4	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"807\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	5	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	5	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	5	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	5	[DEBUG]	Process line 5
2015-07-08	15:15:26	5	[DEBUG]	Load a row
2015-07-08	15:15:26	5	[DEBUG]	Processing item: AC-T1-blue-xl
2015-07-08	15:15:26	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	5	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	5	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	5	[DEBUG]	Product tax:
2015-07-08	15:15:26	5	[DEBUG]	Query for Product
2015-07-08	15:15:26	5	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-blue-xl','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	5	[DEBUG]	No parent found
2015-07-08	15:15:26	5	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	5	[DEBUG]	Check product language entry
2015-07-08	15:15:26	5	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 808
2015-07-08	15:15:26	5	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	5	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-xl' AND `virtuemart_product_id` != 808
2015-07-08	15:15:26	5	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	5	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-blue-xl' AND `virtuemart_product_id` != 808
2015-07-08	15:15:26	5	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	5	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (808, 'test-t-shirt-blue-xl')
2015-07-08	15:15:26	5	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	5	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Blue XL',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-blue-xl' WHERE `virtuemart_product_id`='808'
2015-07-08	15:15:26	5	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	5	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 808 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	5	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	5	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('808','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	5	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	5	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	5	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,5,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	5	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	5	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	5	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	5	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	5	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"808\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	6	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	6	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	6	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	6	[DEBUG]	Process line 6
2015-07-08	15:15:26	6	[DEBUG]	Load a row
2015-07-08	15:15:26	6	[DEBUG]	Processing item: AC-T1-red-small
2015-07-08	15:15:26	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	6	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	6	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	6	[DEBUG]	Product tax:
2015-07-08	15:15:26	6	[DEBUG]	Query for Product
2015-07-08	15:15:26	6	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-red-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	6	[DEBUG]	No parent found
2015-07-08	15:15:26	6	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	6	[DEBUG]	Check product language entry
2015-07-08	15:15:26	6	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 809
2015-07-08	15:15:26	6	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	6	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-small' AND `virtuemart_product_id` != 809
2015-07-08	15:15:26	6	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	6	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-small' AND `virtuemart_product_id` != 809
2015-07-08	15:15:26	6	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	6	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (809, 'test-t-shirt-red-small')
2015-07-08	15:15:26	6	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	6	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-small' WHERE `virtuemart_product_id`='809'
2015-07-08	15:15:26	6	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	6	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 809 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	6	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	6	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('809','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	6	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	6	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	6	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,6,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	6	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	6	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	6	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	6	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	6	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"809\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	7	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	7	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	7	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	7	[DEBUG]	Process line 7
2015-07-08	15:15:26	7	[DEBUG]	Load a row
2015-07-08	15:15:26	7	[DEBUG]	Processing item: AC-T1-red-med
2015-07-08	15:15:26	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	7	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	7	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	7	[DEBUG]	Product tax:
2015-07-08	15:15:26	7	[DEBUG]	Query for Product
2015-07-08	15:15:26	7	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-red-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	7	[DEBUG]	No parent found
2015-07-08	15:15:26	7	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	7	[DEBUG]	Check product language entry
2015-07-08	15:15:26	7	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 810
2015-07-08	15:15:26	7	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	7	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-medium' AND `virtuemart_product_id` != 810
2015-07-08	15:15:26	7	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	7	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-medium' AND `virtuemart_product_id` != 810
2015-07-08	15:15:26	7	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	7	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (810, 'test-t-shirt-red-medium')
2015-07-08	15:15:26	7	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	7	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-medium' WHERE `virtuemart_product_id`='810'
2015-07-08	15:15:26	7	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	7	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 810 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	7	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	7	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('810','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	7	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	7	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	7	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,7,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	7	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	7	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	7	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	7	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	7	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"810\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	8	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	8	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	8	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	8	[DEBUG]	Process line 8
2015-07-08	15:15:26	8	[DEBUG]	Load a row
2015-07-08	15:15:26	8	[DEBUG]	Processing item: AC-T1-red-large
2015-07-08	15:15:26	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	8	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	8	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	8	[DEBUG]	Product tax:
2015-07-08	15:15:26	8	[DEBUG]	Query for Product
2015-07-08	15:15:26	8	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-red-large','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	8	[DEBUG]	No parent found
2015-07-08	15:15:26	8	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	8	[DEBUG]	Check product language entry
2015-07-08	15:15:26	8	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 811
2015-07-08	15:15:26	8	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	8	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-large' AND `virtuemart_product_id` != 811
2015-07-08	15:15:26	8	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	8	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-red-large' AND `virtuemart_product_id` != 811
2015-07-08	15:15:26	8	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	8	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (811, 'test-t-shirt-red-large')
2015-07-08	15:15:26	8	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	8	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt Red Large',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-red-large' WHERE `virtuemart_product_id`='811'
2015-07-08	15:15:26	8	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	8	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 811 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	8	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	8	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('811','0','19.99','1','12.75','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	8	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	8	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	8	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,8,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	8	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	8	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	8	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	8	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	8	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"811\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	9	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	9	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	9	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	9	[DEBUG]	Process line 9
2015-07-08	15:15:26	9	[DEBUG]	Load a row
2015-07-08	15:15:26	9	[DEBUG]	Processing item: AC-T1-white-small
2015-07-08	15:15:26	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	9	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	9	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	9	[DEBUG]	Product tax:
2015-07-08	15:15:26	9	[DEBUG]	Query for Product
2015-07-08	15:15:26	9	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-white-small','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	9	[DEBUG]	No parent found
2015-07-08	15:15:26	9	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	9	[DEBUG]	Check product language entry
2015-07-08	15:15:26	9	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 812
2015-07-08	15:15:26	9	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	9	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-small' AND `virtuemart_product_id` != 812
2015-07-08	15:15:26	9	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	9	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-small' AND `virtuemart_product_id` != 812
2015-07-08	15:15:26	9	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	9	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (812, 'test-t-shirt-white-small')
2015-07-08	15:15:26	9	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	9	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt White Small',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-white-small' WHERE `virtuemart_product_id`='812'
2015-07-08	15:15:26	9	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	9	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 812 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	9	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	9	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('812','0','19.99','1','11','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	9	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	9	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	9	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,9,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	9	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	9	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	9	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	9	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26	9	[QUERY]	UPDATE `w3094_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[]|clabels=0|options={\"812\":[]}|' WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field product_sku
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field product_name
2015-07-08	15:15:26	10	[DEBUG]	Use default value for field category_path
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field product_price
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field published
2015-07-08	15:15:26	10	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:15:26	10	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:15:26	10	[DEBUG]	Process line 10
2015-07-08	15:15:26	10	[DEBUG]	Load a row
2015-07-08	15:15:26	10	[DEBUG]	Processing item: AC-T1-white-med
2015-07-08	15:15:26	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	10	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:15:26	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:15:26	10	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:15:26	10	[DEBUG]	Product tax:
2015-07-08	15:15:26	10	[DEBUG]	Query for Product
2015-07-08	15:15:26	10	[QUERY]	INSERT INTO `w3094_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','804','AC-T1-white-med','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2015-07-08 15:15:26','708','2015-07-08 15:15:26','708','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	10	[DEBUG]	No parent found
2015-07-08	15:15:26	10	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:15:26	10	[DEBUG]	Check product language entry
2015-07-08	15:15:26	10	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 813
2015-07-08	15:15:26	10	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	10	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-medium' AND `virtuemart_product_id` != 813
2015-07-08	15:15:26	10	[DEBUG]	Check if the product slug exists
2015-07-08	15:15:26	10	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM w3094_virtuemart_products_en_gb WHERE `slug` = 'test-t-shirt-white-medium' AND `virtuemart_product_id` != 813
2015-07-08	15:15:26	10	[DEBUG]	Insert the dummy entry for the product language
2015-07-08	15:15:26	10	[QUERY]	INSERT INTO `w3094_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (813, 'test-t-shirt-white-medium')
2015-07-08	15:15:26	10	[DEBUG]	Query for ProductLang
2015-07-08	15:15:26	10	[QUERY]	UPDATE `w3094_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Test T Shirt White Medium',`metadesc`='',`metakey`='',`customtitle`='',`slug`='test-t-shirt-white-medium' WHERE `virtuemart_product_id`='813'
2015-07-08	15:15:26	10	[DEBUG]	Finding a product_price_id
2015-07-08	15:15:26	10	[QUERY]	SELECT `virtuemart_product_price_id` FROM `w3094_virtuemart_product_prices` WHERE `virtuemart_product_id` = 813 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 52 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-07-08	15:15:26	10	[DEBUG]	Query for ProductPrice
2015-07-08	15:15:26	10	[QUERY]	INSERT INTO `w3094_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_override_price`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('813','0','19.99','1','11','52','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
2015-07-08	15:15:26	10	[DEBUG]	Checking manufacturer
2015-07-08	15:15:26	10	[DEBUG]	No custom available fields found
2015-07-08	15:15:26	10	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1,10,'Product price added','Success','Added','Product prices')
2015-07-08	15:15:26	10	[DEBUG]	Process multi-variant fields
2015-07-08	15:15:26	10	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:15:26	10	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:15:26	10	[DEBUG]	Store the updated customfield_params
2015-07-08	15:15:26