# # #Date: 2017-07-07 12:42:38 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2017-07-07 12:42:38 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs 2017-07-07 12:43:08 0 [DEBUG] Found field delimiter: , 2017-07-07 12:43:09 0 [DEBUG] Found field delimiter: , 2017-07-07 12:43:09 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-07-07 12:43:09 0 [QUERY] SELECT `a`.`csvi_name` FROM `lvrc_csvi_availablefields` AS `a` LEFT JOIN `lvrc_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' 2017-07-07 12:43:09 0 [DEBUG] Load the fields to process 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_sku 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Setup field: published 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_name 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_price 2017-07-07 12:43:09 0 [DEBUG] Setup field: category_path 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_desc 2017-07-07 12:43:09 0 [DEBUG] Setup field: file_url 2017-07-07 12:43:09 0 [DEBUG] Setup field: product_currency 2017-07-07 12:43:09 0 [DEBUG] Setup field: Size 2017-07-07 12:43:09 0 [DEBUG] Setup field: Width 2017-07-07 12:43:09 0 [DEBUG] Setup field: multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Setup field: multi_variant_fields 2017-07-07 12:43:09 0 [DEBUG] Use the file for configuration 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:09 0 [DEBUG] Use default value for field product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field published 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_name 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_price 2017-07-07 12:43:09 0 [DEBUG] Use field value for field category_path 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_desc 2017-07-07 12:43:09 0 [DEBUG] Use field value for field file_url 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Size 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Width 2017-07-07 12:43:09 0 [DEBUG] Use field value for field multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Use field value for field multi_variant_fields 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field published 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_name 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_price 2017-07-07 12:43:09 0 [DEBUG] Use default value for field category_path 2017-07-07 12:43:09 0 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:09 0 [DEBUG] Use field value for field file_url 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Size 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Width 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field published 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_name 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_price 2017-07-07 12:43:09 0 [DEBUG] Use default value for field category_path 2017-07-07 12:43:09 0 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:09 0 [DEBUG] Use field value for field file_url 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Size 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Width 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field published 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_name 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_price 2017-07-07 12:43:09 0 [DEBUG] Use default value for field category_path 2017-07-07 12:43:09 0 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:09 0 [DEBUG] Use field value for field file_url 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Size 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Width 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:09 0 [DEBUG] Use field value for field published 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_name 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_price 2017-07-07 12:43:09 0 [DEBUG] Use default value for field category_path 2017-07-07 12:43:09 0 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:09 0 [DEBUG] Use field value for field file_url 2017-07-07 12:43:09 0 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Size 2017-07-07 12:43:09 0 [DEBUG] Use field value for field Width 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:09 0 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:14 0 [DEBUG] Found field delimiter: , 2017-07-07 12:43:14 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-07-07 12:43:14 0 [QUERY] SELECT `a`.`csvi_name` FROM `lvrc_csvi_availablefields` AS `a` LEFT JOIN `lvrc_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' 2017-07-07 12:43:14 0 [DEBUG] Load the fields to process 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_sku 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_parent_sku 2017-07-07 12:43:14 0 [DEBUG] Setup field: published 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_name 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_price 2017-07-07 12:43:14 0 [DEBUG] Setup field: category_path 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_desc 2017-07-07 12:43:14 0 [DEBUG] Setup field: file_url 2017-07-07 12:43:14 0 [DEBUG] Setup field: product_currency 2017-07-07 12:43:14 0 [DEBUG] Setup field: Size 2017-07-07 12:43:14 0 [DEBUG] Setup field: Width 2017-07-07 12:43:14 0 [DEBUG] Setup field: multi_variant_title 2017-07-07 12:43:14 0 [DEBUG] Setup field: multi_variant_fields 2017-07-07 12:43:14 0 [DEBUG] Use the file for configuration 2017-07-07 12:43:14 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2017-07-07 12:43:15 0 [DEBUG] Found field delimiter: , 2017-07-07 12:43:15 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-07-07 12:43:15 0 [QUERY] SELECT `a`.`csvi_name` FROM `lvrc_csvi_availablefields` AS `a` LEFT JOIN `lvrc_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' 2017-07-07 12:43:15 0 [DEBUG] Load the fields to process 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_sku 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_parent_sku 2017-07-07 12:43:15 0 [DEBUG] Setup field: published 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_name 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_price 2017-07-07 12:43:15 0 [DEBUG] Setup field: category_path 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_desc 2017-07-07 12:43:15 0 [DEBUG] Setup field: file_url 2017-07-07 12:43:15 0 [DEBUG] Setup field: product_currency 2017-07-07 12:43:15 0 [DEBUG] Setup field: Size 2017-07-07 12:43:15 0 [DEBUG] Setup field: Width 2017-07-07 12:43:15 0 [DEBUG] Setup field: multi_variant_title 2017-07-07 12:43:15 0 [DEBUG] Setup field: multi_variant_fields 2017-07-07 12:43:15 0 [DEBUG] Use the file for configuration 2017-07-07 12:43:15 0 [DEBUG] ========== 2017-07-07 12:43:15 0 [DEBUG] CSVI Pro Version: 7.2.3 2017-07-07 12:43:15 0 [DEBUG] PHP version: 7.0.1 2017-07-07 12:43:15 0 [DEBUG] Action: import 2017-07-07 12:43:15 0 [DEBUG] Component: com_virtuemart 2017-07-07 12:43:15 0 [DEBUG] Operation: product 2017-07-07 12:43:15 0 [DEBUG] Override: 2017-07-07 12:43:15 0 [DEBUG] Source: fromupload 2017-07-07 12:43:15 0 [DEBUG] Load from your computer: /var/sites/f/fenixxcell.com/public_html/tmp/com_csvi/1552533831/example incomplete for virtumart import-edited-small2.csv 2017-07-07 12:43:15 0 [DEBUG] Load from server: 2017-07-07 12:43:15 0 [DEBUG] Delete after import: No 2017-07-07 12:43:15 0 [DEBUG] Load from URL: http:// 2017-07-07 12:43:15 0 [DEBUG] URL Username: 2017-07-07 12:43:15 0 [DEBUG] Name of username field: user 2017-07-07 12:43:15 0 [DEBUG] URL Password: 2017-07-07 12:43:15 0 [DEBUG] Name of the password field: password 2017-07-07 12:43:15 0 [DEBUG] Retrieve method: get 2017-07-07 12:43:15 0 [DEBUG] FTP Host: 2017-07-07 12:43:15 0 [DEBUG] FTP Port: 2017-07-07 12:43:15 0 [DEBUG] FTP Root Folder: 2017-07-07 12:43:15 0 [DEBUG] FTP Filename: 2017-07-07 12:43:15 0 [DEBUG] Username: 2017-07-07 12:43:15 0 [DEBUG] Host: 2017-07-07 12:43:15 0 [DEBUG] Port: 2017-07-07 12:43:15 0 [DEBUG] Database name: 2017-07-07 12:43:15 0 [DEBUG] Database table: 2017-07-07 12:43:15 0 [DEBUG] Autodetect delimiters: Yes 2017-07-07 12:43:15 0 [DEBUG] Field Delimiter: comma 2017-07-07 12:43:15 0 [DEBUG] Text Enclosure: 2017-07-07 12:43:15 0 [DEBUG] Use file extension: 2017-07-07 12:43:15 0 [DEBUG] I'm Mac: No 2017-07-07 12:43:15 0 [DEBUG] Use file for configuration: Yes 2017-07-07 12:43:15 0 [DEBUG] Add extra fields: No 2017-07-07 12:43:15 0 [DEBUG] Skip first line: No 2017-07-07 12:43:15 0 [DEBUG] Overwrite existing data: Yes 2017-07-07 12:43:15 0 [DEBUG] Skip new items: No 2017-07-07 12:43:15 0 [DEBUG] Record name: 2017-07-07 12:43:15 0 [DEBUG] Language: en-GB 2017-07-07 12:43:15 0 [DEBUG] Category separator: / 2017-07-07 12:43:15 0 [DEBUG] Append categories: No 2017-07-07 12:43:15 0 [DEBUG] Import based on: product_sku 2017-07-07 12:43:15 0 [DEBUG] Unpublish before import: No 2017-07-07 12:43:15 0 [DEBUG] Recreate alias: No 2017-07-07 12:43:15 0 [DEBUG] Delete custom fields relations: No 2017-07-07 12:43:15 0 [DEBUG] Use ICEcat data: No 2017-07-07 12:43:15 0 [DEBUG] Similar SKU search: No 2017-07-07 12:43:15 0 [DEBUG] Number of images: 2017-07-07 12:43:15 0 [DEBUG] Download PDF files: No 2017-07-07 12:43:15 0 [DEBUG] Location product files: 2017-07-07 12:43:15 0 [DEBUG] Delete image relations: No 2017-07-07 12:43:15 0 [DEBUG] Create image name: No 2017-07-07 12:43:15 0 [DEBUG] Image name based on: product_sku 2017-07-07 12:43:15 0 [DEBUG] Image name format: jpg 2017-07-07 12:43:15 0 [DEBUG] Change case: none 2017-07-07 12:43:15 0 [DEBUG] Fill media fields: No 2017-07-07 12:43:15 0 [DEBUG] Update media link only: No 2017-07-07 12:43:15 0 [DEBUG] Process images: Yes 2017-07-07 12:43:15 0 [DEBUG] Keep original file: No 2017-07-07 12:43:15 0 [DEBUG] Convert image type: none 2017-07-07 12:43:15 0 [DEBUG] Save images on server: No 2017-07-07 12:43:15 0 [DEBUG] Re-download image: Yes 2017-07-07 12:43:15 0 [DEBUG] Resize large image: No 2017-07-07 12:43:15 0 [DEBUG] Full image width: 2017-07-07 12:43:15 0 [DEBUG] Full image height: 2017-07-07 12:43:15 0 [DEBUG] Check filetype: No 2017-07-07 12:43:15 0 [DEBUG] Automatic thumbnail creation: Yes 2017-07-07 12:43:15 0 [DEBUG] Thumbnail type: none 2017-07-07 12:43:15 0 [DEBUG] Thumbnail width: 250 2017-07-07 12:43:15 0 [DEBUG] Thumbnail height: 250 2017-07-07 12:43:15 0 [DEBUG] Maximum width resize: 1024 2017-07-07 12:43:15 0 [DEBUG] Maximum height resize: 768 2017-07-07 12:43:15 0 [DEBUG] Watermark: No 2017-07-07 12:43:15 0 [DEBUG] Right margin: 2017-07-07 12:43:15 0 [DEBUG] Bottom margin: 2017-07-07 12:43:15 0 [DEBUG] Image: 2017-07-07 12:43:15 0 [DEBUG] Lines per import: 1000 2017-07-07 12:43:15 0 [DEBUG] Time between imports: 5 2017-07-07 12:43:15 0 [DEBUG] Override system limits?: No 2017-07-07 12:43:15 0 [DEBUG] Maximum execution time: 2017-07-07 12:43:15 0 [DEBUG] Maximum amount of memory: 2017-07-07 12:43:15 0 [DEBUG] Maximum size of POST data in megabytes: 2017-07-07 12:43:15 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2017-07-07 12:43:15 0 [DEBUG] Template ID: 9 2017-07-07 12:43:15 0 [DEBUG] Tags: 2017-07-07 12:43:15 0 [DEBUG] ========== 2017-07-07 12:43:15 0 [DEBUG] Load the custom fields 2017-07-07 12:43:15 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`custom_parent_id`,`field_type`,TRIM(`custom_title`) AS `title`,`ordering` FROM `lvrc_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering` 2017-07-07 12:43:15 1 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:15 1 [DEBUG] Use default value for field product_parent_sku 2017-07-07 12:43:15 1 [DEBUG] Use field value for field published 2017-07-07 12:43:15 1 [DEBUG] Use field value for field product_name 2017-07-07 12:43:15 1 [DEBUG] Use field value for field product_price 2017-07-07 12:43:15 1 [DEBUG] Use field value for field category_path 2017-07-07 12:43:15 1 [DEBUG] Use field value for field product_desc 2017-07-07 12:43:15 1 [DEBUG] Use field value for field file_url 2017-07-07 12:43:15 1 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:15 1 [DEBUG] Use field value for field Size 2017-07-07 12:43:15 1 [DEBUG] Use field value for field Width 2017-07-07 12:43:15 1 [DEBUG] Use field value for field multi_variant_title 2017-07-07 12:43:15 1 [DEBUG] Use field value for field multi_variant_fields 2017-07-07 12:43:15 1 [DEBUG] Process line 1 2017-07-07 12:43:15 1 [DEBUG] Check if the vendor exists 2017-07-07 12:43:15 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 1 [DEBUG] Get the currency ID 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:15 1 [DEBUG] Load a row 2017-07-07 12:43:15 1 [DEBUG] Processing item: ABC 2017-07-07 12:43:15 1 [DEBUG] Product tax: 2017-07-07 12:43:15 1 [DEBUG] Query for Product 2017-07-07 12:43:15 1 [QUERY] SELECT `vendor_currency` FROM `lvrc_virtuemart_vendors` WHERE `virtuemart_vendor_id` = 1 2017-07-07 12:43:15 1 [DEBUG] Check product language entry 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 1 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'my-first-parent-product' AND `virtuemart_product_id` != 3605 2017-07-07 12:43:15 1 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'my-first-parent-product' AND `virtuemart_product_id` != 3605 2017-07-07 12:43:15 1 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:15 1 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3605, 'my-first-parent-product') 2017-07-07 12:43:15 1 [DEBUG] Query for ProductLang 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'my-first-parent-product' 2017-07-07 12:43:15 1 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:15 1 [DEBUG] Finding a product_price_id 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3605 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 1 [DEBUG] Query for ProductPrice 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3605 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 1 [DEBUG] Checking manufacturer 2017-07-07 12:43:15 1 [DEBUG] No custom available fields found 2017-07-07 12:43:15 1 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,1,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:15 1 [DEBUG] Process multi-variant fields 2017-07-07 12:43:15 1 [DEBUG] Find the multi variant custom field entry 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_custom_id` FROM `lvrc_virtuemart_customs` WHERE `custom_title` = 'Options' AND `field_type` = 'C' 2017-07-07 12:43:15 1 [DEBUG] Find the multi variant product entry 2017-07-07 12:43:15 1 [QUERY] SELECT `virtuemart_customfield_id` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 AND `virtuemart_custom_id` = 11 2017-07-07 12:43:15 1 [DEBUG] Insert the multi variant custom field entry 2017-07-07 12:43:15 1 [QUERY] INSERT INTO `lvrc_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`published`,`created_on`,`created_by`) VALUES (3605, 11, 1, '2017-07-07 12:43:15', 479) 2017-07-07 12:43:15 1 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:15 1 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 1 [DEBUG] Checking category 2017-07-07 12:43:15 1 [DEBUG] Check if category path exists: Mens 2017-07-07 12:43:15 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `lvrc_virtuemart_categories` AS `c` LEFT JOIN `lvrc_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `lvrc_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Mens' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0 2017-07-07 12:43:15 1 [DEBUG] Check if category path exists: Mens Shoes 2017-07-07 12:43:15 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `lvrc_virtuemart_categories` AS `c` LEFT JOIN `lvrc_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `lvrc_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Mens Shoes' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 135 2017-07-07 12:43:15 1 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF 2017-07-07 12:43:15 1 [QUERY] DELETE FROM `lvrc_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 1 [DEBUG] Check if a category reference already exists 2017-07-07 12:43:15 1 [QUERY] SELECT COUNT(*) AS total FROM `lvrc_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3605 AND `virtuemart_category_id` = 136 2017-07-07 12:43:15 1 [DEBUG] Category reference does not exist yet 2017-07-07 12:43:15 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES 2017-07-07 12:43:15 1 [QUERY] INSERT INTO `lvrc_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('3605','136') 2017-07-07 12:43:15 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED 2017-07-07 12:43:15 1 [QUERY] INSERT INTO `lvrc_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('3605','136') 2017-07-07 12:43:15 2 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:15 2 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:15 2 [DEBUG] Use field value for field published 2017-07-07 12:43:15 2 [DEBUG] Use field value for field product_name 2017-07-07 12:43:15 2 [DEBUG] Use field value for field product_price 2017-07-07 12:43:15 2 [DEBUG] Use default value for field category_path 2017-07-07 12:43:15 2 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:15 2 [DEBUG] Use field value for field file_url 2017-07-07 12:43:15 2 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:15 2 [DEBUG] Use field value for field Size 2017-07-07 12:43:15 2 [DEBUG] Use field value for field Width 2017-07-07 12:43:15 2 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:15 2 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:15 2 [DEBUG] Process line 2 2017-07-07 12:43:15 2 [DEBUG] Get the currency ID 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:15 2 [DEBUG] Load a row 2017-07-07 12:43:15 2 [DEBUG] Processing item: ABC-S1 2017-07-07 12:43:15 2 [DEBUG] Looking for parent SKU 2017-07-07 12:43:15 2 [DEBUG] Checking product parent SKU 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 2 [DEBUG] Product tax: 2017-07-07 12:43:15 2 [DEBUG] Query for Product 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 2 [DEBUG] No parent found 2017-07-07 12:43:15 2 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:15 2 [DEBUG] Check product language entry 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3606 2017-07-07 12:43:15 2 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-small-2e' AND `virtuemart_product_id` != 3606 2017-07-07 12:43:15 2 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-small-2e' AND `virtuemart_product_id` != 3606 2017-07-07 12:43:15 2 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:15 2 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3606, 'first-product-small-2e') 2017-07-07 12:43:15 2 [DEBUG] Query for ProductLang 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-small-2e' 2017-07-07 12:43:15 2 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:15 2 [DEBUG] Finding a product_price_id 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3606 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 2 [DEBUG] Query for ProductPrice 2017-07-07 12:43:15 2 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3606 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 2 [DEBUG] Checking manufacturer 2017-07-07 12:43:15 2 [DEBUG] No custom available fields found 2017-07-07 12:43:15 2 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,2,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:15 2 [DEBUG] Process multi-variant fields 2017-07-07 12:43:15 2 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:15 2 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 2 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:15 2 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 3 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:15 3 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:15 3 [DEBUG] Use field value for field published 2017-07-07 12:43:15 3 [DEBUG] Use field value for field product_name 2017-07-07 12:43:15 3 [DEBUG] Use field value for field product_price 2017-07-07 12:43:15 3 [DEBUG] Use default value for field category_path 2017-07-07 12:43:15 3 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:15 3 [DEBUG] Use field value for field file_url 2017-07-07 12:43:15 3 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:15 3 [DEBUG] Use field value for field Size 2017-07-07 12:43:15 3 [DEBUG] Use field value for field Width 2017-07-07 12:43:15 3 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:15 3 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:15 3 [DEBUG] Process line 3 2017-07-07 12:43:15 3 [DEBUG] Get the currency ID 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:15 3 [DEBUG] Load a row 2017-07-07 12:43:15 3 [DEBUG] Processing item: ABS-M1 2017-07-07 12:43:15 3 [DEBUG] Looking for parent SKU 2017-07-07 12:43:15 3 [DEBUG] Checking product parent SKU 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 3 [DEBUG] Product tax: 2017-07-07 12:43:15 3 [DEBUG] Query for Product 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 3 [DEBUG] No parent found 2017-07-07 12:43:15 3 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:15 3 [DEBUG] Check product language entry 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3607 2017-07-07 12:43:15 3 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-med-2e' AND `virtuemart_product_id` != 3607 2017-07-07 12:43:15 3 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-med-2e' AND `virtuemart_product_id` != 3607 2017-07-07 12:43:15 3 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:15 3 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3607, 'first-product-med-2e') 2017-07-07 12:43:15 3 [DEBUG] Query for ProductLang 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-med-2e' 2017-07-07 12:43:15 3 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:15 3 [DEBUG] Finding a product_price_id 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3607 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 3 [DEBUG] Query for ProductPrice 2017-07-07 12:43:15 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3607 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 3 [DEBUG] Checking manufacturer 2017-07-07 12:43:15 3 [DEBUG] No custom available fields found 2017-07-07 12:43:15 3 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,3,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:15 3 [DEBUG] Process multi-variant fields 2017-07-07 12:43:15 3 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:15 3 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 3 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:15 3 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\\r\\n8\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"],\"3607\":[\"8\",\"2E\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 4 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:15 4 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:15 4 [DEBUG] Use field value for field published 2017-07-07 12:43:15 4 [DEBUG] Use field value for field product_name 2017-07-07 12:43:15 4 [DEBUG] Use field value for field product_price 2017-07-07 12:43:15 4 [DEBUG] Use default value for field category_path 2017-07-07 12:43:15 4 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:15 4 [DEBUG] Use field value for field file_url 2017-07-07 12:43:15 4 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:15 4 [DEBUG] Use field value for field Size 2017-07-07 12:43:15 4 [DEBUG] Use field value for field Width 2017-07-07 12:43:15 4 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:15 4 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:15 4 [DEBUG] Process line 4 2017-07-07 12:43:15 4 [DEBUG] Get the currency ID 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:15 4 [DEBUG] Load a row 2017-07-07 12:43:15 4 [DEBUG] Processing item: ABC-L1 2017-07-07 12:43:15 4 [DEBUG] Looking for parent SKU 2017-07-07 12:43:15 4 [DEBUG] Checking product parent SKU 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 4 [DEBUG] Product tax: 2017-07-07 12:43:15 4 [DEBUG] Query for Product 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:15 4 [DEBUG] No parent found 2017-07-07 12:43:15 4 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:15 4 [DEBUG] Check product language entry 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3608 2017-07-07 12:43:15 4 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 4 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-large-2e' AND `virtuemart_product_id` != 3608 2017-07-07 12:43:15 4 [DEBUG] Check if the product slug exists 2017-07-07 12:43:15 4 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-large-2e' AND `virtuemart_product_id` != 3608 2017-07-07 12:43:15 4 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:15 4 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3608, 'first-product-large-2e') 2017-07-07 12:43:15 4 [DEBUG] Query for ProductLang 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-large-2e' 2017-07-07 12:43:15 4 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:15 4 [DEBUG] Finding a product_price_id 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3608 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 4 [DEBUG] Query for ProductPrice 2017-07-07 12:43:15 4 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3608 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:15 4 [DEBUG] Checking manufacturer 2017-07-07 12:43:15 4 [DEBUG] No custom available fields found 2017-07-07 12:43:15 4 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,4,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:15 4 [DEBUG] Process multi-variant fields 2017-07-07 12:43:15 4 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:15 4 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:15 4 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:15 4 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\\r\\n8\\r\\n9\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"],\"3607\":[\"8\",\"2E\"],\"3608\":[\"9\",\"2E\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 5 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:16 5 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:16 5 [DEBUG] Use field value for field published 2017-07-07 12:43:16 5 [DEBUG] Use field value for field product_name 2017-07-07 12:43:16 5 [DEBUG] Use field value for field product_price 2017-07-07 12:43:16 5 [DEBUG] Use default value for field category_path 2017-07-07 12:43:16 5 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:16 5 [DEBUG] Use field value for field file_url 2017-07-07 12:43:16 5 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:16 5 [DEBUG] Use field value for field Size 2017-07-07 12:43:16 5 [DEBUG] Use field value for field Width 2017-07-07 12:43:16 5 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:16 5 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:16 5 [DEBUG] Process line 5 2017-07-07 12:43:16 5 [DEBUG] Get the currency ID 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:16 5 [DEBUG] Load a row 2017-07-07 12:43:16 5 [DEBUG] Processing item: ABC-S2 2017-07-07 12:43:16 5 [DEBUG] Looking for parent SKU 2017-07-07 12:43:16 5 [DEBUG] Checking product parent SKU 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 5 [DEBUG] Product tax: 2017-07-07 12:43:16 5 [DEBUG] Query for Product 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 5 [DEBUG] No parent found 2017-07-07 12:43:16 5 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:16 5 [DEBUG] Check product language entry 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3609 2017-07-07 12:43:16 5 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 5 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-small-4e' AND `virtuemart_product_id` != 3609 2017-07-07 12:43:16 5 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 5 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-small-4e' AND `virtuemart_product_id` != 3609 2017-07-07 12:43:16 5 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:16 5 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3609, 'first-product-small-4e') 2017-07-07 12:43:16 5 [DEBUG] Query for ProductLang 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-small-4e' 2017-07-07 12:43:16 5 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:16 5 [DEBUG] Finding a product_price_id 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3609 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 5 [DEBUG] Query for ProductPrice 2017-07-07 12:43:16 5 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3609 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 5 [DEBUG] Checking manufacturer 2017-07-07 12:43:16 5 [DEBUG] No custom available fields found 2017-07-07 12:43:16 5 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,5,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:16 5 [DEBUG] Process multi-variant fields 2017-07-07 12:43:16 5 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:16 5 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 5 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:16 5 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\\r\\n8\\r\\n9\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\\r\\n4E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"],\"3607\":[\"8\",\"2E\"],\"3608\":[\"9\",\"2E\"],\"3609\":[\"7\",\"4E\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 6 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:16 6 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:16 6 [DEBUG] Use field value for field published 2017-07-07 12:43:16 6 [DEBUG] Use field value for field product_name 2017-07-07 12:43:16 6 [DEBUG] Use field value for field product_price 2017-07-07 12:43:16 6 [DEBUG] Use default value for field category_path 2017-07-07 12:43:16 6 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:16 6 [DEBUG] Use field value for field file_url 2017-07-07 12:43:16 6 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:16 6 [DEBUG] Use field value for field Size 2017-07-07 12:43:16 6 [DEBUG] Use field value for field Width 2017-07-07 12:43:16 6 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:16 6 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:16 6 [DEBUG] Process line 6 2017-07-07 12:43:16 6 [DEBUG] Get the currency ID 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:16 6 [DEBUG] Load a row 2017-07-07 12:43:16 6 [DEBUG] Processing item: ABS-M2 2017-07-07 12:43:16 6 [DEBUG] Looking for parent SKU 2017-07-07 12:43:16 6 [DEBUG] Checking product parent SKU 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 6 [DEBUG] Product tax: 2017-07-07 12:43:16 6 [DEBUG] Query for Product 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 6 [DEBUG] No parent found 2017-07-07 12:43:16 6 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:16 6 [DEBUG] Check product language entry 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3610 2017-07-07 12:43:16 6 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 6 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-med-4e' AND `virtuemart_product_id` != 3610 2017-07-07 12:43:16 6 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 6 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-med-4e' AND `virtuemart_product_id` != 3610 2017-07-07 12:43:16 6 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:16 6 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3610, 'first-product-med-4e') 2017-07-07 12:43:16 6 [DEBUG] Query for ProductLang 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-med-4e' 2017-07-07 12:43:16 6 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:16 6 [DEBUG] Finding a product_price_id 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3610 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 6 [DEBUG] Query for ProductPrice 2017-07-07 12:43:16 6 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3610 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 6 [DEBUG] Checking manufacturer 2017-07-07 12:43:16 6 [DEBUG] No custom available fields found 2017-07-07 12:43:16 6 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,6,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:16 6 [DEBUG] Process multi-variant fields 2017-07-07 12:43:16 6 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:16 6 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 6 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:16 6 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\\r\\n8\\r\\n9\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\\r\\n4E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"],\"3607\":[\"8\",\"2E\"],\"3608\":[\"9\",\"2E\"],\"3609\":[\"7\",\"4E\"],\"3610\":[\"8\",\"4E\"]}|' WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 7 [DEBUG] Use field value for field product_sku 2017-07-07 12:43:16 7 [DEBUG] Use field value for field product_parent_sku 2017-07-07 12:43:16 7 [DEBUG] Use field value for field published 2017-07-07 12:43:16 7 [DEBUG] Use field value for field product_name 2017-07-07 12:43:16 7 [DEBUG] Use field value for field product_price 2017-07-07 12:43:16 7 [DEBUG] Use default value for field category_path 2017-07-07 12:43:16 7 [DEBUG] Use default value for field product_desc 2017-07-07 12:43:16 7 [DEBUG] Use field value for field file_url 2017-07-07 12:43:16 7 [DEBUG] Use field value for field product_currency 2017-07-07 12:43:16 7 [DEBUG] Use field value for field Size 2017-07-07 12:43:16 7 [DEBUG] Use field value for field Width 2017-07-07 12:43:16 7 [DEBUG] Use default value for field multi_variant_title 2017-07-07 12:43:16 7 [DEBUG] Use default value for field multi_variant_fields 2017-07-07 12:43:16 7 [DEBUG] Process line 7 2017-07-07 12:43:16 7 [DEBUG] Get the currency ID 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_currency_id` FROM `lvrc_virtuemart_currencies` WHERE `currency_code_3` = '52' AND `virtuemart_vendor_id` = 1 2017-07-07 12:43:16 7 [DEBUG] Load a row 2017-07-07 12:43:16 7 [DEBUG] Processing item: ABC-L2 2017-07-07 12:43:16 7 [DEBUG] Looking for parent SKU 2017-07-07 12:43:16 7 [DEBUG] Checking product parent SKU 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 7 [DEBUG] Product tax: 2017-07-07 12:43:16 7 [DEBUG] Query for Product 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products` WHERE `product_sku` = 'ABC' 2017-07-07 12:43:16 7 [DEBUG] No parent found 2017-07-07 12:43:16 7 [QUERY] SELECT customfield_params FROM lvrc_virtuemart_product_customfields WHERE virtuemart_product_id = 3605 AND customfield_value = 'stockable' 2017-07-07 12:43:16 7 [DEBUG] Check product language entry 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `lvrc_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 3611 2017-07-07 12:43:16 7 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 7 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-large-4e' AND `virtuemart_product_id` != 3611 2017-07-07 12:43:16 7 [DEBUG] Check if the product slug exists 2017-07-07 12:43:16 7 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM lvrc_virtuemart_products_en_gb WHERE `slug` = 'first-product-large-4e' AND `virtuemart_product_id` != 3611 2017-07-07 12:43:16 7 [DEBUG] Insert the dummy entry for the product language 2017-07-07 12:43:16 7 [QUERY] INSERT INTO `lvrc_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (3611, 'first-product-large-4e') 2017-07-07 12:43:16 7 [DEBUG] Query for ProductLang 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_id` FROM `lvrc_virtuemart_products_en_gb` WHERE `slug` = 'first-product-large-4e' 2017-07-07 12:43:16 7 [DEBUG] The file /var/sites/f/fenixxcell.com/public_html/images/stories/virtuemart/product/image.jpg has not been found. 2017-07-07 12:43:16 7 [DEBUG] Finding a product_price_id 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3611 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 7 [DEBUG] Query for ProductPrice 2017-07-07 12:43:16 7 [QUERY] SELECT `virtuemart_product_price_id` FROM `lvrc_virtuemart_product_prices` WHERE `virtuemart_product_id` = 3611 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 52 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-07-07 12:43:16 7 [DEBUG] Checking manufacturer 2017-07-07 12:43:16 7 [DEBUG] No custom available fields found 2017-07-07 12:43:16 7 [QUERY] INSERT INTO `lvrc_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (100,7,'Product price added','Success','Added','Product prices') 2017-07-07 12:43:16 7 [DEBUG] Process multi-variant fields 2017-07-07 12:43:16 7 [DEBUG] Load the existing customfield_params for product parent 2017-07-07 12:43:16 7 [QUERY] SELECT `customfield_params` FROM `lvrc_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 3605 2017-07-07 12:43:16 7 [DEBUG] Store the updated customfield_params 2017-07-07 12:43:16 7 [QUERY] UPDATE `lvrc_virtuemart_product_customfields` SET `customfield_params` = 'usecanonical=0|showlabels=0|sCustomId=0|selectoptions=[{\"voption\":\"clabels\",\"clabel\":\"Size\",\"values\":\"Select from:\\r\\n7\\r\\n8\\r\\n9\"},{\"voption\":\"clabels\",\"clabel\":\"Width\",\"values\":\"Select from:\\r\\n2E\\r\\n4E\"}]|clabels=0|options={\"3605\":[\"Select from:\",\"Select from:\"],\"3606\":[\"7\",\"2E\"],\"3607\":[\"8\",\"2E\"],\"3608\":[\"9\",\"2E\"],\"3609\":[\"7\",\"4E\"],\"3610\":[\"8\",\"4E\"],\"3611\":[\"9\",\"4E\"]}|' WHERE `virtuemart_product_id` = 3605