26/03/2025 08:41:37 am >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '96358' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-25') 26/03/2025 08:41:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13', document_date = '2025-03-25', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '2250.00', price_tax_excluded = '2250.00', date_upd = NOW() WHERE id_document = '96358' 26/03/2025 08:41: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 = '96358' 26/03/2025 08:41:37 am >> DELETE FROM ps_document_detail WHERE id_document = '96358' 26/03/2025 08:41: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 ( '96358' , '4154' , 'FESTA DEL PERDONO' , '560' , '-560' , '4' , '3.0000' , '3' , '0' , '0' , '1680.00' ) 26/03/2025 08:41: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 ( '96358' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '38' , '-38' , '4' , '15.0000' , '15' , '0' , '0' , '570.00' ) 26/03/2025 08:41:49 am >> DELETE FROM ps_document WHERE id_document = '96351' 26/03/2025 08:41:49 am >> DELETE FROM ps_document_detail WHERE id_document = '96351' 26/03/2025 08:49:36 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '95726' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-13') 26/03/2025 08:49:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2025-02-13', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'MERCE SCARICATA', 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 = '231.00', price_tax_excluded = '195.65', date_upd = NOW() WHERE id_document = '95726' 26/03/2025 08:49:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95726' 26/03/2025 08:49:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95726' 26/03/2025 08:49: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 ( '95726' , '6014' , 'LUMINO BIANCO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 26/03/2025 08:49: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 ( '95726' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/03/2025 08:49: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 ( '95726' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 26/03/2025 08:49: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 ( '95726' , '11151' , 'LIBRI rito comunione' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 26/03/2025 08:52:09 am >> SELECT document_num FROM ps_document WHERE document_num = '705' AND id_document != '96012' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-03') 26/03/2025 08:52:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '705', document_date = '2025-03-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 = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '96012' 26/03/2025 08:52:09 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 = '96012' 26/03/2025 08:52:09 am >> DELETE FROM ps_document_detail WHERE id_document = '96012' 26/03/2025 08:52:09 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 ( '96012' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 26/03/2025 08:52:09 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 ( '96012' , '6014' , 'LUMINO BIANCO - 10B' , '370' , '-370' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '148.00' ) 26/03/2025 08:52:34 am >> SELECT document_num FROM ps_document WHERE document_num = '596' AND id_document != '95884' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-24') 26/03/2025 08:52:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '596', document_date = '2025-02-24', 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 = '565.00', price_tax_excluded = '463.11', date_upd = NOW() WHERE id_document = '95884' 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95884' 26/03/2025 08:52:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95884' 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95884' , '18905' , 'PORTA TURIBOLO CM 147 - 32-706' , '1' , '-1' , '1' , '355.0000' , '290.98360655738' , '22' , '0' , '355.00' ) 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95884' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '69.5000' , '56.967213114754' , '22' , '0' , '139.00' ) 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95884' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95884' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '9.00' ) 26/03/2025 08:52:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95884' , '6014' , 'LUMINO BIANCO - 10B' , '14' , '-14' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '5.60' ) 26/03/2025 09:38:43 am >> SELECT document_num FROM ps_document WHERE document_num = '975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 09:38: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' , '975' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '209.60' , '175.14' , NOW() , NOW() ) 26/03/2025 09:38: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 = '96367' 26/03/2025 09:38:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96367' 26/03/2025 09:38: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 ( '96367' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 26/03/2025 09:38: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 ( '96367' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 26/03/2025 09:38: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 ( '96367' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 26/03/2025 09:38: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 ( '96367' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '11' , '9.016393442623' , '22' , '0' , '22.00' ) 26/03/2025 09:38: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 ( '96367' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/03/2025 09:38: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 ( '96367' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '84.00' ) 26/03/2025 10:11:43 am >> SELECT document_num FROM ps_document WHERE document_num = '976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 10:11: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' , '976' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 26/03/2025 10:11: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 = '96368' 26/03/2025 10:11:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96368' 26/03/2025 10:11: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 ( '96368' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 26/03/2025 10:11: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 ( '96368' , '13506' , 'SANTO ROSARIO' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 26/03/2025 11:17:02 am >> SELECT document_num FROM ps_document WHERE document_num = '977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 11:17:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '977' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 26/03/2025 11:17:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96369' 26/03/2025 11:17:02 am >> DELETE FROM ps_document_detail WHERE id_document = '96369' 26/03/2025 11:17:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96369' , '17393' , 'BREVE STORIA DELLA CHIESA - A. FRANZEN' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 26/03/2025 11:18:35 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '95699' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-10') 26/03/2025 11:18:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2025-02-10', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'p. giuseppe castronuovo - baronissi - acconto € 110,00 - 08/03 € 50,00 - 26/03 € 60,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 = '220.38', price_tax_excluded = '184.06', date_upd = NOW() WHERE id_document = '95699' 26/03/2025 11:18:35 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 = '95699' 26/03/2025 11:18:35 am >> DELETE FROM ps_document_detail WHERE id_document = '95699' 26/03/2025 11:18:35 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 ( '95699' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 26/03/2025 11:18:35 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 ( '95699' , '17748' , 'SEGNALIBRO - PR 349' , '4' , '-4' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '1.40' ) 26/03/2025 11:18:35 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 ( '95699' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/03/2025 11:18:35 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 ( '95699' , '22366' , 'SAN GIUSEPPE CM 60 - 08.423' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 26/03/2025 11:18:35 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 ( '95699' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 26/03/2025 11:18:35 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 ( '95699' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '4.0500' , '4.05' , '0' , '0' , '4.05' ) 26/03/2025 11:19:51 am >> SELECT document_num FROM ps_document WHERE document_num = '978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 11:19:51 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' , '978' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '183.68' , NOW() , NOW() ) 26/03/2025 11:19:51 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 = '96370' 26/03/2025 11:19:51 am >> DELETE FROM ps_document_detail WHERE id_document = '96370' 26/03/2025 11:19:51 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 ( '96370' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 26/03/2025 11:19:51 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 ( '96370' , '17748' , 'SEGNALIBRO - PR 349' , '4' , '-4' , '1' , '0.3500' , '0.2869' , '22' , '0' , '1.40' ) 26/03/2025 11:19:51 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 ( '96370' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/03/2025 11:19:51 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 ( '96370' , '22366' , 'SAN GIUSEPPE CM 60 - 08.423' , '1' , '-1' , '1' , '200.0000' , '163.9344' , '22' , '0' , '200.00' ) 26/03/2025 11:19:51 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 ( '96370' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '1.62' , '1.62' , '0' , '0' , '1.62' ) 26/03/2025 11:19:51 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 ( '96370' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '4.0500' , '4.05' , '0' , '0' , '4.05' ) 26/03/2025 11:20:21 am >> SELECT document_num FROM ps_document WHERE document_num = '979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 11:20:21 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' , '979' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 26/03/2025 11:20: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 = '96371' 26/03/2025 11:20:21 am >> DELETE FROM ps_document_detail WHERE id_document = '96371' 26/03/2025 11:20: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 ( '96371' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/03/2025 11:20: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 ( '96371' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/03/2025 11:20:56 am >> SELECT document_num FROM ps_document WHERE document_num = '980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 11:20:56 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' , '980' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 26/03/2025 11:20:56 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 = '96372' 26/03/2025 11:20:56 am >> DELETE FROM ps_document_detail WHERE id_document = '96372' 26/03/2025 11:20:56 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 ( '96372' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/03/2025 11:20:57 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 ( '96372' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/03/2025 11:22:45 am >> DELETE FROM ps_document WHERE id_document = '95699' 26/03/2025 11:22:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95699' 26/03/2025 11:49:43 am >> SELECT document_num FROM ps_document WHERE document_num = '981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 11:49: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' , '981' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 26/03/2025 11:49: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 = '96373' 26/03/2025 11:49:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96373' 26/03/2025 11:49: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 ( '96373' , '23553' , ' CONFEZIONE LIBRO + CORONCINA ACUTIS - 10941' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 26/03/2025 12:06:09 pm >> DELETE FROM ps_document WHERE id_document = '95726' 26/03/2025 12:06:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95726' 26/03/2025 12:27:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 12:27:51 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' , '982' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.57' , '121.06' , NOW() , NOW() ) 26/03/2025 12:27:51 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 = '96374' 26/03/2025 12:27:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '96374' 26/03/2025 12:27:51 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 ( '96374' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/03/2025 12:27:51 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 ( '96374' , '22372' , 'VOLTO DI GESU IL SERVO CROCIFISSO - E. BIANCHI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/03/2025 12:27:51 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 ( '96374' , '23498' , 'SPERANZA NELLA VIA DELLA CROCE' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 26/03/2025 12:27:51 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 ( '96374' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 26/03/2025 12:27:51 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 ( '96374' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 26/03/2025 12:27:51 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 ( '96374' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/03/2025 12:27:51 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 ( '96374' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 26/03/2025 12:57:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 12:57: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' , '983' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 26/03/2025 12:57: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 = '96375' 26/03/2025 12:57:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96375' 26/03/2025 12:57: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 ( '96375' , '15917' , 'STOLA DIACONALE CROCE - AESP06' , '1' , '-1' , '1' , '57.00' , '46.72131147541' , '22' , '0' , '57.00' ) 26/03/2025 12:57:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 12:57:26 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' , '984' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 26/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96376' 26/03/2025 12:57:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '96376' 26/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96376' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 26/03/2025 03:21:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 03:21:21 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' , '985' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 26/03/2025 03:21:21 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 = '96377' 26/03/2025 03:21:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '96377' 26/03/2025 03:21:21 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 ( '96377' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 26/03/2025 04:48:36 pm >> DELETE FROM ps_product WHERE id_product = '79' 26/03/2025 04:48:36 pm >> DELETE FROM ps_product_shop WHERE id_product = '79' 26/03/2025 04:48:36 pm >> DELETE FROM ps_product_lang WHERE id_product = '79' 26/03/2025 04:48:36 pm >> DELETE FROM ps_stock_available WHERE id_product = '79' 26/03/2025 05:13:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 05:13:19 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' , '986' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '24.18' , NOW() , NOW() ) 26/03/2025 05:13:19 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 = '96378' 26/03/2025 05:13:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96378' 26/03/2025 05:13:19 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 ( '96378' , '17343' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIKSM' , '1' , '-1' , '1' , '29.50' , '24.180327868852' , '22' , '0' , '29.50' ) 26/03/2025 05:40:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001574' AND id_product != '17343' AND ean13 != '' 26/03/2025 05:40:11 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001574', date_upd = NOW() WHERE id_product = '17343' 26/03/2025 05:40:11 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIKSM', description = '' WHERE id_product = '17343' 26/03/2025 05:40:11 pm >> UPDATE ps_product SET wholesale_price = '9.25', on_sale = '0', price = '19.262295081967213' WHERE id_product = '17343' 26/03/2025 05:40:11 pm >> UPDATE ps_product_shop SET wholesale_price = '9.25', price = '19.262295081967213', 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 = '17343' 26/03/2025 05:40:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '17343' 26/03/2025 05:41:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001574' AND id_product != '17343' AND ean13 != '' 26/03/2025 05:41:30 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001574', date_upd = NOW() WHERE id_product = '17343' 26/03/2025 05:41:30 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO LEGNO SMALTATA - CZ6NIKSM', description = '' WHERE id_product = '17343' 26/03/2025 05:41:30 pm >> UPDATE ps_product SET wholesale_price = '9.25', on_sale = '0', price = '19.2623' WHERE id_product = '17343' 26/03/2025 05:41:30 pm >> UPDATE ps_product_shop SET wholesale_price = '9.25', price = '19.2623', 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 = '17343' 26/03/2025 05:41:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '17343' 26/03/2025 05:44:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2779' AND id_document != '87241' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 26/03/2025 05:44:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2779', document_date = '2023-09-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.00', price_tax_excluded = '21.31', date_upd = NOW() WHERE id_document = '87241' 26/03/2025 05:44:20 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 = '87241' 26/03/2025 05:44:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '87241' 26/03/2025 05:44:20 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 ( '87241' , '17343' , 'CROCE SAN BENEDETTO LEGNO SMALTATA - CZ6NIKSM' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 26/03/2025 06:09:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 06:09:53 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' , '987' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.40' , '16.71' , NOW() , NOW() ) 26/03/2025 06:09:53 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 = '96379' 26/03/2025 06:09:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '96379' 26/03/2025 06:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96379' , '23098' , 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC' , '1' , '-1' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '2.70' ) 26/03/2025 06:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96379' , '23550' , 'SAN CARLO ACUTIS - 8361' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 26/03/2025 06:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96379' , '22194' , 'PREGHIAMO CON I SANTI MARIA GORETTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 26/03/2025 06:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96379' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 26/03/2025 06:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96379' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.6' , '7.0491803278689' , '22' , '0' , '8.60' ) 26/03/2025 06:16:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002355' AND id_product != '23556' AND ean13 != '' 26/03/2025 06:16:23 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '002355', date_upd = NOW() WHERE id_product = '23556' 26/03/2025 06:16:23 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CARLO ACUTIS - CM20 - ST212-AC', description = '' WHERE id_product = '23556' 26/03/2025 06:16:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '23556' 26/03/2025 06:16:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '151', 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 = '23556' 26/03/2025 06:16:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '23556' 26/03/2025 06:21:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002356' AND id_product != '23556' AND ean13 != '' 26/03/2025 06:21:48 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '002356', date_upd = NOW() WHERE id_product = '23556' 26/03/2025 06:21:48 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CARLO ACUTIS - CM20 - ST211-AC', description = '' WHERE id_product = '23556' 26/03/2025 06:21:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.2950819672131155' WHERE id_product = '23556' 26/03/2025 06:21:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.2950819672131155', id_tax_rules_group = '1', id_category_default = '151', 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 = '23556' 26/03/2025 06:21:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '23556' 26/03/2025 06:22:14 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '561', document_date = '2025-03-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '164.03', price_tax_excluded = '134.45', date_upd = NOW() WHERE id_document = '96234' 26/03/2025 06:22: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 = '96234' 26/03/2025 06:22:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '96234' 26/03/2025 06:22: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 ( '96234' , '17786' , 'CROCE METALLO CM 10 - FX125-SA' , '1' , '1' , '1' , '4.3700' , '3.5819672131148' , '22' , '10' , '4.80' ) 26/03/2025 06:22: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 ( '96234' , '22531' , 'ICONA LEGNO FOGLIA ORO 25X20 - K204.68' , '1' , '1' , '1' , '17.2200' , '14.114754098361' , '22' , '10' , '18.91' ) 26/03/2025 06:22: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 ( '96234' , '20968' , 'CROCE SAN BENEDETTO - PG598' , '4' , '4' , '1' , '5.9500' , '4.8770491803279' , '22' , '10' , '26.13' ) 26/03/2025 06:22: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 ( '96234' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.5700' , '4.5655737704918' , '22' , '10' , '6.12' ) 26/03/2025 06:22: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 ( '96234' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '1' , '1' , '1' , '11.6900' , '9.5819672131148' , '22' , '10' , '12.84' ) 26/03/2025 06:22: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 ( '96234' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '100' , '100' , '1' , '0.1040' , '0.085245901639344' , '22' , '10' , '11.42' ) 26/03/2025 06:22: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 ( '96234' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '1' , '1' , '8.6000' , '7.0491803278689' , '22' , '10' , '9.44' ) 26/03/2025 06:22: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 ( '96234' , '23555' , 'STATUA SAN CARLO ACUTIS - CM7 - ST210-AC' , '12' , '12' , '1' , '2.4200' , '1.983606557377' , '22' , '10' , '31.89' ) 26/03/2025 06:22: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 ( '96234' , '23556' , 'STATUA SAN CARLO ACUTIS - CM20 - ST211-AC' , '1' , '1' , '1' , '3.68' , '3.016393442623' , '22' , '10' , '4.0406' ) 26/03/2025 06:22: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 ( '96234' , '17879' , 'STATUA SAN GIUSEPPE CM 15 - ST212-SG' , '1' , '1' , '1' , '7.88' , '6.4590163934426' , '22' , '10' , '8.6522' ) 26/03/2025 06:22: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 ( '96234' , '23556' , 'STATUA SAN CARLO ACUTIS - CM20 - ST213-AC' , '1' , '1' , '1' , '13.1300' , '10.762295081967' , '22' , '10' , '14.42' ) 26/03/2025 06:22: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 ( '96234' , '23557' , 'STATUA S. MICHELE BIANCA - ST203-BSM' , '1' , '1' , '1' , '14.0000' , '11.475409836066' , '22' , '10' , '15.37' ) 26/03/2025 06:23:52 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/03/2025 06:23:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23599' , '1' , '' , 'nuovo-prodotto' ) 26/03/2025 06:23:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23599' , '1' , '1' , '2' , NOW() , NOW() ) 26/03/2025 06:23:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23599' , '0' , '1' , '0' , '0' ) 26/03/2025 06:24:42 pm >> DELETE FROM ps_product WHERE id_product = '23556' 26/03/2025 06:24:42 pm >> DELETE FROM ps_product_shop WHERE id_product = '23556' 26/03/2025 06:24:42 pm >> DELETE FROM ps_product_lang WHERE id_product = '23556' 26/03/2025 06:24:42 pm >> DELETE FROM ps_stock_available WHERE id_product = '23556' 26/03/2025 06:26:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002355' AND id_product != '23599' AND ean13 != '' 26/03/2025 06:26:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002355', date_upd = NOW() WHERE id_product = '23599' 26/03/2025 06:26:13 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CARLO ACUTIS - ST211AC', description = '' WHERE id_product = '23599' 26/03/2025 06:26:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.2950819672131155' WHERE id_product = '23599' 26/03/2025 06:26:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.2950819672131155', id_tax_rules_group = '1', id_category_default = '151', 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 = '23599' 26/03/2025 06:26:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '23599' 26/03/2025 06:26:14 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 = '23599' 26/03/2025 06:26:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23600' , '1' , '' , 'nuovo-prodotto' ) 26/03/2025 06:26:14 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 '23600' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23599' 26/03/2025 06:26:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23600' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23599' 26/03/2025 06:26:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002356' AND id_product != '23600' AND ean13 != '' 26/03/2025 06:26:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002356', date_upd = NOW() WHERE id_product = '23600' 26/03/2025 06:26:45 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CARLO ACUTIS - ST212-AC', description = '' WHERE id_product = '23600' 26/03/2025 06:26:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '23600' 26/03/2025 06:26:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '151', 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 = '23600' 26/03/2025 06:26:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '23600' 26/03/2025 06:26:46 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 = '23600' 26/03/2025 06:26:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23601' , '1' , '' , 'nuovo-prodotto' ) 26/03/2025 06:26:46 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 '23601' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23600' 26/03/2025 06:26:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23601' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23600' 26/03/2025 06:27:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002357' AND id_product != '23601' AND ean13 != '' 26/03/2025 06:27:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002357', date_upd = NOW() WHERE id_product = '23601' 26/03/2025 06:27:08 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CARLO ACUTIS - ST213AC', description = '' WHERE id_product = '23601' 26/03/2025 06:27:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23601' 26/03/2025 06:27:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '151', 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 = '23601' 26/03/2025 06:27:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23601' 26/03/2025 06:27:10 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 = '23601' 26/03/2025 06:27:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23602' , '1' , '' , 'nuovo-prodotto' ) 26/03/2025 06:27:10 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 '23602' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23601' 26/03/2025 06:27:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23602' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23601' 26/03/2025 06:29:37 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '561', document_date = '2025-03-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '164.03', price_tax_excluded = '134.45', date_upd = NOW() WHERE id_document = '96234' 26/03/2025 06:29: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 = '96234' 26/03/2025 06:29:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '96234' 26/03/2025 06:29: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 ( '96234' , '17786' , 'CROCE METALLO CM 10 - FX125-SA' , '1' , '1' , '1' , '4.3700' , '3.5819672131148' , '22' , '10' , '4.80' ) 26/03/2025 06:29: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 ( '96234' , '22531' , 'ICONA LEGNO FOGLIA ORO 25X20 - K204.68' , '1' , '1' , '1' , '17.2200' , '14.114754098361' , '22' , '10' , '18.91' ) 26/03/2025 06:29: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 ( '96234' , '20968' , 'CROCE SAN BENEDETTO - PG598' , '4' , '4' , '1' , '5.9500' , '4.8770491803279' , '22' , '10' , '26.13' ) 26/03/2025 06:29: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 ( '96234' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.5700' , '4.5655737704918' , '22' , '10' , '6.12' ) 26/03/2025 06:29: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 ( '96234' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '1' , '1' , '1' , '11.6900' , '9.5819672131148' , '22' , '10' , '12.84' ) 26/03/2025 06:29: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 ( '96234' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '100' , '100' , '1' , '0.1040' , '0.085245901639344' , '22' , '10' , '11.42' ) 26/03/2025 06:29: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 ( '96234' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '1' , '1' , '8.6000' , '7.0491803278689' , '22' , '10' , '9.44' ) 26/03/2025 06:29: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 ( '96234' , '23555' , 'STATUA SAN CARLO ACUTIS - CM7 - ST210-AC' , '12' , '12' , '1' , '2.4200' , '1.983606557377' , '22' , '10' , '31.89' ) 26/03/2025 06:29: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 ( '96234' , '23557' , 'STATUA S. MICHELE BIANCA - ST203-BSM' , '1' , '1' , '1' , '14.0000' , '11.475409836066' , '22' , '10' , '15.37' ) 26/03/2025 06:29:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96234' , '23599' , 'STATUA SAN CARLO ACUTIS - ST211AC' , '1' , '1' , '1' , '3.68' , '3.016393442623' , '22' , '10' , '4.0406' ) 26/03/2025 06:29:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96234' , '23600' , 'STATUA SAN CARLO ACUTIS - ST212-AC' , '1' , '1' , '1' , '7.88' , '6.4590163934426' , '22' , '10' , '8.6522' ) 26/03/2025 06:29:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96234' , '23601' , 'STATUA SAN CARLO ACUTIS - ST213AC' , '1' , '1' , '1' , '13.13' , '10.762295081967' , '22' , '10' , '14.4167' ) 26/03/2025 06:30:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '96379' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 06:30:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '987', document_date = '2025-03-26', 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 = '19.40', price_tax_excluded = '16.71', date_upd = NOW() WHERE id_document = '96379' 26/03/2025 06:30: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 = '96379' 26/03/2025 06:30:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96379' 26/03/2025 06:30: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 ( '96379' , '23098' , 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 26/03/2025 06:30: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 ( '96379' , '23550' , 'SAN CARLO ACUTIS - 8361' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 26/03/2025 06:30: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 ( '96379' , '22194' , 'PREGHIAMO CON I SANTI MARIA GORETTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 26/03/2025 06:30: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 ( '96379' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 26/03/2025 06:30: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 ( '96379' , '23599' , 'STATUA SAN CARLO ACUTIS - ST211AC' , '1' , '-1' , '1' , '8.6' , '7.0491803278689' , '22' , '0' , '8.60' ) 26/03/2025 07:41:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 07:41: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' , '988' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 26/03/2025 07:41: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 = '96380' 26/03/2025 07:41:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96380' 26/03/2025 07:41: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 ( '96380' , '22782' , 'STOLA - GRECA 2' , '1' , '-1' , '1' , '130.00' , '106.55737704918' , '22' , '0' , '130.00' ) 26/03/2025 07:42:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-26') 26/03/2025 07:42:39 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' , '989' , '2025-03-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 26/03/2025 07:42:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96381' 26/03/2025 07:42:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96381' 26/03/2025 07:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96381' , '10475' , 'TEALIGHTS X 50 ' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' )