23/06/2025 09:09:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 09:09:45 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' , '2208' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 23/06/2025 09:09:45 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 = '97801' 23/06/2025 09:09:45 am >> DELETE FROM ps_document_detail WHERE id_document = '97801' 23/06/2025 09:09:45 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 ( '97801' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 23/06/2025 09:12:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2208' AND id_document != '97801' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 09:12:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2208', document_date = '2025-06-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 = '0', id_causal = '0', price_tax_included = '160.00', price_tax_excluded = '131.15', date_upd = NOW() WHERE id_document = '97801' 23/06/2025 09:12:23 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 = '97801' 23/06/2025 09:12:23 am >> DELETE FROM ps_document_detail WHERE id_document = '97801' 23/06/2025 09:12:23 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 ( '97801' , '17991' , 'STOLA LINO/POL GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '160.00' , '131.14754098361' , '22' , '0' , '160.00' ) 23/06/2025 09:45:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 09:45:01 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' , '2209' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.60' , '60.44' , NOW() , NOW() ) 23/06/2025 09:45:01 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 = '97802' 23/06/2025 09:45:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97802' 23/06/2025 09:45:01 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 ( '97802' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434TPMA' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 23/06/2025 09:45:01 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 ( '97802' , '23781' , 'CATENINA CON CROCE STRASS - NZ001' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/06/2025 09:45:01 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 ( '97802' , '5823' , 'LIBRO DORO' , '1' , '-1' , '4' , '0.60' , '0.6' , '0' , '0' , '0.60' ) 23/06/2025 10:21:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 10:21:34 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' , '2210' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 23/06/2025 10:21:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97803' 23/06/2025 10:21:34 am >> DELETE FROM ps_document_detail WHERE id_document = '97803' 23/06/2025 10:21:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97803' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 23/06/2025 10:57:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 10:57: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' , '2211' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 23/06/2025 10:57: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 = '97804' 23/06/2025 10:57:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97804' 23/06/2025 10:57: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 ( '97804' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 23/06/2025 11:27:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 11:27: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' , '2212' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.90' , '163.85' , NOW() , NOW() ) 23/06/2025 11:27: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 = '97805' 23/06/2025 11:27:33 am >> DELETE FROM ps_document_detail WHERE id_document = '97805' 23/06/2025 11:27: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 ( '97805' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.00' , '33.606557377049' , '22' , '0' , '41.00' ) 23/06/2025 11:27: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 ( '97805' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '72.00' ) 23/06/2025 11:27: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 ( '97805' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 23/06/2025 11:27: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 ( '97805' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 23/06/2025 11:31:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 11:31:32 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' , '2213' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.75' , '7.75' , NOW() , NOW() ) 23/06/2025 11:31:32 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 = '97806' 23/06/2025 11:31:32 am >> DELETE FROM ps_document_detail WHERE id_document = '97806' 23/06/2025 11:31:32 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 ( '97806' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/06/2025 11:31:32 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 ( '97806' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 23/06/2025 11:52:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 11:52:05 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' , '2214' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 23/06/2025 11:52:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97807' 23/06/2025 11:52:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97807' 23/06/2025 11:52:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97807' , '23740' , 'SIGNORE CI TIENE PER MANO - BENEDETTO XVI' , '1' , '-1' , '4' , '21.9' , '21.9' , '0' , '0' , '21.90' ) 23/06/2025 11:52:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97807' , '23739' , 'GIUSEPPE, IL FRATELLO RITROVATO - C. DI CAVE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/06/2025 11:56:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 11:56:01 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' , '2215' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 23/06/2025 11:56:01 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 = '97808' 23/06/2025 11:56:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97808' 23/06/2025 11:56:01 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 ( '97808' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 23/06/2025 12:01:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 12:01: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' , '2216' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.30' , '28.14' , NOW() , NOW() ) 23/06/2025 12:01: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 = '97809' 23/06/2025 12:01:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '97809' 23/06/2025 12:01: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 ( '97809' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/06/2025 12:01: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 ( '97809' , '14940' , 'SAN CHARBEL - 8850' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 23/06/2025 12:01: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 ( '97809' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.3' , '11.3' , '0' , '0' , '11.30' ) 23/06/2025 12:18:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 12:18:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2217' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '12.40' , NOW() , NOW() ) 23/06/2025 12:18:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97810' 23/06/2025 12:18:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97810' 23/06/2025 12:18:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97810' , '23807' , 'CALENDARIO LITURGICO 2026' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 23/06/2025 12:18:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97810' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 23/06/2025 12:48:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '97808' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 12:48:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2215', document_date = '2025-06-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 = '0', id_causal = '0', price_tax_included = '54.00', price_tax_excluded = '44.26', date_upd = NOW() WHERE id_document = '97808' 23/06/2025 12:48:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97808' 23/06/2025 12:48:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '97808' 23/06/2025 12:48:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97808' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 23/06/2025 01:05:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 01:05:24 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' , '2218' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.90' , '39.28' , NOW() , NOW() ) 23/06/2025 01:05:24 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 = '97811' 23/06/2025 01:05:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '97811' 23/06/2025 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97811' , '23274' , 'FEDE E UN VIAGGIO - PAPA FRANCESCO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 23/06/2025 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97811' , '18130' , 'TAU GRANDE CM 4 - T9' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '8.00' ) 23/06/2025 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97811' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 23/06/2025 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97811' , '23123' , 'STIMMATE DI SAN FRANCESCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/06/2025 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97811' , '18129' , 'TAU COLORATO - T56' , '8' , '-8' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '9.60' ) 23/06/2025 03:50:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '524' , '2025-06-20' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '329.40' , '270.00' , NOW() , NOW() ) 23/06/2025 03:50:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97812' 23/06/2025 03:50:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '97812' 23/06/2025 03:50:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97812' , '23549' , 'STOLA CROCE - 860' , '2' , '2' , '1' , '56' , '45.901639344262' , '22' , '0' , '136.6400' ) 23/06/2025 03:50:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23549' AND id_supplier = '163' 23/06/2025 03:50:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23549' , '163' , '1' ) 23/06/2025 03:50:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97812' , '22464' , 'CASULA LEGGERA - 1212' , '5' , '5' , '1' , '28' , '22.950819672131' , '22' , '0' , '170.8000' ) 23/06/2025 03:50:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22464' AND id_supplier = '163' 23/06/2025 03:50:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22464' , '163' , '1' ) 23/06/2025 03:55:44 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 ( '31' , '9586/00/2025' , '2025-06-19' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '239.70' , '239.70' , NOW() , NOW() ) 23/06/2025 03:55:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97813' 23/06/2025 03:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97813' 23/06/2025 03:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '30' , '30' , '4' , '5.00' , '5' , '0' , '40' , '90.0000' ) 23/06/2025 03:55:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23689' AND id_supplier = '38' 23/06/2025 03:55:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23689' , '38' , '1' ) 23/06/2025 03:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '40' , '40' , '4' , '5.00' , '5' , '0' , '40' , '120.0000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23714' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23714' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4185' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4185' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '22025' , 'GUARDARE A GESU CON LO SGUARDO DI MARIA - 8582' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22025' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22025' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '7436' , 'PANE DI SANTANTONIO' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '40' , '0.9000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7436' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7436' , '38' , '1' ) 23/06/2025 03:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97813' , '23649' , 'APPARECCHIO ALLA MORTE - 8975 ' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 23/06/2025 03:55:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23649' AND id_supplier = '38' 23/06/2025 03:55:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23649' , '38' , '1' ) 23/06/2025 03:58:28 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Jfatbqx94Z5ilWv2' , NOW() , NOW() ) 23/06/2025 03:58:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4218' , '1' ) 23/06/2025 03:58:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4218' , '2' ) 23/06/2025 03:58:28 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4218' , '3' ) 23/06/2025 04:00:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4218' 23/06/2025 04:00:05 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 ( '4218' , '10' , '141' , '' , 'SCHIRRU' , 'IRENEO' , 'VIA SAN LUIGI 4' , '' , '09047' , 'SELARGIUS' , '' , '' , '3406028707' , '' , '' , NOW() , NOW() ) 23/06/2025 04:00:06 pm >> UPDATE ps_customer SET email = 'ireneo.schirru19@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4218' 23/06/2025 04:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 04:00: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 ( '21' , '81' , '2025-06-23' , '' , '4218' , '0' , '4679515' , 'VIA SAN LUIGI 4 09047 SELARGIUS' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 23/06/2025 04:00: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 = '97814' 23/06/2025 04:00:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97814' 23/06/2025 04:00: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 ( '97814' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/06/2025 04:00: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 ( '97814' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/06/2025 04:01:24 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4218' 23/06/2025 04:01:24 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 ( '4218' , '10' , '141' , '' , 'SCHIRRU' , 'IRENEO' , 'VIA SAN LUIGI 4' , '' , '09047' , 'SELARGIUS' , '' , '' , '3406028707' , '' , '' , NOW() , NOW() ) 23/06/2025 04:01:24 pm >> UPDATE ps_customer SET email = 'ireneo.schirru19@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4218' 23/06/2025 04:51:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 04:51:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2219' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 23/06/2025 04:51:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97815' 23/06/2025 04:51:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '97815' 23/06/2025 04:51:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97815' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/06/2025 05:09:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '82/2025' , '2025-06-19' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '244.00' , '200.00' , NOW() , NOW() ) 23/06/2025 05:09:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97816' 23/06/2025 05:09:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97816' 23/06/2025 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97816' , '19190' , 'STOLA MARIANA - 7335' , '1' , '1' , '1' , '75' , '61.475409836066' , '22' , '0' , '91.5000' ) 23/06/2025 05:09:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126' 23/06/2025 05:09:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' ) 23/06/2025 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97816' , '16955' , 'STOLA MARIANA - 8005' , '1' , '1' , '1' , '65' , '53.27868852459' , '22' , '0' , '79.3000' ) 23/06/2025 05:09:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126' 23/06/2025 05:09:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' ) 23/06/2025 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97816' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 23/06/2025 05:09:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126' 23/06/2025 05:09:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' ) 23/06/2025 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97816' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '0' , '48.8000' ) 23/06/2025 05:09:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '126' 23/06/2025 05:09:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '126' , '1' ) 23/06/2025 05:36:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 05:36: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' , '2220' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 23/06/2025 05:36: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 = '97817' 23/06/2025 05:36:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97817' 23/06/2025 05:36: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 ( '97817' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/06/2025 05:39:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 05:39: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' , '2221' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 23/06/2025 05:39: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 = '97818' 23/06/2025 05:39:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97818' 23/06/2025 05:39: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 ( '97818' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '36.5' , '29.918032786885' , '22' , '0' , '36.50' ) 23/06/2025 05:43:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001821' AND id_product != '18838' AND ean13 != '' 23/06/2025 05:43:59 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '001821', date_upd = NOW() WHERE id_product = '18838' 23/06/2025 05:43:59 pm >> UPDATE ps_product_lang SET name = 'CAPOCULLA ', description = '' WHERE id_product = '18838' 23/06/2025 05:43:59 pm >> UPDATE ps_product SET wholesale_price = '8.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '18838' 23/06/2025 05:43:59 pm >> UPDATE ps_product_shop SET wholesale_price = '8.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '120', 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 = '18838' 23/06/2025 05:43:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '18838' 23/06/2025 05:44: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 ( '31' , 'FT1/3174' , '2025-06-23' , '3174' , '199' , '0' , '199' , 'VIA ACQUASANTA, 3 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '48.80' , '40.00' , NOW() , NOW() ) 23/06/2025 05:44: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 = '97819' 23/06/2025 05:44:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97819' 23/06/2025 05:44: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 ( '97819' , '18840' , 'CAPOCULLA ' , '2' , '2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '24.4000' ) 23/06/2025 05:44:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97819' , '18838' , 'CAPOCULLA ' , '1' , '1' , '1' , '10.5' , '8.6065573770492' , '22' , '0' , '12.8100' ) 23/06/2025 05:44:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97819' , '20507' , 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL' , '1' , '1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '11.5900' ) 23/06/2025 05:45:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2220' AND id_document != '97817' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 05:45:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2220', document_date = '2025-06-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 = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '97817' 23/06/2025 05:45:55 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 = '97817' 23/06/2025 05:45:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97817' 23/06/2025 05:45:55 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 ( '97817' , '18840' , 'CAPOCULLA ' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 23/06/2025 05:45:55 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 ( '97817' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 23/06/2025 05:45:55 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 ( '97817' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 23/06/2025 05:48:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 05:48: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' , '2222' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.50' , '114.02' , NOW() , NOW() ) 23/06/2025 05:48: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 = '97820' 23/06/2025 05:48:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97820' 23/06/2025 05:48: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 ( '97820' , '23549' , 'STOLA CROCE - 860' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 23/06/2025 05:48: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 ( '97820' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/06/2025 05:49:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2141' AND id_document != '97726' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-16') 23/06/2025 05:49:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2141', document_date = '2025-06-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '97726' 23/06/2025 05:49:36 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 = '97726' 23/06/2025 05:49:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '97726' 23/06/2025 05:49:36 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 ( '97726' , '23549' , 'STOLA CROCE - 860' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 23/06/2025 05:59:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2216' AND id_document != '97809' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 05:59:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2216', document_date = '2025-06-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 = '0', id_causal = '0', price_tax_included = '30.30', price_tax_excluded = '28.14', date_upd = NOW() WHERE id_document = '97809' 23/06/2025 05:59: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 = '97809' 23/06/2025 05:59:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '97809' 23/06/2025 05:59: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 ( '97809' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/06/2025 05:59: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 ( '97809' , '14940' , 'SAN CHARBEL - 8850' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 23/06/2025 05:59: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 ( '97809' , '23642' , 'LUCE SUL MIO CAMMINO - F. CRISTOFARO' , '1' , '-1' , '4' , '11.3' , '11.3' , '0' , '0' , '11.30' ) 23/06/2025 06:00:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1824' AND id_document != '97362' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 23/06/2025 06:00:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1824', document_date = '2025-05-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '158.00', price_tax_excluded = '129.51', date_upd = NOW() WHERE id_document = '97362' 23/06/2025 06:00:54 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 = '97362' 23/06/2025 06:00:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97362' 23/06/2025 06:00:54 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 ( '97362' , '920' , 'BALZA RICAMATA CM 9,6 - BIANCA - KOM/030 - OGGETTI' , '2' , '-2' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '33.00' ) 23/06/2025 06:00:54 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 ( '97362' , '19190' , 'STOLA MARIANA - 7335' , '1' , '-1' , '1' , '125' , '102.45901639344' , '22' , '0' , '125.00' ) 23/06/2025 06:16:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 06:16: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' , '2223' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 23/06/2025 06:16: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 = '97821' 23/06/2025 06:16:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97821' 23/06/2025 06:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97821' , '5107' , 'SAN GIOVANNI BATTISTA - 63' , '2' , '-2' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '7.20' ) 23/06/2025 06:22:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 06:22:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2224' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 23/06/2025 06:22:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97822' 23/06/2025 06:22:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97822' 23/06/2025 06:22:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97822' , '23642' , 'LUCE SUL MIO CAMMINO - F. CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 23/06/2025 06:49:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-23') 23/06/2025 06:49:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2225' , '2025-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 23/06/2025 06:49:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97823' 23/06/2025 06:49:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '97823' 23/06/2025 06:49:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97823' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' )