15/04/2025 09:20:25 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 09: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 ( '21' , '12' , '2025-04-15' , '' , '7126' , '0' , '177359080' , 'PIAZZA DON PINUCCIO LATTUCHELLA 85100 POTENZA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '23.90' , '23.90' , NOW() , NOW() ) 15/04/2025 09: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 = '14804' 15/04/2025 09:20:25 am >> DELETE FROM ps_document_detail WHERE id_document = '14804' 15/04/2025 09: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 ( '14804' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '15' , '17.00' ) 15/04/2025 09:32:46 am >> SELECT document_num FROM ps_document WHERE document_num = '15/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 09:32:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '15/E' , '2025-04-15' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '474.00' , '388.52' , NOW() , NOW() ) 15/04/2025 09:32:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96693' 15/04/2025 09:32:46 am >> DELETE FROM ps_document_detail WHERE id_document = '96693' 15/04/2025 09:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96693' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '240.00' ) 15/04/2025 09:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96693' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '20' , '-20' , '1' , '12.00' , '9.8360655737705' , '22' , '40' , '144.00' ) 15/04/2025 09:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96693' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 15/04/2025 09:34:50 am >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 09:34:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '15' , '2025-04-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3980.00' , '3980.00' , NOW() , NOW() ) 15/04/2025 09:34:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96694' 15/04/2025 09:34:50 am >> DELETE FROM ps_document_detail WHERE id_document = '96694' 15/04/2025 09:34:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96694' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '500' , '-500' , '4' , '1.00' , '1' , '0' , '0' , '500.00' ) 15/04/2025 09:34:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96694' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '30' , '-30' , '4' , '7.00' , '7' , '0' , '0' , '210.00' ) 15/04/2025 09:34:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96694' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '312' , '-312' , '4' , '5.00' , '5' , '0' , '0' , '1560.00' ) 15/04/2025 09:34:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96694' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '312' , '-312' , '4' , '5.00' , '5' , '0' , '0' , '1560.00' ) 15/04/2025 09:34:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96694' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '50' , '-50' , '4' , '3.00' , '3' , '0' , '0' , '150.00' ) 15/04/2025 09:36:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 09:36:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '4' , '2025-04-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2400.00' , '2400.00' , NOW() , NOW() ) 15/04/2025 09:36:24 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 = '14805' 15/04/2025 09:36:24 am >> DELETE FROM ps_document_detail WHERE id_document = '14805' 15/04/2025 09:36:24 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 ( '14805' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '480' , '-480' , '4' , '2.50' , '2.5' , '0' , '0' , '1200.00' ) 15/04/2025 09:36:24 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 ( '14805' , '33' , '100 GIORNI CON LO SPIRITO' , '100' , '-100' , '4' , '7.50' , '7.5' , '0' , '0' , '750.00' ) 15/04/2025 09:36:24 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 ( '14805' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '300' , '-300' , '4' , '1.50' , '1.5' , '0' , '0' , '450.00' ) 15/04/2025 10:05:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 10:05: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' , '1251' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 15/04/2025 10:05: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 = '96695' 15/04/2025 10:05:51 am >> DELETE FROM ps_document_detail WHERE id_document = '96695' 15/04/2025 10:05:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96695' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 15/04/2025 10:12:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 10:12:20 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' , '1252' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '92.15' , NOW() , NOW() ) 15/04/2025 10:12:20 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 = '96696' 15/04/2025 10:12:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96696' 15/04/2025 10:12:20 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 ( '96696' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 15/04/2025 10:12:20 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 ( '96696' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '84.00' ) 15/04/2025 10:12:20 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 ( '96696' , '20758' , 'SEGNALIBRO 5X15' , '10' , '-10' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '2.00' ) 15/04/2025 10:12:20 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 ( '96696' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/04/2025 10:12:20 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 ( '96696' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 15/04/2025 10:13:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 10:13: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' , '1253' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 15/04/2025 10:13: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 = '96697' 15/04/2025 10:13:37 am >> DELETE FROM ps_document_detail WHERE id_document = '96697' 15/04/2025 10:13: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 ( '96697' , '20936' , 'SANTA RITA - VITA BREVIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 15/04/2025 10:27:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 10:27:58 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' , '1254' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.84' , NOW() , NOW() ) 15/04/2025 10:27:58 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 = '96698' 15/04/2025 10:27:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96698' 15/04/2025 10:27:58 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 ( '96698' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.6' , '40.655737704918' , '22' , '0' , '49.60' ) 15/04/2025 10:27:58 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 ( '96698' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 15/04/2025 10:27:58 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 ( '96698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.9' , '13.032786885246' , '22' , '0' , '15.90' ) 15/04/2025 10:27:58 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 ( '96698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/04/2025 10:27:58 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 ( '96698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 15/04/2025 10:53:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 10:53:26 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' , '1255' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '17.31' , NOW() , NOW() ) 15/04/2025 10:53:26 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 = '96699' 15/04/2025 10:53:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96699' 15/04/2025 10:53:26 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 ( '96699' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '2' , '-2' , '3' , '9' , '8.6538461538462' , '4' , '0' , '18.00' ) 15/04/2025 11:05:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358015028' AND id_product != '1425' AND ean13 != '' 15/04/2025 11:05:16 am >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '8002358015028', date_upd = NOW() WHERE id_product = '1425' 15/04/2025 11:05:16 am >> UPDATE ps_product_lang SET name = 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM', description = '' WHERE id_product = '1425' 15/04/2025 11:05:16 am >> UPDATE ps_product SET wholesale_price = '5.00', on_sale = '0', price = '9.426229508196721' WHERE id_product = '1425' 15/04/2025 11:05:16 am >> UPDATE ps_product_shop SET wholesale_price = '5.00', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1425' 15/04/2025 11:05:16 am >> DELETE FROM ps_specific_price WHERE id_product = '1425' 15/04/2025 11:06:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1256' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:06:32 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' , '1256' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 15/04/2025 11:06:32 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 = '96700' 15/04/2025 11:06:32 am >> DELETE FROM ps_document_detail WHERE id_document = '96700' 15/04/2025 11:06:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96700' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 15/04/2025 11:07:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358015028' AND id_product != '1425' AND ean13 != '' 15/04/2025 11:07:31 am >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '8002358015028', date_upd = NOW() WHERE id_product = '1425' 15/04/2025 11:07:31 am >> UPDATE ps_product_lang SET name = 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM', description = '' WHERE id_product = '1425' 15/04/2025 11:07:31 am >> UPDATE ps_product SET wholesale_price = '5.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '1425' 15/04/2025 11:07:31 am >> UPDATE ps_product_shop SET wholesale_price = '5.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1425' 15/04/2025 11:07:31 am >> DELETE FROM ps_specific_price WHERE id_product = '1425' 15/04/2025 11:08:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:08:07 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' , '1257' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '218.72' , '218.72' , NOW() , NOW() ) 15/04/2025 11:08:07 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 = '96701' 15/04/2025 11:08:07 am >> DELETE FROM ps_document_detail WHERE id_document = '96701' 15/04/2025 11:08:07 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 ( '96701' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '32' , '-32' , '4' , '5.00' , '5' , '0' , '5' , '152.00' ) 15/04/2025 11:08:07 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 ( '96701' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 15/04/2025 11:08:07 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 ( '96701' , '23491' , 'AMEN - MAG 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 15/04/2025 11:08:07 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 ( '96701' , '23492' , 'AMEN - GIU 25' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 15/04/2025 11:08:07 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 ( '96701' , '23606' , 'MESSA MEDITAZIONE - MAG/GIU 25' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 15/04/2025 11:08:07 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 ( '96701' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 15/04/2025 11:13:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'G1257' , '2025-04-11' , '' , '0' , '31' , '2626' , 'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '854.26' , '700.21' , NOW() , NOW() ) 15/04/2025 11:13:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96702' 15/04/2025 11:13:30 am >> DELETE FROM ps_document_detail WHERE id_document = '96702' 15/04/2025 11:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '24' , '24' , '1' , '10' , '8.1967213114754' , '22' , '50+3' , '142.0080' ) 15/04/2025 11:13:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '31' 15/04/2025 11:13:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '31' , '1' ) 15/04/2025 11:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '240' , '240' , '1' , '1.93' , '1.5819672131148' , '22' , '50+3' , '274.0754' ) 15/04/2025 11:13:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '36' , '36' , '1' , '6.4' , '5.2459016393443' , '22' , '50+3' , '136.3277' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11626' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11626' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '24' , '24' , '1' , '5.64' , '4.6229508196721' , '22' , '50+3' , '80.0925' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11623' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11623' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '11624' , 'PALLA 16X16 - SERV 3 ' , '24' , '24' , '1' , '5.06' , '4.1475409836066' , '22' , '50+3' , '71.8560' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11624' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11624' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '12' , '12' , '1' , '10.2' , '8.3606557377049' , '22' , '50+3' , '72.4241' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11625' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11625' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '6402' , 'MENSA BIANCA 60X200 ' , '6' , '6' , '1' , '5.64' , '4.6229508196721' , '22' , '50+3' , '20.0231' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '6402' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6402' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '4' , '4' , '1' , '14' , '11.475409836066' , '22' , '50+3' , '33.1352' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11272' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11272' , '31' , '1' ) 15/04/2025 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96702' , '21349' , 'MENSA BIANCA 80X300 - M8030' , '3' , '3' , '1' , '13.7' , '11.229508196721' , '22' , '50+3' , '24.3189' ) 15/04/2025 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '21349' AND id_supplier = '31' 15/04/2025 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21349' , '31' , '1' ) 15/04/2025 11:33:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '96699' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:33:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1255', document_date = '2025-04-15', 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 = '18.00', price_tax_excluded = '17.31', date_upd = NOW() WHERE id_document = '96699' 15/04/2025 11:33:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96699' 15/04/2025 11:33:46 am >> DELETE FROM ps_document_detail WHERE id_document = '96699' 15/04/2025 11:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96699' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 15/04/2025 11:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96699' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 15/04/2025 11:36:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:36:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1258' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 15/04/2025 11:36:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96703' 15/04/2025 11:36:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96703' 15/04/2025 11:36:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96703' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 15/04/2025 11:37:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:37:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1259' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.70' , '16.11' , NOW() , NOW() ) 15/04/2025 11:37:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96704' 15/04/2025 11:37:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96704' 15/04/2025 11:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96704' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '13.20' ) 15/04/2025 11:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96704' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/04/2025 11:37:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96704' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 15/04/2025 11:41:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:41:12 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' , '1260' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '14.42' , NOW() , NOW() ) 15/04/2025 11:41:12 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 = '96705' 15/04/2025 11:41:12 am >> DELETE FROM ps_document_detail WHERE id_document = '96705' 15/04/2025 11:41:12 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 ( '96705' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '15' , '14.423076923077' , '4' , '0' , '15.00' ) 15/04/2025 11:42:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1260' AND id_document != '96705' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:42:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1260', document_date = '2025-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.00', price_tax_excluded = '14.42', date_upd = NOW() WHERE id_document = '96705' 15/04/2025 11:42:39 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 = '96705' 15/04/2025 11:42:39 am >> DELETE FROM ps_document_detail WHERE id_document = '96705' 15/04/2025 11:42:39 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 ( '96705' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.8' , '1.7307692307692' , '4' , '0' , '1.80' ) 15/04/2025 11:42:39 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 ( '96705' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.3' , '3.1730769230769' , '4' , '0' , '13.20' ) 15/04/2025 11:50:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:50:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1261' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.40' , '14.11' , NOW() , NOW() ) 15/04/2025 11:50:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96706' 15/04/2025 11:50:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96706' 15/04/2025 11:50:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96706' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 15/04/2025 11:50:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96706' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 15/04/2025 11:50:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 11:50: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' , '1262' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.70' , '5.49' , NOW() , NOW() ) 15/04/2025 11:50: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 = '96707' 15/04/2025 11:50:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96707' 15/04/2025 11:50: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 ( '96707' , '7218' , 'OLIO DI NARDO ROSA - 1079/101ITA' , '1' , '-1' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '6.70' ) 15/04/2025 12:06:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 12:06: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' , '1263' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 15/04/2025 12:06: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 = '96708' 15/04/2025 12:06:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96708' 15/04/2025 12:06: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 ( '96708' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 15/04/2025 12:17:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '96483' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02') 15/04/2025 12:17:04 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2025-04-02', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.00', price_tax_excluded = '31.75', date_upd = NOW() WHERE id_document = '96483' 15/04/2025 12:17:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96483' 15/04/2025 12:17:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96483' 15/04/2025 12:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96483' , '23503' , 'TRISTE CASO DELLOMELIA - F. ROSINI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/04/2025 12:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96483' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '18.00' ) 15/04/2025 12:34:08 pm >> DELETE FROM ps_document WHERE id_document = '96483' 15/04/2025 12:34:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '96483' 15/04/2025 12:34:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '96694' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 12:34:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '15', document_date = '2025-04-15', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '3980.00', price_tax_excluded = '3980.00', date_upd = NOW() WHERE id_document = '96694' 15/04/2025 12:34: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 = '96694' 15/04/2025 12:34:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '96694' 15/04/2025 12:34: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 ( '96694' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '500' , '-500' , '4' , '1.0000' , '1' , '0' , '0' , '500.00' ) 15/04/2025 12:34: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 ( '96694' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '30' , '-30' , '4' , '7.0000' , '7' , '0' , '0' , '210.00' ) 15/04/2025 12:34: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 ( '96694' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '312' , '-312' , '4' , '5.0000' , '5' , '0' , '0' , '1560.00' ) 15/04/2025 12:34: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 ( '96694' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '312' , '-312' , '4' , '5.0000' , '5' , '0' , '0' , '1560.00' ) 15/04/2025 12:34: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 ( '96694' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '0' , '150.00' ) 15/04/2025 12:43:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1264' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 12:43:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1264' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 15/04/2025 12:43:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96709' 15/04/2025 12:43:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '96709' 15/04/2025 12:43:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96709' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 15/04/2025 12:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1265' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 12:58: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' , '1265' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '979.40' , '848.39' , NOW() , NOW() ) 15/04/2025 12:58: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 = '96710' 15/04/2025 12:58:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96710' 15/04/2025 12:58: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 ( '96710' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/04/2025 12:58: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 ( '96710' , '23503' , 'TRISTE CASO DELL\'OMELIA - F. ROSINI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 15/04/2025 12:58: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 ( '96710' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 15/04/2025 12:58: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 ( '96710' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '145' , '118.85245901639' , '22' , '0' , '290.00' ) 15/04/2025 12:58: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 ( '96710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 15/04/2025 12:58: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 ( '96710' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 15/04/2025 12:58: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 ( '96710' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 15/04/2025 12:58: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 ( '96710' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 15/04/2025 12:58: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 ( '96710' , '23672' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/3 - RATZINGER' , '1' , '-1' , '4' , '75.00' , '75' , '0' , '5' , '71.25' ) 15/04/2025 12:58: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 ( '96710' , '23671' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/1-2 - RATZINGER' , '1' , '-1' , '4' , '130.00' , '130' , '0' , '5' , '123.50' ) 15/04/2025 12:58: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 ( '96710' , '19757' , 'PIVIALE - KKP/024/02/20' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 15/04/2025 12:58: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 ( '96710' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.00' , '7' , '0' , '5' , '19.95' ) 15/04/2025 02:25:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '722' AND id_document != '96036' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-05') 15/04/2025 02:25:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '722', document_date = '2025-03-05', 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 = '198.80', price_tax_excluded = '166.38', date_upd = NOW() WHERE id_document = '96036' 15/04/2025 02:25:01 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 = '96036' 15/04/2025 02:25:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96036' 15/04/2025 02:25:01 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 ( '96036' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 15/04/2025 02:25:01 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 ( '96036' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 15/04/2025 02:25:01 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 ( '96036' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '144' , '118.03278688525' , '22' , '0' , '144.00' ) 15/04/2025 02:25:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '842' AND id_document != '90873' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 15/04/2025 02:25:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '842', document_date = '2024-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '90873' 15/04/2025 02:25: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 = '90873' 15/04/2025 02:25:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90873' 15/04/2025 02:25: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 ( '90873' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 15/04/2025 02:27:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1008' AND id_document != '96407' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-29') 15/04/2025 02:27:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1008', document_date = '2025-03-29', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '96407' 15/04/2025 02:27:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96407' 15/04/2025 02:27:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '96407' 15/04/2025 02:27:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96407' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 15/04/2025 02:39: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 ( '33' , '695315' , '2025-04-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.41' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.89' , '81.89' , NOW() , NOW() ) 15/04/2025 02:39: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 = '96711' 15/04/2025 02:39:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '96711' 15/04/2025 02:39: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 ( '96711' , '23658' , 'ROSARIO FLAGELLO DEI DEMONI - F. BAMONTE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '33' , '8.6430' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23658' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23658' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '23637' , 'PREGHIERA CHE SALVA IL MONDO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '30' , '1.4000' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23637' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23637' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '20778' , 'PASSIO N.E.' , '11' , '11' , '4' , '6.00' , '6' , '0' , '35' , '42.9000' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20778' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20778' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '23491' , 'AMEN - MAG 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23491' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23491' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '23492' , 'AMEN - GIU 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23492' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23492' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '23486' , 'SERVI INUTILI A TEMPO PIENO - T. BELLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23486' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23486' , '7' , '1' ) 15/04/2025 02:39: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 ( '96711' , '23443' , 'MA COME SI FA?' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 15/04/2025 02:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23443' AND id_supplier = '7' 15/04/2025 02:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23443' , '7' , '1' ) 15/04/2025 03:12:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 15/04/2025 03:12:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '290.00', price_tax_excluded = '290.00', date_upd = NOW() WHERE id_document = '96095' 15/04/2025 03:12: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 = '96095' 15/04/2025 03:12:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '96095' 15/04/2025 03:12: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 ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '10' , '-10' , '0' , '60.0000' , '60' , '0' , '' , '600.00' ) 15/04/2025 03:12: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '6' , '-6' , '0' , '-40.0000' , '-40' , '0' , '0' , '-240.00' ) 15/04/2025 03:12: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE -' , '2' , '-2' , '0' , '-35.0000' , '-35' , '0' , '0' , '-70.00' ) 15/04/2025 03:12: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - da disegnare' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/04/2025 03:19:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1266' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:19:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1266' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.10' , '7.28' , NOW() , NOW() ) 15/04/2025 03:19:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96712' 15/04/2025 03:19:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '96712' 15/04/2025 03:19:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96712' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 15/04/2025 03:19:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96712' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 15/04/2025 03:23:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1262' AND id_document != '96707' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:23:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1262', document_date = '2025-04-15', 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 = '6.70', price_tax_excluded = '5.49', date_upd = NOW() WHERE id_document = '96707' 15/04/2025 03:23:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96707' 15/04/2025 03:23:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96707' 15/04/2025 03:23:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96707' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.7' , '5.4918032786885' , '22' , '0' , '6.70' ) 15/04/2025 03:41:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1267' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:41:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1267' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 15/04/2025 03:41:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96713' 15/04/2025 03:41:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96713' 15/04/2025 03:41:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96713' , '20778' , 'PASSIO N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 15/04/2025 03:43:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1268' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:43:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1268' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 15/04/2025 03:43:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96714' 15/04/2025 03:43:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '96714' 15/04/2025 03:43:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96714' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 15/04/2025 03:51:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1269' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:51:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1269' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 15/04/2025 03:51:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96715' 15/04/2025 03:51:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96715' 15/04/2025 03:51:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96715' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/04/2025 03:56:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 03:56:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1270' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 15/04/2025 03:56:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96716' 15/04/2025 03:56:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '96716' 15/04/2025 03:56: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 ( '96716' , '19594' , 'POLO JERSEY COTONE 100%' , '3' , '-3' , '1' , '40' , '32.786885245902' , '22' , '0' , '120.00' ) 15/04/2025 03:56: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 ( '96716' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 15/04/2025 04:24:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '902' AND id_document != '96277' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-18') 15/04/2025 04:24:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '902', document_date = '2025-03-18', 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 = '96277' 15/04/2025 04:24:40 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 = '96277' 15/04/2025 04:24:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96277' 15/04/2025 04:24:40 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 ( '96277' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 15/04/2025 05:37:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 05:37: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' , '1271' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 15/04/2025 05:37: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 = '96717' 15/04/2025 05:37:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96717' 15/04/2025 05:37: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 ( '96717' , '22104' , 'TURIBOLO - TURI' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 15/04/2025 05:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 05:40:16 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' , '1272' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 15/04/2025 05:40:16 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 = '96718' 15/04/2025 05:40:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '96718' 15/04/2025 05:40:16 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 ( '96718' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 15/04/2025 05:40:16 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 ( '96718' , '13534' , 'SAN PIETRO CM 13 - SP/13' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/04/2025 06:01:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1273' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 06:01: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' , '1273' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 15/04/2025 06:01: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 = '96719' 15/04/2025 06:01:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '96719' 15/04/2025 06:01: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 ( '96719' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '55' , '55' , '0' , '0' , '55.00' ) 15/04/2025 06:10:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 15/04/2025 06:10:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '8.90', price_tax_excluded = '7.30', date_upd = NOW() WHERE id_document = '94912' 15/04/2025 06:10: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 = '94912' 15/04/2025 06:10:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 15/04/2025 06:10: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 ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 15/04/2025 06:10:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 15/04/2025 06:10:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '8.90', price_tax_excluded = '7.30', date_upd = NOW() WHERE id_document = '94912' 15/04/2025 06: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 = '94912' 15/04/2025 06:10:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 15/04/2025 06: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 ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 15/04/2025 06:27:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 06:27: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 ( '11' , '1274' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 15/04/2025 06:27: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 = '96720' 15/04/2025 06:27:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '96720' 15/04/2025 06:27: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 ( '96720' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 15/04/2025 06:32:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 15/04/2025 06:32: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' , '1275' , '2025-04-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 15/04/2025 06:32: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 = '96721' 15/04/2025 06:32:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '96721' 15/04/2025 06:32: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 ( '96721' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 15/04/2025 09:25:43 pm >> UPDATE ps_customer SET active = '0' WHERE id_customer = '7083'