03/10/2025 08:53:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3906/00' , '2025-10-01' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '125.00' , NOW() , NOW() ) 03/10/2025 08:53:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99034' 03/10/2025 08:53:43 am >> DELETE FROM ps_document_detail WHERE id_document = '99034' 03/10/2025 08:53: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 ( '99034' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '25' , '25' , '4' , '5.00' , '5' , '0' , '0' , '125.0000' ) 03/10/2025 09:01:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 09:01: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' , '3207' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.60' , '29.72' , NOW() , NOW() ) 03/10/2025 09:01: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 = '99035' 03/10/2025 09:01:22 am >> DELETE FROM ps_document_detail WHERE id_document = '99035' 03/10/2025 09:01: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 ( '99035' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 03/10/2025 09:01: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 ( '99035' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3.8' , '3.6538461538462' , '4' , '0' , '3.80' ) 03/10/2025 09:01: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 ( '99035' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 03/10/2025 09:10:48 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/10/2025 09:10:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24120' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 09:10:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24120' , '1' , '1' , '2' , NOW() , NOW() ) 03/10/2025 09:10:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24120' , '0' , '1' , '0' , '0' ) 03/10/2025 09:11:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069662' AND id_product != '24120' AND ean13 != '' 03/10/2025 09:11:43 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801069662', date_upd = NOW() WHERE id_product = '24120' 03/10/2025 09:11:43 am >> UPDATE ps_product_lang SET name = 'CHE BELLO! CAMMINA CON GESU\' - QUADERNO 1', description = '' WHERE id_product = '24120' 03/10/2025 09:11:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.098360655737705' WHERE id_product = '24120' 03/10/2025 09:11:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.098360655737705', id_tax_rules_group = '1', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24120' 03/10/2025 09:11:43 am >> DELETE FROM ps_specific_price WHERE id_product = '24120' 03/10/2025 09:11:44 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 = '24120' 03/10/2025 09:11:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24121' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 09:11:44 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 '24121' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24120' 03/10/2025 09:11:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24121' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24120' 03/10/2025 09:13:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788840190518' AND id_product != '24121' AND ean13 != '' 03/10/2025 09:13:51 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788840190518', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:13:51 am >> UPDATE ps_product_lang SET name = 'MORIAR NE MORIAR - A. GENOVESE', description = '' WHERE id_product = '24121' 03/10/2025 09:13:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '24121' 03/10/2025 09:13:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '296', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:13:51 am >> DELETE FROM ps_specific_price WHERE id_product = '24121' 03/10/2025 09:13:52 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 = '24121' 03/10/2025 09:13:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24122' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 09:13:52 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 '24122' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24121' 03/10/2025 09:13:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24122' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24121' 03/10/2025 09:14:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788840190518' AND id_product != '24121' AND ean13 != '' 03/10/2025 09:14:03 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788840190518', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:14:03 am >> UPDATE ps_product_lang SET name = 'MORIAR NE MORIAR - A. GENOVESE', description = '' WHERE id_product = '24121' 03/10/2025 09:14:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '24121' 03/10/2025 09:14:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '296', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:14:03 am >> DELETE FROM ps_specific_price WHERE id_product = '24121' 03/10/2025 09:14:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788840190518' AND id_product != '24121' AND ean13 != '' 03/10/2025 09:14:08 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788840190518', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:14:08 am >> UPDATE ps_product_lang SET name = 'MORIAR NE MORIAR - A. GENOVESE', description = '' WHERE id_product = '24121' 03/10/2025 09:14:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24121' 03/10/2025 09:14:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '296', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24121' 03/10/2025 09:14:08 am >> DELETE FROM ps_specific_price WHERE id_product = '24121' 03/10/2025 09:14:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069662' AND id_product != '24120' AND ean13 != '' 03/10/2025 09:14:26 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801069662', date_upd = NOW() WHERE id_product = '24120' 03/10/2025 09:14:26 am >> UPDATE ps_product_lang SET name = 'CHE BELLO! CAMMINA CON GESU\' - QUADERNO 1', description = '' WHERE id_product = '24120' 03/10/2025 09:14:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '24120' 03/10/2025 09:14:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24120' 03/10/2025 09:14:26 am >> DELETE FROM ps_specific_price WHERE id_product = '24120' 03/10/2025 09:15:40 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' , '710361' , '2025-10-01' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '8.2' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '176.30' , '176.30' , NOW() , NOW() ) 03/10/2025 09:15:40 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 = '99036' 03/10/2025 09:15:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99036' 03/10/2025 09:15:40 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 ( '99036' , '24120' , 'CHE BELLO! CAMMINA CON GESU - QUADERNO 1' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 03/10/2025 09:15:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24120' AND id_supplier = '7' 03/10/2025 09:15:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24120' , '7' , '1' ) 03/10/2025 09:15:40 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 ( '99036' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '6' , '6' , '4' , '24.00' , '24' , '0' , '35' , '93.6000' ) 03/10/2025 09:15:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '12809' AND id_supplier = '7' 03/10/2025 09:15:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12809' , '7' , '1' ) 03/10/2025 09:15:40 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 ( '99036' , '24059' , 'FRANCESCO E CHIARA - L. EPICOCO' , '2' , '2' , '4' , '14.00' , '14' , '0' , '30' , '19.6000' ) 03/10/2025 09:15:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24059' AND id_supplier = '7' 03/10/2025 09:15:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24059' , '7' , '1' ) 03/10/2025 09:15:40 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 ( '99036' , '24121' , 'MORIAR NE MORIAR - A. GENOVESE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 03/10/2025 09:15:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24121' AND id_supplier = '7' 03/10/2025 09:15:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24121' , '7' , '1' ) 03/10/2025 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 03/10/2025 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '7' 03/10/2025 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '7' , '1' ) 03/10/2025 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 03/10/2025 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21629' AND id_supplier = '7' 03/10/2025 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21629' , '7' , '1' ) 03/10/2025 09:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '3' , '3' , '4' , '6.00' , '6' , '0' , '15' , '15.3000' ) 03/10/2025 09:15:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '7' 03/10/2025 09:15:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '7' , '1' ) 03/10/2025 09:16:30 am >> UPDATE ps_document SET id_document_type = '33', document_num = '710361', document_date = '2025-10-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '5.05', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '176.30', price_tax_excluded = '176.30', date_upd = NOW() WHERE id_document = '99036' 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99036' 03/10/2025 09:16:30 am >> DELETE FROM ps_document_detail WHERE id_document = '99036' 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '24120' , 'CHE BELLO! CAMMINA CON GESU - QUADERNO 1' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '6' , '6' , '4' , '24.0000' , '24' , '0' , '35' , '93.60' ) 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '24059' , 'FRANCESCO E CHIARA - L. EPICOCO' , '2' , '2' , '4' , '14.0000' , '14' , '0' , '30' , '19.60' ) 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '24121' , 'MORIAR NE MORIAR - A. GENOVESE' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 03/10/2025 09:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 03/10/2025 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '33' , '16.75' ) 03/10/2025 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '3' , '3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 03/10/2025 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99036' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '30' , '3.1500' ) 03/10/2025 09:21:22 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'qhDCfa71N2zaKIAC' , NOW() , NOW() ) 03/10/2025 09:21:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4246' , '1' ) 03/10/2025 09:21:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4246' , '2' ) 03/10/2025 09:21:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4246' , '3' ) 03/10/2025 09:23:41 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4246' 03/10/2025 09:23:41 am >> 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 ( '4246' , '10' , '210' , '' , 'RAMPOLLA ' , 'RICCARDO' , 'VIA' , '' , '84' , 'SA' , '' , '' , '3402556194' , '' , '' , NOW() , NOW() ) 03/10/2025 09:23:41 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4246' 03/10/2025 10:19:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 10:19:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3208' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 03/10/2025 10:19:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99037' 03/10/2025 10:19:32 am >> DELETE FROM ps_document_detail WHERE id_document = '99037' 03/10/2025 10:19:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99037' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 03/10/2025 10:20:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 10:20:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3209' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 03/10/2025 10:20:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99038' 03/10/2025 10:20:10 am >> DELETE FROM ps_document_detail WHERE id_document = '99038' 03/10/2025 10:20:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99038' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 03/10/2025 11:15:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 11:15:35 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' , '3210' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.30' , '111.05' , NOW() , NOW() ) 03/10/2025 11:15:35 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 = '99039' 03/10/2025 11:15:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99039' 03/10/2025 11:15:35 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 ( '99039' , '23614' , 'FERMAGLIO - B314/FE' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 03/10/2025 11:15:35 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 ( '99039' , '778' , 'ASPERGES CON VASETTO O. S. - 1700 ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 03/10/2025 11:15:35 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 ( '99039' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 03/10/2025 11:15:35 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 ( '99039' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 03/10/2025 11:16:31 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '0uFoRis46E9UUVo5' , NOW() , NOW() ) 03/10/2025 11:16:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4247' , '1' ) 03/10/2025 11:16:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4247' , '2' ) 03/10/2025 11:16:31 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4247' , '3' ) 03/10/2025 11:18:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4247' 03/10/2025 11:18:18 am >> 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 ( '4247' , '10' , '210' , 'PARR. SS SALVATORE E S. ANDREA' , 'CASTALDI' , 'DON FRANCESCO PAOLO' , 'PIAZZA LUCA GAURICO' , '' , '84096' , 'GAURO MONTECORVINO ROVELLA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 03/10/2025 11:18:18 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4247' 03/10/2025 11:18:40 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4247' 03/10/2025 11:18:40 am >> 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 ( '4247' , '10' , '210' , 'PARR. SS SALVATORE E S. ANDREA' , 'CASTALDI' , 'DON FRANCESCO PAOLO' , 'PIAZZA LUCA GAURICO' , '' , '84096' , 'GAURO MONTECORVINO ROVELLA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 03/10/2025 11:18:40 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4247' 03/10/2025 11:31:58 am >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 11:31:58 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' , '108' , '2025-10-03' , '' , '2385' , '0' , '4678091' , 'PIAZZA REGINA MARGHERITA 84084 LANCUSI BOLANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '51.00' , '51.00' , NOW() , NOW() ) 03/10/2025 11:31:58 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 = '99040' 03/10/2025 11:31:58 am >> DELETE FROM ps_document_detail WHERE id_document = '99040' 03/10/2025 11:31:58 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 ( '99040' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 03/10/2025 11:33:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 11:33:40 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' , '3211' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.56' , '16.76' , NOW() , NOW() ) 03/10/2025 11:33:40 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 = '99041' 03/10/2025 11:33:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99041' 03/10/2025 11:33:40 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 ( '99041' , '12270' , 'NUOVO ABC DEL CATECHISTA' , '2' , '-2' , '4' , '4.50' , '4.5' , '0' , '5' , '8.56' ) 03/10/2025 11:33:40 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 ( '99041' , '17006' , 'SEGNALIBRO PR' , '25' , '-25' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '10.00' ) 03/10/2025 11:46:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 11:46: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 ( '11' , '3212' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 03/10/2025 11:46: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 = '99042' 03/10/2025 11:46:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99042' 03/10/2025 11:46: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 ( '99042' , '24068' , 'MESSA MEDITAZIONE - NOV/DIC 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 03/10/2025 11:49:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3034' AND id_document != '98815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-19') 03/10/2025 11:49:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3034', document_date = '2025-09-19', 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 = '53.90', price_tax_excluded = '46.52', date_upd = NOW() WHERE id_document = '98815' 03/10/2025 11:49:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98815' 03/10/2025 11:49:33 am >> DELETE FROM ps_document_detail WHERE id_document = '98815' 03/10/2025 11:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '1' , '-1' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '15.90' ) 03/10/2025 11:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 03/10/2025 11:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '10498' , 'TECA CON PLACCA - 504' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 03/10/2025 11:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 03/10/2025 12:10:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '117/A' AND id_document != '98892' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-24') 03/10/2025 12:10:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '117/A', document_date = '2025-09-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4679537', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '259.40', price_tax_excluded = '234.78', date_upd = NOW() WHERE id_document = '98892' 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98892' 03/10/2025 12:10:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98892' 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '0' , '90.00' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '24085' , 'FINTA CANDELA 3,2X20 COMPL. DI CART. - 1130' , '6' , '-6' , '1' , '21.0000' , '17.213114754098' , '22' , '0' , '126.00' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '' , '03/10' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 03/10/2025 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98892' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/10/2025 12:27:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2943' AND id_document != '98700' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-10') 03/10/2025 12:27:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2943', document_date = '2025-09-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '1500.00', price_tax_excluded = '1236.72', date_upd = NOW() WHERE id_document = '98700' 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98700' 03/10/2025 12:27:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98700' 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98700' , '16407' , 'ASPERGES MAXI PER SECCHIELLO - 690' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98700' , '9780' , 'SECCHIELLO PER ASPERGES IN ACCIAIO - 695' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98700' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '0' , '40.00' ) 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98700' , '' , 'LEGGIO PLEX' , '1' , '-1' , '1' , '375' , '307.37704918033' , '22' , '0' , '375.00' ) 03/10/2025 12:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98700' , '' , 'CROCE ASTILE' , '1' , '-1' , '1' , '950' , '778.68852459016' , '22' , '0' , '950.00' ) 03/10/2025 03:13:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3207' AND id_document != '99035' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 03:13:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3207', document_date = '2025-10-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.60', price_tax_excluded = '29.72', date_upd = NOW() WHERE id_document = '99035' 03/10/2025 03:13:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99035' 03/10/2025 03:13:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99035' 03/10/2025 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99035' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '29.40' ) 03/10/2025 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99035' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 03/10/2025 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99035' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9' , '1.8269230769231' , '4' , '0' , '3.80' ) 03/10/2025 03:17:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 03:17:33 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' , '3213' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.90' , '30.31' , NOW() , NOW() ) 03/10/2025 03:17:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99043' 03/10/2025 03:17:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '99043' 03/10/2025 03:17:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99043' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 03/10/2025 03:17:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99043' , '21175' , 'BRACCIALE ARG. MM6 - 1452/CAV' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 03/10/2025 03:20:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893184991' AND id_product != '24122' AND ean13 != '' 03/10/2025 03:20:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788893184991', date_upd = NOW() WHERE id_product = '24122' 03/10/2025 03:20:38 pm >> UPDATE ps_product_lang SET name = 'GESU\' E SATANA - G. TOMASELLI', description = '' WHERE id_product = '24122' 03/10/2025 03:20:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '24122' 03/10/2025 03:20:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24122' 03/10/2025 03:20:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '24122' 03/10/2025 03:20:39 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 = '24122' 03/10/2025 03:20:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24123' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 03:20:39 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 '24123' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24122' 03/10/2025 03:20:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24123' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24122' 03/10/2025 03:21:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871988504' AND id_product != '24123' AND ean13 != '' 03/10/2025 03:21:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788871988504', date_upd = NOW() WHERE id_product = '24123' 03/10/2025 03:21:24 pm >> UPDATE ps_product_lang SET name = 'TROMBE DELL\'APOCALISSE - L. FANZAGA', description = '' WHERE id_product = '24123' 03/10/2025 03:21:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '24123' 03/10/2025 03:21:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '159', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24123' 03/10/2025 03:21:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '24123' 03/10/2025 03:22:32 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' , '4325' , '2025-10-01' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.48' , '89.48' , NOW() , NOW() ) 03/10/2025 03:22:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99044' 03/10/2025 03:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '99044' 03/10/2025 03:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99044' , '24122' , 'GESU E SATANA - G. TOMASELLI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 03/10/2025 03:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24122' AND id_supplier = '47' 03/10/2025 03:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24122' , '47' , '1' ) 03/10/2025 03:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99044' , '24123' , 'TROMBE DELLAPOCALISSE - L. FANZAGA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '27' , '11.6800' ) 03/10/2025 03:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24123' AND id_supplier = '47' 03/10/2025 03:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24123' , '47' , '1' ) 03/10/2025 03:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99044' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 03/10/2025 03:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18114' AND id_supplier = '47' 03/10/2025 03:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18114' , '47' , '1' ) 03/10/2025 03:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99044' , '17894' , 'OPERE TERESA DI GESU' , '2' , '2' , '4' , '30.00' , '30' , '0' , '30' , '42.0000' ) 03/10/2025 03:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17894' AND id_supplier = '47' 03/10/2025 03:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17894' , '47' , '1' ) 03/10/2025 03:45:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/10/2025 03:45:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24124' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 03:45:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24124' , '1' , '1' , '2' , NOW() , NOW() ) 03/10/2025 03:45:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24124' , '0' , '1' , '0' , '0' ) 03/10/2025 03:46:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879624848' AND id_product != '24124' AND ean13 != '' 03/10/2025 03:46:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788879624848', date_upd = NOW() WHERE id_product = '24124' 03/10/2025 03:46:23 pm >> UPDATE ps_product_lang SET name = 'CALENDARIO D\'AVVENTO 2025', description = '' WHERE id_product = '24124' 03/10/2025 03:46:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '24124' 03/10/2025 03:46:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '110', 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 = '24124' 03/10/2025 03:46:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '24124' 03/10/2025 03:46:26 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 = '24124' 03/10/2025 03:46:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24125' , '1' , '' , 'nuovo-prodotto' ) 03/10/2025 03:46:26 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 '24125' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24124' 03/10/2025 03:46:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24125' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24124' 03/10/2025 03:58:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788896063576' AND id_product != '24125' AND ean13 != '' 03/10/2025 03:58:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788896063576', date_upd = NOW() WHERE id_product = '24125' 03/10/2025 03:58:53 pm >> UPDATE ps_product_lang SET name = 'DIAVOLO E I SUOI ATTACCHI AL MATRIMONIO ', description = '' WHERE id_product = '24125' 03/10/2025 03:58:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24125' 03/10/2025 03:58:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '316', 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 = '24125' 03/10/2025 03:58:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24125' 03/10/2025 03:59: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 ( '33' , '2025000003939' , '2025-10-02' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.56' , '97.13' , NOW() , NOW() ) 03/10/2025 03:59: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 = '99045' 03/10/2025 03:59:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99045' 03/10/2025 03:59: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 ( '99045' , '23978' , 'SACRA LITURGIA - E. FINOTTI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '35' , '16.9000' ) 03/10/2025 03:59:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23978' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23978' , '107' , '1' ) 03/10/2025 03:59:16 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 ( '99045' , '24124' , 'CALENDARIO DAVVENTO 2025' , '1' , '1' , '1' , '10.00' , '8.1967213114754' , '22' , '35' , '7.9300' ) 03/10/2025 03:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24124' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24124' , '107' , '1' ) 03/10/2025 03:59:16 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 ( '99045' , '23864' , 'MARIOLOGIA BIBLICA - S. MANELLI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 03/10/2025 03:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23864' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23864' , '107' , '1' ) 03/10/2025 03:59:16 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 ( '99045' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 03/10/2025 03:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 03/10/2025 03:59:16 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 ( '99045' , '24030' , 'FRATELLO DI TUTTI - V. PISTORE' , '1' , '1' , '4' , '21.50' , '21.5' , '0' , '35' , '13.9750' ) 03/10/2025 03:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24030' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24030' , '107' , '1' ) 03/10/2025 03:59:16 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 ( '99045' , '24125' , 'DIAVOLO E I SUOI ATTACCHI AL MATRIMONIO ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 03/10/2025 03:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24125' AND id_supplier = '107' 03/10/2025 03:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24125' , '107' , '1' ) 03/10/2025 05:01:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 05:01: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' , '3214' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '36.70' , NOW() , NOW() ) 03/10/2025 05:01: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 = '99046' 03/10/2025 05:01:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '99046' 03/10/2025 05:01: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 ( '99046' , '17894' , 'OPERE TERESA DI GESU' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 03/10/2025 05:01: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 ( '99046' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/10/2025 05:21:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 05:21:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '119/A' , '2025-10-03' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.90' , '160.57' , NOW() , NOW() ) 03/10/2025 05:21:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99047' 03/10/2025 05:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99047' 03/10/2025 05:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 03/10/2025 05:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '19594' , 'POLO JERSEY COTONE 100%' , '3' , '-3' , '1' , '41.00' , '33.606557377049' , '22' , '0' , '123.00' ) 03/10/2025 05:21:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 03/10/2025 05:53:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 05:53: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 ( '11' , '3215' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '172.42' , '152.89' , NOW() , NOW() ) 03/10/2025 05:53: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 = '99048' 03/10/2025 05:53:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99048' 03/10/2025 05:53: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 ( '99048' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '13.32' ) 03/10/2025 05:53: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 ( '99048' , '24076' , 'SAN CARLO ACUTIS - ARS 490' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 03/10/2025 05:53: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 ( '99048' , '20758' , 'SEGNALIBRO 5X15' , '200' , '-200' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '40.00' ) 03/10/2025 05:53: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 ( '99048' , '20956' , 'BEATO CARLO ACUTIS - 64' , '200' , '-200' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '40.00' ) 03/10/2025 05:53: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 ( '99048' , '2048' , 'CHRISTIFIDELES LAICI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 03/10/2025 05:53: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 ( '99048' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 03/10/2025 05:53: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 ( '99048' , '18176' , 'ANTIQUUM MINISTERIUM ' , '30' , '-30' , '4' , '1.00' , '1' , '0' , '5' , '28.50' ) 03/10/2025 05:53: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 ( '99048' , '24019' , 'PERCHE LA MADONNA APPARE - 8267' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/10/2025 05:53: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 ( '99048' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 03/10/2025 05:53: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 ( '99048' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '0' , '5.00' ) 03/10/2025 05:53: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 ( '99048' , '23962' , 'CARLO ACUTIS - 8288' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/10/2025 05:53: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 ( '99048' , '23961' , 'PIER GIORGIO FRASSATI - 8287' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/10/2025 05:54:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 05:54:23 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' , '3216' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.60' , '29.54' , NOW() , NOW() ) 03/10/2025 05:54:23 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 = '99049' 03/10/2025 05:54:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99049' 03/10/2025 05:54: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 ( '99049' , '23978' , 'SACRA LITURGIA - E. FINOTTI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 03/10/2025 05:54: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 ( '99049' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 03/10/2025 06:03:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 06:03: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' , '3217' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 03/10/2025 06:03: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 = '99050' 03/10/2025 06:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99050' 03/10/2025 06:03: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 ( '99050' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 03/10/2025 06:03: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 ( '99050' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/10/2025 06:03: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 ( '99050' , '9338' , 'SACROSANCTUM CONCILIUM' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 03/10/2025 06:03: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 ( '99050' , '2019' , 'CHIESA - LUMEN GENTIUM' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 03/10/2025 06:07:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 06:07:39 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' , '3218' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 03/10/2025 06:07:39 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 = '99051' 03/10/2025 06:07:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99051' 03/10/2025 06:07:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99051' , '16244' , 'QUADRO 10X10' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 03/10/2025 06:36:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 06:36:33 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' , '3219' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.30' , '1.89' , NOW() , NOW() ) 03/10/2025 06:36:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99052' 03/10/2025 06:36:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '99052' 03/10/2025 06:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99052' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 03/10/2025 06:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99052' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 03/10/2025 06:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99052' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 03/10/2025 06:49:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 06:49:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3220' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 03/10/2025 06:49: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 = '99053' 03/10/2025 06:49:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99053' 03/10/2025 06:49:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99053' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/10/2025 07:08:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 07:08:01 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' , '3221' , '2025-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 03/10/2025 07:08:01 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 = '99054' 03/10/2025 07:08:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '99054' 03/10/2025 07:08:01 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 ( '99054' , '23983' , 'PIER GIORGIO FRASSATI. UN AVVENTURIERO IN PARADISO - CROUX/DE RUYVER' , '1' , '-1' , '4' , '17.5' , '17.5' , '0' , '0' , '17.50' ) 03/10/2025 07:08:01 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 ( '99054' , '23755' , 'VIAGGIO NEI MIRACOLI EUCARISTICI - M. BUIONI' , '1' , '-1' , '4' , '17.50' , '17.5' , '0' , '0' , '17.50' ) 03/10/2025 07:38:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '99047' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-03') 03/10/2025 07:38:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2025-10-03', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '281.80', price_tax_excluded = '230.98', date_upd = NOW() WHERE id_document = '99047' 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99047' 03/10/2025 07:38:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '99047' 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '19594' , 'POLO JERSEY COTONE 100%' , '3' , '-3' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '123.00' ) 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 03/10/2025 07:38:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99047' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 03/10/2025 07:43:09 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '12270' 03/10/2025 07:43:09 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '12270'