02/07/2025 09:36:53 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('2025-07-02') 02/07/2025 09:36:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2336' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.80' , '72.57' , NOW() , NOW() ) 02/07/2025 09:36:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97954' 02/07/2025 09:36:54 am >> DELETE FROM ps_document_detail WHERE id_document = '97954' 02/07/2025 09:36:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97954' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 02/07/2025 09:36:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97954' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/07/2025 09:36:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97954' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/07/2025 09:36:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97954' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '13' , '-13' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '45.50' ) 02/07/2025 09:55:53 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('2025-07-02') 02/07/2025 09:55: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' , '2337' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 02/07/2025 09:55: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 = '97955' 02/07/2025 09:55:53 am >> DELETE FROM ps_document_detail WHERE id_document = '97955' 02/07/2025 09:55: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 ( '97955' , '19244' , 'CROCE TAU CM 34' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/07/2025 10:26:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001945' AND id_product != '19351' AND ean13 != '' 02/07/2025 10:26:05 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001945', date_upd = NOW() WHERE id_product = '19351' 02/07/2025 10:26:05 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA MISTO LINO - 7050', description = '' WHERE id_product = '19351' 02/07/2025 10:26:05 am >> UPDATE ps_product SET wholesale_price = '20.00', on_sale = '0', price = '42.6230' WHERE id_product = '19351' 02/07/2025 10:26:05 am >> UPDATE ps_product_shop SET wholesale_price = '20.00', price = '42.6230', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19351' 02/07/2025 10:26:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19351' 02/07/2025 10:26:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001492' AND id_product != '16958' AND ean13 != '' 02/07/2025 10:26:49 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001492', date_upd = NOW() WHERE id_product = '16958' 02/07/2025 10:26:49 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA M/LINO MARIANO - 6990', description = '' WHERE id_product = '16958' 02/07/2025 10:26:49 am >> UPDATE ps_product SET wholesale_price = '20.00', on_sale = '0', price = '42.622950819672134' WHERE id_product = '16958' 02/07/2025 10:26:49 am >> UPDATE ps_product_shop SET wholesale_price = '20.00', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '448', 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 = '16958' 02/07/2025 10:26:49 am >> DELETE FROM ps_specific_price WHERE id_product = '16958' 02/07/2025 10:26:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '87/2025' , '2025-06-30' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.60' , '80.00' , NOW() , NOW() ) 02/07/2025 10:26:59 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 = '97956' 02/07/2025 10:26:59 am >> DELETE FROM ps_document_detail WHERE id_document = '97956' 02/07/2025 10:26:59 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 ( '97956' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '0' , '48.8000' ) 02/07/2025 10:26:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126' 02/07/2025 10:26:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' ) 02/07/2025 10:26:59 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 ( '97956' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '0' , '48.8000' ) 02/07/2025 10:26:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 02/07/2025 10:27:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 02/07/2025 10:28:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '67/2025' , '2025-06-30' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '12.5' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '356.85' , '292.50' , NOW() , NOW() ) 02/07/2025 10:28:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97957' 02/07/2025 10:28:44 am >> DELETE FROM ps_document_detail WHERE id_document = '97957' 02/07/2025 10:28:44 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 ( '97957' , '19190' , 'STOLA MARIANA - 7335' , '1' , '0' , '1' , '75.0000' , '61.4754' , '22' , '0' , '91.50' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' ) 02/07/2025 10:28:44 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 ( '97957' , '16955' , 'STOLA MARIANA - 8005' , '1' , '0' , '1' , '65.0000' , '53.2787' , '22' , '0' , '79.30' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' ) 02/07/2025 10:28:44 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 ( '97957' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '0' , '1' , '20.0000' , '16.3934' , '22' , '0' , '24.40' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' ) 02/07/2025 10:28:44 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 ( '97957' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '2' , '0' , '1' , '20.0000' , '16.3934' , '22' , '0' , '48.80' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '126' , '1' ) 02/07/2025 10:28:44 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 ( '97957' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '2' , '0' , '1' , '20.0000' , '16.3934' , '22' , '0' , '48.80' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' ) 02/07/2025 10:28:44 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 ( '97957' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '0' , '1' , '20.0000' , '16.3934' , '22' , '0' , '48.80' ) 02/07/2025 10:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 02/07/2025 10:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 02/07/2025 10:28:56 am >> DELETE FROM ps_document WHERE id_document = '97846' 02/07/2025 10:28:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97846' 02/07/2025 10:29:08 am >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '97915' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-30') 02/07/2025 10:29:08 am >> UPDATE ps_document SET id_document_type = '24', document_num = '95/A', document_date = '2025-06-30', document_letter = 'A', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '97915' 02/07/2025 10:29:08 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 = '97915' 02/07/2025 10:29:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97915' 02/07/2025 10:29:08 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 ( '97915' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '60.00' ) 02/07/2025 11:21:56 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('2025-07-02') 02/07/2025 11:21:56 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' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '64.38' , NOW() , NOW() ) 02/07/2025 11:21:56 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 = '97958' 02/07/2025 11:21:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97958' 02/07/2025 11:21:56 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 ( '97958' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 02/07/2025 11:21:56 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 ( '97958' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 02/07/2025 11:29:54 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('2025-07-02') 02/07/2025 11:29:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2339' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 02/07/2025 11:29:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97959' 02/07/2025 11:29:54 am >> DELETE FROM ps_document_detail WHERE id_document = '97959' 02/07/2025 11:29:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97959' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 02/07/2025 11:35:25 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('2025-07-02') 02/07/2025 11:35:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2340' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.50' , '94.27' , NOW() , NOW() ) 02/07/2025 11:35:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97960' 02/07/2025 11:35:25 am >> DELETE FROM ps_document_detail WHERE id_document = '97960' 02/07/2025 11:35:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97960' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '-1' , '4' , '17.3' , '17.3' , '0' , '0' , '17.30' ) 02/07/2025 11:35:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97960' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.2' , '3.2' , '0' , '0' , '3.20' ) 02/07/2025 11:35:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97960' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 02/07/2025 11:37:41 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('2025-07-02') 02/07/2025 11:37:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2341' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 02/07/2025 11:37: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 = '97961' 02/07/2025 11:37:41 am >> DELETE FROM ps_document_detail WHERE id_document = '97961' 02/07/2025 11:37: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 ( '97961' , '9464' , 'S. GIUSEPPE BABY - PB19077' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '0' , '9.90' ) 02/07/2025 11:51:25 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('2025-07-02') 02/07/2025 11:51:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2342' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 02/07/2025 11:51:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97962' 02/07/2025 11:51:25 am >> DELETE FROM ps_document_detail WHERE id_document = '97962' 02/07/2025 11:51:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97962' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 02/07/2025 11:51:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97962' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 02/07/2025 11:58:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2335' AND id_document != '97953' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 02/07/2025 11:58:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2335', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.50', price_tax_excluded = '25.59', date_upd = NOW() WHERE id_document = '97953' 02/07/2025 11:58:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97953' 02/07/2025 11:58:25 am >> DELETE FROM ps_document_detail WHERE id_document = '97953' 02/07/2025 11:58:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/07/2025 11:58:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/07/2025 11:58:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '12' , '-12' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '6.00' ) 02/07/2025 12:23:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 02/07/2025 12:23:55 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' , '2343' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 02/07/2025 12:23: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 = '97963' 02/07/2025 12:23:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97963' 02/07/2025 12:23: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 ( '97963' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 02/07/2025 12:23: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 ( '97963' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2025 12:24:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 02/07/2025 12:24:47 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' , '2344' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 02/07/2025 12:24:47 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 = '97964' 02/07/2025 12:24:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97964' 02/07/2025 12:24:47 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 ( '97964' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 02/07/2025 03:38:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 02/07/2025 03:38:55 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' , '2345' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '60.28' , NOW() , NOW() ) 02/07/2025 03:38: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 = '97965' 02/07/2025 03:38:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97965' 02/07/2025 03:38: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 ( '97965' , '17349' , 'CROCE TRILOBATA H21 - CL56' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 02/07/2025 03:38: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 ( '97965' , '21730' , 'CROCE CLASSICA CM 40 - CL51' , '1' , '-1' , '1' , '54.00' , '44.262295081967' , '22' , '0' , '54.00' ) 02/07/2025 03:38: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 ( '97965' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '' , '5.50' ) 02/07/2025 03:38: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 ( '97965' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 02/07/2025 04:14:39 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/07/2025 04:14:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23847' , '1' , '' , 'nuovo-prodotto' ) 02/07/2025 04:14:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23847' , '1' , '1' , '2' , NOW() , NOW() ) 02/07/2025 04:14:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23847' , '0' , '1' , '0' , '0' ) 02/07/2025 04:15:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831527637' AND id_product != '23847' AND ean13 != '' 02/07/2025 04:15:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831527637', date_upd = NOW() WHERE id_product = '23847' 02/07/2025 04:15:11 pm >> UPDATE ps_product_lang SET name = 'ROSARIO EUCARISTICO', description = '' WHERE id_product = '23847' 02/07/2025 04:15:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.3' WHERE id_product = '23847' 02/07/2025 04:15:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.3', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23847' 02/07/2025 04:15:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23847' 02/07/2025 04:15:12 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23847' 02/07/2025 04:15:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23848' , '1' , '' , 'nuovo-prodotto' ) 02/07/2025 04:15:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23848' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23847' 02/07/2025 04:15:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23848' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23847' 02/07/2025 04:16:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '703271' , '2025-07-01' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.89' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.80' , '110.80' , NOW() , NOW() ) 02/07/2025 04:16:39 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 = '97966' 02/07/2025 04:16:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97966' 02/07/2025 04:16:39 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 ( '97966' , '6964' , 'NELLA CASA DEL PADRE - FEDELI' , '5' , '5' , '4' , '8.90' , '8.9' , '0' , '35' , '28.9250' ) 02/07/2025 04:16:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6964' AND id_supplier = '7' 02/07/2025 04:16:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6964' , '7' , '1' ) 02/07/2025 04:16:39 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 ( '97966' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '15' , '51.0000' ) 02/07/2025 04:16:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '7' 02/07/2025 04:16:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '7' , '1' ) 02/07/2025 04:16: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 ( '97966' , '23847' , 'ROSARIO EUCARISTICO' , '4' , '4' , '4' , '1.30' , '1.3' , '0' , '33' , '3.4840' ) 02/07/2025 04:16:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23847' AND id_supplier = '7' 02/07/2025 04:16:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23847' , '7' , '1' ) 02/07/2025 04:16: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 ( '97966' , '23694' , 'DONNA DI FRONTIERA ... - E. RONcHI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 02/07/2025 04:16:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23694' AND id_supplier = '7' 02/07/2025 04:16:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23694' , '7' , '1' ) 02/07/2025 04:16: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 ( '97966' , '23767' , 'PROMESSE DEL SACRO CUORE A CARATTERI GRANDI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 02/07/2025 04:16:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23767' AND id_supplier = '7' 02/07/2025 04:16:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23767' , '7' , '1' ) 02/07/2025 04:16: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 ( '97966' , '23274' , 'FEDE E UN VIAGGIO - PAPA FRANCESCO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 02/07/2025 04:16:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23274' AND id_supplier = '7' 02/07/2025 04:16:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23274' , '7' , '1' ) 02/07/2025 05:32:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400072303' AND id_product != '16447' AND ean13 != '' 02/07/2025 05:32:04 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400072303', date_upd = NOW() WHERE id_product = '16447' 02/07/2025 05:32:04 pm >> UPDATE ps_product_lang SET name = 'TELA 30X40 - 2964', description = '' WHERE id_product = '16447' 02/07/2025 05:32:04 pm >> UPDATE ps_product SET wholesale_price = '5.81', on_sale = '0', price = '13.114754098360656' WHERE id_product = '16447' 02/07/2025 05:32:04 pm >> UPDATE ps_product_shop SET wholesale_price = '5.81', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '95', 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 = '16447' 02/07/2025 05:32:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '16447' 02/07/2025 06:11:55 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('2025-07-02') 02/07/2025 06:11:55 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' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 02/07/2025 06:11: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 = '97967' 02/07/2025 06:11:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97967' 02/07/2025 06:11: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 ( '97967' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 02/07/2025 07:21: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('2025-07-02') 02/07/2025 07:21: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' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 02/07/2025 07:21: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 = '97968' 02/07/2025 07:21:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '97968' 02/07/2025 07:21: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 ( '97968' , '10464' , 'TAVOLETTA PAPA FRANCESCO - OGGETTI' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 02/07/2025 08:08:11 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('2025-07-02') 02/07/2025 08:08: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' , '2348' , '2025-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 02/07/2025 08:08: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 = '97969' 02/07/2025 08:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '97969' 02/07/2025 08:08: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 ( '97969' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 02/07/2025 08:10:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2348' AND id_document != '97969' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 02/07/2025 08:10:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2348', document_date = '2025-07-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '97969' 02/07/2025 08:10: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 = '97969' 02/07/2025 08:10:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97969' 02/07/2025 08:10:48 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 ( '97969' , '23224' , 'STOLA MARIANA - ST07' , '1' , '-1' , '1' , '80.00' , '65.573770491803' , '22' , '0' , '80.00' )