09/07/2025 08:23:24 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/07/2025 08:23:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23859' , '1' , '' , 'nuovo-prodotto' ) 09/07/2025 08:23:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23859' , '1' , '1' , '2' , NOW() , NOW() ) 09/07/2025 08:23:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23859' , '0' , '1' , '0' , '0' ) 09/07/2025 08:24:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281500082' AND id_product != '23859' AND ean13 != '' 09/07/2025 08:24:19 am >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9791281500082', date_upd = NOW() WHERE id_product = '23859' 09/07/2025 08:24:19 am >> UPDATE ps_product_lang SET name = 'LASCIATE CHE I BAMBINI VENGANO A ME', description = '' WHERE id_product = '23859' 09/07/2025 08:24:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.5' WHERE id_product = '23859' 09/07/2025 08:24:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.5', id_tax_rules_group = '4', id_category_default = '261', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23859' 09/07/2025 08:24:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23859' 09/07/2025 08:24:21 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 = '23859' 09/07/2025 08:24:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23860' , '1' , '' , 'nuovo-prodotto' ) 09/07/2025 08:24:21 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 '23860' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23859' 09/07/2025 08:24:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23860' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23859' 09/07/2025 08:29:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2025000002901' , '2025-07-04' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '122.03' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4881.04' , '4881.04' , NOW() , NOW() ) 09/07/2025 08:29:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98027' 09/07/2025 08:29:53 am >> DELETE FROM ps_document_detail WHERE id_document = '98027' 09/07/2025 08:29:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98027' , '9017' , 'RITO DELLA PENITENZA' , '3' , '3' , '4' , '10.50' , '10.5' , '0' , '22' , '24.5700' ) 09/07/2025 08:29: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 ( '98027' , '9013' , 'RITO DELL\'INIZIAZIONE CRISTIANA DEGLI ADULTI' , '5' , '5' , '4' , '20.66' , '20.66' , '0' , '22' , '80.5740' ) 09/07/2025 08:29: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 ( '98027' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '5' , '5' , '4' , '25.00' , '25' , '0' , '22' , '97.5000' ) 09/07/2025 08:29: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 ( '98027' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '3' , '3' , '4' , '60.00' , '60' , '0' , '22' , '140.4000' ) 09/07/2025 08:29: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 ( '98027' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '3' , '3' , '4' , '60.00' , '60' , '0' , '22' , '140.4000' ) 09/07/2025 08:29: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 ( '98027' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '5' , '5' , '4' , '110.00' , '110' , '0' , '22' , '429.0000' ) 09/07/2025 08:29: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 ( '98027' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '1' , '4' , '130.00' , '130' , '0' , '22' , '101.4000' ) 09/07/2025 08:29: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 ( '98027' , '18580' , 'ORAZIONALE PER LA PREGHIERA UNIVERSALE - N.E.' , '2' , '2' , '4' , '15.00' , '15' , '0' , '22' , '23.4000' ) 09/07/2025 08:29: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 ( '98027' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '6' , '6' , '4' , '35.00' , '35' , '0' , '22' , '163.8000' ) 09/07/2025 08:29: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 ( '98027' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '2' , '2' , '4' , '60.00' , '60' , '0' , '22' , '93.6000' ) 09/07/2025 08:29: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 ( '98027' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '3' , '3' , '4' , '35.00' , '35' , '0' , '22' , '81.9000' ) 09/07/2025 08:29: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 ( '98027' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '3' , '3' , '4' , '35.00' , '35' , '0' , '22' , '81.9000' ) 09/07/2025 08:29: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 ( '98027' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '5' , '5' , '4' , '20.00' , '20' , '0' , '22' , '78.0000' ) 09/07/2025 08:29: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 ( '98027' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '5' , '5' , '4' , '20.00' , '20' , '0' , '22' , '78.0000' ) 09/07/2025 08:29: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 ( '98027' , '21655' , 'BENEDIZIONALE N. E. ' , '5' , '5' , '4' , '40.00' , '40' , '0' , '22' , '156.0000' ) 09/07/2025 08:29: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 ( '98027' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '5' , '5' , '4' , '30.00' , '30' , '0' , '22' , '117.0000' ) 09/07/2025 08:29: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 ( '98027' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '3' , '3' , '4' , '20.00' , '20' , '0' , '22' , '46.8000' ) 09/07/2025 08:29: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 ( '98027' , '23859' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '30' , '30' , '4' , '5.50' , '5.5' , '0' , '22' , '128.7000' ) 09/07/2025 08:29: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 ( '98027' , '5444' , 'IO SONO CON VOI - CAT.' , '334' , '334' , '4' , '5.50' , '5.5' , '0' , '22' , '1432.8600' ) 09/07/2025 08:29: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 ( '98027' , '11193' , 'VENITE CON ME CAT.' , '198' , '198' , '4' , '5.50' , '5.5' , '0' , '22' , '849.4200' ) 09/07/2025 08:29: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 ( '98027' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '1' , '4' , '250.00' , '250' , '0' , '22' , '195.0000' ) 09/07/2025 08:29: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 ( '98027' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '51' , '51' , '4' , '5.50' , '5.5' , '0' , '22' , '218.7900' ) 09/07/2025 08:32:22 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 08:32: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 ( '24' , '20' , '2025-07-09' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MERCE GUASTA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '258.00' , '258.00' , NOW() , NOW() ) 09/07/2025 08:32: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 = '98028' 09/07/2025 08:32:22 am >> DELETE FROM ps_document_detail WHERE id_document = '98028' 09/07/2025 08:32: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 ( '98028' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 09/07/2025 08:32:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '107' 09/07/2025 08:32:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '107' , '1' ) 09/07/2025 08:32: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 ( '98028' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '3' , '-3' , '4' , '35.00' , '35' , '0' , '0' , '105.00' ) 09/07/2025 08:32:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22112' AND id_supplier = '107' 09/07/2025 08:32:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22112' , '107' , '1' ) 09/07/2025 08:32: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 ( '98028' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 09/07/2025 08:32:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '107' 09/07/2025 08:32:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '107' , '1' ) 09/07/2025 08:32: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 ( '98028' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '0' , '22.00' ) 09/07/2025 08:32:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '107' 09/07/2025 08:32:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '107' , '1' ) 09/07/2025 08:32: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 ( '98028' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '0' , '11.00' ) 09/07/2025 08:32:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '107' 09/07/2025 08:32:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '107' , '1' ) 09/07/2025 09:25:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2394' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 09:25:47 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' , '2394' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.96' , '68.85' , NOW() , NOW() ) 09/07/2025 09:25:47 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 = '98029' 09/07/2025 09:25:47 am >> DELETE FROM ps_document_detail WHERE id_document = '98029' 09/07/2025 09:25: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 ( '98029' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 09/07/2025 09:25: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 ( '98029' , '23656' , 'PROFETI DI SPERANZA - T. GIANNUZZI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/07/2025 09:25: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 ( '98029' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 09/07/2025 09:25: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 ( '98029' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 09/07/2025 09:28:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2395' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 09:28:11 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' , '2395' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 09/07/2025 09:28: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 = '98030' 09/07/2025 09:28:11 am >> DELETE FROM ps_document_detail WHERE id_document = '98030' 09/07/2025 09:28: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 ( '98030' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 09/07/2025 09:44:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 09:44:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2396' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 09/07/2025 09:44:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98031' 09/07/2025 09:44:02 am >> DELETE FROM ps_document_detail WHERE id_document = '98031' 09/07/2025 09:44:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98031' , '23823' , 'AMEN - SET 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/07/2025 09:44:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98031' , '23822' , 'AMEN - OTT 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/07/2025 10:11:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 10:11:54 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' , '2397' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 09/07/2025 10:11: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 = '98032' 09/07/2025 10:11:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98032' 09/07/2025 10:11: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 ( '98032' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/07/2025 10:11: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 ( '98032' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/07/2025 10:33:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 10:33:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2398' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 09/07/2025 10:33:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98033' 09/07/2025 10:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '98033' 09/07/2025 10:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98033' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 09/07/2025 10:51:10 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 10:51: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 ( '24' , '96/A' , '2025-07-09' , 'A' , '0' , '149' , '4671100' , 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 09/07/2025 10:51: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 = '98034' 09/07/2025 10:51:10 am >> DELETE FROM ps_document_detail WHERE id_document = '98034' 09/07/2025 10:51: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 ( '98034' , '19846' , 'CALICE IN ARG. EVANGELISTI - 175/A' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 09/07/2025 10:51:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19846' AND id_supplier = '149' 09/07/2025 10:51:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19846' , '149' , '1' ) 09/07/2025 10:51: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 ( '98034' , '' , 'incisione' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0' ) 09/07/2025 10:51:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '149' 09/07/2025 10:51:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '149' , '1' ) 09/07/2025 10:51: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 ( '98034' , '' , 'A DON GAETANO LANDI - DONO DELLA COMUNITA\' DI S.FELICE E S.M. MADRE DELLA CHIESA' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0' ) 09/07/2025 10:51:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '149' 09/07/2025 10:51:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '149' , '1' ) 09/07/2025 10:51: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 ( '98034' , '' , '29/04/2025 - 25° DI SACERDOZIO' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0' ) 09/07/2025 10:51:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '149' 09/07/2025 10:51:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '149' , '1' ) 09/07/2025 12:21:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 12:21:41 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' , '2399' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '36.90' , NOW() , NOW() ) 09/07/2025 12:21:41 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 = '98035' 09/07/2025 12:21:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '98035' 09/07/2025 12:21:41 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 ( '98035' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 09/07/2025 12:21:41 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 ( '98035' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/07/2025 12:21:41 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 ( '98035' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 09/07/2025 12:21:41 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 ( '98035' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/07/2025 12:23:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 12:23: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' , '2400' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 09/07/2025 12:23: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 = '98036' 09/07/2025 12:23:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '98036' 09/07/2025 12:23: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 ( '98036' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 09/07/2025 12:23: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 ( '98036' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 09/07/2025 12:51:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '97/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 12:51:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '97/A' , '2025-07-09' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 09/07/2025 12:51:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98037' 09/07/2025 12:51:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '98037' 09/07/2025 12:51:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98037' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 09/07/2025 12:56:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2194' AND id_document != '97787' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-20') 09/07/2025 12:56:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2194', document_date = '2025-06-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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '97787' 09/07/2025 12:56:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97787' 09/07/2025 12:56:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97787' 09/07/2025 12:56:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97787' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 09/07/2025 12:56:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97787' , '21176' , 'BRACCIALE ARG. EMATITE - 1642CAV' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 09/07/2025 03:34:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 03:34: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' , '2401' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 09/07/2025 03:34: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 = '98038' 09/07/2025 03:34:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '98038' 09/07/2025 03:34: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 ( '98038' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/07/2025 05:34:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 05:34:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2402' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 09/07/2025 05:34:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98039' 09/07/2025 05:34:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '98039' 09/07/2025 05:34:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98039' , '23694' , 'DONNA DI FRONTIERA ... - E. RONcHI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 09/07/2025 05:34:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839938329' AND id_product != '23694' AND ean13 != '' 09/07/2025 05:34:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788839938329', date_upd = NOW() WHERE id_product = '23694' 09/07/2025 05:34:35 pm >> UPDATE ps_product_lang SET name = 'DONNA DI FRONTIERA ... - E. RONCHI', description = '' WHERE id_product = '23694' 09/07/2025 05:34:35 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '15.0000' WHERE id_product = '23694' 09/07/2025 05:34:35 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23694' 09/07/2025 05:34:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '23694' 09/07/2025 06:18:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 06:18: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' , '2403' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.42' , '13.42' , NOW() , NOW() ) 09/07/2025 06:18: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 = '98040' 09/07/2025 06:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98040' 09/07/2025 06:18: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 ( '98040' , '23770' , 'PAROLA E PREGHIERA - AGO 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 09/07/2025 06:18: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 ( '98040' , '23824' , 'PAROLA E PREGHIERA - SET 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 09/07/2025 06:18: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 ( '98040' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.9' , '7.9' , '0' , '0' , '7.90' ) 09/07/2025 07:05:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-09') 09/07/2025 07:05:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2404' , '2025-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.31' , NOW() , NOW() ) 09/07/2025 07:05:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98041' 09/07/2025 07:05:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '98041' 09/07/2025 07:05:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98041' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' )