13/11/2025 08:30:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '97512' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-03') 13/11/2025 08:30:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1957', document_date = '2025-06-03', 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 = '21.10', price_tax_excluded = '21.10', date_upd = NOW() WHERE id_document = '97512' 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97512' 13/11/2025 08:30:16 am >> DELETE FROM ps_document_detail WHERE id_document = '97512' 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 13/11/2025 08:30:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97512' , '475' , 'AMICO GESÙ - FIGURINE' , '12' , '-12' , '4' , '0.5000' , '0.5' , '0' , '0' , '6.00' ) 13/11/2025 08:31:54 am >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '98800' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-09-18') 13/11/2025 08:31:54 am >> UPDATE ps_document SET id_document_type = '21', document_num = '93', document_date = '2025-09-18', document_letter = '', id_customer = '4238', id_supplier = '', id_address = '4679532', address1 = 'VIA GIACOMO MATTEOTTI 7 62020 GUALDO', address2 = '', note = '', price_shipping = '4.58', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '25.40', price_tax_excluded = '25.40', date_upd = NOW() WHERE id_document = '98800' 13/11/2025 08:31:54 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 = '98800' 13/11/2025 08:31:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98800' 13/11/2025 08:31:54 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 ( '98800' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 13/11/2025 08:33:30 am >> SELECT document_num FROM ps_document WHERE document_num = '115' AND id_document != '99142' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-09') 13/11/2025 08:33:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '115', document_date = '2025-10-09', document_letter = '', id_customer = '1207', id_supplier = '', id_address = '4679560', address1 = 'VIA SS. SALVATORE, 2 84080 CALVANICO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '163.12', price_tax_excluded = '163.12', date_upd = NOW() WHERE id_document = '99142' 13/11/2025 08:33:30 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 = '99142' 13/11/2025 08:33:30 am >> DELETE FROM ps_document_detail WHERE id_document = '99142' 13/11/2025 08:33:30 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 ( '99142' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 13/11/2025 08:33:30 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 ( '99142' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 13/11/2025 08:33:31 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 ( '99142' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '9' , '-9' , '4' , '3.8000' , '3.8' , '0' , '15' , '29.07' ) 13/11/2025 08:33:31 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 ( '99142' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '-9' , '4' , '3.8000' , '3.8' , '0' , '15' , '29.07' ) 13/11/2025 08:33:31 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 ( '99142' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '13' , '-13' , '4' , '3.8000' , '3.8' , '0' , '15' , '41.99' ) 13/11/2025 08:33:31 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 ( '99142' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.51' , '0.51' , '0' , '0' , '0.51' ) 13/11/2025 08:34:41 am >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '99278' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-16') 13/11/2025 08:34:41 am >> UPDATE ps_document SET id_document_type = '21', document_num = '134', document_date = '2025-10-16', document_letter = '', id_customer = '2787', id_supplier = '', id_address = '4679575', address1 = 'PIAZZA DEL CARMINE 2 71013 S. GIOVANNI ROTONDO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '122.40', price_tax_excluded = '122.40', date_upd = NOW() WHERE id_document = '99278' 13/11/2025 08:34:41 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 = '99278' 13/11/2025 08:34:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99278' 13/11/2025 08:34:41 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 ( '99278' , '2679' , 'CONOSCERE GESU\'' , '41' , '-41' , '4' , '3.50' , '3.5' , '0' , '15' , '121.98' ) 13/11/2025 08:34:41 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 ( '99278' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.42' , '0.42' , '0' , '0' , '0.42' ) 13/11/2025 08:35:48 am >> SELECT document_num FROM ps_document WHERE document_num = '142' AND id_document != '99334' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 13/11/2025 08:35:48 am >> UPDATE ps_document SET id_document_type = '21', document_num = '142', document_date = '2025-10-20', document_letter = '', id_customer = '3533', id_supplier = '', id_address = '4672868', address1 = 'VIALE FRENTANO 2 66030 MOZZAGROGNA', address2 = '', note = '', price_shipping = '0.25', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '94.52', price_tax_excluded = '94.52', date_upd = NOW() WHERE id_document = '99334' 13/11/2025 08:35:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99334' 13/11/2025 08:35:48 am >> DELETE FROM ps_document_detail WHERE id_document = '99334' 13/11/2025 08:35:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99334' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '6' , '-6' , '4' , '2.5000' , '2.5' , '0' , '15' , '12.75' ) 13/11/2025 08:35:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99334' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 13/11/2025 08:35:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99334' , '11191' , 'VENITE CON ME 1 PARTE' , '8' , '-8' , '4' , '2.8000' , '2.8' , '0' , '15' , '19.04' ) 13/11/2025 08:35:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99334' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 13/11/2025 08:39:20 am >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '99384' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-22') 13/11/2025 08:39:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '150', document_date = '2025-10-22', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4679370', address1 = 'VIA DEL CASALE DI SAN PIO V, 11/13 00165 ROMA ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '754.32', price_tax_excluded = '754.32', date_upd = NOW() WHERE id_document = '99384' 13/11/2025 08:39: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 = '99384' 13/11/2025 08:39:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99384' 13/11/2025 08:39: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 ( '99384' , '5444' , 'IO SONO CON VOI - CAT.' , '29' , '-29' , '4' , '5.5000' , '5.5' , '0' , '0' , '159.50' ) 13/11/2025 08:39: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 ( '99384' , '5457' , 'IO SONO CON VOI 1 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '15' , '83.30' ) 13/11/2025 08:39: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 ( '99384' , '5458' , 'IO SONO CON VOI 2 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '15' , '83.30' ) 13/11/2025 08:39: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 ( '99384' , '11191' , 'VENITE CON ME 1 PARTE' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '15' , '95.20' ) 13/11/2025 08:39: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 ( '99384' , '11192' , 'VENITE CON ME 2 PARTE' , '34' , '-34' , '4' , '2.8000' , '2.8' , '0' , '15' , '80.92' ) 13/11/2025 08:39: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 ( '99384' , '11193' , 'VENITE CON ME CAT.' , '31' , '-31' , '4' , '5.5000' , '5.5' , '0' , '0' , '170.50' ) 13/11/2025 08:39: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 ( '99384' , '2679' , 'CONOSCERE GESU\'' , '27' , '-27' , '4' , '3.50' , '3.5' , '0' , '15' , '80.33' ) 13/11/2025 08:39: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 ( '99384' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '1.27' , '1.27' , '0' , '0' , '1.27' ) 13/11/2025 08:40:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3495' AND id_document != '99451' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 13/11/2025 08:40:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3495', document_date = '2025-10-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 = '27.44', price_tax_excluded = '25.46', date_upd = NOW() WHERE id_document = '99451' 13/11/2025 08:40:03 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 = '99451' 13/11/2025 08:40:03 am >> DELETE FROM ps_document_detail WHERE id_document = '99451' 13/11/2025 08:40:03 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 ( '99451' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 13/11/2025 08:40:03 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 ( '99451' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 13/11/2025 08:40:03 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 ( '99451' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2025 08:40:03 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 ( '99451' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2025 08:40:03 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 ( '99451' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 13/11/2025 08:40:03 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 ( '99451' , '14031' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '2.28' , '2.28' , '0' , '0' , '2.28' ) 13/11/2025 08:41:11 am >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '99708' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 13/11/2025 08:41:11 am >> UPDATE ps_document SET id_document_type = '21', document_num = '197', document_date = '2025-11-05', document_letter = '', id_customer = '586', id_supplier = '', id_address = '4676029', address1 = 'P.ZZA MADONNA DI FATIMA 3 83031 ARIANO IRPINO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '48.35', price_tax_excluded = '48.35', date_upd = NOW() WHERE id_document = '99708' 13/11/2025 08:41:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99708' 13/11/2025 08:41:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99708' 13/11/2025 08:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99708' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 13/11/2025 08:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99708' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 13/11/2025 08:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99708' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.12' , '2.12' , '0' , '0' , '2.12' ) 13/11/2025 08:43:09 am >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '99715' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 13/11/2025 08:43:09 am >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2025-11-06', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4679628', address1 = 'P. ZZA CARMINE PASTORE 10 84080 CAPRIGLIA - PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '86.50', price_tax_excluded = '86.50', date_upd = NOW() WHERE id_document = '99715' 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99715' 13/11/2025 08:43:09 am >> DELETE FROM ps_document_detail WHERE id_document = '99715' 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99715' , '2679' , 'CONOSCERE GESU\'' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99715' , '12813' , 'MARIA MADRE NOSTRA' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '15' , '17.85' ) 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99715' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99715' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '15' , '15.30' ) 13/11/2025 08:43:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99715' , '14031' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.07' , '1.07' , '0' , '0' , '1.07' ) 13/11/2025 08:44:24 am >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '99836' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-11') 13/11/2025 08:44:24 am >> UPDATE ps_document SET id_document_type = '21', document_num = '223', document_date = '2025-11-11', document_letter = '', id_customer = '353', id_supplier = '', id_address = '4677366', address1 = 'C.DA EPITAFFIO 82100 BENEVENTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '124.36', price_tax_excluded = '124.36', date_upd = NOW() WHERE id_document = '99836' 13/11/2025 08:44:24 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 = '99836' 13/11/2025 08:44:24 am >> DELETE FROM ps_document_detail WHERE id_document = '99836' 13/11/2025 08:44:24 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 ( '99836' , '2679' , 'CONOSCERE GESU\'' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 13/11/2025 08:44:24 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 ( '99836' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/11/2025 08:44:24 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 ( '99836' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.46' , '2.46' , '0' , '0' , '2.46' ) 13/11/2025 09:04:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/11/2025 09:04:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24270' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 09:04:52 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24270' , '1' , '1' , '2' , NOW() , NOW() ) 13/11/2025 09:04:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24270' , '0' , '1' , '0' , '0' ) 13/11/2025 09:17:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400292909' AND id_product != '24270' AND ean13 != '' 13/11/2025 09:17:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400292909', date_upd = NOW() WHERE id_product = '24270' 13/11/2025 09:17:07 am >> UPDATE ps_product_lang SET name = 'SET 4 CANDELE AVVENTO - P764MUL', description = '' WHERE id_product = '24270' 13/11/2025 09:17:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '24270' 13/11/2025 09:17:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24270' 13/11/2025 09:17:07 am >> DELETE FROM ps_specific_price WHERE id_product = '24270' 13/11/2025 09:17:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24270' 13/11/2025 09:17:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24271' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 09:17:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24271' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24270' 13/11/2025 09:17:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24271' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24270' 13/11/2025 09:21:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3769' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:21:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3769' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.65' , '9.93' , NOW() , NOW() ) 13/11/2025 09:21:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99870' 13/11/2025 09:21:29 am >> DELETE FROM ps_document_detail WHERE id_document = '99870' 13/11/2025 09:21:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99870' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 13/11/2025 09:21:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99870' , '23776' , 'ROSARIO LEGNO 10MM - R987' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 13/11/2025 09:25:41 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 ( '31' , 'A4445' , '2025-11-11' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '19.90' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '464.80' , '380.98' , NOW() , NOW() ) 13/11/2025 09:25:41 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 = '99871' 13/11/2025 09:25:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99871' 13/11/2025 09:25:41 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 ( '99871' , '24189' , 'STATUA CM 20 - 4002' , '1' , '1' , '1' , '5.69' , '4.6639344262295' , '22' , '0' , '6.9418' ) 13/11/2025 09:25:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '24189' AND id_supplier = '28' 13/11/2025 09:25:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24189' , '28' , '1' ) 13/11/2025 09:25:41 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 ( '99871' , '24191' , 'STATUA CM 15 - 4025' , '1' , '1' , '1' , '3.73' , '3.0573770491803' , '22' , '0' , '4.5506' ) 13/11/2025 09:25:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '24191' AND id_supplier = '28' 13/11/2025 09:25:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24191' , '28' , '1' ) 13/11/2025 09:25:41 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 ( '99871' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '6' , '6' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '66.3192' ) 13/11/2025 09:25:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 13/11/2025 09:25:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 13/11/2025 09:25:41 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 ( '99871' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '200' , '200' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '183.0000' ) 13/11/2025 09:25:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '24270' AND id_supplier = '28' 13/11/2025 09:25:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24270' , '28' , '1' ) 13/11/2025 09:25:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99871' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '500' , '500' , '1' , '0.131' , '0.10737704918033' , '22' , '0' , '79.9100' ) 13/11/2025 09:25:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 13/11/2025 09:25:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 13/11/2025 09:25:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99871' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '300' , '300' , '1' , '0.131' , '0.10737704918033' , '22' , '0' , '47.9460' ) 13/11/2025 09:25:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '28' 13/11/2025 09:25:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '28' , '1' ) 13/11/2025 09:25:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99871' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '250' , '250' , '1' , '0.17' , '0.13934426229508' , '22' , '0' , '51.8500' ) 13/11/2025 09:25:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '28' 13/11/2025 09:25:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '28' , '1' ) 13/11/2025 09:39:10 am >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:39: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 ( '21' , '229' , '2025-11-13' , '' , '2021' , '0' , '4672489' , 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '316.20' , '316.20' , NOW() , NOW() ) 13/11/2025 09:39: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 = '99872' 13/11/2025 09:39:10 am >> DELETE FROM ps_document_detail WHERE id_document = '99872' 13/11/2025 09:39: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 ( '99872' , '2679' , 'CONOSCERE GESU\'' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '15' , '148.75' ) 13/11/2025 09:39: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 ( '99872' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '15' , '148.75' ) 13/11/2025 09:39:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99872' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 13/11/2025 09:39:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99872' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 13/11/2025 09:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3770' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:41:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3770' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 13/11/2025 09:41:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99873' 13/11/2025 09:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '99873' 13/11/2025 09:41:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99873' , '22606' , 'BRACCIALE ARG DORATO - ASB925-0726G' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 13/11/2025 09:41:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99873' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/11/2025 09:43:25 am >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '99872' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:43:25 am >> UPDATE ps_document SET id_document_type = '21', document_num = '229', document_date = '2025-11-13', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4672489', address1 = 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '316.20', price_tax_excluded = '316.20', date_upd = NOW() WHERE id_document = '99872' 13/11/2025 09:43:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99872' 13/11/2025 09:43:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99872' 13/11/2025 09:43:26 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 ( '99872' , '2679' , 'CONOSCERE GESU\'' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '15' , '148.75' ) 13/11/2025 09:43:26 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 ( '99872' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '15' , '148.75' ) 13/11/2025 09:43:26 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 ( '99872' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 13/11/2025 09:43:26 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 ( '99872' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 13/11/2025 09:55:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3771' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:55:46 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' , '3771' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.76' , '19.31' , NOW() , NOW() ) 13/11/2025 09:55:46 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 = '99874' 13/11/2025 09:55:46 am >> DELETE FROM ps_document_detail WHERE id_document = '99874' 13/11/2025 09:55:46 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 ( '99874' , '24006' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 13/11/2025 09:55:46 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 ( '99874' , '24007' , 'TUTTI I COLORI DEL NATALE ' , '1' , '-1' , '3' , '10.90' , '10.480769230769' , '4' , '5' , '10.36' ) 13/11/2025 09:59:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 09:59:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3772' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.60' , '42.60' , NOW() , NOW() ) 13/11/2025 09:59:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99875' 13/11/2025 09:59:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99875' 13/11/2025 09:59:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99875' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 13/11/2025 09:59:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99875' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 13/11/2025 09:59:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99875' , '24197' , 'PAROLA DI DIO OGNI GIORNO 2026 - V. PAGLIA' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 13/11/2025 10:07:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 10:07: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' , '3773' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 13/11/2025 10:07: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 = '99876' 13/11/2025 10:07:33 am >> DELETE FROM ps_document_detail WHERE id_document = '99876' 13/11/2025 10:07: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 ( '99876' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 13/11/2025 10:08:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 10:08:57 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' , '3774' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 13/11/2025 10:08:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99877' 13/11/2025 10:08:57 am >> DELETE FROM ps_document_detail WHERE id_document = '99877' 13/11/2025 10:08:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99877' , '24266' , 'VENITE A ME - F. CRISTOFARO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 13/11/2025 10:19:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859055555' AND id_product != '24271' AND ean13 != '' 13/11/2025 10:19:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859055555', date_upd = NOW() WHERE id_product = '24271' 13/11/2025 10:19:05 am >> UPDATE ps_product_lang SET name = 'CARTOLINA 363', description = '' WHERE id_product = '24271' 13/11/2025 10:19:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '24271' 13/11/2025 10:19:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '92', 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 = '24271' 13/11/2025 10:19:05 am >> DELETE FROM ps_specific_price WHERE id_product = '24271' 13/11/2025 10:19:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24271' 13/11/2025 10:19:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24272' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 10:19:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24272' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24271' 13/11/2025 10:19:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24272' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24271' 13/11/2025 10:20:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859055470' AND id_product != '24272' AND ean13 != '' 13/11/2025 10:20:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859055470', date_upd = NOW() WHERE id_product = '24272' 13/11/2025 10:20:23 am >> UPDATE ps_product_lang SET name = 'PAPA LEONE - ARS 506', description = '' WHERE id_product = '24272' 13/11/2025 10:20:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '24272' 13/11/2025 10:20:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '92', 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 = '24272' 13/11/2025 10:20:23 am >> DELETE FROM ps_specific_price WHERE id_product = '24272' 13/11/2025 10:20:24 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24272' 13/11/2025 10:20:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24273' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 10:20:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24273' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24272' 13/11/2025 10:20:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24273' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24272' 13/11/2025 10:23:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859018710' AND id_product != '24273' AND ean13 != '' 13/11/2025 10:23:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859018710', date_upd = NOW() WHERE id_product = '24273' 13/11/2025 10:23:09 am >> UPDATE ps_product_lang SET name = 'IMMACOLATA - ARS 11', description = '' WHERE id_product = '24273' 13/11/2025 10:23:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.12295081967213115' WHERE id_product = '24273' 13/11/2025 10:23:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.12295081967213115', id_tax_rules_group = '1', id_category_default = '92', 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 = '24273' 13/11/2025 10:23:09 am >> DELETE FROM ps_specific_price WHERE id_product = '24273' 13/11/2025 10:23:10 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24273' 13/11/2025 10:23:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24274' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 10:23:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24274' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24273' 13/11/2025 10:23:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24274' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24273' 13/11/2025 10:24:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002119' AND id_product != '20758' AND ean13 != '' 13/11/2025 10:24:49 am >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '002119', date_upd = NOW() WHERE id_product = '20758' 13/11/2025 10:24:49 am >> UPDATE ps_product_lang SET name = 'SEGNALIBRO 5X15', description = '' WHERE id_product = '20758' 13/11/2025 10:24:49 am >> UPDATE ps_product SET wholesale_price = '0.07', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '20758' 13/11/2025 10:24:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.07', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '92', 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 = '20758' 13/11/2025 10:24:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20758' 13/11/2025 10:25:44 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 ( '31' , '1012/00' , '2025-11-11' , '00' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , 'CONTROLLARE NUMERO' , '9.785' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '261.81' , '214.60' , NOW() , NOW() ) 13/11/2025 10:25:44 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 = '99878' 13/11/2025 10:25:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99878' 13/11/2025 10:25:44 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 ( '99878' , '17617' , 'IMMAGINI ISONZO X 100' , '80' , '80' , '1' , '2.5' , '2.0491803278689' , '22' , '30+10' , '153.7200' ) 13/11/2025 10:25:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 13/11/2025 10:25:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 13/11/2025 10:25:44 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 ( '99878' , '24271' , 'CARTOLINA 363' , '10' , '10' , '1' , '0.15' , '0.12295081967213' , '22' , '30+10' , '1.1529' ) 13/11/2025 10:25:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24271' AND id_supplier = '23' 13/11/2025 10:25:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24271' , '23' , '1' ) 13/11/2025 10:25:44 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 ( '99878' , '24272' , 'PAPA LEONE - ARS 506' , '100' , '100' , '1' , '0.07' , '0.057377049180328' , '22' , '30+10' , '5.3802' ) 13/11/2025 10:25:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24272' AND id_supplier = '23' 13/11/2025 10:25:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24272' , '23' , '1' ) 13/11/2025 10:25:44 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 ( '99878' , '24273' , 'IMMACOLATA - ARS 11' , '200' , '200' , '1' , '0.07' , '0.057377049180328' , '22' , '30+10' , '10.7604' ) 13/11/2025 10:25:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24273' AND id_supplier = '23' 13/11/2025 10:25:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24273' , '23' , '1' ) 13/11/2025 10:25:44 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 ( '99878' , '4374' , 'GESÙ BAMBINO - 273' , '300' , '300' , '1' , '0.07' , '0.057377049180328' , '22' , '30+10' , '16.1406' ) 13/11/2025 10:25:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4374' AND id_supplier = '23' 13/11/2025 10:25:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4374' , '23' , '1' ) 13/11/2025 10:25: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 ( '99878' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 - AVRSTEL' , '60' , '60' , '1' , '0.36' , '0.29508196721311' , '22' , '30+10' , '16.6018' ) 13/11/2025 10:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '5105' AND id_supplier = '23' 13/11/2025 10:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5105' , '23' , '1' ) 13/11/2025 10:25: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 ( '99878' , '20758' , 'SEGNALIBRO 5X15' , '600' , '600' , '1' , '0.1' , '0.081967213114754' , '22' , '30+10' , '46.1160' ) 13/11/2025 10:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '20758' AND id_supplier = '23' 13/11/2025 10:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20758' , '23' , '1' ) 13/11/2025 10:35:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3768' AND id_document != '99869' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-12') 13/11/2025 10:35:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3768', document_date = '2025-11-12', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '99869' 13/11/2025 10:35: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 = '99869' 13/11/2025 10:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '99869' 13/11/2025 10:35: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 ( '99869' , '18760' , 'BRACCIALE ARG - 1819' , '1' , '-1' , '1' , '43.0000' , '35.245901639344' , '22' , '0' , '43.00' ) 13/11/2025 10:35: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 ( '99869' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 13/11/2025 10:35: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 ( '99869' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '10' , '-10' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '20.00' ) 13/11/2025 10:36:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '99332' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-18') 13/11/2025 10:36:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3412', document_date = '2025-10-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 = '3.90', price_tax_excluded = '3.20', date_upd = NOW() WHERE id_document = '99332' 13/11/2025 10:36:31 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 = '99332' 13/11/2025 10:36:31 am >> DELETE FROM ps_document_detail WHERE id_document = '99332' 13/11/2025 10:36:31 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 ( '99332' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '2' , '-2' , '1' , '1.95' , '1.5983606557377' , '22' , '0' , '3.90' ) 13/11/2025 10:37:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3586' AND id_document != '99578' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-30') 13/11/2025 10:37:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3586', document_date = '2025-10-30', 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 = '3.80', price_tax_excluded = '3.11', date_upd = NOW() WHERE id_document = '99578' 13/11/2025 10:37:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99578' 13/11/2025 10:37:00 am >> DELETE FROM ps_document_detail WHERE id_document = '99578' 13/11/2025 10:37:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99578' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '2' , '-2' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '3.80' ) 13/11/2025 10:42:34 am >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '99823' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-11') 13/11/2025 10:42:34 am >> UPDATE ps_document SET id_document_type = '24', document_num = '139/A', document_date = '2025-11-11', document_letter = 'A', id_customer = '559', id_supplier = '', id_address = '4677368', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', 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 = '1164.14', price_tax_excluded = '1164.14', date_upd = NOW() WHERE id_document = '99823' 13/11/2025 10:42: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 = '99823' 13/11/2025 10:42:34 am >> DELETE FROM ps_document_detail WHERE id_document = '99823' 13/11/2025 10:42: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 ( '99823' , '10748' , 'TU MI CHIAMI PER NOME' , '35' , '-35' , '4' , '6.9000' , '6.9' , '0' , '5' , '229.43' ) 13/11/2025 10:42: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 ( '99823' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '69' , '-69' , '4' , '5.9000' , '5.9' , '0' , '5' , '386.75' ) 13/11/2025 10:42: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 ( '99823' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '66' , '-66' , '4' , '5.9000' , '5.9' , '0' , '5' , '369.93' ) 13/11/2025 10:42: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 ( '99823' , '12895' , 'PASSI VERSO LA CRESIMA' , '6' , '-6' , '4' , '7.9000' , '7.9' , '0' , '5' , '45.03' ) 13/11/2025 10:42: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 ( '99823' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '28' , '-28' , '4' , '5.0000' , '5' , '0' , '5' , '133.00' ) 13/11/2025 10:52:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3775' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 10:52: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' , '3775' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 13/11/2025 10:52: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 = '99879' 13/11/2025 10:52:10 am >> DELETE FROM ps_document_detail WHERE id_document = '99879' 13/11/2025 10:52: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 ( '99879' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '115' , '94.262295081967' , '22' , '0' , '115.00' ) 13/11/2025 10:53:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 10:53: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' , '3776' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '42.05' , NOW() , NOW() ) 13/11/2025 10:53: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 = '99880' 13/11/2025 10:53:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99880' 13/11/2025 10:53: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 ( '99880' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '34.00' ) 13/11/2025 10:53: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 ( '99880' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 13/11/2025 10:53: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 ( '99880' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 13/11/2025 10:53: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 ( '99880' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 13/11/2025 11:27:04 am >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 11:27: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 ( '21' , '230' , '2025-11-13' , '' , '3514' , '0' , '4674062' , 'VIA A. SALERNITANA, 41 84127 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.92' , '46.92' , NOW() , NOW() ) 13/11/2025 11:27: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 = '99881' 13/11/2025 11:27:04 am >> DELETE FROM ps_document_detail WHERE id_document = '99881' 13/11/2025 11:27: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 ( '99881' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 13/11/2025 11:27: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 ( '99881' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 13/11/2025 11:27: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 ( '99881' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '15' , '6.46' ) 13/11/2025 11:27: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 ( '99881' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '15' , '6.46' ) 13/11/2025 11:29:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 11:29:24 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' , '3777' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.19' , NOW() , NOW() ) 13/11/2025 11:29:24 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 = '99882' 13/11/2025 11:29:24 am >> DELETE FROM ps_document_detail WHERE id_document = '99882' 13/11/2025 11:29:24 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 ( '99882' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 13/11/2025 11:29:24 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 ( '99882' , '8855' , 'REGISTRO DEL CATECHISTA' , '6' , '-6' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '4.50' ) 13/11/2025 11:29:24 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 ( '99882' , '24200' , 'AVVENTURE SPAZIALI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 13/11/2025 12:15:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:15:14 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 ( '24' , '33' , '2025-11-13' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7136.00' , '7136.00' , NOW() , NOW() ) 13/11/2025 12:15: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 = '99883' 13/11/2025 12:15:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99883' 13/11/2025 12:15: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 ( '99883' , '11183' , 'VENITE CON ME - GUIDA' , '20' , '-20' , '4' , '8.00' , '8' , '0' , '0' , '160.00' ) 13/11/2025 12:15: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 ( '99883' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '640' , '-640' , '4' , '3.00' , '3' , '0' , '0' , '1920.00' ) 13/11/2025 12:15: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 ( '99883' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '60' , '-60' , '4' , '6.00' , '6' , '0' , '0' , '360.00' ) 13/11/2025 12:15: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 ( '99883' , '18357' , 'MIE PREGHIERINE N.E.' , '800' , '-800' , '4' , '1.50' , '1.5' , '0' , '0' , '1200.00' ) 13/11/2025 12:15: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 ( '99883' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '280' , '-280' , '4' , '3.50' , '3.5' , '0' , '0' , '980.00' ) 13/11/2025 12:15: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 ( '99883' , '24202' , 'GRANDI DONNE E GRANDI SANTE' , '50' , '-50' , '4' , '6.00' , '6' , '0' , '0' , '300.00' ) 13/11/2025 12:15:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99883' , '23677' , 'RICETTE DI MAMMA ROSA' , '10' , '-10' , '4' , '20.00' , '20' , '0' , '0' , '200.00' ) 13/11/2025 12:15:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99883' , '11192' , 'VENITE CON ME 2 PARTE' , '720' , '-720' , '4' , '2.80' , '2.8' , '0' , '0' , '2016.00' ) 13/11/2025 12:16:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '55/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:16: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 ( '23' , '55/E' , '2025-11-13' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '980.50' , '980.50' , NOW() , NOW() ) 13/11/2025 12:16: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 = '99884' 13/11/2025 12:16:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '99884' 13/11/2025 12:16: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 ( '99884' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.50' , '18.5' , '0' , '47' , '980.50' ) 13/11/2025 12:25:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3778' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:25:11 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' , '3778' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 13/11/2025 12:25:11 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 = '99885' 13/11/2025 12:25:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99885' 13/11/2025 12:25:11 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 ( '99885' , '24186' , 'DILEXI TE ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 13/11/2025 12:27:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:27: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' , '3779' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.61' , '53.22' , NOW() , NOW() ) 13/11/2025 12:27: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 = '99886' 13/11/2025 12:27:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '99886' 13/11/2025 12:27: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 ( '99886' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '3' , '-3' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '40.50' ) 13/11/2025 12:27: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 ( '99886' , '18219' , 'CROCE EMATITE CON LACCIO - N169-C' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 13/11/2025 12:27: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 ( '99886' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '5' , '15.11' ) 13/11/2025 12:28:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:28:07 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' , '3780' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.90' , NOW() , NOW() ) 13/11/2025 12:28:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99887' 13/11/2025 12:28:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '99887' 13/11/2025 12:28:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99887' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 13/11/2025 12:36:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '99881' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 12:36:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '230', document_date = '2025-11-13', document_letter = '', id_customer = '3514', id_supplier = '', id_address = '4674062', address1 = 'VIA A. SALERNITANA, 41 84127 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '46.92', price_tax_excluded = '46.92', date_upd = NOW() WHERE id_document = '99881' 13/11/2025 12:36:08 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 = '99881' 13/11/2025 12:36:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '99881' 13/11/2025 12:36:08 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 ( '99881' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 13/11/2025 12:36:08 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 ( '99881' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 13/11/2025 12:36:08 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 ( '99881' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 13/11/2025 12:36:08 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 ( '99881' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 13/11/2025 12:41:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '99860' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-12') 13/11/2025 12:41:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '228', document_date = '2025-11-12', document_letter = '', id_customer = '4141', id_supplier = '', id_address = '4679424', address1 = 'VIA SAN GIOVANNI - FRAZ. FERRARI 83020 SERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '61.88', price_tax_excluded = '61.88', date_upd = NOW() WHERE id_document = '99860' 13/11/2025 12:41:11 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 = '99860' 13/11/2025 12:41:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99860' 13/11/2025 12:41: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 ( '99860' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '14' , '-14' , '4' , '2.4000' , '2.4' , '0' , '15' , '28.56' ) 13/11/2025 12:41: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 ( '99860' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '15' , '33.32' ) 13/11/2025 03:00:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:00:52 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' , '3781' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.66' , '42.66' , NOW() , NOW() ) 13/11/2025 03:00:52 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 = '99888' 13/11/2025 03:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '99888' 13/11/2025 03:00:52 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 ( '99888' , '23970' , 'SIMONE CHIAMATO PIETRO - M. LEPORI' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 13/11/2025 03:00:52 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 ( '99888' , '24242' , 'COMMENTO AL VANGELO DEL GIORNO ANNO A - A. SPINA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 13/11/2025 03:00:52 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 ( '99888' , '24211' , 'PAPA LEONE XIV - C. HENNING' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '5' , '15.11' ) 13/11/2025 03:02:28 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 ( '32' , '344/25' , '2025-11-07' , '25' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '68.25' , '68.25' , NOW() , NOW() ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99889' 13/11/2025 03:02:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '99889' 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '24243' , 'SAN MARTINO DI TOURS - M. ARAMINI' , '22' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '55.00' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9573' , 'SANTA LUCIA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 13/11/2025 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9530' , 'SANTAGOSTINO - R.PICCOLOMINI' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:03:14 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '344/25', document_date = '2025-11-07', document_letter = '25', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '68.25', price_tax_excluded = '68.25', date_upd = NOW() WHERE id_document = '99889' 13/11/2025 03:03: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 = '99889' 13/11/2025 03:03:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99889' 13/11/2025 03:03: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 ( '99889' , '24243' , 'SAN MARTINO DI TOURS - M. ARAMINI' , '22' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '55.00' ) 13/11/2025 03:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24243' AND id_supplier = '17' 13/11/2025 03:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24243' , '17' , '1' ) 13/11/2025 03:03: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 ( '99889' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9473' AND id_supplier = '17' 13/11/2025 03:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9473' , '17' , '1' ) 13/11/2025 03:03: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 ( '99889' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '17' 13/11/2025 03:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '17' , '1' ) 13/11/2025 03:03: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 ( '99889' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19669' AND id_supplier = '17' 13/11/2025 03:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19669' , '17' , '1' ) 13/11/2025 03:03:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9573' , 'SANTA LUCIA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9573' AND id_supplier = '17' 13/11/2025 03:03:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9573' , '17' , '1' ) 13/11/2025 03:03:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 13/11/2025 03:03:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9527' AND id_supplier = '17' 13/11/2025 03:03:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9527' , '17' , '1' ) 13/11/2025 03:03:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99889' , '9530' , 'SANTAGOSTINO - R.PICCOLOMINI' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:03:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9530' AND id_supplier = '17' 13/11/2025 03:03:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9530' , '17' , '1' ) 13/11/2025 03:03:33 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '199/2025', document_date = '2025-11-07', document_letter = '2025', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '68.25', price_tax_excluded = '68.25', date_upd = NOW() WHERE id_document = '99814' 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99814' 13/11/2025 03:03:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '99814' 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99814' , '24243' , 'SAN MARTINO DI TOURS - M. ARAMINI' , '22' , '22' , '4' , '5.0000' , '5' , '0' , '50' , '55.00' ) 13/11/2025 03:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24243' AND id_supplier = '17' 13/11/2025 03:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24243' , '17' , '1' ) 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99814' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9473' AND id_supplier = '17' 13/11/2025 03:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9473' , '17' , '1' ) 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99814' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '17' 13/11/2025 03:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '17' , '1' ) 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99814' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19669' AND id_supplier = '17' 13/11/2025 03:03:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19669' , '17' , '1' ) 13/11/2025 03:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99814' , '9573' , 'SANTA LUCIA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/11/2025 03:03:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9573' AND id_supplier = '17' 13/11/2025 03:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9573' , '17' , '1' ) 13/11/2025 03:03: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 ( '99814' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 13/11/2025 03:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9527' AND id_supplier = '17' 13/11/2025 03:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9527' , '17' , '1' ) 13/11/2025 03:03: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 ( '99814' , '9530' , 'SANTAGOSTINO - R.PICCOLOMINI' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 13/11/2025 03:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9530' AND id_supplier = '17' 13/11/2025 03:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9530' , '17' , '1' ) 13/11/2025 03:15:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:15:46 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' , '3782' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.80' , '11.31' , NOW() , NOW() ) 13/11/2025 03:15:46 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 = '99890' 13/11/2025 03:15:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99890' 13/11/2025 03:15:46 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 ( '99890' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 13/11/2025 03:15:46 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 ( '99890' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 13/11/2025 03:18:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934181237' AND id_product != '24274' AND ean13 != '' 13/11/2025 03:18:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934181237', date_upd = NOW() WHERE id_product = '24274' 13/11/2025 03:18:03 pm >> UPDATE ps_product_lang SET name = 'BAMBINO OCCHI DI VETRO CM 34 - PB18123 ', description = '' WHERE id_product = '24274' 13/11/2025 03:18:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65.57377049180327' WHERE id_product = '24274' 13/11/2025 03:18:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65.57377049180327', id_tax_rules_group = '1', id_category_default = '458', 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 = '24274' 13/11/2025 03:18:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '24274' 13/11/2025 03:19:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934181237' AND id_product != '24274' AND ean13 != '' 13/11/2025 03:19:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934181237', date_upd = NOW() WHERE id_product = '24274' 13/11/2025 03:19:19 pm >> UPDATE ps_product_lang SET name = 'BAMBINO OCCHI DI VETRO CM 34 - PB18123 ', description = '' WHERE id_product = '24274' 13/11/2025 03:19:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65.57377049180327' WHERE id_product = '24274' 13/11/2025 03:19:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65.57377049180327', id_tax_rules_group = '1', id_category_default = '458', 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 = '24274' 13/11/2025 03:19:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '24274' 13/11/2025 03:19:19 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24274' 13/11/2025 03:19:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24275' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:19:20 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24275' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24274' 13/11/2025 03:19:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24275' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24274' 13/11/2025 03:22:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:22:08 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' , '3783' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '469.00' , '398.99' , NOW() , NOW() ) 13/11/2025 03:22:08 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 = '99891' 13/11/2025 03:22:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '99891' 13/11/2025 03:22:08 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 ( '99891' , '24255' , 'PAROLA DI CRISTO ANNO A - R. CANTALAMESSA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/11/2025 03:22:08 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 ( '99891' , '24217' , 'DUBBI DEL VIANDANTE - D. ANTISERI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/11/2025 03:22:08 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 ( '99891' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '-2' , '1' , '170' , '139.34426229508' , '22' , '0' , '340.00' ) 13/11/2025 03:22:08 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 ( '99891' , '24247' , 'NOZZE DELLAGNELLO - E. FALQUE' , '1' , '-1' , '4' , '53.00' , '53' , '0' , '5' , '50.35' ) 13/11/2025 03:22:08 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 ( '99891' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '18.25' , '14.959016393443' , '22' , '0' , '18.25' ) 13/11/2025 03:22:08 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 ( '99891' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 13/11/2025 03:23:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:23:37 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' , '3784' , '2025-11-13' , '' , '0' , '0' , '0' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.60' , '36.81' , NOW() , NOW() ) 13/11/2025 03:23:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99892' 13/11/2025 03:23:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '99892' 13/11/2025 03:23:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99892' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3654' , '4' , '0' , '10.50' ) 13/11/2025 03:23:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99892' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 13/11/2025 03:23:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99892' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/11/2025 03:27:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:27:09 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' , '3785' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '324.00' , '324.00' , NOW() , NOW() ) 13/11/2025 03:27:09 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 = '99893' 13/11/2025 03:27:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99893' 13/11/2025 03:27:09 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 ( '99893' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '10' , '45.00' ) 13/11/2025 03:27:09 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 ( '99893' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '10' , '67.50' ) 13/11/2025 03:27:09 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 ( '99893' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '10' , '90.00' ) 13/11/2025 03:27:09 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 ( '99893' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '-2' , '4' , '15.00' , '15' , '0' , '10' , '27.00' ) 13/11/2025 03:27:09 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 ( '99893' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '4' , '-4' , '4' , '15.00' , '15' , '0' , '10' , '54.00' ) 13/11/2025 03:27:09 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 ( '99893' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '3' , '-3' , '4' , '15.00' , '15' , '0' , '10' , '40.50' ) 13/11/2025 03:30:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3784' AND id_document != '99892' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:30:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3784', document_date = '2025-11-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '37.60', price_tax_excluded = '36.81', date_upd = NOW() WHERE id_document = '99892' 13/11/2025 03:30:32 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 = '99892' 13/11/2025 03:30:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '99892' 13/11/2025 03:30:32 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 ( '99892' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/11/2025 03:30:32 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 ( '99892' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/11/2025 03:30:32 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 ( '99892' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/11/2025 03:30:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3783' AND id_document != '99891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 03:30:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3783', document_date = '2025-11-13', 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 = '3', id_causal = '0', price_tax_included = '469.00', price_tax_excluded = '398.99', date_upd = NOW() WHERE id_document = '99891' 13/11/2025 03:30:45 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 = '99891' 13/11/2025 03:30:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99891' 13/11/2025 03:30: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 ( '99891' , '24255' , 'PAROLA DI CRISTO ANNO A - R. CANTALAMESSA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/11/2025 03:30: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 ( '99891' , '24217' , 'DUBBI DEL VIANDANTE - D. ANTISERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/11/2025 03:30: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 ( '99891' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '-2' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '340.00' ) 13/11/2025 03:30: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 ( '99891' , '24247' , 'NOZZE DELLAGNELLO - E. FALQUE' , '1' , '-1' , '4' , '53.0000' , '53' , '0' , '5' , '50.35' ) 13/11/2025 03:30: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 ( '99891' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '18.2500' , '14.959016393443' , '22' , '0' , '18.25' ) 13/11/2025 03:30: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 ( '99891' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 13/11/2025 03:36:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934195173' AND id_product != '24275' AND ean13 != '' 13/11/2025 03:36:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934195173', date_upd = NOW() WHERE id_product = '24275' 13/11/2025 03:36:37 pm >> UPDATE ps_product_lang SET name = 'GRUPPO NATIVITA\' MADONNA SDRAIATA - PB19517', description = '' WHERE id_product = '24275' 13/11/2025 03:36:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.78688524590164' WHERE id_product = '24275' 13/11/2025 03:36:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '458', 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 = '24275' 13/11/2025 03:36:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '24275' 13/11/2025 03:36:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24275' 13/11/2025 03:36:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24276' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:36:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24276' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24275' 13/11/2025 03:36:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24276' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24275' 13/11/2025 03:38:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190826' AND id_product != '24276' AND ean13 != '' 13/11/2025 03:38:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934190826', date_upd = NOW() WHERE id_product = '24276' 13/11/2025 03:38:28 pm >> UPDATE ps_product_lang SET name = 'IMMACOLATA CONC. BABY - PB19082', description = '' WHERE id_product = '24276' 13/11/2025 03:38:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '24276' 13/11/2025 03:38:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '458', 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 = '24276' 13/11/2025 03:38:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '24276' 13/11/2025 03:38:29 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24276' 13/11/2025 03:38:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24277' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:38:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24277' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24276' 13/11/2025 03:38:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24277' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24276' 13/11/2025 03:48:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934064950' AND id_product != '24277' AND ean13 != '' 13/11/2025 03:48:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934064950', date_upd = NOW() WHERE id_product = '24277' 13/11/2025 03:48:40 pm >> UPDATE ps_product_lang SET name = 'ANGELO IN RESINA - PB6495', description = '' WHERE id_product = '24277' 13/11/2025 03:48:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '24277' 13/11/2025 03:48:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '458', 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 = '24277' 13/11/2025 03:48:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '24277' 13/11/2025 03:48:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24277' 13/11/2025 03:48:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24278' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:48:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24278' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24277' 13/11/2025 03:48:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24278' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24277' 13/11/2025 03:51:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934207340' AND id_product != '24278' AND ean13 != '' 13/11/2025 03:51:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934207340', date_upd = NOW() WHERE id_product = '24278' 13/11/2025 03:51:01 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' CON CAPANNA CM 25 RESINA - PB20734', description = '' WHERE id_product = '24278' 13/11/2025 03:51:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '80.32786885245902' WHERE id_product = '24278' 13/11/2025 03:51:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '458', 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 = '24278' 13/11/2025 03:51:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '24278' 13/11/2025 03:51:02 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24278' 13/11/2025 03:51:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24279' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:51:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24279' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24278' 13/11/2025 03:51:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24279' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24278' 13/11/2025 03:52:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934198600' AND id_product != '24279' AND ean13 != '' 13/11/2025 03:52:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934198600', date_upd = NOW() WHERE id_product = '24279' 13/11/2025 03:52:53 pm >> UPDATE ps_product_lang SET name = 'GRUPPO NATIVITA\' CM 14 - PB19860', description = '' WHERE id_product = '24279' 13/11/2025 03:52:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '24279' 13/11/2025 03:52:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '458', 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 = '24279' 13/11/2025 03:52:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24279' 13/11/2025 03:52:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24279' 13/11/2025 03:52:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24280' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:52:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24280' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24279' 13/11/2025 03:52:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24280' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24279' 13/11/2025 03:56:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934062789' AND id_product != '17574' AND ean13 != '' 13/11/2025 03:56:31 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934062789', date_upd = NOW() WHERE id_product = '17574' 13/11/2025 03:56:31 pm >> UPDATE ps_product_lang SET name = 'BAMBINO RESINA - PB6278', description = '' WHERE id_product = '17574' 13/11/2025 03:56:31 pm >> UPDATE ps_product SET wholesale_price = '9.41', on_sale = '0', price = '27.049180327868854' WHERE id_product = '17574' 13/11/2025 03:56:31 pm >> UPDATE ps_product_shop SET wholesale_price = '9.41', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '458', 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 = '17574' 13/11/2025 03:56:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '17574' 13/11/2025 03:56:32 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '17574' 13/11/2025 03:56:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24281' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 03:56:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24281' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '17574' 13/11/2025 03:56:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24281' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '17574' 13/11/2025 04:04:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934159441' AND id_product != '24280' AND ean13 != '' 13/11/2025 04:04:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934159441', date_upd = NOW() WHERE id_product = '24280' 13/11/2025 04:04:40 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 30 - PB15944', description = '' WHERE id_product = '24280' 13/11/2025 04:04:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '24280' 13/11/2025 04:04:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '458', 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 = '24280' 13/11/2025 04:04:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '24280' 13/11/2025 04:04:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24280' 13/11/2025 04:04:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24282' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 04:04:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24282' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24280' 13/11/2025 04:04:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24282' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24280' 13/11/2025 04:05:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934062758' AND id_product != '18886' AND ean13 != '' 13/11/2025 04:05:34 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934062758', date_upd = NOW() WHERE id_product = '18886' 13/11/2025 04:05:34 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CON CULLA - PB6275', description = '' WHERE id_product = '18886' 13/11/2025 04:05:34 pm >> UPDATE ps_product SET wholesale_price = '17.96', on_sale = '0', price = '45.08196721311476' WHERE id_product = '18886' 13/11/2025 04:05:34 pm >> UPDATE ps_product_shop SET wholesale_price = '17.96', price = '45.08196721311476', id_tax_rules_group = '1', id_category_default = '458', 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 = '18886' 13/11/2025 04:05:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '18886' 13/11/2025 04:05:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '18886' 13/11/2025 04:05:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24283' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 04:05:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24283' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '18886' 13/11/2025 04:05:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24283' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '18886' 13/11/2025 04:09:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934181244' AND id_product != '24282' AND ean13 != '' 13/11/2025 04:09:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934181244', date_upd = NOW() WHERE id_product = '24282' 13/11/2025 04:09:14 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 43 OCCHI DI VETRO - PB18124', description = '' WHERE id_product = '24282' 13/11/2025 04:09:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '100' WHERE id_product = '24282' 13/11/2025 04:09:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '100', id_tax_rules_group = '1', id_category_default = '458', 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 = '24282' 13/11/2025 04:09:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '24282' 13/11/2025 04:10:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934181244' AND id_product != '24282' AND ean13 != '' 13/11/2025 04:10:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934181244', date_upd = NOW() WHERE id_product = '24282' 13/11/2025 04:10:21 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 43 OCCHI DI VETRO - PB18124', description = '' WHERE id_product = '24282' 13/11/2025 04:10:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '100' WHERE id_product = '24282' 13/11/2025 04:10:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '100', id_tax_rules_group = '1', id_category_default = '458', 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 = '24282' 13/11/2025 04:10:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '24282' 13/11/2025 04:10:22 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24282' 13/11/2025 04:10:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24284' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 04:10:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24284' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24282' 13/11/2025 04:10:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24284' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24282' 13/11/2025 04:11:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934178237' AND id_product != '24284' AND ean13 != '' 13/11/2025 04:11:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934178237', date_upd = NOW() WHERE id_product = '24284' 13/11/2025 04:11:36 pm >> UPDATE ps_product_lang SET name = 'CUORE NATIVITA\' CM 16 - PB17823', description = '' WHERE id_product = '24284' 13/11/2025 04:11:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '24284' 13/11/2025 04:11:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '458', 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 = '24284' 13/11/2025 04:11:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '24284' 13/11/2025 04:17:59 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' , '22' , '2025-10-10' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 13/11/2025 04:17:59 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 = '99894' 13/11/2025 04:17:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99894' 13/11/2025 04:17:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99894' , '18682' , 'CLERGY ROMANO ML - C17' , '85' , '85' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 13/11/2025 04:17:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '137' 13/11/2025 04:17:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '137' , '1' ) 13/11/2025 04:19:54 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 ( '32' , '225' , '2025-11-04' , '' , '0' , '0' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '518.50' , '425.00' , NOW() , NOW() ) 13/11/2025 04:19: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 = '99895' 13/11/2025 04:19:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99895' 13/11/2025 04:19: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 ( '99895' , '18682' , 'CLERGY ROMANO ML - C17' , '85' , '0' , '1' , '5' , '4.0983606557377' , '22' , '0' , '518.5000' ) 13/11/2025 04:24:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934178237' AND id_product != '24284' AND ean13 != '' 13/11/2025 04:24:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934178237', date_upd = NOW() WHERE id_product = '24284' 13/11/2025 04:24:37 pm >> UPDATE ps_product_lang SET name = 'CUORE NATIVITA\' CM 16 - PB17823', description = '' WHERE id_product = '24284' 13/11/2025 04:24:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '24284' 13/11/2025 04:24:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '458', 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 = '24284' 13/11/2025 04:24:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '24284' 13/11/2025 04:24:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24284' 13/11/2025 04:24:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24285' , '1' , '' , 'nuovo-prodotto' ) 13/11/2025 04:24:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24285' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24284' 13/11/2025 04:24:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24285' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24284' 13/11/2025 04:56:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '203' AND id_document != '99725' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 13/11/2025 04:56:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '203', document_date = '2025-11-06', document_letter = '', id_customer = '2385', id_supplier = '', id_address = '4678091', address1 = 'PIAZZA REGINA MARGHERITA 84084 LANCUSI BOLANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '92.48', price_tax_excluded = '92.48', date_upd = NOW() WHERE id_document = '99725' 13/11/2025 04:56:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99725' 13/11/2025 04:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99725' 13/11/2025 04:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99725' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 13/11/2025 04:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99725' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '16' , '-16' , '4' , '3.8000' , '3.8' , '0' , '15' , '51.68' ) 13/11/2025 04:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99725' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '3.80' , '3.8' , '0' , '15' , '32.30' ) 13/11/2025 06:05:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 06:05:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3786' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 13/11/2025 06:05:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99896' 13/11/2025 06:05:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99896' 13/11/2025 06:05:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99896' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 13/11/2025 06:07:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 06:07:18 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' , '3787' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 13/11/2025 06:07:18 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 = '99897' 13/11/2025 06:07:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '99897' 13/11/2025 06:07:18 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 ( '99897' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 13/11/2025 06:23:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 06:23: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 ( '11' , '3788' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.41' , '28.41' , NOW() , NOW() ) 13/11/2025 06:23: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 = '99898' 13/11/2025 06:23:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99898' 13/11/2025 06:23: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 ( '99898' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 13/11/2025 06:23: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 ( '99898' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 13/11/2025 06:28:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 06:28:12 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' , '3789' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 13/11/2025 06:28: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 = '99899' 13/11/2025 06:28:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99899' 13/11/2025 06:28: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 ( '99899' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/11/2025 06:28: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 ( '99899' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/11/2025 06:58:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 06:58:06 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' , '3790' , '2025-11-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '17.28' , NOW() , NOW() ) 13/11/2025 06:58:06 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 = '99900' 13/11/2025 06:58:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '99900' 13/11/2025 06:58:06 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 ( '99900' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/11/2025 06:58:06 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 ( '99900' , '23270' , 'PINO 3D - P172' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/11/2025 06:58:06 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 ( '99900' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 13/11/2025 07:03:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3743' AND id_document != '99829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-11') 13/11/2025 07:03:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3743', document_date = '2025-11-11', 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 = '340.00', price_tax_excluded = '296.51', date_upd = NOW() WHERE id_document = '99829' 13/11/2025 07:03:06 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 = '99829' 13/11/2025 07:03:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '99829' 13/11/2025 07:03:06 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 ( '99829' , '2528' , 'COMPIETA' , '5' , '-5' , '4' , '1.9000' , '1.9' , '0' , '5' , '9.05' ) 13/11/2025 07:03:06 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 ( '99829' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '34.7700' , '28.5' , '22' , '0' , '34.77' ) 13/11/2025 07:03:06 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 ( '99829' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 13/11/2025 07:03:06 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 ( '99829' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '34.00' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '24135' , 'SULLA SOGLIA DELLA VITA - E. RONCHI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '24162' , 'EQUILIBRIO DEL SOLCO - E. RONCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '5590' , 'LECTIO DIVINA OGNI GIORNO - 16' , '1' , '-1' , '4' , '13.3' , '13.3' , '0' , '0' , '13.30' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '5587' , 'LECTIO DIVINA OGNI GIORNO - 13' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '5586' , 'LECTIO DIVINA OGNI GIORNO - 12' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '5589' , 'LECTIO DIVINA OGNI GIORNO - 15' , '1' , '-1' , '4' , '15.675' , '15.675' , '0' , '0' , '15.68' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/11/2025 07:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99829' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 13/11/2025 07:42:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3787' AND id_document != '99897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 13/11/2025 07:42:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3787', document_date = '2025-11-13', 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 = '14.25', price_tax_excluded = '14.25', date_upd = NOW() WHERE id_document = '99897' 13/11/2025 07:42:04 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 = '99897' 13/11/2025 07:42:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99897' 13/11/2025 07:42:04 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 ( '99897' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' )