30/03/2026 09:37:00 am >> SELECT document_num FROM ps_document WHERE document_num = '865' AND id_document != '101868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-23') 30/03/2026 09:37:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '865', document_date = '2026-03-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '97.00', price_tax_excluded = '80.79', date_upd = NOW() WHERE id_document = '101868' 30/03/2026 09:37:00 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 = '101868' 30/03/2026 09:37:00 am >> DELETE FROM ps_document_detail WHERE id_document = '101868' 30/03/2026 09:37:00 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 ( '101868' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 30/03/2026 09:37:00 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 ( '101868' , '1710' , 'CARBONCINI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 30/03/2026 09:37:00 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 ( '101868' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 30/03/2026 09:37:00 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 ( '101868' , '24620' , 'CONFEZIONE DECINA S. FRANCESCO - 3169' , '20' , '-20' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '54.00' ) 30/03/2026 09:47:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400325379' AND id_product != '19312' AND ean13 != '' 30/03/2026 09:47:56 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400325379', date_upd = NOW() WHERE id_product = '19312' 30/03/2026 09:47:56 am >> UPDATE ps_product_lang SET name = 'PORTACHIAVE COMUNIONE - 1828/K25', description = '' WHERE id_product = '19312' 30/03/2026 09:47:56 am >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.377049180327869' WHERE id_product = '19312' 30/03/2026 09:47:56 am >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.377049180327869', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19312' 30/03/2026 09:47:56 am >> DELETE FROM ps_specific_price WHERE id_product = '19312' 30/03/2026 09:49:35 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('2026-03-30') 30/03/2026 09:49:35 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 30/03/2026 09:49: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 = '102012' 30/03/2026 09:49:35 am >> DELETE FROM ps_document_detail WHERE id_document = '102012' 30/03/2026 09:49: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 ( '102012' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/03/2026 09:54:14 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('2026-03-30') 30/03/2026 09:54:14 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 30/03/2026 09:54:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102013' 30/03/2026 09:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '102013' 30/03/2026 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102013' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 30/03/2026 10:02:48 am >> SELECT document_num FROM ps_document WHERE document_num = '979' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 10:02:48 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '189.00' , '154.92' , NOW() , NOW() ) 30/03/2026 10:02:48 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 = '102014' 30/03/2026 10:02:48 am >> DELETE FROM ps_document_detail WHERE id_document = '102014' 30/03/2026 10:02:48 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 ( '102014' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '169' , '138.52459016393' , '22' , '0' , '169.00' ) 30/03/2026 10:02:48 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 ( '102014' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '16.65' ) 30/03/2026 10:02:48 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 ( '102014' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.35' , '2.7459016393443' , '22' , '0' , '3.35' ) 30/03/2026 10:06: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('2026-03-30') 30/03/2026 10:06: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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '60.70' , '49.88' , NOW() , NOW() ) 30/03/2026 10:06: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 = '102015' 30/03/2026 10:06:56 am >> DELETE FROM ps_document_detail WHERE id_document = '102015' 30/03/2026 10:06: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 ( '102015' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/03/2026 10:06: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 ( '102015' , '24658' , 'CARTONCINO CROCE RESURREZIONE' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 30/03/2026 10:06: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 ( '102015' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '5' , '-5' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '45.00' ) 30/03/2026 10:22:11 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('2026-03-30') 30/03/2026 10:22:12 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 30/03/2026 10:22:12 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 = '102016' 30/03/2026 10:22:12 am >> DELETE FROM ps_document_detail WHERE id_document = '102016' 30/03/2026 10:22:12 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 ( '102016' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 30/03/2026 10:23:40 am >> SELECT document_num FROM ps_document WHERE document_num = '982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 10:23: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' , '982' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 30/03/2026 10:23: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 = '102017' 30/03/2026 10:23:40 am >> DELETE FROM ps_document_detail WHERE id_document = '102017' 30/03/2026 10:23: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 ( '102017' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 30/03/2026 10:28:42 am >> SELECT document_num FROM ps_document WHERE document_num = '976' AND id_document != '102011' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 30/03/2026 10:28:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '976', document_date = '2026-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 = '15', id_causal = '0', price_tax_included = '53.00', price_tax_excluded = '50.96', date_upd = NOW() WHERE id_document = '102011' 30/03/2026 10:28:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102011' 30/03/2026 10:28:42 am >> DELETE FROM ps_document_detail WHERE id_document = '102011' 30/03/2026 10:28:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102011' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '18.00' ) 30/03/2026 10:28:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102011' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/03/2026 10:37:51 am >> SELECT document_num FROM ps_document WHERE document_num = '983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 10:37: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' , '983' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 30/03/2026 10:37: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 = '102018' 30/03/2026 10:37:51 am >> DELETE FROM ps_document_detail WHERE id_document = '102018' 30/03/2026 10:37: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 ( '102018' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/03/2026 11:42:25 am >> SELECT document_num FROM ps_document WHERE document_num = '984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 11:42:25 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' , '984' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '64.40' , '64.40' , NOW() , NOW() ) 30/03/2026 11:42:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102019' 30/03/2026 11:42:25 am >> DELETE FROM ps_document_detail WHERE id_document = '102019' 30/03/2026 11:42:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102019' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '12' , '-12' , '4' , '4.1' , '4.1' , '0' , '0' , '49.20' ) 30/03/2026 11:42:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102019' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 30/03/2026 11:48:28 am >> SELECT document_num FROM ps_document WHERE document_num = '985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 11:48:28 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' , '985' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '37.75' , '31.80' , NOW() , NOW() ) 30/03/2026 11:48:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102020' 30/03/2026 11:48:28 am >> DELETE FROM ps_document_detail WHERE id_document = '102020' 30/03/2026 11:48:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102020' , '24623' , 'SULLA TUA PAROLA - MAG/GIU 2026' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/03/2026 11:48:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102020' , '7202' , 'ARTICOLI RELIGIOSI' , '20' , '-20' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '8.00' ) 30/03/2026 11:48:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102020' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 30/03/2026 02:22:50 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('2026-03-30') 30/03/2026 02:22:50 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '119.00' , '101.66' , NOW() , NOW() ) 30/03/2026 02:22:50 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 = '102021' 30/03/2026 02:22:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '102021' 30/03/2026 02:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102021' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 30/03/2026 02:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102021' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 30/03/2026 02:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102021' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 30/03/2026 02:43:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '101932' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-03-25') 30/03/2026 02:43:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '16', document_date = '2026-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 = '17', id_causal = '0', price_tax_included = '8269.00', price_tax_excluded = '8269.00', date_upd = NOW() WHERE id_document = '101932' 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101932' 30/03/2026 02:43:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '101932' 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '60' , '-60' , '4' , '8.5000' , '8.5' , '0' , '0' , '510.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '60' , '-60' , '4' , '6.0000' , '6' , '0' , '0' , '360.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24540' , 'DONNE INDISPENSABILI NELLA STORIA DELLA CHIESA' , '34' , '-34' , '4' , '16.0000' , '16' , '0' , '0' , '544.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '100' , '-100' , '4' , '4.5000' , '4.5' , '0' , '0' , '450.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24542' , 'MESSAGGIO DI SAN FRANCESCO DASSISI - POSTER' , '90' , '-90' , '4' , '3.0000' , '3' , '0' , '0' , '270.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '50' , '-50' , '4' , '9.5000' , '9.5' , '0' , '0' , '475.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '15020' , 'PREGARE OGNI GIORNO' , '1200' , '-1200' , '4' , '1.3000' , '1.3' , '0' , '0' , '1560.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '15019' , 'PREGHIAMO CON MARIA' , '1200' , '-1200' , '4' , '1.2000' , '1.2' , '0' , '0' , '1440.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1200' , '-1200' , '4' , '1.2000' , '1.2' , '0' , '0' , '1440.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24886' , 'EGIDIO BULLESI' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '0' , '150.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24887' , 'PREGO PER TE - V. SIRACUSA' , '50' , '-50' , '4' , '5.0000' , '5' , '0' , '0' , '250.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24486' , 'SOFFERENZE DI CRISTO - A. RAGONE' , '20' , '-20' , '4' , '9.00' , '9' , '0' , '0' , '180.00' ) 30/03/2026 02:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101932' , '24882' , 'NON LASCIATEVI RUBARE LA SPERANZA - V. SIRACUSA' , '80' , '-80' , '4' , '8.00' , '8' , '0' , '0' , '640.00' ) 30/03/2026 03:25:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4080' 30/03/2026 03:25:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4080' , '10' , '170' , 'PADRI SOMASCHI - VILLA SANTA MARIA' , 'PERSICO' , 'P. WALTER' , 'VIA SAN GEROLAMO 18' , '' , '23808' , 'VERCURAGO ' , '' , '' , '' , '' , '' , NOW() , NOW() ) 30/03/2026 03:25:23 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4080' 30/03/2026 03:26:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 03:26:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '11/E' , '2026-03-30' , 'E' , '4332' , '0' , '4679743' , 'PIAZZA XXV APRILE 2 20121 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2500.00' , '2500.00' , NOW() , NOW() ) 30/03/2026 03:26:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102022' 30/03/2026 03:26:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '102022' 30/03/2026 03:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102022' , '24886' , 'EGIDIO BULLESI' , '500' , '-500' , '4' , '5.00' , '5' , '0' , '0' , '2500.00' ) 30/03/2026 03:44:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '102022' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 03:44:02 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/E', document_date = '2026-03-30', document_letter = 'E', id_customer = '4332', id_supplier = '', id_address = '4679743', address1 = 'PIAZZA XXV APRILE 2 20121 MILANO', 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 = '1250.00', price_tax_excluded = '1250.00', date_upd = NOW() WHERE id_document = '102022' 30/03/2026 03: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 = '102022' 30/03/2026 03:44:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '102022' 30/03/2026 03: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 ( '102022' , '24886' , 'EGIDIO BULLESI' , '500' , '-500' , '4' , '5.0000' , '5' , '0' , '50' , '1250.00' ) 30/03/2026 03:50:27 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('2026-03-30') 30/03/2026 03:50:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '987' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 30/03/2026 03:50:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102023' 30/03/2026 03:50:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '102023' 30/03/2026 03:50:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102023' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '-1' , '1' , '47.00' , '38.524590163934' , '22' , '0' , '47.00' ) 30/03/2026 03:50:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102023' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 30/03/2026 03:50:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102023' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 30/03/2026 03:50:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102023' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 30/03/2026 04:15:57 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('2026-03-30') 30/03/2026 04:15:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '988' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 30/03/2026 04:15:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102024' 30/03/2026 04:15:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '102024' 30/03/2026 04:15:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102024' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 30/03/2026 04:15:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102024' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 30/03/2026 04:15:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102024' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 30/03/2026 04:32:48 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('2026-03-30') 30/03/2026 04:32:48 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' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 30/03/2026 04:32: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 = '102025' 30/03/2026 04:32:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '102025' 30/03/2026 04:32: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 ( '102025' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 30/03/2026 05:17:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 05:17:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '990' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.00' , '28.00' , NOW() , NOW() ) 30/03/2026 05:17: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 = '102026' 30/03/2026 05:17:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '102026' 30/03/2026 05:17: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 ( '102026' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '13' , '13' , '0' , '0' , '26.00' ) 30/03/2026 05:17: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 ( '102026' , '24517' , 'PIU FORTE DELLA MORTE - VIA CRUCIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/03/2026 05:56:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002403' AND id_product != '23914' AND ean13 != '' 30/03/2026 05:56:44 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002403', date_upd = NOW() WHERE id_product = '23914' 30/03/2026 05:56:44 pm >> UPDATE ps_product_lang SET name = 'DECINA ROSARIO - 142/6-D', description = '' WHERE id_product = '23914' 30/03/2026 05:56:44 pm >> UPDATE ps_product SET wholesale_price = '0.40', on_sale = '0', price = '1.1475409836065573' WHERE id_product = '23914' 30/03/2026 05:56:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.40', price = '1.1475409836065573', 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 = '23914' 30/03/2026 05:56:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '23914' 30/03/2026 06:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 06:06:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '991' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 30/03/2026 06:06:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102027' 30/03/2026 06:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '102027' 30/03/2026 06:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102027' , '21175' , 'BRACCIALE ARG. MM6 - 1452/CAV' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 30/03/2026 06:14:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 06:14:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '992' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '12.50' , '12.02' , NOW() , NOW() ) 30/03/2026 06:14:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102028' 30/03/2026 06:14:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '102028' 30/03/2026 06:14:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102028' , '24661' , 'OSTIA PANE ROSSA MM 74 X 1,4 - OPR20/74' , '5' , '-5' , '3' , '2.50' , '2.4038461538462' , '4' , '0' , '12.50' ) 30/03/2026 06:23:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 06:23:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '993' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '9.00' , '7.92' , NOW() , NOW() ) 30/03/2026 06:23:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102029' 30/03/2026 06:23:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '102029' 30/03/2026 06:23:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102029' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 30/03/2026 06:23:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102029' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 30/03/2026 06:30:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 06:30:56 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' , '994' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 30/03/2026 06:30:56 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 = '102030' 30/03/2026 06:30:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '102030' 30/03/2026 06:30:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102030' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 30/03/2026 07:06:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 07:06:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '995' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '146.93' , '122.44' , NOW() , NOW() ) 30/03/2026 07:06:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102031' 30/03/2026 07:06:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '102031' 30/03/2026 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '24399' , 'AMEN - APR 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/03/2026 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '24593' , 'AMEN - MAG. 2026' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/03/2026 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '24592' , 'AMEN - GIU. 2026' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/03/2026 07:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 30/03/2026 07:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 30/03/2026 07:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102031' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 30/03/2026 07:07:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 07:07: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' , '996' , '2026-03-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 30/03/2026 07:07: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 = '102032' 30/03/2026 07:07:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '102032' 30/03/2026 07:07: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 ( '102032' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 30/03/2026 07:37:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4332' 30/03/2026 07:37:52 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4332' , '10' , '180' , 'PROVINCIA LOMBARDA DELL’ORDINE DEI CHIERICI REGOLARI SOMASCHI' , '' , '' , 'PIAZZA XXV APRILE 2' , '' , '20121' , 'MILANO' , '' , '' , '' , '' , '03145110155' , NOW() , NOW() ) 30/03/2026 07:37:52 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4332' 30/03/2026 07:38:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '102022' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-30') 30/03/2026 07:38:07 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/E', document_date = '2026-03-30', document_letter = 'E', id_customer = '4332', id_supplier = '0', id_address = '4679745', address1 = 'PIAZZA XXV APRILE 2 20121 MILANO', 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 = '1250.00', price_tax_excluded = '1250.00', date_upd = NOW() WHERE id_document = '102022' 30/03/2026 07:38:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102022' 30/03/2026 07:38:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '102022' 30/03/2026 07:38:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102022' , '24886' , 'EGIDIO BULLESI' , '500' , '-500' , '4' , '5.0000' , '5' , '0' , '50' , '1250.00' ) 30/03/2026 07:41:24 pm >> DELETE FROM ps_document WHERE id_document = '101925' 30/03/2026 07:41:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '101925'