14/01/2025 09:20:14 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/01/2025 09:20:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23341' , '1' , '' , 'nuovo-prodotto' ) 14/01/2025 09:20:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23341' , '1' , '1' , '2' , NOW() , NOW() ) 14/01/2025 09:20:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23341' , '0' , '1' , '0' , '0' ) 14/01/2025 09:29:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804797548' AND id_product != '23341' AND ean13 != '' 14/01/2025 09:29:22 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788804797548', date_upd = NOW() WHERE id_product = '23341' 14/01/2025 09:29:22 am >> UPDATE ps_product_lang SET name = 'SPERA - PAPA FRANCESCO', description = '' WHERE id_product = '23341' 14/01/2025 09:29:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '23341' 14/01/2025 09:29:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '333', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23341' 14/01/2025 09:29:22 am >> DELETE FROM ps_specific_price WHERE id_product = '23341' 14/01/2025 09:46:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1542337' , '2025-01-10' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '533.80' , '533.80' , NOW() , NOW() ) 14/01/2025 09:46:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95262' 14/01/2025 09:46:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95262' 14/01/2025 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95262' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '5' , '4' , '12.00' , '12' , '0' , '0' , '60.0000' ) 14/01/2025 09:46:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 14/01/2025 09:46:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 14/01/2025 09:46:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95262' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '2' , '2' , '4' , '16.90' , '16.9' , '0' , '0' , '33.8000' ) 14/01/2025 09:46:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '23006' AND id_supplier = '177' 14/01/2025 09:46:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23006' , '177' , '1' ) 14/01/2025 09:46:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95262' , '23341' , 'SPERA - PAPA FRANCESCO' , '20' , '20' , '4' , '22.00' , '22' , '0' , '0' , '440.0000' ) 14/01/2025 09:46:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23341' AND id_supplier = '177' 14/01/2025 09:46:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23341' , '177' , '1' ) 14/01/2025 10:07:01 am >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:07:01 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' , '128' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.23' , '5.23' , NOW() , NOW() ) 14/01/2025 10:07:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95263' 14/01/2025 10:07:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95263' 14/01/2025 10:07:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95263' , '8501' , 'PRIMA RICONCILIAZIONE' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 14/01/2025 10:25:45 am >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:25:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '129' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 14/01/2025 10:25:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95264' 14/01/2025 10:25:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95264' 14/01/2025 10:25:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95264' , '23339' , 'PASTORES DABO VOBIS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/01/2025 10:42:46 am >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:42: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 ( '11' , '130' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '24.70' , NOW() , NOW() ) 14/01/2025 10:42: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 = '95265' 14/01/2025 10:42:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95265' 14/01/2025 10:42: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 ( '95265' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/01/2025 10:42: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 ( '95265' , '17629' , 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/01/2025 10:42: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 ( '95265' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/01/2025 10:42: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 ( '95265' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/01/2025 10:42: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 ( '95265' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/01/2025 10:45:15 am >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:45:15 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' , '131' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 14/01/2025 10:45:15 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 = '95266' 14/01/2025 10:45:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95266' 14/01/2025 10:45:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95266' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 14/01/2025 10:48:48 am >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:48:48 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' , '132' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 14/01/2025 10:48:48 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 = '95267' 14/01/2025 10:48:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95267' 14/01/2025 10:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95267' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 14/01/2025 10:50:51 am >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 10:50: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' , '133' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '16.15' , NOW() , NOW() ) 14/01/2025 10:50: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 = '95268' 14/01/2025 10:50:51 am >> DELETE FROM ps_document_detail WHERE id_document = '95268' 14/01/2025 10:50: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 ( '95268' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 14/01/2025 10:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95268' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 14/01/2025 10:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95268' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/01/2025 11:04:34 am >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 11:04:34 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' , '134' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.80' , '47.43' , NOW() , NOW() ) 14/01/2025 11:04:34 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 = '95269' 14/01/2025 11:04:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95269' 14/01/2025 11:04:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95269' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 14/01/2025 11:04:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95269' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 14/01/2025 11:04:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95269' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 14/01/2025 11:04:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95269' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 14/01/2025 11:04:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95269' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 14/01/2025 11:10:00 am >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '95223' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09') 14/01/2025 11:10:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '95', document_date = '2025-01-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.30', price_tax_excluded = '21.56', date_upd = NOW() WHERE id_document = '95223' 14/01/2025 11:10:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95223' 14/01/2025 11:10:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95223' 14/01/2025 11:10:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95223' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 14/01/2025 11:10:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95223' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 14/01/2025 11:25:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 11:25: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 ( '21' , '4' , '2025-01-14' , '' , '3266' , '0' , '4679047' , 'VIA DANTE 35 07010 MARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '83.51' , '83.51' , NOW() , NOW() ) 14/01/2025 11:25: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 = '95270' 14/01/2025 11:25:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95270' 14/01/2025 11:25: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 ( '95270' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '7' , '-7' , '4' , '5.50' , '5.5' , '0' , '5' , '36.57' ) 14/01/2025 11:25: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 ( '95270' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '5' , '20.90' ) 14/01/2025 11:25: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 ( '95270' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4' , '-4' , '4' , '2.80' , '2.8' , '0' , '5' , '10.64' ) 14/01/2025 11:25: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 ( '95270' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 14/01/2025 11:25: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 ( '95270' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '8' , '-8' , '4' , '0.50' , '0.5' , '0' , '0' , '4.00' ) 14/01/2025 11:25: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 ( '95270' , '' , 'pergamene prima comunione' , '4' , '-4' , '4' , '0.7' , '0.7' , '0' , '0' , '2.80' ) 14/01/2025 11:25: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 ( '95270' , '' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 14/01/2025 11:33:44 am >> SELECT document_num FROM ps_document WHERE document_num = '135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 11:33:44 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' , '135' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 14/01/2025 11:33:44 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 = '95271' 14/01/2025 11:33:44 am >> DELETE FROM ps_document_detail WHERE id_document = '95271' 14/01/2025 11:33:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95271' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 14/01/2025 11:39:05 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3266' 14/01/2025 11:39:05 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3266' , '10' , '211' , '' , 'MARIANI' , 'PACIFICA' , 'VIA DANTE 35' , '' , '07010' , 'MARA' , '' , '0799568062' , '' , '' , '' , NOW() , NOW() ) 14/01/2025 11:39:05 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3266' 14/01/2025 12:22:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884046505' AND id_product != '17629' AND ean13 != '' 14/01/2025 12:22:40 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884046505', date_upd = NOW() WHERE id_product = '17629' 14/01/2025 12:22:40 pm >> UPDATE ps_product_lang SET name = 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207', description = '' WHERE id_product = '17629' 14/01/2025 12:22:40 pm >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '17629' 14/01/2025 12:22:40 pm >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17629' 14/01/2025 12:22:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '17629' 14/01/2025 02:17:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/01/2025 02:17:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23342' , '1' , '' , 'nuovo-prodotto' ) 14/01/2025 02:17:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23342' , '1' , '1' , '2' , NOW() , NOW() ) 14/01/2025 02:17:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23342' , '0' , '1' , '0' , '0' ) 14/01/2025 02:19:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000018585' AND id_product != '23342' AND ean13 != '' 14/01/2025 02:19:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000018585', date_upd = NOW() WHERE id_product = '23342' 14/01/2025 02:19:19 pm >> UPDATE ps_product_lang SET name = 'PATENA OFFERTORIALE - 889', description = '' WHERE id_product = '23342' 14/01/2025 02:19:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '89.34426229508198' WHERE id_product = '23342' 14/01/2025 02:19:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '89.34426229508198', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23342' 14/01/2025 02:19:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '23342' 14/01/2025 02:19:22 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23342' 14/01/2025 02:19:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23343' , '1' , '' , 'nuovo-prodotto' ) 14/01/2025 02:19:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23343' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23342' 14/01/2025 02:19:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23343' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23342' 14/01/2025 02:21:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000717' AND id_product != '4194' AND ean13 != '' 14/01/2025 02:21:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '000717', date_upd = NOW() WHERE id_product = '4194' 14/01/2025 02:21:36 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA - 1180', description = '' WHERE id_product = '4194' 14/01/2025 02:21:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '33.60655737704918' WHERE id_product = '4194' 14/01/2025 02:21:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '33.60655737704918', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4194' 14/01/2025 02:21:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '4194' 14/01/2025 02:34:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000241' AND id_product != '9716' AND ean13 != '' 14/01/2025 02:34:53 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000241', date_upd = NOW() WHERE id_product = '9716' 14/01/2025 02:34:53 pm >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIE INOX IHS - CM 9,5 X 12,5 - 682', description = '' WHERE id_product = '9716' 14/01/2025 02:34:53 pm >> UPDATE ps_product SET wholesale_price = '9.98', on_sale = '0', price = '23.770491803278688' WHERE id_product = '9716' 14/01/2025 02:34:54 pm >> UPDATE ps_product_shop SET wholesale_price = '9.98', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9716' 14/01/2025 02:34:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '9716' 14/01/2025 02:43:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000046' AND id_product != '7735' AND ean13 != '' 14/01/2025 02:43:57 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000046', date_upd = NOW() WHERE id_product = '7735' 14/01/2025 02:43:57 pm >> UPDATE ps_product_lang SET name = 'PATENA OTTONE - DIAM. 14 - 900', description = '' WHERE id_product = '7735' 14/01/2025 02:43:57 pm >> UPDATE ps_product SET wholesale_price = '17.58', on_sale = '0', price = '36.0655737704918' WHERE id_product = '7735' 14/01/2025 02:43:57 pm >> UPDATE ps_product_shop SET wholesale_price = '17.58', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7735' 14/01/2025 02:43:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '7735' 14/01/2025 02:45:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032185' AND id_product != '17741' AND ean13 != '' 14/01/2025 02:45:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032185', date_upd = NOW() WHERE id_product = '17741' 14/01/2025 02:45:48 pm >> UPDATE ps_product_lang SET name = 'CORDA BORDEAUX m 150 - 4000/C', description = '' WHERE id_product = '17741' 14/01/2025 02:45:48 pm >> UPDATE ps_product SET wholesale_price = '15.20', on_sale = '0', price = '36.885245901639344' WHERE id_product = '17741' 14/01/2025 02:45:48 pm >> UPDATE ps_product_shop SET wholesale_price = '15.20', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17741' 14/01/2025 02:45:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '17741' 14/01/2025 03:05:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032178' AND id_product != '23343' AND ean13 != '' 14/01/2025 03:05:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032178', date_upd = NOW() WHERE id_product = '23343' 14/01/2025 03:05:17 pm >> UPDATE ps_product_lang SET name = 'PIANTANA ACCIAIO DORATO - 4000/P', description = '' WHERE id_product = '23343' 14/01/2025 03:05:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '94.26229508196721' WHERE id_product = '23343' 14/01/2025 03:05:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '94.26229508196721', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23343' 14/01/2025 03:05:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '23343' 14/01/2025 03:05:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032178' AND id_product != '23343' AND ean13 != '' 14/01/2025 03:05:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032178', date_upd = NOW() WHERE id_product = '23343' 14/01/2025 03:05:33 pm >> UPDATE ps_product_lang SET name = 'PIANTANA ACCIAIO DORATO - 4000/P', description = '' WHERE id_product = '23343' 14/01/2025 03:05:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98.36065573770492' WHERE id_product = '23343' 14/01/2025 03:05:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98.36065573770492', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23343' 14/01/2025 03:05:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '23343' 14/01/2025 03:06:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '49' , '2025-01-10' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '18.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '597.18' , '489.50' , NOW() , NOW() ) 14/01/2025 03:06:06 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 = '95272' 14/01/2025 03:06:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '95272' 14/01/2025 03:06:06 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 ( '95272' , '23342' , 'PATENA OFFERTORIALE - 889' , '1' , '1' , '1' , '49.5' , '40.573770491803' , '22' , '5' , '57.3705' ) 14/01/2025 03:06:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23342' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23342' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '4194' , 'FINTA CANDELA COMPLETA DI CARTUCCIA - 1180' , '2' , '2' , '1' , '18.5' , '15.16393442623' , '22' , '5' , '42.8830' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4194' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4194' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '20899' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188' , '1' , '1' , '1' , '11.8' , '9.672131147541' , '22' , '5' , '13.6762' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20899' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20899' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '1' , '1' , '1' , '8' , '6.5573770491803' , '22' , '5' , '9.2720' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1752' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1752' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4' , '3.2786885245902' , '22' , '5' , '9.2720' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23215' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23215' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '5976' , 'LUCERNA VETRO - 1493' , '4' , '4' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '39.4060' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5976' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5976' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '15.6465' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21583' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21583' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '9716' , 'SCATOLA PORTA OSTIE INOX IHS - CM 9,5 X 12,5 - 682' , '1' , '1' , '1' , '13' , '10.655737704918' , '22' , '5' , '15.0670' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9716' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9716' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '100' , '100' , '1' , '0.24' , '0.19672131147541' , '22' , '5' , '27.8160' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '3' , '3' , '1' , '21' , '17.213114754098' , '22' , '5' , '73.0170' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '780' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '780' , '12' , '1' ) 14/01/2025 03:06:07 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 ( '95272' , '22318' , 'BOSSOLO OTTONE 8X14 - 162' , '1' , '1' , '1' , '28.5' , '23.360655737705' , '22' , '5' , '33.0315' ) 14/01/2025 03:06:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22318' AND id_supplier = '12' 14/01/2025 03:06:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22318' , '12' , '1' ) 14/01/2025 03:06:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95272' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '2' , '1' , '18.5' , '15.16393442623' , '22' , '5' , '42.8830' ) 14/01/2025 03:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 14/01/2025 03:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 14/01/2025 03:06:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95272' , '17741' , 'CORDA BORDEAUX m 150 - 4000/C' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '5' , '23.1800' ) 14/01/2025 03:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17741' AND id_supplier = '12' 14/01/2025 03:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17741' , '12' , '1' ) 14/01/2025 03:06:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95272' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '1' , '1' , '24' , '19.672131147541' , '22' , '5' , '27.8160' ) 14/01/2025 03:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15351' AND id_supplier = '12' 14/01/2025 03:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15351' , '12' , '1' ) 14/01/2025 03:06:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95272' , '21457' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 3,2X60 - 1135' , '2' , '2' , '1' , '11.5' , '9.4262295081967' , '22' , '5' , '26.6570' ) 14/01/2025 03:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21457' AND id_supplier = '12' 14/01/2025 03:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21457' , '12' , '1' ) 14/01/2025 03:06:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95272' , '23343' , 'PIANTANA ACCIAIO DORATO - 4000/P' , '2' , '2' , '1' , '51' , '41.803278688525' , '22' , '5' , '118.2180' ) 14/01/2025 03:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23343' AND id_supplier = '12' 14/01/2025 03:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23343' , '12' , '1' ) 14/01/2025 03:13:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 03:13:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '136' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.50' , '66.99' , NOW() , NOW() ) 14/01/2025 03:13: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 = '95273' 14/01/2025 03:13:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95273' 14/01/2025 03:13: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 ( '95273' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 14/01/2025 03:13: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 ( '95273' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 14/01/2025 03:13: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 ( '95273' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/01/2025 03:13: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 ( '95273' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/01/2025 03:15:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 03:15:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '137' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.40' , '13.44' , NOW() , NOW() ) 14/01/2025 03:15:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95274' 14/01/2025 03:15:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95274' 14/01/2025 03:15:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95274' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 14/01/2025 03:15:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95274' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '9.40' ) 14/01/2025 03:26:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 03:26: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 ( '24' , '21/A' , '2025-01-14' , 'A' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '21.00' , NOW() , NOW() ) 14/01/2025 03:26: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 = '95275' 14/01/2025 03:26:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '95275' 14/01/2025 03:26:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95275' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.70' , '0.7' , '0' , '0' , '21.00' ) 14/01/2025 03:28:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 03:28:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '2/E' , '2025-01-14' , 'E' , '202' , '0' , '4670823' , 'VIA BRIGNANO INFERIORE, 31 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '34.90' , '29.41' , NOW() , NOW() ) 14/01/2025 03:28: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 = '95276' 14/01/2025 03:28:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '95276' 14/01/2025 03:28: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 ( '95276' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 14/01/2025 03:28: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 ( '95276' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 14/01/2025 03:28: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 ( '95276' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 14/01/2025 03:29:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 03:29:46 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 ( '23' , '1/L' , '2025-01-14' , 'L' , '202' , '0' , '4670823' , 'VIA BRIGNANO INFERIORE, 31 84135 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '34.90' , '34.90' , NOW() , NOW() ) 14/01/2025 03:29:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95277' 14/01/2025 03:29:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '95277' 14/01/2025 03:29:46 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 ( '95277' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 14/01/2025 03:29:46 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 ( '95277' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 14/01/2025 03:29:46 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 ( '95277' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '100' , '-100' , '1' , '0.3000' , '0.2459' , '22' , '0' , '30.00' ) 14/01/2025 03:29:53 pm >> DELETE FROM ps_document WHERE id_document = '95276' 14/01/2025 03:29:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95276' 14/01/2025 04:08:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 04:08:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '138' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '268.00' , '265.32' , NOW() , NOW() ) 14/01/2025 04:08:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95278' 14/01/2025 04:08:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95278' 14/01/2025 04:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95278' , '1823' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '25' , '-25' , '4' , '10.00' , '10' , '0' , '0' , '250.00' ) 14/01/2025 04:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95278' , '22240' , 'PERGAMENA CRESIMA' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 14/01/2025 04:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95278' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 14/01/2025 04:09:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 04:09: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' , '139' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 14/01/2025 04:09: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 = '95279' 14/01/2025 04:09:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95279' 14/01/2025 04:09: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 ( '95279' , '9409' , 'SAN DANIELE COMBONI - G. PESENTI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 14/01/2025 04:10:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 04:10: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 ( '21' , '5' , '2025-01-14' , '' , '3432' , '0' , '4670953' , 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.88' , '61.88' , NOW() , NOW() ) 14/01/2025 04:10: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 = '95280' 14/01/2025 04:10:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95280' 14/01/2025 04:10: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 ( '95280' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '26' , '-26' , '4' , '2.80' , '2.8' , '0' , '15' , '61.88' ) 14/01/2025 04:14:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '95280' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 04:14:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '5', document_date = '2025-01-14', document_letter = '', id_customer = '3432', id_supplier = '', id_address = '4670953', address1 = 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '61.88', price_tax_excluded = '61.88', date_upd = NOW() WHERE id_document = '95280' 14/01/2025 04:14:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95280' 14/01/2025 04:14:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95280' 14/01/2025 04:14:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95280' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '26' , '-26' , '4' , '2.8000' , '2.8' , '0' , '15' , '61.88' ) 14/01/2025 04:27:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 04:27: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' , '140' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '32.70' , NOW() , NOW() ) 14/01/2025 04:27: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 = '95281' 14/01/2025 04:27:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95281' 14/01/2025 04:27: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 ( '95281' , '22342' , 'LAMPADA IN CRISTALLO VARI COLORI' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 14/01/2025 04:27: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 ( '95281' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 14/01/2025 05:46:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-14') 14/01/2025 05:46:31 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' , '141' , '2025-01-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 14/01/2025 05:46:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95282' 14/01/2025 05:46:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95282' 14/01/2025 05:46:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95282' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' )