15/12/2022 08:28:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3781' AND id_document != '76138' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 15/12/2022 08:28:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3781', document_date = '2022-12-07', 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 = '30.00', price_tax_excluded = '25.09', date_upd = NOW() WHERE id_document = '76138' 15/12/2022 08:28:58 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 = '76138' 15/12/2022 08:28:58 am >> DELETE FROM ps_document_detail WHERE id_document = '76138' 15/12/2022 08:28:58 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 ( '76138' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/12/2022 08:28:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/12/2022 08:28:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/12/2022 08:28:58 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 ( '76138' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 15/12/2022 08:28:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18883' AND id_supplier = '' 15/12/2022 08:28:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18883' , '' , '1' ) 15/12/2022 08:28:58 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 ( '76138' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2022 08:28:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 15/12/2022 08:28:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 15/12/2022 08:28:58 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 ( '76138' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/12/2022 08:28:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 15/12/2022 08:28:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 15/12/2022 08:30:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3807' AND id_document != '76685' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 15/12/2022 08:30:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3807', document_date = '2022-12-09', 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 = '43.50', price_tax_excluded = '35.66', date_upd = NOW() WHERE id_document = '76685' 15/12/2022 08:30:21 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 = '76685' 15/12/2022 08:30:21 am >> DELETE FROM ps_document_detail WHERE id_document = '76685' 15/12/2022 08:30:21 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 ( '76685' , '14831' , 'CAPANNA IN CARTONCINO - P574' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 15/12/2022 08:30:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '14831' AND id_supplier = '' 15/12/2022 08:30:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14831' , '' , '1' ) 15/12/2022 08:30:21 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 ( '76685' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/12/2022 08:30:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 15/12/2022 08:30:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 15/12/2022 08:30:21 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 ( '76685' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '4' , '-4' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '6.00' ) 15/12/2022 08:30:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 15/12/2022 08:30:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 15/12/2022 08:30:21 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 ( '76685' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '7.50' ) 15/12/2022 08:30:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 08:30:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 08:31:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3794' AND id_document != '76158' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 15/12/2022 08:31:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3794', document_date = '2022-12-07', 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 = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '76158' 15/12/2022 08:31:28 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 = '76158' 15/12/2022 08:31:28 am >> DELETE FROM ps_document_detail WHERE id_document = '76158' 15/12/2022 08:31:28 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 ( '76158' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '5.60' ) 15/12/2022 08:31:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 15/12/2022 08:31:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 15/12/2022 08:31:28 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 ( '76158' , '6019' , 'LUMINO ROSSO - 10B' , '3' , '-3' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.50' ) 15/12/2022 08:31:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 15/12/2022 08:31:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 15/12/2022 08:31:28 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 ( '76158' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '1' , '-1' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '0.90' ) 15/12/2022 08:31:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 08:31:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 08:31:28 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 ( '76158' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 15/12/2022 08:31:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 08:31:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 08:33:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3790' AND id_document != '76150' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 15/12/2022 08:33:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3790', document_date = '2022-12-07', 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 = '21.90', price_tax_excluded = '17.95', date_upd = NOW() WHERE id_document = '76150' 15/12/2022 08:33:14 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 = '76150' 15/12/2022 08:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '76150' 15/12/2022 08:33:14 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 ( '76150' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '14' , '-14' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '14.00' ) 15/12/2022 08:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 08:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 08:33:14 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 ( '76150' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1' , '0.81967213114754' , '22' , '0' , '6.00' ) 15/12/2022 08:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 15/12/2022 08:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 15/12/2022 08:33:14 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 ( '76150' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '0.95' , '0.77868852459016' , '22' , '0' , '1.90' ) 15/12/2022 08:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 15/12/2022 08:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 15/12/2022 08:35:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3528' AND id_document != '74247' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 15/12/2022 08:35:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3528', document_date = '2022-11-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 = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '74247' 15/12/2022 08:35:08 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 = '74247' 15/12/2022 08:35:08 am >> DELETE FROM ps_document_detail WHERE id_document = '74247' 15/12/2022 08:35:08 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 ( '74247' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '6' , '-6' , '1' , '3' , '2.4590163934426' , '22' , '0' , '18.00' ) 15/12/2022 08:35:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 15/12/2022 08:35:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 15/12/2022 08:35:08 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 ( '74247' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '8' , '-8' , '1' , '1' , '0.81967213114754' , '22' , '0' , '8.00' ) 15/12/2022 08:35:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 15/12/2022 08:35:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 15/12/2022 08:35:08 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 ( '74247' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 15/12/2022 08:35:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 15/12/2022 08:35:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 15/12/2022 08:35:08 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 ( '74247' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 15/12/2022 08:35:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '20171' AND id_supplier = '' 15/12/2022 08:35:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20171' , '' , '1' ) 15/12/2022 08:35:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3508' AND id_document != '73194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 15/12/2022 08:35:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3508', document_date = '2022-11-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 = '44.25', price_tax_excluded = '38.84', date_upd = NOW() WHERE id_document = '73194' 15/12/2022 08:35:26 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 = '73194' 15/12/2022 08:35:26 am >> DELETE FROM ps_document_detail WHERE id_document = '73194' 15/12/2022 08:35:26 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 ( '73194' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 15/12/2022 08:35:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '' 15/12/2022 08:35:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '' , '1' ) 15/12/2022 08:35:26 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 ( '73194' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/12/2022 08:35:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 15/12/2022 08:35:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 15/12/2022 08:35:26 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 ( '73194' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '6' , '-6' , '1' , '3' , '2.4590163934426' , '22' , '0' , '18.00' ) 15/12/2022 08:35:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 15/12/2022 08:35:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 15/12/2022 08:35:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3498' AND id_document != '73179' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 15/12/2022 08:35:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3498', document_date = '2022-11-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '73179' 15/12/2022 08:35:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73179' 15/12/2022 08:35:42 am >> DELETE FROM ps_document_detail WHERE id_document = '73179' 15/12/2022 08:35:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73179' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '6' , '-6' , '1' , '3' , '2.4590163934426' , '22' , '0' , '18.00' ) 15/12/2022 08:35:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 15/12/2022 08:35:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 15/12/2022 08:36:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3438' AND id_document != '72056' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-12') 15/12/2022 08:36:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3438', document_date = '2022-11-12', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '72056' 15/12/2022 08:36:44 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 = '72056' 15/12/2022 08:36:44 am >> DELETE FROM ps_document_detail WHERE id_document = '72056' 15/12/2022 08:36:44 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 ( '72056' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '33.00' ) 15/12/2022 08:36:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 15/12/2022 08:36:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 15/12/2022 08:36:44 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 ( '72056' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 15/12/2022 08:36:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11677' AND id_supplier = '' 15/12/2022 08:36:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11677' , '' , '1' ) 15/12/2022 08:36:44 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 ( '72056' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '7' , '-7' , '1' , '3' , '2.4590163934426' , '22' , '0' , '21.00' ) 15/12/2022 08:36:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 15/12/2022 08:36:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 15/12/2022 08:37:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '71508' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 15/12/2022 08:37:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3412', document_date = '2022-11-10', 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 = '173.00', price_tax_excluded = '141.80', date_upd = NOW() WHERE id_document = '71508' 15/12/2022 08:37:25 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 = '71508' 15/12/2022 08:37:25 am >> DELETE FROM ps_document_detail WHERE id_document = '71508' 15/12/2022 08:37:25 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 ( '71508' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2022 08:37:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 15/12/2022 08:37:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 15/12/2022 08:37:25 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 ( '71508' , '17858' , 'LAMPADA IHS - 096DP1K' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 15/12/2022 08:37:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17858' AND id_supplier = '' 15/12/2022 08:37:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17858' , '' , '1' ) 15/12/2022 08:37:25 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 ( '71508' , '1628' , 'CANDELIERE DELLAVVENTO 4 SETT + 1 - OGGETTI' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 15/12/2022 08:37:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '1628' AND id_supplier = '' 15/12/2022 08:37:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1628' , '' , '1' ) 15/12/2022 08:37:25 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 ( '71508' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '40' , '-40' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '8.00' ) 15/12/2022 08:37:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 15/12/2022 08:37:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 15/12/2022 08:38:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3295' AND id_document != '70309' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-03') 15/12/2022 08:38:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3295', document_date = '2022-11-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.70', price_tax_excluded = '12.87', date_upd = NOW() WHERE id_document = '70309' 15/12/2022 08:38:06 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 = '70309' 15/12/2022 08:38:06 am >> DELETE FROM ps_document_detail WHERE id_document = '70309' 15/12/2022 08:38:06 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 ( '70309' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.7' , '4.672131147541' , '22' , '0' , '5.70' ) 15/12/2022 08:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 08:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 08:38:07 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 ( '70309' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 15/12/2022 08:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 08:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 10:23:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 10:23:22 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' , '3874' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 15/12/2022 10:23:22 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 = '77280' 15/12/2022 10:23:22 am >> DELETE FROM ps_document_detail WHERE id_document = '77280' 15/12/2022 10:23:22 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 ( '77280' , '6721' , 'MIRACOLI EUCARISTICI - MELONI' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '0' , '39.00' ) 15/12/2022 10:23:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '6721' AND id_supplier = '' 15/12/2022 10:23:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6721' , '' , '1' ) 15/12/2022 10:23:46 am >> DELETE FROM ps_document WHERE id_document = '77280' 15/12/2022 10:23:46 am >> DELETE FROM ps_document_detail WHERE id_document = '77280' 15/12/2022 10:23:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 10:23:59 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' , '3874' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 15/12/2022 10:23:59 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 = '77281' 15/12/2022 10:23:59 am >> DELETE FROM ps_document_detail WHERE id_document = '77281' 15/12/2022 10:23:59 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 ( '77281' , '6721' , 'MIRACOLI EUCARISTICI - MELONI' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '0' , '39.00' ) 15/12/2022 10:23:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '6721' AND id_supplier = '' 15/12/2022 10:23:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6721' , '' , '1' ) 15/12/2022 10:52:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3819' AND id_document != '76698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 15/12/2022 10:52:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3819', document_date = '2022-12-10', 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 = '110.00', price_tax_excluded = '95.87', date_upd = NOW() WHERE id_document = '76698' 15/12/2022 10:52:59 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 = '76698' 15/12/2022 10:52:59 am >> DELETE FROM ps_document_detail WHERE id_document = '76698' 15/12/2022 10:52:59 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 ( '76698' , '7202' , 'ARTICOLI RELIGIOSI' , '20' , '-20' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '76.00' ) 15/12/2022 10:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 10:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 10:52:59 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 ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 15/12/2022 10:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/12/2022 10:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/12/2022 10:52:59 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 ( '76698' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.45' , '4.45' , '0' , '0' , '4.45' ) 15/12/2022 10:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/12/2022 10:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/12/2022 10:52:59 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 ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '3.00' ) 15/12/2022 10:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/12/2022 10:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/12/2022 10:52:59 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 ( '76698' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 15/12/2022 10:52:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 15/12/2022 10:52:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 15/12/2022 10:54:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3175' AND id_document != '68599' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 15/12/2022 10:54:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3175', document_date = '2022-10-25', 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 = '44.00', price_tax_excluded = '44.00', date_upd = NOW() WHERE id_document = '68599' 15/12/2022 10:54:14 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 = '68599' 15/12/2022 10:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '68599' 15/12/2022 10:54:14 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 ( '68599' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.40' , '15.4' , '0' , '0' , '15.40' ) 15/12/2022 10:54:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/12/2022 10:54:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/12/2022 10:54:14 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 ( '68599' , '15122' , 'PREGHIERE PER OGNI GIORNO DELLANNO - 8738' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 15/12/2022 10:54:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '15122' AND id_supplier = '' 15/12/2022 10:54:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15122' , '' , '1' ) 15/12/2022 10:54:14 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 ( '68599' , '19745' , 'BUON COMPLEANNO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 15/12/2022 10:54:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19745' AND id_supplier = '' 15/12/2022 10:54:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19745' , '' , '1' ) 15/12/2022 10:54:14 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 ( '68599' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '100' , '0.00' ) 15/12/2022 10:54:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 15/12/2022 10:54:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 15/12/2022 10:54:14 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 ( '68599' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 15/12/2022 10:54:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 15/12/2022 10:54:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 15/12/2022 10:54:51 am >> DELETE FROM ps_document WHERE id_document = '61817' 15/12/2022 10:54:51 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 15/12/2022 10:56:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3800' AND id_document != '76165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 15/12/2022 10:56:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3800', document_date = '2022-12-09', 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 = '7.00', price_tax_excluded = '6.73', date_upd = NOW() WHERE id_document = '76165' 15/12/2022 10:56:18 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 = '76165' 15/12/2022 10:56:18 am >> DELETE FROM ps_document_detail WHERE id_document = '76165' 15/12/2022 10:56: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 ( '76165' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/12/2022 10:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 15/12/2022 10:56:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 15/12/2022 10:56: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 ( '76165' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/12/2022 10:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/12/2022 10:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/12/2022 11:00:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 11:00:43 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' , '3875' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 15/12/2022 11:00:43 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 = '77282' 15/12/2022 11:00:43 am >> DELETE FROM ps_document_detail WHERE id_document = '77282' 15/12/2022 11:00:43 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 ( '77282' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2022 11:00:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 11:00:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 11:11:13 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 ( '33' , '896' , '2022-12-13' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1018.10' , '834.51' , NOW() , NOW() ) 15/12/2022 11:11:13 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 = '77283' 15/12/2022 11:11:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77283' 15/12/2022 11:11:13 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 ( '77283' , '20514' , 'ROSARIO S. BENEDETTO - 175/OV3' , '144' , '144' , '1' , '1.4' , '1.1475409836066' , '22' , '3' , '238.5734' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20514' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20514' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20516' , 'CROCE COMUNIONE - 42/08' , '700' , '700' , '1' , '0.45' , '0.36885245901639' , '22' , '3' , '372.7710' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20516' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20516' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20515' , 'DECINA ULIVO - 04/7-D' , '500' , '500' , '1' , '0.18' , '0.14754098360656' , '22' , '3' , '106.5060' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20515' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20515' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20513' , 'QUADRETTO CANDELA - 22/109-NAT04' , '50' , '50' , '1' , '0.5' , '0.40983606557377' , '22' , '3' , '29.5850' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20513' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20513' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '50' , '50' , '1' , '0.5' , '0.40983606557377' , '22' , '3' , '29.5850' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20158' , 'CASETTA NATIVITA\' - 23/97NAT04' , '100' , '100' , '1' , '0.5' , '0.40983606557377' , '22' , '3' , '59.1700' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20158' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20158' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '12' , '12' , '1' , '1.8' , '1.4754098360656' , '22' , '3' , '25.5614' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20512' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20512' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20517' , 'ROSARIO PERLA - 43/4' , '100' , '100' , '1' , '0.75' , '0.61475409836066' , '22' , '3' , '88.7550' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20517' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20517' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20518' , 'DECINA PERLA - 43/4-D' , '24' , '24' , '1' , '0.38' , '0.31147540983607' , '22' , '3' , '10.7926' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20518' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20518' , '60' , '1' ) 15/12/2022 11:11:13 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 ( '77283' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '24' , '24' , '1' , '2' , '1.6393442622951' , '22' , '3' , '56.8032' ) 15/12/2022 11:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '60' 15/12/2022 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '60' , '1' ) 15/12/2022 11:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 11:18:38 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' , '3876' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 15/12/2022 11:18: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 = '77284' 15/12/2022 11:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '77284' 15/12/2022 11:18: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 ( '77284' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '80' , '-80' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '20.00' ) 15/12/2022 11:18:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 15/12/2022 11:18:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 15/12/2022 11:46:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 11:46:37 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' , '3877' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '66.94' , NOW() , NOW() ) 15/12/2022 11:46:37 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 = '77285' 15/12/2022 11:46:37 am >> DELETE FROM ps_document_detail WHERE id_document = '77285' 15/12/2022 11:46:37 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 ( '77285' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 15/12/2022 11:46:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 15/12/2022 11:46:37 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 ( '77285' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 15/12/2022 11:46:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 15/12/2022 11:46:37 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 ( '77285' , '19754' , 'BRUCIA INCENSI CAMPANA' , '1' , '-1' , '1' , '10.4' , '8.5245901639344' , '22' , '0' , '10.40' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19754' AND id_supplier = '' 15/12/2022 11:46:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19754' , '' , '1' ) 15/12/2022 11:46:37 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 ( '77285' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 15/12/2022 11:46:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 15/12/2022 11:46:37 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 ( '77285' , '20204' , 'SERTUM MARIAE - D. PRIORI' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20204' AND id_supplier = '' 15/12/2022 11:46:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20204' , '' , '1' ) 15/12/2022 11:46:37 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 ( '77285' , '16328' , 'GRUPPO NATIVITA CM 20 - PB14890' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 15/12/2022 11:46:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16328' AND id_supplier = '' 15/12/2022 11:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16328' , '' , '1' ) 15/12/2022 12:14:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 12:14:23 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' , '3878' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.41' , NOW() , NOW() ) 15/12/2022 12:14:23 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 = '77286' 15/12/2022 12:14:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77286' 15/12/2022 12:14:23 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 ( '77286' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 15/12/2022 12:14:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 15/12/2022 12:14:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 15/12/2022 12:38:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 12:38:32 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' , '3879' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.24' , '98.97' , NOW() , NOW() ) 15/12/2022 12:38: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 = '77287' 15/12/2022 12:38:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77287' 15/12/2022 12:38: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 ( '77287' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 15/12/2022 12:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 15/12/2022 12:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 15/12/2022 12:38: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 ( '77287' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/12/2022 12:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/12/2022 12:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/12/2022 12:38: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 ( '77287' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 15/12/2022 12:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 15/12/2022 12:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 15/12/2022 12:38:33 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 ( '77287' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '6' , '-6' , '4' , '1.20' , '1.2' , '0' , '5' , '6.84' ) 15/12/2022 12:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 15/12/2022 12:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 15/12/2022 12:45:45 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') 15/12/2022 12:45:45 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 € 200,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 = '390.90', price_tax_excluded = '323.37', date_upd = NOW() WHERE id_document = '57793' 15/12/2022 12:45: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 = '57793' 15/12/2022 12:45:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 15/12/2022 12:45: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 ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '11' , '-11' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '20.90' ) 15/12/2022 12:45:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/12/2022 12:45:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/12/2022 12:45: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 ( '57793' , '' , '15/12/2022' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0' ) 15/12/2022 12:45:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 15/12/2022 12:45:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 15/12/2022 12:45: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 ( '57793' , '20226' , 'BAMBINELLO IN GESSO CM 50 STILE ANTICO - J202/50' , '1' , '-1' , '1' , '370.00' , '303.27868852459' , '22' , '0' , '370.00' ) 15/12/2022 12:45:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20226' AND id_supplier = '' 15/12/2022 12:45:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20226' , '' , '1' ) 15/12/2022 12:45:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 12:45:58 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' , '3880' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 15/12/2022 12:45:58 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 = '77288' 15/12/2022 12:45:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77288' 15/12/2022 12:45: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 ( '77288' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 15/12/2022 12:45:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 15/12/2022 12:45:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 15/12/2022 12:53:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3865' AND id_document != '77268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 15/12/2022 12:53:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3865', document_date = '2022-12-14', 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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '77268' 15/12/2022 12:53: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 = '77268' 15/12/2022 12:53:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77268' 15/12/2022 12:53: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 ( '77268' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 15/12/2022 12:53:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 12:53:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 12:53: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 ( '77268' , '20170' , 'ANGELO IN GINOCCHIO - AR66' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 15/12/2022 12:53:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20170' AND id_supplier = '' 15/12/2022 12:53:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20170' , '' , '1' ) 15/12/2022 12:53: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 ( '77268' , '20182' , 'COPPIA TESTE DI ANGELO CM7 - AR06' , '4' , '-4' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '20.00' ) 15/12/2022 12:53:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20182' AND id_supplier = '' 15/12/2022 12:53:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20182' , '' , '1' ) 15/12/2022 12:53: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 ( '77268' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 15/12/2022 12:53:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18883' AND id_supplier = '' 15/12/2022 12:53:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18883' , '' , '1' ) 15/12/2022 03:00:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3295' AND id_document != '70309' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-03') 15/12/2022 03:00:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3295', document_date = '2022-11-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.70', price_tax_excluded = '12.87', date_upd = NOW() WHERE id_document = '70309' 15/12/2022 03:00: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 = '70309' 15/12/2022 03:00:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '70309' 15/12/2022 03:00: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 ( '70309' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 15/12/2022 03:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 15/12/2022 03:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 15/12/2022 03:00: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 ( '70309' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '1' , '5.7' , '4.672131147541' , '22' , '0' , '5.70' ) 15/12/2022 03:00:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20123' AND id_supplier = '' 15/12/2022 03:00:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20123' , '' , '1' ) 15/12/2022 03:07:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2022 03:07:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20521' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 03:07:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20521' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2022 03:07:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20521' , '0' , '1' , '0' , '0' ) 15/12/2022 03:08:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002085' AND id_product != '20521' AND ean13 != '' 15/12/2022 03:08:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002085', date_upd = NOW() WHERE id_product = '20521' 15/12/2022 03:08:48 pm >> UPDATE ps_product_lang SET name = 'CASETTA NATIVITA\' - 23/CAL-NAT04', description = '' WHERE id_product = '20521' 15/12/2022 03:08:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2295081967213115' WHERE id_product = '20521' 15/12/2022 03:08:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2295081967213115', id_tax_rules_group = '1', id_category_default = '154', 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 = '20521' 15/12/2022 03:08:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '20521' 15/12/2022 03:09:37 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '896', document_date = '2022-12-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2655', address1 = 'Z.I. PIANE MAVONE 64042 COLLEDARA', 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 = '1018.11', price_tax_excluded = '834.52', date_upd = NOW() WHERE id_document = '77283' 15/12/2022 03:09:37 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 = '77283' 15/12/2022 03:09:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '77283' 15/12/2022 03:09: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 ( '77283' , '20514' , 'ROSARIO S. BENEDETTO - 175/OV3' , '144' , '144' , '1' , '1.4000' , '1.1475409836066' , '22' , '3' , '238.57' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20514' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20514' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20516' , 'CROCE COMUNIONE - 42/08' , '700' , '700' , '1' , '0.4500' , '0.36885245901639' , '22' , '3' , '372.77' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20516' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20516' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20515' , 'DECINA ULIVO - 04/7-D' , '500' , '500' , '1' , '0.1800' , '0.14754098360656' , '22' , '3' , '106.51' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20515' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20515' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20513' , 'QUADRETTO CANDELA - 22/109-NAT04' , '50' , '50' , '1' , '0.5000' , '0.40983606557377' , '22' , '3' , '29.59' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20513' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20513' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '50' , '50' , '1' , '0.5000' , '0.40983606557377' , '22' , '3' , '29.59' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20521' , 'CASETTA NATIVITA - 23/CAL-NAT04' , '100' , '100' , '1' , '0.5' , '0.40983606557377' , '22' , '3' , '59.1700' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '12' , '12' , '1' , '1.8000' , '1.4754098360656' , '22' , '3' , '25.56' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20512' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20512' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20517' , 'ROSARIO PERLA - 43/4' , '100' , '100' , '1' , '0.7500' , '0.61475409836066' , '22' , '3' , '88.76' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20517' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20517' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20518' , 'DECINA PERLA - 43/4-D' , '24' , '24' , '1' , '0.3800' , '0.31147540983607' , '22' , '3' , '10.79' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20518' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20518' , '' , '1' ) 15/12/2022 03:09: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 ( '77283' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '24' , '24' , '1' , '2.0000' , '1.6393442622951' , '22' , '3' , '56.80' ) 15/12/2022 03:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '' 15/12/2022 03:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '' , '1' ) 15/12/2022 03:10:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3872' AND id_document != '77277' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 15/12/2022 03:10:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3872', document_date = '2022-12-14', 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 = '3.50', price_tax_excluded = '2.87', date_upd = NOW() WHERE id_document = '77277' 15/12/2022 03:10:03 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 = '77277' 15/12/2022 03:10:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77277' 15/12/2022 03:10:03 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 ( '77277' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 15/12/2022 03:10:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15105' AND id_supplier = '' 15/12/2022 03:10:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15105' , '' , '1' ) 15/12/2022 03:10:03 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 ( '77277' , '20521' , 'CASETTA NATIVITA - 23/CAL-NAT04' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/12/2022 03:10:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '' 15/12/2022 03:10:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '' , '1' ) 15/12/2022 03:22:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 03:22:23 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' , '3881' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.56' , '25.56' , NOW() , NOW() ) 15/12/2022 03:22:23 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 = '77289' 15/12/2022 03:22:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77289' 15/12/2022 03:22:23 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 ( '77289' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 15/12/2022 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '' 15/12/2022 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '' , '1' ) 15/12/2022 03:22:23 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 ( '77289' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 15/12/2022 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 15/12/2022 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 15/12/2022 03:37:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 03:37:34 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' , '3882' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.60' , '60.13' , NOW() , NOW() ) 15/12/2022 03:37:34 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 = '77290' 15/12/2022 03:37:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77290' 15/12/2022 03:37:34 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 ( '77290' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 15/12/2022 03:37:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/12/2022 03:37:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/12/2022 03:37:34 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 ( '77290' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 15/12/2022 03:37:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/12/2022 03:37:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/12/2022 03:37:34 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 ( '77290' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 15/12/2022 03:37:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/12/2022 03:37:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/12/2022 03:37:34 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 ( '77290' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 15/12/2022 03:37:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 15/12/2022 03:37:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 15/12/2022 03:42:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 03:42: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' , '3883' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.48' , '86.18' , NOW() , NOW() ) 15/12/2022 03:42: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 = '77291' 15/12/2022 03:42:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '77291' 15/12/2022 03:42: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 ( '77291' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 15/12/2022 03:42:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/12/2022 03:42:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/12/2022 03:42: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 ( '77291' , '19056' , 'NOVENA AL SANTO NATALE - A. CANOPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/12/2022 03:42:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19056' AND id_supplier = '' 15/12/2022 03:42:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19056' , '' , '1' ) 15/12/2022 03:42: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 ( '77291' , '9889' , 'SERMONI DEL NATALE - L. MAGNO - CONTO DEPOSITO' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 15/12/2022 03:42:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9889' AND id_supplier = '' 15/12/2022 03:42:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9889' , '' , '1' ) 15/12/2022 03:42: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 ( '77291' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 15/12/2022 03:42:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 15/12/2022 03:42:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 15/12/2022 04:12:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001185' AND id_product != '15484' AND ean13 != '' 15/12/2022 04:12:14 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001185', date_upd = NOW() WHERE id_product = '15484' 15/12/2022 04:12:14 pm >> UPDATE ps_product_lang SET name = 'CROCE - 076BIS ALV.', description = '' WHERE id_product = '15484' 15/12/2022 04:12:14 pm >> UPDATE ps_product SET wholesale_price = '0.74', on_sale = '0', price = '1.5573770491803278' WHERE id_product = '15484' 15/12/2022 04:12:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.74', price = '1.5573770491803278', id_tax_rules_group = '1', id_category_default = '401', 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 = '15484' 15/12/2022 04:12:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '15484' 15/12/2022 04:26:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2022 04:26:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20522' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 04:26:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20522' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2022 04:26:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20522' , '0' , '1' , '0' , '0' ) 15/12/2022 04:30:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002094' AND id_product != '20522' AND ean13 != '' 15/12/2022 04:30:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002094', date_upd = NOW() WHERE id_product = '20522' 15/12/2022 04:30:00 pm >> UPDATE ps_product_lang SET name = 'CROCE BASE NIK - 105 ALV', description = '' WHERE id_product = '20522' 15/12/2022 04:30:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '20522' 15/12/2022 04:30:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '401', 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 = '20522' 15/12/2022 04:30:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20522' 15/12/2022 04:37:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002094' AND id_product != '20522' AND ean13 != '' 15/12/2022 04:37:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002094', date_upd = NOW() WHERE id_product = '20522' 15/12/2022 04:37:15 pm >> UPDATE ps_product_lang SET name = 'CROCE BASE NIK - 105 ALV', description = '' WHERE id_product = '20522' 15/12/2022 04:37:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '20522' 15/12/2022 04:37:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '401', 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 = '20522' 15/12/2022 04:37:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20522' 15/12/2022 04:45:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 04:45:47 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' , '3884' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.44' , '29.44' , NOW() , NOW() ) 15/12/2022 04:45: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 = '77292' 15/12/2022 04:45:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '77292' 15/12/2022 04:45: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 ( '77292' , '9313' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE DEGLI INFERMI' , '2' , '-2' , '4' , '15.49' , '15.49' , '0' , '5' , '29.44' ) 15/12/2022 04:45:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9313' AND id_supplier = '' 15/12/2022 04:45:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9313' , '' , '1' ) 15/12/2022 04:47:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002094' AND id_product != '20522' AND ean13 != '' 15/12/2022 04:47:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002094', date_upd = NOW() WHERE id_product = '20522' 15/12/2022 04:47:03 pm >> UPDATE ps_product_lang SET name = 'CROCE BASE NIK - 105 ALV', description = '' WHERE id_product = '20522' 15/12/2022 04:47:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '20522' 15/12/2022 04:47:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '401', 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 = '20522' 15/12/2022 04:47:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '20522' 15/12/2022 04:48:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3747' AND id_document != '75569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 15/12/2022 04:48:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3747', document_date = '2022-12-05', 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 = '49.90', price_tax_excluded = '42.63', date_upd = NOW() WHERE id_document = '75569' 15/12/2022 04:48: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 = '75569' 15/12/2022 04:48:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '75569' 15/12/2022 04:48: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 ( '75569' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '3' , '-3' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '4.80' ) 15/12/2022 04:48:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11681' AND id_supplier = '' 15/12/2022 04:48:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11681' , '' , '1' ) 15/12/2022 04:48: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 ( '75569' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 15/12/2022 04:48:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 15/12/2022 04:48:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 15/12/2022 04:48: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 ( '75569' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/12/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 15/12/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 15/12/2022 04:48:43 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 ( '75569' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 15/12/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/12/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/12/2022 04:48:43 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 ( '75569' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 15/12/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/12/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/12/2022 04:48:43 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 ( '75569' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 15/12/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 15/12/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 15/12/2022 04:48:43 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 ( '75569' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '32.00' ) 15/12/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 15/12/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 15/12/2022 05:02:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 05:02:03 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' , '3885' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.66' , '6.66' , NOW() , NOW() ) 15/12/2022 05:02:03 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 = '77293' 15/12/2022 05:02:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77293' 15/12/2022 05:02:04 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 ( '77293' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 15/12/2022 05:02:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 15/12/2022 05:02:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 15/12/2022 05:02:04 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 ( '77293' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 15/12/2022 05:02:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 15/12/2022 05:02:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 15/12/2022 05:03:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 05:03:33 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' , '3886' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.45' , '16.80' , NOW() , NOW() ) 15/12/2022 05:03:33 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 = '77294' 15/12/2022 05:03:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '77294' 15/12/2022 05:03:33 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 ( '77294' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 15/12/2022 05:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/12/2022 05:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/12/2022 05:03:33 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 ( '77294' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/12/2022 05:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 15/12/2022 05:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 15/12/2022 05:09:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 05:09: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' , '3887' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 15/12/2022 05:09: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 = '77295' 15/12/2022 05:09:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '77295' 15/12/2022 05:09: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 ( '77295' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/12/2022 05:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 15/12/2022 05:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 15/12/2022 05:11:49 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2022 05:11:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20523' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 05:11:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20523' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2022 05:11:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20523' , '0' , '1' , '0' , '0' ) 15/12/2022 05:16:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002095' AND id_product != '20523' AND ean13 != '' 15/12/2022 05:16:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002095', date_upd = NOW() WHERE id_product = '20523' 15/12/2022 05:16:50 pm >> UPDATE ps_product_lang SET name = 'CROCE - 094 ALV', description = '' WHERE id_product = '20523' 15/12/2022 05:16:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '20523' 15/12/2022 05:16:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '401', 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 = '20523' 15/12/2022 05:16:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20523' 15/12/2022 05:28:43 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 ( '32' , '857' , '2022-12-15' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '25' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1143.28' , '937.12' , NOW() , NOW() ) 15/12/2022 05:28:43 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 = '77296' 15/12/2022 05:28:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '77296' 15/12/2022 05:28:44 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 ( '77296' , '20514' , 'ROSARIO S. BENEDETTO - 175/OV3' , '144' , '0' , '1' , '1.4000' , '1.1475' , '22' , '3' , '238.57' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20514' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20514' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20516' , 'CROCE COMUNIONE - 42/08' , '700' , '0' , '1' , '0.4500' , '0.3689' , '22' , '3' , '372.77' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20516' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20516' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20515' , 'DECINA ULIVO - 04/7-D' , '500' , '0' , '1' , '0.1800' , '0.1475' , '22' , '3' , '106.51' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20515' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20515' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20513' , 'QUADRETTO CANDELA - 22/109-NAT04' , '50' , '0' , '1' , '0.5000' , '0.4098' , '22' , '3' , '29.59' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20513' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20513' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '50' , '0' , '1' , '0.5000' , '0.4098' , '22' , '3' , '29.59' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20521' , 'CASETTA NATIVITA - 23/CAL-NAT04' , '100' , '0' , '1' , '0.5000' , '0.4098' , '22' , '3' , '59.17' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '12' , '0' , '1' , '1.8000' , '1.4754' , '22' , '3' , '25.56' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20512' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20512' , '60' , '1' ) 15/12/2022 05:28:44 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 ( '77296' , '20517' , 'ROSARIO PERLA - 43/4' , '100' , '0' , '1' , '0.7500' , '0.6148' , '22' , '3' , '88.76' ) 15/12/2022 05:28:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20517' AND id_supplier = '60' 15/12/2022 05:28:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20517' , '60' , '1' ) 15/12/2022 05:28: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 ( '77296' , '20518' , 'DECINA PERLA - 43/4-D' , '24' , '0' , '1' , '0.3800' , '0.3115' , '22' , '3' , '10.79' ) 15/12/2022 05:28:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20518' AND id_supplier = '60' 15/12/2022 05:28:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20518' , '60' , '1' ) 15/12/2022 05:28: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 ( '77296' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '24' , '0' , '1' , '2.0000' , '1.6393' , '22' , '3' , '56.80' ) 15/12/2022 05:28:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '60' 15/12/2022 05:28:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '60' , '1' ) 15/12/2022 05:28: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 ( '77296' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '50' , '0' , '1' , '1.6' , '1.3114754098361' , '22' , '3' , '94.6720' ) 15/12/2022 05:28:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20519' AND id_supplier = '60' 15/12/2022 05:28:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20519' , '60' , '1' ) 15/12/2022 05:29:05 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '896', document_date = '2022-12-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2655', address1 = 'Z.I. PIANE MAVONE 64042 COLLEDARA', 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 = '1112.78', price_tax_excluded = '912.12', date_upd = NOW() WHERE id_document = '77283' 15/12/2022 05:29: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 = '77283' 15/12/2022 05:29:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '77283' 15/12/2022 05:29: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 ( '77283' , '20514' , 'ROSARIO S. BENEDETTO - 175/OV3' , '144' , '144' , '1' , '1.4000' , '1.1475409836066' , '22' , '3' , '238.57' ) 15/12/2022 05:29:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20514' AND id_supplier = '' 15/12/2022 05:29:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20514' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20516' , 'CROCE COMUNIONE - 42/08' , '700' , '700' , '1' , '0.4500' , '0.36885245901639' , '22' , '3' , '372.77' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20516' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20516' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20515' , 'DECINA ULIVO - 04/7-D' , '500' , '500' , '1' , '0.1800' , '0.14754098360656' , '22' , '3' , '106.51' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20515' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20515' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20513' , 'QUADRETTO CANDELA - 22/109-NAT04' , '50' , '50' , '1' , '0.5000' , '0.40983606557377' , '22' , '3' , '29.59' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20513' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20513' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '50' , '50' , '1' , '0.5000' , '0.40983606557377' , '22' , '3' , '29.59' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20521' , 'CASETTA NATIVITA - 23/CAL-NAT04' , '100' , '100' , '1' , '0.5000' , '0.40983606557377' , '22' , '3' , '59.17' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '' , '1' ) 15/12/2022 05:29:06 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 ( '77283' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '12' , '12' , '1' , '1.8000' , '1.4754098360656' , '22' , '3' , '25.56' ) 15/12/2022 05:29:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20512' AND id_supplier = '' 15/12/2022 05:29:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20512' , '' , '1' ) 15/12/2022 05:29: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 ( '77283' , '20517' , 'ROSARIO PERLA - 43/4' , '100' , '100' , '1' , '0.7500' , '0.61475409836066' , '22' , '3' , '88.76' ) 15/12/2022 05:29:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20517' AND id_supplier = '' 15/12/2022 05:29:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20517' , '' , '1' ) 15/12/2022 05:29: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 ( '77283' , '20518' , 'DECINA PERLA - 43/4-D' , '24' , '24' , '1' , '0.3800' , '0.31147540983607' , '22' , '3' , '10.79' ) 15/12/2022 05:29:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20518' AND id_supplier = '' 15/12/2022 05:29:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20518' , '' , '1' ) 15/12/2022 05:29: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 ( '77283' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '24' , '24' , '1' , '2.0000' , '1.6393442622951' , '22' , '3' , '56.80' ) 15/12/2022 05:29:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '' 15/12/2022 05:29:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '' , '1' ) 15/12/2022 05:29: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 ( '77283' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '50' , '50' , '1' , '1.6' , '1.3114754098361' , '22' , '3' , '94.6720' ) 15/12/2022 05:29:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20519' AND id_supplier = '' 15/12/2022 05:29:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20519' , '' , '1' ) 15/12/2022 05:35:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001575' AND id_product != '18339' AND ean13 != '' 15/12/2022 05:35:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001575', date_upd = NOW() WHERE id_product = '18339' 15/12/2022 05:35:51 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI', description = '' WHERE id_product = '18339' 15/12/2022 05:35:51 pm >> UPDATE ps_product SET wholesale_price = '4.38', on_sale = '0', price = '9.01639344262295' WHERE id_product = '18339' 15/12/2022 05:35:52 pm >> UPDATE ps_product_shop SET wholesale_price = '4.38', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '401', 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 = '18339' 15/12/2022 05:35:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '18339' 15/12/2022 05:39:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001194' AND id_product != '15498' AND ean13 != '' 15/12/2022 05:39:55 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001194', date_upd = NOW() WHERE id_product = '15498' 15/12/2022 05:39:55 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK', description = '' WHERE id_product = '15498' 15/12/2022 05:39:55 pm >> UPDATE ps_product SET wholesale_price = '6.28', on_sale = '0', price = '12.2951' WHERE id_product = '15498' 15/12/2022 05:39:55 pm >> UPDATE ps_product_shop SET wholesale_price = '6.28', price = '12.2951', id_tax_rules_group = '1', id_category_default = '401', 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 = '15498' 15/12/2022 05:39:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '15498' 15/12/2022 05:40:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001194' AND id_product != '15498' AND ean13 != '' 15/12/2022 05:40:13 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001194', date_upd = NOW() WHERE id_product = '15498' 15/12/2022 05:40:13 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK', description = '' WHERE id_product = '15498' 15/12/2022 05:40:13 pm >> UPDATE ps_product SET wholesale_price = '6.28', on_sale = '0', price = '13.114754098360656' WHERE id_product = '15498' 15/12/2022 05:40:13 pm >> UPDATE ps_product_shop SET wholesale_price = '6.28', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '401', 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 = '15498' 15/12/2022 05:40:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '15498' 15/12/2022 05:43:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001577' AND id_product != '12490' AND ean13 != '' 15/12/2022 05:43:52 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001577', date_upd = NOW() WHERE id_product = '12490' 15/12/2022 05:43:52 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO ULIVO - CZ6NIK', description = '' WHERE id_product = '12490' 15/12/2022 05:43:52 pm >> UPDATE ps_product SET wholesale_price = '7.40', on_sale = '0', price = '13.9344' WHERE id_product = '12490' 15/12/2022 05:43:52 pm >> UPDATE ps_product_shop SET wholesale_price = '7.40', price = '13.9344', id_tax_rules_group = '1', id_category_default = '401', 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 = '12490' 15/12/2022 05:43:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '12490' 15/12/2022 05:54:56 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2022 05:54:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20524' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 05:54:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20524' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2022 05:54:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20524' , '0' , '1' , '0' , '0' ) 15/12/2022 05:56:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002096' AND id_product != '20524' AND ean13 != '' 15/12/2022 05:56:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002096', date_upd = NOW() WHERE id_product = '20524' 15/12/2022 05:56:15 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK', description = '' WHERE id_product = '20524' 15/12/2022 05:56:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '20524' 15/12/2022 05:56:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '401', 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 = '20524' 15/12/2022 05:56:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20524' 15/12/2022 05:58:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002096' AND id_product != '20524' AND ean13 != '' 15/12/2022 05:58:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002096', date_upd = NOW() WHERE id_product = '20524' 15/12/2022 05:58:29 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK', description = '' WHERE id_product = '20524' 15/12/2022 05:58:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '20524' 15/12/2022 05:58:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '401', 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 = '20524' 15/12/2022 05:58:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20524' 15/12/2022 06:01:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001192' AND id_product != '15492' AND ean13 != '' 15/12/2022 06:01:39 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001192', date_upd = NOW() WHERE id_product = '15492' 15/12/2022 06:01:39 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK', description = '' WHERE id_product = '15492' 15/12/2022 06:01:39 pm >> UPDATE ps_product SET wholesale_price = '10.30', on_sale = '0', price = '21.311475409836067' WHERE id_product = '15492' 15/12/2022 06:01:39 pm >> UPDATE ps_product_shop SET wholesale_price = '10.30', price = '21.311475409836067', id_tax_rules_group = '1', id_category_default = '401', 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 = '15492' 15/12/2022 06:01:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '15492' 15/12/2022 06:10:11 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2022 06:10:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20525' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 06:10:11 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20525' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2022 06:10:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20525' , '0' , '1' , '0' , '0' ) 15/12/2022 06:11:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002097' AND id_product != '20525' AND ean13 != '' 15/12/2022 06:11:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002097', date_upd = NOW() WHERE id_product = '20525' 15/12/2022 06:11:29 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM', description = '' WHERE id_product = '20525' 15/12/2022 06:11:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.4426229508196724' WHERE id_product = '20525' 15/12/2022 06:11:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.4426229508196724', id_tax_rules_group = '1', id_category_default = '401', 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 = '20525' 15/12/2022 06:11:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20525' 15/12/2022 06:12:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002097' AND id_product != '20525' AND ean13 != '' 15/12/2022 06:12:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002097', date_upd = NOW() WHERE id_product = '20525' 15/12/2022 06:12:08 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM', description = '' WHERE id_product = '20525' 15/12/2022 06:12:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.4426229508196724' WHERE id_product = '20525' 15/12/2022 06:12:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.4426229508196724', id_tax_rules_group = '1', id_category_default = '401', 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 = '20525' 15/12/2022 06:12:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '20525' 15/12/2022 06:12:09 pm >> 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 = '20525' 15/12/2022 06:12:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20526' , '1' , '' , 'nuovo-prodotto' ) 15/12/2022 06:12:09 pm >> 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 '20526' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20525' 15/12/2022 06:12:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20526' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20525' 15/12/2022 06:13:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002098' AND id_product != '20526' AND ean13 != '' 15/12/2022 06:13:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002098', date_upd = NOW() WHERE id_product = '20526' 15/12/2022 06:13:23 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO 36MM - M275/A', description = '' WHERE id_product = '20526' 15/12/2022 06:13:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '20526' 15/12/2022 06:13:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '401', 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 = '20526' 15/12/2022 06:13:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20526' 15/12/2022 06:13:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002098' AND id_product != '20526' AND ean13 != '' 15/12/2022 06:13:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002098', date_upd = NOW() WHERE id_product = '20526' 15/12/2022 06:13:43 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO 36MM - M275/A', description = '' WHERE id_product = '20526' 15/12/2022 06:13:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '20526' 15/12/2022 06:13:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '401', 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 = '20526' 15/12/2022 06:13:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '20526' 15/12/2022 06:16:23 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 ( '33' , '426' , '2022-12-13' , '' , '0' , '91' , '2738' , 'ZONA IND. G. BRODOLINI, 25 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '497.71' , '407.96' , NOW() , NOW() ) 15/12/2022 06:16:23 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 = '77297' 15/12/2022 06:16:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77297' 15/12/2022 06:16:23 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 ( '77297' , '20523' , 'CROCE - 094 ALV' , '24' , '24' , '1' , '3.29' , '2.6967213114754' , '22' , '50+10+3' , '42.0486' ) 15/12/2022 06:16:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20523' AND id_supplier = '91' 15/12/2022 06:16:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20523' , '91' , '1' ) 15/12/2022 06:16:23 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 ( '77297' , '20522' , 'CROCE BASE NIK - 105 ALV' , '24' , '24' , '1' , '2.29' , '1.8770491803279' , '22' , '50+10+3' , '29.2678' ) 15/12/2022 06:16:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20522' AND id_supplier = '91' 15/12/2022 06:16:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20522' , '91' , '1' ) 15/12/2022 06:16:23 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 ( '77297' , '15484' , 'CROCE - 076BIS ALV.' , '24' , '24' , '1' , '1.733' , '1.4204918032787' , '22' , '50+10+3' , '22.1490' ) 15/12/2022 06:16:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15484' AND id_supplier = '91' 15/12/2022 06:16:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15484' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '26' , '26' , '1' , '9.95' , '8.155737704918' , '22' , '50+10+3' , '137.7655' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '11' , '11' , '1' , '14.3' , '11.72131147541' , '22' , '50+10+3' , '83.7670' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15498' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15498' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '12490' , 'CROCE SAN BENEDETTO ULIVO COL' , '1' , '1' , '1' , '14.45' , '11.844262295082' , '22' , '50+10+3' , '7.6951' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12490' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12490' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '20' , '20' , '1' , '3.88' , '3.1803278688525' , '22' , '50+10+3' , '41.3243' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20524' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20524' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '2' , '2' , '1' , '23.4' , '19.180327868852' , '22' , '50+10+3' , '24.9224' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15492' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15492' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '15497' , 'CROCE PLEX - 086' , '5' , '5' , '1' , '7.16' , '5.8688524590164' , '22' , '50+10+3' , '19.0646' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15497' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15497' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '20525' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM' , '24' , '24' , '1' , '3.36' , '2.7540983606557' , '22' , '50+10+3' , '42.9432' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20525' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20525' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '50' , '50' , '1' , '0.84' , '0.68852459016393' , '22' , '50+10+3' , '22.3663' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20526' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20526' , '91' , '1' ) 15/12/2022 06:16:24 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 ( '77297' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 15/12/2022 06:16:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '91' 15/12/2022 06:16:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '91' , '1' ) 15/12/2022 06:23:28 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'E6SdLi9hPWCGJppw' , NOW() , NOW() ) 15/12/2022 06:23:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3994' , '1' ) 15/12/2022 06:23:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3994' , '2' ) 15/12/2022 06:23:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3994' , '3' ) 15/12/2022 06:25:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3994' 15/12/2022 06:25:35 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3994' , '10' , '145' , 'IMBALPAST SRL' , '' , '' , 'Via Consortile Zona Ind.Asi' , '' , '81030' , 'TEVEROLA' , 'COTENA RAFFAELE ' , '' , '3356277695' , '01452051210' , '05712370633' , NOW() , NOW() ) 15/12/2022 06:25:35 pm >> UPDATE ps_customer SET email = 'raffaele.cotena@imbalplast.com', sdi = 'J6URRTW', pec = '', date_upd = NOW() WHERE id_customer = '3994' 15/12/2022 06:26:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820322' AND id_product != '1134' AND ean13 != '' 15/12/2022 06:26:34 pm >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820322', date_upd = NOW() WHERE id_product = '1134' 15/12/2022 06:26:34 pm >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME NERA', description = '' WHERE id_product = '1134' 15/12/2022 06:26:34 pm >> UPDATE ps_product SET wholesale_price = '18.77', on_sale = '0', price = '32.0000' WHERE id_product = '1134' 15/12/2022 06:26:34 pm >> UPDATE ps_product_shop SET wholesale_price = '18.77', price = '32.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1134' 15/12/2022 06:26:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '1134' 15/12/2022 06:27:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 06:27:05 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 ( '23' , '22/L' , '2022-12-15' , 'L' , '3994' , '0' , '4677906' , 'Via Consortile Zona Ind.Asi 81030 TEVEROLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1360.00' , '1360.00' , NOW() , NOW() ) 15/12/2022 06:27: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 = '77298' 15/12/2022 06:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '77298' 15/12/2022 06:27: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 ( '77298' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '50' , '-50' , '4' , '32' , '32' , '0' , '15' , '1360.00' ) 15/12/2022 07:12:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '189' 15/12/2022 07:12:46 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '189' , '10' , '145' , 'CRISTO RE ARTE SACRA SRL' , '' , '' , 'VIA NAZIONALE APPIA, 128' , '' , '81022' , 'CASAGIOVE' , 'SCONTO 38%' , '' , '' , '04195520616' , '' , NOW() , NOW() ) 15/12/2022 07:12:46 pm >> UPDATE ps_customer SET email = '', sdi = 'W4KYJ8V', pec = 'cristoreartesacrasrl@arubapec.it', date_upd = NOW() WHERE id_customer = '189' 15/12/2022 07:12:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:12:52 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 ( '24' , '117/A' , '2022-12-15' , 'A' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '446.40' , '446.40' , NOW() , NOW() ) 15/12/2022 07:12: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 = '77299' 15/12/2022 07:12:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77299' 15/12/2022 07:12: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 ( '77299' , '15020' , 'PREGARE OGNI GIORNO' , '720' , '-720' , '4' , '1.00' , '1' , '0' , '38' , '446.40' ) 15/12/2022 07:14:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:14:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '117 A' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:14: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 ( '26' , '117 A' , '2022-12-15' , '' , '189' , '0' , '4677907' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '446.40' , '446.40' , NOW() , NOW() ) 15/12/2022 07:14: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 = '77300' 15/12/2022 07:14:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '77300' 15/12/2022 07:14: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 ( '77300' , '15020' , 'PREGARE OGNI GIORNO' , '720' , '0' , '4' , '1.00' , '1' , '0' , '38' , '446.40' ) 15/12/2022 07:14:29 pm >> DELETE FROM ps_document WHERE id_document = '77300' 15/12/2022 07:14:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '77300' 15/12/2022 07:18:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '117 A' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:18:17 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 ( '26' , '117 A' , '2022-12-15' , '' , '189' , '0' , '4677907' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '13.6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '460.00' , '460.00' , NOW() , NOW() ) 15/12/2022 07:18:17 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 = '77301' 15/12/2022 07:18:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '77301' 15/12/2022 07:18:17 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 ( '77301' , '15020' , 'PREGARE OGNI GIORNO' , '720' , '0' , '4' , '1.00' , '1' , '0' , '38' , '446.40' ) 15/12/2022 07:18:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '77299' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:18:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '117/A', document_date = '2022-12-15', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4670598', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '13.6', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '460.00', price_tax_excluded = '460.00', date_upd = NOW() WHERE id_document = '77299' 15/12/2022 07:18:44 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 = '77299' 15/12/2022 07:18:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '77299' 15/12/2022 07:18:44 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 ( '77299' , '15020' , 'PREGARE OGNI GIORNO' , '720' , '-720' , '4' , '1.0000' , '1' , '0' , '38' , '446.40' ) 15/12/2022 07:18:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 15/12/2022 07:18:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 15/12/2022 07:23:06 pm >> DELETE FROM ps_document WHERE id_document = '77301' 15/12/2022 07:23:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '77301' 15/12/2022 07:33:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:33:27 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' , '3888' , '2022-12-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 15/12/2022 07:33:27 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 = '77302' 15/12/2022 07:33:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '77302' 15/12/2022 07:33:27 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 ( '77302' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 15/12/2022 07:33:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 07:33:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 07:43:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3888' AND id_document != '77302' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 15/12/2022 07:43:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3888', document_date = '2022-12-15', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '77302' 15/12/2022 07:43:02 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 = '77302' 15/12/2022 07:43:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77302' 15/12/2022 07:43:02 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 ( '77302' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '31' , '25.409836065574' , '22' , '0' , '31.00' ) 15/12/2022 07:43:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/12/2022 07:43:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/12/2022 07:43:02 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 ( '77302' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 15/12/2022 07:43:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19998' AND id_supplier = '' 15/12/2022 07:43:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19998' , '' , '1' ) 15/12/2022 07:43:02 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 ( '77302' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 15/12/2022 07:43:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18885' AND id_supplier = '' 15/12/2022 07:43:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18885' , '' , '1' )