Details Date Software 2014-12-04 15:44:01 UTC Processed 358 lines #Fields: date time line_nr action comment 2014-12-04 15:44:01 0 [DEBUG] Importing filetype: csv 2014-12-04 15:44:01 0 [DEBUG] Found text enclosure " 2014-12-04 15:44:01 0 [DEBUG] Found field delimiter: 2014-12-04 15:44:01 0 [DEBUG] Load config fields 2014-12-04 15:44:01 0 [DEBUG] Field: product_height 2014-12-04 15:44:01 0 [DEBUG] Field: product_sku 2014-12-04 15:44:01 0 [DEBUG] Field: product_name 2014-12-04 15:44:01 0 [DEBUG] Field: product_parent_sku 2014-12-04 15:44:01 0 [DEBUG] Field: category_path 2014-12-04 15:44:01 0 [DEBUG] Field: product_desc 2014-12-04 15:44:01 0 [DEBUG] Field: product_s_desc 2014-12-04 15:44:01 0 [DEBUG] Field: product_price 2014-12-04 15:44:01 0 [DEBUG] Field: file_url 2014-12-04 15:44:01 0 [DEBUG] Field: file_url_thumb 2014-12-04 15:44:01 0 [DEBUG] Field: published 2014-12-04 15:44:01 0 [DEBUG] Field: manufacturer_name 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_LENGTH 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_WIDTH 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_HEIGHT 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_DIAMETER 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_WEIGHT 2014-12-04 15:44:01 0 [DEBUG] Field: SELECT_MATERIAL 2014-12-04 15:44:01 0 [DEBUG] Field: product_width 2014-12-04 15:44:01 0 [DEBUG] Using file for configuration 2014-12-04 15:44:01 0 [DEBUG] CSVI Pro Version: 5.20 2014-12-04 15:44:01 0 [DEBUG] PHP version: 5.4.35 2014-12-04 15:44:01 0 [DEBUG] action: import 2014-12-04 15:44:01 0 [DEBUG] component: com_virtuemart 2014-12-04 15:44:01 0 [DEBUG] operation: productimport 2014-12-04 15:44:01 0 [DEBUG] source: fromupload 2014-12-04 15:44:01 0 [DEBUG] Load from computer: product_export (19).csv 2014-12-04 15:44:01 0 [DEBUG] local_csv_file: 2014-12-04 15:44:01 0 [DEBUG] urlfile: 2014-12-04 15:44:01 0 [DEBUG] ftphost: 2014-12-04 15:44:01 0 [DEBUG] ftpport: 2014-12-04 15:44:01 0 [DEBUG] ftproot: 2014-12-04 15:44:01 0 [DEBUG] ftpfile: 2014-12-04 15:44:01 0 [DEBUG] auto_detect_delimiters: Yes 2014-12-04 15:44:01 0 [DEBUG] field_delimiter: 2014-12-04 15:44:01 0 [DEBUG] text_enclosure: 2014-12-04 15:44:01 0 [DEBUG] use_file_extension: 2014-12-04 15:44:01 0 [DEBUG] im_mac: No 2014-12-04 15:44:01 0 [DEBUG] use_column_headers: Yes 2014-12-04 15:44:01 0 [DEBUG] add_extra_fields: No 2014-12-04 15:44:01 0 [DEBUG] skip_first_line: No 2014-12-04 15:44:01 0 [DEBUG] overwrite_existing_data: Yes 2014-12-04 15:44:01 0 [DEBUG] ignore_non_exist: No 2014-12-04 15:44:01 0 [DEBUG] skip_default_value: No 2014-12-04 15:44:01 0 [DEBUG] collect_debug_info: Yes 2014-12-04 15:44:01 0 [DEBUG] xml_record_name: 2014-12-04 15:44:01 0 [DEBUG] language: en-GB 2014-12-04 15:44:01 0 [DEBUG] category_separator: / 2014-12-04 15:44:01 0 [DEBUG] append_categories: No 2014-12-04 15:44:01 0 [DEBUG] update_based_on: product_sku 2014-12-04 15:44:01 0 [DEBUG] mpn_column_name: 2014-12-04 15:44:01 0 [DEBUG] unpublish_before_import: No 2014-12-04 15:44:01 0 [DEBUG] recreate_alias: No 2014-12-04 15:44:01 0 [DEBUG] update_stockable_parent: No 2014-12-04 15:44:01 0 [DEBUG] use_icecat: No 2014-12-04 15:44:01 0 [DEBUG] similar_sku: No 2014-12-04 15:44:01 0 [DEBUG] process_image: Yes 2014-12-04 15:44:01 0 [DEBUG] delete_product_images: No 2014-12-04 15:44:01 0 [DEBUG] auto_generate_image_name: No 2014-12-04 15:44:01 0 [DEBUG] type_generate_image_name: product_sku 2014-12-04 15:44:01 0 [DEBUG] autogenerateext: jpg 2014-12-04 15:44:01 0 [DEBUG] change_case: none 2014-12-04 15:44:01 0 [DEBUG] autofill: No 2014-12-04 15:44:01 0 [DEBUG] keep_original: No 2014-12-04 15:44:01 0 [DEBUG] convert_type: none 2014-12-04 15:44:01 0 [DEBUG] save_images_on_server: No 2014-12-04 15:44:01 0 [DEBUG] redownload_external_image: Yes 2014-12-04 15:44:01 0 [DEBUG] full_resize: No 2014-12-04 15:44:01 0 [DEBUG] full_width: 2014-12-04 15:44:01 0 [DEBUG] full_height: 2014-12-04 15:44:01 0 [DEBUG] full_watermark: No 2014-12-04 15:44:01 0 [DEBUG] full_watermark_right: 2014-12-04 15:44:01 0 [DEBUG] full_watermark_bottom: 2014-12-04 15:44:01 0 [DEBUG] full_watermark_image: 2014-12-04 15:44:01 0 [DEBUG] thumb_check_filetype: No 2014-12-04 15:44:01 0 [DEBUG] thumb_create: No 2014-12-04 15:44:01 0 [DEBUG] thumb_extension: none 2014-12-04 15:44:01 0 [DEBUG] thumb_width: 90 2014-12-04 15:44:01 0 [DEBUG] thumb_height: 90 2014-12-04 15:44:01 0 [DEBUG] resize_max_width: 1024 2014-12-04 15:44:01 0 [DEBUG] resize_max_height: 768 2014-12-04 15:44:01 0 [DEBUG] file_location_product_files: images/stories/virtuemart/product/ 2014-12-04 15:44:01 0 [DEBUG] use_system_limits: No 2014-12-04 15:44:01 0 [DEBUG] max_execution_time: 2014-12-04 15:44:01 0 [DEBUG] memory_limit: 2014-12-04 15:44:01 0 [DEBUG] post_max_size: 2014-12-04 15:44:01 0 [DEBUG] upload_max_filesize: 2014-12-04 15:44:01 0 [DEBUG] template_name: template 2014-12-04 15:44:01 0 [DEBUG] id: 10 2014-12-04 15:44:02 0 [DEBUG] Load custom fields 2014-12-04 15:44:02 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`field_type`, TRIM(`custom_title`) AS `title`,`custom_parent_id` FROM `hxtz4_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','X') 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use field value 2014-12-04 15:44:02 1 [DEBUG] Use field value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use field value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use field value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Process line 1 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Use default value 2014-12-04 15:44:02 1 [DEBUG] Get the product currency 2014-12-04 15:44:02 1 [DEBUG] Get the product currency 2014-12-04 15:44:02 1 [QUERY] SELECT vendor_currency FROM hxtz4_virtuemart_vendors WHERE virtuemart_vendor_id = 1 2014-12-04 15:44:02 1 [DEBUG] Finding product parent SKU for child product 2014-12-04 15:44:02 1 [DEBUG] No product SKU or ID found 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use field value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Process line 2 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Use default value 2014-12-04 15:44:02 2 [DEBUG] Get the product currency 2014-12-04 15:44:02 2 [DEBUG] No product SKU or ID found 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Use default value 2014-12-04 15:44:02 3 [DEBUG] Process line 3 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Find product ID based on product SKU 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_product_id` FROM `hxtz4_virtuemart_products` WHERE `product_sku` = 'test 001' 2014-12-04 15:44:02 3 [DEBUG] Use field value 2014-12-04 15:44:02 3 [DEBUG] Check to see if the vendor ID exists 2014-12-04 15:44:02 3 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM hxtz4_virtuemart_products WHERE product_sku = 'test 001' 2014-12-04 15:44:02 3 [DEBUG] Get the product currency 2014-12-04 15:44:02 3 [DEBUG] Processing SKU: test 001 2014-12-04 15:44:02 3 [DEBUG] Product tax 2014-12-04 15:44:02 3 [DEBUG] Manufacturer import 2014-12-04 15:44:02 3 [DEBUG] Retrieve manufacturer ID based on product SKU 2014-12-04 15:44:02 3 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `hxtz4_virtuemart_product_manufacturers` AS `m` LEFT JOIN `hxtz4_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'test 001' 2014-12-04 15:44:02 3 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 3 [QUERY] SELECT * FROM hxtz4_virtuemart_manufacturers_en_gb WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 3 [DEBUG] Manufacturer language query 2014-12-04 15:44:02 3 [QUERY] UPDATE `hxtz4_virtuemart_manufacturers_en_gb` SET `mf_name`='',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='2014-12-04-03-42-131518517555' WHERE `virtuemart_manufacturer_id`='20' 2014-12-04 15:44:02 3 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 3 [QUERY] SELECT virtuemart_manufacturer_id FROM hxtz4_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 3 [DEBUG] Product query 2014-12-04 15:44:02 3 [QUERY] UPDATE `hxtz4_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='test 001',`product_gtin`='',`product_mpn`='',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='',`product_height`='',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2014-12-04 12:55:34',`created_by`='500',`modified_on`='2014-12-04 15:44:02',`modified_by`='500',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Check product language entry 2014-12-04 15:44:02 3 [QUERY] SELECT virtuemart_product_id FROM hxtz4_virtuemart_products_en_gb WHERE `virtuemart_product_id` = 1897 2014-12-04 15:44:02 3 [DEBUG] Product language query 2014-12-04 15:44:02 3 [QUERY] UPDATE `hxtz4_virtuemart_products_en_gb` SET `product_name`='Test Hoofdartikel' WHERE `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Process file: /var/www/vhosts/kerckhoeve.org/httpdocs/images/stories/virtuemart/product/300px-rubik's_cube_v3.svg.png 2014-12-04 15:44:02 3 [DEBUG] Process full image 2014-12-04 15:44:02 3 [DEBUG] Mime type found: image/png 2014-12-04 15:44:02 3 [DEBUG] Full name original: /var/www/vhosts/kerckhoeve.org/httpdocs/images/stories/virtuemart/product/300px-rubik's_cube_v3.svg.png 2014-12-04 15:44:02 3 [DEBUG] Full name target: images/stories/virtuemart/product/300px-rubik's_cube_v3.svg.png 2014-12-04 15:44:02 3 [DEBUG] Convert image: 2014-12-04 15:44:02 3 [DEBUG] Media query 2014-12-04 15:44:02 3 [QUERY] UPDATE `hxtz4_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='',`file_description`='',`file_meta`='',`file_mimetype`='image/png',`file_type`='product',`file_url`='images/stories/virtuemart/product/300px-rubik\'s_cube_v3.svg.png',`file_url_thumb`='images/stories/virtuemart/product/300px-rubik\'s_cube_v3.svg.png',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_lang`='',`published`='1' WHERE `virtuemart_media_id`='23' 2014-12-04 15:44:02 3 [DEBUG] Product image relation already exists 2014-12-04 15:44:02 3 [DEBUG] Finding a product_price_id 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `hxtz4_virtuemart_product_prices` WHERE `virtuemart_product_id` = '1897' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '47' AND `price_quantity_start` = '0' AND `price_quantity_end` = '0' AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL) 2014-12-04 15:44:02 3 [DEBUG] Storing price 2014-12-04 15:44:02 3 [QUERY] UPDATE `hxtz4_virtuemart_product_prices` SET `virtuemart_product_id`='1897',`virtuemart_shoppergroup_id`='0',`product_price`='10000',`override`='0',`product_override_price`='0.00000',`product_tax_id`='-1',`product_discount_id`='0',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='2014-12-04 12:55:34',`created_by`='500',`modified_on`='2014-12-04 13:55:02',`modified_by`='500',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='1831' 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_LENGTH 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 23, '10', '2') 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_WIDTH 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 24, '10', '3') 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_HEIGHT 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 25, '10', '4') 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_WEIGHT 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 26, '1000KG', '5') 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_MATERIAL 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 29, 'Staal', '6') 2014-12-04 15:44:02 3 [DEBUG] Processing custom available field: SELECT_DIAMETER 2014-12-04 15:44:02 3 [DEBUG] Custom field parent query 2014-12-04 15:44:02 3 [QUERY] SELECT `virtuemart_customfield_id` FROM `hxtz4_virtuemart_product_customfields` WHERE `virtuemart_custom_id`=30 AND `virtuemart_product_id`='1897' 2014-12-04 15:44:02 3 [DEBUG] Store custom available field 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`ordering`) VALUES (1897, 28, '12', '7') 2014-12-04 15:44:02 3 [DEBUG] Checking category 2014-12-04 15:44:02 3 [DEBUG] Checking category path: Test 2014-12-04 15:44:02 3 [DEBUG] Check if category path exists 2014-12-04 15:44:02 3 [QUERY] SELECT c.virtuemart_category_id FROM hxtz4_virtuemart_categories c LEFT JOIN hxtz4_virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id LEFT JOIN hxtz4_virtuemart_categories_en_gb l ON l.virtuemart_category_id = c.virtuemart_category_id WHERE l.category_name = 'Test' AND x.category_child_id = c.virtuemart_category_id AND x.category_parent_id = 0 2014-12-04 15:44:02 3 [DEBUG] Delete old category references 2014-12-04 15:44:02 3 [QUERY] DELETE FROM hxtz4_virtuemart_product_categories WHERE virtuemart_product_id = 1897 2014-12-04 15:44:02 3 [DEBUG] Check if category reference already exists 2014-12-04 15:44:02 3 [QUERY] SELECT COUNT(*) AS total FROM hxtz4_virtuemart_product_categories WHERE virtuemart_product_id = 1897 AND virtuemart_category_id = 11 2014-12-04 15:44:02 3 [DEBUG] Category reference does not yet exist 2014-12-04 15:44:02 3 [DEBUG] Add new category references 2014-12-04 15:44:02 3 [QUERY] INSERT INTO `hxtz4_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('1897','11') 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Use default value 2014-12-04 15:44:02 4 [DEBUG] Process line 4 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Find product ID based on product SKU 2014-12-04 15:44:02 4 [QUERY] SELECT `virtuemart_product_id` FROM `hxtz4_virtuemart_products` WHERE `product_sku` = 'Test schubartikel 2' 2014-12-04 15:44:02 4 [DEBUG] Use field value 2014-12-04 15:44:02 4 [DEBUG] Check to see if the vendor ID exists 2014-12-04 15:44:02 4 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM hxtz4_virtuemart_products WHERE product_sku = 'Test schubartikel 2' 2014-12-04 15:44:02 4 [DEBUG] Get the product currency 2014-12-04 15:44:02 4 [DEBUG] Finding product parent SKU for child product 2014-12-04 15:44:02 4 [DEBUG] Finding product parent SKU for child product 2014-12-04 15:44:02 4 [QUERY] SELECT virtuemart_product_id FROM hxtz4_virtuemart_products WHERE product_sku = 'test 001' 2014-12-04 15:44:02 4 [DEBUG] Processing SKU: Test schubartikel 2 2014-12-04 15:44:02 4 [DEBUG] Product tax 2014-12-04 15:44:02 4 [DEBUG] Manufacturer import 2014-12-04 15:44:02 4 [DEBUG] Retrieve manufacturer ID based on product SKU 2014-12-04 15:44:02 4 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `hxtz4_virtuemart_product_manufacturers` AS `m` LEFT JOIN `hxtz4_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'Test schubartikel 2' 2014-12-04 15:44:02 4 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 4 [QUERY] SELECT * FROM hxtz4_virtuemart_manufacturers_en_gb WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 4 [DEBUG] Manufacturer language query 2014-12-04 15:44:02 4 [QUERY] UPDATE `hxtz4_virtuemart_manufacturers_en_gb` SET `mf_name`='',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='2014-12-04-03-42-131518517555' WHERE `virtuemart_manufacturer_id`='20' 2014-12-04 15:44:02 4 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 4 [QUERY] SELECT virtuemart_manufacturer_id FROM hxtz4_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 4 [DEBUG] Product query 2014-12-04 15:44:02 4 [QUERY] UPDATE `hxtz4_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='1897',`product_sku`='Test schubartikel 2',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='',`product_height`='',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2014-12-04 15:39:08',`created_by`='500',`modified_on`='2014-12-04 15:44:02',`modified_by`='500',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='1898' 2014-12-04 15:44:02 4 [DEBUG] No parent value found 2014-12-04 15:44:02 4 [QUERY] SELECT customfield_params FROM hxtz4_virtuemart_product_customfields WHERE virtuemart_product_id = 1897 AND customfield_value = 'stockable' 2014-12-04 15:44:02 4 [DEBUG] Check product language entry 2014-12-04 15:44:02 4 [QUERY] SELECT virtuemart_product_id FROM hxtz4_virtuemart_products_en_gb WHERE `virtuemart_product_id` = 1898 2014-12-04 15:44:02 4 [DEBUG] Product language query 2014-12-04 15:44:02 4 [QUERY] UPDATE `hxtz4_virtuemart_products_en_gb` SET `product_name`='Test schubartikel 2' WHERE `virtuemart_product_id`='1898' 2014-12-04 15:44:02 4 [DEBUG] Child product and empty price, not adding so it will take the price of the parent product 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_LENGTH 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_WIDTH 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_HEIGHT 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_WEIGHT 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_MATERIAL 2014-12-04 15:44:02 4 [DEBUG] Processing custom available field: SELECT_DIAMETER 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Use default value 2014-12-04 15:44:02 5 [DEBUG] Process line 5 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Find product ID based on product SKU 2014-12-04 15:44:02 5 [QUERY] SELECT `virtuemart_product_id` FROM `hxtz4_virtuemart_products` WHERE `product_sku` = 'Test schubartikel 3' 2014-12-04 15:44:02 5 [DEBUG] Use field value 2014-12-04 15:44:02 5 [DEBUG] Check to see if the vendor ID exists 2014-12-04 15:44:02 5 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM hxtz4_virtuemart_products WHERE product_sku = 'Test schubartikel 3' 2014-12-04 15:44:02 5 [DEBUG] Get the product currency 2014-12-04 15:44:02 5 [DEBUG] Finding product parent SKU for child product 2014-12-04 15:44:02 5 [DEBUG] Finding product parent SKU for child product 2014-12-04 15:44:02 5 [QUERY] SELECT virtuemart_product_id FROM hxtz4_virtuemart_products WHERE product_sku = 'test 001' 2014-12-04 15:44:02 5 [DEBUG] Processing SKU: Test schubartikel 3 2014-12-04 15:44:02 5 [DEBUG] Product tax 2014-12-04 15:44:02 5 [DEBUG] Manufacturer import 2014-12-04 15:44:02 5 [DEBUG] Retrieve manufacturer ID based on product SKU 2014-12-04 15:44:02 5 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `hxtz4_virtuemart_product_manufacturers` AS `m` LEFT JOIN `hxtz4_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'Test schubartikel 3' 2014-12-04 15:44:02 5 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 5 [QUERY] SELECT * FROM hxtz4_virtuemart_manufacturers_en_gb WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 5 [DEBUG] Manufacturer language query 2014-12-04 15:44:02 5 [QUERY] UPDATE `hxtz4_virtuemart_manufacturers_en_gb` SET `mf_name`='',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='2014-12-04-03-42-131518517555' WHERE `virtuemart_manufacturer_id`='20' 2014-12-04 15:44:02 5 [DEBUG] Manufacturer already exists 2014-12-04 15:44:02 5 [QUERY] SELECT virtuemart_manufacturer_id FROM hxtz4_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '20' 2014-12-04 15:44:02 5 [DEBUG] Product query 2014-12-04 15:44:02 5 [QUERY] UPDATE `hxtz4_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='1897',`product_sku`='Test schubartikel 3',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='',`product_height`='',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2014-12-04 15:39:08',`created_by`='500',`modified_on`='2014-12-04 15:44:02',`modified_by`='500',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='1899' 2014-12-04 15:44:02 5 [DEBUG] No parent value found 2014-12-04 15:44:02 5 [QUERY] SELECT customfield_params FROM hxtz4_virtuemart_product_customfields WHERE virtuemart_product_id = 1897 AND customfield_value = 'stockable' 2014-12-04 15:44:02 5 [DEBUG] Check product language entry 2014-12-04 15:44:02 5 [QUERY] SELECT virtuemart_product_id FROM hxtz4_virtuemart_products_en_gb WHERE `virtuemart_product_id` = 1899 2014-12-04 15:44:02 5 [DEBUG] Product language query 2014-12-04 15:44:02 5 [QUERY] UPDATE `hxtz4_virtuemart_products_en_gb` SET `product_name`='Test schubartikel 3' WHERE `virtuemart_product_id`='1899' 2014-12-04 15:44:02 5 [DEBUG] Child product and empty price, not adding so it will take the price of the parent product 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_LENGTH 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_WIDTH 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_HEIGHT 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_WEIGHT 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_MATERIAL 2014-12-04 15:44:02 5 [DEBUG] Processing custom available field: SELECT_DIAMETER 2014-12-04 15:45:37 0 [DEBUG] Clean up old logs. Found 22 logs and threshold is 25 logs