31/03/2026 08:21:01 am >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '101767' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2026-03-16') 31/03/2026 08:21:01 am >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2026-03-16', document_letter = '', id_customer = '4329', id_supplier = '', id_address = '4679740', address1 = 'VIA CAPPUCCINI 26 65024 MANOPPELLO', address2 = '', note = '', price_shipping = '5.295', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '23.88', price_tax_excluded = '23.88', date_upd = NOW() WHERE id_document = '101767' 31/03/2026 08:21: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 = '101767' 31/03/2026 08:21:01 am >> DELETE FROM ps_document_detail WHERE id_document = '101767' 31/03/2026 08:21: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 ( '101767' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '5' , '0.85' ) 31/03/2026 08:21: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 ( '101767' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.6200' , '0.62' , '0' , '' , '0.62' ) 31/03/2026 08:21: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 ( '101767' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 31/03/2026 08:21: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 ( '101767' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 31/03/2026 08:21: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 ( '101767' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/03/2026 08:21: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 ( '101767' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 31/03/2026 08:21: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 ( '101767' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/03/2026 08:21: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 ( '101767' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/03/2026 08:21: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 ( '101767' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 31/03/2026 09:02:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2026 09:02:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24924' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:02:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24924' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2026 09:02:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24924' , '0' , '1' , '0' , '0' ) 31/03/2026 09:07:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851430986' AND id_product != '24924' AND ean13 != '' 31/03/2026 09:07:56 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788851430986', date_upd = NOW() WHERE id_product = '24924' 31/03/2026 09:07:56 am >> UPDATE ps_product_lang SET name = 'MISTERI DI CRISTO - R. CANTALAMESSA', description = '' WHERE id_product = '24924' 31/03/2026 09:07:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '37' WHERE id_product = '24924' 31/03/2026 09:07:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '37', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24924' 31/03/2026 09:07:56 am >> DELETE FROM ps_specific_price WHERE id_product = '24924' 31/03/2026 09:07:57 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 = '24924' 31/03/2026 09:07:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24925' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:07:57 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 '24925' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24924' 31/03/2026 09:07:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24925' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24924' 31/03/2026 09:08:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248930' AND id_product != '24925' AND ean13 != '' 31/03/2026 09:08:55 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788884248930', date_upd = NOW() WHERE id_product = '24925' 31/03/2026 09:08:56 am >> UPDATE ps_product_lang SET name = 'ADORIAMO GESU\' NELLE FESTE DELL\'ANNO LITURGICO 2', description = '' WHERE id_product = '24925' 31/03/2026 09:08:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '24925' 31/03/2026 09:08:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '83', 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 = '24925' 31/03/2026 09:08:56 am >> DELETE FROM ps_specific_price WHERE id_product = '24925' 31/03/2026 09:08:57 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 = '24925' 31/03/2026 09:08:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24926' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:08:57 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 '24926' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24925' 31/03/2026 09:08:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24926' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24925' 31/03/2026 09:09:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892249950' AND id_product != '24926' AND ean13 != '' 31/03/2026 09:09:38 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788892249950', date_upd = NOW() WHERE id_product = '24926' 31/03/2026 09:09:38 am >> UPDATE ps_product_lang SET name = 'SIAMO SOLI? - S. NOE\'', description = '' WHERE id_product = '24926' 31/03/2026 09:09:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '24926' 31/03/2026 09:09:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24926' 31/03/2026 09:09:38 am >> DELETE FROM ps_specific_price WHERE id_product = '24926' 31/03/2026 09:09:39 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 = '24926' 31/03/2026 09:09:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24927' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:09:39 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 '24927' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24926' 31/03/2026 09:09:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24927' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24926' 31/03/2026 09:10:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892249561' AND id_product != '24927' AND ean13 != '' 31/03/2026 09:10:40 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892249561', date_upd = NOW() WHERE id_product = '24927' 31/03/2026 09:10:40 am >> UPDATE ps_product_lang SET name = 'MAESTRO DI DOVE SEI? - C. DI FIORE', description = '' WHERE id_product = '24927' 31/03/2026 09:10:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '24927' 31/03/2026 09:10:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24927' 31/03/2026 09:10:40 am >> DELETE FROM ps_specific_price WHERE id_product = '24927' 31/03/2026 09:10:42 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 = '24927' 31/03/2026 09:10:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24928' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:10:42 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 '24928' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24927' 31/03/2026 09:10:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24928' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24927' 31/03/2026 09:11:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825060560' AND id_product != '24928' AND ean13 != '' 31/03/2026 09:11:47 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788825060560', date_upd = NOW() WHERE id_product = '24928' 31/03/2026 09:11:47 am >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO LUCA - C. DOGLIO', description = '' WHERE id_product = '24928' 31/03/2026 09:11:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '21' WHERE id_product = '24928' 31/03/2026 09:11:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '21', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24928' 31/03/2026 09:11:47 am >> DELETE FROM ps_specific_price WHERE id_product = '24928' 31/03/2026 09:11:48 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 = '24928' 31/03/2026 09:11:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24929' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:11:48 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 '24929' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24928' 31/03/2026 09:11:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24929' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24928' 31/03/2026 09:12:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825061901' AND id_product != '24929' AND ean13 != '' 31/03/2026 09:12:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825061901', date_upd = NOW() WHERE id_product = '24929' 31/03/2026 09:12:16 am >> UPDATE ps_product_lang SET name = 'ROSARIO DELLA FAMIGLIA', description = '' WHERE id_product = '24929' 31/03/2026 09:12:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '24929' 31/03/2026 09:12:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '17', 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 = '24929' 31/03/2026 09:12:16 am >> DELETE FROM ps_specific_price WHERE id_product = '24929' 31/03/2026 09:12:17 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 = '24929' 31/03/2026 09:12:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24930' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:12:17 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 '24930' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24929' 31/03/2026 09:12:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24930' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24929' 31/03/2026 09:12:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069808' AND id_product != '24930' AND ean13 != '' 31/03/2026 09:12:58 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788801069808', date_upd = NOW() WHERE id_product = '24930' 31/03/2026 09:12:58 am >> UPDATE ps_product_lang SET name = 'FORNAIO DEL TITANIC - B. FERRERO', description = '' WHERE id_product = '24930' 31/03/2026 09:12:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '24930' 31/03/2026 09:12:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24930' 31/03/2026 09:12:58 am >> DELETE FROM ps_specific_price WHERE id_product = '24930' 31/03/2026 09:12:59 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 = '24930' 31/03/2026 09:12:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24931' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:12:59 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 '24931' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24930' 31/03/2026 09:12:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24931' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24930' 31/03/2026 09:13:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259755810' AND id_product != '24931' AND ean13 != '' 31/03/2026 09:13:32 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791259755810', date_upd = NOW() WHERE id_product = '24931' 31/03/2026 09:13:32 am >> UPDATE ps_product_lang SET name = 'SCUOLA DELLA COMPASSIONE', description = '' WHERE id_product = '24931' 31/03/2026 09:13:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '24931' 31/03/2026 09:13:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '267', 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 = '24931' 31/03/2026 09:13:33 am >> DELETE FROM ps_specific_price WHERE id_product = '24931' 31/03/2026 09:13:33 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 = '24931' 31/03/2026 09:13:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24932' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:13:34 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 '24932' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24931' 31/03/2026 09:13:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24932' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24931' 31/03/2026 09:14:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892872899' AND id_product != '24932' AND ean13 != '' 31/03/2026 09:14:09 am >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788892872899', date_upd = NOW() WHERE id_product = '24932' 31/03/2026 09:14:09 am >> UPDATE ps_product_lang SET name = 'MIA GRANDE BIBBIA', description = '' WHERE id_product = '24932' 31/03/2026 09:14:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.9' WHERE id_product = '24932' 31/03/2026 09:14:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24932' 31/03/2026 09:14:09 am >> DELETE FROM ps_specific_price WHERE id_product = '24932' 31/03/2026 09:14: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 = '24932' 31/03/2026 09:14:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24933' , '1' , '' , 'nuovo-prodotto' ) 31/03/2026 09:14: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 '24933' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24932' 31/03/2026 09:14:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24933' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24932' 31/03/2026 09:17:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259755810' AND id_product != '24931' AND ean13 != '' 31/03/2026 09:17:32 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791259755810', date_upd = NOW() WHERE id_product = '24931' 31/03/2026 09:17:32 am >> UPDATE ps_product_lang SET name = 'SCUOLA DELLA COMPASSIONE', description = '' WHERE id_product = '24931' 31/03/2026 09:17:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24931' 31/03/2026 09:17:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '267', 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 = '24931' 31/03/2026 09:17:32 am >> DELETE FROM ps_specific_price WHERE id_product = '24931' 31/03/2026 09:18: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 ( '33' , '007690' , '2026-03-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.32' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '116.88' , '116.88' , NOW() , NOW() ) 31/03/2026 09:18: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 = '102033' 31/03/2026 09:18:22 am >> DELETE FROM ps_document_detail WHERE id_document = '102033' 31/03/2026 09:18: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 ( '102033' , '24927' , 'MAESTRO DI DOVE SEI? - C. DI FIORE' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24927' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24927' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24928' , 'VANGELO SECONDO LUCA - C. DOGLIO' , '1' , '1' , '4' , '21.00' , '21' , '0' , '30' , '14.7000' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24928' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24928' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24926' , 'SIAMO SOLI? - S. NOE' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24926' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24926' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24930' , 'FORNAIO DEL TITANIC - B. FERRERO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24930' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24930' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24924' , 'MISTERI DI CRISTO - R. CANTALAMESSA' , '1' , '1' , '4' , '37.00' , '37' , '0' , '33' , '24.7900' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24924' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24924' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24929' , 'ROSARIO DELLA FAMIGLIA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '30' , '4.2000' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24929' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24929' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24932' , 'MIA GRANDE BIBBIA' , '1' , '1' , '4' , '29.90' , '29.9' , '0' , '30' , '20.9300' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24932' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24932' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24931' , 'SCUOLA DELLA COMPASSIONE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24931' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24931' , '7' , '1' ) 31/03/2026 09:18: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 ( '102033' , '24925' , 'ADORIAMO GESU NELLE FESTE DELLANNO LITURGICO 2' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 31/03/2026 09:18:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '24925' AND id_supplier = '7' 31/03/2026 09:18:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24925' , '7' , '1' ) 31/03/2026 10:05:29 am >> SELECT document_num FROM ps_document WHERE document_num = '997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 10:05:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '997' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/03/2026 10:05: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 = '102034' 31/03/2026 10:05:29 am >> DELETE FROM ps_document_detail WHERE id_document = '102034' 31/03/2026 10:05: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 ( '102034' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 31/03/2026 10:20:25 am >> SELECT document_num FROM ps_document WHERE document_num = '998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 10:20:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '998' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '75.25' , '72.22' , NOW() , NOW() ) 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102035' 31/03/2026 10:20:25 am >> DELETE FROM ps_document_detail WHERE id_document = '102035' 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102035' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102035' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102035' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102035' , '16910' , 'SERVIZIO DEL MINISTRO STRAORDINARIO - 8954' , '5' , '-5' , '4' , '7.00' , '7' , '0' , '5' , '33.25' ) 31/03/2026 10:20:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102035' , '1041' , 'BENEDIZIONI' , '100' , '-100' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '10.00' ) 31/03/2026 10:25:19 am >> SELECT document_num FROM ps_document WHERE document_num = '999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 10:25:19 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' , '999' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '36.60' , '34.80' , NOW() , NOW() ) 31/03/2026 10:25:19 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 = '102036' 31/03/2026 10:25:19 am >> DELETE FROM ps_document_detail WHERE id_document = '102036' 31/03/2026 10:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102036' , '14860' , 'MARCO GALLO - ANCHE I SASSI SI SAREBBERO MESSI A SALTELLARE' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 31/03/2026 10:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102036' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 31/03/2026 10:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102036' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 31/03/2026 10:30:23 am >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '101748' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-13') 31/03/2026 10:30:23 am >> UPDATE ps_document SET id_document_type = '24', document_num = '33/A', document_date = '2026-03-13', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '184.90', price_tax_excluded = '151.56', date_upd = NOW() WHERE id_document = '101748' 31/03/2026 10:30: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 = '101748' 31/03/2026 10:30:23 am >> DELETE FROM ps_document_detail WHERE id_document = '101748' 31/03/2026 10:30: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 ( '101748' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 31/03/2026 10:30: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 ( '101748' , '' , '31/03 TELEFONO' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 31/03/2026 10:30: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 ( '101748' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 31/03/2026 10:30: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 ( '101748' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '36.00' ) 31/03/2026 10:30: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 ( '101748' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 31/03/2026 10:38:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 10:38:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1000' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '240.00' , '196.72' , NOW() , NOW() ) 31/03/2026 10:38:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102037' 31/03/2026 10:38:11 am >> DELETE FROM ps_document_detail WHERE id_document = '102037' 31/03/2026 10:38:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102037' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '10' , '-10' , '1' , '24' , '19.672131147541' , '22' , '0' , '240.00' ) 31/03/2026 11:19:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:19: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 ( '11' , '1001' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 31/03/2026 11:19: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 = '102038' 31/03/2026 11:19:51 am >> DELETE FROM ps_document_detail WHERE id_document = '102038' 31/03/2026 11:19: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 ( '102038' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 31/03/2026 11:23:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:23:45 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' , '1002' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '149.20' , '126.46' , NOW() , NOW() ) 31/03/2026 11:23:45 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 = '102039' 31/03/2026 11:23:45 am >> DELETE FROM ps_document_detail WHERE id_document = '102039' 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '85' , '69.672131147541' , '22' , '0' , '85.00' ) 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/03/2026 11:23:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102039' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.70' , '3.5576923076923' , '4' , '0' , '7.40' ) 31/03/2026 11:31:00 am >> SELECT document_num FROM ps_document WHERE document_num = '488' AND id_document != '101372' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-02-14') 31/03/2026 11:31:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '488', document_date = '2026-02-14', 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 = '15', id_causal = '0', price_tax_included = '119.68', price_tax_excluded = '102.50', date_upd = NOW() WHERE id_document = '101372' 31/03/2026 11:31: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 = '101372' 31/03/2026 11:31:00 am >> DELETE FROM ps_document_detail WHERE id_document = '101372' 31/03/2026 11:31: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 ( '101372' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 31/03/2026 11:31: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 ( '101372' , '24399' , 'AMEN - APR 26' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/03/2026 11:31: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 ( '101372' , '24398' , 'AMEN - MAR 26' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/03/2026 11:31: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 ( '101372' , '24352' , 'AMEN - FEB 26' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/03/2026 11:31: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 ( '101372' , '6414' , 'MERAVIGLIOSO SEGRETO DELLE ANIME DEL PURGATORIO - 8110' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/03/2026 11:31: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 ( '101372' , '23852' , 'ANELLO ARG. CON AMETISTA - 6688/AM' , '1' , '-1' , '1' , '94' , '77.049180327869' , '22' , '0' , '94.00' ) 31/03/2026 11:38:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:38:37 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' , '1003' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 31/03/2026 11:38:37 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 = '102040' 31/03/2026 11:38:37 am >> DELETE FROM ps_document_detail WHERE id_document = '102040' 31/03/2026 11:38:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102040' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 31/03/2026 11:54:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:54:19 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' , '1004' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '460.00' , '380.20' , NOW() , NOW() ) 31/03/2026 11:54:19 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 = '102041' 31/03/2026 11:54:19 am >> DELETE FROM ps_document_detail WHERE id_document = '102041' 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '12535' , 'BROCCA CON PIATTINO - 1006/15+731/100' , '1' , '-1' , '1' , '82.00' , '67.213114754098' , '22' , '0' , '82.00' ) 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '149' , '122.13114754098' , '22' , '0' , '149.00' ) 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 31/03/2026 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102041' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20.5' , '16.803278688525' , '22' , '0' , '20.50' ) 31/03/2026 11:54:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:54:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1005' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 31/03/2026 11:54: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 = '102042' 31/03/2026 11:54:43 am >> DELETE FROM ps_document_detail WHERE id_document = '102042' 31/03/2026 11:54: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 ( '102042' , '3118' , 'CROCE SU CANDELIERE CM 37 - 589/C' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 31/03/2026 11:59:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 11:59:45 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' , '1006' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 31/03/2026 11:59:45 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 = '102043' 31/03/2026 11:59:45 am >> DELETE FROM ps_document_detail WHERE id_document = '102043' 31/03/2026 11:59:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102043' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/03/2026 11:59:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102043' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 31/03/2026 12:46:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 12:46:20 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' , '1007' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '330.00' , '270.49' , NOW() , NOW() ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102044' 31/03/2026 12:46:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '102044' 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '24624' , 'ANGELO - 6863' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '24657' , 'TEGOLA IN COCCIO S. FAMIGLIA - 2200' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '22357' , 'CROCE RESINA - 692/02' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105' , '86.065573770492' , '22' , '0' , '105.00' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '2766' , 'CORONA PLASTICA VARI COLORI - 07' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '19411' , 'RISURREZIONE CM 22' , '1' , '-1' , '1' , '181.2' , '148.52459016393' , '22' , '0' , '181.20' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '24658' , 'CARTONCINO CROCE RESURREZIONE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '9506' , 'SAN PIO- 781-5 TMD ' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '24093' , 'ROSARIO ACUTIS - RE 1959-254' , '2' , '-2' , '1' , '5.60' , '4.5901639344262' , '22' , '0' , '11.20' ) 31/03/2026 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102044' , '19148' , 'CANDELE STEREATICHE E/5' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 31/03/2026 03:34:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '101121' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-27') 31/03/2026 03:34:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2026-01-27', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '100.60', price_tax_excluded = '94.97', date_upd = NOW() WHERE id_document = '101121' 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101121' 31/03/2026 03:34:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '101121' 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '0' , '9/3/2026' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '0' , 'TUNICA BORDO ORO MISURA 115-120-125-130' , '4' , '-4' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 31/03/2026 03:34:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101121' , '20516' , 'CROCE COMUNIONE - 42/08' , '24' , '-24' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '31.20' ) 31/03/2026 03:35:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 03:35:29 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' , '1008' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '18.41' , '18.06' , NOW() , NOW() ) 31/03/2026 03:35:29 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 = '102045' 31/03/2026 03:35:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '102045' 31/03/2026 03:35:29 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 ( '102045' , '24399' , 'AMEN - APR 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/03/2026 03:35:29 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 ( '102045' , '24594' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2026' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 31/03/2026 03:35:29 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 ( '102045' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/03/2026 03:35:29 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 ( '102045' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/03/2026 03:42:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 03:42:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1009' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 31/03/2026 03:42:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102046' 31/03/2026 03:42:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '102046' 31/03/2026 03:42:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102046' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '5' , '-5' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '45.00' ) 31/03/2026 04:15:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 04:15:53 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' , '1010' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 31/03/2026 04:15:53 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 = '102047' 31/03/2026 04:15:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '102047' 31/03/2026 04:15: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 ( '102047' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '55' , '55' , '0' , '0' , '55.00' ) 31/03/2026 04:18:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 04:18:22 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' , '1011' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/03/2026 04:18: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 = '102048' 31/03/2026 04:18:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '102048' 31/03/2026 04:18: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 ( '102048' , '24612' , 'STATUA SAN MICHELE CM 13,5 - 4011' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/03/2026 04:43:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 04:43: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' , '1012' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 31/03/2026 04:43: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 = '102049' 31/03/2026 04:43:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '102049' 31/03/2026 04:43: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 ( '102049' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 31/03/2026 06:48:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 06:48:24 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' , '1013' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '23.30' , '21.50' , NOW() , NOW() ) 31/03/2026 06:48:24 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 = '102050' 31/03/2026 06:48:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '102050' 31/03/2026 06:48:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102050' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 31/03/2026 06:48:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '102050' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 31/03/2026 07:36:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-31') 31/03/2026 07:36:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1014' , '2026-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '134.00' , '109.84' , NOW() , NOW() ) 31/03/2026 07:36:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '102051' 31/03/2026 07:36:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '102051' 31/03/2026 07:36:23 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 ( '102051' , '24812' , 'CASULA LEGGERA - 361' , '1' , '-1' , '1' , '79' , '64.754098360656' , '22' , '0' , '79.00' ) 31/03/2026 07:36:23 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 ( '102051' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 31/03/2026 07:44:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/L' AND id_document != '101006' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-21') 31/03/2026 07:44:18 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '1/L', document_date = '2026-01-21', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. CAMPOLONGO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '339.70', price_tax_excluded = '283.85', date_upd = NOW() WHERE id_document = '101006' 31/03/2026 07:44:18 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 = '101006' 31/03/2026 07:44:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '101006' 31/03/2026 07:44:18 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 ( '101006' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '26.70' ) 31/03/2026 07:44:18 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 ( '101006' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 31/03/2026 07:44:18 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 ( '101006' , '23840' , 'COPRI LEGGIO - 331/TP' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 31/03/2026 07:44:18 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 ( '101006' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 31/03/2026 07:44:18 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 ( '101006' , '23620' , 'CAMICE AVORIO GIGLIUCCIO - 19/3 PL' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' )