28/03/2026 09:06:29 am >> SELECT document_num FROM ps_document WHERE document_num = '958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 09:06:29 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' , '958' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '119.90' , '98.28' , NOW() , NOW() ) 28/03/2026 09:06:29 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 = '101992' 28/03/2026 09:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '101992' 28/03/2026 09:06:29 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 ( '101992' , '24702' , 'BROCCA E PIATTINO - 32-794 / 32-789' , '1' , '-1' , '1' , '119.90' , '98.27868852459' , '22' , '0' , '119.90' ) 28/03/2026 09:40:38 am >> SELECT document_num FROM ps_document WHERE document_num = '959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 09:40:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '959' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '16.70' , '14.21' , NOW() , NOW() ) 28/03/2026 09:40:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101993' 28/03/2026 09:40:38 am >> DELETE FROM ps_document_detail WHERE id_document = '101993' 28/03/2026 09:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101993' , '1710' , 'CARBONCINI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/03/2026 09:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101993' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.70' , '3.5576923076923' , '4' , '0' , '3.70' ) 28/03/2026 10:16:55 am >> SELECT document_num FROM ps_document WHERE document_num = '960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:16: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' , '960' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 28/03/2026 10:16: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 = '101994' 28/03/2026 10:16:55 am >> DELETE FROM ps_document_detail WHERE id_document = '101994' 28/03/2026 10:16: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 ( '101994' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 28/03/2026 10:16: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 ( '101994' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/03/2026 10:24:14 am >> SELECT document_num FROM ps_document WHERE document_num = '961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:24: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' , '961' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 28/03/2026 10:24: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 = '101995' 28/03/2026 10:24:14 am >> DELETE FROM ps_document_detail WHERE id_document = '101995' 28/03/2026 10:24: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 ( '101995' , '23924' , 'COPRILEGGIO - 331/TP' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 28/03/2026 10:24: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 ( '101995' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 28/03/2026 10:25:07 am >> SELECT document_num FROM ps_document WHERE document_num = '962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:25:07 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' , '962' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 28/03/2026 10:25:07 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 = '101996' 28/03/2026 10:25:07 am >> DELETE FROM ps_document_detail WHERE id_document = '101996' 28/03/2026 10:25:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101996' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 28/03/2026 10:35:09 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:35:09 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' , '41/A' , '2026-03-28' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '282.00' , '231.15' , NOW() , NOW() ) 28/03/2026 10:35: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 = '101997' 28/03/2026 10:35:09 am >> DELETE FROM ps_document_detail WHERE id_document = '101997' 28/03/2026 10:35: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 ( '101997' , '6014' , 'LUMINO BIANCO - 10B' , '384' , '-384' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '192.00' ) 28/03/2026 10:35: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 ( '101997' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 28/03/2026 10:38:02 am >> SELECT document_num FROM ps_document WHERE document_num = '963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:38: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' , '963' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 28/03/2026 10:38: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 = '101998' 28/03/2026 10:38:02 am >> DELETE FROM ps_document_detail WHERE id_document = '101998' 28/03/2026 10:38: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 ( '101998' , '3262' , 'CUSTODIA PELLE - 104' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 28/03/2026 10:47:33 am >> SELECT document_num FROM ps_document WHERE document_num = '964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:47:33 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' , '964' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '22.00' , '21.15' , NOW() , NOW() ) 28/03/2026 10:47:33 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 = '101999' 28/03/2026 10:47:33 am >> DELETE FROM ps_document_detail WHERE id_document = '101999' 28/03/2026 10:47:33 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 ( '101999' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 28/03/2026 10:47:33 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 ( '101999' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 28/03/2026 10:47:33 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 ( '101999' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/03/2026 10:55:42 am >> SELECT document_num FROM ps_document WHERE document_num = '965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 10:55:42 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' , '965' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '9.03' , '9.03' , NOW() , NOW() ) 28/03/2026 10:55: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 = '102000' 28/03/2026 10:55:42 am >> DELETE FROM ps_document_detail WHERE id_document = '102000' 28/03/2026 10:55: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 ( '102000' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 28/03/2026 11:04:37 am >> SELECT document_num FROM ps_document WHERE document_num = '966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:04:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '966' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '25.90' , '23.78' , NOW() , NOW() ) 28/03/2026 11:04: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 = '102001' 28/03/2026 11:04:37 am >> DELETE FROM ps_document_detail WHERE id_document = '102001' 28/03/2026 11:04: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 ( '102001' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/03/2026 11:04: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 ( '102001' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 28/03/2026 11:04: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 ( '102001' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 28/03/2026 11:07:19 am >> SELECT document_num FROM ps_document WHERE document_num = '967' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:07:19 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' , '967' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '45.90' , '37.62' , NOW() , NOW() ) 28/03/2026 11:07:19 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 = '102002' 28/03/2026 11:07:19 am >> DELETE FROM ps_document_detail WHERE id_document = '102002' 28/03/2026 11:07:19 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 ( '102002' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 28/03/2026 11:07:19 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 ( '102002' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 28/03/2026 11:07:58 am >> SELECT document_num FROM ps_document WHERE document_num = '968' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:07:58 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' , '968' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 28/03/2026 11:07:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102003' 28/03/2026 11:07:58 am >> DELETE FROM ps_document_detail WHERE id_document = '102003' 28/03/2026 11:07:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102003' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 28/03/2026 11:08:16 am >> SELECT document_num FROM ps_document WHERE document_num = '969' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:08: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 ( '11' , '969' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 28/03/2026 11:08: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 = '102004' 28/03/2026 11:08:16 am >> DELETE FROM ps_document_detail WHERE id_document = '102004' 28/03/2026 11:08: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 ( '102004' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 28/03/2026 11:08:37 am >> SELECT document_num FROM ps_document WHERE document_num = '970' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:08:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '970' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 28/03/2026 11:08: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 = '102005' 28/03/2026 11:08:37 am >> DELETE FROM ps_document_detail WHERE id_document = '102005' 28/03/2026 11:08: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 ( '102005' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 28/03/2026 11:11:29 am >> SELECT document_num FROM ps_document WHERE document_num = '971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:11:29 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' , '971' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.00' , '23.67' , NOW() , NOW() ) 28/03/2026 11:11:29 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 = '102006' 28/03/2026 11:11:29 am >> DELETE FROM ps_document_detail WHERE id_document = '102006' 28/03/2026 11:11:29 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 ( '102006' , '1710' , 'CARBONCINI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/03/2026 11:11:29 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 ( '102006' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 28/03/2026 11:11:29 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 ( '102006' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 28/03/2026 11:27:18 am >> SELECT document_num FROM ps_document WHERE document_num = '972' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:27: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' , '972' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 28/03/2026 11:27: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 = '102007' 28/03/2026 11:27:18 am >> DELETE FROM ps_document_detail WHERE id_document = '102007' 28/03/2026 11:27: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 ( '102007' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 28/03/2026 11:28:36 am >> SELECT document_num FROM ps_document WHERE document_num = '973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:28:36 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' , '973' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '2' , '0' , '18.40' , '15.08' , NOW() , NOW() ) 28/03/2026 11:28: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 = '102008' 28/03/2026 11:28:36 am >> DELETE FROM ps_document_detail WHERE id_document = '102008' 28/03/2026 11:28:36 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 ( '102008' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 28/03/2026 11:28:36 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 ( '102008' , '10197' , 'STAMPE IN CARTA 40X50 - OGGETTI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/03/2026 11:28:36 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 ( '102008' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 28/03/2026 11:28: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 ( '102008' , '24866' , 'FRAGRANZA MIRRA VARIE PROFUMAZIONI 8ML' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 28/03/2026 11:29:56 am >> SELECT document_num FROM ps_document WHERE document_num = '974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 11:29: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' , '974' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '20.00' , '19.28' , NOW() , NOW() ) 28/03/2026 11:29: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 = '102009' 28/03/2026 11:29:56 am >> DELETE FROM ps_document_detail WHERE id_document = '102009' 28/03/2026 11:29: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 ( '102009' , '23778' , 'BRACCIALE DECINA - BD007' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 28/03/2026 11:29: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 ( '102009' , '20872' , 'CON TE GESU - VIA CRUCIS' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/03/2026 11:29: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 ( '102009' , '11099' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 28/03/2026 11:29: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 ( '102009' , '22451' , 'STORIA DI SANTA CHIARA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 28/03/2026 11:29: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 ( '102009' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '8.6' , '8.6' , '0' , '0' , '8.60' ) 28/03/2026 11:43:14 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('2026-03-28') 28/03/2026 11:43:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '975' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/03/2026 11:43:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102010' 28/03/2026 11:43:15 am >> DELETE FROM ps_document_detail WHERE id_document = '102010' 28/03/2026 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102010' , '24623' , 'SULLA TUA PAROLA - MAG/GIU 2026' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/03/2026 12:00:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '101997' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 12:00:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '41/A', document_date = '2026-03-28', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', 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 = '377.00', price_tax_excluded = '326.15', date_upd = NOW() WHERE id_document = '101997' 28/03/2026 12:00:25 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 = '101997' 28/03/2026 12:00:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '101997' 28/03/2026 12:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101997' , '6014' , 'LUMINO BIANCO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 28/03/2026 12:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101997' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '12' , '-12' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '90.00' ) 28/03/2026 12:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101997' , '24887' , 'PREGO PER TE - V. SIRACUSA' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '0' , '50.00' ) 28/03/2026 12:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101997' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '10' , '-10' , '4' , '4.50' , '4.5' , '0' , '0' , '45.00' ) 28/03/2026 12:09:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-28') 28/03/2026 12:09: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' , '976' , '2026-03-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '53.00' , '50.96' , NOW() , NOW() ) 28/03/2026 12:09: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 = '102011' 28/03/2026 12:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '102011' 28/03/2026 12:09: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 ( '102011' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '53' , '50.961538461538' , '4' , '0' , '53.00' ) 28/03/2026 12:12:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '896' AND id_document != '101903' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-24') 28/03/2026 12:12:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '896', document_date = '2026-03-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 = '15', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '101903' 28/03/2026 12:12: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 = '101903' 28/03/2026 12:12:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '101903' 28/03/2026 12:12: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 ( '101903' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 28/03/2026 12:12: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 ( '101903' , '24897' , 'MESSA MEDITAZIONE - MAG/GIU 26' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/03/2026 12:48:01 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'UvL1ksSF9Ke5oZMQ' , NOW() , NOW() ) 28/03/2026 12:48:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4332' , '1' ) 28/03/2026 12:48:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4332' , '2' ) 28/03/2026 12:48:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4332' , '3' ) 28/03/2026 12:49:56 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4332' 28/03/2026 12:49:56 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() ) 28/03/2026 12:49:56 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4332'