17/09/2025 10:13:49 am >> SELECT document_num FROM ps_document WHERE document_num = '39/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 10:13:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '39/E' , '2025-09-17' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2858.76' , '2851.73' , NOW() , NOW() ) 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98772' 17/09/2025 10:13:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98772' 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98772' , '5457' , 'IO SONO CON VOI 1 PARTE' , '700' , '-700' , '4' , '2.80' , '2.8' , '0' , '38' , '1215.20' ) 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98772' , '5458' , 'IO SONO CON VOI 2 PARTE' , '210' , '-210' , '4' , '2.80' , '2.8' , '0' , '38' , '364.56' ) 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98772' , '11191' , 'VENITE CON ME 1 PARTE' , '700' , '-700' , '4' , '2.80' , '2.8' , '0' , '38' , '1215.20' ) 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98772' , '12819' , 'REGISTRO DEL CATECHISTA ' , '60' , '-60' , '1' , '1.00' , '0.81967213114754' , '22' , '35' , '39.00' ) 17/09/2025 10:13:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98772' , '5446' , 'IO SONO CON VOI - GUIDA' , '5' , '-5' , '4' , '8.00' , '8' , '0' , '38' , '24.80' ) 17/09/2025 10:48:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 10:48: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' , '3005' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.30' , '67.13' , NOW() , NOW() ) 17/09/2025 10:48: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 = '98773' 17/09/2025 10:48:37 am >> DELETE FROM ps_document_detail WHERE id_document = '98773' 17/09/2025 10:48: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 ( '98773' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 17/09/2025 10:48: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 ( '98773' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/09/2025 10:48: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 ( '98773' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 17/09/2025 10:48: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 ( '98773' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 17/09/2025 10:55:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 10:55: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' , '3006' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.45' , '10.45' , NOW() , NOW() ) 17/09/2025 10:55: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 = '98774' 17/09/2025 10:55:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98774' 17/09/2025 10:55: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 ( '98774' , '23970' , 'SIMONE CHIAMATO PIETRO - M. LEPORI' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 17/09/2025 10:57:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 10:57:06 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' , '3007' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 17/09/2025 10:57:06 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 = '98775' 17/09/2025 10:57:06 am >> DELETE FROM ps_document_detail WHERE id_document = '98775' 17/09/2025 10:57:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98775' , '23988' , 'AMEN - DIC 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 17/09/2025 10:57:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98775' , '23989' , 'AMEN - NOV 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 17/09/2025 11:23:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 11:23: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' , '3008' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 17/09/2025 11:23: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 = '98776' 17/09/2025 11:23:41 am >> DELETE FROM ps_document_detail WHERE id_document = '98776' 17/09/2025 11:23: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 ( '98776' , '23850' , 'OCCHI IN METALLO - 18003MET' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 17/09/2025 12:43:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3635/00' , '2025-09-16' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '200.00' , NOW() , NOW() ) 17/09/2025 12:43:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98777' 17/09/2025 12:43:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98777' 17/09/2025 12:43:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98777' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '20' , '20' , '4' , '10.00' , '10' , '0' , '0' , '200.0000' ) 17/09/2025 12:44:28 pm >> DELETE FROM ps_document WHERE id_document = '98777' 17/09/2025 12:44:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '98777' 17/09/2025 12:45:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3635/00' , '2025-09-16' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '200.00' , NOW() , NOW() ) 17/09/2025 12:45:08 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 = '98778' 17/09/2025 12:45:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98778' 17/09/2025 12:45:08 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 ( '98778' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '20' , '20' , '4' , '10.00' , '10' , '0' , '0' , '200.0000' ) 17/09/2025 12:45:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/09/2025 12:45:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24025' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:45:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24025' , '1' , '1' , '2' , NOW() , NOW() ) 17/09/2025 12:45:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24025' , '0' , '1' , '0' , '0' ) 17/09/2025 12:46:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852608070' AND id_product != '24025' AND ean13 != '' 17/09/2025 12:46:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788852608070', date_upd = NOW() WHERE id_product = '24025' 17/09/2025 12:46:55 pm >> UPDATE ps_product_lang SET name = 'STORIA DI GESU\' - E. DAL PANE', description = '' WHERE id_product = '24025' 17/09/2025 12:46:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24025' 17/09/2025 12:46:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '285', 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 = '24025' 17/09/2025 12:46:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '24025' 17/09/2025 12:46:56 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24025' 17/09/2025 12:46:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24026' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:46:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24026' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24025' 17/09/2025 12:46:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24026' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24025' 17/09/2025 12:47:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852608087' AND id_product != '24026' AND ean13 != '' 17/09/2025 12:47:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788852608087', date_upd = NOW() WHERE id_product = '24026' 17/09/2025 12:47:43 pm >> UPDATE ps_product_lang SET name = 'LUCE DEL NATALE - G. CORNACCHIONE', description = '' WHERE id_product = '24026' 17/09/2025 12:47:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.5' WHERE id_product = '24026' 17/09/2025 12:47:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.5', id_tax_rules_group = '4', id_category_default = '285', 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 = '24026' 17/09/2025 12:47:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '24026' 17/09/2025 12:47:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24026' 17/09/2025 12:47:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24027' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:47:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24027' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24026' 17/09/2025 12:47:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24027' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24026' 17/09/2025 12:48:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852608179' AND id_product != '24027' AND ean13 != '' 17/09/2025 12:48:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788852608179', date_upd = NOW() WHERE id_product = '24027' 17/09/2025 12:48:37 pm >> UPDATE ps_product_lang SET name = 'SI TRATTA DI TE - G. SGUBBI', description = '' WHERE id_product = '24027' 17/09/2025 12:48:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24027' 17/09/2025 12:48:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '285', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24027' 17/09/2025 12:48:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '24027' 17/09/2025 12:48:39 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24027' 17/09/2025 12:48:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24028' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:48:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24028' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24027' 17/09/2025 12:48:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24028' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24027' 17/09/2025 12:49:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873673576' AND id_product != '24028' AND ean13 != '' 17/09/2025 12:49:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788873673576', date_upd = NOW() WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> UPDATE ps_product_lang SET name = 'PIER GIORGIO FRASSATI DIO, IL TESORO - S. FARI\'', description = '' WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '380', 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 = '24028' 17/09/2025 12:49:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24029' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:49:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24029' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24028' 17/09/2025 12:49:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24029' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24028' 17/09/2025 12:50:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830819665' AND id_product != '24029' AND ean13 != '' 17/09/2025 12:50:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788830819665', date_upd = NOW() WHERE id_product = '24029' 17/09/2025 12:50:53 pm >> UPDATE ps_product_lang SET name = 'SEMI DEL PRESENTE - A. ORILIA', description = '' WHERE id_product = '24029' 17/09/2025 12:50:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.5' WHERE id_product = '24029' 17/09/2025 12:50:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.5', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24029' 17/09/2025 12:50:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24029' 17/09/2025 12:50:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24029' 17/09/2025 12:50:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24030' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:50:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24030' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24029' 17/09/2025 12:50:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24030' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24029' 17/09/2025 12:51:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830819825' AND id_product != '24030' AND ean13 != '' 17/09/2025 12:51:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788830819825', date_upd = NOW() WHERE id_product = '24030' 17/09/2025 12:51:51 pm >> UPDATE ps_product_lang SET name = 'FRATELLO DI TUTTI - V. PISTORE', description = '' WHERE id_product = '24030' 17/09/2025 12:51:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '21.5' WHERE id_product = '24030' 17/09/2025 12:51:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '21.5', id_tax_rules_group = '4', id_category_default = '11', 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 = '24030' 17/09/2025 12:51:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '24030' 17/09/2025 12:51:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24030' 17/09/2025 12:51:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24031' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:51:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24031' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24030' 17/09/2025 12:51:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24031' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24030' 17/09/2025 12:53:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254824382' AND id_product != '24031' AND ean13 != '' 17/09/2025 12:53:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791254824382', date_upd = NOW() WHERE id_product = '24031' 17/09/2025 12:53:21 pm >> UPDATE ps_product_lang SET name = 'MISIONEROS DIGITALE - H. G. ARIAS', description = '' WHERE id_product = '24031' 17/09/2025 12:53:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24031' 17/09/2025 12:53:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '272', 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 = '24031' 17/09/2025 12:53:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '24031' 17/09/2025 12:53:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24031' 17/09/2025 12:53:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24032' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:53:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24032' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24031' 17/09/2025 12:53:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24032' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24031' 17/09/2025 12:55:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002409' AND id_product != '24032' AND ean13 != '' 17/09/2025 12:55:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002409', date_upd = NOW() WHERE id_product = '24032' 17/09/2025 12:55:48 pm >> UPDATE ps_product_lang SET name = 'BUSTINA CON MEDAGLIA C. ACUTIS - A101', description = '' WHERE id_product = '24032' 17/09/2025 12:55:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1' WHERE id_product = '24032' 17/09/2025 12:55:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1', id_tax_rules_group = '4', id_category_default = '272', 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 = '24032' 17/09/2025 12:55:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '24032' 17/09/2025 12:55:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002409' AND id_product != '24032' AND ean13 != '' 17/09/2025 12:55:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002409', date_upd = NOW() WHERE id_product = '24032' 17/09/2025 12:55:56 pm >> UPDATE ps_product_lang SET name = 'BUSTINA CON MEDAGLIA C. ACUTIS - A101', description = '' WHERE id_product = '24032' 17/09/2025 12:55:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.819672131147541' WHERE id_product = '24032' 17/09/2025 12:55:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.819672131147541', id_tax_rules_group = '1', id_category_default = '272', 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 = '24032' 17/09/2025 12:55:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '24032' 17/09/2025 12:57: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 ( '33' , '2025000003636' , '2025-09-16' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.31' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '252.04' , '238.84' , NOW() , NOW() ) 17/09/2025 12:57: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 = '98779' 17/09/2025 12:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98779' 17/09/2025 12:57: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 ( '98779' , '24025' , 'STORIA DI GESU - E. DAL PANE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 17/09/2025 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24025' AND id_supplier = '107' 17/09/2025 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24025' , '107' , '1' ) 17/09/2025 12:57: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 ( '98779' , '24026' , 'LUCE DEL NATALE - G. CORNACCHIONE' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '35' , '4.8750' ) 17/09/2025 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24026' AND id_supplier = '107' 17/09/2025 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24026' , '107' , '1' ) 17/09/2025 12:57: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 ( '98779' , '24027' , 'SI TRATTA DI TE - G. SGUBBI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 17/09/2025 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24027' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24027' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '24028' , 'PIER GIORGIO FRASSATI DIO, IL TESORO - S. FARI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24028' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24028' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '24029' , 'SEMI DEL PRESENTE - A. ORILIA' , '1' , '1' , '4' , '15.50' , '15.5' , '0' , '35' , '10.0750' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24029' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24029' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '24030' , 'FRATELLO DI TUTTI - V. PISTORE' , '1' , '1' , '4' , '21.50' , '21.5' , '0' , '5' , '20.4250' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24030' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24030' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '24031' , 'MISIONEROS DIGITALE - H. G. ARIAS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24031' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24031' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '24032' , 'BUSTINA CON MEDAGLIA C. ACUTIS - A101' , '100' , '100' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '73.2000' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24032' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24032' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '17482' , 'DOMANDE GRANDI DEI BAMBINI N.E. - 1' , '6' , '6' , '4' , '10.00' , '10' , '0' , '35' , '39.0000' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17482' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17482' , '107' , '1' ) 17/09/2025 12:57:21 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 ( '98779' , '17481' , 'DOMANDE GRANDI DEI BAMBINI N.E. - 2' , '6' , '6' , '4' , '10.00' , '10' , '0' , '35' , '39.0000' ) 17/09/2025 12:57:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17481' AND id_supplier = '107' 17/09/2025 12:57:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17481' , '107' , '1' ) 17/09/2025 12:57:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002409' AND id_product != '24032' AND ean13 != '' 17/09/2025 12:57:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002409', date_upd = NOW() WHERE id_product = '24032' 17/09/2025 12:57:53 pm >> UPDATE ps_product_lang SET name = 'BUSTINA CON MEDAGLIA C. ACUTIS - A101', description = '' WHERE id_product = '24032' 17/09/2025 12:57:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.819672131147541' WHERE id_product = '24032' 17/09/2025 12:57:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.819672131147541', id_tax_rules_group = '1', id_category_default = '272', 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 = '24032' 17/09/2025 12:57:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24032' 17/09/2025 12:57:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24032' 17/09/2025 12:57:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24033' , '1' , '' , 'nuovo-prodotto' ) 17/09/2025 12:57:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24033' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24032' 17/09/2025 12:57:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24033' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24032' 17/09/2025 01:02:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 01:02:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3009' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 17/09/2025 01:02:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98780' 17/09/2025 01:02:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '98780' 17/09/2025 01:02:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98780' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 17/09/2025 04:22:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 04:22:34 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' , '3010' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 17/09/2025 04:22:34 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 = '98781' 17/09/2025 04:22:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '98781' 17/09/2025 04:22:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98781' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 17/09/2025 05:03:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 05:03:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3011' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 17/09/2025 05:03:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98782' 17/09/2025 05:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '98782' 17/09/2025 05:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98782' , '22603' , 'CATENINA CM 60 - UASS-0025SXL' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 17/09/2025 05:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98782' , '24032' , 'BUSTINA CON MEDAGLIA C. ACUTIS - A101' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/09/2025 05:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98782' , '' , 'OGGETTI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/09/2025 05:05:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002409' AND id_product != '24032' AND ean13 != '' 17/09/2025 05:05:19 pm >> UPDATE ps_product SET id_supplier = '107', reference = '', ean13 = '002409', date_upd = NOW() WHERE id_product = '24032' 17/09/2025 05:05:19 pm >> UPDATE ps_product_lang SET name = 'BUSTINA CON MEDAGLIA C. ACUTIS - A101', description = '' WHERE id_product = '24032' 17/09/2025 05:05:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.1475409836065573' WHERE id_product = '24032' 17/09/2025 05:05:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.1475409836065573', id_tax_rules_group = '1', id_category_default = '272', 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 = '24032' 17/09/2025 05:05:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '24032' 17/09/2025 05:36:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '115/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 05:36:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '115/A' , '2025-09-17' , 'A' , '3812' , '0' , '4679440' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.20' , '95.70' , NOW() , NOW() ) 17/09/2025 05:36:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98783' 17/09/2025 05:36:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98783' 17/09/2025 05:36:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98783' , '15356' , 'AMPOLLE A BRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 17/09/2025 05:36:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98783' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 17/09/2025 05:36:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98783' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 17/09/2025 05:37:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001169' AND id_product != '15356' AND ean13 != '' 17/09/2025 05:37:02 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001169', date_upd = NOW() WHERE id_product = '15356' 17/09/2025 05:37:02 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO DORATE - 1511', description = '' WHERE id_product = '15356' 17/09/2025 05:37:02 pm >> UPDATE ps_product SET wholesale_price = '40.38', on_sale = '0', price = '86.0656' WHERE id_product = '15356' 17/09/2025 05:37:02 pm >> UPDATE ps_product_shop SET wholesale_price = '40.38', price = '86.0656', id_tax_rules_group = '1', id_category_default = '147', 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 = '15356' 17/09/2025 05:37:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '15356' 17/09/2025 05:53:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 05:53:09 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' , '3012' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 17/09/2025 05:53:09 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 = '98784' 17/09/2025 05:53:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98784' 17/09/2025 05:53:09 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 ( '98784' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 17/09/2025 06:38:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 06:38: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' , '3013' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 17/09/2025 06:38: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 = '98785' 17/09/2025 06:38:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98785' 17/09/2025 06:38: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 ( '98785' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 17/09/2025 07:01:45 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '3kjtGF9s11KcK4Kg' , NOW() , NOW() ) 17/09/2025 07:01:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4235' , '1' ) 17/09/2025 07:01:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4235' , '2' ) 17/09/2025 07:01:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4235' , '3' ) 17/09/2025 07:01:56 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'y9TztcjO9jirGDR2' , NOW() , NOW() ) 17/09/2025 07:01:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7152' , '1' ) 17/09/2025 07:01:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7152' , '2' ) 17/09/2025 07:01:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7152' , '3' ) 17/09/2025 07:05:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 07:05:09 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' , '3014' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 17/09/2025 07:05:09 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 = '98786' 17/09/2025 07:05:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98786' 17/09/2025 07:05:09 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 ( '98786' , '23719' , 'STOLA RICAMO CROCE - 796MTP' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 17/09/2025 07:05:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 17/09/2025 07:05:21 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' , '3015' , '2025-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 17/09/2025 07:05:21 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 = '98787' 17/09/2025 07:05:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '98787' 17/09/2025 07:05:21 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 ( '98787' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/09/2025 07:08:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3000' AND id_document != '98765' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-16') 17/09/2025 07:08:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3000', document_date = '2025-09-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '114.50', price_tax_excluded = '106.37', date_upd = NOW() WHERE id_document = '98765' 17/09/2025 07:08:25 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 = '98765' 17/09/2025 07:08:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '98765' 17/09/2025 07:08:25 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 ( '98765' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 17/09/2025 07:08:25 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 ( '98765' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 17/09/2025 07:08:25 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 ( '98765' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 17/09/2025 07:08:25 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 ( '98765' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '31' , '29.807692307692' , '4' , '0' , '31.00' ) 17/09/2025 07:08:25 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 ( '98765' , '23864' , 'MARIOLOGIA BIBLICA - S. MANELLI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 17/09/2025 07:08:25 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 ( '98765' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 17/09/2025 07:08:25 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 ( '98765' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/09/2025 07:08:25 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 ( '98765' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/09/2025 07:09:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2324' AND id_document != '97940' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 17/09/2025 07:09:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2324', document_date = '2025-07-01', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '97940' 17/09/2025 07:09:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97940' 17/09/2025 07:09:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97940' 17/09/2025 07:09:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97940' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 17/09/2025 07:09:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97940' , '17006' , 'SEGNALIBRO PR' , '50' , '-50' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '15.00' ) 17/09/2025 07:10:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '97945' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 17/09/2025 07:10:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2329', document_date = '2025-07-01', 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 = '31.00', price_tax_excluded = '25.41', date_upd = NOW() WHERE id_document = '97945' 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97945' 17/09/2025 07:10:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97945' 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '23091' , 'PORTAFOTO CON COFANETTO' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 17/09/2025 07:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '17006' , 'SEGNALIBRO PR' , '20' , '-20' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '8.00' ) 17/09/2025 07:10:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2346' AND id_document != '97967' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 17/09/2025 07:10:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2346', document_date = '2025-07-02', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '97967' 17/09/2025 07:10: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 = '97967' 17/09/2025 07:10:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97967' 17/09/2025 07:10: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 ( '97967' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' )