2023-03-16 13:13:49 6631 [DEBUG] Found ICEcat mpn reference: HP3DXPLABK 2023-03-16 13:13:49 6631 [DEBUG] Found ICEcat manufacturer name: HAMLET 2023-03-16 13:13:49 6631 [DEBUG] Find the ICEcat ID for manufacturer HAMLET and part number HP3DXPLABK 2023-03-16 13:13:49 6631 [QUERY] SELECT product_id FROM `jos_csvi_icecat_index` AS `i` LEFT JOIN `jos_csvi_icecat_suppliers` AS `s` ON `s`.`supplier_id` = `i`.`supplier_id` WHERE `i`.`prod_id` = 'HP3DXPLABK' AND `s`.`supplier_name` = 'HAMLET' 2023-03-16 13:13:49 6631 [DEBUG] Calling ICEcat URL: https://data.icecat.biz/export/level4/IT/24803666.xml 2023-03-16 13:13:49 6631 [DEBUG] Dialling... 2023-03-16 13:13:49 6631 [DEBUG] Finished talking to ICEcat 2023-03-16 13:13:49 6631 [DEBUG] Received data 2023-03-16 13:13:49 6631 [DEBUG] "\n\n\n\n\n\n \n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n \n <\/FeatureGroup>\n <\/CategoryFeatureGroup>\n \n \n <\/Category>\n \n \n \n \n \n \n \n \n \n \n <\/GeneratedBulletPoints>\n \n \n \n \n \n \n \n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Sign>\n <\/Signs>\n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n <\/ProductGallery>\n \n \n \n Hamlet Bobina di filamento per stampanti 3D Bio-Plastica Nero da 1kg, 1 pz, 1 kg<\/ShortSummaryDescription>\n Hamlet Bobina di filamento per stampanti 3D Bio-Plastica Nero da 1kg. Materiale di stampa: Acido polilattico (PLA), Colori di stampa: Nero, Compatibilit\u00e0 marca: Hamlet. Peso: 1 kg, Spessore: 1,75 mm. Quantit\u00e0 per pacco: 1 pz<\/LongSummaryDescription>\n <\/SummaryDescription>\n \n <\/Product>\n<\/ICECAT-interface>\n" 2023-03-16 13:13:49 6631 [DEBUG] Closed connection 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_sku 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field manufacturer_name 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_name 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field category_path 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_desc 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_in_stock 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_s_desc 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field price_with_tax 2023-03-16 13:13:49 6631 [DEBUG] Use default value for field file_url 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_weight 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_tax 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_availability 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_weight_uom 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_gtin 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field file_title 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field published 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field metakey 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field metadesc 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field low_stock_notification 2023-03-16 13:13:49 6631 [DEBUG] Use field value for field product_mpn 2023-03-16 13:13:49 6631 [DEBUG] Use default value for field min_order_level 2023-03-16 13:13:49 6631 [DEBUG] Use default value for field product_currency 2023-03-16 13:13:49 6631 [DEBUG] Use default value for field metarobot 2023-03-16 13:13:49 6631 [DEBUG] Process line 6631 2023-03-16 13:13:49 6631 [DEBUG] Get the currency ID 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_currency_id` FROM `jos_virtuemart_currencies` WHERE `currency_code_3` = 'EUR' AND `virtuemart_vendor_id` = 1 2023-03-16 13:13:49 6631 [DEBUG] Load a row 2023-03-16 13:13:49 6631 [DEBUG] Processing item: HP3DXPLABK 2023-03-16 13:13:49 6631 [DEBUG] Product tax: 22 2023-03-16 13:13:49 6631 [DEBUG] Processing product tax 2023-03-16 13:13:49 6631 [DEBUG] Check if calculation rule exists 2023-03-16 13:13:49 6631 [QUERY] SELECT `c`.`virtuemart_calc_id` FROM `jos_virtuemart_calcs` AS `c` WHERE `calc_kind` = 'Tax' AND `calc_value_mathop` = '+%' AND `calc_value` BETWEEN '22' AND '22' AND (`publish_up` = '0000-00-00 00:00:00' OR `publish_up` = '1970-01-01 00:00:00') AND (`publish_down` = '0000-00-00 00:00:00' OR `publish_down` = '1970-01-01 00:00:00') GROUP BY `c`.`virtuemart_calc_id` 2023-03-16 13:13:49 6631 [DEBUG] Found multiple calculation rules, using the first one. This is 1 2023-03-16 13:13:49 6631 [DEBUG] Query for Product 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_gtin`,`product_mpn`,`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','0','V650529-INMI','8000130591081','HP3DXPLABK','1.32','Kg','M','','3','0','0','20','0000-00-00 00:00:00','3-5d.gif','0','0','0','KG','0','min_order_level=\"1\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"','0','','index, follow','','0','1','0','2023-03-16 11:05:02','0','2023-03-16 11:05:02','0','0000-00-00 00:00:00','0') 2023-03-16 13:13:49 6631 [DEBUG] Check product language entry 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `jos_virtuemart_products_it_it` WHERE `virtuemart_product_id` = 965401 2023-03-16 13:13:49 6631 [DEBUG] Check if the product slug exists 2023-03-16 13:13:49 6631 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM jos_virtuemart_products_it_it WHERE `slug` = 'bobina-pla-1kg-x-comp-hp3dxplabk' AND `virtuemart_product_id` != 965401 2023-03-16 13:13:49 6631 [DEBUG] Check if the product slug exists 2023-03-16 13:13:49 6631 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM jos_virtuemart_products_it_it WHERE `slug` = 'bobina-pla-1kg-x-comp-hp3dxplabk' AND `virtuemart_product_id` != 965401 2023-03-16 13:13:49 6631 [DEBUG] Insert the dummy entry for the product language 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_products_it_it` (`virtuemart_product_id`,`slug`) VALUES (965401, 'bobina-pla-1kg-x-comp-hp3dxplabk') 2023-03-16 13:13:49 6631 [DEBUG] Query for ProductLang 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] UPDATE `jos_virtuemart_products_it_it` SET `product_s_desc`='3DX100 NERO SP.1.75MM.',`product_desc`='

