Details Date 2020-10-24 08:46:23 UTC Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT Date Time Line Action Comment Processed 818 lines 2020-10-24 08:46:23 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs 2020-10-24 08:46:29 0 [DEBUG] Found field delimiter: ~ 2020-10-24 08:46:29 0 [DEBUG] Found field delimiter: ~ 2020-10-24 08:46:29 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2020-10-24 08:46:29 0 [QUERY] SELECT `a`.`csvi_name` FROM `k14d3_csvi_availablefields` AS `a` LEFT JOIN `k14d3_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' 2020-10-24 08:46:29 0 [DEBUG] Load the fields to process 2020-10-24 08:46:29 0 [DEBUG] Field name: product_sku 2020-10-24 08:46:29 0 [DEBUG] Field name: product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Field name: product_name 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_name 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_name 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_name 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_name 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:29 0 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 0 [DEBUG] Found field delimiter: ~ 2020-10-24 08:46:34 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2020-10-24 08:46:34 0 [QUERY] SELECT `a`.`csvi_name` FROM `k14d3_csvi_availablefields` AS `a` LEFT JOIN `k14d3_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' 2020-10-24 08:46:34 0 [DEBUG] Load the fields to process 2020-10-24 08:46:34 0 [DEBUG] Field name: product_sku 2020-10-24 08:46:34 0 [DEBUG] Field name: product_parent_sku 2020-10-24 08:46:34 0 [DEBUG] Field name: product_name 2020-10-24 08:46:34 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2020-10-24 08:46:34 0 [DEBUG] Found field delimiter: ~ 2020-10-24 08:46:34 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2020-10-24 08:46:34 0 [QUERY] SELECT `a`.`csvi_name` FROM `k14d3_csvi_availablefields` AS `a` LEFT JOIN `k14d3_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' 2020-10-24 08:46:34 0 [DEBUG] Load the fields to process 2020-10-24 08:46:34 0 [DEBUG] Field name: product_sku 2020-10-24 08:46:34 0 [DEBUG] Field name: product_parent_sku 2020-10-24 08:46:34 0 [DEBUG] Field name: product_name 2020-10-24 08:46:34 0 [DEBUG] ========== 2020-10-24 08:46:34 0 [DEBUG] RO CSVI Version: 7.18.0 2020-10-24 08:46:34 0 [DEBUG] PHP version: 7.4.10 2020-10-24 08:46:34 0 [DEBUG] Action: import 2020-10-24 08:46:34 0 [DEBUG] Component: com_virtuemart 2020-10-24 08:46:34 0 [DEBUG] Operation: product 2020-10-24 08:46:34 0 [DEBUG] Override: 2020-10-24 08:46:34 0 [DEBUG] Source: fromupload 2020-10-24 08:46:34 0 [DEBUG] Load from your computer: /home/lexa5345/biosource2020/tmp/com_csvi/3094765178/testimportenfant.csv 2020-10-24 08:46:34 0 [DEBUG] Load from server: 2020-10-24 08:46:34 0 [DEBUG] Delete after import: No 2020-10-24 08:46:34 0 [DEBUG] Load from URL: http:// 2020-10-24 08:46:34 0 [DEBUG] URL Username: 2020-10-24 08:46:34 0 [DEBUG] Name of username field: user 2020-10-24 08:46:34 0 [DEBUG] URL Password: 2020-10-24 08:46:34 0 [DEBUG] Name of the password field: password 2020-10-24 08:46:34 0 [DEBUG] Retrieve method: get 2020-10-24 08:46:34 0 [DEBUG] Authorization Type: htaccess 2020-10-24 08:46:34 0 [DEBUG] Encode URL: Yes 2020-10-24 08:46:34 0 [DEBUG] FTP Host: 2020-10-24 08:46:34 0 [DEBUG] FTP Port: 2020-10-24 08:46:34 0 [DEBUG] SFTP: No 2020-10-24 08:46:34 0 [DEBUG] FTP Root Folder: 2020-10-24 08:46:34 0 [DEBUG] FTP Filename: 2020-10-24 08:46:34 0 [DEBUG] Connection type: 2020-10-24 08:46:34 0 [DEBUG] Table list: 2020-10-24 08:46:34 0 [DEBUG] Username: 2020-10-24 08:46:34 0 [DEBUG] Host: 2020-10-24 08:46:34 0 [DEBUG] Port: 2020-10-24 08:46:34 0 [DEBUG] Database name: 2020-10-24 08:46:34 0 [DEBUG] Database table: 2020-10-24 08:46:34 0 [DEBUG] Client ID: 2020-10-24 08:46:34 0 [DEBUG] Client Secret: 2020-10-24 08:46:34 0 [DEBUG] Access token: 2020-10-24 08:46:34 0 [DEBUG] Access token details: 2020-10-24 08:46:34 0 [DEBUG] Spreadsheet Id: 2020-10-24 08:46:34 0 [DEBUG] Sheet name: 2020-10-24 08:46:34 0 [DEBUG] From Cell: 2020-10-24 08:46:34 0 [DEBUG] To Cell: 2020-10-24 08:46:34 0 [DEBUG] Autodetect delimiters: Yes 2020-10-24 08:46:34 0 [DEBUG] Field Delimiter: comma 2020-10-24 08:46:34 0 [DEBUG] Text Enclosure: 2020-10-24 08:46:34 0 [DEBUG] Use file extension: 2020-10-24 08:46:34 0 [DEBUG] I'm Mac: No 2020-10-24 08:46:34 0 [DEBUG] Use file for configuration: No 2020-10-24 08:46:34 0 [DEBUG] Add extra fields: No 2020-10-24 08:46:34 0 [DEBUG] Skip first line: Yes 2020-10-24 08:46:34 0 [DEBUG] Overwrite existing data: Yes 2020-10-24 08:46:34 0 [DEBUG] Skip new items: No 2020-10-24 08:46:34 0 [DEBUG] Skip empty custom fields: No 2020-10-24 08:46:34 0 [DEBUG] Record name: 2020-10-24 08:46:34 0 [DEBUG] Language: fr-FR 2020-10-24 08:46:34 0 [DEBUG] Category separator: / 2020-10-24 08:46:34 0 [DEBUG] Append categories: No 2020-10-24 08:46:34 0 [DEBUG] Import based on: product_sku 2020-10-24 08:46:34 0 [DEBUG] Unpublish before import: No 2020-10-24 08:46:34 0 [DEBUG] Recreate alias: No 2020-10-24 08:46:34 0 [DEBUG] Delete custom fields relations: No 2020-10-24 08:46:34 0 [DEBUG] Delete existing prices: No 2020-10-24 08:46:34 0 [DEBUG] Delete shopper groups: No 2020-10-24 08:46:34 0 [DEBUG] Delete related products: No 2020-10-24 08:46:34 0 [DEBUG] COM_CSVI_JFORM_delete_manufacturers_LABEL: No 2020-10-24 08:46:34 0 [DEBUG] Use ICEcat data: No 2020-10-24 08:46:34 0 [DEBUG] Similar SKU search: No 2020-10-24 08:46:34 0 [DEBUG] Number of images: 2020-10-24 08:46:34 0 [DEBUG] Download PDF files: No 2020-10-24 08:46:34 0 [DEBUG] Location product files: 2020-10-24 08:46:34 0 [DEBUG] Delete image relations: No 2020-10-24 08:46:34 0 [DEBUG] Create image name: No 2020-10-24 08:46:34 0 [DEBUG] Image name based on: product_sku 2020-10-24 08:46:34 0 [DEBUG] Image name format: jpg 2020-10-24 08:46:34 0 [DEBUG] Change case: none 2020-10-24 08:46:34 0 [DEBUG] Fill media fields: No 2020-10-24 08:46:34 0 [DEBUG] Update media link only: No 2020-10-24 08:46:34 0 [DEBUG] Process images: Yes 2020-10-24 08:46:34 0 [DEBUG] Keep original file: No 2020-10-24 08:46:34 0 [DEBUG] Convert image type: none 2020-10-24 08:46:34 0 [DEBUG] Save images on server: No 2020-10-24 08:46:34 0 [DEBUG] Re-download image: Yes 2020-10-24 08:46:34 0 [DEBUG] Resize large image: No 2020-10-24 08:46:34 0 [DEBUG] Full image width: 2020-10-24 08:46:34 0 [DEBUG] Full image height: 2020-10-24 08:46:34 0 [DEBUG] Check filetype: No 2020-10-24 08:46:34 0 [DEBUG] Automatic thumbnail creation: No 2020-10-24 08:46:34 0 [DEBUG] Thumbnail type: none 2020-10-24 08:46:34 0 [DEBUG] Thumbnail width: 90 2020-10-24 08:46:34 0 [DEBUG] Thumbnail height: 90 2020-10-24 08:46:34 0 [DEBUG] Maximum width resize: 1024 2020-10-24 08:46:34 0 [DEBUG] Maximum height resize: 768 2020-10-24 08:46:34 0 [DEBUG] Watermark: No 2020-10-24 08:46:34 0 [DEBUG] Right margin: No 2020-10-24 08:46:34 0 [DEBUG] Bottom margin: No 2020-10-24 08:46:34 0 [DEBUG] Image: 2020-10-24 08:46:34 0 [DEBUG] URL Username: 2020-10-24 08:46:34 0 [DEBUG] URL Password: 2020-10-24 08:46:34 0 [DEBUG] Retrieve method: post 2020-10-24 08:46:34 0 [DEBUG] Authorization Type: htaccess 2020-10-24 08:46:34 0 [DEBUG] Encode URL: Yes 2020-10-24 08:46:34 0 [DEBUG] Verify SSL: Yes 2020-10-24 08:46:34 0 [DEBUG] Lines per import: 1000 2020-10-24 08:46:34 0 [DEBUG] Time between imports: 5 2020-10-24 08:46:34 0 [DEBUG] Override system limits?: No 2020-10-24 08:46:34 0 [DEBUG] Maximum execution time: 2020-10-24 08:46:34 0 [DEBUG] Maximum amount of memory: 2020-10-24 08:46:34 0 [DEBUG] Maximum size of POST data in megabytes: 2020-10-24 08:46:34 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2020-10-24 08:46:34 0 [DEBUG] Template ID: 44 2020-10-24 08:46:34 0 [DEBUG] Tags: 2020-10-24 08:46:34 0 [DEBUG] ========== 2020-10-24 08:46:34 0 [DEBUG] Updating start date and time of import 2020-10-24 08:46:34 0 [QUERY] UPDATE `k14d3_csvi_logs` SET `start` = '2020-10-24 08:46:34' WHERE `csvi_log_id` = 44 2020-10-24 08:46:34 0 [DEBUG] Load the custom fields 2020-10-24 08:46:34 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`custom_parent_id`,`field_type`,TRIM(`custom_title`) AS `title`,`ordering` FROM `k14d3_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering` 2020-10-24 08:46:34 0 [DEBUG] Load stockable custom fields 2020-10-24 08:46:34 0 [QUERY] SELECT `custom_title` FROM `k14d3_virtuemart_customs` WHERE `custom_element` = 'stockablecustomfields' AND `field_type` = 'E' 2020-10-24 08:46:34 0 [DEBUG] Load custom fields for all 2020-10-24 08:46:34 0 [QUERY] SELECT `custom_title` FROM `k14d3_virtuemart_customs` WHERE `custom_element` = 'customfieldsforall' AND `field_type` = 'E' 2020-10-24 08:46:34 1 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 1 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 1 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 1 [DEBUG] Process line 1 2020-10-24 08:46:34 1 [DEBUG] Check if the vendor exists 2020-10-24 08:46:34 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'AR01836' 2020-10-24 08:46:34 1 [DEBUG] Load a row 2020-10-24 08:46:34 1 [DEBUG] Processing item: AR01836 2020-10-24 08:46:34 1 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 1 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 1 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 1 [DEBUG] Product tax: 2020-10-24 08:46:34 1 [DEBUG] Query for Product 2020-10-24 08:46:34 1 [DEBUG] Executed store 2020-10-24 08:46:34 1 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR01836','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 1 [DEBUG] No parent found 2020-10-24 08:46:34 1 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 1 [DEBUG] Check product language entry 2020-10-24 08:46:34 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 718 2020-10-24 08:46:34 1 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-orangee-sac-de-12-5-kg' AND `virtuemart_product_id` != 718 2020-10-24 08:46:34 1 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-orangee-sac-de-12-5-kg' AND `virtuemart_product_id` != 718 2020-10-24 08:46:34 1 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 1 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (718, 'enduit-a-l-argile-argil-deco-terre-orangee-sac-de-12-5-kg') 2020-10-24 08:46:34 1 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 1 [DEBUG] Executed store 2020-10-24 08:46:34 1 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE ORANGEE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-orangee-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '718' 2020-10-24 08:46:34 1 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 1 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 1 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 1 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 1 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 1 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 1 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 718 2020-10-24 08:46:34 2 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 2 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 2 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 2 [DEBUG] Process line 2 2020-10-24 08:46:34 2 [DEBUG] Load a row 2020-10-24 08:46:34 2 [DEBUG] Processing item: AR03020 2020-10-24 08:46:34 2 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 2 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 2 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 2 [DEBUG] Product tax: 2020-10-24 08:46:34 2 [DEBUG] Query for Product 2020-10-24 08:46:34 2 [DEBUG] Executed store 2020-10-24 08:46:34 2 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03020','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 2 [DEBUG] No parent found 2020-10-24 08:46:34 2 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 2 [DEBUG] Check product language entry 2020-10-24 08:46:34 2 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 719 2020-10-24 08:46:34 2 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-anthracite-sac-de-12-5-kg' AND `virtuemart_product_id` != 719 2020-10-24 08:46:34 2 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-anthracite-sac-de-12-5-kg' AND `virtuemart_product_id` != 719 2020-10-24 08:46:34 2 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 2 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (719, 'enduit-a-l-argile-argil-deco-anthracite-sac-de-12-5-kg') 2020-10-24 08:46:34 2 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 2 [DEBUG] Executed store 2020-10-24 08:46:34 2 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO ANTHRACITE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-anthracite-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '719' 2020-10-24 08:46:34 2 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 2 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 2 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 2 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 2 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 2 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 2 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 719 2020-10-24 08:46:34 3 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 3 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 3 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 3 [DEBUG] Process line 3 2020-10-24 08:46:34 3 [DEBUG] Load a row 2020-10-24 08:46:34 3 [DEBUG] Processing item: AR03021 2020-10-24 08:46:34 3 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 3 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 3 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 3 [DEBUG] Product tax: 2020-10-24 08:46:34 3 [DEBUG] Query for Product 2020-10-24 08:46:34 3 [DEBUG] Executed store 2020-10-24 08:46:34 3 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03021','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 3 [DEBUG] No parent found 2020-10-24 08:46:34 3 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 3 [DEBUG] Check product language entry 2020-10-24 08:46:34 3 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 720 2020-10-24 08:46:34 3 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-blanc-sac-de-12-5-kg' AND `virtuemart_product_id` != 720 2020-10-24 08:46:34 3 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-blanc-sac-de-12-5-kg' AND `virtuemart_product_id` != 720 2020-10-24 08:46:34 3 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 3 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (720, 'enduit-a-l-argile-argil-deco-blanc-sac-de-12-5-kg') 2020-10-24 08:46:34 3 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 3 [DEBUG] Executed store 2020-10-24 08:46:34 3 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO BLANC (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-blanc-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '720' 2020-10-24 08:46:34 3 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 3 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 3 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 3 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 3 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 3 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 3 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 720 2020-10-24 08:46:34 4 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 4 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 4 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 4 [DEBUG] Process line 4 2020-10-24 08:46:34 4 [DEBUG] Load a row 2020-10-24 08:46:34 4 [DEBUG] Processing item: AR03022 2020-10-24 08:46:34 4 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 4 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 4 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 4 [DEBUG] Product tax: 2020-10-24 08:46:34 4 [DEBUG] Query for Product 2020-10-24 08:46:34 4 [DEBUG] Executed store 2020-10-24 08:46:34 4 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03022','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 4 [DEBUG] No parent found 2020-10-24 08:46:34 4 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 4 [DEBUG] Check product language entry 2020-10-24 08:46:34 4 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 721 2020-10-24 08:46:34 4 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 4 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-bleu-clair-sac-de-12-5-kg' AND `virtuemart_product_id` != 721 2020-10-24 08:46:34 4 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 4 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-bleu-clair-sac-de-12-5-kg' AND `virtuemart_product_id` != 721 2020-10-24 08:46:34 4 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 4 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (721, 'enduit-a-l-argile-argil-deco-bleu-clair-sac-de-12-5-kg') 2020-10-24 08:46:34 4 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 4 [DEBUG] Executed store 2020-10-24 08:46:34 4 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO BLEU CLAIR (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-bleu-clair-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '721' 2020-10-24 08:46:34 4 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 4 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 4 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 4 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 4 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 4 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 4 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 721 2020-10-24 08:46:34 5 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 5 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 5 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 5 [DEBUG] Process line 5 2020-10-24 08:46:34 5 [DEBUG] Load a row 2020-10-24 08:46:34 5 [DEBUG] Processing item: AR03023 2020-10-24 08:46:34 5 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 5 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 5 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 5 [DEBUG] Product tax: 2020-10-24 08:46:34 5 [DEBUG] Query for Product 2020-10-24 08:46:34 5 [DEBUG] Executed store 2020-10-24 08:46:34 5 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03023','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 5 [DEBUG] No parent found 2020-10-24 08:46:34 5 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 5 [DEBUG] Check product language entry 2020-10-24 08:46:34 5 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 722 2020-10-24 08:46:34 5 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 5 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-gris-souris-sac-de-12-5-kg' AND `virtuemart_product_id` != 722 2020-10-24 08:46:34 5 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 5 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-gris-souris-sac-de-12-5-kg' AND `virtuemart_product_id` != 722 2020-10-24 08:46:34 5 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 5 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (722, 'enduit-a-l-argile-argil-deco-gris-souris-sac-de-12-5-kg') 2020-10-24 08:46:34 5 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 5 [DEBUG] Executed store 2020-10-24 08:46:34 5 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO GRIS SOURIS (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-gris-souris-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '722' 2020-10-24 08:46:34 5 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 5 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 5 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 5 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 5 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 5 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 5 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 722 2020-10-24 08:46:34 6 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 6 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 6 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 6 [DEBUG] Process line 6 2020-10-24 08:46:34 6 [DEBUG] Load a row 2020-10-24 08:46:34 6 [DEBUG] Processing item: AR03024 2020-10-24 08:46:34 6 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 6 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 6 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 6 [DEBUG] Product tax: 2020-10-24 08:46:34 6 [DEBUG] Query for Product 2020-10-24 08:46:34 6 [DEBUG] Executed store 2020-10-24 08:46:34 6 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03024','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 6 [DEBUG] No parent found 2020-10-24 08:46:34 6 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 6 [DEBUG] Check product language entry 2020-10-24 08:46:34 6 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 723 2020-10-24 08:46:34 6 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 6 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-jaune-clair-sac-de-12-5-kg' AND `virtuemart_product_id` != 723 2020-10-24 08:46:34 6 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 6 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-jaune-clair-sac-de-12-5-kg' AND `virtuemart_product_id` != 723 2020-10-24 08:46:34 6 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 6 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (723, 'enduit-a-l-argile-argil-deco-jaune-clair-sac-de-12-5-kg') 2020-10-24 08:46:34 6 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 6 [DEBUG] Executed store 2020-10-24 08:46:34 6 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO JAUNE CLAIR (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-jaune-clair-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '723' 2020-10-24 08:46:34 6 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 6 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 6 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 6 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 6 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 6 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 6 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 723 2020-10-24 08:46:34 7 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 7 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 7 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 7 [DEBUG] Process line 7 2020-10-24 08:46:34 7 [DEBUG] Load a row 2020-10-24 08:46:34 7 [DEBUG] Processing item: AR03025 2020-10-24 08:46:34 7 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 7 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 7 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 7 [DEBUG] Product tax: 2020-10-24 08:46:34 7 [DEBUG] Query for Product 2020-10-24 08:46:34 7 [DEBUG] Executed store 2020-10-24 08:46:34 7 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03025','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 7 [DEBUG] No parent found 2020-10-24 08:46:34 7 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 7 [DEBUG] Check product language entry 2020-10-24 08:46:34 7 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 724 2020-10-24 08:46:34 7 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 7 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-jaune-sac-de-12-5-kg' AND `virtuemart_product_id` != 724 2020-10-24 08:46:34 7 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 7 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-jaune-sac-de-12-5-kg' AND `virtuemart_product_id` != 724 2020-10-24 08:46:34 7 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 7 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (724, 'enduit-a-l-argile-argil-deco-jaune-sac-de-12-5-kg') 2020-10-24 08:46:34 7 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 7 [DEBUG] Executed store 2020-10-24 08:46:34 7 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO JAUNE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-jaune-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '724' 2020-10-24 08:46:34 7 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 7 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 7 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 7 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 7 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 7 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 7 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 724 2020-10-24 08:46:34 8 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 8 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 8 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 8 [DEBUG] Process line 8 2020-10-24 08:46:34 8 [DEBUG] Load a row 2020-10-24 08:46:34 8 [DEBUG] Processing item: AR03026 2020-10-24 08:46:34 8 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 8 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 8 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 8 [DEBUG] Product tax: 2020-10-24 08:46:34 8 [DEBUG] Query for Product 2020-10-24 08:46:34 8 [DEBUG] Executed store 2020-10-24 08:46:34 8 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03026','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 8 [DEBUG] No parent found 2020-10-24 08:46:34 8 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 8 [DEBUG] Check product language entry 2020-10-24 08:46:34 8 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 725 2020-10-24 08:46:34 8 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 8 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-ocre-jaune-sac-de-12-5-kg' AND `virtuemart_product_id` != 725 2020-10-24 08:46:34 8 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 8 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-ocre-jaune-sac-de-12-5-kg' AND `virtuemart_product_id` != 725 2020-10-24 08:46:34 8 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 8 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (725, 'enduit-a-l-argile-argil-deco-ocre-jaune-sac-de-12-5-kg') 2020-10-24 08:46:34 8 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 8 [DEBUG] Executed store 2020-10-24 08:46:34 8 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO OCRE JAUNE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-ocre-jaune-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '725' 2020-10-24 08:46:34 8 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 8 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 8 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 8 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 8 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 8 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 8 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 725 2020-10-24 08:46:34 9 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 9 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 9 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 9 [DEBUG] Process line 9 2020-10-24 08:46:34 9 [DEBUG] Load a row 2020-10-24 08:46:34 9 [DEBUG] Processing item: AR03027 2020-10-24 08:46:34 9 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 9 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 9 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 9 [DEBUG] Product tax: 2020-10-24 08:46:34 9 [DEBUG] Query for Product 2020-10-24 08:46:34 9 [DEBUG] Executed store 2020-10-24 08:46:34 9 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03027','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 9 [DEBUG] No parent found 2020-10-24 08:46:34 9 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 9 [DEBUG] Check product language entry 2020-10-24 08:46:34 9 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 726 2020-10-24 08:46:34 9 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 9 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-rouge-sac-de-12-5-kg' AND `virtuemart_product_id` != 726 2020-10-24 08:46:34 9 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 9 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-rouge-sac-de-12-5-kg' AND `virtuemart_product_id` != 726 2020-10-24 08:46:34 9 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 9 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (726, 'enduit-a-l-argile-argil-deco-rouge-sac-de-12-5-kg') 2020-10-24 08:46:34 9 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 9 [DEBUG] Executed store 2020-10-24 08:46:34 9 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO ROUGE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-rouge-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '726' 2020-10-24 08:46:34 9 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 9 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 9 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 9 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 9 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 9 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 9 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 726 2020-10-24 08:46:34 10 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 10 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 10 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 10 [DEBUG] Process line 10 2020-10-24 08:46:34 10 [DEBUG] Load a row 2020-10-24 08:46:34 10 [DEBUG] Processing item: AR03028 2020-10-24 08:46:34 10 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 10 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 10 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 10 [DEBUG] Product tax: 2020-10-24 08:46:34 10 [DEBUG] Query for Product 2020-10-24 08:46:34 10 [DEBUG] Executed store 2020-10-24 08:46:34 10 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03028','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 10 [DEBUG] No parent found 2020-10-24 08:46:34 10 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 10 [DEBUG] Check product language entry 2020-10-24 08:46:34 10 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 727 2020-10-24 08:46:34 10 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 10 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sable-des-landes-sac-de-12-5-kg' AND `virtuemart_product_id` != 727 2020-10-24 08:46:34 10 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 10 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sable-des-landes-sac-de-12-5-kg' AND `virtuemart_product_id` != 727 2020-10-24 08:46:34 10 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 10 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (727, 'enduit-a-l-argile-argil-deco-sable-des-landes-sac-de-12-5-kg') 2020-10-24 08:46:34 10 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 10 [DEBUG] Executed store 2020-10-24 08:46:34 10 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO SABLE DES LANDES (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-sable-des-landes-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '727' 2020-10-24 08:46:34 10 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 10 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 10 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 10 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 10 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 10 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 10 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 727 2020-10-24 08:46:34 11 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 11 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 11 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 11 [DEBUG] Process line 11 2020-10-24 08:46:34 11 [DEBUG] Load a row 2020-10-24 08:46:34 11 [DEBUG] Processing item: AR03029 2020-10-24 08:46:34 11 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 11 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 11 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 11 [DEBUG] Product tax: 2020-10-24 08:46:34 11 [DEBUG] Query for Product 2020-10-24 08:46:34 11 [DEBUG] Executed store 2020-10-24 08:46:34 11 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03029','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 11 [DEBUG] No parent found 2020-10-24 08:46:34 11 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 11 [DEBUG] Check product language entry 2020-10-24 08:46:34 11 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 728 2020-10-24 08:46:34 11 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 11 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sable-sac-de-12-5-kg' AND `virtuemart_product_id` != 728 2020-10-24 08:46:34 11 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 11 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sable-sac-de-12-5-kg' AND `virtuemart_product_id` != 728 2020-10-24 08:46:34 11 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 11 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (728, 'enduit-a-l-argile-argil-deco-sable-sac-de-12-5-kg') 2020-10-24 08:46:34 11 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 11 [DEBUG] Executed store 2020-10-24 08:46:34 11 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO SABLE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-sable-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '728' 2020-10-24 08:46:34 11 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 11 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 11 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 11 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 11 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 11 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 11 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 728 2020-10-24 08:46:34 12 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 12 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 12 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 12 [DEBUG] Process line 12 2020-10-24 08:46:34 12 [DEBUG] Load a row 2020-10-24 08:46:34 12 [DEBUG] Processing item: AR03030 2020-10-24 08:46:34 12 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 12 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 12 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 12 [DEBUG] Product tax: 2020-10-24 08:46:34 12 [DEBUG] Query for Product 2020-10-24 08:46:34 12 [DEBUG] Executed store 2020-10-24 08:46:34 12 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03030','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 12 [DEBUG] No parent found 2020-10-24 08:46:34 12 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 12 [DEBUG] Check product language entry 2020-10-24 08:46:34 12 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 729 2020-10-24 08:46:34 12 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 12 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-saumon-sac-de-12-5-kg' AND `virtuemart_product_id` != 729 2020-10-24 08:46:34 12 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 12 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-saumon-sac-de-12-5-kg' AND `virtuemart_product_id` != 729 2020-10-24 08:46:34 12 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 12 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (729, 'enduit-a-l-argile-argil-deco-saumon-sac-de-12-5-kg') 2020-10-24 08:46:34 12 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 12 [DEBUG] Executed store 2020-10-24 08:46:34 12 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO SAUMON (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-saumon-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '729' 2020-10-24 08:46:34 12 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 12 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 12 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 12 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 12 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 12 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 12 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 729 2020-10-24 08:46:34 13 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 13 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 13 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 13 [DEBUG] Process line 13 2020-10-24 08:46:34 13 [DEBUG] Load a row 2020-10-24 08:46:34 13 [DEBUG] Processing item: AR03031 2020-10-24 08:46:34 13 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 13 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 13 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 13 [DEBUG] Product tax: 2020-10-24 08:46:34 13 [DEBUG] Query for Product 2020-10-24 08:46:34 13 [DEBUG] Executed store 2020-10-24 08:46:34 13 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03031','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 13 [DEBUG] No parent found 2020-10-24 08:46:34 13 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 13 [DEBUG] Check product language entry 2020-10-24 08:46:34 13 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 730 2020-10-24 08:46:34 13 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 13 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sienne-sac-de-12-5-kg' AND `virtuemart_product_id` != 730 2020-10-24 08:46:34 13 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 13 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-sienne-sac-de-12-5-kg' AND `virtuemart_product_id` != 730 2020-10-24 08:46:34 13 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 13 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (730, 'enduit-a-l-argile-argil-deco-sienne-sac-de-12-5-kg') 2020-10-24 08:46:34 13 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 13 [DEBUG] Executed store 2020-10-24 08:46:34 13 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO SIENNE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-sienne-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '730' 2020-10-24 08:46:34 13 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 13 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 13 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 13 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 13 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 13 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 13 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 730 2020-10-24 08:46:34 14 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 14 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 14 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 14 [DEBUG] Process line 14 2020-10-24 08:46:34 14 [DEBUG] Load a row 2020-10-24 08:46:34 14 [DEBUG] Processing item: AR03032 2020-10-24 08:46:34 14 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 14 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 14 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 14 [DEBUG] Product tax: 2020-10-24 08:46:34 14 [DEBUG] Query for Product 2020-10-24 08:46:34 14 [DEBUG] Executed store 2020-10-24 08:46:34 14 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03032','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 14 [DEBUG] No parent found 2020-10-24 08:46:34 14 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 14 [DEBUG] Check product language entry 2020-10-24 08:46:34 14 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 731 2020-10-24 08:46:34 14 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 14 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-blanche-sac-de-12-5-kg' AND `virtuemart_product_id` != 731 2020-10-24 08:46:34 14 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 14 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-blanche-sac-de-12-5-kg' AND `virtuemart_product_id` != 731 2020-10-24 08:46:34 14 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 14 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (731, 'enduit-a-l-argile-argil-deco-terre-blanche-sac-de-12-5-kg') 2020-10-24 08:46:34 14 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 14 [DEBUG] Executed store 2020-10-24 08:46:34 14 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE BLANCHE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-blanche-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '731' 2020-10-24 08:46:34 14 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 14 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 14 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 14 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 14 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 14 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 14 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 731 2020-10-24 08:46:34 15 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 15 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 15 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 15 [DEBUG] Process line 15 2020-10-24 08:46:34 15 [DEBUG] Load a row 2020-10-24 08:46:34 15 [DEBUG] Processing item: AR03033 2020-10-24 08:46:34 15 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 15 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 15 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 15 [DEBUG] Product tax: 2020-10-24 08:46:34 15 [DEBUG] Query for Product 2020-10-24 08:46:34 15 [DEBUG] Executed store 2020-10-24 08:46:34 15 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03033','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 15 [DEBUG] No parent found 2020-10-24 08:46:34 15 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 15 [DEBUG] Check product language entry 2020-10-24 08:46:34 15 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 732 2020-10-24 08:46:34 15 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 15 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-brune-sac-de-12-5-kg' AND `virtuemart_product_id` != 732 2020-10-24 08:46:34 15 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 15 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-brune-sac-de-12-5-kg' AND `virtuemart_product_id` != 732 2020-10-24 08:46:34 15 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 15 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (732, 'enduit-a-l-argile-argil-deco-terre-brune-sac-de-12-5-kg') 2020-10-24 08:46:34 15 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 15 [DEBUG] Executed store 2020-10-24 08:46:34 15 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE BRUNE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-brune-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '732' 2020-10-24 08:46:34 15 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 15 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 15 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 15 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 15 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 15 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 15 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 732 2020-10-24 08:46:34 16 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 16 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 16 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 16 [DEBUG] Process line 16 2020-10-24 08:46:34 16 [DEBUG] Load a row 2020-10-24 08:46:34 16 [DEBUG] Processing item: AR03034 2020-10-24 08:46:34 16 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 16 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 16 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 16 [DEBUG] Product tax: 2020-10-24 08:46:34 16 [DEBUG] Query for Product 2020-10-24 08:46:34 16 [DEBUG] Executed store 2020-10-24 08:46:34 16 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03034','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 16 [DEBUG] No parent found 2020-10-24 08:46:34 16 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 16 [DEBUG] Check product language entry 2020-10-24 08:46:34 16 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 733 2020-10-24 08:46:34 16 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 16 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-rouge-sac-de-12-5-kg' AND `virtuemart_product_id` != 733 2020-10-24 08:46:34 16 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 16 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-rouge-sac-de-12-5-kg' AND `virtuemart_product_id` != 733 2020-10-24 08:46:34 16 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 16 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (733, 'enduit-a-l-argile-argil-deco-terre-rouge-sac-de-12-5-kg') 2020-10-24 08:46:34 16 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 16 [DEBUG] Executed store 2020-10-24 08:46:34 16 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE ROUGE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-rouge-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '733' 2020-10-24 08:46:34 16 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 16 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 16 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 16 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 16 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 16 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 16 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 733 2020-10-24 08:46:34 17 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 17 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 17 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 17 [DEBUG] Process line 17 2020-10-24 08:46:34 17 [DEBUG] Load a row 2020-10-24 08:46:34 17 [DEBUG] Processing item: AR03035 2020-10-24 08:46:34 17 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 17 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 17 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 17 [DEBUG] Product tax: 2020-10-24 08:46:34 17 [DEBUG] Query for Product 2020-10-24 08:46:34 17 [DEBUG] Executed store 2020-10-24 08:46:34 17 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03035','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 17 [DEBUG] No parent found 2020-10-24 08:46:34 17 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 17 [DEBUG] Check product language entry 2020-10-24 08:46:34 17 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 734 2020-10-24 08:46:34 17 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 17 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' AND `virtuemart_product_id` != 734 2020-10-24 08:46:34 17 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 17 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' AND `virtuemart_product_id` != 734 2020-10-24 08:46:34 17 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 17 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (734, 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg') 2020-10-24 08:46:34 17 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 17 [DEBUG] Executed store 2020-10-24 08:46:34 17 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '734' 2020-10-24 08:46:34 17 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 17 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 17 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 17 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 17 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 17 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 17 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 734 2020-10-24 08:46:34 18 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 18 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 18 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 18 [DEBUG] Process line 18 2020-10-24 08:46:34 18 [DEBUG] Load a row 2020-10-24 08:46:34 18 [DEBUG] Processing item: AR03036 2020-10-24 08:46:34 18 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 18 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 18 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100' 2020-10-24 08:46:34 18 [DEBUG] Product tax: 2020-10-24 08:46:34 18 [DEBUG] Query for Product 2020-10-24 08:46:34 18 [DEBUG] Executed store 2020-10-24 08:46:34 18 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03036','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 18 [DEBUG] No parent found 2020-10-24 08:46:34 18 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable' 2020-10-24 08:46:34 18 [DEBUG] Check product language entry 2020-10-24 08:46:34 18 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 735 2020-10-24 08:46:34 18 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 18 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' AND `virtuemart_product_id` != 735 2020-10-24 08:46:34 18 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 18 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' AND `virtuemart_product_id` != 735 2020-10-24 08:46:34 18 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 18 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (735, 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg') 2020-10-24 08:46:34 18 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 18 [DEBUG] Executed store 2020-10-24 08:46:34 18 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO VERT AMANDE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '735' 2020-10-24 08:46:34 18 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 18 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 18 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 18 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 18 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 18 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 18 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 735 2020-10-24 08:46:34 19 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 19 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 19 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 19 [DEBUG] Process line 19 2020-10-24 08:46:34 19 [DEBUG] Load a row 2020-10-24 08:46:34 19 [DEBUG] Processing item: AR00865 2020-10-24 08:46:34 19 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 19 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 19 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000101' 2020-10-24 08:46:34 19 [DEBUG] Product tax: 2020-10-24 08:46:34 19 [DEBUG] Query for Product 2020-10-24 08:46:34 19 [DEBUG] Executed store 2020-10-24 08:46:34 19 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','526','AR00865','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 19 [DEBUG] No parent found 2020-10-24 08:46:34 19 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 526 AND customfield_value = 'stockable' 2020-10-24 08:46:34 19 [DEBUG] Check product language entry 2020-10-24 08:46:34 19 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 736 2020-10-24 08:46:34 19 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 19 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'charge-decorative-pour-argil-deco-mica-boite-de-750-g' AND `virtuemart_product_id` != 736 2020-10-24 08:46:34 19 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 19 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'charge-decorative-pour-argil-deco-mica-boite-de-750-g' AND `virtuemart_product_id` != 736 2020-10-24 08:46:34 19 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 19 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (736, 'charge-decorative-pour-argil-deco-mica-boite-de-750-g') 2020-10-24 08:46:34 19 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 19 [DEBUG] Executed store 2020-10-24 08:46:34 19 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='CHARGE DECORATIVE POUR ARGIL DECO MICA (Boîte de 750 g)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='charge-decorative-pour-argil-deco-mica-boite-de-750-g' WHERE `virtuemart_product_id` = '736' 2020-10-24 08:46:34 19 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 19 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 19 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 19 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 19 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 19 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 19 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 736 2020-10-24 08:46:34 20 [DEBUG] Use field value for field product_sku 2020-10-24 08:46:34 20 [DEBUG] Use field value for field product_parent_sku 2020-10-24 08:46:34 20 [DEBUG] Use field value for field product_name 2020-10-24 08:46:34 20 [DEBUG] Process line 20 2020-10-24 08:46:34 20 [DEBUG] Load a row 2020-10-24 08:46:34 20 [DEBUG] Processing item: AR00866 2020-10-24 08:46:34 20 [DEBUG] Looking for parent SKU 2020-10-24 08:46:34 20 [DEBUG] Checking product parent SKU 2020-10-24 08:46:34 20 [QUERY] SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000102' 2020-10-24 08:46:34 20 [DEBUG] Product tax: 2020-10-24 08:46:34 20 [DEBUG] Query for Product 2020-10-24 08:46:34 20 [DEBUG] Executed store 2020-10-24 08:46:34 20 [QUERY] INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','527','AR00866','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0') 2020-10-24 08:46:34 20 [DEBUG] No parent found 2020-10-24 08:46:34 20 [QUERY] SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 527 AND customfield_value = 'stockable' 2020-10-24 08:46:34 20 [DEBUG] Check product language entry 2020-10-24 08:46:34 20 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 737 2020-10-24 08:46:34 20 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 20 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'charge-decorative-pour-argil-deco-nacre-boite-de-1-5-kg' AND `virtuemart_product_id` != 737 2020-10-24 08:46:34 20 [DEBUG] Check if the product slug exists 2020-10-24 08:46:34 20 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'charge-decorative-pour-argil-deco-nacre-boite-de-1-5-kg' AND `virtuemart_product_id` != 737 2020-10-24 08:46:34 20 [DEBUG] Insert the dummy entry for the product language 2020-10-24 08:46:34 20 [QUERY] INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (737, 'charge-decorative-pour-argil-deco-nacre-boite-de-1-5-kg') 2020-10-24 08:46:34 20 [DEBUG] Query for ProductLang 2020-10-24 08:46:34 20 [DEBUG] Executed store 2020-10-24 08:46:34 20 [QUERY] UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='CHARGE DECORATIVE POUR ARGIL DECO NACRE (Boîte de 1,5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='charge-decorative-pour-argil-deco-nacre-boite-de-1-5-kg' WHERE `virtuemart_product_id` = '737' 2020-10-24 08:46:34 20 [DEBUG] Checking manufacturer 2020-10-24 08:46:34 20 [DEBUG] Processing custom available field: Disponibilité 2020-10-24 08:46:34 20 [DEBUG] Processing custom available field: prixbase 2020-10-24 08:46:34 20 [DEBUG] Processing custom available field: ongletssousproduits 2020-10-24 08:46:34 20 [DEBUG] Processing custom available field: complémentsousonglet 2020-10-24 08:46:34 20 [DEBUG] Update has fields after all processing 2020-10-24 08:46:34 20 [QUERY] UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 737