17/12/2025 09:20:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 09:20:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4271' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 17/12/2025 09:20:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100529' 17/12/2025 09:20:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100529' 17/12/2025 09:20:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100529' , '24429' , 'ILLUSTRISSIMI ALBINO LUCIANI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 17/12/2025 09:37:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/12/2025 09:37:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24431' , '1' , '' , 'nuovo-prodotto' ) 17/12/2025 09:37:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24431' , '1' , '1' , '2' , NOW() , NOW() ) 17/12/2025 09:37:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24431' , '0' , '1' , '0' , '0' ) 17/12/2025 09:38:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392988' AND id_product != '24431' AND ean13 != '' 17/12/2025 09:38:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256392988', date_upd = NOW() WHERE id_product = '24431' 17/12/2025 09:38:32 am >> UPDATE ps_product_lang SET name = 'rosario e novena con la serva di dio', description = '' WHERE id_product = '24431' 17/12/2025 09:38:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '24431' 17/12/2025 09:38:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24431' 17/12/2025 09:38:32 am >> DELETE FROM ps_specific_price WHERE id_product = '24431' 17/12/2025 09:38:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392988' AND id_product != '24431' AND ean13 != '' 17/12/2025 09:38:51 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256392988', date_upd = NOW() WHERE id_product = '24431' 17/12/2025 09:38:51 am >> UPDATE ps_product_lang SET name = 'ROSARIO E NOVENA CON LA SERVA DI DIO', description = '' WHERE id_product = '24431' 17/12/2025 09:38:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '24431' 17/12/2025 09:38:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24431' 17/12/2025 09:38:51 am >> DELETE FROM ps_specific_price WHERE id_product = '24431' 17/12/2025 09:39:41 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/12/2025 09:39:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24432' , '1' , '' , 'nuovo-prodotto' ) 17/12/2025 09:39:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24432' , '1' , '1' , '2' , NOW() , NOW() ) 17/12/2025 09:39:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24432' , '0' , '1' , '0' , '0' ) 17/12/2025 09:40:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256393022' AND id_product != '24432' AND ean13 != '' 17/12/2025 09:40:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256393022', date_upd = NOW() WHERE id_product = '24432' 17/12/2025 09:40:22 am >> UPDATE ps_product_lang SET name = 'SANTA MARIA TRONCATTI - 8567', description = '' WHERE id_product = '24432' 17/12/2025 09:40:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '24432' 17/12/2025 09:40:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24432' 17/12/2025 09:40:22 am >> DELETE FROM ps_specific_price WHERE id_product = '24432' 17/12/2025 09:41:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884045881' AND id_product != '15746' AND ean13 != '' 17/12/2025 09:41:40 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884045881', date_upd = NOW() WHERE id_product = '15746' 17/12/2025 09:41:40 am >> UPDATE ps_product_lang SET name = 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958', description = '' WHERE id_product = '15746' 17/12/2025 09:41:40 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '4' WHERE id_product = '15746' 17/12/2025 09:41:40 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15746' 17/12/2025 09:41:40 am >> DELETE FROM ps_specific_price WHERE id_product = '15746' 17/12/2025 09:41:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '19162/00/2025' , '2025-12-15' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '357.00' , '357.00' , NOW() , NOW() ) 17/12/2025 09:41:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100530' 17/12/2025 09:41:51 am >> DELETE FROM ps_document_detail WHERE id_document = '100530' 17/12/2025 09:41:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100530' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '85' , '85' , '4' , '5.00' , '5' , '0' , '40' , '255.0000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '24214' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24214' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '1' , '4' , '19.00' , '19' , '0' , '40' , '11.4000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '19924' , 'SACRA BIBBIA BIANCA - 8056' , '1' , '1' , '4' , '38.00' , '38' , '0' , '40' , '22.8000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19924' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19924' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '2' , '4' , '10.00' , '10' , '0' , '40' , '12.0000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '7395' , 'PADRE PIO - UN PENSIERO PER OGNI GIORNO - 8142' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7395' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7395' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '4185' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4185' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '24220' , 'SIATE SANTI SIATE FELICI - 8404' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '24220' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24220' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '3388' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3388' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '24431' , 'ROSARIO E NOVENA CON LA SERVA DI DIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '24431' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24431' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '2' , '2' , '4' , '2.00' , '2' , '0' , '40' , '2.4000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21479' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21479' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '24432' , 'SANTA MARIA TRONCATTI - 8567' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '24432' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24432' , '38' , '1' ) 17/12/2025 09:41:52 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 ( '100530' , '23163' , 'SANTA FILOMENA - 8841' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 17/12/2025 09:41:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '23163' AND id_supplier = '38' 17/12/2025 09:41:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23163' , '38' , '1' ) 17/12/2025 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100530' , '14940' , 'SAN CHARBEL - 8850' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 17/12/2025 09:41:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '14940' AND id_supplier = '38' 17/12/2025 09:41:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14940' , '38' , '1' ) 17/12/2025 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100530' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '1' , '4' , '4' , '4' , '0' , '40' , '2.4000' ) 17/12/2025 09:41:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 17/12/2025 09:41:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 17/12/2025 09:41:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100530' , '23649' , 'APPARECCHIO ALLA MORTE - 8975 ' , '2' , '2' , '4' , '12.00' , '12' , '0' , '40' , '14.4000' ) 17/12/2025 09:41:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '23649' AND id_supplier = '38' 17/12/2025 09:41:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23649' , '38' , '1' ) 17/12/2025 10:01:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 10:01:13 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' , '4272' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.78' , '66.13' , NOW() , NOW() ) 17/12/2025 10:01:13 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 = '100531' 17/12/2025 10:01:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100531' 17/12/2025 10:01:13 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 ( '100531' , '24137' , 'GIOCHIAMO CON IL NATALE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 17/12/2025 10:01:13 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 ( '100531' , '24337' , 'MIA NOVENA DI NATALE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 17/12/2025 10:01:13 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 ( '100531' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 17/12/2025 10:01:13 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 ( '100531' , '24349' , 'PAROLA E PREGHIERA - GEN 26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 17/12/2025 10:01:13 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 ( '100531' , '24350' , 'PAROLA E PREGHIERA - FEB 26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 17/12/2025 10:01:13 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 ( '100531' , '24427' , 'SACRA FAMIGLIA CM 6 - P696' , '10' , '-10' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '29.00' ) 17/12/2025 10:01:13 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 ( '100531' , '23096' , 'QUADRETTO EFFETTO CERAMICA - P734/F38' , '5' , '-5' , '1' , '4' , '3.2786885245902' , '22' , '0' , '20.00' ) 17/12/2025 10:01:13 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 ( '100531' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 17/12/2025 10:05:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3933' AND id_document != '100103' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26') 17/12/2025 10:05:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3933', document_date = '2025-11-26', 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 = '22.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '100103' 17/12/2025 10:05:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100103' 17/12/2025 10:05:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100103' 17/12/2025 10:05:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100103' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '11' , '-11' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '22.00' ) 17/12/2025 10:06:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3932' AND id_document != '100102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26') 17/12/2025 10:06:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3932', document_date = '2025-11-26', 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 = '74.00', price_tax_excluded = '61.93', date_upd = NOW() WHERE id_document = '100102' 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100102' 17/12/2025 10:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '100102' 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '5' , '-5' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '16.50' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '6.7000' , '5.4918032786885' , '22' , '0' , '13.40' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.8000' , '6.3934426229508' , '22' , '0' , '15.60' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 17/12/2025 10:06:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100102' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '9' , '-9' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '18.00' ) 17/12/2025 10:17:54 am >> SELECT document_num FROM ps_document WHERE document_num = '4273' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 10:17:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4273' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 17/12/2025 10:17: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 = '100532' 17/12/2025 10:17:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100532' 17/12/2025 10:17: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 ( '100532' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 17/12/2025 10:24:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 10:24:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4274' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 17/12/2025 10:24:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100533' 17/12/2025 10:24:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100533' 17/12/2025 10:24:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100533' , '20157' , 'ALBERO DI NATALE - MIX' , '13' , '-13' , '1' , '2.30' , '1.8852459016393' , '22' , '0' , '29.90' ) 17/12/2025 10:31:19 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/12/2025 10:31:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24433' , '1' , '' , 'nuovo-prodotto' ) 17/12/2025 10:31:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24433' , '1' , '1' , '2' , NOW() , NOW() ) 17/12/2025 10:31:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24433' , '0' , '1' , '0' , '0' ) 17/12/2025 10:38:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000133' AND id_product != '24433' AND ean13 != '' 17/12/2025 10:38:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000133', date_upd = NOW() WHERE id_product = '24433' 17/12/2025 10:38:46 am >> UPDATE ps_product_lang SET name = 'LITURGICO CARTA - KING CELLOPHANE', description = '' WHERE id_product = '24433' 17/12/2025 10:38:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '24433' 17/12/2025 10:38:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24433' 17/12/2025 10:38:46 am >> DELETE FROM ps_specific_price WHERE id_product = '24433' 17/12/2025 10:40: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 ( '31' , 'G3537' , '2025-12-15' , '' , '0' , '31' , '2626' , 'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1506.42' , '1234.77' , NOW() , NOW() ) 17/12/2025 10:40: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 = '100534' 17/12/2025 10:40:31 am >> DELETE FROM ps_document_detail WHERE id_document = '100534' 17/12/2025 10:40: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 ( '100534' , '17160' , 'CARBONCINI ROSSI - CARRO' , '144' , '144' , '1' , '10.7' , '8.7704918032787' , '22' , '50+10+3' , '820.5222' ) 17/12/2025 10:40:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '31' 17/12/2025 10:40:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '31' , '1' ) 17/12/2025 10:40: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 ( '100534' , '24433' , 'LITURGICO CARTA - KING CELLOPHANE' , '300' , '300' , '1' , '4.2' , '3.4426229508197' , '22' , '50+8+3' , '685.8986' ) 17/12/2025 10:40:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '24433' AND id_supplier = '31' 17/12/2025 10:40:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24433' , '31' , '1' ) 17/12/2025 10:40:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000133' AND id_product != '24433' AND ean13 != '' 17/12/2025 10:40:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000133', date_upd = NOW() WHERE id_product = '24433' 17/12/2025 10:40:36 am >> UPDATE ps_product_lang SET name = 'LITURGICO CARTA - KING CELLOPHANE', description = '' WHERE id_product = '24433' 17/12/2025 10:40:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '24433' 17/12/2025 10:40:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24433' 17/12/2025 10:40:36 am >> DELETE FROM ps_specific_price WHERE id_product = '24433' 17/12/2025 10:40:37 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 = '24433' 17/12/2025 10:40:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24434' , '1' , '' , 'nuovo-prodotto' ) 17/12/2025 10:40:37 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 '24434' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24433' 17/12/2025 10:40:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24434' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24433' 17/12/2025 10:54:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 10:54:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4275' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '306.91' , NOW() , NOW() ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100535' 17/12/2025 10:54:28 am >> DELETE FROM ps_document_detail WHERE id_document = '100535' 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '3' , '-3' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '39.00' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '48.15' , '39.467213114754' , '22' , '0' , '48.15' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '22.50' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 17/12/2025 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100535' , '24416' , 'PAROLE PIU IMPORTANTI DI GESU - G. LOHFINK' , '1' , '-1' , '4' , '47.00' , '47' , '0' , '5' , '44.65' ) 17/12/2025 11:23:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4276' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 11:23:00 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' , '4276' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '235.74' , '213.51' , NOW() , NOW() ) 17/12/2025 11:23: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 = '100536' 17/12/2025 11:23:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100536' 17/12/2025 11:23: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 ( '100536' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 17/12/2025 11:23:01 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 ( '100536' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 17/12/2025 11:23:01 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 ( '100536' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 17/12/2025 11:23:01 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 ( '100536' , '11193' , 'VENITE CON ME CAT.' , '15' , '-15' , '4' , '5.50' , '5.5' , '0' , '0' , '82.50' ) 17/12/2025 11:23:01 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 ( '100536' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '20' , '-20' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '40.00' ) 17/12/2025 11:23:01 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 ( '100536' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 17/12/2025 11:23:01 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 ( '100536' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '4' , '-4' , '4' , '1.50' , '1.5' , '0' , '0' , '6.00' ) 17/12/2025 11:23:01 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 ( '100536' , '2697' , 'CONTEMPLATE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 17/12/2025 11:23:01 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 ( '100536' , '24253' , 'TU SCENDI DALLE STELLE - A. COMASTRI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 17/12/2025 11:23:01 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 ( '100536' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 17/12/2025 11:23:01 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 ( '100536' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 17/12/2025 11:23:01 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 ( '100536' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 17/12/2025 11:26:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4276' AND id_document != '100536' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 11:26:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4276', document_date = '2025-12-17', 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 = '235.74', price_tax_excluded = '213.51', date_upd = NOW() WHERE id_document = '100536' 17/12/2025 11:26:01 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 = '100536' 17/12/2025 11:26:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100536' 17/12/2025 11:26:01 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 ( '100536' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 17/12/2025 11:26:01 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 ( '100536' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 17/12/2025 11:26:01 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 ( '100536' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '5' , '13.30' ) 17/12/2025 11:26:01 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 ( '100536' , '11193' , 'VENITE CON ME CAT.' , '15' , '-15' , '4' , '5.5000' , '5.5' , '0' , '0' , '82.50' ) 17/12/2025 11:26:01 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 ( '100536' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '20' , '-20' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '40.00' ) 17/12/2025 11:26:01 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 ( '100536' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 17/12/2025 11:26:01 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 ( '100536' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 17/12/2025 11:26:01 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 ( '100536' , '2697' , 'CONTEMPLATE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 17/12/2025 11:26:01 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 ( '100536' , '24253' , 'TU SCENDI DALLE STELLE - A. COMASTRI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/12/2025 11:26:01 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 ( '100536' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 17/12/2025 11:26:01 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 ( '100536' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 17/12/2025 11:26:01 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 ( '100536' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3300' , '2.7295081967213' , '22' , '0' , '9.99' ) 17/12/2025 11:36:41 am >> SELECT document_num FROM ps_document WHERE document_num = '4277' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 11:36:41 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' , '4277' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.95' , '65.64' , NOW() , NOW() ) 17/12/2025 11:36:41 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 = '100537' 17/12/2025 11:36:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100537' 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '16.65' ) 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '17882' , 'CROCE MOGANO CORPO MET CM 20 - 167M' , '3' , '-3' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 17/12/2025 11:36:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100537' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/12/2025 11:43:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4278' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 11:43:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4278' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 17/12/2025 11:43:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100538' 17/12/2025 11:43:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100538' 17/12/2025 11:43:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100538' , '9227' , 'S. MICHELE CM 20 - O023 SMK/20' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 17/12/2025 12:32:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4279' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 12:32:52 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' , '4279' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.67' , '40.67' , NOW() , NOW() ) 17/12/2025 12:32:52 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 = '100539' 17/12/2025 12:32:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100539' 17/12/2025 12:32:53 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 ( '100539' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 17/12/2025 12:32:53 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 ( '100539' , '24351' , 'AMEN - GEN 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 17/12/2025 12:32:53 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 ( '100539' , '24352' , 'AMEN - FEB 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 17/12/2025 12:42:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4280' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 12:42: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' , '4280' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '4.84' , NOW() , NOW() ) 17/12/2025 12:42: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 = '100540' 17/12/2025 12:42:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100540' 17/12/2025 12:42: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 ( '100540' , '3807' , 'ELETTRICO LUMINI 10/EA 150 GG' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 17/12/2025 05:23:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '155/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 05:23:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '155/A' , '2025-12-17' , 'A' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2140.00' , '2140.00' , NOW() , NOW() ) 17/12/2025 05:23:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100541' 17/12/2025 05:23:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '100541' 17/12/2025 05:23:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100541' , '' , 'SET 3 PEZZI NATIVITA\' CM 105' , '1' , '-1' , '0' , '1590' , '1590' , '' , '0' , '1590.00' ) 17/12/2025 05:23:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100541' , '' , 'BAMBINELLO IN TERRACOTTA CM 40' , '1' , '-1' , '0' , '550' , '550' , '' , '0' , '550.00' ) 17/12/2025 05:26:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4281' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 05:26:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4281' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.76' , '54.45' , NOW() , NOW() ) 17/12/2025 05:26:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100542' 17/12/2025 05:26:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '100542' 17/12/2025 05:26:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100542' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 17/12/2025 05:26:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100542' , '24351' , 'AMEN - GEN 26' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 17/12/2025 05:26:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100542' , '24352' , 'AMEN - FEB 26' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 17/12/2025 05:26:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100542' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 17/12/2025 05:52:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4282' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 05:52: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' , '4282' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.90' , '40.90' , NOW() , NOW() ) 17/12/2025 05:52: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 = '100543' 17/12/2025 05:52:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100543' 17/12/2025 05:52: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 ( '100543' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 17/12/2025 05:59:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 05:59: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' , '4283' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 17/12/2025 05:59: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 = '100544' 17/12/2025 05:59:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100544' 17/12/2025 05:59: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 ( '100544' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3' , '2.4590163934426' , '22' , '0' , '18.00' ) 17/12/2025 05:59: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 ( '100544' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/12/2025 06:12:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3734' AND id_document != '99816' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-10') 17/12/2025 06:12:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3734', document_date = '2025-11-10', 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.80', price_tax_excluded = '12.80', date_upd = NOW() WHERE id_document = '99816' 17/12/2025 06:12:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99816' 17/12/2025 06:12:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '99816' 17/12/2025 06:12:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99816' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 17/12/2025 06:12:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99816' , '24043' , 'MESSALE FESTIVO 2026' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 17/12/2025 06:50:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 06:50:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4284' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 17/12/2025 06:50:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100545' 17/12/2025 06:50:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100545' 17/12/2025 06:50:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100545' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 17/12/2025 07:19:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-17') 17/12/2025 07:19:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4285' , '2025-12-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 17/12/2025 07:19:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100546' 17/12/2025 07:19:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100546' 17/12/2025 07:19:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100546' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' )