Details
Date	2015-06-30 16:35:35 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 1078 lines
2015-06-30	16:35:35	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:35	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:35	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:35	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:36	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:36	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:36	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:36	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:36	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:36	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:37	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:37	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:37	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:37	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:37	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:37	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:37	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:37	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:38	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:38	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:38	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:38	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:38	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:38	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:38	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:38	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:39	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:39	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:39	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:39	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:39	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:39	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:39	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:39	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:40	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:40	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:40	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:40	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:40	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:40	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:40	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:40	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:40	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:40	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:41	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:41	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:41	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:41	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:42	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:42	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:42	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:42	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:42	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:42	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:42	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:42	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:43	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:43	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:43	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:43	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:43	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:43	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:43	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:43	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:44	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:44	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:44	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:44	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:44	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:44	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:44	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:44	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:45	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:45	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:45	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:45	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:45	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:45	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:45	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:45	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:46	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:46	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:46	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:46	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:46	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:46	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:46	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:46	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:47	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:47	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:47	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:47	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:47	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:47	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:48	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:48	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:48	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:48	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:48	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:48	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:48	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:48	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:49	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:49	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:49	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:49	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-06-30	16:35:49	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-06-30	16:35:49	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:18:44	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-07-02	18:18:44	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:19:06	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-07-02	18:19:06	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-02	18:19:06	0	[DEBUG]	Found field delimiter: ,
2015-07-02	18:19:06	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-02	18:19: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:19:06	0	[DEBUG]	Load the fields to process
2015-07-02	18:19:06	0	[DEBUG]	Field name: product_sku
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: product_parent_sku
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: product_name
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: category_path
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: product_price
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: product_override_price
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: published
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: multi_variant_title
2015-07-02	18:19: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:19:06	0	[DEBUG]	Field name: multi_variant_fields
2015-07-02	18:19: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:19:06	0	[DEBUG]	==========
2015-07-02	18:19:06	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-02	18:19:06	0	[DEBUG]	PHP version: 5.4.42
2015-07-02	18:19:06	0	[DEBUG]	Action: import
2015-07-02	18:19:06	0	[DEBUG]	Component: com_virtuemart
2015-07-02	18:19:06	0	[DEBUG]	Operation: product
2015-07-02	18:19:06	0	[DEBUG]	Source: fromupload
2015-07-02	18:19:06	0	[DEBUG]	Load from computer: /home/mynewsit/public_html/lambretta/tmp/com_csvi/1435861135/MV-Product.csv
2015-07-02	18:19:06	0	[DEBUG]	Load from server:
2015-07-02	18:19:06	0	[DEBUG]	Delete after import: No
2015-07-02	18:19:06	0	[DEBUG]	Load from URL:
2015-07-02	18:19:06	0	[DEBUG]	FTP Host:
2015-07-02	18:19:06	0	[DEBUG]	FTP Port:
2015-07-02	18:19:06	0	[DEBUG]	FTP Root Folder:
2015-07-02	18:19:06	0	[DEBUG]	FTP Filename:
2015-07-02	18:19:06	0	[DEBUG]	Auto detect delimiters: Yes
2015-07-02	18:19:06	0	[DEBUG]	Field Delimiter: comma
2015-07-02	18:19:06	0	[DEBUG]	Text Enclosure:
2015-07-02	18:19:06	0	[DEBUG]	Use file extension:
2015-07-02	18:19:06	0	[DEBUG]	I'm Mac: No
2015-07-02	18:19:06	0	[DEBUG]	Use file for configuration: No
2015-07-02	18:19:06	0	[DEBUG]	Add extra fields: No
2015-07-02	18:19:06	0	[DEBUG]	Skip first line: Yes
2015-07-02	18:19:06	0	[DEBUG]	Overwrite existing data: Yes
2015-07-02	18:19:06	0	[DEBUG]	Skip new items: No
2015-07-02	18:19:06	0	[DEBUG]	Record name:
2015-07-02	18:19:06	0	[DEBUG]	Language: en-GB
2015-07-02	18:19:06	0	[DEBUG]	Category separator: /
2015-07-02	18:19:06	0	[DEBUG]	Append categories: No
2015-07-02	18:19:06	0	[DEBUG]	Import based on: product_sku
2015-07-02	18:19:06	0	[DEBUG]	Unpublish before import: No
2015-07-02	18:19:06	0	[DEBUG]	Recreate alias: No
2015-07-02	18:19:06	0	[DEBUG]	Force stockable parent update: No
2015-07-02	18:19:06	0	[DEBUG]	Use ICEcat data: No
2015-07-02	18:19:06	0	[DEBUG]	Similar SKU search: No
2015-07-02	18:19:06	0	[DEBUG]	Process images: Yes
2015-07-02	18:19:06	0	[DEBUG]	Location product files:
2015-07-02	18:19:06	0	[DEBUG]	Delete image relations: No
2015-07-02	18:19:06	0	[DEBUG]	Create image name: No
2015-07-02	18:19:06	0	[DEBUG]	Image name based on: product_sku
2015-07-02	18:19:06	0	[DEBUG]	Image name format: jpg
2015-07-02	18:19:06	0	[DEBUG]	Change case: none
2015-07-02	18:19:06	0	[DEBUG]	Fill media fields: No
2015-07-02	18:19:06	0	[DEBUG]	Keep original file: No
2015-07-02	18:19:06	0	[DEBUG]	Convert image type: none
2015-07-02	18:19:06	0	[DEBUG]	Save images on server: No
2015-07-02	18:19:06	0	[DEBUG]	Re-download image: Yes
2015-07-02	18:19:06	0	[DEBUG]	Resize large image: No
2015-07-02	18:19:06	0	[DEBUG]	Full image width:
2015-07-02	18:19:06	0	[DEBUG]	Full image height:
2015-07-02	18:19:06	0	[DEBUG]	Check filetype: No
2015-07-02	18:19:06	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-02	18:19:06	0	[DEBUG]	Thumbnail type: none
2015-07-02	18:19:06	0	[DEBUG]	Thumbnail width: 90
2015-07-02	18:19:06	0	[DEBUG]	Thumbnail height: 90
2015-07-02	18:19:06	0	[DEBUG]	Maximum width resize: 1024
2015-07-02	18:19:06	0	[DEBUG]	Maximum height resize: 768
2015-07-02	18:19:06	0	[DEBUG]	Watermark: No
2015-07-02	18:19:06	0	[DEBUG]	Right margin:
2015-07-02	18:19:06	0	[DEBUG]	Bottom margin:
2015-07-02	18:19:06	0	[DEBUG]	Image:
2015-07-02	18:19:06	0	[DEBUG]	Lines per import: 1000
2015-07-02	18:19:06	0	[DEBUG]	Time between imports: 5
2015-07-02	18:19:06	0	[DEBUG]	Override system limits?: No
2015-07-02	18:19:06	0	[DEBUG]	Maximum execution time:
2015-07-02	18:19:06	0	[DEBUG]	Maximum amount of memory:
2015-07-02	18:19:06	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-02	18:19:06	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-02	18:19:06	0	[DEBUG]	==========
2015-07-02	18:19:06	0	[DEBUG]	Load the custom fields
2015-07-02	18:19: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:19:06	1	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	1	[DEBUG]	Use default value for field product_parent_sku
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field category_path
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	1	[DEBUG]	Use default value for field multi_variant_title
2015-07-02	18:19:06	1	[DEBUG]	Use field value for field multi_variant_fields
2015-07-02	18:19:06	1	[DEBUG]	Process line 1
2015-07-02	18:19:06	1	[DEBUG]	Check if the vendor exists
2015-07-02	18:19: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:19:06	1	[DEBUG]	Load a row
2015-07-02	18:19:06	1	[DEBUG]	Product tax:
2015-07-02	18:19:06	1	[DEBUG]	Query for Product
2015-07-02	18:19:06	1	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='784',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1'
2015-07-02	18:19:06	1	[DEBUG]	Check product language entry
2015-07-02	18:19:06	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	1	[DEBUG]	Load a row
2015-07-02	18:19:06	1	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	1	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	1	[DEBUG]	Load a row
2015-07-02	18:19:06	1	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	1	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='784',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='137'
2015-07-02	18:19:06	1	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	1	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	1	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,1,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	1	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	1	[DEBUG]	Find the multi variant custom field entry
2015-07-02	18:19:06	1	[QUERY]	SELECT `virtuemart_custom_id` FROM `w3094_virtuemart_customs` WHERE `custom_title` = '' AND `field_type` = 'C'
2015-07-02	18:19:06	1	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	1	[DEBUG]	Checking category
2015-07-02	18:19:06	1	[DEBUG]	Check if category path exists: Test T Shirts
2015-07-02	18:19: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:19:06	1	[DEBUG]	COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2015-07-02	18:19:06	1	[QUERY]	DELETE FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	1	[DEBUG]	COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
2015-07-02	18:19: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:19:06	1	[DEBUG]	COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
2015-07-02	18:19:06	1	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2015-07-02	18:19:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('784','11')
2015-07-02	18:19:06	1	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2015-07-02	18:19:06	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('784','11')
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	2	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	2	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	2	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	2	[DEBUG]	Process line 2
2015-07-02	18:19:06	2	[DEBUG]	Load a row
2015-07-02	18:19:06	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	2	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	2	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	2	[DEBUG]	Product tax:
2015-07-02	18:19:06	2	[DEBUG]	Query for Product
2015-07-02	18:19:06	2	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='785',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-Blue-small'
2015-07-02	18:19:06	2	[DEBUG]	No parent found
2015-07-02	18:19:06	2	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	2	[DEBUG]	Check product language entry
2015-07-02	18:19:06	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 785
2015-07-02	18:19:06	2	[DEBUG]	Load a row
2015-07-02	18:19:06	2	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	2	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	2	[DEBUG]	Load a row
2015-07-02	18:19:06	2	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	2	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='785',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='138'
2015-07-02	18:19:06	2	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	2	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	2	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,2,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	2	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	2	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	2	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	2	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	3	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	3	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	3	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	3	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	3	[DEBUG]	Process line 3
2015-07-02	18:19:06	3	[DEBUG]	Load a row
2015-07-02	18:19:06	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	3	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	3	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	3	[DEBUG]	Product tax:
2015-07-02	18:19:06	3	[DEBUG]	Query for Product
2015-07-02	18:19:06	3	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='786',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-med'
2015-07-02	18:19:06	3	[DEBUG]	No parent found
2015-07-02	18:19:06	3	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	3	[DEBUG]	Check product language entry
2015-07-02	18:19:06	3	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 786
2015-07-02	18:19:06	3	[DEBUG]	Load a row
2015-07-02	18:19:06	3	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	3	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	3	[DEBUG]	Load a row
2015-07-02	18:19:06	3	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	3	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='786',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='139'
2015-07-02	18:19:06	3	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	3	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	3	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,3,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	3	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	3	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	3	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	3	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	4	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	4	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	4	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	4	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	4	[DEBUG]	Process line 4
2015-07-02	18:19:06	4	[DEBUG]	Load a row
2015-07-02	18:19:06	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	4	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	4	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	4	[DEBUG]	Product tax:
2015-07-02	18:19:06	4	[DEBUG]	Query for Product
2015-07-02	18:19:06	4	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='787',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-large'
2015-07-02	18:19:06	4	[DEBUG]	No parent found
2015-07-02	18:19:06	4	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	4	[DEBUG]	Check product language entry
2015-07-02	18:19:06	4	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 787
2015-07-02	18:19:06	4	[DEBUG]	Load a row
2015-07-02	18:19:06	4	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	4	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	4	[DEBUG]	Load a row
2015-07-02	18:19:06	4	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	4	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='787',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='140'
2015-07-02	18:19:06	4	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	4	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	4	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,4,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	4	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	4	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	4	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	4	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	5	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	5	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	5	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	5	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	5	[DEBUG]	Process line 5
2015-07-02	18:19:06	5	[DEBUG]	Load a row
2015-07-02	18:19:06	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	5	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	5	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	5	[DEBUG]	Product tax:
2015-07-02	18:19:06	5	[DEBUG]	Query for Product
2015-07-02	18:19:06	5	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='788',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-xl'
2015-07-02	18:19:06	5	[DEBUG]	No parent found
2015-07-02	18:19:06	5	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	5	[DEBUG]	Check product language entry
2015-07-02	18:19:06	5	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 788
2015-07-02	18:19:06	5	[DEBUG]	Load a row
2015-07-02	18:19:06	5	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	5	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	5	[DEBUG]	Load a row
2015-07-02	18:19:06	5	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	5	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='788',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='141'
2015-07-02	18:19:06	5	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	5	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	5	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,5,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	5	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	5	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	5	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	5	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	6	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	6	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	6	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	6	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	6	[DEBUG]	Process line 6
2015-07-02	18:19:06	6	[DEBUG]	Load a row
2015-07-02	18:19:06	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	6	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	6	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	6	[DEBUG]	Product tax:
2015-07-02	18:19:06	6	[DEBUG]	Query for Product
2015-07-02	18:19:06	6	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='789',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-small'
2015-07-02	18:19:06	6	[DEBUG]	No parent found
2015-07-02	18:19:06	6	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	6	[DEBUG]	Check product language entry
2015-07-02	18:19:06	6	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 789
2015-07-02	18:19:06	6	[DEBUG]	Load a row
2015-07-02	18:19:06	6	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	6	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	6	[DEBUG]	Load a row
2015-07-02	18:19:06	6	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	6	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='789',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='142'
2015-07-02	18:19:06	6	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	6	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	6	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,6,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	6	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	6	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	6	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	6	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	7	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	7	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	7	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	7	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	7	[DEBUG]	Process line 7
2015-07-02	18:19:06	7	[DEBUG]	Load a row
2015-07-02	18:19:06	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	7	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	7	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	7	[DEBUG]	Product tax:
2015-07-02	18:19:06	7	[DEBUG]	Query for Product
2015-07-02	18:19:06	7	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='790',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-med'
2015-07-02	18:19:06	7	[DEBUG]	No parent found
2015-07-02	18:19:06	7	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	7	[DEBUG]	Check product language entry
2015-07-02	18:19:06	7	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 790
2015-07-02	18:19:06	7	[DEBUG]	Load a row
2015-07-02	18:19:06	7	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	7	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	7	[DEBUG]	Load a row
2015-07-02	18:19:06	7	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	7	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='790',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='143'
2015-07-02	18:19:06	7	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	7	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	7	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,7,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	7	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	7	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	7	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	7	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	8	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	8	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	8	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	8	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	8	[DEBUG]	Process line 8
2015-07-02	18:19:06	8	[DEBUG]	Load a row
2015-07-02	18:19:06	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	8	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	8	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	8	[DEBUG]	Product tax:
2015-07-02	18:19:06	8	[DEBUG]	Query for Product
2015-07-02	18:19:06	8	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='791',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-large'
2015-07-02	18:19:06	8	[DEBUG]	No parent found
2015-07-02	18:19:06	8	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	8	[DEBUG]	Check product language entry
2015-07-02	18:19:06	8	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 791
2015-07-02	18:19:06	8	[DEBUG]	Load a row
2015-07-02	18:19:06	8	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	8	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	8	[DEBUG]	Load a row
2015-07-02	18:19:06	8	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	8	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='791',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='144'
2015-07-02	18:19:06	8	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	8	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	8	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,8,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	8	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	8	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	8	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	8	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	9	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	9	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	9	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	9	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	9	[DEBUG]	Process line 9
2015-07-02	18:19:06	9	[DEBUG]	Load a row
2015-07-02	18:19:06	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	9	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	9	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	9	[DEBUG]	Product tax:
2015-07-02	18:19:06	9	[DEBUG]	Query for Product
2015-07-02	18:19:06	9	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='792',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-white-small'
2015-07-02	18:19:06	9	[DEBUG]	No parent found
2015-07-02	18:19:06	9	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	9	[DEBUG]	Check product language entry
2015-07-02	18:19:06	9	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 792
2015-07-02	18:19:06	9	[DEBUG]	Load a row
2015-07-02	18:19:06	9	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	9	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	9	[DEBUG]	Load a row
2015-07-02	18:19:06	9	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	9	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='792',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='11.00',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='145'
2015-07-02	18:19:06	9	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	9	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	9	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,9,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	9	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	9	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	9	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	9	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:19:06	10	[DEBUG]	Use field value for field product_sku
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field product_parent_sku
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field product_name
2015-07-02	18:19:06	10	[DEBUG]	Use default value for field category_path
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field product_price
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field product_override_price
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field published
2015-07-02	18:19:06	10	[DEBUG]	Use field value for field multi_variant_title
2015-07-02	18:19:06	10	[DEBUG]	Use default value for field multi_variant_fields
2015-07-02	18:19:06	10	[DEBUG]	Process line 10
2015-07-02	18:19:06	10	[DEBUG]	Load a row
2015-07-02	18:19:06	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	10	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-02	18:19:06	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-02	18:19:06	10	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-02	18:19:06	10	[DEBUG]	Product tax:
2015-07-02	18:19:06	10	[DEBUG]	Query for Product
2015-07-02	18:19:06	10	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='793',`virtuemart_vendor_id`='1',`product_parent_id`='784',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-02 18:17:06',`created_by`='708',`modified_on`='2015-07-02 18:19:06',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-white-med'
2015-07-02	18:19:06	10	[DEBUG]	No parent found
2015-07-02	18:19:06	10	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 784 AND customfield_value = 'stockable'
2015-07-02	18:19:06	10	[DEBUG]	Check product language entry
2015-07-02	18:19:06	10	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 793
2015-07-02	18:19:06	10	[DEBUG]	Load a row
2015-07-02	18:19:06	10	[DEBUG]	Query for ProductLang
2015-07-02	18:19: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:19:06	10	[DEBUG]	Finding a product_price_id
2015-07-02	18:19: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:19:06	10	[DEBUG]	Load a row
2015-07-02	18:19:06	10	[DEBUG]	Query for ProductPrice
2015-07-02	18:19:06	10	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='793',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='11.00',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='146'
2015-07-02	18:19:06	10	[DEBUG]	Checking manufacturer
2015-07-02	18:19:06	10	[DEBUG]	No custom available fields found
2015-07-02	18:19:06	10	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,10,'Product price updated','Success','Updated','Product prices')
2015-07-02	18:19:06	10	[DEBUG]	Process multi-variant fields
2015-07-02	18:19:06	10	[DEBUG]	Load the existing customfield_params for product parent
2015-07-02	18:19:06	10	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 784
2015-07-02	18:19:06	10	[DEBUG]	Store the updated customfield_params
2015-07-02	18:19: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:18:12	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-07-08	15:18:12	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-08	15:18:23	0	[DEBUG]	Clean up old logs. Found 3 logs and threshold is 25 logs
2015-07-08	15:18:23	0	[QUERY]	SELECT csvi_log_id FROM w3094_csvi_logs ORDER BY csvi_log_id
2015-07-08	15:18:23	0	[DEBUG]	Found field delimiter: ,
2015-07-08	15:18:23	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Load the fields to process
2015-07-08	15:18:23	0	[DEBUG]	Field name: product_sku
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: product_parent_sku
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: product_name
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: category_path
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: product_price
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: product_override_price
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: published
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: multi_variant_title
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	Field name: multi_variant_fields
2015-07-08	15:18:23	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:18:23	0	[DEBUG]	==========
2015-07-08	15:18:23	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-08	15:18:23	0	[DEBUG]	PHP version: 5.4.42
2015-07-08	15:18:23	0	[DEBUG]	Action: import
2015-07-08	15:18:23	0	[DEBUG]	Component: com_virtuemart
2015-07-08	15:18:23	0	[DEBUG]	Operation: product
2015-07-08	15:18:23	0	[DEBUG]	Source: fromupload
2015-07-08	15:18:23	0	[DEBUG]	Load from computer: /home/mynewsit/public_html/lambretta/tmp/com_csvi/1436368701/MV-Product.csv
2015-07-08	15:18:23	0	[DEBUG]	Load from server:
2015-07-08	15:18:23	0	[DEBUG]	Delete after import: No
2015-07-08	15:18:23	0	[DEBUG]	Load from URL:
2015-07-08	15:18:23	0	[DEBUG]	FTP Host:
2015-07-08	15:18:23	0	[DEBUG]	FTP Port:
2015-07-08	15:18:23	0	[DEBUG]	FTP Root Folder:
2015-07-08	15:18:23	0	[DEBUG]	FTP Filename:
2015-07-08	15:18:23	0	[DEBUG]	Auto detect delimiters: Yes
2015-07-08	15:18:23	0	[DEBUG]	Field Delimiter: comma
2015-07-08	15:18:23	0	[DEBUG]	Text Enclosure:
2015-07-08	15:18:23	0	[DEBUG]	Use file extension:
2015-07-08	15:18:23	0	[DEBUG]	I'm Mac: No
2015-07-08	15:18:23	0	[DEBUG]	Use file for configuration: No
2015-07-08	15:18:23	0	[DEBUG]	Add extra fields: No
2015-07-08	15:18:23	0	[DEBUG]	Skip first line: Yes
2015-07-08	15:18:23	0	[DEBUG]	Overwrite existing data: Yes
2015-07-08	15:18:23	0	[DEBUG]	Skip new items: No
2015-07-08	15:18:23	0	[DEBUG]	Record name:
2015-07-08	15:18:23	0	[DEBUG]	Language: en-GB
2015-07-08	15:18:23	0	[DEBUG]	Category separator: /
2015-07-08	15:18:23	0	[DEBUG]	Append categories: No
2015-07-08	15:18:23	0	[DEBUG]	Import based on: product_sku
2015-07-08	15:18:23	0	[DEBUG]	Unpublish before import: No
2015-07-08	15:18:23	0	[DEBUG]	Recreate alias: No
2015-07-08	15:18:23	0	[DEBUG]	Force stockable parent update: No
2015-07-08	15:18:23	0	[DEBUG]	Use ICEcat data: No
2015-07-08	15:18:23	0	[DEBUG]	Similar SKU search: No
2015-07-08	15:18:23	0	[DEBUG]	Process images: Yes
2015-07-08	15:18:23	0	[DEBUG]	Location product files:
2015-07-08	15:18:23	0	[DEBUG]	Delete image relations: No
2015-07-08	15:18:23	0	[DEBUG]	Create image name: No
2015-07-08	15:18:23	0	[DEBUG]	Image name based on: product_sku
2015-07-08	15:18:23	0	[DEBUG]	Image name format: jpg
2015-07-08	15:18:23	0	[DEBUG]	Change case: none
2015-07-08	15:18:23	0	[DEBUG]	Fill media fields: No
2015-07-08	15:18:23	0	[DEBUG]	Keep original file: No
2015-07-08	15:18:23	0	[DEBUG]	Convert image type: none
2015-07-08	15:18:23	0	[DEBUG]	Save images on server: No
2015-07-08	15:18:23	0	[DEBUG]	Re-download image: Yes
2015-07-08	15:18:23	0	[DEBUG]	Resize large image: No
2015-07-08	15:18:23	0	[DEBUG]	Full image width:
2015-07-08	15:18:23	0	[DEBUG]	Full image height:
2015-07-08	15:18:23	0	[DEBUG]	Check filetype: No
2015-07-08	15:18:23	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-08	15:18:23	0	[DEBUG]	Thumbnail type: none
2015-07-08	15:18:23	0	[DEBUG]	Thumbnail width: 90
2015-07-08	15:18:23	0	[DEBUG]	Thumbnail height: 90
2015-07-08	15:18:23	0	[DEBUG]	Maximum width resize: 1024
2015-07-08	15:18:23	0	[DEBUG]	Maximum height resize: 768
2015-07-08	15:18:23	0	[DEBUG]	Watermark: No
2015-07-08	15:18:23	0	[DEBUG]	Right margin:
2015-07-08	15:18:23	0	[DEBUG]	Bottom margin:
2015-07-08	15:18:23	0	[DEBUG]	Image:
2015-07-08	15:18:23	0	[DEBUG]	Lines per import: 1000
2015-07-08	15:18:23	0	[DEBUG]	Time between imports: 5
2015-07-08	15:18:23	0	[DEBUG]	Override system limits?: No
2015-07-08	15:18:23	0	[DEBUG]	Maximum execution time:
2015-07-08	15:18:23	0	[DEBUG]	Maximum amount of memory:
2015-07-08	15:18:23	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-08	15:18:23	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-08	15:18:23	0	[DEBUG]	==========
2015-07-08	15:18:23	0	[DEBUG]	Load the custom fields
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	1	[DEBUG]	Use default value for field product_parent_sku
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field category_path
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	1	[DEBUG]	Use default value for field multi_variant_title
2015-07-08	15:18:23	1	[DEBUG]	Use field value for field multi_variant_fields
2015-07-08	15:18:23	1	[DEBUG]	Process line 1
2015-07-08	15:18:23	1	[DEBUG]	Check if the vendor exists
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	Load a row
2015-07-08	15:18:23	1	[DEBUG]	Product tax:
2015-07-08	15:18:23	1	[DEBUG]	Query for Product
2015-07-08	15:18:23	1	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='804',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1'
2015-07-08	15:18:23	1	[DEBUG]	Check product language entry
2015-07-08	15:18:23	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	1	[DEBUG]	Load a row
2015-07-08	15:18:23	1	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	Load a row
2015-07-08	15:18:23	1	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	1	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='804',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='157'
2015-07-08	15:18:23	1	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	1	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	1	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,1,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	1	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	1	[DEBUG]	Find the multi variant custom field entry
2015-07-08	15:18:23	1	[QUERY]	SELECT `virtuemart_custom_id` FROM `w3094_virtuemart_customs` WHERE `custom_title` = '' AND `field_type` = 'C'
2015-07-08	15:18:23	1	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	Checking category
2015-07-08	15:18:23	1	[DEBUG]	Check if category path exists: Test T Shirts
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2015-07-08	15:18:23	1	[QUERY]	DELETE FROM `w3094_virtuemart_product_categories` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	1	[DEBUG]	COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
2015-07-08	15:18:23	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:18:23	1	[DEBUG]	COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
2015-07-08	15:18:23	1	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2015-07-08	15:18:23	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('804','11')
2015-07-08	15:18:23	1	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2015-07-08	15:18:23	1	[QUERY]	INSERT INTO `w3094_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('804','11')
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	2	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	2	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	2	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	2	[DEBUG]	Process line 2
2015-07-08	15:18:23	2	[DEBUG]	Load a row
2015-07-08	15:18:23	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	2	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	2	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	2	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	2	[DEBUG]	Product tax:
2015-07-08	15:18:23	2	[DEBUG]	Query for Product
2015-07-08	15:18:23	2	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='805',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-Blue-small'
2015-07-08	15:18:23	2	[DEBUG]	No parent found
2015-07-08	15:18:23	2	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	2	[DEBUG]	Check product language entry
2015-07-08	15:18:23	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 805
2015-07-08	15:18:23	2	[DEBUG]	Load a row
2015-07-08	15:18:23	2	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	2	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	2	[DEBUG]	Load a row
2015-07-08	15:18:23	2	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	2	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='805',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='158'
2015-07-08	15:18:23	2	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	2	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	2	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,2,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	2	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	2	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	2	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	2	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	3	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	3	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	3	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	3	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	3	[DEBUG]	Process line 3
2015-07-08	15:18:23	3	[DEBUG]	Load a row
2015-07-08	15:18:23	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	3	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	3	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	3	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	3	[DEBUG]	Product tax:
2015-07-08	15:18:23	3	[DEBUG]	Query for Product
2015-07-08	15:18:23	3	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='806',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-med'
2015-07-08	15:18:23	3	[DEBUG]	No parent found
2015-07-08	15:18:23	3	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	3	[DEBUG]	Check product language entry
2015-07-08	15:18:23	3	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 806
2015-07-08	15:18:23	3	[DEBUG]	Load a row
2015-07-08	15:18:23	3	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	3	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	3	[DEBUG]	Load a row
2015-07-08	15:18:23	3	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	3	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='806',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='159'
2015-07-08	15:18:23	3	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	3	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	3	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,3,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	3	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	3	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	3	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	3	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	4	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	4	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	4	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	4	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	4	[DEBUG]	Process line 4
2015-07-08	15:18:23	4	[DEBUG]	Load a row
2015-07-08	15:18:23	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	4	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	4	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	4	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	4	[DEBUG]	Product tax:
2015-07-08	15:18:23	4	[DEBUG]	Query for Product
2015-07-08	15:18:23	4	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='807',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-large'
2015-07-08	15:18:23	4	[DEBUG]	No parent found
2015-07-08	15:18:23	4	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	4	[DEBUG]	Check product language entry
2015-07-08	15:18:23	4	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 807
2015-07-08	15:18:23	4	[DEBUG]	Load a row
2015-07-08	15:18:23	4	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	4	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	4	[DEBUG]	Load a row
2015-07-08	15:18:23	4	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	4	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='807',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='160'
2015-07-08	15:18:23	4	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	4	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	4	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,4,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	4	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	4	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	4	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	4	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	5	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	5	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	5	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	5	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	5	[DEBUG]	Process line 5
2015-07-08	15:18:23	5	[DEBUG]	Load a row
2015-07-08	15:18:23	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	5	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	5	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	5	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	5	[DEBUG]	Product tax:
2015-07-08	15:18:23	5	[DEBUG]	Query for Product
2015-07-08	15:18:23	5	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='808',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-blue-xl'
2015-07-08	15:18:23	5	[DEBUG]	No parent found
2015-07-08	15:18:23	5	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	5	[DEBUG]	Check product language entry
2015-07-08	15:18:23	5	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 808
2015-07-08	15:18:23	5	[DEBUG]	Load a row
2015-07-08	15:18:23	5	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	5	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	5	[DEBUG]	Load a row
2015-07-08	15:18:23	5	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	5	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='808',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='161'
2015-07-08	15:18:23	5	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	5	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	5	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,5,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	5	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	5	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	5	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	5	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	6	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	6	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	6	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	6	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	6	[DEBUG]	Process line 6
2015-07-08	15:18:23	6	[DEBUG]	Load a row
2015-07-08	15:18:23	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	6	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	6	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	6	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	6	[DEBUG]	Product tax:
2015-07-08	15:18:23	6	[DEBUG]	Query for Product
2015-07-08	15:18:23	6	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='809',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-small'
2015-07-08	15:18:23	6	[DEBUG]	No parent found
2015-07-08	15:18:23	6	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	6	[DEBUG]	Check product language entry
2015-07-08	15:18:23	6	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 809
2015-07-08	15:18:23	6	[DEBUG]	Load a row
2015-07-08	15:18:23	6	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	6	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	6	[DEBUG]	Load a row
2015-07-08	15:18:23	6	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	6	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='809',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='162'
2015-07-08	15:18:23	6	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	6	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	6	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,6,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	6	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	6	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	6	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	6	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	7	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	7	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	7	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	7	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	7	[DEBUG]	Process line 7
2015-07-08	15:18:23	7	[DEBUG]	Load a row
2015-07-08	15:18:23	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	7	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	7	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	7	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	7	[DEBUG]	Product tax:
2015-07-08	15:18:23	7	[DEBUG]	Query for Product
2015-07-08	15:18:23	7	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='810',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-med'
2015-07-08	15:18:23	7	[DEBUG]	No parent found
2015-07-08	15:18:23	7	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	7	[DEBUG]	Check product language entry
2015-07-08	15:18:23	7	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 810
2015-07-08	15:18:23	7	[DEBUG]	Load a row
2015-07-08	15:18:23	7	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	7	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	7	[DEBUG]	Load a row
2015-07-08	15:18:23	7	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	7	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='810',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='163'
2015-07-08	15:18:23	7	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	7	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	7	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,7,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	7	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	7	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	7	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	7	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	8	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	8	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	8	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	8	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	8	[DEBUG]	Process line 8
2015-07-08	15:18:23	8	[DEBUG]	Load a row
2015-07-08	15:18:23	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	8	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	8	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	8	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	8	[DEBUG]	Product tax:
2015-07-08	15:18:23	8	[DEBUG]	Query for Product
2015-07-08	15:18:23	8	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='811',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-red-large'
2015-07-08	15:18:23	8	[DEBUG]	No parent found
2015-07-08	15:18:23	8	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	8	[DEBUG]	Check product language entry
2015-07-08	15:18:23	8	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 811
2015-07-08	15:18:23	8	[DEBUG]	Load a row
2015-07-08	15:18:23	8	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	8	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	8	[DEBUG]	Load a row
2015-07-08	15:18:23	8	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	8	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='811',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='12.75',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='164'
2015-07-08	15:18:23	8	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	8	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	8	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,8,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	8	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	8	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	8	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	8	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	9	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	9	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	9	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	9	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	9	[DEBUG]	Process line 9
2015-07-08	15:18:23	9	[DEBUG]	Load a row
2015-07-08	15:18:23	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	9	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	9	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	9	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	9	[DEBUG]	Product tax:
2015-07-08	15:18:23	9	[DEBUG]	Query for Product
2015-07-08	15:18:23	9	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='812',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-white-small'
2015-07-08	15:18:23	9	[DEBUG]	No parent found
2015-07-08	15:18:23	9	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	9	[DEBUG]	Check product language entry
2015-07-08	15:18:23	9	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 812
2015-07-08	15:18:23	9	[DEBUG]	Load a row
2015-07-08	15:18:23	9	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	9	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	9	[DEBUG]	Load a row
2015-07-08	15:18:23	9	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	9	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='812',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='11',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='165'
2015-07-08	15:18:23	9	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	9	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	9	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,9,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	9	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	9	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	9	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:23	9	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:23	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:18:23	10	[DEBUG]	Use field value for field product_sku
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field product_parent_sku
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field product_name
2015-07-08	15:18:23	10	[DEBUG]	Use default value for field category_path
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field product_price
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field product_override_price
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field published
2015-07-08	15:18:23	10	[DEBUG]	Use field value for field multi_variant_title
2015-07-08	15:18:23	10	[DEBUG]	Use default value for field multi_variant_fields
2015-07-08	15:18:23	10	[DEBUG]	Process line 10
2015-07-08	15:18:23	10	[DEBUG]	Load a row
2015-07-08	15:18:23	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	10	[QUERY]	SELECT `vendor_currency` FROM `w3094_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1
2015-07-08	15:18:23	10	[DEBUG]	COM_CSVI_DEBUG_PRODUCT_PARENT_SKU
2015-07-08	15:18:23	10	[QUERY]	SELECT `virtuemart_product_id` FROM `w3094_virtuemart_products` WHERE `product_sku` = 'AC-T1'
2015-07-08	15:18:23	10	[DEBUG]	Product tax:
2015-07-08	15:18:23	10	[DEBUG]	Query for Product
2015-07-08	15:18:23	10	[QUERY]	UPDATE `w3094_virtuemart_products` SET `virtuemart_product_id`='813',`virtuemart_vendor_id`='1',`product_parent_id`='804',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-07-08 15:15:26',`created_by`='708',`modified_on`='2015-07-08 15:18:23',`modified_by`='708',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='AC-T1-white-med'
2015-07-08	15:18:23	10	[DEBUG]	No parent found
2015-07-08	15:18:23	10	[QUERY]	SELECT customfield_params FROM w3094_virtuemart_product_customfields WHERE virtuemart_product_id = 804 AND customfield_value = 'stockable'
2015-07-08	15:18:23	10	[DEBUG]	Check product language entry
2015-07-08	15:18:23	10	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `w3094_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 813
2015-07-08	15:18:23	10	[DEBUG]	Load a row
2015-07-08	15:18:23	10	[DEBUG]	Query for ProductLang
2015-07-08	15:18:23	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:18:23	10	[DEBUG]	Finding a product_price_id
2015-07-08	15:18:23	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:18:23	10	[DEBUG]	Load a row
2015-07-08	15:18:23	10	[DEBUG]	Query for ProductPrice
2015-07-08	15:18:23	10	[QUERY]	UPDATE `w3094_virtuemart_product_prices` SET `virtuemart_product_id`='813',`virtuemart_shoppergroup_id`='0',`product_price`='19.99',`override`='1',`product_override_price`='11',`product_tax_id`=NULL,`product_discount_id`=NULL,`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='166'
2015-07-08	15:18:23	10	[DEBUG]	Checking manufacturer
2015-07-08	15:18:23	10	[DEBUG]	No custom available fields found
2015-07-08	15:18:23	10	[QUERY]	INSERT INTO `w3094_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (3,10,'Product price updated','Success','Updated','Product prices')
2015-07-08	15:18:23	10	[DEBUG]	Process multi-variant fields
2015-07-08	15:18:23	10	[DEBUG]	Load the existing customfield_params for product parent
2015-07-08	15:18:23	10	[QUERY]	SELECT `customfield_params` FROM `w3094_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 804
2015-07-08	15:18:24	10	[DEBUG]	Store the updated customfield_params
2015-07-08	15:18:24