# # #Date: 2022-07-25 10:03:54 UTC #Software: Joomla! 4.1.5 Stable [ Kuamini ] 21-June-2022 14:00 GMT #Fields: date time line_nr action comment 2022-07-25 10:03:54 0 [DEBUG] Clean up old logs. Found 21 logs and threshold is 25 logs 2022-07-25 10:04:03 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2022-07-25 10:04:03 0 [QUERY] SELECT `a`.`csvi_name` FROM `joo4_csvi_availablefields` AS `a` LEFT JOIN `joo4_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' 2022-07-25 10:04:03 0 [DEBUG] Load the fields to process 2022-07-25 10:04:03 0 [DEBUG] Setup field: category_path 2022-07-25 10:04:03 0 [DEBUG] Setup field: created_on 2022-07-25 10:04:03 0 [DEBUG] Setup field: file_description 2022-07-25 10:04:03 0 [DEBUG] Setup field: file_meta 2022-07-25 10:04:03 0 [DEBUG] Setup field: file_ordering 2022-07-25 10:04:03 0 [DEBUG] Setup field: file_title 2022-07-25 10:04:03 0 [DEBUG] Setup field: file_url 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_available_date 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_currency 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_height 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_length 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_ordered 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_ordering 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_params 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_price 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_sku 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_unit 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_weight 2022-07-25 10:04:03 0 [DEBUG] Setup field: product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Setup field: published 2022-07-25 10:04:03 0 [DEBUG] Setup field: slug 2022-07-25 10:04:03 0 [DEBUG] Use the file for configuration 2022-07-25 10:04:03 0 [DEBUG] Use field value for field category_path 2022-07-25 10:04:03 0 [DEBUG] Use field value for field created_on 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_description 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_title 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_url 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_height 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_length 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_params 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_price 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field published 2022-07-25 10:04:03 0 [DEBUG] Use default value for field slug 2022-07-25 10:04:03 0 [DEBUG] Use field value for field category_path 2022-07-25 10:04:03 0 [DEBUG] Use field value for field created_on 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_description 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_title 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_url 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_height 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_length 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_params 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_price 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field published 2022-07-25 10:04:03 0 [DEBUG] Use default value for field slug 2022-07-25 10:04:03 0 [DEBUG] Use field value for field category_path 2022-07-25 10:04:03 0 [DEBUG] Use field value for field created_on 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_description 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_title 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_url 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_height 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_length 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_params 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_price 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field published 2022-07-25 10:04:03 0 [DEBUG] Use default value for field slug 2022-07-25 10:04:03 0 [DEBUG] Use field value for field category_path 2022-07-25 10:04:03 0 [DEBUG] Use field value for field created_on 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_description 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_title 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_url 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_height 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_length 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_params 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_price 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field published 2022-07-25 10:04:03 0 [DEBUG] Use default value for field slug 2022-07-25 10:04:03 0 [DEBUG] Use field value for field category_path 2022-07-25 10:04:03 0 [DEBUG] Use field value for field created_on 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_description 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_title 2022-07-25 10:04:03 0 [DEBUG] Use field value for field file_url 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_height 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:03 0 [DEBUG] Use default value for field product_length 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_params 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_price 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:03 0 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:03 0 [DEBUG] Use field value for field published 2022-07-25 10:04:03 0 [DEBUG] Use default value for field slug 2022-07-25 10:04:06 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2022-07-25 10:04:06 0 [QUERY] SELECT `a`.`csvi_name` FROM `joo4_csvi_availablefields` AS `a` LEFT JOIN `joo4_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' 2022-07-25 10:04:06 0 [DEBUG] Load the fields to process 2022-07-25 10:04:06 0 [DEBUG] Setup field: category_path 2022-07-25 10:04:06 0 [DEBUG] Setup field: created_on 2022-07-25 10:04:06 0 [DEBUG] Setup field: file_description 2022-07-25 10:04:06 0 [DEBUG] Setup field: file_meta 2022-07-25 10:04:06 0 [DEBUG] Setup field: file_ordering 2022-07-25 10:04:06 0 [DEBUG] Setup field: file_title 2022-07-25 10:04:06 0 [DEBUG] Setup field: file_url 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_available_date 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_currency 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_height 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_in_stock 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_length 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_lwh_uom 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_ordered 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_ordering 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_params 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_price 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_sku 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_unit 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_weight 2022-07-25 10:04:06 0 [DEBUG] Setup field: product_weight_uom 2022-07-25 10:04:06 0 [DEBUG] Setup field: published 2022-07-25 10:04:06 0 [DEBUG] Setup field: slug 2022-07-25 10:04:06 0 [DEBUG] Use the file for configuration 2022-07-25 10:04:06 0 [DEBUG] Clean up old logs. Found 21 logs and threshold is 25 logs 2022-07-25 10:04:07 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2022-07-25 10:04:07 0 [QUERY] SELECT `a`.`csvi_name` FROM `joo4_csvi_availablefields` AS `a` LEFT JOIN `joo4_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' 2022-07-25 10:04:07 0 [DEBUG] Load the fields to process 2022-07-25 10:04:07 0 [DEBUG] Setup field: category_path 2022-07-25 10:04:07 0 [DEBUG] Setup field: created_on 2022-07-25 10:04:07 0 [DEBUG] Setup field: file_description 2022-07-25 10:04:07 0 [DEBUG] Setup field: file_meta 2022-07-25 10:04:07 0 [DEBUG] Setup field: file_ordering 2022-07-25 10:04:07 0 [DEBUG] Setup field: file_title 2022-07-25 10:04:07 0 [DEBUG] Setup field: file_url 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_available_date 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_currency 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_height 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_in_stock 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_length 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_lwh_uom 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_ordered 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_ordering 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_params 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_price 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_sku 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_unit 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_weight 2022-07-25 10:04:07 0 [DEBUG] Setup field: product_weight_uom 2022-07-25 10:04:07 0 [DEBUG] Setup field: published 2022-07-25 10:04:07 0 [DEBUG] Setup field: slug 2022-07-25 10:04:07 0 [DEBUG] Use the file for configuration 2022-07-25 10:04:07 0 [DEBUG] ========== 2022-07-25 10:04:07 0 [DEBUG] RO CSVI Version: 8.3.1 2022-07-25 10:04:07 0 [DEBUG] PHP version: 7.4.30 2022-07-25 10:04:07 0 [DEBUG] Action: import 2022-07-25 10:04:07 0 [DEBUG] Component: com_virtuemart 2022-07-25 10:04:07 0 [DEBUG] Operation: product 2022-07-25 10:04:07 0 [DEBUG] Override: 2022-07-25 10:04:07 0 [DEBUG] Source: fromupload 2022-07-25 10:04:07 0 [DEBUG] Load from your computer: /homepages/41/d35514980/htdocs/joomla4/tmp/com_csvi/2225440271/CSVI_Virtuemart Produkte Export_25-07-2022_10.47_1.csv 2022-07-25 10:04:07 0 [DEBUG] Load from server: 2022-07-25 10:04:07 0 [DEBUG] Delete after import: No 2022-07-25 10:04:07 0 [DEBUG] Load from URL: https:// 2022-07-25 10:04:07 0 [DEBUG] URL Username: 2022-07-25 10:04:07 0 [DEBUG] Name of username field: user 2022-07-25 10:04:07 0 [DEBUG] URL Password: 2022-07-25 10:04:07 0 [DEBUG] Name of the password field: password 2022-07-25 10:04:07 0 [DEBUG] Retrieve method: get 2022-07-25 10:04:07 0 [DEBUG] Authorization Type: htaccess 2022-07-25 10:04:07 0 [DEBUG] Encode URL: Yes 2022-07-25 10:04:07 0 [DEBUG] FTP Host: 2022-07-25 10:04:07 0 [DEBUG] FTP Port: 2022-07-25 10:04:07 0 [DEBUG] SFTP: No 2022-07-25 10:04:07 0 [DEBUG] FTP Root Folder: 2022-07-25 10:04:07 0 [DEBUG] FTP Filename: 2022-07-25 10:04:07 0 [DEBUG] Connection type: 2022-07-25 10:04:07 0 [DEBUG] Table list: 2022-07-25 10:04:07 0 [DEBUG] Username: 2022-07-25 10:04:07 0 [DEBUG] Host: 2022-07-25 10:04:07 0 [DEBUG] Port: 2022-07-25 10:04:07 0 [DEBUG] Database name: 2022-07-25 10:04:07 0 [DEBUG] Database table: 2022-07-25 10:04:07 0 [DEBUG] Client ID: 2022-07-25 10:04:07 0 [DEBUG] Client Secret: 2022-07-25 10:04:07 0 [DEBUG] Access token: 2022-07-25 10:04:07 0 [DEBUG] Access token details: 2022-07-25 10:04:07 0 [DEBUG] Spreadsheet Id: 2022-07-25 10:04:07 0 [DEBUG] Sheet name: 2022-07-25 10:04:07 0 [DEBUG] From Cell/Column: 2022-07-25 10:04:07 0 [DEBUG] To Cell/Column: 2022-07-25 10:04:07 0 [DEBUG] Autodetect delimiters: No 2022-07-25 10:04:07 0 [DEBUG] Field Delimiter: comma 2022-07-25 10:04:07 0 [DEBUG] Text Enclosure: ' 2022-07-25 10:04:07 0 [DEBUG] Use file extension: 2022-07-25 10:04:07 0 [DEBUG] I'm Mac: No 2022-07-25 10:04:07 0 [DEBUG] Use file for configuration: Yes 2022-07-25 10:04:07 0 [DEBUG] Add extra fields: No 2022-07-25 10:04:07 0 [DEBUG] Skip first line: No 2022-07-25 10:04:07 0 [DEBUG] Skip lines: Yes 2022-07-25 10:04:07 0 [DEBUG] Overwrite existing data: Yes 2022-07-25 10:04:07 0 [DEBUG] Skip new items: No 2022-07-25 10:04:07 0 [DEBUG] Skip empty custom fields: Yes 2022-07-25 10:04:07 0 [DEBUG] Record container: 2022-07-25 10:04:07 0 [DEBUG] Record name: 2022-07-25 10:04:07 0 [DEBUG] Language: de-DE 2022-07-25 10:04:07 0 [DEBUG] Category separator: / 2022-07-25 10:04:07 0 [DEBUG] Append categories: No 2022-07-25 10:04:07 0 [DEBUG] Import based on: product_sku 2022-07-25 10:04:07 0 [DEBUG] Unpublish before import: No 2022-07-25 10:04:07 0 [DEBUG] Recreate alias: No 2022-07-25 10:04:07 0 [DEBUG] Delete custom fields relations: No 2022-07-25 10:04:07 0 [DEBUG] Delete existing prices: No 2022-07-25 10:04:07 0 [DEBUG] Delete shopper groups: No 2022-07-25 10:04:07 0 [DEBUG] Delete related products: No 2022-07-25 10:04:07 0 [DEBUG] Delete related categories: No 2022-07-25 10:04:07 0 [DEBUG] Delete manufacturers: No 2022-07-25 10:04:07 0 [DEBUG] Use ICEcat data: No 2022-07-25 10:04:07 0 [DEBUG] Similar SKU search: No 2022-07-25 10:04:07 0 [DEBUG] Number of images: 2022-07-25 10:04:07 0 [DEBUG] Download PDF files: No 2022-07-25 10:04:07 0 [DEBUG] Product name field: Name 2022-07-25 10:04:07 0 [DEBUG] Location product files: images/virtuemart/product 2022-07-25 10:04:07 0 [DEBUG] Delete image relations: No 2022-07-25 10:04:07 0 [DEBUG] Create image name: No 2022-07-25 10:04:07 0 [DEBUG] Image name based on: product_sku 2022-07-25 10:04:07 0 [DEBUG] Image name format: jpg 2022-07-25 10:04:07 0 [DEBUG] Change case: none 2022-07-25 10:04:07 0 [DEBUG] Fill media fields: No 2022-07-25 10:04:07 0 [DEBUG] Update media link only: No 2022-07-25 10:04:07 0 [DEBUG] Process images: Yes 2022-07-25 10:04:07 0 [DEBUG] Keep original file: No 2022-07-25 10:04:07 0 [DEBUG] Convert image type: none 2022-07-25 10:04:07 0 [DEBUG] Save images on server: No 2022-07-25 10:04:07 0 [DEBUG] Re-download image: Yes 2022-07-25 10:04:07 0 [DEBUG] Resize large image: No 2022-07-25 10:04:07 0 [DEBUG] Full image width: 2022-07-25 10:04:07 0 [DEBUG] Full image height: 2022-07-25 10:04:07 0 [DEBUG] Check filetype: No 2022-07-25 10:04:07 0 [DEBUG] Automatic thumbnail creation: No 2022-07-25 10:04:07 0 [DEBUG] Thumbnail type: none 2022-07-25 10:04:07 0 [DEBUG] Thumbnail width: 90 2022-07-25 10:04:07 0 [DEBUG] Thumbnail height: 90 2022-07-25 10:04:07 0 [DEBUG] Maximum width resize: 1024 2022-07-25 10:04:07 0 [DEBUG] Maximum height resize: 768 2022-07-25 10:04:07 0 [DEBUG] Watermark: No 2022-07-25 10:04:07 0 [DEBUG] Right margin: No 2022-07-25 10:04:07 0 [DEBUG] Bottom margin: No 2022-07-25 10:04:07 0 [DEBUG] Image: 2022-07-25 10:04:07 0 [DEBUG] URL Username: 2022-07-25 10:04:07 0 [DEBUG] URL Password: 2022-07-25 10:04:07 0 [DEBUG] Retrieve method: post 2022-07-25 10:04:07 0 [DEBUG] Authorization Type: htaccess 2022-07-25 10:04:07 0 [DEBUG] Encode URL: Yes 2022-07-25 10:04:07 0 [DEBUG] Verify SSL: Yes 2022-07-25 10:04:07 0 [DEBUG] Global Rules: 2022-07-25 10:04:07 0 [DEBUG] Lines per import: 1000 2022-07-25 10:04:07 0 [DEBUG] Time between imports: 5 2022-07-25 10:04:07 0 [DEBUG] Override system limits?: No 2022-07-25 10:04:07 0 [DEBUG] Maximum execution time: 2022-07-25 10:04:07 0 [DEBUG] Maximum amount of memory: 2022-07-25 10:04:07 0 [DEBUG] Maximum size of POST data in megabytes: 2022-07-25 10:04:07 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2022-07-25 10:04:07 0 [DEBUG] Template ID: 2 2022-07-25 10:04:07 0 [DEBUG] ========== 2022-07-25 10:04:07 0 [DEBUG] Updating start date and time of import 2022-07-25 10:04:07 0 [QUERY] UPDATE `joo4_csvi_logs` SET `start` = '2022-07-25 10:04:07' WHERE `csvi_log_id` = 21 2022-07-25 10:04:07 0 [DEBUG] Load the custom fields 2022-07-25 10:04:07 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`custom_parent_id`,`field_type`,TRIM(`custom_title`) AS `title`,`ordering` FROM `joo4_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering` 2022-07-25 10:04:07 0 [DEBUG] Load stockable custom fields 2022-07-25 10:04:07 0 [QUERY] SELECT `custom_title` FROM `joo4_virtuemart_customs` WHERE `custom_element` = 'stockablecustomfields' AND `field_type` = 'E' 2022-07-25 10:04:07 0 [DEBUG] Load custom fields for all 2022-07-25 10:04:07 0 [QUERY] SELECT `custom_title` FROM `joo4_virtuemart_customs` WHERE `custom_element` = 'customfieldsforall' AND `field_type` = 'E' 2022-07-25 10:04:07 1 [DEBUG] Use field value for field category_path 2022-07-25 10:04:07 1 [DEBUG] Use field value for field created_on 2022-07-25 10:04:07 1 [DEBUG] Use field value for field file_description 2022-07-25 10:04:07 1 [DEBUG] Use field value for field file_meta 2022-07-25 10:04:07 1 [DEBUG] Use field value for field file_ordering 2022-07-25 10:04:07 1 [DEBUG] Use field value for field file_title 2022-07-25 10:04:07 1 [DEBUG] Use field value for field file_url 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_available_date 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_currency 2022-07-25 10:04:07 1 [DEBUG] Use default value for field product_height 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_in_stock 2022-07-25 10:04:07 1 [DEBUG] Use default value for field product_length 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_lwh_uom 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_ordered 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_ordering 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_params 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_price 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_sku 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_unit 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_weight 2022-07-25 10:04:07 1 [DEBUG] Use field value for field product_weight_uom 2022-07-25 10:04:07 1 [DEBUG] Use field value for field published 2022-07-25 10:04:07 1 [DEBUG] Use default value for field slug 2022-07-25 10:04:07 1 [DEBUG] Process line 1 2022-07-25 10:04:07 1 [DEBUG] Check if the vendor exists 2022-07-25 10:04:07 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `joo4_virtuemart_products` WHERE `product_sku` = 'BFDELUXE' 2022-07-25 10:04:07 1 [DEBUG] Get the currency ID 2022-07-25 10:04:07 1 [QUERY] SELECT `virtuemart_currency_id` FROM `joo4_virtuemart_currencies` WHERE `currency_code_3` = 'EUR' AND `virtuemart_vendor_id` = 1 2022-07-25 10:04:07 1 [DEBUG] Load a row 2022-07-25 10:04:07 1 [DEBUG] Processing item: BFDELUXE 2022-07-25 10:04:07 1 [DEBUG] Product tax: 2022-07-25 10:04:07 1 [DEBUG] Query for Product 2022-07-25 10:04:07 1 [DEBUG] Executed store 2022-07-25 10:04:07 1 [QUERY] INSERT INTO `joo4_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_by`) VALUES ('1','0','BFDELUXE','400.0000','G','M','','100','40','0','0','2009-12-01 00:00:00','','0','0','0','GRAMM','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','1','0','11/03/2019 13:35:53','778','2022-07-25 10:04:07','778','0') 2022-07-25 10:04:07 1 [DEBUG] Check product language entry 2022-07-25 10:04:07 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `joo4_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 0 2022-07-25 10:04:07 1 [DEBUG] Check if the product slug exists 2022-07-25 10:04:07 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM joo4_virtuemart_products_de_de WHERE `slug` = '2022-07-25-10-04-071147412742' AND `virtuemart_product_id` != 0 2022-07-25 10:04:07 1 [DEBUG] Insert the dummy entry for the product language 2022-07-25 10:04:07 1 [QUERY] INSERT INTO `joo4_virtuemart_products_de_de` (`virtuemart_product_id`,`slug`) VALUES (0, '2022-07-25-10-04-071147412742')