28/03/2025 08:27:16 am >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 08:27:16 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 ( '24' , '14' , '2025-03-28' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '300.00' , NOW() , NOW() ) 28/03/2025 08:27:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96398' 28/03/2025 08:27:16 am >> DELETE FROM ps_document_detail WHERE id_document = '96398' 28/03/2025 08:27:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96398' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '100' , '-100' , '4' , '3.00' , '3' , '0' , '0' , '300.00' ) 28/03/2025 09:28:05 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 28/03/2025 09:28:05 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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.60', price_tax_excluded = '144.57', date_upd = NOW() WHERE id_document = '95409' 28/03/2025 09:28:05 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 = '95409' 28/03/2025 09:28:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 28/03/2025 09:28:05 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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 28/03/2025 09:28:05 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 ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/03/2025 09:28: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 ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 28/03/2025 09:28: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 ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/03/2025 09:28: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 ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 28/03/2025 09:28: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 ( '95409' , '' , '26/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 28/03/2025 09:28: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 ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/03/2025 09:28: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 ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/03/2025 09:28:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 09:28:18 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' , '1001' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.77' , NOW() , NOW() ) 28/03/2025 09:28: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 = '96399' 28/03/2025 09:28:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96399' 28/03/2025 09:28: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 ( '96399' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 28/03/2025 09:39:10 am >> SELECT document_num FROM ps_document WHERE document_num = '891' AND id_document != '96264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-17') 28/03/2025 09:39:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '891', document_date = '2025-03-17', 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 = '90.00', price_tax_excluded = '77.38', date_upd = NOW() WHERE id_document = '96264' 28/03/2025 09:39:11 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 = '96264' 28/03/2025 09:39:11 am >> DELETE FROM ps_document_detail WHERE id_document = '96264' 28/03/2025 09:39:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96264' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 28/03/2025 09:39:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96264' , '22463' , 'CAMICE LEGGERO - 020/06' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 28/03/2025 10:00:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002279' AND id_product != '22651' AND ean13 != '' 28/03/2025 10:00:14 am >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002279', date_upd = NOW() WHERE id_product = '22651' 28/03/2025 10:00:14 am >> UPDATE ps_product_lang SET name = 'QUADRETTO S. FAMIGLIA - 25/101-22', description = '' WHERE id_product = '22651' 28/03/2025 10:00:14 am >> UPDATE ps_product SET wholesale_price = '3.50', on_sale = '0', price = '8.19672131147541' WHERE id_product = '22651' 28/03/2025 10:00:14 am >> UPDATE ps_product_shop SET wholesale_price = '3.50', price = '8.19672131147541', 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 = '22651' 28/03/2025 10:00:14 am >> DELETE FROM ps_specific_price WHERE id_product = '22651' 28/03/2025 10:28:57 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 28/03/2025 10:28:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '96095' 28/03/2025 10:28:57 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 = '96095' 28/03/2025 10:28:57 am >> DELETE FROM ps_document_detail WHERE id_document = '96095' 28/03/2025 10:28: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 ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '7' , '-7' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '420.00' ) 28/03/2025 10:28: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '3' , '-3' , '1' , '-40' , '-32.786885245902' , '22' , '0' , '-120.00' ) 28/03/2025 10:28: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 ( '96095' , '0' , 'CERO PASQUALE API 80X 120 da fare disegni' , '4' , '-4' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 28/03/2025 10:30:53 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 28/03/2025 10:30:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '300.00', price_tax_excluded = '300.00', date_upd = NOW() WHERE id_document = '96095' 28/03/2025 10:30:53 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 = '96095' 28/03/2025 10:30:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96095' 28/03/2025 10:30:53 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 ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '7' , '-7' , '0' , '60.0000' , '60' , '' , '0' , '420.00' ) 28/03/2025 10:30:53 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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '3' , '-3' , '0' , '-40.0000' , '-40' , '' , '0' , '-120.00' ) 28/03/2025 10:30:53 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 ( '96095' , '0' , 'CERO PASQUALE API 80X 120 da fare disegni' , '4' , '-4' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/03/2025 11:11:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 11:11:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1002' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 28/03/2025 11:11:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96400' 28/03/2025 11:11:17 am >> DELETE FROM ps_document_detail WHERE id_document = '96400' 28/03/2025 11:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96400' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '89' , '72.950819672131' , '22' , '0' , '89.00' ) 28/03/2025 11:40:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 11:40:40 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' , '1003' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 28/03/2025 11:40:40 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 = '96401' 28/03/2025 11:40:40 am >> DELETE FROM ps_document_detail WHERE id_document = '96401' 28/03/2025 11:40:40 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 ( '96401' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 28/03/2025 11:48:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 11:48:55 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' , '1004' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 28/03/2025 11:48:55 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 = '96402' 28/03/2025 11:48:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96402' 28/03/2025 11:48:55 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 ( '96402' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 28/03/2025 12:12:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 12:12:22 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' , '10/E' , '2025-03-28' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 28/03/2025 12:12:22 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 = '96403' 28/03/2025 12:12:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96403' 28/03/2025 12:12: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 ( '96403' , '13506' , 'SANTO ROSARIO' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 28/03/2025 01:12:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 01:12:00 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' , '1005' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '493.50' , '411.39' , NOW() , NOW() ) 28/03/2025 01:12:00 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 = '96404' 28/03/2025 01:12:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '96404' 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '20437' , 'LUMINO BIANCO 10BTS000' , '192' , '-192' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '96.00' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/03/2025 01:12:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96404' , '19861' , 'FERMAGLIO - B225/CA' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 28/03/2025 02:50:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1004' AND id_document != '96402' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 02:50:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1004', document_date = '2025-03-28', 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 = '96402' 28/03/2025 02:50:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96402' 28/03/2025 02:50:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '96402' 28/03/2025 02:50:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96402' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 28/03/2025 02:55:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048936' AND id_product != '22194' AND ean13 != '' 28/03/2025 02:55:27 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048936', date_upd = NOW() WHERE id_product = '22194' 28/03/2025 02:55:27 pm >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON I SANTI MARIA GORETTI - 8589', description = '' WHERE id_product = '22194' 28/03/2025 02:55:27 pm >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '22194' 28/03/2025 02:55:27 pm >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22194' 28/03/2025 02:55:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22194' 28/03/2025 02:56:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1002' AND id_document != '96400' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 02:56:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1002', document_date = '2025-03-28', 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 = '89.00', price_tax_excluded = '72.95', date_upd = NOW() WHERE id_document = '96400' 28/03/2025 02:56:22 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 = '96400' 28/03/2025 02:56:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96400' 28/03/2025 02:56:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96400' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '89' , '72.950819672131' , '22' , '0' , '89.00' ) 28/03/2025 03:18:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '96398' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 03:18:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '14', document_date = '2025-03-28', 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 = '300.00', price_tax_excluded = '300.00', date_upd = NOW() WHERE id_document = '96398' 28/03/2025 03:18: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 = '96398' 28/03/2025 03:18:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '96398' 28/03/2025 03:18: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 ( '96398' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '100' , '-100' , '4' , '3.0000' , '3' , '0' , '0' , '300.00' ) 28/03/2025 05:44:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 05:44:02 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' , '1006' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.42' , '34.57' , NOW() , NOW() ) 28/03/2025 05:44: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 = '96405' 28/03/2025 05:44:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '96405' 28/03/2025 05:44: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 ( '96405' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/03/2025 05:44: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 ( '96405' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/03/2025 05:44: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 ( '96405' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '0' , '6.00' ) 28/03/2025 05:44: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 ( '96405' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/03/2025 05:44: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 ( '96405' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/03/2025 05:54:55 pm >> DELETE FROM ps_document WHERE id_document = '96151' 28/03/2025 05:54:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96151' 28/03/2025 05:58:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-28') 28/03/2025 05:58:10 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' , '1007' , '2025-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '223.01' , '193.84' , NOW() , NOW() ) 28/03/2025 05:58:10 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 = '96406' 28/03/2025 05:58:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '96406' 28/03/2025 05:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96406' , '23497' , 'ALFA E OMEGA - SANCHEZ' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '5' , '27.55' ) 28/03/2025 05:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96406' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 28/03/2025 05:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96406' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145' , '118.85245901639' , '22' , '0' , '145.00' ) 28/03/2025 05:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96406' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 28/03/2025 05:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96406' , '23567' , 'SEGRETO DI MIO FIGLIO - SALZANO/ACUTIS' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' )