28/11/2025 08:56:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/11/2025 08:56:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24328' , '1' , '' , 'nuovo-prodotto' ) 28/11/2025 08:56:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24328' , '1' , '1' , '2' , NOW() , NOW() ) 28/11/2025 08:56:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24328' , '0' , '1' , '0' , '0' ) 28/11/2025 08:57:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884249043' AND id_product != '24328' AND ean13 != '' 28/11/2025 08:57:03 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788884249043', date_upd = NOW() WHERE id_product = '24328' 28/11/2025 08:57:03 am >> UPDATE ps_product_lang SET name = 'CONFESSIONI SANT\'AGOSTINO', description = '' WHERE id_product = '24328' 28/11/2025 08:57:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '24328' 28/11/2025 08:57:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24328' 28/11/2025 08:57:03 am >> DELETE FROM ps_specific_price WHERE id_product = '24328' 28/11/2025 08:57:04 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 = '24328' 28/11/2025 08:57:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24329' , '1' , '' , 'nuovo-prodotto' ) 28/11/2025 08:57:04 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 '24329' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24328' 28/11/2025 08:57:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24329' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24328' 28/11/2025 08:57:30 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' , '717599' , '2025-11-26' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.86' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.92' , '133.92' , NOW() , NOW() ) 28/11/2025 08:57: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 = '100134' 28/11/2025 08:57:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100134' 28/11/2025 08:57: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 ( '100134' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '12' , '12' , '4' , '14.00' , '14' , '0' , '33' , '112.5600' ) 28/11/2025 08:57:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 28/11/2025 08:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 28/11/2025 08:57: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 ( '100134' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '100' , '0.0000' ) 28/11/2025 08:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 28/11/2025 08:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 28/11/2025 08:57: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 ( '100134' , '24328' , 'CONFESSIONI SANTAGOSTINO' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 28/11/2025 08:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '24328' AND id_supplier = '7' 28/11/2025 08:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24328' , '7' , '1' ) 28/11/2025 09:48:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 09:48:48 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' , '3955' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '189.38' , NOW() , NOW() ) 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100135' 28/11/2025 09:48:48 am >> DELETE FROM ps_document_detail WHERE id_document = '100135' 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100135' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100135' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100135' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100135' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 28/11/2025 09:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100135' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '108.00' ) 28/11/2025 09:49:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 09:49:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3956' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 28/11/2025 09:49:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100136' 28/11/2025 09:49:29 am >> DELETE FROM ps_document_detail WHERE id_document = '100136' 28/11/2025 09:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100136' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 28/11/2025 10:00:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165327' AND id_product != '24329' AND ean13 != '' 28/11/2025 10:00:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831165327', date_upd = NOW() WHERE id_product = '24329' 28/11/2025 10:00:18 am >> UPDATE ps_product_lang SET name = 'VENITE CON ME - SUSSIDIO', description = '' WHERE id_product = '24329' 28/11/2025 10:00:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '24329' 28/11/2025 10:00:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '13', 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 = '24329' 28/11/2025 10:00:18 am >> DELETE FROM ps_specific_price WHERE id_product = '24329' 28/11/2025 10:00:18 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 = '24329' 28/11/2025 10:00:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24330' , '1' , '' , 'nuovo-prodotto' ) 28/11/2025 10:00:19 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 '24330' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24329' 28/11/2025 10:00:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24330' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24329' 28/11/2025 10:01:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256750764' AND id_product != '24330' AND ean13 != '' 28/11/2025 10:01:50 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791256750764', date_upd = NOW() WHERE id_product = '24330' 28/11/2025 10:01:50 am >> UPDATE ps_product_lang SET name = 'AMORE NON SI BUTTA - FUMAGALLI', description = '' WHERE id_product = '24330' 28/11/2025 10:01:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '24330' 28/11/2025 10:01:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24330' 28/11/2025 10:01:50 am >> DELETE FROM ps_specific_price WHERE id_product = '24330' 28/11/2025 10:01:51 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 = '24330' 28/11/2025 10:01:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24331' , '1' , '' , 'nuovo-prodotto' ) 28/11/2025 10:01:51 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 '24331' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24330' 28/11/2025 10:01:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24331' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24330' 28/11/2025 10:03:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810440131' AND id_product != '24331' AND ean13 != '' 28/11/2025 10:03:01 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788810440131', date_upd = NOW() WHERE id_product = '24331' 28/11/2025 10:03:01 am >> UPDATE ps_product_lang SET name = 'DIO RICALCOLA IL PERCORSO - CURTAZ/RONCHI', description = '' WHERE id_product = '24331' 28/11/2025 10:03:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '24331' 28/11/2025 10:03:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24331' 28/11/2025 10:03:01 am >> DELETE FROM ps_specific_price WHERE id_product = '24331' 28/11/2025 10:03:02 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 = '24331' 28/11/2025 10:03:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24332' , '1' , '' , 'nuovo-prodotto' ) 28/11/2025 10:03:02 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 '24332' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24331' 28/11/2025 10:03:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24332' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24331' 28/11/2025 10:03:28 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' , '00358809' , '2025-11-26' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.70' , '133.70' , NOW() , NOW() ) 28/11/2025 10:03:28 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 = '100137' 28/11/2025 10:03:28 am >> DELETE FROM ps_document_detail WHERE id_document = '100137' 28/11/2025 10:03:28 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 ( '100137' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 28/11/2025 10:03:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '24080' AND id_supplier = '109' 28/11/2025 10:03:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24080' , '109' , '1' ) 28/11/2025 10:03:28 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 ( '100137' , '24329' , 'VENITE CON ME - SUSSIDIO' , '6' , '6' , '4' , '3.90' , '3.9' , '0' , '30' , '16.3800' ) 28/11/2025 10:03:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '24329' AND id_supplier = '109' 28/11/2025 10:03:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24329' , '109' , '1' ) 28/11/2025 10:03:28 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 ( '100137' , '24079' , 'FRANCESCO IL PRIMO ITALIANO - A. CAZZULLO' , '2' , '2' , '4' , '19.50' , '19.5' , '0' , '30' , '27.3000' ) 28/11/2025 10:03:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '24079' AND id_supplier = '109' 28/11/2025 10:03:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24079' , '109' , '1' ) 28/11/2025 10:03:28 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 ( '100137' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '30' , '13.6500' ) 28/11/2025 10:03:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 28/11/2025 10:03:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 28/11/2025 10:03:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24330' , 'AMORE NON SI BUTTA - FUMAGALLI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 28/11/2025 10:03:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '24330' AND id_supplier = '109' 28/11/2025 10:03:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24330' , '109' , '1' ) 28/11/2025 10:03:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24331' , 'DIO RICALCOLA IL PERCORSO - CURTAZ/RONCHI' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '33' , '6.3650' ) 28/11/2025 10:03:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '24331' AND id_supplier = '109' 28/11/2025 10:03:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24331' , '109' , '1' ) 28/11/2025 10:03:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '2' , '2' , '4' , '35.00' , '35' , '0' , '33' , '46.9000' ) 28/11/2025 10:03:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '22283' AND id_supplier = '109' 28/11/2025 10:03:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22283' , '109' , '1' ) 28/11/2025 10:07:17 am >> UPDATE ps_document SET id_document_type = '33', document_num = '00358809', document_date = '2025-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '139.16', price_tax_excluded = '139.16', date_upd = NOW() WHERE id_document = '100137' 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100137' 28/11/2025 10:07:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100137' 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24329' , 'VENITE CON ME - SUSSIDIO' , '8' , '8' , '4' , '3.9000' , '3.9' , '0' , '30' , '21.8400' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24079' , 'FRANCESCO IL PRIMO ITALIANO - A. CAZZULLO' , '2' , '2' , '4' , '19.5000' , '19.5' , '0' , '30' , '27.30' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '1' , '4' , '19.5000' , '19.5' , '0' , '30' , '13.65' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24330' , 'AMORE NON SI BUTTA - FUMAGALLI' , '1' , '1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '24331' , 'DIO RICALCOLA IL PERCORSO - CURTAZ/RONCHI' , '1' , '1' , '4' , '9.5000' , '9.5' , '0' , '33' , '6.37' ) 28/11/2025 10:07:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100137' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '33' , '46.90' ) 28/11/2025 10:33:25 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' , '3064' , '2025-11-25' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.87' , '127.76' , NOW() , NOW() ) 28/11/2025 10:33:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100138' 28/11/2025 10:33:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100138' 28/11/2025 10:33:25 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 ( '100138' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '900' , '900' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '100.2035' ) 28/11/2025 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '6325' AND id_supplier = '43' 28/11/2025 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6325' , '43' , '1' ) 28/11/2025 10:33:25 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 ( '100138' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '500' , '500' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '55.6686' ) 28/11/2025 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '6354' AND id_supplier = '43' 28/11/2025 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6354' , '43' , '1' ) 28/11/2025 10:38:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 10:38:08 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' , '3957' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 28/11/2025 10:38:08 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 = '100139' 28/11/2025 10:38:08 am >> DELETE FROM ps_document_detail WHERE id_document = '100139' 28/11/2025 10:38:08 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 ( '100139' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '45.00' ) 28/11/2025 10:40:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 10:40: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' , '3958' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.70' , '5.76' , NOW() , NOW() ) 28/11/2025 10:40: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 = '100140' 28/11/2025 10:40:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100140' 28/11/2025 10:40: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 ( '100140' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 28/11/2025 10:40: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 ( '100140' , '12904' , 'NOVENA DELLE ROSE A S. TERESA LISIEUX - 8848' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 28/11/2025 10:40:55 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 ( '100140' , '6331' , 'MEDAGLIA OVALE DECORATA - MIRACOLOSA - G011.3' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 28/11/2025 10:52:39 am >> UPDATE ps_document SET id_document_type = '33', document_num = '3064', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', 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 = '189.44', price_tax_excluded = '155.28', date_upd = NOW() WHERE id_document = '100138' 28/11/2025 10:52: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 = '100138' 28/11/2025 10:52:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100138' 28/11/2025 10:52: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 ( '100138' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '900' , '900' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '100.20' ) 28/11/2025 10:52: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 ( '100138' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '500' , '500' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '55.67' ) 28/11/2025 10:52: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 ( '100138' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.57' , '4.5655737704918' , '22' , '10' , '6.1159' ) 28/11/2025 10:52: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 ( '100138' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '100' , '100' , '1' , '0.25' , '0.20491803278689' , '22' , '10' , '27.4500' ) 28/11/2025 10:57:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 10:57: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' , '3959' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.80' , '82.56' , NOW() , NOW() ) 28/11/2025 10:57: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 = '100141' 28/11/2025 10:57:47 am >> DELETE FROM ps_document_detail WHERE id_document = '100141' 28/11/2025 10:57: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 ( '100141' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 28/11/2025 10:57: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 ( '100141' , '24280' , 'BAMBINO CM 30 - PB15944' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 28/11/2025 10:57: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 ( '100141' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/11/2025 10:57: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 ( '100141' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 28/11/2025 10:57: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 ( '100141' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 28/11/2025 11:04:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000024' AND id_product != '17052' AND ean13 != '' 28/11/2025 11:04:33 am >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '000024', date_upd = NOW() WHERE id_product = '17052' 28/11/2025 11:04:33 am >> UPDATE ps_product_lang SET name = 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382', description = '' WHERE id_product = '17052' 28/11/2025 11:04:33 am >> UPDATE ps_product SET wholesale_price = '0.24', on_sale = '0', price = '0.5738' WHERE id_product = '17052' 28/11/2025 11:04:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.24', price = '0.5738', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17052' 28/11/2025 11:04:33 am >> DELETE FROM ps_specific_price WHERE id_product = '17052' 28/11/2025 11:07:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846182228' AND id_product != '22737' AND ean13 != '' 28/11/2025 11:07:25 am >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846182228', date_upd = NOW() WHERE id_product = '22737' 28/11/2025 11:07:25 am >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO ARG - RA812', description = '' WHERE id_product = '22737' 28/11/2025 11:07:25 am >> UPDATE ps_product SET wholesale_price = '7.74', on_sale = '0', price = '20.491803278688526' WHERE id_product = '22737' 28/11/2025 11:07:25 am >> UPDATE ps_product_shop SET wholesale_price = '7.74', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22737' 28/11/2025 11:07:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22737' 28/11/2025 11:16:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846276385' AND id_product != '24332' AND ean13 != '' 28/11/2025 11:16:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846276385', date_upd = NOW() WHERE id_product = '24332' 28/11/2025 11:16:08 am >> UPDATE ps_product_lang SET name = 'ICONA SERIGRAFATA MADONNA - K095.D ', description = '' WHERE id_product = '24332' 28/11/2025 11:16:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '24332' 28/11/2025 11:16:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24332' 28/11/2025 11:16:08 am >> DELETE FROM ps_specific_price WHERE id_product = '24332' 28/11/2025 11:18:17 am >> UPDATE ps_document SET id_document_type = '33', document_num = '3064', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', 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 = '335.98', price_tax_excluded = '275.39', date_upd = NOW() WHERE id_document = '100138' 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100138' 28/11/2025 11:18:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100138' 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '900' , '900' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '100.20' ) 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '500' , '500' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '55.67' ) 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.5700' , '4.5655737704918' , '22' , '10' , '6.12' ) 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '100' , '100' , '1' , '0.25' , '0.20491803278689' , '22' , '10' , '27.4500' ) 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '100' , '100' , '1' , '0.1273' , '0.10434426229508' , '22' , '10' , '13.9775' ) 28/11/2025 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100138' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '1' , '1' , '12.73' , '10.434426229508' , '22' , '10' , '13.9775' ) 28/11/2025 11:18:18 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 ( '100138' , '21858' , 'ANELLO S. LUCIA' , '300' , '300' , '1' , '0.24' , '0.19672131147541' , '22' , '10' , '79.0560' ) 28/11/2025 11:18:18 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 ( '100138' , '24087' , 'ICONA GRECA SERIGRAFATA 23X18 - K096.A' , '1' , '1' , '1' , '20.7' , '16.967213114754' , '22' , '10' , '22.7286' ) 28/11/2025 11:18:18 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 ( '100138' , '24332' , 'ICONA SERIGRAFATA MADONNA - K095.D ' , '1' , '1' , '1' , '15.3' , '12.540983606557' , '22' , '10' , '16.7994' ) 28/11/2025 11:39:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 11:39:31 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' , '3960' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.59' , NOW() , NOW() ) 28/11/2025 11:39:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100142' 28/11/2025 11:39:31 am >> DELETE FROM ps_document_detail WHERE id_document = '100142' 28/11/2025 11:39: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 ( '100142' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 28/11/2025 11:39: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 ( '100142' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '' , '3.00' ) 28/11/2025 12:21:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2680' , '2025-11-28' , '' , '0' , '0' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '14.49' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '362.16' , '296.85' , NOW() , NOW() ) 28/11/2025 12:21: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 = '100143' 28/11/2025 12:21:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100143' 28/11/2025 12:21: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 ( '100143' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '1000' , '0' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '111.3372' ) 28/11/2025 12:21: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 ( '100143' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '500' , '0' , '1' , '0.1014' , '0.083114754098361' , '22' , '10' , '55.6686' ) 28/11/2025 12:21: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 ( '100143' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '0' , '1' , '5.5700' , '4.5656' , '22' , '10' , '6.12' ) 28/11/2025 12:21: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 ( '100143' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '100' , '0' , '1' , '0.2500' , '0.2049' , '22' , '10' , '27.45' ) 28/11/2025 12:21: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 ( '100143' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '100' , '0' , '1' , '0.1273' , '0.1043' , '22' , '10' , '13.98' ) 28/11/2025 12:21: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 ( '100143' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '0' , '1' , '10.32' , '8.4590163934426' , '22' , '10' , '11.3314' ) 28/11/2025 12:21: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 ( '100143' , '21858' , 'ANELLO S. LUCIA' , '300' , '0' , '1' , '0.2400' , '0.1967' , '22' , '10' , '79.06' ) 28/11/2025 12:21: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 ( '100143' , '24087' , 'ICONA GRECA SERIGRAFATA 23X18 - K096.A' , '1' , '0' , '1' , '20.7000' , '16.9672' , '22' , '10' , '22.73' ) 28/11/2025 12:21: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 ( '100143' , '24332' , 'ICONA SERIGRAFATA MADONNA - K095.D ' , '1' , '0' , '1' , '15.3000' , '12.541' , '22' , '10' , '16.80' ) 28/11/2025 12:29:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 12:29:05 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' , '3961' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.30' , '27.30' , NOW() , NOW() ) 28/11/2025 12:29:05 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 = '100144' 28/11/2025 12:29:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '100144' 28/11/2025 12:29:05 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 ( '100144' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' ) 28/11/2025 12:29:05 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 ( '100144' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/11/2025 12:29:05 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 ( '100144' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/11/2025 12:29:05 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 ( '100144' , '13316' , 'SEGNALIBRI E NATALE - 120' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 28/11/2025 12:30:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 12:30:35 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' , '3962' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.68' , '29.68' , NOW() , NOW() ) 28/11/2025 12:30:35 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 = '100145' 28/11/2025 12:30:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '100145' 28/11/2025 12:30:35 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 ( '100145' , '24329' , 'VENITE CON ME - SUSSIDIO' , '8' , '-8' , '4' , '3.90' , '3.9' , '0' , '5' , '29.68' ) 28/11/2025 12:33:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 12:33: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' , '3963' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.45' , '29.45' , NOW() , NOW() ) 28/11/2025 12:33: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 = '100146' 28/11/2025 12:33:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100146' 28/11/2025 12:33: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 ( '100146' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/11/2025 12:33: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 ( '100146' , '24146' , 'INFERNO CHE TRISTEZZA - M. BOTTA' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 28/11/2025 12:52:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3964' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 12:52:17 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' , '3964' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 28/11/2025 12:52:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100147' 28/11/2025 12:52:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100147' 28/11/2025 12:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100147' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 28/11/2025 12:52:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100147' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 28/11/2025 12:53:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 12:53:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3965' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.75' , '67.05' , NOW() , NOW() ) 28/11/2025 12:53:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100148' 28/11/2025 12:53:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '100148' 28/11/2025 12:53:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100148' , '6811' , 'MOCCOLO 80X200' , '8' , '-8' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '76.00' ) 28/11/2025 12:53:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100148' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/11/2025 02:11:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801031119' AND id_product != '7385' AND ean13 != '' 28/11/2025 02:11:33 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801031119', date_upd = NOW() WHERE id_product = '7385' 28/11/2025 02:11:33 pm >> UPDATE ps_product_lang SET name = 'SAN PIO DA PIETRELCINA - L. DA FARA', description = '' WHERE id_product = '7385' 28/11/2025 02:11:33 pm >> UPDATE ps_product SET wholesale_price = '2.50', on_sale = '0', price = '5.0000' WHERE id_product = '7385' 28/11/2025 02:11:33 pm >> UPDATE ps_product_shop SET wholesale_price = '2.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7385' 28/11/2025 02:11:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '7385' 28/11/2025 03:14:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 03:14:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3966' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 28/11/2025 03:14:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100149' 28/11/2025 03:14:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100149' 28/11/2025 03:14:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100149' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 28/11/2025 03:14:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100149' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.1' , '2.5409836065574' , '22' , '0' , '3.10' ) 28/11/2025 03:46:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3967' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 03:46:58 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' , '3967' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.44' , '189.03' , NOW() , NOW() ) 28/11/2025 03:46:58 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 = '100150' 28/11/2025 03:46:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100150' 28/11/2025 03:46:58 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 ( '100150' , '10748' , 'TU MI CHIAMI PER NOME' , '24' , '-24' , '4' , '6.90' , '6.9' , '0' , '5' , '157.44' ) 28/11/2025 03:46:58 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 ( '100150' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 28/11/2025 03:46:58 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 ( '100150' , '23258' , 'MARIA PORTA DEL CIELO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 28/11/2025 03:46:58 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 ( '100150' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/11/2025 04:02:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '280' 28/11/2025 04:02:51 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '280' , '10' , '210' , 'PARR. SAN GIACOMO MAGG. AP.' , 'CIRILLO ' , 'DON ALESSANDRO' , 'P.ZZA AMENDOLA 1' , '' , '84010' , 'SAN VALENTINO TORIO' , '' , '081 5187122' , '' , '' , '80008450654' , NOW() , NOW() ) 28/11/2025 04:02:51 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '280' 28/11/2025 04:16:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3968' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 04:16: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' , '3968' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 28/11/2025 04:16: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 = '100151' 28/11/2025 04:16:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '100151' 28/11/2025 04:16: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 ( '100151' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9' , '7.3770491803279' , '22' , '0' , '36.00' ) 28/11/2025 04:17:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3969' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 04:17: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' , '3969' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 28/11/2025 04:17: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 = '100152' 28/11/2025 04:17:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100152' 28/11/2025 04:17: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 ( '100152' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 28/11/2025 04:59:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3970' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 04:59:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3970' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 28/11/2025 04:59: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 = '100153' 28/11/2025 04:59:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100153' 28/11/2025 04:59:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100153' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 28/11/2025 05:17:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 05:17:31 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' , '3971' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.40' , '10.40' , NOW() , NOW() ) 28/11/2025 05:17:31 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 = '100154' 28/11/2025 05:17:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '100154' 28/11/2025 05:17:31 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 ( '100154' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 28/11/2025 05:17:31 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 ( '100154' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/11/2025 05:40:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3972' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 05:40:04 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' , '3972' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 28/11/2025 05:40:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100155' 28/11/2025 05:40:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '100155' 28/11/2025 05:40: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 ( '100155' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '-1' , '1' , '115.00' , '94.262295081967' , '22' , '0' , '115.00' ) 28/11/2025 06:43:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025010001966' , '2025-11-28' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.35' , '77.35' , NOW() , NOW() ) 28/11/2025 06:43:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100156' 28/11/2025 06:43:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100156' 28/11/2025 06:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24223' , 'PRESENZA REALE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 28/11/2025 06:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24223' AND id_supplier = '107' 28/11/2025 06:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24223' , '107' , '1' ) 28/11/2025 06:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24224' , 'LEONE XIV CHI DITE - INGRAO/PAGANO' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '35' , '11.05' ) 28/11/2025 06:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24224' AND id_supplier = '107' 28/11/2025 06:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24224' , '107' , '1' ) 28/11/2025 06:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24225' , 'FRANCESCO MAESTRO E FRATELLO - G. CESAREO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 28/11/2025 06:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24225' AND id_supplier = '107' 28/11/2025 06:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24225' , '107' , '1' ) 28/11/2025 06:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24226' , 'INTRODUZIONE ALLA ECCLESIOLOGIA - G. MILITELLO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 28/11/2025 06:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24226' AND id_supplier = '107' 28/11/2025 06:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24226' , '107' , '1' ) 28/11/2025 06:43:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24227' , 'RISVOLTI TEOLOGICI DELLA CARITA S. VINCENZO DE PAOLI - G. MARTINELLI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 28/11/2025 06:43:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24227' AND id_supplier = '107' 28/11/2025 06:43:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24227' , '107' , '1' ) 28/11/2025 06:43:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24229' , 'RITORNELLI SALMI RESPONSORIALI ANNO A - A. CIMINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 28/11/2025 06:43:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24229' AND id_supplier = '107' 28/11/2025 06:43:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24229' , '107' , '1' ) 28/11/2025 06:43:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24230' , 'RITORNELLI SALMI RESPONSORIALI ANNO B - A. CIMINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 28/11/2025 06:43:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24230' AND id_supplier = '107' 28/11/2025 06:43:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24230' , '107' , '1' ) 28/11/2025 06:43:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100156' , '24228' , 'RITORNELLI SALMI RESPONSORIALI ANNO C - A. CIMINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 28/11/2025 06:43:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24228' AND id_supplier = '107' 28/11/2025 06:43:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24228' , '107' , '1' ) 28/11/2025 06:52:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 06:52: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' , '3973' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 28/11/2025 06:52: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 = '100157' 28/11/2025 06:52:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100157' 28/11/2025 06:52: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 ( '100157' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '28.50' ) 28/11/2025 06:52: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 ( '100157' , '21137' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/11/2025 06:55:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 06:55:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3974' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 28/11/2025 06:55:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100158' 28/11/2025 06:55:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '100158' 28/11/2025 06:55:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100158' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/11/2025 07:08:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 07:08: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' , '3975' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 28/11/2025 07:08: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 = '100159' 28/11/2025 07:08:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '100159' 28/11/2025 07:08: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 ( '100159' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 28/11/2025 07:10:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 07:10:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3976' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/11/2025 07:10:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100160' 28/11/2025 07:10:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100160' 28/11/2025 07:10:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100160' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/11/2025 07:17:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 07:17: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' , '3977' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.49' , '26.63' , NOW() , NOW() ) 28/11/2025 07:17: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 = '100161' 28/11/2025 07:17:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100161' 28/11/2025 07:17: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 ( '100161' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 28/11/2025 07:17: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 ( '100161' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 28/11/2025 07:30:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '146/A' AND id_document != '100116' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 28/11/2025 07:30:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '146/A', document_date = '2025-11-27', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '253.95', price_tax_excluded = '216.89', date_upd = NOW() WHERE id_document = '100116' 28/11/2025 07:30: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 = '100116' 28/11/2025 07:30:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '100116' 28/11/2025 07:30: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 ( '100116' , '23990' , 'DI PASQUA IN PASQUA - F. ROSINI' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 28/11/2025 07:30: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 ( '100116' , '24326' , 'IO SONO COME GUARDO - L.M. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 28/11/2025 07:30:47 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 ( '100116' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 28/11/2025 07:30:47 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 ( '100116' , '6810' , 'MOCCOLO 80X150' , '4' , '-4' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '28.00' ) 28/11/2025 07:30:47 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 ( '100116' , '19345' , 'BALZA IN RASO H CM 19 - P456' , '7.5' , '-7.5' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '172.50' ) 28/11/2025 08:01:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 28/11/2025 08:01: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' , '3978' , '2025-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.96' , '32.75' , NOW() , NOW() ) 28/11/2025 08:01: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 = '100162' 28/11/2025 08:01:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '100162' 28/11/2025 08:01: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 ( '100162' , '17617' , 'IMMAGINI ISONZO X 100' , '12' , '-12' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '39.96' )