23/06/2022 09:42:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 09:42: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' , '2008' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 23/06/2022 09:42: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 = '58861' 23/06/2022 09:42:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58861' 23/06/2022 09:42: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 ( '58861' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 23/06/2022 09:42:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/06/2022 09:42:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/06/2022 10:11:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1932' AND id_document != '58776' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 23/06/2022 10:11:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1932', document_date = '2022-06-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 = '2.00', price_tax_excluded = '1.64', date_upd = NOW() WHERE id_document = '58776' 23/06/2022 10:11: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 = '58776' 23/06/2022 10:11:20 am >> DELETE FROM ps_document_detail WHERE id_document = '58776' 23/06/2022 10:11: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 ( '58776' , '11686' , 'CORONA ROSARIO E PORTACORONA - 388' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 23/06/2022 10:11:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11686' AND id_supplier = '' 23/06/2022 10:11:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11686' , '' , '1' ) 23/06/2022 10:11:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1353' AND id_document != '56540' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 23/06/2022 10:11:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1353', document_date = '2022-05-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '23.90', price_tax_excluded = '22.84', date_upd = NOW() WHERE id_document = '56540' 23/06/2022 10:11: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 = '56540' 23/06/2022 10:11:53 am >> DELETE FROM ps_document_detail WHERE id_document = '56540' 23/06/2022 10:11: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 ( '56540' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 23/06/2022 10:11:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1713' AND id_supplier = '' 23/06/2022 10:11:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1713' , '' , '1' ) 23/06/2022 10:11: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 ( '56540' , '11100' , 'VANGELO E ATTI DEGLI APOSTOLI - CARATTERI GRANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 23/06/2022 10:11:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11100' AND id_supplier = '' 23/06/2022 10:11:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11100' , '' , '1' ) 23/06/2022 10:11: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 ( '56540' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '2' , '-2' , '1' , '1.75' , '1.4344262295082' , '22' , '0' , '3.50' ) 23/06/2022 10:11:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15105' AND id_supplier = '' 23/06/2022 10:11:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15105' , '' , '1' ) 23/06/2022 10:20:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 10:20:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2009' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '47.50' , NOW() , NOW() ) 23/06/2022 10:20:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58862' 23/06/2022 10:20:22 am >> DELETE FROM ps_document_detail WHERE id_document = '58862' 23/06/2022 10:20:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58862' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 23/06/2022 10:20:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 23/06/2022 10:20:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 23/06/2022 10:24:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 10:24: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' , '2010' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '17.33' , NOW() , NOW() ) 23/06/2022 10:24: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 = '58863' 23/06/2022 10:24:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58863' 23/06/2022 10:24: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 ( '58863' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/06/2022 10:24:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 23/06/2022 10:24:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 23/06/2022 10:24: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 ( '58863' , '1312' , 'BRACCIALE DECINA' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 23/06/2022 10:24:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 23/06/2022 10:24:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 23/06/2022 10:26:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1526' AND id_document != '57266' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 23/06/2022 10:26:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1526', document_date = '2022-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.17', price_tax_excluded = '25.85', date_upd = NOW() WHERE id_document = '57266' 23/06/2022 10:26: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 = '57266' 23/06/2022 10:26:00 am >> DELETE FROM ps_document_detail WHERE id_document = '57266' 23/06/2022 10:26: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 ( '57266' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '2' , '-2' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '5.60' ) 23/06/2022 10:26:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 23/06/2022 10:26:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 23/06/2022 10:26: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 ( '57266' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '3' , '-3' , '4' , '1.6000' , '1.6' , '0' , '5' , '4.56' ) 23/06/2022 10:26:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 23/06/2022 10:26:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 23/06/2022 10:26: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 ( '57266' , '5436' , 'IO MI CONFESSO ' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2022 10:26:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '5436' AND id_supplier = '' 23/06/2022 10:26:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5436' , '' , '1' ) 23/06/2022 10:26: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 ( '57266' , '15762' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 23/06/2022 10:26:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15762' AND id_supplier = '' 23/06/2022 10:26:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15762' , '' , '1' ) 23/06/2022 10:26:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57266' , '19180' , 'NOSTRA EUCARESTIA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 23/06/2022 10:26:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19180' AND id_supplier = '' 23/06/2022 10:26:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19180' , '' , '1' ) 23/06/2022 10:26:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57266' , '18729' , 'GIOCHI PER IL CATECHISMO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 23/06/2022 10:26:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18729' AND id_supplier = '' 23/06/2022 10:26:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18729' , '' , '1' ) 23/06/2022 10:26:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57266' , '9727' , 'SCATOLINA PRIMA CONFESSIONE - 2334/G85' , '1' , '-1' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '1.70' ) 23/06/2022 10:26:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '9727' AND id_supplier = '' 23/06/2022 10:26:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9727' , '' , '1' ) 23/06/2022 10:26:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1413' AND id_document != '56614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 23/06/2022 10:26:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1413', document_date = '2022-05-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 = '262.00', price_tax_excluded = '240.54', date_upd = NOW() WHERE id_document = '56614' 23/06/2022 10:26:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56614' 23/06/2022 10:26:23 am >> DELETE FROM ps_document_detail WHERE id_document = '56614' 23/06/2022 10:26:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '12528' , 'LAMPADA A SFERA BLU' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 23/06/2022 10:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12528' AND id_supplier = '' 23/06/2022 10:26:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12528' , '' , '1' ) 23/06/2022 10:26:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 23/06/2022 10:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 23/06/2022 10:26:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 23/06/2022 10:26:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '54.00' ) 23/06/2022 10:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/06/2022 10:26:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/06/2022 10:26:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 23/06/2022 10:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15318' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15318' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '6257' , 'MARIA OSTENSORIO DEL CORPO DI CRISTO - M. GOBBIN' , '1' , '-1' , '4' , '1.3000' , '1.3' , '0' , '0' , '1.30' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6257' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6257' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '13885' , 'NOVENA PER CHIEDERE I DONI DELLO SPIRITO SANTO - U. TERRINONI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13885' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13885' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '2552' , 'COMUNIONE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '2552' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2552' , '' , '1' ) 23/06/2022 10:26: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 ( '56614' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 23/06/2022 10:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 23/06/2022 10:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 23/06/2022 10:34:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1988' AND id_document != '58840' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 23/06/2022 10:34:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1988', document_date = '2022-06-22', 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 = '35.15', price_tax_excluded = '35.15', date_upd = NOW() WHERE id_document = '58840' 23/06/2022 10:34: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 = '58840' 23/06/2022 10:34:37 am >> DELETE FROM ps_document_detail WHERE id_document = '58840' 23/06/2022 10:34: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 ( '58840' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 23/06/2022 10:34:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '10712' AND id_supplier = '' 23/06/2022 10:34:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10712' , '' , '1' ) 23/06/2022 10:34: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 ( '58840' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 23/06/2022 10:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '' 23/06/2022 10:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '' , '1' ) 23/06/2022 10:34:38 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 ( '58840' , '15983' , 'BIBBIA IN 365 GIORNI' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 23/06/2022 10:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '15983' AND id_supplier = '' 23/06/2022 10:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15983' , '' , '1' ) 23/06/2022 10:34:38 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 ( '58840' , '2776' , 'CORONCINA E NOVENA AL PREZIOSISSIMO SANGUE' , '1' , '-1' , '4' , '1.04' , '1.04' , '0' , '0' , '1.04' ) 23/06/2022 10:34:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '2776' AND id_supplier = '' 23/06/2022 10:34:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2776' , '' , '1' ) 23/06/2022 10:37:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 10:37:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2011' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 23/06/2022 10:37: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 = '58864' 23/06/2022 10:37:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58864' 23/06/2022 10:37: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 ( '58864' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 23/06/2022 10:37:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 23/06/2022 10:37:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 23/06/2022 11:29:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 11:29: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' , '2012' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.50' , '87.76' , NOW() , NOW() ) 23/06/2022 11:29: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 = '58865' 23/06/2022 11:29:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58865' 23/06/2022 11:29: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 ( '58865' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 23/06/2022 11:29:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/06/2022 11:29:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/06/2022 11:29: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 ( '58865' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 23/06/2022 11:29:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/06/2022 11:29:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/06/2022 11:29: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 ( '58865' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/06/2022 11:29:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '' 23/06/2022 11:29:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '' , '1' ) 23/06/2022 11:29: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 ( '58865' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '6' , '-6' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '27.00' ) 23/06/2022 11:29:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '18098' AND id_supplier = '' 23/06/2022 11:29:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18098' , '' , '1' ) 23/06/2022 11:29: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 ( '58865' , '3008' , 'CROCE IN POLIMERO EFFETTO PIETRA - CRISTO ' , '4' , '-4' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '22.00' ) 23/06/2022 11:29:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '3008' AND id_supplier = '' 23/06/2022 11:29:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3008' , '' , '1' ) 23/06/2022 11:30:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 11:30: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' , '2013' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 23/06/2022 11:30: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 = '58866' 23/06/2022 11:30:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58866' 23/06/2022 11:30: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 ( '58866' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '30' , '-30' , '1' , '2' , '1.6393442622951' , '22' , '0' , '60.00' ) 23/06/2022 11:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 23/06/2022 11:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 23/06/2022 12:02:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 12:02:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2014' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '79.28' , NOW() , NOW() ) 23/06/2022 12:02:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58867' 23/06/2022 12:02:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '58867' 23/06/2022 12:02:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58867' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '2' , '-2' , '4' , '27.00' , '27' , '0' , '5' , '51.30' ) 23/06/2022 12:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '' 23/06/2022 12:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '' , '1' ) 23/06/2022 12:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58867' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '5' , '9.98' ) 23/06/2022 12:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9017' AND id_supplier = '' 23/06/2022 12:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9017' , '' , '1' ) 23/06/2022 12:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58867' , '9313' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE DEGLI INFERMI' , '1' , '-1' , '4' , '15.49' , '15.49' , '0' , '5' , '14.72' ) 23/06/2022 12:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9313' AND id_supplier = '' 23/06/2022 12:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9313' , '' , '1' ) 23/06/2022 12:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58867' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 23/06/2022 12:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 23/06/2022 12:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 23/06/2022 12:11:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 12:11:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2015' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.65' , '65.42' , NOW() , NOW() ) 23/06/2022 12:11: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 = '58868' 23/06/2022 12:11:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58868' 23/06/2022 12:11: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 ( '58868' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35' , '35' , '0' , '0' , '35.00' ) 23/06/2022 12:11:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/06/2022 12:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/06/2022 12:11: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 ( '58868' , '19295' , 'DETTI E FATTI DEI PADRI DEL DESERTO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 23/06/2022 12:11:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19295' AND id_supplier = '' 23/06/2022 12:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19295' , '' , '1' ) 23/06/2022 12:11: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 ( '58868' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 23/06/2022 12:11:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 23/06/2022 12:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 23/06/2022 12:48:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 12:48:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2016' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1200.00' , '983.61' , NOW() , NOW() ) 23/06/2022 12:48:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58869' 23/06/2022 12:48:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58869' 23/06/2022 12:48:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '18560' , 'STOLA ROMANA S/MOIRE - 7289S' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 23/06/2022 12:48:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18560' AND id_supplier = '' 23/06/2022 12:48:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18560' , '' , '1' ) 23/06/2022 12:48:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19352' , 'CASULA LANA S/MOIRE AGNELLO - 8219' , '1' , '-1' , '1' , '870' , '713.11475409836' , '22' , '0' , '870.00' ) 23/06/2022 12:48:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19352' AND id_supplier = '' 23/06/2022 12:48:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19352' , '' , '1' ) 23/06/2022 12:48:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '100' , '0.00' ) 23/06/2022 12:48:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 23/06/2022 12:48:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 23/06/2022 12:50:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '58869' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 12:50:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2016', document_date = '2022-06-23', 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 = '900.00', price_tax_excluded = '737.70', date_upd = NOW() WHERE id_document = '58869' 23/06/2022 12:50: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 = '58869' 23/06/2022 12:50:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58869' 23/06/2022 12:50: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 ( '58869' , '19352' , 'CASULA LANA S/MOIRE AGNELLO - 8219' , '1' , '-1' , '1' , '900' , '737.70491803279' , '22' , '0' , '900.00' ) 23/06/2022 12:50:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19352' AND id_supplier = '' 23/06/2022 12:50:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19352' , '' , '1' ) 23/06/2022 12:50: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 ( '58869' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '100' , '0.00' ) 23/06/2022 12:50:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 23/06/2022 12:50:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 23/06/2022 12:51:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '58869' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 12:51:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2016', document_date = '2022-06-23', 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 = '1200.00', price_tax_excluded = '983.61', date_upd = NOW() WHERE id_document = '58869' 23/06/2022 12:51: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 = '58869' 23/06/2022 12:51:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '58869' 23/06/2022 12:51: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 ( '58869' , '19352' , 'CASULA LANA S/MOIRE AGNELLO - 8219' , '1' , '-1' , '1' , '870' , '713.11475409836' , '22' , '0' , '870.00' ) 23/06/2022 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19352' AND id_supplier = '' 23/06/2022 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19352' , '' , '1' ) 23/06/2022 12:51: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 ( '58869' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '100' , '0.00' ) 23/06/2022 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 23/06/2022 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 23/06/2022 12:51: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 ( '58869' , '18560' , 'STOLA ROMANA S/MOIRE - 7289S' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 23/06/2022 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18560' AND id_supplier = '' 23/06/2022 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18560' , '' , '1' ) 23/06/2022 04:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 04:14:40 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' , '2017' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 23/06/2022 04:14: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 = '58870' 23/06/2022 04:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '58870' 23/06/2022 04:14: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 ( '58870' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/06/2022 04:14:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 23/06/2022 04:14:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 23/06/2022 04:14: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 ( '58870' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/06/2022 04:14:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 23/06/2022 04:14:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 23/06/2022 04:58:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 04:58: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 ( '11' , '2018' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '81.93' , NOW() , NOW() ) 23/06/2022 04:58: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 = '58871' 23/06/2022 04:58:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '58871' 23/06/2022 04:58: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 ( '58871' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '26.5' , '21.72131147541' , '22' , '0' , '26.50' ) 23/06/2022 04:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 23/06/2022 04:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 23/06/2022 04:58: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 ( '58871' , '18357' , 'MIE PREGHIERINE N.E.' , '15' , '-15' , '4' , '1.50' , '1.5' , '0' , '0' , '22.50' ) 23/06/2022 04:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 23/06/2022 04:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 23/06/2022 04:58: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 ( '58871' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '12' , '-12' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '6.00' ) 23/06/2022 04:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 23/06/2022 04:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 23/06/2022 04:58: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 ( '58871' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/06/2022 04:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17087' AND id_supplier = '' 23/06/2022 04:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17087' , '' , '1' ) 23/06/2022 05:33:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 05:33:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2019' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 23/06/2022 05:33:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58872' 23/06/2022 05:33:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '58872' 23/06/2022 05:33:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58872' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 23/06/2022 05:33:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 23/06/2022 05:33:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 23/06/2022 05:50:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 05:50:28 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' , '2020' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 23/06/2022 05:50:28 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 = '58873' 23/06/2022 05:50:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '58873' 23/06/2022 05:50:28 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 ( '58873' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/06/2022 05:50:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 23/06/2022 05:50:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 23/06/2022 05:50:28 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 ( '58873' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/06/2022 05:50:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 23/06/2022 05:50:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 23/06/2022 07:13:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 23/06/2022 07:13: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' , '2021' , '2022-06-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 23/06/2022 07:13: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 = '58874' 23/06/2022 07:13:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58874' 23/06/2022 07:13: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 ( '58874' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 23/06/2022 07:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/06/2022 07:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/06/2022 07:13: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 ( '58874' , '13563' , 'CORONCINA IN STOFFA CON FIORI - 3312' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 23/06/2022 07:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13563' AND id_supplier = '' 23/06/2022 07:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13563' , '' , '1' ) 23/06/2022 07:29:35 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 23/06/2022 07:29:35 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '162' , '1' ) 23/06/2022 07:29:35 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '162' , '1' ) 23/06/2022 07:29:35 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '162' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 23/06/2022 07:34:43 pm >> UPDATE ps_address SET id_state = '', lastname = 'FARPORTUGAL - IND. DE ARTIGOS RELIGIOSOS LDA', address1 = 'Ap 1006 PC VILAR DOS PRAZERES', address2 = '', postcode = '2490646', dni = 'PT500259038', vat_number = '', city = 'SOBRAL - OUREM', phone = '249 595322', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '162' 23/06/2022 07:34:43 pm >> UPDATE ps_supplier SET email = 'info@farportugal.com', name = 'FARPORTUGAL - IND. DE ARTIGOS RELIGIOSOS LDA', date_upd = NOW() WHERE id_supplier = '162' 23/06/2022 07:34:43 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '162'