24/12/2025 09:06:04 am >> SELECT document_num FROM ps_document WHERE document_num = '4399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 09:06:04 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' , '4399' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '12.11' , NOW() , NOW() ) 24/12/2025 09:06:04 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 = '100682' 24/12/2025 09:06:04 am >> DELETE FROM ps_document_detail WHERE id_document = '100682' 24/12/2025 09:06:04 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 ( '100682' , '24180' , 'DILEXI TE' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 24/12/2025 09:06: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 ( '100682' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 24/12/2025 09:06: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 ( '100682' , '22500' , 'DECINA LEGNO' , '1' , '-1' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '1.60' ) 24/12/2025 09:57:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 09:57:49 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' , '4400' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '14.50' , NOW() , NOW() ) 24/12/2025 09:57:49 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 = '100683' 24/12/2025 09:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '100683' 24/12/2025 09:57:49 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 ( '100683' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/12/2025 09:57:49 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 ( '100683' , '23892' , 'CROCE S. BENEDETTO - 730' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 24/12/2025 09:57:49 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 ( '100683' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 24/12/2025 09:57:49 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 ( '100683' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 24/12/2025 09:57:49 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 ( '100683' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '2' , '-2' , '4' , '1.40' , '1.4' , '0' , '0' , '2.80' ) 24/12/2025 10:04:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10: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' , '4401' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 24/12/2025 10: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 = '100684' 24/12/2025 10:04:37 am >> DELETE FROM ps_document_detail WHERE id_document = '100684' 24/12/2025 10: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 ( '100684' , '23100' , 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 24/12/2025 10:04: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 ( '100684' , '19994' , 'MEDAGLIA SAN PIO ARG - RA641' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 24/12/2025 10:04: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 ( '100684' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 24/12/2025 10:27:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10:27:10 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' , '4402' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 24/12/2025 10:27:10 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 = '100685' 24/12/2025 10:27:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100685' 24/12/2025 10:27:10 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 ( '100685' , '22463' , 'CAMICE LEGGERO - 020/06' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 24/12/2025 10:32:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10:32: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' , '4403' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.36' , '31.36' , NOW() , NOW() ) 24/12/2025 10:32: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 = '100686' 24/12/2025 10:32:34 am >> DELETE FROM ps_document_detail WHERE id_document = '100686' 24/12/2025 10:32: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 ( '100686' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 24/12/2025 10:32: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 ( '100686' , '24422' , 'DOMANDA E IL PERDONO - L.M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 24/12/2025 10:32: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 ( '100686' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '2' , '-2' , '4' , '4.50' , '4.5' , '0' , '5' , '8.56' ) 24/12/2025 10:35:50 am >> SELECT document_num FROM ps_document WHERE document_num = '4404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10:35:50 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' , '4404' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 24/12/2025 10:35:50 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 = '100687' 24/12/2025 10:35:50 am >> DELETE FROM ps_document_detail WHERE id_document = '100687' 24/12/2025 10:35:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100687' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 24/12/2025 10:42:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10:42:10 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' , '4405' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 24/12/2025 10:42:10 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 = '100688' 24/12/2025 10:42:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100688' 24/12/2025 10:42:10 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 ( '100688' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 24/12/2025 10:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 10:53:53 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' , '4406' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 24/12/2025 10:53:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100689' 24/12/2025 10:53:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100689' 24/12/2025 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100689' , '21083' , 'BRACCIALE ARG. CRISTALLO - 1351CAV' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 24/12/2025 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100689' , '11692' , 'BRACCIALE ROSARIO - 618M' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 24/12/2025 11:20:10 am >> SELECT document_num FROM ps_document WHERE document_num = '4407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 11:20:10 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' , '4407' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.70' , '55.94' , NOW() , NOW() ) 24/12/2025 11:20:10 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 = '100690' 24/12/2025 11:20:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100690' 24/12/2025 11:20:10 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 ( '100690' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 24/12/2025 11:20:10 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 ( '100690' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 24/12/2025 11:20:10 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 ( '100690' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 24/12/2025 11:20:10 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 ( '100690' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 24/12/2025 11:30:17 am >> SELECT document_num FROM ps_document WHERE document_num = '4408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 11:30:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4408' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '27.39' , NOW() , NOW() ) 24/12/2025 11:30:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100691' 24/12/2025 11:30:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100691' 24/12/2025 11:30:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100691' , '16273' , 'GEMELLI MADREPERLA CROCE - 21774' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 24/12/2025 11:30:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100691' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 24/12/2025 11:31:04 am >> SELECT document_num FROM ps_document WHERE document_num = '4409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 11:31:04 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' , '4409' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 24/12/2025 11:31:04 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 = '100692' 24/12/2025 11:31:04 am >> DELETE FROM ps_document_detail WHERE id_document = '100692' 24/12/2025 11:31:04 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 ( '100692' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 24/12/2025 11:39:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 11:39:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4410' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 24/12/2025 11:39:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100693' 24/12/2025 11:39:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100693' 24/12/2025 11:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100693' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 24/12/2025 11:44:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 11:44:20 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' , '4411' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.20' , '28.03' , NOW() , NOW() ) 24/12/2025 11:44:20 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 = '100694' 24/12/2025 11:44:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100694' 24/12/2025 11:44:20 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 ( '100694' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 24/12/2025 11:44:20 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 ( '100694' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 24/12/2025 11:55:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856698435' AND id_product != '24210' AND ean13 != '' 24/12/2025 11:55:59 am >> UPDATE ps_product SET id_supplier = '177', reference = '', ean13 = '9788856698435', date_upd = NOW() WHERE id_product = '24210' 24/12/2025 11:55:59 am >> UPDATE ps_product_lang SET name = 'LIBERI DI AMARE - C. AMIRANTE', description = '' WHERE id_product = '24210' 24/12/2025 11:55:59 am >> UPDATE ps_product SET wholesale_price = '9.99', on_sale = '0', price = '12.9000' WHERE id_product = '24210' 24/12/2025 11:55:59 am >> UPDATE ps_product_shop SET wholesale_price = '9.99', price = '12.9000', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24210' 24/12/2025 11:55:59 am >> DELETE FROM ps_specific_price WHERE id_product = '24210' 24/12/2025 11:56:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048509' AND id_product != '20896' AND ean13 != '' 24/12/2025 11:56:21 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884048509', date_upd = NOW() WHERE id_product = '20896' 24/12/2025 11:56:21 am >> UPDATE ps_product_lang SET name = 'SANTI DEL MESSALINO. MONICA LA VITA - 8467', description = '' WHERE id_product = '20896' 24/12/2025 11:56:21 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '20896' 24/12/2025 11:56:21 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20896' 24/12/2025 11:56:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20896' 24/12/2025 12:02:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3991' AND id_document != '100176' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 24/12/2025 12:02:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3991', document_date = '2025-11-29', 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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '100176' 24/12/2025 12:02:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100176' 24/12/2025 12:02:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100176' 24/12/2025 12:02:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100176' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 24/12/2025 12:02:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100176' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 24/12/2025 12:02:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100176' , '5975' , 'LUCERNA COLORATA - 1491' , '1' , '-1' , '1' , '21.0000' , '17.213114754098' , '22' , '0' , '21.00' ) 24/12/2025 12:02:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100176' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 24/12/2025 12:10:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 12:10:38 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' , '4412' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.46' , NOW() , NOW() ) 24/12/2025 12:10:38 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 = '100695' 24/12/2025 12:10:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100695' 24/12/2025 12:10:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100695' , '9506' , 'SAN PIO- 781-5 TMD ' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 24/12/2025 12:10:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100695' , '23940' , 'ROSARIO CON PADRE PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/12/2025 12:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100695' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/12/2025 12:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100695' , '17748' , 'SEGNALIBRO - PR 349' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 24/12/2025 12:18:17 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '2475', document_date = '2025-07-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '11.99', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '407.20', price_tax_excluded = '333.77', date_upd = NOW() WHERE id_document = '98350' 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98350' 24/12/2025 12:18:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '98350' 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '1371' , 'BRONZINA RIGHE VERT. CM 9 - 619' , '1' , '1' , '1' , '5.0000' , '4.0983606557377' , '22' , '5' , '5.80' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '1596' , 'CAMPANELLO 4 SUONI - 629' , '1' , '1' , '1' , '31.0000' , '25.409836065574' , '22' , '5' , '35.93' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '23873' , 'BOSSOLO DIAM 4 - 160' , '2' , '2' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '12.75' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '22931' , 'FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131' , '2' , '2' , '1' , '9.5000' , '7.7868852459016' , '22' , '5' , '22.02' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '1' , '1' , '13.5000' , '11.065573770492' , '22' , '5' , '15.65' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '23308' , 'FINTA CANDELA CON CARTUCCIA 3,2X30 - 1132' , '2' , '2' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '23.18' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '10' , '10' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '69.54' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '69.54' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '100' , '100' , '1' , '0.2500' , '0.20491803278689' , '22' , '5' , '28.98' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '1' , '1' , '13.2000' , '10.819672131148' , '22' , '5' , '15.30' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '23603' , 'CUSTODIA PELLE BIBBIA GERUSALEMME - 732' , '2' , '2' , '1' , '15.5000' , '12.704918032787' , '22' , '5' , '35.93' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '12' , '12' , '1' , '1.0000' , '0.81967213114754' , '22' , '5' , '13.91' ) 24/12/2025 12:18:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98350' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '1' , '1' , '38.0000' , '31.147540983607' , '22' , '5' , '44.04' ) 24/12/2025 12:22:28 pm >> DELETE FROM ps_product WHERE id_product = '750' 24/12/2025 12:22:28 pm >> DELETE FROM ps_product_shop WHERE id_product = '750' 24/12/2025 12:22:28 pm >> DELETE FROM ps_product_lang WHERE id_product = '750' 24/12/2025 12:22:28 pm >> DELETE FROM ps_stock_available WHERE id_product = '750' 24/12/2025 12:23:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4298' AND id_document != '100561' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-18') 24/12/2025 12:23:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4298', document_date = '2025-12-18', 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 = '24.90', price_tax_excluded = '20.41', date_upd = NOW() WHERE id_document = '100561' 24/12/2025 12:23:12 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 = '100561' 24/12/2025 12:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100561' 24/12/2025 12:23:12 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 ( '100561' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 24/12/2025 12:23:12 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 ( '100561' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 24/12/2025 12:23:12 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 ( '100561' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '1.10' ) 24/12/2025 12:37:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 12:37:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4413' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 24/12/2025 12:37:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100696' 24/12/2025 12:37:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100696' 24/12/2025 12:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100696' , '3248' , 'CUSTODIA BIBBIA GERUSALEMME PICCOLA - OGGETTI' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 24/12/2025 12:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100696' , '9791' , 'SEGNABIBBIA - 3110' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/12/2025 12:45:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 24/12/2025 12:45:20 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' , '4414' , '2025-12-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 24/12/2025 12:45:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100697' 24/12/2025 12:45:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100697' 24/12/2025 12:45:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100697' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' )