20/10/2025 09:01:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 09:01:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3413' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 20/10/2025 09:01:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99333' 20/10/2025 09:01:51 am >> DELETE FROM ps_document_detail WHERE id_document = '99333' 20/10/2025 09:01:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99333' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '20' , '-20' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '56.00' ) 20/10/2025 09:13:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3180' AND id_document != '98999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-01') 20/10/2025 09:13:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3180', document_date = '2025-10-01', 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 = '150.00', price_tax_excluded = '123.45', date_upd = NOW() WHERE id_document = '98999' 20/10/2025 09:13: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 = '98999' 20/10/2025 09:13:44 am >> DELETE FROM ps_document_detail WHERE id_document = '98999' 20/10/2025 09:13: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 ( '98999' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '60' , '-60' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '60.00' ) 20/10/2025 09:13: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 ( '98999' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '4' , '-4' , '1' , '12.8000' , '10.491803278689' , '22' , '0' , '51.20' ) 20/10/2025 09:13: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 ( '98999' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/10/2025 09:13: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 ( '98999' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/10/2025 09:13: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 ( '98999' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/10/2025 09:13: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 ( '98999' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.2' , '6.7213114754098' , '22' , '0' , '8.20' ) 20/10/2025 09:13: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 ( '98999' , '24094' , 'BRACCIALE SAN BENEDETTO - CC 111-SB' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 20/10/2025 09:13: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 ( '98999' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '1.60' ) 20/10/2025 09:13: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 ( '98999' , '21102' , 'BRACCIALE DECINA LEGNO CORDA - BC568' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 20/10/2025 09:13: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 ( '98999' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 20/10/2025 09:42:44 am >> SELECT document_num FROM ps_document WHERE document_num = '142' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 09:42: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 ( '21' , '142' , '2025-10-20' , '' , '3533' , '0' , '4672868' , 'VIALE FRENTANO 2 66030 MOZZAGROGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '94.52' , '94.52' , NOW() , NOW() ) 20/10/2025 09:42: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 = '99334' 20/10/2025 09:42:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99334' 20/10/2025 09:42: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 ( '99334' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '22' , '-22' , '4' , '2.40' , '2.4' , '0' , '15' , '44.88' ) 20/10/2025 09:42: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 ( '99334' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '15' , '12.75' ) 20/10/2025 09:42: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 ( '99334' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '15' , '17.85' ) 20/10/2025 09:42: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 ( '99334' , '11191' , 'VENITE CON ME 1 PARTE' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 20/10/2025 09:53:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 09:53: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' , '3414' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.75' , '11.48' , NOW() , NOW() ) 20/10/2025 09:53: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 = '99335' 20/10/2025 09:53:07 am >> DELETE FROM ps_document_detail WHERE id_document = '99335' 20/10/2025 09:53: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 ( '99335' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2025 09:53: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 ( '99335' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/10/2025 10:03:56 am >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 10:03:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '125/A' , '2025-10-20' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '441.33' , '441.33' , NOW() , NOW() ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99336' 20/10/2025 10:03:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99336' 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.80' , '3.8' , '0' , '15' , '96.90' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.80' , '3.8' , '0' , '15' , '48.45' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '15' , '34.00' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '-45' , '4' , '2.80' , '2.8' , '0' , '15' , '107.10' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '0' , '1.00' , '1' , '' , '0' , '4.00' ) 20/10/2025 10:03:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99336' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '45' , '-45' , '4' , '3.50' , '3.5' , '0' , '15' , '133.88' ) 20/10/2025 10:09:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 10:09:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3415' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '11.50' , NOW() , NOW() ) 20/10/2025 10:09:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99337' 20/10/2025 10:09:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99337' 20/10/2025 10:09:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99337' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 20/10/2025 10:09:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99337' , '21739' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 20/10/2025 10:09:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99337' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 20/10/2025 10:09:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99337' , '19933' , 'PADRE NOSTRO PER I PICCOLI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 20/10/2025 10:43:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 10:43:22 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' , '3416' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.10' , '4.18' , NOW() , NOW() ) 20/10/2025 10:43:22 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 = '99338' 20/10/2025 10:43:22 am >> DELETE FROM ps_document_detail WHERE id_document = '99338' 20/10/2025 10:43:22 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 ( '99338' , '6362' , 'MEDAGLIE ASSORTITE CON SPILLA - MO20 ' , '3' , '-3' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '1.80' ) 20/10/2025 10:43:22 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 ( '99338' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 20/10/2025 10:43:22 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 ( '99338' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 20/10/2025 10:43:22 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 ( '99338' , '16056' , 'CROCE TRINITA\' - G451' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 20/10/2025 10:43:22 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 ( '99338' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '0.70' ) 20/10/2025 10:44:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3416' AND id_document != '99338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 10:44:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3416', document_date = '2025-10-20', 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 = '5.10', price_tax_excluded = '4.18', date_upd = NOW() WHERE id_document = '99338' 20/10/2025 10:44: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 = '99338' 20/10/2025 10:44:46 am >> DELETE FROM ps_document_detail WHERE id_document = '99338' 20/10/2025 10:44: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 ( '99338' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 20/10/2025 10:44: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 ( '99338' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 20/10/2025 10:44:47 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 ( '99338' , '16056' , 'CROCE TRINITA\' - G451' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 20/10/2025 10:44:47 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 ( '99338' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 20/10/2025 11:41:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 11:41:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3417' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 20/10/2025 11:41:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99339' 20/10/2025 11:41:42 am >> DELETE FROM ps_document_detail WHERE id_document = '99339' 20/10/2025 11:41:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99339' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 20/10/2025 12:07:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 12:07:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3418' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1911.00' , '1566.39' , NOW() , NOW() ) 20/10/2025 12:07:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99340' 20/10/2025 12:07:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99340' 20/10/2025 12:07:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99340' , '24157' , 'LUCERNA TONDA TERRACOTTA - 056TEK' , '91' , '-91' , '1' , '21' , '17.213114754098' , '22' , '0' , '1911.00' ) 20/10/2025 12:18:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 12:18:36 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' , '3419' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 20/10/2025 12:18:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99341' 20/10/2025 12:18:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99341' 20/10/2025 12:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99341' , '20703' , 'QUADRETTO 30X15 - POSTO TRANQUILLO' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 20/10/2025 12:38:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '143' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 12:38:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '143' , '2025-10-20' , '' , '1553' , '0' , '4679270' , 'VIA LORETELLA 07041 ALGHERO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '17.92' , '17.92' , NOW() , NOW() ) 20/10/2025 12:38:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99342' 20/10/2025 12:38:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99342' 20/10/2025 12:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99342' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 20/10/2025 12:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99342' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 20/10/2025 12:38:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99342' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 20/10/2025 12:50:10 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2025 12:50:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24159' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:50:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24159' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2025 12:50:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24159' , '0' , '1' , '0' , '0' ) 20/10/2025 12:51:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839936271' AND id_product != '24159' AND ean13 != '' 20/10/2025 12:51:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839936271', date_upd = NOW() WHERE id_product = '24159' 20/10/2025 12:51:00 pm >> UPDATE ps_product_lang SET name = 'VIVERE E PENSARE IL DIO DEI POVERI - G. GUTIERREZ', description = '' WHERE id_product = '24159' 20/10/2025 12:51:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42' WHERE id_product = '24159' 20/10/2025 12:51:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24159' 20/10/2025 12:51:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '24159' 20/10/2025 12:51:01 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 = '24159' 20/10/2025 12:51:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24160' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:51:01 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 '24160' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24159' 20/10/2025 12:51:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24160' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24159' 20/10/2025 12:52:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892248908' AND id_product != '24160' AND ean13 != '' 20/10/2025 12:52:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788892248908', date_upd = NOW() WHERE id_product = '24160' 20/10/2025 12:52:01 pm >> UPDATE ps_product_lang SET name = 'SIMBOLI NELL\'ARTE CRISTIANA - C. CORTI', description = '' WHERE id_product = '24160' 20/10/2025 12:52:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '24160' 20/10/2025 12:52:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24160' 20/10/2025 12:52:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '24160' 20/10/2025 12:52: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 = '24160' 20/10/2025 12:52:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24161' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:52: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 '24161' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24160' 20/10/2025 12:52:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24161' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24160' 20/10/2025 12:52:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558273' AND id_product != '24161' AND ean13 != '' 20/10/2025 12:52:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831558273', date_upd = NOW() WHERE id_product = '24161' 20/10/2025 12:52:38 pm >> UPDATE ps_product_lang SET name = 'BIBBIA CHE SORPRESA', description = '' WHERE id_product = '24161' 20/10/2025 12:52:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.9' WHERE id_product = '24161' 20/10/2025 12:52:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24161' 20/10/2025 12:52:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '24161' 20/10/2025 12:52: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 = '24161' 20/10/2025 12:52:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24162' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:52: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 '24162' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24161' 20/10/2025 12:52:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24162' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24161' 20/10/2025 12:53:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557399' AND id_product != '24162' AND ean13 != '' 20/10/2025 12:53:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831557399', date_upd = NOW() WHERE id_product = '24162' 20/10/2025 12:53:35 pm >> UPDATE ps_product_lang SET name = 'EQUILIBRIO DEL SOLCO - E. RONCHI', description = '' WHERE id_product = '24162' 20/10/2025 12:53:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '24162' 20/10/2025 12:53:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24162' 20/10/2025 12:53:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '24162' 20/10/2025 12:53:36 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 = '24162' 20/10/2025 12:53:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24163' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:53:36 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 '24163' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24162' 20/10/2025 12:53:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24163' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24162' 20/10/2025 12:54:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558648' AND id_product != '24163' AND ean13 != '' 20/10/2025 12:54:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788831558648', date_upd = NOW() WHERE id_product = '24163' 20/10/2025 12:54:15 pm >> UPDATE ps_product_lang SET name = 'SCHIZZI DI VANGELO', description = '' WHERE id_product = '24163' 20/10/2025 12:54:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '24163' 20/10/2025 12:54:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24163' 20/10/2025 12:54:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '24163' 20/10/2025 12:54:18 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 = '24163' 20/10/2025 12:54:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24164' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:54:18 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 '24164' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24163' 20/10/2025 12:54:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24164' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24163' 20/10/2025 12:55:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839931412' AND id_product != '24164' AND ean13 != '' 20/10/2025 12:55:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788839931412', date_upd = NOW() WHERE id_product = '24164' 20/10/2025 12:55:14 pm >> UPDATE ps_product_lang SET name = 'FARSI AMICA L\'ESSANZA - H. NOUWEN', description = '' WHERE id_product = '24164' 20/10/2025 12:55:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '24164' 20/10/2025 12:55:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24164' 20/10/2025 12:55:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '24164' 20/10/2025 12:55:15 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 = '24164' 20/10/2025 12:55:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24165' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:55:15 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 '24165' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24164' 20/10/2025 12:55:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24165' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24164' 20/10/2025 12:56:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892249141' AND id_product != '24165' AND ean13 != '' 20/10/2025 12:56:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892249141', date_upd = NOW() WHERE id_product = '24165' 20/10/2025 12:56:16 pm >> UPDATE ps_product_lang SET name = 'DOMANDE DI GESU\' - L. MONTI', description = '' WHERE id_product = '24165' 20/10/2025 12:56:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '24165' 20/10/2025 12:56:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24165' 20/10/2025 12:56:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '24165' 20/10/2025 12:56:16 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 = '24165' 20/10/2025 12:56:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24166' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:56:16 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 '24166' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24165' 20/10/2025 12:56:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24166' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24165' 20/10/2025 12:57:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281917286' AND id_product != '24166' AND ean13 != '' 20/10/2025 12:57:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9791281917286', date_upd = NOW() WHERE id_product = '24166' 20/10/2025 12:57:19 pm >> UPDATE ps_product_lang SET name = 'QUATTRO RIVOLUZIONI GENTILI - P. PELLEGRINO', description = '' WHERE id_product = '24166' 20/10/2025 12:57:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.5' WHERE id_product = '24166' 20/10/2025 12:57:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.5', id_tax_rules_group = '4', id_category_default = '483', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24166' 20/10/2025 12:57:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '24166' 20/10/2025 12:57:20 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 = '24166' 20/10/2025 12:57:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24167' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 12:57: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 '24167' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24166' 20/10/2025 12:57:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24167' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24166' 20/10/2025 02:12:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868948221' AND id_product != '24167' AND ean13 != '' 20/10/2025 02:12:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788868948221', date_upd = NOW() WHERE id_product = '24167' 20/10/2025 02:12:55 pm >> UPDATE ps_product_lang SET name = 'DIO PER SEMPRE? - G. CHEMINI', description = '' WHERE id_product = '24167' 20/10/2025 02:12:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '24167' 20/10/2025 02:12:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24167' 20/10/2025 02:12:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '24167' 20/10/2025 02:12:56 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 = '24167' 20/10/2025 02:12:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24168' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 02:12:56 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 '24168' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24167' 20/10/2025 02:12:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24168' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24167' 20/10/2025 02:13:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884249067' AND id_product != '24168' AND ean13 != '' 20/10/2025 02:13:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884249067', date_upd = NOW() WHERE id_product = '24168' 20/10/2025 02:13:27 pm >> UPDATE ps_product_lang SET name = 'AVVENTO 2025 GIORNO PER GIORNO', description = '' WHERE id_product = '24168' 20/10/2025 02:13:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '24168' 20/10/2025 02:13:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24168' 20/10/2025 02:13:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '24168' 20/10/2025 02:13:28 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 = '24168' 20/10/2025 02:13:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24169' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 02:13:28 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 '24169' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24168' 20/10/2025 02:13:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24169' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24168' 20/10/2025 02:14:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825061109' AND id_product != '24169' AND ean13 != '' 20/10/2025 02:14:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788825061109', date_upd = NOW() WHERE id_product = '24169' 20/10/2025 02:14:14 pm >> UPDATE ps_product_lang SET name = 'NOVENA ALLA MADRE DEL BUON CONSIGLIO - G. PARIS', description = '' WHERE id_product = '24169' 20/10/2025 02:14:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '24169' 20/10/2025 02:14:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24169' 20/10/2025 02:14:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '24169' 20/10/2025 02:14:15 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 = '24169' 20/10/2025 02:14:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24170' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 02:14:16 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 '24170' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24169' 20/10/2025 02:14:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24170' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24169' 20/10/2025 02:15:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069716' AND id_product != '24170' AND ean13 != '' 20/10/2025 02:15:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788801069716', date_upd = NOW() WHERE id_product = '24170' 20/10/2025 02:15:08 pm >> UPDATE ps_product_lang SET name = 'DON BOSCO COMMENTA IL VANGELO - M. WIRTH', description = '' WHERE id_product = '24170' 20/10/2025 02:15:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '24170' 20/10/2025 02:15:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24170' 20/10/2025 02:15:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '24170' 20/10/2025 02:15:09 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 = '24170' 20/10/2025 02:15:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24171' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 02:15:09 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 '24171' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24170' 20/10/2025 02:15:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24171' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24170' 20/10/2025 02:16:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248947' AND id_product != '24171' AND ean13 != '' 20/10/2025 02:16:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788884248947', date_upd = NOW() WHERE id_product = '24171' 20/10/2025 02:16:04 pm >> UPDATE ps_product_lang SET name = 'MISSA HIELMALIS - A.M. MOTTA', description = '' WHERE id_product = '24171' 20/10/2025 02:16:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '24171' 20/10/2025 02:16:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24171' 20/10/2025 02:16:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '24171' 20/10/2025 02:16:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248947' AND id_product != '24171' AND ean13 != '' 20/10/2025 02:16:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788884248947', date_upd = NOW() WHERE id_product = '24171' 20/10/2025 02:16:14 pm >> UPDATE ps_product_lang SET name = 'MISSA HIELMALIS - A.M. MOTTA', description = '' WHERE id_product = '24171' 20/10/2025 02:16:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '24171' 20/10/2025 02:16:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24171' 20/10/2025 02:16:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '24171' 20/10/2025 02:16:15 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 = '24171' 20/10/2025 02:16:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24172' , '1' , '' , 'nuovo-prodotto' ) 20/10/2025 02:16:15 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 '24172' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24171' 20/10/2025 02:16:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24172' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24171' 20/10/2025 02:17:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892249141' AND id_product != '24165' AND ean13 != '' 20/10/2025 02:17:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892249141', date_upd = NOW() WHERE id_product = '24165' 20/10/2025 02:17:32 pm >> UPDATE ps_product_lang SET name = 'DOMANDE DI GESU\' - L. MONTI', description = '' WHERE id_product = '24165' 20/10/2025 02:17:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24165' 20/10/2025 02:17:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24165' 20/10/2025 02:17:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '24165' 20/10/2025 02:20:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '712121' , '2025-10-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.06' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.93' , '154.93' , NOW() , NOW() ) 20/10/2025 02:20:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99343' 20/10/2025 02:20:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99343' 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24160' , 'SIMBOLI NELLARTE CRISTIANA - C. CORTI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '33' , '23.4500' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24160' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24160' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24161' , 'BIBBIA CHE SORPRESA' , '1' , '1' , '4' , '13.90' , '13.9' , '0' , '35' , '9.0350' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24161' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24161' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24165' , 'DOMANDE DI GESU - L. MONTI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24165' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24165' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24162' , 'EQUILIBRIO DEL SOLCO - E. RONCHI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24162' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24162' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24159' , 'VIVERE E PENSARE IL DIO DEI POVERI - G. GUTIERREZ' , '1' , '1' , '4' , '42.00' , '42' , '0' , '30' , '29.4000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24159' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24159' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24171' , 'MISSA HIELMALIS - A.M. MOTTA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24171' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24171' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24170' , 'DON BOSCO COMMENTA IL VANGELO - M. WIRTH' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24170' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24170' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24167' , 'DIO PER SEMPRE? - G. CHEMINI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24167' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24167' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24164' , 'FARSI AMICA LESSANZA - H. NOUWEN' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24164' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24164' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24168' , 'AVVENTO 2025 GIORNO PER GIORNO' , '3' , '3' , '4' , '6.00' , '6' , '0' , '30' , '12.6000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24168' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24168' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24163' , 'SCHIZZI DI VANGELO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '33' , '11.3900' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24163' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24163' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24169' , 'NOVENA ALLA MADRE DEL BUON CONSIGLIO - G. PARIS' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24169' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24169' , '7' , '1' ) 20/10/2025 02:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99343' , '24166' , 'QUATTRO RIVOLUZIONI GENTILI - P. PELLEGRINO' , '1' , '1' , '4' , '10.50' , '10.5' , '0' , '30' , '7.3500' ) 20/10/2025 02:20:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24166' AND id_supplier = '7' 20/10/2025 02:20:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24166' , '7' , '1' ) 20/10/2025 02:22:58 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 20/10/2025 02:22:58 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '218' , '1' ) 20/10/2025 02:22:58 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '218' , '1' ) 20/10/2025 02:22:58 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '218' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 20/10/2025 02:23:12 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'DVyUZkU7M76xz9Rr' , NOW() , NOW() ) 20/10/2025 02:23:12 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4261' , '1' ) 20/10/2025 02:23:12 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4261' , '2' ) 20/10/2025 02:23:12 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4261' , '3' ) 20/10/2025 02:24:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4261' 20/10/2025 02:24:58 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4261' , '10' , '183' , '' , 'CASTALDO' , 'SALVATORE' , 'VIA CIRCUMVALLAZIONE OVEST PARCO AGENZIA 30' , '' , '80023' , 'CAIVANO' , '' , '' , '3356979371' , '' , '' , NOW() , NOW() ) 20/10/2025 02:24:58 pm >> UPDATE ps_customer SET email = 'ADAVIDE226@GMAIL.COM', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4261' 20/10/2025 02:26:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 02:26:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '144' , '2025-10-20' , '' , '4261' , '0' , '4679582' , 'VIA CIRCUMVALLAZIONE OVEST PARCO AGENZIA 30 80023 CAIVANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '144.40' , '144.40' , NOW() , NOW() ) 20/10/2025 02:26:00 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 = '99344' 20/10/2025 02:26:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '99344' 20/10/2025 02:26:00 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 ( '99344' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '15' , '-15' , '4' , '3.80' , '3.8' , '0' , '5' , '54.15' ) 20/10/2025 02:26:00 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 ( '99344' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '5' , '90.25' ) 20/10/2025 02:45:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246454' AND id_product != '23364' AND ean13 != '' 20/10/2025 02:45:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/2', ean13 = '9788892246454', date_upd = NOW() WHERE id_product = '23364' 20/10/2025 02:45:46 pm >> UPDATE ps_product_lang SET name = 'PADRE PIO - S. GAETA', description = '' WHERE id_product = '23364' 20/10/2025 02:45:46 pm >> UPDATE ps_product SET wholesale_price = '9.38', on_sale = '0', price = '14.0000' WHERE id_product = '23364' 20/10/2025 02:45:46 pm >> UPDATE ps_product_shop SET wholesale_price = '9.38', price = '14.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23364' 20/10/2025 02:45:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23364' 20/10/2025 02:46:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246966' AND id_product != '23701' AND ean13 != '' 20/10/2025 02:46:40 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/5', ean13 = '9788892246966', date_upd = NOW() WHERE id_product = '23701' 20/10/2025 02:46:40 pm >> UPDATE ps_product_lang SET name = 'CHIESA E I SACRAMENTI - C. SIMONELLI', description = '' WHERE id_product = '23701' 20/10/2025 02:46:40 pm >> UPDATE ps_product SET wholesale_price = '10.05', on_sale = '0', price = '15.0000' WHERE id_product = '23701' 20/10/2025 02:46:40 pm >> UPDATE ps_product_shop SET wholesale_price = '10.05', price = '15.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23701' 20/10/2025 02:46:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '23701' 20/10/2025 02:51:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608839' AND id_product != '22685' AND ean13 != '' 20/10/2025 02:51:47 pm >> UPDATE ps_product SET id_supplier = '79', reference = '13/7', ean13 = '9788826608839', date_upd = NOW() WHERE id_product = '22685' 20/10/2025 02:51:47 pm >> UPDATE ps_product_lang SET name = 'LAZZARO VIENI FUORI - J. MARTIN', description = '' WHERE id_product = '22685' 20/10/2025 02:51:47 pm >> UPDATE ps_product SET wholesale_price = '13.75', on_sale = '0', price = '25.0000' WHERE id_product = '22685' 20/10/2025 02:51:47 pm >> UPDATE ps_product_shop SET wholesale_price = '13.75', price = '25.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '284', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22685' 20/10/2025 02:51:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22685' 20/10/2025 03:05:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '145' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 03:05:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '145' , '2025-10-20' , '' , '541' , '0' , '4671522' , 'VIA GALLIANO 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '200.26' , '200.26' , NOW() , NOW() ) 20/10/2025 03:05: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 = '99345' 20/10/2025 03:05:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99345' 20/10/2025 03:05: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 ( '99345' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.80' , '3.8' , '0' , '15' , '74.29' ) 20/10/2025 03:05: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 ( '99345' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '12' , '-12' , '4' , '3.80' , '3.8' , '0' , '15' , '38.76' ) 20/10/2025 03:05: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 ( '99345' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '27' , '-27' , '4' , '3.80' , '3.8' , '0' , '15' , '87.21' ) 20/10/2025 03:29:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB0494' AND id_product != '20483' AND ean13 != '' 20/10/2025 03:29:56 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = 'PB0494', date_upd = NOW() WHERE id_product = '20483' 20/10/2025 03:29:56 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 43CM - 11 PEZZI - PB0494', description = '' WHERE id_product = '20483' 20/10/2025 03:29:56 pm >> UPDATE ps_product SET wholesale_price = '198.40', on_sale = '0', price = '491.8032786885246' WHERE id_product = '20483' 20/10/2025 03:29:56 pm >> UPDATE ps_product_shop SET wholesale_price = '198.40', price = '491.8032786885246', 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 = '20483' 20/10/2025 03:29:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20483' 20/10/2025 05:11:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 05:11: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' , '3420' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 20/10/2025 05:11: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 = '99346' 20/10/2025 05:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '99346' 20/10/2025 05:11: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 ( '99346' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2025 05:11: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 ( '99346' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 20/10/2025 05:58:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 05:58:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '126/A' , '2025-10-20' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA UNIVERSITARIA - DON CESARE D\'ANDREA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.20' , '49.83' , NOW() , NOW() ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99347' 20/10/2025 05:58:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99347' 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '22809' , 'O LUCE BEATISSIMA' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '0' , '12.50' ) 20/10/2025 05:58:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.50' , '27.459016393443' , '22' , '0' , '33.50' ) 20/10/2025 06:07:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 06:07:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3421' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 20/10/2025 06:07:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99348' 20/10/2025 06:07:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '99348' 20/10/2025 06:07:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 20/10/2025 06:52:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 06:52: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' , '3422' , '2025-10-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 20/10/2025 06:52: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 = '99349' 20/10/2025 06:52:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99349' 20/10/2025 06:52: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 ( '99349' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 20/10/2025 07:40:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '146' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 07:40: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 ( '21' , '146' , '2025-10-20' , '' , '4143' , '0' , '4679432' , 'VIA G. MEDICI 411A 98076 SANT\\\'AGATA DI MILITELLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.75' , '99.75' , NOW() , NOW() ) 20/10/2025 07:40: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 = '99350' 20/10/2025 07:40:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '99350' 20/10/2025 07:40: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 ( '99350' , '4154' , 'FESTA DEL PERDONO' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 20/10/2025 07:40: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 ( '99350' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2025 07:40: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 ( '99350' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 20/10/2025 07:40: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 ( '99350' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 20/10/2025 07:40:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '146' AND id_document != '99350' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-20') 20/10/2025 07:40:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '146', document_date = '2025-10-20', document_letter = '', id_customer = '4143', id_supplier = '', id_address = '4679432', address1 = 'VIA G. MEDICI 411A 98076 SANT\\\'AGATA DI MILITELLO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '99.75', price_tax_excluded = '99.75', date_upd = NOW() WHERE id_document = '99350' 20/10/2025 07:40: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 = '99350' 20/10/2025 07:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '99350' 20/10/2025 07:40: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 ( '99350' , '4154' , 'FESTA DEL PERDONO' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '5' , '28.50' ) 20/10/2025 07:40: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 ( '99350' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/10/2025 07:40: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 ( '99350' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '5' , '57.00' ) 20/10/2025 07:40: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 ( '99350' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' )