BOBINA PLA 1KG X COMP.

3DX100 NERO SP.1.75MM.',`product_name`='BOBINA PLA 1KG X COMP. HP3DXPLABK',`metadesc`='BOBINA PLA 1KG X COMP.',`metakey`='BOBINA PLA 1KG X COMP.',`customtitle`='',`slug`='bobina-pla-1kg-x-comp-hp3dxplabk' WHERE `virtuemart_product_id` = '965401' 2023-03-16 13:13:49 6631 [DEBUG] Generate image name 2023-03-16 13:13:49 6631 [DEBUG] Create name from product SKU 2023-03-16 13:13:49 6631 [DEBUG] Created image name: V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Delete images 2023-03-16 13:13:49 6631 [QUERY] DELETE FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id`=965401 2023-03-16 13:13:49 6631 [DEBUG] Generate image name 2023-03-16 13:13:49 6631 [DEBUG] Create name from product SKU 2023-03-16 13:13:49 6631 [DEBUG] Created image name: V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Process file: /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2023-03-16 13:13:49 6631 [DEBUG] Process image file 2023-03-16 13:13:49 6631 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2023-03-16 13:13:49 6631 [DEBUG] Mime type found: image/jpeg 2023-03-16 13:13:49 6631 [DEBUG] Full name original: /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Full name target: images/stories/virtuemart/product/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Check original file: /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2023-03-16 13:13:49 6631 [DEBUG] Create thumbnail from /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/V650529-INMI.jpg to /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/resized/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Save the new image 2023-03-16 13:13:49 6631 [DEBUG] File out extension: jpg 2023-03-16 13:13:49 6631 [DEBUG] File out: /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/resized/V650529-INMI.jpg 2023-03-16 13:13:49 6631 [DEBUG] Thumbnail created 2023-03-16 13:13:49 6631 [DEBUG] Checking if the file_url exists 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_media_id` FROM `jos_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/V650529-INMI.jpg' 2023-03-16 13:13:49 6631 [DEBUG] Query for Media 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] UPDATE `jos_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='V650529',`file_description`='',`file_meta`='',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/V650529-INMI.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/V650529-INMI.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id` = '168760' 2023-03-16 13:13:49 6631 [DEBUG] Query for ProductMedia 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('965401','168760','1') 2023-03-16 13:13:49 6631 [DEBUG] Store product image relation 2023-03-16 13:13:49 6631 [DEBUG] Load a row 2023-03-16 13:13:49 6631 [DEBUG] Finding a product_price_id 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 965401 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2023-03-16 13:13:49 6631 [DEBUG] Query for ProductPrice 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_tax_id`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('965401','0','14.180327868852','0','1','47','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2023-03-16 13:13:49 6631 [DEBUG] Checking manufacturer 2023-03-16 13:13:49 6631 [DEBUG] Delete product manufacturer references 2023-03-16 13:13:49 6631 [QUERY] DELETE FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 965401 2023-03-16 13:13:49 6631 [DEBUG] Manufacturer exists 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_manufacturers_it_it` WHERE `mf_name` = 'HAMLET' 2023-03-16 13:13:49 6631 [DEBUG] Load a row 2023-03-16 13:13:49 6631 [DEBUG] Query for ManufacturerLang 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] UPDATE `jos_virtuemart_manufacturers_it_it` SET `mf_name`='HAMLET',`mf_email`='',`mf_desc`='',`mf_url`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='hamlet' WHERE `virtuemart_manufacturer_id` = '567' 2023-03-16 13:13:49 6631 [DEBUG] Manufacturer exists 2023-03-16 13:13:49 6631 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 567 2023-03-16 13:13:49 6631 [DEBUG] Query for ProductManufacturer 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('965401','567') 2023-03-16 13:13:49 6631 [DEBUG] No custom available fields found 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (1066,6631,'Product manufacturer reference added','Success','Added','Product manufacturer relations') 2023-03-16 13:13:49 6631 [DEBUG] Checking category 2023-03-16 13:13:49 6631 [DEBUG] Get the existing categories for the product 2023-03-16 13:13:49 6631 [QUERY] SELECT `id`,`virtuemart_category_id` FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 965401 2023-03-16 13:13:49 6631 [DEBUG] Query for Productcategoryxref 2023-03-16 13:13:49 6631 [DEBUG] Executed store 2023-03-16 13:13:49 6631 [QUERY] INSERT INTO `jos_virtuemart_product_categories` (`id`,`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('0','965401','767') 2023-03-16 13:13:49 6631 [DEBUG] Delete leftover product categories 2023-03-16 13:13:49 6631 [QUERY] DELETE FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 965401 AND `virtuemart_category_id` NOT IN (767) 2023-03-16 13:13:49 6631 [DEBUG] Update has fields after all processing 2023-03-16 13:13:49 6631 [QUERY] UPDATE `jos_virtuemart_products` SET `has_categories` = 1 , `has_manufacturers` = 1 , `has_medias` = 1 , `has_prices` = 1 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 965401