09/12/2025 09:38:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 09:38:38 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' , '4114' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '10.26' , NOW() , NOW() ) 09/12/2025 09:38:38 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 = '100332' 09/12/2025 09:38:38 am >> DELETE FROM ps_document_detail WHERE id_document = '100332' 09/12/2025 09:38:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100332' , '14062' , 'STELLARIO PLEX CM 8' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 09/12/2025 09:38:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100332' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 09/12/2025 09:46:04 am >> SELECT document_num FROM ps_document WHERE document_num = '4115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 09:46:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4115' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 09/12/2025 09:46:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100333' 09/12/2025 09:46:04 am >> DELETE FROM ps_document_detail WHERE id_document = '100333' 09/12/2025 09:46:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100333' , '23940' , 'ROSARIO CON PADRE PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/12/2025 09:55:40 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/12/2025 09:55:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24398' , '1' , '' , 'nuovo-prodotto' ) 09/12/2025 09:55:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24398' , '1' , '1' , '2' , NOW() , NOW() ) 09/12/2025 09:55:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24398' , '0' , '1' , '0' , '0' ) 09/12/2025 09:56:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892248304' AND id_product != '24398' AND ean13 != '' 09/12/2025 09:56:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892248304', date_upd = NOW() WHERE id_product = '24398' 09/12/2025 09:56:08 am >> UPDATE ps_product_lang SET name = 'AMEN - MAR 26', description = '' WHERE id_product = '24398' 09/12/2025 09:56:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '24398' 09/12/2025 09:56:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24398' 09/12/2025 09:56:08 am >> DELETE FROM ps_specific_price WHERE id_product = '24398' 09/12/2025 09:56:10 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24398' 09/12/2025 09:56:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24399' , '1' , '' , 'nuovo-prodotto' ) 09/12/2025 09:56:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24399' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24398' 09/12/2025 09:56:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24399' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24398' 09/12/2025 09:56:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892248311' AND id_product != '24399' AND ean13 != '' 09/12/2025 09:56:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892248311', date_upd = NOW() WHERE id_product = '24399' 09/12/2025 09:56:25 am >> UPDATE ps_product_lang SET name = 'AMEN - APR 26', description = '' WHERE id_product = '24399' 09/12/2025 09:56:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '24399' 09/12/2025 09:56:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24399' 09/12/2025 09:56:25 am >> DELETE FROM ps_specific_price WHERE id_product = '24399' 09/12/2025 09:56:26 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 = '24399' 09/12/2025 09:56:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24400' , '1' , '' , 'nuovo-prodotto' ) 09/12/2025 09:56:26 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 '24400' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24399' 09/12/2025 09:56:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24400' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24399' 09/12/2025 09:57:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826610498' AND id_product != '24400' AND ean13 != '' 09/12/2025 09:57:04 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788826610498', date_upd = NOW() WHERE id_product = '24400' 09/12/2025 09:57:04 am >> UPDATE ps_product_lang SET name = 'MATER POPULI FIDELIS', description = '' WHERE id_product = '24400' 09/12/2025 09:57:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '24400' 09/12/2025 09:57:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24400' 09/12/2025 09:57:04 am >> DELETE FROM ps_specific_price WHERE id_product = '24400' 09/12/2025 09:57:05 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 = '24400' 09/12/2025 09:57:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24401' , '1' , '' , 'nuovo-prodotto' ) 09/12/2025 09:57:05 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 '24401' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24400' 09/12/2025 09:57:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24401' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24400' 09/12/2025 09:58: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 ( '33' , '718549' , '2025-12-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '9.76' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '372.50' , '372.50' , NOW() , NOW() ) 09/12/2025 09:58: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 = '100334' 09/12/2025 09:58:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100334' 09/12/2025 09:58: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 ( '100334' , '2048' , 'CHRISTIFIDELES LAICI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '33' , '5.3600' ) 09/12/2025 09:58:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 09/12/2025 09:58:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '2' , '2' , '4' , '90.00' , '90' , '0' , '15' , '153.0000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '8274' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8274' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '1' , '4' , '38.00' , '38' , '0' , '30' , '26.6000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '8275' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8275' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24398' , 'AMEN - MAR 26' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24398' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24398' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24398' , 'AMEN - MAR 26' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24398' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24398' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24399' , 'AMEN - APR 26' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24399' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24399' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24399' , 'AMEN - APR 26' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24399' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24399' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24400' , 'MATER POPULI FIDELIS' , '12' , '12' , '4' , '3.90' , '3.9' , '0' , '30' , '32.7600' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24400' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24400' , '7' , '1' ) 09/12/2025 09:58: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 ( '100334' , '24400' , 'MATER POPULI FIDELIS' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 09/12/2025 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24400' AND id_supplier = '7' 09/12/2025 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24400' , '7' , '1' ) 09/12/2025 10:01:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280783615' AND id_product != '24401' AND ean13 != '' 09/12/2025 10:01:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280783615', date_upd = NOW() WHERE id_product = '24401' 09/12/2025 10:01:40 am >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO - GEN FEB 26', description = '' WHERE id_product = '24401' 09/12/2025 10:01:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '24401' 09/12/2025 10:01:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '343', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24401' 09/12/2025 10:01:40 am >> DELETE FROM ps_specific_price WHERE id_product = '24401' 09/12/2025 10:01:41 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 = '24401' 09/12/2025 10:01:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24402' , '1' , '' , 'nuovo-prodotto' ) 09/12/2025 10:01:41 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 '24402' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24401' 09/12/2025 10:01:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24402' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24401' 09/12/2025 10:02:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '718406' , '2025-12-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '10.96' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '414.90' , '411.71' , NOW() , NOW() ) 09/12/2025 10:02:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100335' 09/12/2025 10:02:46 am >> DELETE FROM ps_document_detail WHERE id_document = '100335' 09/12/2025 10:02:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100335' , '24201' , 'PORTA IL DONO' , '114' , '114' , '4' , '2.80' , '2.8' , '0' , '30+5' , '212.2680' ) 09/12/2025 10:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '24201' AND id_supplier = '7' 09/12/2025 10:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24201' , '7' , '1' ) 09/12/2025 10:02: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 ( '100335' , '23984' , 'AGENDA 2026' , '3' , '3' , '1' , '4.83' , '3.9590163934426' , '22' , '0' , '17.6778' ) 09/12/2025 10:02:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '23984' AND id_supplier = '7' 09/12/2025 10:02:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23984' , '7' , '1' ) 09/12/2025 10:02: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 ( '100335' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '2' , '2' , '4' , '90.00' , '90' , '0' , '15' , '153.0000' ) 09/12/2025 10:02:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5775' AND id_supplier = '7' 09/12/2025 10:02:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5775' , '7' , '1' ) 09/12/2025 10:02: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 ( '100335' , '17378' , 'FRATELLI TUTTI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '33' , '3.3500' ) 09/12/2025 10:02:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '17378' AND id_supplier = '7' 09/12/2025 10:02:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17378' , '7' , '1' ) 09/12/2025 10:02: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 ( '100335' , '23998' , 'PENSIERI EUCARISTICI 2026' , '3' , '3' , '4' , '6.90' , '6.9' , '0' , '30' , '14.4900' ) 09/12/2025 10:02:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '23998' AND id_supplier = '7' 09/12/2025 10:02:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23998' , '7' , '1' ) 09/12/2025 10:02: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 ( '100335' , '24401' , 'PANE QUOTIDIANO - GEN FEB 26' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '30' , '3.1500' ) 09/12/2025 10:02:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '24401' AND id_supplier = '7' 09/12/2025 10:02:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24401' , '7' , '1' ) 09/12/2025 10:04:09 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '9ze7vI01wKHb5iVQ' , NOW() , NOW() ) 09/12/2025 10:04:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4294' , '1' ) 09/12/2025 10:04:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4294' , '2' ) 09/12/2025 10:04:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4294' , '3' ) 09/12/2025 10:05:23 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4294' 09/12/2025 10:05:23 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 ( '4294' , '10' , '210' , '' , 'ABITABILE' , 'DON PASQUALE ' , 'SALITA SOTTOPORTICO S. ANDREA 7' , '' , '84011' , 'AMALFI' , 'GIOVANNI FUSCO 3494128353' , '' , '' , '' , '' , NOW() , NOW() ) 09/12/2025 10:05:23 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4294' 09/12/2025 10:06:39 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4294' 09/12/2025 10:06:39 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 ( '4294' , '10' , '210' , '' , 'ABITABILE' , 'DON PASQUALE ' , 'SALITA SOTTOPORTICO S. ANDREA 7' , '' , '84011' , 'AMALFI' , 'GIOVANNI FUSCO 3494128353' , '' , '' , '' , '' , NOW() , NOW() ) 09/12/2025 10:06:39 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4294' 09/12/2025 10:07:10 am >> SELECT document_num FROM ps_document WHERE document_num = '153/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 10:07:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '153/A' , '2025-12-09' , 'A' , '4294' , '0' , '4679674' , 'SALITA SOTTOPORTICO S. ANDREA 7 84011 AMALFI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '322.00' , '322.00' , NOW() , NOW() ) 09/12/2025 10:07: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 = '100336' 09/12/2025 10:07:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100336' 09/12/2025 10:07: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 ( '100336' , '24201' , 'PORTA IL DONO' , '115' , '-115' , '4' , '2.80' , '2.8' , '0' , '0' , '322.00' ) 09/12/2025 10:35:23 am >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 10:35:23 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' , '4116' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '35.49' , NOW() , NOW() ) 09/12/2025 10:35:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100337' 09/12/2025 10:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '100337' 09/12/2025 10:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100337' , '23188' , 'GRUPPO NATIVITA CAMPANA CON LUCI - PB20515' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 09/12/2025 10:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100337' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 09/12/2025 10:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100337' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 09/12/2025 10:37:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 10:37:49 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' , '4117' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '116.05' , NOW() , NOW() ) 09/12/2025 10:37:49 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 = '100338' 09/12/2025 10:37:49 am >> DELETE FROM ps_document_detail WHERE id_document = '100338' 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.6' , '8.6885245901639' , '22' , '0' , '10.60' ) 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/12/2025 10:37:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100338' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/12/2025 10:38:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 10:38:59 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' , '4118' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 09/12/2025 10:38:59 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 = '100339' 09/12/2025 10:38:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100339' 09/12/2025 10:38:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100339' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 09/12/2025 10:39:36 am >> DELETE FROM ps_document WHERE id_document = '100339' 09/12/2025 10:39:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100339' 09/12/2025 10:39:50 am >> SELECT document_num FROM ps_document WHERE document_num = '4118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 10:39:50 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' , '4118' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 09/12/2025 10:39:50 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 = '100340' 09/12/2025 10:39:50 am >> DELETE FROM ps_document_detail WHERE id_document = '100340' 09/12/2025 10:39:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100340' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 09/12/2025 11:02:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 11:02:18 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' , '4119' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/12/2025 11:02:18 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 = '100341' 09/12/2025 11:02:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100341' 09/12/2025 11:02: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 ( '100341' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/12/2025 11:16:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 11:16:59 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' , '4120' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 09/12/2025 11:16:59 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 = '100342' 09/12/2025 11:16:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100342' 09/12/2025 11:16:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100342' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 09/12/2025 11:31:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 11:31:09 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' , '4121' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.30' , '95.82' , NOW() , NOW() ) 09/12/2025 11:31:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100343' 09/12/2025 11:31:09 am >> DELETE FROM ps_document_detail WHERE id_document = '100343' 09/12/2025 11:31:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100343' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/12/2025 11:31:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100343' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/12/2025 11:38:31 am >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 11:38: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 ( '21' , '271' , '2025-12-09' , '' , '2755' , '0' , '4679629' , 'VIA APPIA 1425 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '92.73' , '92.73' , NOW() , NOW() ) 09/12/2025 11:38: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 = '100344' 09/12/2025 11:38:31 am >> DELETE FROM ps_document_detail WHERE id_document = '100344' 09/12/2025 11:38: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 ( '100344' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/12/2025 11:38: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 ( '100344' , '18357' , 'MIE PREGHIERINE N.E.' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '5' , '2.85' ) 09/12/2025 11:38: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 ( '100344' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 09/12/2025 11:38: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 ( '100344' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 09/12/2025 11:38: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 ( '100344' , '23347' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.80' ) 09/12/2025 11:38: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 ( '100344' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/12/2025 11:38: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 ( '100344' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/12/2025 11:38: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 ( '100344' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '24097' , 'AVVENTO E NATALE 2025 - BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.75' ) 09/12/2025 11:38: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 ( '100344' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 09/12/2025 11:38: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 ( '100344' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 09/12/2025 11:38: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 ( '100344' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 09/12/2025 11:38: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 ( '100344' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 09/12/2025 11:38: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 ( '100344' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 11:38: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 ( '100344' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 09/12/2025 11:38: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 ( '100344' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 09/12/2025 11:38: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 ( '100344' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 09/12/2025 11:38: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 ( '100344' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 09/12/2025 11:38: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 ( '100344' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 09/12/2025 11:38: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 ( '100344' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '0' , '0.45' , '0.45' , '' , '0' , '22.50' ) 09/12/2025 11:57:00 am >> SELECT document_num FROM ps_document WHERE document_num = '153/A' AND id_document != '100336' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 11:57:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '153/A', document_date = '2025-12-09', document_letter = 'A', id_customer = '4294', id_supplier = '', id_address = '4679674', address1 = 'SALITA SOTTOPORTICO S. ANDREA 7 84011 AMALFI', 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 = '305.90', price_tax_excluded = '305.90', date_upd = NOW() WHERE id_document = '100336' 09/12/2025 11:57:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100336' 09/12/2025 11:57:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100336' 09/12/2025 11:57:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100336' , '24201' , 'PORTA IL DONO' , '115' , '-115' , '4' , '2.8000' , '2.8' , '0' , '5' , '305.90' ) 09/12/2025 12:05:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 12:05:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4122' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.00' , '67.21' , NOW() , NOW() ) 09/12/2025 12:05: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 = '100345' 09/12/2025 12:05:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100345' 09/12/2025 12:05: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 ( '100345' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '82.00' , '67.213114754098' , '22' , '0' , '82.00' ) 09/12/2025 12:33:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 12:33:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4123' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 09/12/2025 12:33: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 = '100346' 09/12/2025 12:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100346' 09/12/2025 12:33: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 ( '100346' , '19076' , 'NATIVITA\' 5 PEZZI CM 30 - PB8026' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 09/12/2025 12:42:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 12:42:02 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' , '4124' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 09/12/2025 12:42:02 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 = '100347' 09/12/2025 12:42:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '100347' 09/12/2025 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100347' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '220.00' , '180.32786885246' , '22' , '0' , '220.00' ) 09/12/2025 12:45:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 12:45:13 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' , '4125' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 09/12/2025 12:45:13 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 = '100348' 09/12/2025 12:45:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100348' 09/12/2025 12:45:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100348' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 09/12/2025 12:58:30 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' , '936' , '2025-12-04' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.72' , '126.00' , NOW() , NOW() ) 09/12/2025 12:58:30 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 = '100349' 09/12/2025 12:58:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '100349' 09/12/2025 12:58:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100349' , '19357' , 'DALMATICA ROSA - AEDA01' , '2' , '2' , '1' , '42' , '34.426229508197' , '22' , '0' , '102.4800' ) 09/12/2025 12:58:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19357' AND id_supplier = '122' 09/12/2025 12:58:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19357' , '122' , '1' ) 09/12/2025 12:58:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100349' , '14926' , 'VESTINA BATTESIMALE' , '20' , '20' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '51.2400' ) 09/12/2025 12:58:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '122' 09/12/2025 12:58:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '122' , '1' ) 09/12/2025 02:36:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '4114' AND id_document != '100332' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 02:36:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4114', document_date = '2025-12-09', 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 = '12.00', price_tax_excluded = '10.26', date_upd = NOW() WHERE id_document = '100332' 09/12/2025 02:36: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 = '100332' 09/12/2025 02:36:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '100332' 09/12/2025 02:36: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 ( '100332' , '14062' , 'STELLARIO PLEX CM 8' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 09/12/2025 02:36: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 ( '100332' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 09/12/2025 03:01:55 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4294' 09/12/2025 03:01:55 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 ( '4294' , '10' , '210' , '' , 'AVITABILE' , 'DON PASQUALE ' , 'SALITA SOTTOPORTICO S. ANDREA 7' , '' , '84011' , 'AMALFI' , 'GIOVANNI FUSCO 3494128353' , '' , '' , '' , '' , NOW() , NOW() ) 09/12/2025 03:01:55 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4294' 09/12/2025 03:36:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 03:36:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4126' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '305.90' , '305.90' , NOW() , NOW() ) 09/12/2025 03:36:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100350' 09/12/2025 03:36:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100350' 09/12/2025 03:36:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100350' , '24201' , 'PORTA IL DONO' , '115' , '-115' , '4' , '2.80' , '2.8' , '0' , '5' , '305.90' ) 09/12/2025 04:26:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 04:26:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4127' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '282.00' , '256.68' , NOW() , NOW() ) 09/12/2025 04:26: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 = '100351' 09/12/2025 04:26:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100351' 09/12/2025 04:26: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 ( '100351' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 09/12/2025 04:26: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 ( '100351' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 09/12/2025 04:26: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 ( '100351' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '140.00' ) 09/12/2025 04:45:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 04:45:19 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' , '4128' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.50' , '142.50' , NOW() , NOW() ) 09/12/2025 04:45:19 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 = '100352' 09/12/2025 04:45:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100352' 09/12/2025 04:45:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100352' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '5' , '142.50' ) 09/12/2025 04:50:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4294' 09/12/2025 04:50:07 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 ( '4294' , '10' , '210' , '' , 'AVITABILE' , 'DON PASQUALE ' , 'SUPPORTICO S. ANDREA 7' , '' , '84011' , 'AMALFI' , 'GIOVANNI FUSCO 3494128353' , '' , '' , '' , '' , NOW() , NOW() ) 09/12/2025 04:50:07 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4294' 09/12/2025 05:16:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 05:16:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4129' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.80' , '62.95' , NOW() , NOW() ) 09/12/2025 05:16:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100353' 09/12/2025 05:16:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100353' 09/12/2025 05:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100353' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 09/12/2025 05:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100353' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '1' , '12.90' , '10.573770491803' , '22' , '0' , '25.80' ) 09/12/2025 05:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100353' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '22' , '-22' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '44.00' ) 09/12/2025 05:23:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 05:23:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4130' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '50.30' , NOW() , NOW() ) 09/12/2025 05:23:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100354' 09/12/2025 05:23:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100354' 09/12/2025 05:23: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 ( '100354' , '7202' , 'ARTICOLI RELIGIOSI' , '12' , '-12' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '34.80' ) 09/12/2025 05:23: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 ( '100354' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 09/12/2025 05:23: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 ( '100354' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 09/12/2025 05:23: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 ( '100354' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '11.00' ) 09/12/2025 05:23: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 ( '100354' , '17432' , 'SANTA LUCIA' , '1' , '-1' , '4' , '3.7' , '3.7' , '0' , '0' , '3.70' ) 09/12/2025 06:04:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 06:04: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' , '4131' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.40' , '170.84' , NOW() , NOW() ) 09/12/2025 06:04: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 = '100355' 09/12/2025 06:04:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '100355' 09/12/2025 06:04: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 ( '100355' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '0' , '90.00' ) 09/12/2025 06:04: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 ( '100355' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 09/12/2025 06:04: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 ( '100355' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 09/12/2025 06:04: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 ( '100355' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/12/2025 06:04: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 ( '100355' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/12/2025 06:04: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 ( '100355' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/12/2025 06:13:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '100149' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-28') 09/12/2025 06:13:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2025-11-28', 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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '100149' 09/12/2025 06:13: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 = '100149' 09/12/2025 06:13:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100149' 09/12/2025 06:13: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 ( '100149' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '0' , '11.90' ) 09/12/2025 06:13: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 ( '100149' , '18845' , 'ANGELO - 3907' , '1' , '-1' , '1' , '3.1' , '2.5409836065574' , '22' , '0' , '3.10' ) 09/12/2025 06:26:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 06:26:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4132' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.85' , '134.25' , NOW() , NOW() ) 09/12/2025 06:26:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100356' 09/12/2025 06:26:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100356' 09/12/2025 06:26:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100356' , '21447' , 'FAZZOLETTO TULLE ' , '2' , '-2' , '1' , '65' , '53.27868852459' , '22' , '0' , '130.00' ) 09/12/2025 06:26:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100356' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/12/2025 06:26:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100356' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 09/12/2025 06:26:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100356' , '13315' , 'SEGNALIBRI VIENI BAMBINO GESU\' - 119' , '23' , '-23' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.45' ) 09/12/2025 07:18:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 07:18: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' , '4133' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/12/2025 07:18: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 = '100357' 09/12/2025 07:18:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100357' 09/12/2025 07:18: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 ( '100357' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/12/2025 07:25:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3506' AND id_document != '94300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-16') 09/12/2025 07:25:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3506', document_date = '2024-11-16', 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 = '725.00', price_tax_excluded = '720.49', date_upd = NOW() WHERE id_document = '94300' 09/12/2025 07:25: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 = '94300' 09/12/2025 07:25:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94300' 09/12/2025 07:25: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 ( '94300' , '5444' , 'IO SONO CON VOI - CAT.' , '45' , '-45' , '4' , '5.5000' , '5.5' , '0' , '5' , '235.35' ) 09/12/2025 07:25: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 ( '94300' , '11193' , 'VENITE CON ME CAT.' , '80' , '-80' , '4' , '5.5000' , '5.5' , '0' , '5' , '418.40' ) 09/12/2025 07:25: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 ( '94300' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 09/12/2025 07:25: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 ( '94300' , '22769' , 'COPPIE IN CAMMINO - MAIO/CALETTI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 09/12/2025 07:25: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 ( '94300' , '13431' , 'PASSI VERSO LEUCARISTIA' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 09/12/2025 07:25: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 ( '94300' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.52' , '2.52' , '0' , '0' , '5.04' ) 09/12/2025 07:25: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 ( '94300' , '23157' , 'ASPETTIAMO CON GIOIA IL NATALE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 07:25: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 ( '94300' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/12/2025 07:25: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 ( '94300' , '23128' , 'CIACK, SI GIRA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 09/12/2025 07:25: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 ( '94300' , '21709' , 'GESU E IL PANE DI VITA' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 09/12/2025 07:25: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 ( '94300' , '13033' , 'NOVENA ALLIMMACOLATA CONCEZIONE E AL SANTO NATALE - 8176' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 09/12/2025 07:25: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 ( '94300' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/12/2025 07:25:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '99774' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-07') 09/12/2025 07:25:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '137/A', document_date = '2025-11-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'CATECHESI - ACCONTO € 500', 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 = '668.15', price_tax_excluded = '668.15', date_upd = NOW() WHERE id_document = '99774' 09/12/2025 07:25: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 = '99774' 09/12/2025 07:25:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '99774' 09/12/2025 07:25: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 ( '99774' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 09/12/2025 07:25: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 ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 09/12/2025 07:25: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 ( '99774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 09/12/2025 07:25: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 ( '99774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '45' , '-45' , '4' , '3.8000' , '3.8' , '0' , '15' , '145.35' ) 09/12/2025 07:25: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 ( '99774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.8000' , '3.8' , '0' , '15' , '129.20' ) 09/12/2025 07:25: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 ( '99774' , '23583' , 'PIER GIORGIO FRASSATI - C. SICCARDI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 09/12/2025 07:25: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 ( '99774' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/12/2025 07:25: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 ( '99774' , '' , '09/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 09/12/2025 07:25: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 ( '99774' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 09/12/2025 07:26:17 pm >> DELETE FROM ps_document WHERE id_document = '100336' 09/12/2025 07:26:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100336' 09/12/2025 07:28:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '4033' AND id_document != '100232' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-03') 09/12/2025 07:28:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4033', document_date = '2025-12-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 = '26.40', price_tax_excluded = '21.64', date_upd = NOW() WHERE id_document = '100232' 09/12/2025 07:28:22 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 = '100232' 09/12/2025 07:28:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '100232' 09/12/2025 07:28:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100232' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 09/12/2025 07:28:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100232' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '3' , '-3' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '1.20' ) 09/12/2025 07:28:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100232' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO - P762' , '12' , '-12' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '7.20' ) 09/12/2025 07:41:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4134' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 07:41:47 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' , '4134' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 09/12/2025 07:41:47 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 = '100358' 09/12/2025 07:41:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100358' 09/12/2025 07:41: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 ( '100358' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 09/12/2025 07:41: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 ( '100358' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 09/12/2025 07:41: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 ( '100358' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/12/2025 07:41: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 ( '100358' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO - P762' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 09/12/2025 07:41: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 ( '100358' , '20061' , 'BRACCIALE DECINA - BC528' , '1' , '-1' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '1.60' ) 09/12/2025 07:45:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 09/12/2025 07:45:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4135' , '2025-12-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '14.20' , NOW() , NOW() ) 09/12/2025 07:45: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 = '100359' 09/12/2025 07:45:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100359' 09/12/2025 07:45: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 ( '100359' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 09/12/2025 07:45: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 ( '100359' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/12/2025 07:45: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 ( '100359' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/12/2025 07:45: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 ( '100359' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '0' , '5.00' )