04/08/2022 09:48:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2440' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-04') 04/08/2022 09:48:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2440' , '2022-08-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 04/08/2022 09:48:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59915' 04/08/2022 09:48:42 am >> DELETE FROM ps_document_detail WHERE id_document = '59915' 04/08/2022 09:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59915' , '18015' , 'RELIQUIARIO DORATO H 32' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 04/08/2022 09:48:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18015' AND id_supplier = '' 04/08/2022 09:48:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18015' , '' , '1' ) 04/08/2022 09:55:42 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/08/2022 09:55:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19865' , '1' , '' , 'nuovo-prodotto' ) 04/08/2022 09:55:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19865' , '1' , '1' , '2' , NOW() , NOW() ) 04/08/2022 09:55:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19865' , '0' , '1' , '0' , '0' ) 04/08/2022 09:57:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002011' AND id_product != '19865' AND ean13 != '' 04/08/2022 09:57:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002011', date_upd = NOW() WHERE id_product = '19865' 04/08/2022 09:57:40 am >> UPDATE ps_product_lang SET name = 'CASULA CROCE ELICA - CSL080V', description = '' WHERE id_product = '19865' 04/08/2022 09:57:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '179.5081967213115' WHERE id_product = '19865' 04/08/2022 09:57:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '179.5081967213115', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19865' 04/08/2022 09:57:40 am >> DELETE FROM ps_specific_price WHERE id_product = '19865' 04/08/2022 09:57:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19865' 04/08/2022 09:57:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19866' , '1' , '' , 'nuovo-prodotto' ) 04/08/2022 09:57:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19866' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19865' 04/08/2022 09:57:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19866' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19865' 04/08/2022 09:58:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002012' AND id_product != '19866' AND ean13 != '' 04/08/2022 09:58:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002012', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 09:58:58 am >> UPDATE ps_product_lang SET name = 'casula croce uva - csl111', description = '' WHERE id_product = '19866' 04/08/2022 09:58:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '19866' 04/08/2022 09:58:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 09:58:58 am >> DELETE FROM ps_specific_price WHERE id_product = '19866' 04/08/2022 10:00:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002012' AND id_product != '19866' AND ean13 != '' 04/08/2022 10:00:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002012', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 10:00:15 am >> UPDATE ps_product_lang SET name = 'casula croce uva - csl111', description = '' WHERE id_product = '19866' 04/08/2022 10:00:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '19866' 04/08/2022 10:00:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 10:00:16 am >> DELETE FROM ps_specific_price WHERE id_product = '19866' 04/08/2022 10:00:17 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19866' 04/08/2022 10:00:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19867' , '1' , '' , 'nuovo-prodotto' ) 04/08/2022 10:00:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19867' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19866' 04/08/2022 10:00:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19867' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19866' 04/08/2022 10:01:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002012' AND id_product != '19866' AND ean13 != '' 04/08/2022 10:01:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002012', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 10:01:35 am >> UPDATE ps_product_lang SET name = 'CASULA CROCE UVA - CSL111', description = '' WHERE id_product = '19866' 04/08/2022 10:01:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.7541' WHERE id_product = '19866' 04/08/2022 10:01:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.7541', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19866' 04/08/2022 10:01:35 am >> DELETE FROM ps_specific_price WHERE id_product = '19866' 04/08/2022 10:02:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002013' AND id_product != '19867' AND ean13 != '' 04/08/2022 10:02:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002013', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:02:45 am >> UPDATE ps_product_lang SET name = 'CINGOLO NODO BIANCO', description = '' WHERE id_product = '19867' 04/08/2022 10:02:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '19867' 04/08/2022 10:02:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:02:45 am >> DELETE FROM ps_specific_price WHERE id_product = '19867' 04/08/2022 10:03:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002013' AND id_product != '19867' AND ean13 != '' 04/08/2022 10:03:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002013', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:03:34 am >> UPDATE ps_product_lang SET name = 'CINGOLO NODO BIANCO', description = '' WHERE id_product = '19867' 04/08/2022 10:03:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '19867' 04/08/2022 10:03:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:03:34 am >> DELETE FROM ps_specific_price WHERE id_product = '19867' 04/08/2022 10:03:34 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19867' 04/08/2022 10:03:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19868' , '1' , '' , 'nuovo-prodotto' ) 04/08/2022 10:03:34 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19868' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19867' 04/08/2022 10:03:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19868' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19867' 04/08/2022 10:07:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2441' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-04') 04/08/2022 10:07:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2441' , '2022-08-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.40' , '28.18' , NOW() , NOW() ) 04/08/2022 10:07:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59916' 04/08/2022 10:07:15 am >> DELETE FROM ps_document_detail WHERE id_document = '59916' 04/08/2022 10:07:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59916' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '800' , '-800' , '4' , '0.03' , '0.03' , '0' , '0' , '24.00' ) 04/08/2022 10:07:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 04/08/2022 10:07:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 04/08/2022 10:07:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59916' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '2' , '-2' , '4' , '1.60' , '1.6' , '0' , '0' , '3.20' ) 04/08/2022 10:07:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 04/08/2022 10:07:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 04/08/2022 10:07:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59916' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 04/08/2022 10:07:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 04/08/2022 10:07:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 04/08/2022 10:07:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002014' AND id_product != '19868' AND ean13 != '' 04/08/2022 10:07:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002014', date_upd = NOW() WHERE id_product = '19868' 04/08/2022 10:07:59 am >> UPDATE ps_product_lang SET name = 'CINGOLO 2 FIOCCHI - F9798', description = '' WHERE id_product = '19868' 04/08/2022 10:07:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19868' 04/08/2022 10:07:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19868' 04/08/2022 10:07:59 am >> DELETE FROM ps_specific_price WHERE id_product = '19868' 04/08/2022 10:08:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002013' AND id_product != '19867' AND ean13 != '' 04/08/2022 10:08:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002013', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:08:26 am >> UPDATE ps_product_lang SET name = 'CINGOLO NODO BIANCO - F9756', description = '' WHERE id_product = '19867' 04/08/2022 10:08:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8033' WHERE id_product = '19867' 04/08/2022 10:08:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8033', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19867' 04/08/2022 10:08:26 am >> DELETE FROM ps_specific_price WHERE id_product = '19867' 04/08/2022 10:08:42 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19868' 04/08/2022 10:08:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19869' , '1' , '' , 'nuovo-prodotto' ) 04/08/2022 10:08:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19869' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19868' 04/08/2022 10:08:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19869' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19868' 04/08/2022 10:09:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002015' AND id_product != '19869' AND ean13 != '' 04/08/2022 10:09:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002015', date_upd = NOW() WHERE id_product = '19869' 04/08/2022 10:09:48 am >> UPDATE ps_product_lang SET name = 'CINGOLO 2 FIOCCHI - F9799', description = '' WHERE id_product = '19869' 04/08/2022 10:09:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.9672131147541' WHERE id_product = '19869' 04/08/2022 10:09:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.9672131147541', id_tax_rules_group = '1', id_category_default = '500', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19869' 04/08/2022 10:09:48 am >> DELETE FROM ps_specific_price WHERE id_product = '19869' 04/08/2022 10:13:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1/206' , '2022-08-01' , '206' , '0' , '164' , '4674531' , 'VIA DEI CONTI FALLUC, 70/A 88100 CATANZARO' , '' , '' , '14.52' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '732.65' , '600.54' , NOW() , NOW() ) 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59917' 04/08/2022 10:13:02 am >> DELETE FROM ps_document_detail WHERE id_document = '59917' 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59917' , '19865' , 'CASULA CROCE ELICA - CSL080V' , '4' , '4' , '1' , '90' , '73.770491803279' , '22' , '3' , '426.0240' ) 04/08/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19865' AND id_supplier = '164' 04/08/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19865' , '164' , '1' ) 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59917' , '19866' , 'CASULA CROCE UVA - CSL111' , '4' , '4' , '1' , '32' , '26.229508196721' , '22' , '3' , '151.4752' ) 04/08/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19866' AND id_supplier = '164' 04/08/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19866' , '164' , '1' ) 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59917' , '19867' , 'CINGOLO NODO BIANCO - F9756' , '25' , '25' , '1' , '0.9' , '0.73770491803279' , '22' , '3' , '26.6265' ) 04/08/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19867' AND id_supplier = '164' 04/08/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19867' , '164' , '1' ) 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59917' , '19868' , 'CINGOLO 2 FIOCCHI - F9798' , '4' , '4' , '1' , '10.06' , '8.2459016393443' , '22' , '3' , '47.6200' ) 04/08/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19868' AND id_supplier = '164' 04/08/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19868' , '164' , '1' ) 04/08/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59917' , '19869' , 'CINGOLO 2 FIOCCHI - F9799' , '4' , '4' , '1' , '13.35' , '10.94262295082' , '22' , '3' , '63.1936' ) 04/08/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19869' AND id_supplier = '164' 04/08/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19869' , '164' , '1' ) 04/08/2022 11:36:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2442' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-04') 04/08/2022 11:36:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2442' , '2022-08-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 04/08/2022 11:36:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59918' 04/08/2022 11:36:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59918' 04/08/2022 11:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59918' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 04/08/2022 11:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19128' AND id_supplier = '' 04/08/2022 11:36:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19128' , '' , '1' ) 04/08/2022 02:24:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '200' , '2022-08-02' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '71.05' , '58.24' , NOW() , NOW() ) 04/08/2022 02:24:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59919' 04/08/2022 02:24:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '59919' 04/08/2022 02:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59919' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '2' , '1' , '15.9' , '13.032786885246' , '22' , '5' , '36.8562' ) 04/08/2022 02:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 04/08/2022 02:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 04/08/2022 02:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59919' , '16489' , 'CLERGY DIAMANTINO ML - C19' , '1' , '1' , '1' , '29.5' , '24.180327868852' , '22' , '5' , '34.1905' ) 04/08/2022 02:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16489' AND id_supplier = '137' 04/08/2022 02:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16489' , '137' , '1' ) 04/08/2022 06:52:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2436' AND id_document != '59906' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 04/08/2022 06:52:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2436', document_date = '2022-08-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.75', price_tax_excluded = '4.75', date_upd = NOW() WHERE id_document = '59906' 04/08/2022 06:52:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59906' 04/08/2022 06:52:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '59906' 04/08/2022 06:52:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59906' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/08/2022 06:52:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 04/08/2022 06:52:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' )