23/07/2022 08:54:21 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 08:54:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '54/A' , '2022-07-23' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '408.10' , '348.35' , NOW() , NOW() ) 23/07/2022 08:54:21 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 = '59768' 23/07/2022 08:54:21 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 08:54:21 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 ( '59768' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 23/07/2022 08:54: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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 23/07/2022 08:54: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 ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 23/07/2022 08:54: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 ( '59768' , '' , '23/07/2022' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0' ) 23/07/2022 08:54: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 ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 23/07/2022 08:54: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 ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/07/2022 08:54: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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/07/2022 08:54: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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 23/07/2022 08:54:37 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 23/07/2022 08:54:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 650,00', 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 = '2872.60', price_tax_excluded = '2354.59', date_upd = NOW() WHERE id_document = '56617' 23/07/2022 08:54: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 = '56617' 23/07/2022 08:54:37 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 23/07/2022 08:54: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 23/07/2022 08:54:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 23/07/2022 08:54:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 23/07/2022 08:54: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 23/07/2022 08:54:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 23/07/2022 08:54:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 23/07/2022 08:54: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 ( '56617' , '19594' , 'POLO JERSEY COTONE 100%' , '4' , '-4' , '1' , '36.9000' , '30.245901639344' , '22' , '0' , '147.60' ) 23/07/2022 08:54:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 23/07/2022 08:54:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 23/07/2022 08:59:03 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 08:59:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '438.10', price_tax_excluded = '372.94', date_upd = NOW() WHERE id_document = '59768' 23/07/2022 08:59:03 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 = '59768' 23/07/2022 08:59:03 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 08:59:03 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 ( '59768' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '0' , '23/07/2022' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 08:59:03 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 ( '59768' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 23/07/2022 08:59:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '' 23/07/2022 08:59:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '' , '1' ) 23/07/2022 09:11:12 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:11:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '438.10', price_tax_excluded = '432.69', date_upd = NOW() WHERE id_document = '59768' 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:11:12 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 23/07/2022 09:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 23/07/2022 09:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '0' , '10.0000' , '10' , '' , '0' , '20.00' ) 23/07/2022 09:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '0' , '26.0000' , '26' , '' , '0' , '26.00' ) 23/07/2022 09:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 23/07/2022 09:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '0' , '23/07/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 23/07/2022 09:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/07/2022 09:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/07/2022 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '0' , '1.9000' , '1.9' , '' , '0' , '7.60' ) 23/07/2022 09:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 09:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 09:11:13 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 ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '0' , '3.5000' , '3.5' , '' , '0' , '17.50' ) 23/07/2022 09:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 09:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 09:11:13 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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '0' , '10.0000' , '10' , '' , '0' , '10.00' ) 23/07/2022 09:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:11:13 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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '0' , '4.5000' , '4.5' , '' , '0' , '270.00' ) 23/07/2022 09:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 09:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 09:11:13 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 ( '59768' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '30.00' ) 23/07/2022 09:11:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '' 23/07/2022 09:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '' , '1' ) 23/07/2022 09:12:41 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:12:41 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '438.10', price_tax_excluded = '438.10', date_upd = NOW() WHERE id_document = '59768' 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:12:41 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '0' , '26.0000' , '26' , '0' , '0' , '26.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '0' , '23/07/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '0' , '1.9000' , '1.9' , '0' , '0' , '7.60' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '0' , '3.5000' , '3.5' , '0' , '0' , '17.50' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '0' , '4.5000' , '4.5' , '0' , '0' , '270.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '-100' , '0' , '0.3000' , '0.3' , '' , '0' , '30.00' ) 23/07/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '' 23/07/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '' , '1' ) 23/07/2022 09:13:50 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:13:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '438.10', price_tax_excluded = '372.94', date_upd = NOW() WHERE id_document = '59768' 23/07/2022 09:13:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:13:50 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 23/07/2022 09:13:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '0' , '23/07/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 09:13: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 ( '59768' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '30.00' ) 23/07/2022 09:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '' 23/07/2022 09:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '' , '1' ) 23/07/2022 09:15:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:15:36 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' , '2335' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 23/07/2022 09:15:36 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 = '59769' 23/07/2022 09:15:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59769' 23/07/2022 09:15:36 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 ( '59769' , '968' , 'BATTESIMO DONA VITA' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 23/07/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '968' AND id_supplier = '' 23/07/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '968' , '' , '1' ) 23/07/2022 09:16:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118111760' AND id_product != '968' AND ean13 != '' 23/07/2022 09:16:01 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE', ean13 = '8019118111760', date_upd = NOW() WHERE id_product = '968' 23/07/2022 09:16:01 am >> UPDATE ps_product_lang SET name = 'BATTESIMO DONA VITA', description = '' WHERE id_product = '968' 23/07/2022 09:16:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.819672131147541' WHERE id_product = '968' 23/07/2022 09:16:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.819672131147541', id_tax_rules_group = '1', id_category_default = '27', 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 = '968' 23/07/2022 09:16:01 am >> DELETE FROM ps_specific_price WHERE id_product = '968' 23/07/2022 09:44:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:44:03 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' , '2336' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.60' , '76.37' , NOW() , NOW() ) 23/07/2022 09:44:03 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 = '59770' 23/07/2022 09:44:03 am >> DELETE FROM ps_document_detail WHERE id_document = '59770' 23/07/2022 09:44:03 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 ( '59770' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 23/07/2022 09:44:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/07/2022 09:44:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/07/2022 09:44:03 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 ( '59770' , '11151' , 'LIBRI' , '12' , '-12' , '4' , '3.8' , '3.8' , '0' , '0' , '45.60' ) 23/07/2022 09:44:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/07/2022 09:44:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/07/2022 09:44:03 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 ( '59770' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 23/07/2022 09:44:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/07/2022 09:44:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/07/2022 09:54:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 09:54:40 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' , '2337' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '89.44' , NOW() , NOW() ) 23/07/2022 09:54:40 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 = '59771' 23/07/2022 09:54:40 am >> DELETE FROM ps_document_detail WHERE id_document = '59771' 23/07/2022 09:54:40 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 ( '59771' , '19706' , 'PALLA 75/1634' , '1' , '-1' , '1' , '81.5' , '66.803278688525' , '22' , '0' , '81.50' ) 23/07/2022 09:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19706' AND id_supplier = '' 23/07/2022 09:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19706' , '' , '1' ) 23/07/2022 09:54:40 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 ( '59771' , '15922' , 'PARTICOLE 3MM - P3M' , '2' , '-2' , '3' , '6.00' , '5.7692307692308' , '4' , '0' , '12.00' ) 23/07/2022 09:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '15922' AND id_supplier = '' 23/07/2022 09:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15922' , '' , '1' ) 23/07/2022 09:54:40 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 ( '59771' , '15924' , 'OSTIA 3MM - 03M-25' , '1' , '-1' , '3' , '6.00' , '5.7692307692308' , '4' , '0' , '6.00' ) 23/07/2022 09:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = '' 23/07/2022 09:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' ) 23/07/2022 09:54:40 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 ( '59771' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/07/2022 09:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 23/07/2022 09:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 23/07/2022 09:54:40 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 ( '59771' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 23/07/2022 09:54:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 23/07/2022 09:54:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 23/07/2022 10:01:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 10:01:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2338' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.42' , '25.45' , NOW() , NOW() ) 23/07/2022 10:01: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 = '59772' 23/07/2022 10:01:20 am >> DELETE FROM ps_document_detail WHERE id_document = '59772' 23/07/2022 10:01: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 ( '59772' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/07/2022 10:01:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 23/07/2022 10:01:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 23/07/2022 10:01: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 ( '59772' , '19684' , 'AMEN - SETT. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/07/2022 10:01:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 23/07/2022 10:01:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 23/07/2022 10:01: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 ( '59772' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/07/2022 10:01:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/07/2022 10:01:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/07/2022 10:01:21 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 ( '59772' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/07/2022 10:01:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 23/07/2022 10:01:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 23/07/2022 10:29:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 10:29:39 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' , '2339' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 23/07/2022 10:29:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59773' 23/07/2022 10:29:39 am >> DELETE FROM ps_document_detail WHERE id_document = '59773' 23/07/2022 10:29:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59773' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 23/07/2022 10:29:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '' 23/07/2022 10:29:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '' , '1' ) 23/07/2022 10:31:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 10:31:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2340' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 23/07/2022 10:31: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 = '59774' 23/07/2022 10:31:53 am >> DELETE FROM ps_document_detail WHERE id_document = '59774' 23/07/2022 10:31: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 ( '59774' , '15334' , 'CANDELA VOTIVA 20X40' , '3' , '-3' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '2.40' ) 23/07/2022 10:31:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '15334' AND id_supplier = '' 23/07/2022 10:31:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15334' , '' , '1' ) 23/07/2022 10:32:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001166' AND id_product != '15334' AND ean13 != '' 23/07/2022 10:32:45 am >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '001166', date_upd = NOW() WHERE id_product = '15334' 23/07/2022 10:32:45 am >> UPDATE ps_product_lang SET name = 'CANDELA VOTIVA 20X40', description = '' WHERE id_product = '15334' 23/07/2022 10:32:45 am >> UPDATE ps_product SET wholesale_price = '0.23', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '15334' 23/07/2022 10:32:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.23', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '205', 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 = '15334' 23/07/2022 10:32:45 am >> DELETE FROM ps_specific_price WHERE id_product = '15334' 23/07/2022 11:06:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 11:06:02 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' , '2341' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1460.00' , '1196.72' , NOW() , NOW() ) 23/07/2022 11:06:02 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 = '59775' 23/07/2022 11:06:02 am >> DELETE FROM ps_document_detail WHERE id_document = '59775' 23/07/2022 11:06: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 ( '59775' , '18403' , 'CAMICE MISTO LANA GIGLIUCCIO A MANO - 70/1121' , '1' , '-1' , '1' , '600' , '491.80327868852' , '22' , '0' , '600.00' ) 23/07/2022 11:06:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18403' AND id_supplier = '' 23/07/2022 11:06:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18403' , '' , '1' ) 23/07/2022 11:06: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 ( '59775' , '15407' , 'AMITTO F/LANA CON CROCE - 6799' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 23/07/2022 11:06:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '15407' AND id_supplier = '' 23/07/2022 11:06:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15407' , '' , '1' ) 23/07/2022 11:06: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 ( '59775' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C' , '1' , '-1' , '1' , '840' , '688.52459016393' , '22' , '0' , '840.00' ) 23/07/2022 11:06:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19802' AND id_supplier = '' 23/07/2022 11:06:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19802' , '' , '1' ) 23/07/2022 11:08:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 11:08:42 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' , '2342' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 23/07/2022 11:08:42 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 = '59776' 23/07/2022 11:08:42 am >> DELETE FROM ps_document_detail WHERE id_document = '59776' 23/07/2022 11:08:42 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 ( '59776' , '19516' , 'AMEN - AGO 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 23/07/2022 11:08:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 23/07/2022 11:08:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 23/07/2022 11:11:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 11:11: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' , '2343' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '22.87' , NOW() , NOW() ) 23/07/2022 11:11: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 = '59777' 23/07/2022 11:11:01 am >> DELETE FROM ps_document_detail WHERE id_document = '59777' 23/07/2022 11:11: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 ( '59777' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 23/07/2022 11:11:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 23/07/2022 11:11:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 23/07/2022 11:11: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 ( '59777' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/07/2022 11:11:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/07/2022 11:11:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/07/2022 11:11: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 ( '59777' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/07/2022 11:11:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 11:11:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 11:42:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 11:42: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' , '2344' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.20' , '9.99' , NOW() , NOW() ) 23/07/2022 11:42: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 = '59778' 23/07/2022 11:42:22 am >> DELETE FROM ps_document_detail WHERE id_document = '59778' 23/07/2022 11:42: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 ( '59778' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '2.20' , '2.1153846153846' , '4' , '0' , '2.20' ) 23/07/2022 11:42:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11152' AND id_supplier = '' 23/07/2022 11:42:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11152' , '' , '1' ) 23/07/2022 11:42: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 ( '59778' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/07/2022 11:42:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 11:42:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 11:42: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 ( '59778' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 23/07/2022 11:42:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 23/07/2022 11:42:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 23/07/2022 11:49:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 11:49:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2345' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '2' , '0' , '305.00' , '256.33' , NOW() , NOW() ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59779' 23/07/2022 11:49:28 am >> DELETE FROM ps_document_detail WHERE id_document = '59779' 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 23/07/2022 11:49:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 23/07/2022 11:49:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/07/2022 11:49:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 11:49:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 23/07/2022 11:49:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 23/07/2022 11:49:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 23/07/2022 11:49:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1951' AND id_supplier = '' 23/07/2022 11:49:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1951' , '' , '1' ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/07/2022 11:49:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 11:49:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 11:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 23/07/2022 11:49:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 11:49:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '8788' , 'RACCONTI DI UN PELLEGRINO RUSSO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 23/07/2022 11:49:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '8788' AND id_supplier = '' 23/07/2022 11:49:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8788' , '' , '1' ) 23/07/2022 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.02' , '13.02' , '0' , '0' , '13.02' ) 23/07/2022 11:49:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/07/2022 11:49:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/07/2022 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '2324' , 'CLERGY GRIGIO MM - COTONE 39' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '15' , '33.58' ) 23/07/2022 11:49:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '2324' AND id_supplier = '' 23/07/2022 11:49:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2324' , '' , '1' ) 23/07/2022 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59779' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 23/07/2022 11:49:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '18399' AND id_supplier = '' 23/07/2022 11:49:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18399' , '' , '1' ) 23/07/2022 12:04:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:04:48 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' , '2346' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.40' , '184.75' , NOW() , NOW() ) 23/07/2022 12:04:48 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 = '59780' 23/07/2022 12:04:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '59780' 23/07/2022 12:04:49 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 ( '59780' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/07/2022 12:04:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/07/2022 12:04:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/07/2022 12:04:49 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 ( '59780' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/07/2022 12:04:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/07/2022 12:04:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/07/2022 12:04:49 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 ( '59780' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 23/07/2022 12:04:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 23/07/2022 12:04:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 23/07/2022 12:04:49 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 ( '59780' , '6811' , 'MOCCOLO 80X200' , '6' , '-6' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '54.00' ) 23/07/2022 12:04:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/07/2022 12:04:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/07/2022 12:04:49 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 ( '59780' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '100' , '0.00' ) 23/07/2022 12:04:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/07/2022 12:04:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/07/2022 12:09:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:09: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' , '2347' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 23/07/2022 12:09: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 = '59781' 23/07/2022 12:09:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '59781' 23/07/2022 12:09: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 ( '59781' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 23/07/2022 12:09:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 23/07/2022 12:09:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 23/07/2022 12:12:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:12: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' , '2348' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 23/07/2022 12:12: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 = '59782' 23/07/2022 12:12:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '59782' 23/07/2022 12:12: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 ( '59782' , '7418' , 'PAGELLA A TRE PAGINE - LITANIE S. CUORE' , '100' , '-100' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '13.00' ) 23/07/2022 12:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7418' AND id_supplier = '' 23/07/2022 12:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7418' , '' , '1' ) 23/07/2022 12:15:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:15:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2349' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '15.02' , NOW() , NOW() ) 23/07/2022 12:15:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59783' 23/07/2022 12:15:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59783' 23/07/2022 12:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59783' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '4' , '-4' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '5.60' ) 23/07/2022 12:15:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 23/07/2022 12:15:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 23/07/2022 12:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59783' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '8.40' ) 23/07/2022 12:15:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 23/07/2022 12:15:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 23/07/2022 12:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59783' , '18222' , 'ROSARIO COLORATO - R316' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 23/07/2022 12:15:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 23/07/2022 12:15:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 23/07/2022 12:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59783' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 23/07/2022 12:15:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 12:15:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 12:29:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2344' AND id_document != '59778' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:29:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2344', document_date = '2022-07-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 = '11.20', price_tax_excluded = '9.99', date_upd = NOW() WHERE id_document = '59778' 23/07/2022 12:29:55 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 = '59778' 23/07/2022 12:29:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '59778' 23/07/2022 12:29:55 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 ( '59778' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.2' , '2.1153846153846' , '4' , '0' , '2.20' ) 23/07/2022 12:29:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/07/2022 12:29:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/07/2022 12:29:55 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 ( '59778' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/07/2022 12:29:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 12:29:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/07/2022 12:29:55 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 ( '59778' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 23/07/2022 12:29:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 23/07/2022 12:29:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 23/07/2022 12:32:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 23/07/2022 12:32: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' , '2350' , '2022-07-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.21' , NOW() , NOW() ) 23/07/2022 12:32: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 = '59784' 23/07/2022 12:32:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '59784' 23/07/2022 12:32: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 ( '59784' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/07/2022 12:32:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/07/2022 12:32:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/07/2022 12:32: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 ( '59784' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/07/2022 12:32:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/07/2022 12:32:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )