# # #Date: 2023-03-09 07:15:01 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2023-03-09 08:35:05 5839 [DEBUG] Found ICEcat mpn reference: NWA110AX-EU0102F 2023-03-09 08:35:05 5839 [DEBUG] Found ICEcat manufacturer name: ZYXEL 2023-03-09 08:35:05 5839 [DEBUG] Find the ICEcat ID for manufacturer ZYXEL and part number NWA110AX-EU0102F 2023-03-09 08:35:05 5839 [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` = 'NWA110AX-EU0102F' AND `s`.`supplier_name` = 'ZYXEL' 2023-03-09 08:35:05 5839 [DEBUG] Calling ICEcat URL: https://data.icecat.biz/export/level4/IT/79222395.xml 2023-03-09 08:35:05 5839 [DEBUG] Dialling... 2023-03-09 08:35:06 5839 [DEBUG] Finished talking to ICEcat 2023-03-09 08:35:06 5839 [DEBUG] Received data 2023-03-09 08:35:06 5839 [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 \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 \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 <\/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 \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 \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 <\/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 <\/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 <\/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 <\/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 <\/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 <\/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 \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 <\/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 <\/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 <\/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 <\/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 \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 \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 \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 \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 <\/Measure>\n <\/LocalValue>\n \n \n \n <\/Measure>\n \n <\/Feature>\n <\/ProductFeature>\n \n \n \n \n \n \n \n \n \n \n \n <\/ProductGallery>\n \n \n \n <\/ProductMultimediaObject>\n \n \n Zyxel NWA110AX, 1000 Mbit\/s, 575 Mbit\/s, 1200 Mbit\/s, 10,100,1000 Mbit\/s, 2.412 - 2.472, 5.470 - 5.725 GHz, 0,08 GHz<\/ShortSummaryDescription>\n Zyxel NWA110AX. Velocit\u00e0 massima di trasferimento dati: 1000 Mbit\/s, Velocit\u00e0 massima di trasferimento dati (2,4 GHz): 575 Mbit\/s, Velocit\u00e0 massima di trasferimento dati (5 GHz): 1200 Mbit\/s. Algoritmi di sicurezza supportati: WPA, WPA-PSK, WPA2, WPA2-Enterprise, WPA3. Protocollo di routing: IP, Caratteristiche IPv4 e IPv6: IPv4\/IPv6 access-control list (ACL). Tensione di ingresso AC: 5 - 12 V, Corrente d'ingresso: 1.5 A, Consumi: 17 W. Installazione: Soffitto, Tavolo, Parete, Colore del prodotto: Bianco, Certificazione: FCC Part 15C FCC Part 15E ETSI EN 300 328 EN 301 893 LP0002 EMC FCC Part 15B EN 301 489-1 EN 301...<\/LongSummaryDescription>\n <\/SummaryDescription>\n \n <\/Product>\n<\/ICECAT-interface>\n" 2023-03-09 08:35:06 5839 [DEBUG] Closed connection 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_sku 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field manufacturer_name 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_name 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field category_path 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_desc 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_in_stock 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_s_desc 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field price_with_tax 2023-03-09 08:35:06 5839 [DEBUG] Use default value for field file_url 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_weight 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_tax 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_availability 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_weight_uom 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_gtin 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field file_title 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field published 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field metakey 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field metadesc 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field low_stock_notification 2023-03-09 08:35:06 5839 [DEBUG] Use field value for field product_mpn 2023-03-09 08:35:06 5839 [DEBUG] Use default value for field min_order_level 2023-03-09 08:35:06 5839 [DEBUG] Use default value for field product_currency 2023-03-09 08:35:06 5839 [DEBUG] Use default value for field metarobot 2023-03-09 08:35:06 5839 [DEBUG] Process line 5839 2023-03-09 08:35:06 5839 [DEBUG] Get the currency ID 2023-03-09 08:35:06 5839 [QUERY] SELECT `virtuemart_currency_id` FROM `jos_virtuemart_currencies` WHERE `currency_code_3` = 'EUR' AND `virtuemart_vendor_id` = 1 2023-03-09 08:35:06 5839 [DEBUG] Load a row 2023-03-09 08:35:06 5839 [DEBUG] Product tax: 22 2023-03-09 08:35:06 5839 [DEBUG] Processing product tax 2023-03-09 08:35:06 5839 [DEBUG] Check if calculation rule exists 2023-03-09 08:35:06 5839 [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-09 08:35:06 5839 [DEBUG] Found multiple calculation rules, using the first one. This is 1 2023-03-09 08:35:06 5839 [DEBUG] Query for Product 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] UPDATE `jos_virtuemart_products` SET `virtuemart_product_id`='921242',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='NWA110AX-EU0102F-FOC',`product_gtin`='4718937610259',`product_weight`='1',`product_weight_uom`='Kg',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='',`product_in_stock`='3',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='20',`product_available_date`='0000-00-00 00:00:00',`product_availability`='3-5d.gif',`product_special`='0',`product_discontinued`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"1\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"',`product_canon_category_id`=NULL,`hits`='0',`intnotes`='',`metarobot`='index, follow',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`has_categories`='1',`has_manufacturers`='1',`has_medias`='1',`has_prices`='1',`has_shoppergroups`='0',`created_on`='2022-04-03 17:34:08',`created_by`='141',`modified_on`='2023-03-09 07:15:01',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_mpn` = 'NWA110AX-EU0102F' 2023-03-09 08:35:06 5839 [DEBUG] Check product language entry 2023-03-09 08:35:06 5839 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `jos_virtuemart_products_it_it` WHERE `virtuemart_product_id` = 921242 2023-03-09 08:35:06 5839 [DEBUG] Load a row 2023-03-09 08:35:06 5839 [DEBUG] Check if the product slug exists 2023-03-09 08:35:06 5839 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM jos_virtuemart_products_it_it WHERE `slug` = 'zyxel-377168-zyxel-nwa110ax-nebulaflex-access-point-wi-fi-6-dual-band-poe' AND `virtuemart_product_id` != 921242 2023-03-09 08:35:06 5839 [DEBUG] Query for ProductLang 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] UPDATE `jos_virtuemart_products_it_it` SET `product_s_desc`='ACCESS POINT WIFI6 1LAN 1RJ45 NEBUL A CLOUD/CONTROL INDOOR/OUTDOOR',`product_desc`='ACCESS POINT WIFI6 1LAN 1RJ45 NEBUL A CLOUD/CONTROL INDOOR/OUTDOOR',`product_name`='ZYXEL NWA110AX-EU0102F ACCESS POINT WIFI6 1LAN 1RJ45 NEBUL A CLOUD/CONTROL INDOOR/OUTDOOR',`metadesc`='ACCESS POINT WIFI6 1LAN 1RJ45 NEBUL A CLOUD/CONTROL INDOOR/OUTDOOR',`metakey`='ACCESS POINT WIFI6 1LAN 1RJ45 NEBUL A CLOUD/CONTROL INDOOR/OUTDOOR',`customtitle`='',`slug`='zyxel-377168-zyxel-nwa110ax-nebulaflex-access-point-wi-fi-6-dual-band-poe' WHERE `virtuemart_product_id` = '921242' 2023-03-09 08:35:06 5839 [DEBUG] Generate image name 2023-03-09 08:35:06 5839 [DEBUG] Create name from product SKU 2023-03-09 08:35:06 5839 [DEBUG] Created image name: NWA110AX-EU0102F-FOC.jpg 2023-03-09 08:35:06 5839 [DEBUG] Delete images 2023-03-09 08:35:06 5839 [QUERY] DELETE FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id`=921242 2023-03-09 08:35:06 5839 [DEBUG] Generate image name 2023-03-09 08:35:06 5839 [DEBUG] Create name from product SKU 2023-03-09 08:35:06 5839 [DEBUG] Created image name: NWA110AX-EU0102F-FOC.jpg 2023-03-09 08:35:06 5839 [DEBUG] The file /home/uwjcyoig/domains/fatelettronica.it/public_html/images/stories/virtuemart/product/NWA110AX-EU0102F-FOC.jpg has not been found. 2023-03-09 08:35:06 5839 [DEBUG] Load a row 2023-03-09 08:35:06 5839 [DEBUG] Finding a product_price_id 2023-03-09 08:35:06 5839 [QUERY] SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 921242 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-09 08:35:06 5839 [DEBUG] Load a row 2023-03-09 08:35:06 5839 [DEBUG] Query for ProductPrice 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] UPDATE `jos_virtuemart_product_prices` SET `virtuemart_product_id`='921242',`virtuemart_shoppergroup_id`='0',`product_price`='187.70491803279',`override`='0',`product_tax_id`='1',`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`='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_product_price_id` = '920622' 2023-03-09 08:35:06 5839 [DEBUG] Checking manufacturer 2023-03-09 08:35:06 5839 [DEBUG] Delete product manufacturer references 2023-03-09 08:35:06 5839 [QUERY] DELETE FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 921242 2023-03-09 08:35:06 5839 [DEBUG] Manufacturer exists 2023-03-09 08:35:06 5839 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_manufacturers_it_it` WHERE `mf_name` = 'ZYXEL' 2023-03-09 08:35:06 5839 [DEBUG] Load a row 2023-03-09 08:35:06 5839 [DEBUG] Query for ManufacturerLang 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] UPDATE `jos_virtuemart_manufacturers_it_it` SET `mf_name`='ZYXEL',`mf_email`='',`mf_desc`='
ZYXEL
',`mf_url`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='zyxel' WHERE `virtuemart_manufacturer_id` = '251' 2023-03-09 08:35:06 5839 [DEBUG] Manufacturer exists 2023-03-09 08:35:06 5839 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 251 2023-03-09 08:35:06 5839 [DEBUG] Query for ProductManufacturer 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] INSERT INTO `jos_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('921242','251') 2023-03-09 08:35:06 5839 [DEBUG] No custom available fields found 2023-03-09 08:35:06 5839 [QUERY] INSERT INTO `jos_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (990,5839,'Product manufacturer reference added','Success','Added','Product manufacturer relations') 2023-03-09 08:35:06 5839 [DEBUG] Checking category 2023-03-09 08:35:06 5839 [DEBUG] Get the existing categories for the product 2023-03-09 08:35:06 5839 [QUERY] SELECT `id`,`virtuemart_category_id` FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 921242 2023-03-09 08:35:06 5839 [DEBUG] Query for Productcategoryxref 2023-03-09 08:35:06 5839 [DEBUG] Executed store 2023-03-09 08:35:06 5839 [QUERY] UPDATE `jos_virtuemart_product_categories` SET `virtuemart_product_id`='921242',`virtuemart_category_id`='311' WHERE `id` = '1843221' 2023-03-09 08:35:06 5839 [DEBUG] Delete leftover product categories 2023-03-09 08:35:06 5839 [QUERY] DELETE FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 921242 AND `virtuemart_category_id` NOT IN (311) 2023-03-09 08:35:06 5839 [DEBUG] Update has fields after all processing 2023-03-09 08:35:06 5839 [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` = 921242