27/05/2022 08:40:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 08:40:50 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' , '1668' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.70' , '15.82' , NOW() , NOW() ) 27/05/2022 08:40:50 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 = '58463' 27/05/2022 08:40:50 am >> DELETE FROM ps_document_detail WHERE id_document = '58463' 27/05/2022 08:40:50 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 ( '58463' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 27/05/2022 08:40:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 27/05/2022 08:40:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 27/05/2022 08:40:50 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 ( '58463' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/05/2022 08:40:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/05/2022 08:40:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/05/2022 08:40:50 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 ( '58463' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.3' , '7.3' , '0' , '0' , '7.30' ) 27/05/2022 08:40:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/05/2022 08:40:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/05/2022 09:12:04 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' , 'A2156' , '2022-05-25' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 27/05/2022 09:12:04 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 = '58464' 27/05/2022 09:12:04 am >> DELETE FROM ps_document_detail WHERE id_document = '58464' 27/05/2022 09:12:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400235906' AND id_product != '18095' AND ean13 != '' 27/05/2022 09:12:36 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400235906', date_upd = NOW() WHERE id_product = '18095' 27/05/2022 09:12:36 am >> UPDATE ps_product_lang SET name = 'CROCE IN ULIVO - 2882', description = '' WHERE id_product = '18095' 27/05/2022 09:12:36 am >> UPDATE ps_product SET wholesale_price = '8.90', on_sale = '0', price = '20.327868852459016' WHERE id_product = '18095' 27/05/2022 09:12:36 am >> UPDATE ps_product_shop SET wholesale_price = '8.90', price = '20.327868852459016', id_tax_rules_group = '1', id_category_default = '95', 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 = '18095' 27/05/2022 09:12:36 am >> DELETE FROM ps_specific_price WHERE id_product = '18095' 27/05/2022 09:22:45 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/05/2022 09:22:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19601' , '1' , '' , 'nuovo-prodotto' ) 27/05/2022 09:22:46 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19601' , '1' , '1' , '2' , NOW() , NOW() ) 27/05/2022 09:22:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19601' , '0' , '1' , '0' , '0' ) 27/05/2022 09:23:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327519' AND id_product != '19601' AND ean13 != '' 27/05/2022 09:23:57 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400327519', date_upd = NOW() WHERE id_product = '19601' 27/05/2022 09:23:57 am >> UPDATE ps_product_lang SET name = 'ANGELO ALI TORTORA - 4231', description = '' WHERE id_product = '19601' 27/05/2022 09:23:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '19601' 27/05/2022 09:23:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '95', 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 = '19601' 27/05/2022 09:23:57 am >> DELETE FROM ps_specific_price WHERE id_product = '19601' 27/05/2022 09:28:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400174724' AND id_product != '18199' AND ean13 != '' 27/05/2022 09:28:00 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400174724', date_upd = NOW() WHERE id_product = '18199' 27/05/2022 09:28:00 am >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA SANTA RITA - 2952', description = '' WHERE id_product = '18199' 27/05/2022 09:28:00 am >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '2.8689' WHERE id_product = '18199' 27/05/2022 09:28:00 am >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '2.8689', id_tax_rules_group = '1', id_category_default = '95', 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 = '18199' 27/05/2022 09:28:00 am >> DELETE FROM ps_specific_price WHERE id_product = '18199' 27/05/2022 09:28:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400179590' AND id_product != '15914' AND ean13 != '' 27/05/2022 09:28:44 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400179590', date_upd = NOW() WHERE id_product = '15914' 27/05/2022 09:28:44 am >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA MAD. DEL CARMINE', description = '' WHERE id_product = '15914' 27/05/2022 09:28:44 am >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '15914' 27/05/2022 09:28:44 am >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '15914' 27/05/2022 09:28:44 am >> DELETE FROM ps_specific_price WHERE id_product = '15914' 27/05/2022 09:29:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400174724' AND id_product != '18199' AND ean13 != '' 27/05/2022 09:29:07 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400174724', date_upd = NOW() WHERE id_product = '18199' 27/05/2022 09:29:07 am >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA SANTA RITA - 2952', description = '' WHERE id_product = '18199' 27/05/2022 09:29:07 am >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '18199' 27/05/2022 09:29:07 am >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '18199' 27/05/2022 09:29:07 am >> DELETE FROM ps_specific_price WHERE id_product = '18199' 27/05/2022 09:31:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/05/2022 09:31:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19602' , '1' , '' , 'nuovo-prodotto' ) 27/05/2022 09:31:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19602' , '1' , '1' , '2' , NOW() , NOW() ) 27/05/2022 09:31:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19602' , '0' , '1' , '0' , '0' ) 27/05/2022 09:31:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400173482' AND id_product != '19602' AND ean13 != '' 27/05/2022 09:31:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400173482', date_upd = NOW() WHERE id_product = '19602' 27/05/2022 09:31:41 am >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952', description = '' WHERE id_product = '19602' 27/05/2022 09:31:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '19602' 27/05/2022 09:31:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '2', 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 = '19602' 27/05/2022 09:31:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19602' 27/05/2022 09:32:03 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 = '19602' 27/05/2022 09:32:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19603' , '1' , '' , 'nuovo-prodotto' ) 27/05/2022 09:32:03 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 '19603' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19602' 27/05/2022 09:32:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19603' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19602' 27/05/2022 09:33:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400155402' AND id_product != '15089' AND ean13 != '' 27/05/2022 09:33:12 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400155402', date_upd = NOW() WHERE id_product = '15089' 27/05/2022 09:33:12 am >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950', description = '' WHERE id_product = '15089' 27/05/2022 09:33:12 am >> UPDATE ps_product SET wholesale_price = '2.20', on_sale = '0', price = '4.836065573770492' WHERE id_product = '15089' 27/05/2022 09:33:12 am >> UPDATE ps_product_shop SET wholesale_price = '2.20', price = '4.836065573770492', id_tax_rules_group = '1', id_category_default = '95', 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 = '15089' 27/05/2022 09:33:12 am >> DELETE FROM ps_specific_price WHERE id_product = '15089' 27/05/2022 09:34:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400297072' AND id_product != '18318' AND ean13 != '' 27/05/2022 09:34:56 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400297072', date_upd = NOW() WHERE id_product = '18318' 27/05/2022 09:34:56 am >> UPDATE ps_product_lang SET name = 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001', description = '' WHERE id_product = '18318' 27/05/2022 09:34:56 am >> UPDATE ps_product SET wholesale_price = '0.85', on_sale = '0', price = '1.9672131147540983' WHERE id_product = '18318' 27/05/2022 09:34:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.85', price = '1.9672131147540983', id_tax_rules_group = '1', id_category_default = '95', 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 = '18318' 27/05/2022 09:34:56 am >> DELETE FROM ps_specific_price WHERE id_product = '18318' 27/05/2022 09:35:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400300086' AND id_product != '15403' AND ean13 != '' 27/05/2022 09:35:58 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400300086', date_upd = NOW() WHERE id_product = '15403' 27/05/2022 09:35:58 am >> UPDATE ps_product_lang SET name = 'CROCE IN RESINA CM 9 - 3806/G052', description = '' WHERE id_product = '15403' 27/05/2022 09:35:58 am >> UPDATE ps_product SET wholesale_price = '1.33', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '15403' 27/05/2022 09:35:58 am >> UPDATE ps_product_shop SET wholesale_price = '1.33', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '95', 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 = '15403' 27/05/2022 09:35:58 am >> DELETE FROM ps_specific_price WHERE id_product = '15403' 27/05/2022 09:36:17 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' , 'A2156' , '2022-05-25' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '195.35' , '160.12' , NOW() , NOW() ) 27/05/2022 09:36:17 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 = '58465' 27/05/2022 09:36:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58465' 27/05/2022 09:36:17 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 ( '58465' , '18095' , 'CROCE IN ULIVO - 2882' , '1' , '1' , '1' , '10.08' , '8.2622950819672' , '22' , '0' , '12.2976' ) 27/05/2022 09:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18095' AND id_supplier = '28' 27/05/2022 09:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18095' , '28' , '1' ) 27/05/2022 09:36:17 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 ( '58465' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '6' , '6' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '26.3520' ) 27/05/2022 09:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19318' AND id_supplier = '28' 27/05/2022 09:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19318' , '28' , '1' ) 27/05/2022 09:36:17 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 ( '58465' , '19601' , 'ANGELO ALI TORTORA - 4231' , '6' , '6' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '26.3520' ) 27/05/2022 09:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19601' AND id_supplier = '28' 27/05/2022 09:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19601' , '28' , '1' ) 27/05/2022 09:36:17 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 ( '58465' , '18199' , 'QUADRETTO EFFETTO PIETRA SANTA RITA - 2952' , '3' , '3' , '1' , '1.46' , '1.1967213114754' , '22' , '0' , '5.3436' ) 27/05/2022 09:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18199' AND id_supplier = '28' 27/05/2022 09:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18199' , '28' , '1' ) 27/05/2022 09:36:17 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 ( '58465' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '10' , '10' , '1' , '1.46' , '1.1967213114754' , '22' , '0' , '17.8120' ) 27/05/2022 09:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '28' 27/05/2022 09:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '28' , '1' ) 27/05/2022 09:36:18 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 ( '58465' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '5' , '5' , '1' , '2.38' , '1.9508196721311' , '22' , '0' , '14.5180' ) 27/05/2022 09:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '15089' AND id_supplier = '28' 27/05/2022 09:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15089' , '28' , '1' ) 27/05/2022 09:36:18 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 ( '58465' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '50' , '50' , '1' , '0.96' , '0.78688524590164' , '22' , '0' , '58.5600' ) 27/05/2022 09:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18318' AND id_supplier = '28' 27/05/2022 09:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18318' , '28' , '1' ) 27/05/2022 09:36:18 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 ( '58465' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '12' , '12' , '1' , '1.33' , '1.0901639344262' , '22' , '0' , '19.4712' ) 27/05/2022 09:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '28' 27/05/2022 09:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '28' , '1' ) 27/05/2022 09:37:38 am >> SELECT document_num FROM ps_document WHERE document_num = '824' AND id_document != '53348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-21') 27/05/2022 09:37:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '824', document_date = '2022-03-21', 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 = '45.30', price_tax_excluded = '38.41', date_upd = NOW() WHERE id_document = '53348' 27/05/2022 09:37:38 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 = '53348' 27/05/2022 09:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '53348' 27/05/2022 09:37:38 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 ( '53348' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '9.00' ) 27/05/2022 09:37:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/05/2022 09:37:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/05/2022 09:37:39 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 ( '53348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.8' , '9.672131147541' , '22' , '0' , '11.80' ) 27/05/2022 09:37:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/05/2022 09:37:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/05/2022 09:37:39 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 ( '53348' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 27/05/2022 09:37:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 27/05/2022 09:37:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 27/05/2022 09:37:39 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 ( '53348' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/05/2022 09:37:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '15089' AND id_supplier = '' 27/05/2022 09:37:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15089' , '' , '1' ) 27/05/2022 09:58:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 09:58:32 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' , '1669' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 27/05/2022 09:58:32 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 = '58466' 27/05/2022 09:58:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58466' 27/05/2022 09:58:32 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 ( '58466' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 27/05/2022 09:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '13830' AND id_supplier = '' 27/05/2022 09:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13830' , '' , '1' ) 27/05/2022 10:06:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 10:06:34 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' , '1670' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 27/05/2022 10:06:34 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 = '58467' 27/05/2022 10:06:34 am >> DELETE FROM ps_document_detail WHERE id_document = '58467' 27/05/2022 10:06:34 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 ( '58467' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 27/05/2022 10:06:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19087' AND id_supplier = '' 27/05/2022 10:06:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19087' , '' , '1' ) 27/05/2022 10:16:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 10:16:49 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' , '1671' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 27/05/2022 10:16:49 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 = '58468' 27/05/2022 10:16:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58468' 27/05/2022 10:16:49 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 ( '58468' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '0' , '10.00' ) 27/05/2022 10:16:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '' 27/05/2022 10:16:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '' , '1' ) 27/05/2022 10:37:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 10:37:10 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' , '1672' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.02' , '77.18' , NOW() , NOW() ) 27/05/2022 10:37:10 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 = '58469' 27/05/2022 10:37:10 am >> DELETE FROM ps_document_detail WHERE id_document = '58469' 27/05/2022 10:37:10 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 ( '58469' , '17553' , 'GRANDI SANTE AMICHE DI GESU' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 27/05/2022 10:37:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '17553' AND id_supplier = '' 27/05/2022 10:37:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17553' , '' , '1' ) 27/05/2022 10:37:10 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 ( '58469' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '25.5' , '20.901639344262' , '22' , '0' , '25.50' ) 27/05/2022 10:37:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '15801' AND id_supplier = '' 27/05/2022 10:37:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15801' , '' , '1' ) 27/05/2022 10:37:10 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 ( '58469' , '18216' , 'BRACCIALE PERLA - BC534' , '11' , '-11' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '16.50' ) 27/05/2022 10:37:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18216' AND id_supplier = '' 27/05/2022 10:37:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18216' , '' , '1' ) 27/05/2022 10:37:10 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 ( '58469' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 27/05/2022 10:37:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18892' AND id_supplier = '' 27/05/2022 10:37:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18892' , '' , '1' ) 27/05/2022 10:37:11 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 ( '58469' , '581' , 'ANELLO FEDINA IN ARG. 925 - M043/022' , '2' , '-2' , '1' , '12.2' , '10' , '22' , '0' , '24.40' ) 27/05/2022 10:37:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '581' AND id_supplier = '' 27/05/2022 10:37:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '581' , '' , '1' ) 27/05/2022 10:37:11 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 ( '58469' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 27/05/2022 10:37:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '17554' AND id_supplier = '' 27/05/2022 10:37:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17554' , '' , '1' ) 27/05/2022 10:52:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 10:52:03 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' , '1673' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.50' , '121.72' , NOW() , NOW() ) 27/05/2022 10:52:03 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 = '58470' 27/05/2022 10:52:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58470' 27/05/2022 10:52:03 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 ( '58470' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '65' , '-65' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '32.50' ) 27/05/2022 10:52:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 27/05/2022 10:52:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 27/05/2022 10:52:03 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 ( '58470' , '15774' , 'INCENSO NARJAN - 500G' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 27/05/2022 10:52:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 27/05/2022 10:52:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 27/05/2022 10:52:03 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 ( '58470' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '5' , '-5' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '6.00' ) 27/05/2022 10:52:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 27/05/2022 10:52:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 27/05/2022 10:52:03 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 ( '58470' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '-10' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '60.00' ) 27/05/2022 10:52:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '' 27/05/2022 10:52:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '' , '1' ) 27/05/2022 11:00:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1048' AND id_document != '54649' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-08') 27/05/2022 11:00:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1048', document_date = '2022-04-08', 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 = '597.68', price_tax_excluded = '519.94', date_upd = NOW() WHERE id_document = '54649' 27/05/2022 11:00:16 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 = '54649' 27/05/2022 11:00:16 am >> DELETE FROM ps_document_detail WHERE id_document = '54649' 27/05/2022 11:00: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 ( '54649' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '17.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '12237' , 'TURIBOLO H28 CM' , '1' , '-1' , '1' , '165.0000' , '135.24590163934' , '22' , '0' , '165.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12237' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12237' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12238' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12238' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '19115' , 'NOTTE DI PASSIONE - 8051' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19115' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19115' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '15272' , 'BEATITUDINI ALLA LUCE DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15272' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15272' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '17520' , 'LUMINO SMERALDO' , '100' , '-100' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '40.00' ) 27/05/2022 11:00:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 27/05/2022 11:00:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 27/05/2022 11:00: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 ( '54649' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '110.00' ) 27/05/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 27/05/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 27/05/2022 11:00:17 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 ( '54649' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 27/05/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 27/05/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 27/05/2022 11:00:17 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 ( '54649' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30.4' , '30.4' , '0' , '0' , '30.40' ) 27/05/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/05/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/05/2022 11:00:17 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 ( '54649' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '26.3300' , '26.33' , '0' , '0' , '26.33' ) 27/05/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/05/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/05/2022 11:00:17 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 ( '54649' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '5' , '-5' , '4' , '18.5000' , '18.5' , '0' , '5' , '87.90' ) 27/05/2022 11:00:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 27/05/2022 11:00:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 27/05/2022 11:00:36 am >> DELETE FROM ps_document WHERE id_document = '54524' 27/05/2022 11:00:36 am >> DELETE FROM ps_document_detail WHERE id_document = '54524' 27/05/2022 11:29:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1674' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 11:29: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' , '1674' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 27/05/2022 11:29: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 = '58471' 27/05/2022 11:29:15 am >> DELETE FROM ps_document_detail WHERE id_document = '58471' 27/05/2022 11:29: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 ( '58471' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/05/2022 11:29:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16190' AND id_supplier = '' 27/05/2022 11:29:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16190' , '' , '1' ) 27/05/2022 11:29: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 ( '58471' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/05/2022 11:29:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 27/05/2022 11:29:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 27/05/2022 11:50:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 11:50:01 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' , '1675' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '249.80' , '209.80' , NOW() , NOW() ) 27/05/2022 11:50:01 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 = '58472' 27/05/2022 11:50:01 am >> DELETE FROM ps_document_detail WHERE id_document = '58472' 27/05/2022 11:50:01 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 ( '58472' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '21.00' ) 27/05/2022 11:50:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 27/05/2022 11:50:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 27/05/2022 11:50:01 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 ( '58472' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '200' , '-200' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '100.00' ) 27/05/2022 11:50:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 27/05/2022 11:50:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 27/05/2022 11:50:01 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 ( '58472' , '18338' , 'CROCE BIANCA CALICE - S2253/CZ' , '17' , '-17' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '40.80' ) 27/05/2022 11:50:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18338' AND id_supplier = '' 27/05/2022 11:50:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18338' , '' , '1' ) 27/05/2022 11:50:01 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 ( '58472' , '18357' , 'MIE PREGHIERINE N.E.' , '20' , '-20' , '4' , '1.4' , '1.4' , '0' , '0' , '28.00' ) 27/05/2022 11:50:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 27/05/2022 11:50:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 27/05/2022 11:50:01 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 ( '58472' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 27/05/2022 11:50:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 27/05/2022 11:50:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 27/05/2022 12:04:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 27/05/2022 12:04:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'ACCONTO € 4,00', 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 = '22.30', price_tax_excluded = '20.80', date_upd = NOW() WHERE id_document = '57793' 27/05/2022 12:04:55 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 = '57793' 27/05/2022 12:04:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 27/05/2022 12:04:55 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 ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 27/05/2022 12:04:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/05/2022 12:04:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/05/2022 12:04:55 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 ( '57793' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 27/05/2022 12:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 27/05/2022 12:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 27/05/2022 12:04:56 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 ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '4.50' ) 27/05/2022 12:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 27/05/2022 12:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 27/05/2022 12:13:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 12:13:01 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 ( '11' , '1676' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.20' , '66.84' , NOW() , NOW() ) 27/05/2022 12:13:01 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 = '58473' 27/05/2022 12:13:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '58473' 27/05/2022 12:13:01 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 ( '58473' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 27/05/2022 12:13:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14163' AND id_supplier = '' 27/05/2022 12:13:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14163' , '' , '1' ) 27/05/2022 12:13:01 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 ( '58473' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/05/2022 12:13:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 27/05/2022 12:13:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 27/05/2022 12:13:01 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 ( '58473' , '14687' , 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 27/05/2022 12:13:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14687' AND id_supplier = '' 27/05/2022 12:13:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14687' , '' , '1' ) 27/05/2022 12:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 12:21:07 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 ( '11' , '1677' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.00' , '126.23' , NOW() , NOW() ) 27/05/2022 12:21:07 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 = '58474' 27/05/2022 12:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '58474' 27/05/2022 12:21:07 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 ( '58474' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' , '72.00' , '59.016393442623' , '22' , '0' , '72.00' ) 27/05/2022 12:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '' 27/05/2022 12:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '' , '1' ) 27/05/2022 12:21:07 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 ( '58474' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 27/05/2022 12:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 27/05/2022 12:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 27/05/2022 12:21:07 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 ( '58474' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 27/05/2022 12:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1631' AND id_supplier = '' 27/05/2022 12:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1631' , '' , '1' ) 27/05/2022 12:39:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 12:39:57 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 ( '11' , '1678' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '617.50' , '506.15' , NOW() , NOW() ) 27/05/2022 12:39:57 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 = '58475' 27/05/2022 12:39:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '58475' 27/05/2022 12:39:57 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 ( '58475' , '15097' , 'CORONA MATRIMONIO - ORO' , '25' , '-25' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '187.50' ) 27/05/2022 12:39:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 27/05/2022 12:39:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 27/05/2022 12:39:58 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 ( '58475' , '19558' , 'PORTACERO - PC23OR' , '1' , '-1' , '1' , '430' , '352.45901639344' , '22' , '0' , '430.00' ) 27/05/2022 12:39:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19558' AND id_supplier = '' 27/05/2022 12:39:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19558' , '' , '1' ) 27/05/2022 12:42:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 12:42:16 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 ( '11' , '1679' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '33.35' , NOW() , NOW() ) 27/05/2022 12:42:16 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 = '58476' 27/05/2022 12:42:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '58476' 27/05/2022 12:42:16 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 ( '58476' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '2' , '-2' , '4' , '16.00' , '16' , '0' , '5' , '30.40' ) 27/05/2022 12:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 27/05/2022 12:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 27/05/2022 12:42:16 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 ( '58476' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 27/05/2022 12:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 27/05/2022 12:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 27/05/2022 12:52:59 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '5190' 27/05/2022 12:52:59 pm >> UPDATE ps_stock_available SET quantity = quantity + '2' WHERE id_product = '5190' 27/05/2022 02:56:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '58453' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-26') 27/05/2022 02:56:32 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '90', document_date = '2022-05-26', document_letter = '', id_customer = '979', id_supplier = '', id_address = '4671729', address1 = 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '58453' 27/05/2022 02:56:32 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 = '58453' 27/05/2022 02:56:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '58453' 27/05/2022 02:56:32 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 ( '58453' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 27/05/2022 02:56:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 27/05/2022 02:56:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 27/05/2022 03:50:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 03:50:54 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 ( '11' , '1680' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '24.18' , NOW() , NOW() ) 27/05/2022 03:50:54 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 = '58477' 27/05/2022 03:50:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58477' 27/05/2022 03:50:55 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 ( '58477' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29.5' , '24.180327868852' , '22' , '0' , '29.50' ) 27/05/2022 03:50:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/05/2022 03:50:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/05/2022 04:14:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 04:14:08 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 ( '11' , '1681' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 27/05/2022 04:14:08 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 = '58478' 27/05/2022 04:14:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '58478' 27/05/2022 04:14:08 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 ( '58478' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/05/2022 04:14:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 27/05/2022 04:14:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 27/05/2022 04:16:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1565' AND id_document != '57822' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 27/05/2022 04:16:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1565', document_date = '2022-05-18', 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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '57822' 27/05/2022 04:16:26 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 = '57822' 27/05/2022 04:16:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '57822' 27/05/2022 04:16:26 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 ( '57822' , '14354' , 'CAMICE BENEDETTINO LINO' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 27/05/2022 04:16:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 27/05/2022 04:16:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 27/05/2022 04:19:48 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '997/2022', document_date = '2022-05-25', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '15.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '145.74', price_tax_excluded = '119.46', date_upd = NOW() WHERE id_document = '58456' 27/05/2022 04:19:48 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 = '58456' 27/05/2022 04:19:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '58456' 27/05/2022 04:19:48 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 ( '58456' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '150' , '150' , '1' , '0.2500' , '0.20491803278689' , '22' , '5' , '43.46' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '19234' , 'ANELLO A FASCIA ROSATO - RA085 -CU' , '2' , '2' , '1' , '9.4000' , '7.7049180327869' , '22' , '5' , '21.79' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19234' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19234' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '17602' , 'BRACCIALE SIMIL PELLE BLU - AC120P' , '1' , '1' , '1' , '5.9700' , '4.8934426229508' , '22' , '5' , '6.92' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17602' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17602' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '17603' , 'BRACCIALE SIMIL PELLE NERO - AC120D' , '1' , '1' , '1' , '5.9700' , '4.8934426229508' , '22' , '5' , '6.92' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17603' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17603' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '1' , '1' , '4.4100' , '3.6147540983607' , '22' , '5' , '5.11' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '1' , '1' , '6.8300' , '5.5983606557377' , '22' , '5' , '7.92' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '' , '1' ) 27/05/2022 04:19:48 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 ( '58456' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '50' , '50' , '1' , '0.5300' , '0.4344262295082' , '22' , '5' , '30.71' ) 27/05/2022 04:19:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19598' AND id_supplier = '' 27/05/2022 04:19:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19598' , '' , '1' ) 27/05/2022 04:19: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 ( '58456' , '17786' , 'CROCE METALLO CM 10 - FX125-SA' , '1' , '1' , '1' , '3.9700' , '3.2540983606557' , '22' , '5' , '4.60' ) 27/05/2022 04:19:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17786' AND id_supplier = '' 27/05/2022 04:19:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17786' , '' , '1' ) 27/05/2022 04:26:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 04:26:07 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 ( '11' , '1682' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.80' , '5.11' , NOW() , NOW() ) 27/05/2022 04:26:07 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 = '58479' 27/05/2022 04:26:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '58479' 27/05/2022 04:26:07 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 ( '58479' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 27/05/2022 04:26:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19600' AND id_supplier = '' 27/05/2022 04:26:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19600' , '' , '1' ) 27/05/2022 04:26:07 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 ( '58479' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/05/2022 04:26:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9070' AND id_supplier = '' 27/05/2022 04:26:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9070' , '' , '1' ) 27/05/2022 04:30:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000347' AND id_product != '2177' AND ean13 != '' 27/05/2022 04:30:53 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000347', date_upd = NOW() WHERE id_product = '2177' 27/05/2022 04:30:53 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - MM ', description = '' WHERE id_product = '2177' 27/05/2022 04:30:53 pm >> UPDATE ps_product SET wholesale_price = '11.65', on_sale = '0', price = '27.049180327868854' WHERE id_product = '2177' 27/05/2022 04:30:53 pm >> UPDATE ps_product_shop SET wholesale_price = '11.65', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '253', 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 = '2177' 27/05/2022 04:30:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '2177' 27/05/2022 04:31:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000349' AND id_product != '2178' AND ean13 != '' 27/05/2022 04:31:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000349', date_upd = NOW() WHERE id_product = '2178' 27/05/2022 04:31:40 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC EXTRA - MM ', description = '' WHERE id_product = '2178' 27/05/2022 04:31:40 pm >> UPDATE ps_product SET wholesale_price = '11.65', on_sale = '0', price = '30.327868852459016' WHERE id_product = '2178' 27/05/2022 04:31:40 pm >> UPDATE ps_product_shop SET wholesale_price = '11.65', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '253', 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 = '2178' 27/05/2022 04:31:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '2178' 27/05/2022 04:34:35 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '53/2017', document_date = '2017-04-10', document_letter = '2017', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1049.00', price_tax_excluded = '1049.00', date_upd = NOW() WHERE id_document = '1741' 27/05/2022 04:34:35 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 = '1741' 27/05/2022 04:34:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '1741' 27/05/2022 04:34:36 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 ( '1741' , '2166' , 'CLERGY CELESTE MISTO ML - 5 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2166' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2166' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2165' , 'CLERGY CELESTE MISTO ML - 4 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2165' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2165' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2169' , 'CLERGY CELESTE MISTO ML - XL - OGGETTI' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2169' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2169' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2168' , 'CLERGY CELESTE MISTO ML - M - OGGETTI' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2300' , 'CLERGY GRIGIO MISTO ML - 6 XL - OGGETTI' , '1' , '1' , '0' , '14.3500' , '14.35' , '0' , '0' , '14.35' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2300' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2300' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2339' , 'CLERGY GRIGIO MISTO ML - 5 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2339' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2339' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2299' , 'CLERGY GRIGIO MISTO ML - 4XL' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2299' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2299' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2303' , 'CLERGY GRIGIO MISTO ML - XL' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2303' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2303' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2301' , 'CLERGY GRIGIO MISTO ML - M - OGGETTI' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2301' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2301' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2251' , 'CLERGY GRIGIO CHIARO MISTO ML - 5 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2251' AND id_supplier = '' 27/05/2022 04:34:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2251' , '' , '1' ) 27/05/2022 04:34:36 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 ( '1741' , '2250' , 'CLERGY GRIGIO CHIARO MISTO ML - 4XL' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2250' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2250' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2254' , 'CLERGY GRIGIO CHIARO MISTO ML - M - OGGETTI' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2254' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2254' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2350' , 'CLERGY NERO MISTO ML - 5 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2350' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2350' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2351' , 'CLERGY NERO MISTO ML - 4 XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2351' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2351' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2344' , 'CLERGY NERO MISTO ML - 3XL - OGGETTI' , '3' , '3' , '0' , '14.3500' , '14.35' , '0' , '0' , '43.05' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2344' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2344' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2355' , 'CLERGY NERO MISTO ML - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2355' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2355' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2354' , 'CLERGY NERO MISTO ML - XL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2354' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2354' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2352' , 'CLERGY NERO MISTO ML - L ' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2352' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2352' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2353' , 'CLERGY NERO MISTO ML - M' , '5' , '5' , '0' , '12.1500' , '12.15' , '0' , '0' , '60.75' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2177' , 'CLERGY BASIC - MM ' , '14' , '14' , '0' , '11.65' , '11.65' , '' , '0' , '163.1000' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:34:37 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 ( '1741' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '14' , '14' , '0' , '13.75' , '13.75' , '' , '0' , '192.5000' ) 27/05/2022 04:34:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:34:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:38:52 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '130/2017', document_date = '2017-06-28', document_letter = '2017', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '1', price_tax_included = '322.75', price_tax_excluded = '322.75', date_upd = NOW() WHERE id_document = '3128' 27/05/2022 04:38:52 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 = '3128' 27/05/2022 04:38:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '3128' 27/05/2022 04:38:52 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 ( '3128' , '2177' , 'CLERGY BASIC - MM ' , '8' , '8' , '0' , '12.15' , '12.15' , '' , '0' , '97.2000' ) 27/05/2022 04:38:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:38:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:38:52 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 ( '3128' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '2' , '2' , '0' , '13.75' , '13.75' , '' , '0' , '27.5000' ) 27/05/2022 04:38:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:38:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:38:53 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 ( '3128' , '2177' , 'CLERGY BASIC - MM ' , '17' , '17' , '0' , '11.65' , '11.65' , '' , '0' , '198.0500' ) 27/05/2022 04:38:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:38:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:40:07 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '141/2017', document_date = '2017-07-04', document_letter = '2017', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '1', price_tax_included = '132.90', price_tax_excluded = '132.90', date_upd = NOW() WHERE id_document = '3183' 27/05/2022 04:40:07 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 = '3183' 27/05/2022 04:40:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '3183' 27/05/2022 04:40:07 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 ( '3183' , '2177' , 'CLERGY BASIC - MM ' , '6' , '6' , '0' , '11.65' , '11.65' , '' , '0' , '69.9000' ) 27/05/2022 04:40:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:40:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:40:07 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 ( '3183' , '2177' , 'CLERGY BASIC - MM ' , '6' , '6' , '0' , '10.5' , '10.5' , '' , '0' , '63.0000' ) 27/05/2022 04:40:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:40:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:45:13 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '46/2018', document_date = '2018-03-21', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '349.50', price_tax_excluded = '349.50', date_upd = NOW() WHERE id_document = '7325' 27/05/2022 04:45:14 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 = '7325' 27/05/2022 04:45:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '7325' 27/05/2022 04:45:14 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 ( '7325' , '2167' , 'CLERGY CELESTE MISTO ML - L - OGGETTI' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2167' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2167' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2168' , 'CLERGY CELESTE MISTO ML - M - OGGETTI' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2254' , 'CLERGY GRIGIO CHIARO MISTO ML - M - OGGETTI' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2254' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2254' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2301' , 'CLERGY GRIGIO MISTO ML - M ' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2301' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2301' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2302' , 'CLERGY GRIGIO MISTO ML - L' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2302' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2302' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2303' , 'CLERGY GRIGIO MISTO ML - XL' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2303' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2303' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2353' , 'CLERGY NERO MISTO ML - M' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2352' , 'CLERGY NERO MISTO ML - L ' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2352' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2352' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2354' , 'CLERGY NERO MISTO ML - XL' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2354' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2354' , '' , '1' ) 27/05/2022 04:45:14 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 ( '7325' , '2350' , 'CLERGY NERO MISTO ML - 5 XL - OGGETTI' , '1' , '1' , '0' , '14.3500' , '14.35' , '0' , '0' , '14.35' ) 27/05/2022 04:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2350' AND id_supplier = '' 27/05/2022 04:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2350' , '' , '1' ) 27/05/2022 04:45:15 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 ( '7325' , '2302' , 'CLERGY GRIGIO MISTO ML - L' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2302' AND id_supplier = '' 27/05/2022 04:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2302' , '' , '1' ) 27/05/2022 04:45:15 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 ( '7325' , '2303' , 'CLERGY GRIGIO MISTO ML - XL' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2303' AND id_supplier = '' 27/05/2022 04:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2303' , '' , '1' ) 27/05/2022 04:45:15 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 ( '7325' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '4' , '4' , '0' , '13.75' , '13.75' , '' , '0' , '55.0000' ) 27/05/2022 04:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:45:15 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 ( '7325' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '1' , '1' , '0' , '14.35' , '14.35' , '' , '0' , '14.3500' ) 27/05/2022 04:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:45:15 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 ( '7325' , '2177' , 'CLERGY BASIC - MM ' , '2' , '2' , '0' , '11.65' , '11.65' , '' , '0' , '23.3000' ) 27/05/2022 04:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:47:57 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '138/2018', document_date = '2018-07-12', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '429.05', price_tax_excluded = '429.05', date_upd = NOW() WHERE id_document = '9910' 27/05/2022 04:47:57 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 = '9910' 27/05/2022 04:47:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '9910' 27/05/2022 04:47:57 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 ( '9910' , '14297' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 27/05/2022 04:47:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14297' AND id_supplier = '' 27/05/2022 04:47:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14297' , '' , '1' ) 27/05/2022 04:47:57 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 ( '9910' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 27/05/2022 04:47:58 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 ( '9910' , '8147' , 'POLO BASIC' , '21' , '21' , '0' , '10.5000' , '10.5' , '0' , '0' , '220.50' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 27/05/2022 04:47:58 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 ( '9910' , '8147' , 'POLO BASIC' , '1' , '1' , '0' , '11.8500' , '11.85' , '0' , '0' , '11.85' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 27/05/2022 04:47:58 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 ( '9910' , '8082' , 'POLO LIMITED ' , '3' , '3' , '0' , '10.5000' , '10.5' , '0' , '0' , '31.50' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 27/05/2022 04:47:58 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 ( '9910' , '2177' , 'CLERGY BASIC - MM ' , '9' , '9' , '0' , '11.65' , '11.65' , '' , '0' , '104.8500' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:47:58 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 ( '9910' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '1' , '1' , '0' , '13.75' , '13.75' , '' , '0' , '13.7500' ) 27/05/2022 04:47:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:47:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:48:53 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '154/2018', document_date = '2018-07-26', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '245.95', price_tax_excluded = '245.95', date_upd = NOW() WHERE id_document = '10450' 27/05/2022 04:48:54 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 = '10450' 27/05/2022 04:48:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '10450' 27/05/2022 04:48:54 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 ( '10450' , '2353' , 'CLERGY NERO MISTO ML - M' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '14384' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14384' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14384' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '14385' , 'CLERGY GRIGIO MISTO ML - S' , '3' , '3' , '0' , '12.6500' , '12.65' , '0' , '0' , '37.95' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14385' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14385' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2246' , 'CLERGY GRIGIO CHIARO MISTO ML - 3XL' , '2' , '2' , '0' , '14.8500' , '14.85' , '0' , '0' , '29.70' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2246' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2246' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2253' , 'CLERGY GRIGIO CHIARO MISTO ML - L - OGGETTI' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2253' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2253' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '14386' , 'CLERGY CELESTE MISTO ML - S' , '3' , '3' , '0' , '12.6500' , '12.65' , '0' , '0' , '37.95' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14386' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14386' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2167' , 'CLERGY CELESTE MISTO ML - L' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2167' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2167' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2168' , 'CLERGY CELESTE MISTO ML - M - OGGETTI' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2170' , 'CLERGY CELESTE MISTO ML - XXL - OGGETTI' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2170' AND id_supplier = '' 27/05/2022 04:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2170' , '' , '1' ) 27/05/2022 04:48:54 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 ( '10450' , '2161' , 'CLERGY CELESTE MISTO ML - 3XL' , '1' , '1' , '0' , '14.8500' , '14.85' , '0' , '0' , '14.85' ) 27/05/2022 04:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2161' AND id_supplier = '' 27/05/2022 04:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2161' , '' , '1' ) 27/05/2022 04:48:55 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 ( '10450' , '2177' , 'CLERGY BASIC - MM ' , '2' , '2' , '0' , '12.15' , '12.15' , '' , '0' , '24.3000' ) 27/05/2022 04:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:51:36 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '68/2019', document_date = '2019-04-26', document_letter = '2019', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '852.45', price_tax_excluded = '852.45', date_upd = NOW() WHERE id_document = '19371' 27/05/2022 04:51:36 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 = '19371' 27/05/2022 04:51:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '19371' 27/05/2022 04:51:36 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 ( '19371' , '15685' , 'CLERGY CELESTE 80% - MM - L' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 27/05/2022 04:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15685' AND id_supplier = '' 27/05/2022 04:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15685' , '' , '1' ) 27/05/2022 04:51:36 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 ( '19371' , '15689' , 'CLERGY CELESTE 80% - MM - M' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 27/05/2022 04:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15689' AND id_supplier = '' 27/05/2022 04:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15689' , '' , '1' ) 27/05/2022 04:51:36 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 ( '19371' , '15687' , 'CLERGY CELESTE 80% - MM - XL' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 27/05/2022 04:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15687' AND id_supplier = '' 27/05/2022 04:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15687' , '' , '1' ) 27/05/2022 04:51:36 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 ( '19371' , '15688' , 'CLERGY CELESTE 80% - MM - XXL' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 27/05/2022 04:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15688' AND id_supplier = '' 27/05/2022 04:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15688' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2302' , 'CLERGY GRIGIO MISTO ML - L' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2302' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2302' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '14384' , 'CLERGY NERO ML - MISTO - S' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14384' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14384' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2353' , 'CLERGY NERO MISTO ML - M' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2352' , 'CLERGY NERO MISTO ML - L ' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2352' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2352' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2354' , 'CLERGY NERO MISTO ML - XL' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2354' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2354' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2355' , 'CLERGY NERO MISTO ML - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2355' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2355' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '8082' , 'POLO LIMITED ' , '30' , '30' , '0' , '11.2500' , '11.25' , '0' , '0' , '337.50' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '8079' , 'POLO LIMITED EXTRA' , '4' , '4' , '0' , '12.6000' , '12.6' , '0' , '0' , '50.40' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 27/05/2022 04:51:37 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 ( '19371' , '2177' , 'CLERGY BASIC - MM ' , '11' , '11' , '0' , '11.65' , '11.65' , '' , '0' , '128.1500' ) 27/05/2022 04:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:51:38 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 ( '19371' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '3' , '3' , '0' , '13.75' , '13.75' , '' , '0' , '41.2500' ) 27/05/2022 04:51:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:51:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:51:38 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 ( '19371' , '2177' , 'CLERGY BASIC - MM ' , '1' , '1' , '0' , '12.15' , '12.15' , '' , '0' , '12.1500' ) 27/05/2022 04:51:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:51:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:52:45 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '100/2020', document_date = '2020-06-19', document_letter = '2020', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1024.20', price_tax_excluded = '1024.20', date_upd = NOW() WHERE id_document = '24310' 27/05/2022 04:52:45 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 = '24310' 27/05/2022 04:52:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '24310' 27/05/2022 04:52:45 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 ( '24310' , '2168' , 'CLERGY CELESTE MISTO ML - M ' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '2255' , 'CLERGY GRIGIO CHIARO MISTO ML - XL - OGGETTI' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2255' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2255' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '2353' , 'CLERGY NERO MISTO ML - M' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '2303' , 'CLERGY GRIGIO MISTO ML - XL' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2303' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2303' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '14385' , 'CLERGY GRIGIO MISTO ML - S' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14385' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14385' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '8082' , 'POLO LIMITED ' , '57' , '57' , '0' , '11.5000' , '11.5' , '0' , '0' , '655.50' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '8079' , 'POLO LIMITED EXTRA' , '13' , '13' , '0' , '13.1000' , '13.1' , '0' , '0' , '170.30' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 27/05/2022 04:52:45 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 ( '24310' , '2177' , 'CLERGY BASIC - MM ' , '8' , '8' , '0' , '12.15' , '12.15' , '' , '0' , '97.2000' ) 27/05/2022 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:54:47 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '48/2022', document_date = '2022-04-01', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '548.90', price_tax_excluded = '548.90', date_upd = NOW() WHERE id_document = '54650' 27/05/2022 04:54:47 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 = '54650' 27/05/2022 04:54:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '54650' 27/05/2022 04:54:47 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 ( '54650' , '2177' , 'CLERGY BASIC - MM ' , '23' , '23' , '0' , '13.15' , '13.15' , '' , '0' , '302.4500' ) 27/05/2022 04:54:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:54:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:54:47 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 ( '54650' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '9' , '9' , '0' , '15.25' , '15.25' , '' , '0' , '137.2500' ) 27/05/2022 04:54:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:54:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:54:47 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 ( '54650' , '19459' , 'CLERGY MISTO ML - B&P' , '8' , '8' , '0' , '13.6500' , '13.65' , '0' , '0' , '109.20' ) 27/05/2022 04:54:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19459' AND id_supplier = '' 27/05/2022 04:54:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19459' , '' , '1' ) 27/05/2022 04:55:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000347' AND id_product != '2177' AND ean13 != '' 27/05/2022 04:55:31 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000347', date_upd = NOW() WHERE id_product = '2177' 27/05/2022 04:55:31 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - MM - B&P', description = '' WHERE id_product = '2177' 27/05/2022 04:55:31 pm >> UPDATE ps_product SET wholesale_price = '11.65', on_sale = '0', price = '27.0492' WHERE id_product = '2177' 27/05/2022 04:55:31 pm >> UPDATE ps_product_shop SET wholesale_price = '11.65', price = '27.0492', id_tax_rules_group = '1', id_category_default = '253', 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 = '2177' 27/05/2022 04:55:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '2177' 27/05/2022 04:55:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000349' AND id_product != '2178' AND ean13 != '' 27/05/2022 04:55:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000349', date_upd = NOW() WHERE id_product = '2178' 27/05/2022 04:55:49 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC EXTRA - MM - B&P', description = '' WHERE id_product = '2178' 27/05/2022 04:55:49 pm >> UPDATE ps_product SET wholesale_price = '11.65', on_sale = '0', price = '30.3279' WHERE id_product = '2178' 27/05/2022 04:55:49 pm >> UPDATE ps_product_shop SET wholesale_price = '11.65', price = '30.3279', id_tax_rules_group = '1', id_category_default = '253', 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 = '2178' 27/05/2022 04:55:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '2178' 27/05/2022 04:56:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1628' AND id_document != '57895' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-23') 27/05/2022 04:56:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1628', document_date = '2022-05-23', 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 = '33.00', price_tax_excluded = '27.05', date_upd = NOW() WHERE id_document = '57895' 27/05/2022 04:56:42 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 = '57895' 27/05/2022 04:56:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '57895' 27/05/2022 04:56:42 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 ( '57895' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 27/05/2022 04:56:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:56:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:57:01 pm >> DELETE FROM ps_product WHERE id_product = '19457' 27/05/2022 04:57:01 pm >> DELETE FROM ps_product_shop WHERE id_product = '19457' 27/05/2022 04:57:01 pm >> DELETE FROM ps_product_lang WHERE id_product = '19457' 27/05/2022 04:57:01 pm >> DELETE FROM ps_stock_available WHERE id_product = '19457' 27/05/2022 04:58:05 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '48/2022', document_date = '2022-04-01', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '548.90', price_tax_excluded = '548.90', date_upd = NOW() WHERE id_document = '54650' 27/05/2022 04:58:05 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 = '54650' 27/05/2022 04:58:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '54650' 27/05/2022 04:58:05 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 ( '54650' , '2177' , 'CLERGY BASIC - MM ' , '23' , '23' , '0' , '13.1500' , '13.15' , '0' , '0' , '302.45' ) 27/05/2022 04:58:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:58:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:58:05 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 ( '54650' , '2178' , 'CLERGY BASIC EXTRA - MM ' , '9' , '9' , '0' , '15.2500' , '15.25' , '0' , '0' , '137.25' ) 27/05/2022 04:58:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '' 27/05/2022 04:58:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '' , '1' ) 27/05/2022 04:58:05 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 ( '54650' , '2177' , 'CLERGY BASIC - MM - B&P' , '8' , '8' , '0' , '13.65' , '13.65' , '' , '0' , '109.2000' ) 27/05/2022 04:58:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 27/05/2022 04:58:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 27/05/2022 04:58:30 pm >> DELETE FROM ps_product WHERE id_product = '19459' 27/05/2022 04:58:30 pm >> DELETE FROM ps_product_shop WHERE id_product = '19459' 27/05/2022 04:58:30 pm >> DELETE FROM ps_product_lang WHERE id_product = '19459' 27/05/2022 04:58:30 pm >> DELETE FROM ps_stock_available WHERE id_product = '19459' 27/05/2022 06:04:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 06:04:28 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 ( '11' , '1683' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 27/05/2022 06:04:28 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 = '58480' 27/05/2022 06:04:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '58480' 27/05/2022 06:04:28 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 ( '58480' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 27/05/2022 06:04:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/05/2022 06:04:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/05/2022 06:04:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 06:04:42 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 ( '11' , '1684' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 27/05/2022 06:04:42 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 = '58481' 27/05/2022 06:04:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '58481' 27/05/2022 06:04:42 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 ( '58481' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/05/2022 06:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/05/2022 06:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/05/2022 06:20:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 06:20:14 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 ( '11' , '1685' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '51.25' , NOW() , NOW() ) 27/05/2022 06:20:14 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 = '58482' 27/05/2022 06:20:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58482' 27/05/2022 06:20:14 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 ( '58482' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '29.50' , '24.180327868852' , '22' , '0' , '29.50' ) 27/05/2022 06:20:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 27/05/2022 06:20:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 27/05/2022 06:20:14 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 ( '58482' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.2' , '9.1803278688525' , '22' , '0' , '11.20' ) 27/05/2022 06:20:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/05/2022 06:20:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/05/2022 06:20:14 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 ( '58482' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.5' , '11.5' , '0' , '0' , '11.50' ) 27/05/2022 06:20:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/05/2022 06:20:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/05/2022 06:20:14 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 ( '58482' , '13733' , 'DECINA - 356/14' , '3' , '-3' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '5.10' ) 27/05/2022 06:20:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13733' AND id_supplier = '' 27/05/2022 06:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13733' , '' , '1' ) 27/05/2022 06:20:15 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 ( '58482' , '13362' , 'CORONA VETRO MM 6' , '1' , '-1' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '2.70' ) 27/05/2022 06:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13362' AND id_supplier = '' 27/05/2022 06:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13362' , '' , '1' ) 27/05/2022 06:28:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 06:28:14 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 ( '11' , '1686' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.26' , '49.57' , NOW() , NOW() ) 27/05/2022 06:28:14 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 = '58483' 27/05/2022 06:28:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58483' 27/05/2022 06:28:14 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 ( '58483' , '1134' , 'BIBBIA DI GERUSALEMME - PLASTICA' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 27/05/2022 06:28:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1134' AND id_supplier = '' 27/05/2022 06:28:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1134' , '' , '1' ) 27/05/2022 06:28:14 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 ( '58483' , '19485' , 'PERCHE TI AMO, MARIA - T. DI LISIEUX' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 27/05/2022 06:28:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19485' AND id_supplier = '' 27/05/2022 06:28:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19485' , '' , '1' ) 27/05/2022 06:28:14 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 ( '58483' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 27/05/2022 06:28:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '' 27/05/2022 06:28:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '' , '1' ) 27/05/2022 06:28:14 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 ( '58483' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/05/2022 06:28:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 27/05/2022 06:28:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 27/05/2022 06:28:14 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 ( '58483' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 27/05/2022 06:28:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/05/2022 06:28:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/05/2022 06:40:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 27/05/2022 06:40:15 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 ( '11' , '1687' , '2022-05-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '3.52' , NOW() , NOW() ) 27/05/2022 06:40:15 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 = '58484' 27/05/2022 06:40:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58484' 27/05/2022 06:40:15 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 ( '58484' , '7914' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '12' , '-12' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.60' ) 27/05/2022 06:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7914' AND id_supplier = '' 27/05/2022 06:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7914' , '' , '1' ) 27/05/2022 06:40:15 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 ( '58484' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 27/05/2022 06:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 27/05/2022 06:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' )