02/05/2024 08:37:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024010000759' , '2024-04-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '126.25' , '126.25' , NOW() , NOW() ) 02/05/2024 08:37:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91532' 02/05/2024 08:37:51 am >> DELETE FROM ps_document_detail WHERE id_document = '91532' 02/05/2024 08:37: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 ( '91532' , '22275' , 'THE CHOSEN. TI HO CHIAMATO PER NOME' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 02/05/2024 08:37:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22275' AND id_supplier = '107' 02/05/2024 08:37:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22275' , '107' , '1' ) 02/05/2024 08:37:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91532' , '22274' , 'CANTO DEL TRIDUO PASQUALE - S. MILITELLO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 02/05/2024 08:37:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22274' AND id_supplier = '107' 02/05/2024 08:37:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22274' , '107' , '1' ) 02/05/2024 08:37:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91532' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '58.50' ) 02/05/2024 08:37:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 02/05/2024 08:37:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 02/05/2024 08:37:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91532' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 02/05/2024 08:37:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 02/05/2024 08:37:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 02/05/2024 09:06:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 09:06:09 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' , '1364' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 02/05/2024 09:06:09 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 = '91533' 02/05/2024 09:06:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91533' 02/05/2024 09:06:09 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 ( '91533' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 02/05/2024 09:15:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/05/2024 09:15:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22496' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 09:15:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22496' , '1' , '1' , '2' , NOW() , NOW() ) 02/05/2024 09:15:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22496' , '0' , '1' , '0' , '0' ) 02/05/2024 09:16:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049612' AND id_product != '22496' AND ean13 != '' 02/05/2024 09:16:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884049612', date_upd = NOW() WHERE id_product = '22496' 02/05/2024 09:16:11 am >> UPDATE ps_product_lang SET name = 'PREGHIERA CATECHESI PAPA FRANCESCO - 8654', description = '' WHERE id_product = '22496' 02/05/2024 09:16:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22496' 02/05/2024 09:16:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22496' 02/05/2024 09:16:11 am >> DELETE FROM ps_specific_price WHERE id_product = '22496' 02/05/2024 09:16:12 am >> 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 = '22496' 02/05/2024 09:16:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22497' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 09:16:12 am >> 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 '22497' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22496' 02/05/2024 09:16:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22497' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22496' 02/05/2024 09:16:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6716/00/2024' , '2024-04-29' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.40' , '131.40' , NOW() , NOW() ) 02/05/2024 09:16:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91534' 02/05/2024 09:16:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91534' 02/05/2024 09:16:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91534' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '12' , '12' , '4' , '5.00' , '5' , '0' , '40' , '36.0000' ) 02/05/2024 09:16:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22341' AND id_supplier = '38' 02/05/2024 09:16:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22341' , '38' , '1' ) 02/05/2024 09:16:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91534' , '22414' , 'SULLA TUA PAROLA - LUG AGO 2024' , '28' , '28' , '4' , '5.00' , '5' , '0' , '40' , '84.0000' ) 02/05/2024 09:16:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22414' AND id_supplier = '38' 02/05/2024 09:16:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22414' , '38' , '1' ) 02/05/2024 09:16:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91534' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 02/05/2024 09:16:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6417' AND id_supplier = '38' 02/05/2024 09:16:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6417' , '38' , '1' ) 02/05/2024 09:16:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91534' , '22496' , 'PREGHIERA CATECHESI PAPA FRANCESCO - 8654' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 02/05/2024 09:16:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22496' AND id_supplier = '38' 02/05/2024 09:16:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22496' , '38' , '1' ) 02/05/2024 09:39:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 09:39:52 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' , '1365' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.40' , '75.38' , NOW() , NOW() ) 02/05/2024 09:39:52 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 = '91535' 02/05/2024 09:39:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91535' 02/05/2024 09:39:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91535' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '780' , '-780' , '4' , '0.04' , '0.04' , '0' , '0' , '31.20' ) 02/05/2024 09:39:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91535' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 02/05/2024 09:39:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91535' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/05/2024 10:11:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:11:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1366' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.06' , '21.74' , NOW() , NOW() ) 02/05/2024 10:11:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91536' 02/05/2024 10:11:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91536' 02/05/2024 10:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91536' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 02/05/2024 10:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91536' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 02/05/2024 10:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91536' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 02/05/2024 10:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91536' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 02/05/2024 10:13:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:13:19 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' , '1367' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 02/05/2024 10:13:19 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 = '91537' 02/05/2024 10:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '91537' 02/05/2024 10:13:19 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 ( '91537' , '18222' , 'ROSARIO COLORATO - R316' , '14' , '-14' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '9.80' ) 02/05/2024 10:27:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:27:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1368' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '9.60' , NOW() , NOW() ) 02/05/2024 10:27:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91538' 02/05/2024 10:27:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91538' 02/05/2024 10:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91538' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.04' , '0.04' , '0' , '0' , '9.60' ) 02/05/2024 10:42:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:42:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1369' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '550.00' , '480.97' , NOW() , NOW() ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 10:42:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '55' , '-55' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '192.50' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '54.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '9.3' , '7.6229508196721' , '22' , '0' , '9.30' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '4.20' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3' , '2.4590163934426' , '22' , '0' , '72.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '65' , '-65' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '78.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '18223' , 'CORONA MISSIONARIA - R102' , '25' , '-25' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '25.00' ) 02/05/2024 10:42:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '90' , '-90' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '45.00' ) 02/05/2024 10:46:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:46:11 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' , '1370' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '570.40' , '570.40' , NOW() , NOW() ) 02/05/2024 10:46:11 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 = '91540' 02/05/2024 10:46:11 am >> DELETE FROM ps_document_detail WHERE id_document = '91540' 02/05/2024 10:46:11 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 ( '91540' , '17423' , 'CARLO ACUTIS' , '80' , '-80' , '4' , '7.50' , '7.5' , '0' , '5' , '570.40' ) 02/05/2024 10:52:30 am >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:52:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '83' , '2024-05-02' , '' , '1140' , '0' , '4673607' , 'VIA PADRE GENTILE 84090 PONTECAGNANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '59.50' , '59.50' , NOW() , NOW() ) 02/05/2024 10:52:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91541' 02/05/2024 10:52:30 am >> DELETE FROM ps_document_detail WHERE id_document = '91541' 02/05/2024 10:52:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91541' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '25' , '-25' , '4' , '2.80' , '2.8' , '0' , '15' , '59.50' ) 02/05/2024 10:56:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 10:56:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1371' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 02/05/2024 10:56:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91542' 02/05/2024 10:56:58 am >> DELETE FROM ps_document_detail WHERE id_document = '91542' 02/05/2024 10:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91542' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 02/05/2024 11:02:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1084' AND id_document != '91182' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-09') 02/05/2024 11:02:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1084', document_date = '2024-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '91182' 02/05/2024 11:02:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91182' 02/05/2024 11:02:45 am >> DELETE FROM ps_document_detail WHERE id_document = '91182' 02/05/2024 11:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91182' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 02/05/2024 11:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1100' AND id_document != '91206' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 02/05/2024 11:03:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1100', document_date = '2024-04-11', 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 = '154.80', price_tax_excluded = '129.63', date_upd = NOW() WHERE id_document = '91206' 02/05/2024 11:03:14 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 = '91206' 02/05/2024 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '91206' 02/05/2024 11:03:14 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 ( '91206' , '22336' , 'CALAMITE ' , '14' , '-14' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '68.60' ) 02/05/2024 11:03:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91206' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '51.0000' , '41.803278688525' , '22' , '0' , '51.00' ) 02/05/2024 11:03:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91206' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 02/05/2024 11:03:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91206' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 02/05/2024 11:03:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91206' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '11' , '-11' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '16.50' ) 02/05/2024 11:54:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 11:54:52 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' , '1372' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 02/05/2024 11:54:52 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 = '91543' 02/05/2024 11:54:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91543' 02/05/2024 11:54:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91543' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/05/2024 11:54:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91543' , '22414' , 'SULLA TUA PAROLA - LUG AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/05/2024 12:32:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 12:32:01 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' , '1373' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.94' , '23.94' , NOW() , NOW() ) 02/05/2024 12:32:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91544' 02/05/2024 12:32:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91544' 02/05/2024 12:32:02 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 ( '91544' , '22392' , 'DALLALBA AL TRAMONTO - MAG 2024' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '5' , '3.04' ) 02/05/2024 12:32:02 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 ( '91544' , '22414' , 'SULLA TUA PAROLA - LUG AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/05/2024 12:32:02 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 ( '91544' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 02/05/2024 12:48:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 12:48: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' , '1374' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.70' , '43.70' , NOW() , NOW() ) 02/05/2024 12:48: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 = '91545' 02/05/2024 12:48:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91545' 02/05/2024 12:48: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 ( '91545' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '46.00' , '46' , '0' , '5' , '43.70' ) 02/05/2024 12:59:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 12:59:27 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' , '1375' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 02/05/2024 12:59:27 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 = '91546' 02/05/2024 12:59:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91546' 02/05/2024 12:59:27 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 ( '91546' , '15481' , 'CROCE IHS - 2389/CZ' , '14' , '-14' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '35.00' ) 02/05/2024 01:02:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 01:02:26 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' , '1376' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.38' , NOW() , NOW() ) 02/05/2024 01:02:26 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 = '91547' 02/05/2024 01:02:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91547' 02/05/2024 01:02:26 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 ( '91547' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 02/05/2024 01:02:26 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 ( '91547' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/05/2024 01:02:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 01:02:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1377' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '690.00' , '565.57' , NOW() , NOW() ) 02/05/2024 01:02:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91548' 02/05/2024 01:02:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '91548' 02/05/2024 01:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91548' , '15543' , 'COTTA LANA/POL SFILATURA A MANO' , '1' , '-1' , '1' , '690.00' , '565.5737704918' , '22' , '0' , '690.00' ) 02/05/2024 01:53:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049322' AND id_product != '22414' AND ean13 != '' 02/05/2024 01:53:58 pm >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884049322', date_upd = NOW() WHERE id_product = '22414' 02/05/2024 01:53:58 pm >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - LUG/AGO 2024', description = '' WHERE id_product = '22414' 02/05/2024 01:53:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '22414' 02/05/2024 01:53:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22414' 02/05/2024 01:53:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22414' 02/05/2024 03:44:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 03:44:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1378' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '16.77' , NOW() , NOW() ) 02/05/2024 03:44:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91549' 02/05/2024 03:44:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91549' 02/05/2024 03:44:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91549' , '22152' , 'A TE RICORRIAMO' , '4' , '-4' , '4' , '3.00' , '3' , '0' , '5' , '11.40' ) 02/05/2024 03:44:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91549' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 02/05/2024 03:44:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91549' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/05/2024 03:48:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 03:48:02 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' , '1379' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '12.90' , NOW() , NOW() ) 02/05/2024 03:48:02 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 = '91550' 02/05/2024 03:48:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91550' 02/05/2024 03:48:02 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 ( '91550' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '15.00' ) 02/05/2024 03:48:02 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 ( '91550' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '0.60' , '0.6' , '0' , '0' , '0.60' ) 02/05/2024 03:58:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '91539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 03:58:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1369', document_date = '2024-05-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '550.00', price_tax_excluded = '480.97', date_upd = NOW() WHERE id_document = '91539' 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 03:58:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '55' , '-55' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '192.50' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '54.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '9.3000' , '7.6229508196721' , '22' , '0' , '9.30' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '72.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '65' , '-65' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '78.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '18223' , 'CORONA MISSIONARIA - R102' , '25' , '-25' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '25.00' ) 02/05/2024 03:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '90' , '-90' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '45.00' ) 02/05/2024 03:59:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '91539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 03:59:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1369', document_date = '2024-05-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '550.00', price_tax_excluded = '480.97', date_upd = NOW() WHERE id_document = '91539' 02/05/2024 03:59:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 03:59:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91539' 02/05/2024 03:59:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '55' , '-55' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '192.50' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '54.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '9.3000' , '7.6229508196721' , '22' , '0' , '9.30' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '72.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '65' , '-65' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '78.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '18223' , 'CORONA MISSIONARIA - R102' , '25' , '-25' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '25.00' ) 02/05/2024 03:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91539' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '90' , '-90' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '45.00' ) 02/05/2024 04:40:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 04:40:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1380' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.55' , '20.85' , NOW() , NOW() ) 02/05/2024 04:40:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91551' 02/05/2024 04:40:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91551' 02/05/2024 04:40:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91551' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 02/05/2024 04:40:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91551' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 02/05/2024 05:04:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 05:04:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1381' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 02/05/2024 05:04:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91552' 02/05/2024 05:04:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91552' 02/05/2024 05:04:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91552' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 02/05/2024 05:04:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91552' , '22307' , 'MESSA E MEDITAZIONE - LUG/AGO ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 02/05/2024 05:09:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 05:09:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1382' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 02/05/2024 05:09:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91553' 02/05/2024 05:09:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91553' 02/05/2024 05:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91553' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 02/05/2024 05:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91553' , '18222' , 'ROSARIO COLORATO - R316' , '50' , '-50' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '35.00' ) 02/05/2024 05:09:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91553' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '15.00' ) 02/05/2024 05:42:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 05:42:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1383' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 02/05/2024 05:42:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91554' 02/05/2024 05:42:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91554' 02/05/2024 05:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91554' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 02/05/2024 05:43:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002268' AND id_product != '22497' AND ean13 != '' 02/05/2024 05:43:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002268', date_upd = NOW() WHERE id_product = '22497' 02/05/2024 05:43:44 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO CRESIMA - 31/264-1K', description = '' WHERE id_product = '22497' 02/05/2024 05:43:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '22497' 02/05/2024 05:43:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '154', 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 = '22497' 02/05/2024 05:43:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '22497' 02/05/2024 05:47:20 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 = '22497' 02/05/2024 05:47:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22498' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 05:47:20 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 '22498' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22497' 02/05/2024 05:47:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22498' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22497' 02/05/2024 05:48:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002269' AND id_product != '22498' AND ean13 != '' 02/05/2024 05:48:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002269', date_upd = NOW() WHERE id_product = '22498' 02/05/2024 05:48:52 pm >> UPDATE ps_product_lang SET name = 'CROCE TRILOBATA - 603/8-0', description = '' WHERE id_product = '22498' 02/05/2024 05:48:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '22498' 02/05/2024 05:48:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '154', 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 = '22498' 02/05/2024 05:48:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22498' 02/05/2024 05:49:41 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 = '22498' 02/05/2024 05:49:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22499' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 05:49:41 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 '22499' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22498' 02/05/2024 05:49:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22499' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22498' 02/05/2024 05:50:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '800/259' AND id_product != '22499' AND ean13 != '' 02/05/2024 05:50:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '800/259', date_upd = NOW() WHERE id_product = '22499' 02/05/2024 05:50:22 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE PRIMA COMUNIONE', description = '' WHERE id_product = '22499' 02/05/2024 05:50:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2' WHERE id_product = '22499' 02/05/2024 05:50:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2', id_tax_rules_group = '4', id_category_default = '154', 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 = '22499' 02/05/2024 05:50:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '22499' 02/05/2024 05:50:25 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 = '22499' 02/05/2024 05:50:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22500' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 05:50:25 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 '22500' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22499' 02/05/2024 05:50:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22500' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22499' 02/05/2024 05:54:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '196/07' AND id_product != '22500' AND ean13 != '' 02/05/2024 05:54:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '196/07', date_upd = NOW() WHERE id_product = '22500' 02/05/2024 05:54:04 pm >> UPDATE ps_product_lang SET name = 'DECINA LEGNO', description = '' WHERE id_product = '22500' 02/05/2024 05:54:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.6' WHERE id_product = '22500' 02/05/2024 05:54:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.6', id_tax_rules_group = '4', id_category_default = '154', 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 = '22500' 02/05/2024 05:54:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22500' 02/05/2024 05:56:35 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 = '22500' 02/05/2024 05:56:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22501' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 05:56:35 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 '22501' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22500' 02/05/2024 05:56:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22501' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22500' 02/05/2024 06:02:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '800/271' AND id_product != '22501' AND ean13 != '' 02/05/2024 06:02:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '800/271', date_upd = NOW() WHERE id_product = '22501' 02/05/2024 06:02:37 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE COLORATO PRIMA COMUNIONE', description = '' WHERE id_product = '22501' 02/05/2024 06:02:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '22501' 02/05/2024 06:02:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '154', 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 = '22501' 02/05/2024 06:02:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '22501' 02/05/2024 06:05:26 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 = '22501' 02/05/2024 06:05:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22502' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 06:05:26 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 '22502' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22501' 02/05/2024 06:05:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22502' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22501' 02/05/2024 06:06:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002270' AND id_product != '22502' AND ean13 != '' 02/05/2024 06:06:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002270', date_upd = NOW() WHERE id_product = '22502' 02/05/2024 06:06:38 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK', description = '' WHERE id_product = '22502' 02/05/2024 06:06:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22502' 02/05/2024 06:06:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '154', 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 = '22502' 02/05/2024 06:06:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22502' 02/05/2024 06:07:43 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 = '22502' 02/05/2024 06:07:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22503' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 06:07:43 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 '22503' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22502' 02/05/2024 06:07:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22503' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22502' 02/05/2024 06:17:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002271' AND id_product != '22503' AND ean13 != '' 02/05/2024 06:17:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002271', date_upd = NOW() WHERE id_product = '22503' 02/05/2024 06:17:07 pm >> UPDATE ps_product_lang SET name = 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6', description = '' WHERE id_product = '22503' 02/05/2024 06:17:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '22503' 02/05/2024 06:17:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '154', 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 = '22503' 02/05/2024 06:17:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22503' 02/05/2024 06:17:09 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 = '22503' 02/05/2024 06:17:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22504' , '1' , '' , 'nuovo-prodotto' ) 02/05/2024 06:17:09 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 '22504' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22503' 02/05/2024 06:17:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22504' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22503' 02/05/2024 06:19:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2766' 02/05/2024 06:19:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-152' WHERE id_product = '2766' 02/05/2024 06:20:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000768' AND id_product != '2766' AND ean13 != '' 02/05/2024 06:20:53 pm >> UPDATE ps_product SET id_supplier = '39', reference = '2015', ean13 = '000768', date_upd = NOW() WHERE id_product = '2766' 02/05/2024 06:20:53 pm >> UPDATE ps_product_lang SET name = 'CORONA PLASTICA FLUO / BIANCO', description = '' WHERE id_product = '2766' 02/05/2024 06:20:53 pm >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.2459' WHERE id_product = '2766' 02/05/2024 06:20:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.2459', id_tax_rules_group = '1', id_category_default = '154', 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 = '2766' 02/05/2024 06:20:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '2766' 02/05/2024 06:30:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000768' AND id_product != '2766' AND ean13 != '' 02/05/2024 06:30:54 pm >> UPDATE ps_product SET id_supplier = '39', reference = '2015', ean13 = '000768', date_upd = NOW() WHERE id_product = '2766' 02/05/2024 06:30:54 pm >> UPDATE ps_product_lang SET name = 'CORONA PLASTICA FLUO / BIANCO', description = '' WHERE id_product = '2766' 02/05/2024 06:30:54 pm >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.2459' WHERE id_product = '2766' 02/05/2024 06:30:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.2459', id_tax_rules_group = '1', id_category_default = '154', 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 = '2766' 02/05/2024 06:30:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '2766' 02/05/2024 06:34:14 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' , '297' , '2024-04-30' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '974.88' , '907.10' , NOW() , NOW() ) 02/05/2024 06:34:14 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 = '91555' 02/05/2024 06:34:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91555' 02/05/2024 06:34:14 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 ( '91555' , '22497' , 'QUADRETTO CRESIMA - 31/264-1K' , '57' , '57' , '4' , '2' , '2' , '0' , '0' , '114.0000' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22497' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22497' , '60' , '1' ) 02/05/2024 06:34:14 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 ( '91555' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '414' , '414' , '1' , '0.55' , '0.45081967213115' , '22' , '0' , '277.7940' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22354' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22354' , '60' , '1' ) 02/05/2024 06:34:14 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 ( '91555' , '22498' , 'CROCE TRILOBATA - 603/8-0' , '87' , '87' , '4' , '1.4' , '1.4' , '0' , '0' , '121.8000' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22498' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22498' , '60' , '1' ) 02/05/2024 06:34:14 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 ( '91555' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '192' , '192' , '4' , '0.5' , '0.5' , '0' , '0' , '96.0000' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22499' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22499' , '60' , '1' ) 02/05/2024 06:34:14 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 ( '91555' , '22500' , 'DECINA LEGNO' , '48' , '48' , '4' , '0.65' , '0.65' , '0' , '0' , '31.2000' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22500' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22500' , '60' , '1' ) 02/05/2024 06:34:14 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 ( '91555' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '100' , '100' , '4' , '0.62' , '0.62' , '0' , '0' , '62.0000' ) 02/05/2024 06:34:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22501' AND id_supplier = '60' 02/05/2024 06:34:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22501' , '60' , '1' ) 02/05/2024 06:34:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91555' , '22502' , 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK' , '200' , '200' , '4' , '0.75' , '0.75' , '0' , '0' , '150.0000' ) 02/05/2024 06:34:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22502' AND id_supplier = '60' 02/05/2024 06:34:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22502' , '60' , '1' ) 02/05/2024 06:34:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91555' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '12' , '12' , '4' , '2' , '2' , '0' , '0' , '24.0000' ) 02/05/2024 06:34:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22503' AND id_supplier = '60' 02/05/2024 06:34:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22503' , '60' , '1' ) 02/05/2024 06:34:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91555' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '804' , '804' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '98.0880' ) 02/05/2024 06:34:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '60' 02/05/2024 06:34:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '60' , '1' ) 02/05/2024 06:41:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002271' AND id_product != '22503' AND ean13 != '' 02/05/2024 06:41:24 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002271', date_upd = NOW() WHERE id_product = '22503' 02/05/2024 06:41:25 pm >> UPDATE ps_product_lang SET name = 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6', description = '' WHERE id_product = '22503' 02/05/2024 06:41:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '22503' 02/05/2024 06:41:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '154', 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 = '22503' 02/05/2024 06:41:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22503' 02/05/2024 06:41:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002268' AND id_product != '22497' AND ean13 != '' 02/05/2024 06:41:46 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002268', date_upd = NOW() WHERE id_product = '22497' 02/05/2024 06:41:46 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO CRESIMA - 31/264-1K', description = '' WHERE id_product = '22497' 02/05/2024 06:41:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '22497' 02/05/2024 06:41:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '154', 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 = '22497' 02/05/2024 06:41:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22497' 02/05/2024 06:41:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002269' AND id_product != '22498' AND ean13 != '' 02/05/2024 06:41:59 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002269', date_upd = NOW() WHERE id_product = '22498' 02/05/2024 06:41:59 pm >> UPDATE ps_product_lang SET name = 'CROCE TRILOBATA - 603/8-0', description = '' WHERE id_product = '22498' 02/05/2024 06:41:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '22498' 02/05/2024 06:41:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '154', 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 = '22498' 02/05/2024 06:41:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '22498' 02/05/2024 06:42:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '800/259' AND id_product != '22499' AND ean13 != '' 02/05/2024 06:42:21 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '800/259', date_upd = NOW() WHERE id_product = '22499' 02/05/2024 06:42:21 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE PRIMA COMUNIONE', description = '' WHERE id_product = '22499' 02/05/2024 06:42:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '22499' 02/05/2024 06:42:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '154', 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 = '22499' 02/05/2024 06:42:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22499' 02/05/2024 06:43:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '196/07' AND id_product != '22500' AND ean13 != '' 02/05/2024 06:43:56 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '196/07', date_upd = NOW() WHERE id_product = '22500' 02/05/2024 06:43:57 pm >> UPDATE ps_product_lang SET name = 'DECINA LEGNO', description = '' WHERE id_product = '22500' 02/05/2024 06:43:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.3114754098360657' WHERE id_product = '22500' 02/05/2024 06:43:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.3114754098360657', id_tax_rules_group = '1', id_category_default = '154', 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 = '22500' 02/05/2024 06:43:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '22500' 02/05/2024 06:44:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '800/271' AND id_product != '22501' AND ean13 != '' 02/05/2024 06:44:16 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '800/271', date_upd = NOW() WHERE id_product = '22501' 02/05/2024 06:44:16 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE COLORATO PRIMA COMUNIONE', description = '' WHERE id_product = '22501' 02/05/2024 06:44:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2295081967213115' WHERE id_product = '22501' 02/05/2024 06:44:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2295081967213115', id_tax_rules_group = '1', id_category_default = '154', 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 = '22501' 02/05/2024 06:44:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '22501' 02/05/2024 06:45:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002270' AND id_product != '22502' AND ean13 != '' 02/05/2024 06:45:10 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002270', date_upd = NOW() WHERE id_product = '22502' 02/05/2024 06:45:10 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK', description = '' WHERE id_product = '22502' 02/05/2024 06:45:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4754098360655739' WHERE id_product = '22502' 02/05/2024 06:45:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4754098360655739', id_tax_rules_group = '1', id_category_default = '154', 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 = '22502' 02/05/2024 06:45:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '22502' 02/05/2024 06:45:26 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 ( '32' , '279' , '2024-04-30' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '22' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '1133.50' , '929.10' , NOW() , NOW() ) 02/05/2024 06:45:26 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 = '91556' 02/05/2024 06:45:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91556' 02/05/2024 06:45:26 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 ( '91556' , '22497' , 'QUADRETTO CRESIMA - 31/264-1K' , '57' , '0' , '1' , '2' , '1.6393442622951' , '22' , '0' , '139.0800' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22497' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22497' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '414' , '0' , '1' , '0.5500' , '0.4508' , '22' , '0' , '277.79' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22354' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22354' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22498' , 'CROCE TRILOBATA - 603/8-0' , '87' , '0' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '148.5960' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22498' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22498' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '192' , '0' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '117.1200' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22499' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22499' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22500' , 'DECINA LEGNO' , '48' , '0' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '38.0640' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22500' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22500' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '100' , '0' , '1' , '0.62' , '0.50819672131148' , '22' , '0' , '75.6400' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22501' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22501' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22502' , 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK' , '200' , '0' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '183.0000' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22502' AND id_supplier = '60' 02/05/2024 06:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22502' , '60' , '1' ) 02/05/2024 06:45:26 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 ( '91556' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '12' , '0' , '1' , '2' , '1.6393442622951' , '22' , '0' , '29.2800' ) 02/05/2024 06:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22503' AND id_supplier = '60' 02/05/2024 06:45:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22503' , '60' , '1' ) 02/05/2024 06:45:27 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 ( '91556' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '804' , '0' , '1' , '0.1000' , '0.082' , '22' , '0' , '98.09' ) 02/05/2024 06:45:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '60' 02/05/2024 06:45:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '60' , '1' ) 02/05/2024 06:58:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 06:58: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' , '1384' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 02/05/2024 06:58: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 = '91557' 02/05/2024 06:58:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91557' 02/05/2024 06:58: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 ( '91557' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 02/05/2024 07:10:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 07:10:02 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' , '1385' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 02/05/2024 07:10:02 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 = '91558' 02/05/2024 07:10:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91558' 02/05/2024 07:10:02 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 ( '91558' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 02/05/2024 07:10:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 07:10:27 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' , '1386' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 02/05/2024 07:10:27 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 = '91559' 02/05/2024 07:10:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91559' 02/05/2024 07:10:27 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 ( '91559' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 02/05/2024 07:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-02') 02/05/2024 07:38:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1387' , '2024-05-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '18.30' , NOW() , NOW() ) 02/05/2024 07:38:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91560' 02/05/2024 07:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91560' 02/05/2024 07:38:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91560' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '15.00' ) 02/05/2024 07:38:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91560' , '22152' , 'A TE RICORRIAMO' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '0' , '6.00' )