03/06/2022 08:41:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 08:41:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1750' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 03/06/2022 08:41:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58564' 03/06/2022 08:41:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58564' 03/06/2022 08:41:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58564' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '16.50' ) 03/06/2022 08:41:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 03/06/2022 08:41:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 03/06/2022 09:14:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 09:14:17 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' , '1751' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.55' , '20.91' , NOW() , NOW() ) 03/06/2022 09:14:17 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 = '58565' 03/06/2022 09:14:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58565' 03/06/2022 09:14:17 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 ( '58565' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 03/06/2022 09:14:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/06/2022 09:14:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/06/2022 09:14:17 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 ( '58565' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 03/06/2022 09:14:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/06/2022 09:14:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/06/2022 09:14:17 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 ( '58565' , '5312' , 'INNO ALLO SPIRITO SANTO' , '3' , '-3' , '4' , '0.15' , '0.15' , '0' , '0' , '0.45' ) 03/06/2022 09:14:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '5312' AND id_supplier = '' 03/06/2022 09:14:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5312' , '' , '1' ) 03/06/2022 09:14:17 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 ( '58565' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '7.50' ) 03/06/2022 09:14:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = '' 03/06/2022 09:14:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' ) 03/06/2022 09:32:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001065' AND id_product != '14578' AND ean13 != '' 03/06/2022 09:32:07 am >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001065', date_upd = NOW() WHERE id_product = '14578' 03/06/2022 09:32:07 am >> UPDATE ps_product_lang SET name = 'CAMICE GOTICO - MISTO LANA LEGGERO - 328', description = '' WHERE id_product = '14578' 03/06/2022 09:32:07 am >> UPDATE ps_product SET wholesale_price = '48.50', on_sale = '0', price = '151.63934426229508' WHERE id_product = '14578' 03/06/2022 09:32:07 am >> UPDATE ps_product_shop SET wholesale_price = '48.50', price = '151.63934426229508', id_tax_rules_group = '1', id_category_default = '432', 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 = '14578' 03/06/2022 09:32:07 am >> DELETE FROM ps_specific_price WHERE id_product = '14578' 03/06/2022 09:33:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001774' AND id_product != '18426' AND ean13 != '' 03/06/2022 09:33:05 am >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001774', date_upd = NOW() WHERE id_product = '18426' 03/06/2022 09:33:05 am >> UPDATE ps_product_lang SET name = 'CAMICE BENEDETTINO MISTO LINO - 378', description = '' WHERE id_product = '18426' 03/06/2022 09:33:05 am >> UPDATE ps_product SET wholesale_price = '48.50', on_sale = '0', price = '110.65573770491804' WHERE id_product = '18426' 03/06/2022 09:33:05 am >> UPDATE ps_product_shop SET wholesale_price = '48.50', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '432', 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 = '18426' 03/06/2022 09:33:05 am >> DELETE FROM ps_specific_price WHERE id_product = '18426' 03/06/2022 09:34:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001061' AND id_product != '14354' AND ean13 != '' 03/06/2022 09:34:38 am >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001061', date_upd = NOW() WHERE id_product = '14354' 03/06/2022 09:34:38 am >> UPDATE ps_product_lang SET name = 'CAMICE BENEDETTINO LINO - 3010', description = '' WHERE id_product = '14354' 03/06/2022 09:34:38 am >> UPDATE ps_product SET wholesale_price = '53.35', on_sale = '0', price = '113.9344262295082' WHERE id_product = '14354' 03/06/2022 09:34:39 am >> UPDATE ps_product_shop SET wholesale_price = '53.35', price = '113.9344262295082', id_tax_rules_group = '1', id_category_default = '432', 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 = '14354' 03/06/2022 09:34:39 am >> DELETE FROM ps_specific_price WHERE id_product = '14354' 03/06/2022 09:45: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 ( '31' , '366' , '2022-05-31' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , 'cambiare numero' , '13.5' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '695.64' , '570.20' , NOW() , NOW() ) 03/06/2022 09:45: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 = '58566' 03/06/2022 09:45:48 am >> DELETE FROM ps_document_detail WHERE id_document = '58566' 03/06/2022 09:45: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 ( '58566' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '2' , '2' , '1' , '74' , '60.655737704918' , '22' , '5' , '171.5320' ) 03/06/2022 09:45:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '118' 03/06/2022 09:45:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '118' , '1' ) 03/06/2022 09:45: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 ( '58566' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '1' , '1' , '51' , '41.803278688525' , '22' , '5' , '59.1090' ) 03/06/2022 09:45:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = '118' 03/06/2022 09:45:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '118' , '1' ) 03/06/2022 09:45: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 ( '58566' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '6' , '6' , '1' , '56' , '45.901639344262' , '22' , '5' , '389.4240' ) 03/06/2022 09:45:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '118' 03/06/2022 09:45:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '118' , '1' ) 03/06/2022 09:45: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 ( '58566' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '1' , '1' , '51' , '41.803278688525' , '22' , '5' , '59.1090' ) 03/06/2022 09:45:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 03/06/2022 09:45:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 03/06/2022 09:46:15 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14577' 03/06/2022 09:46:15 am >> UPDATE ps_stock_available SET quantity = quantity + '2' WHERE id_product = '14577' 03/06/2022 09:46:46 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14577' 03/06/2022 09:46:46 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '14577' 03/06/2022 10:10:02 am >> SELECT document_num FROM ps_document WHERE document_num = '677' AND id_document != '52641' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-08') 03/06/2022 10:10:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '677', document_date = '2022-03-08', 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 = '49.50', price_tax_excluded = '40.57', date_upd = NOW() WHERE id_document = '52641' 03/06/2022 10:10:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '52641' 03/06/2022 10:10:03 am >> DELETE FROM ps_document_detail WHERE id_document = '52641' 03/06/2022 10:10:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52641' , '9217' , 'S. GIUSEPPE - 32 ' , '7' , '-7' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '24.50' ) 03/06/2022 10:10:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9217' AND id_supplier = '' 03/06/2022 10:10:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9217' , '' , '1' ) 03/06/2022 10:10:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52641' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '15' , '-15' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '22.50' ) 03/06/2022 10:10:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 10:10:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 03/06/2022 10:10:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52641' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/06/2022 10:10:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 03/06/2022 10:10:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 03/06/2022 10:21:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1752' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 10:21:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1752' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.50' , '63.52' , NOW() , NOW() ) 03/06/2022 10:21:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58567' 03/06/2022 10:21:39 am >> DELETE FROM ps_document_detail WHERE id_document = '58567' 03/06/2022 10:21:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58567' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '25' , '-25' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '32.50' ) 03/06/2022 10:21:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 10:21:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 10:21:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58567' , '18130' , 'TAU GRANDE CM 4 - T9' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 03/06/2022 10:21:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18130' AND id_supplier = '' 03/06/2022 10:21:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18130' , '' , '1' ) 03/06/2022 10:21:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58567' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 03/06/2022 10:21:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 03/06/2022 10:21:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 03/06/2022 10:21:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58567' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 03/06/2022 10:21:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 03/06/2022 10:21:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 03/06/2022 10:24:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 10:24:55 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' , '1753' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.70' , '27.83' , NOW() , NOW() ) 03/06/2022 10:24:55 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 = '58568' 03/06/2022 10:24:55 am >> DELETE FROM ps_document_detail WHERE id_document = '58568' 03/06/2022 10:24:55 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 ( '58568' , '6809' , 'MOCCOLO 60X165' , '6' , '-6' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '27.00' ) 03/06/2022 10:24:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 03/06/2022 10:24:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 03/06/2022 10:24:55 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 ( '58568' , '19620' , 'PRAEDICATE EVANGELIUM' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 03/06/2022 10:24:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19620' AND id_supplier = '' 03/06/2022 10:24:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19620' , '' , '1' ) 03/06/2022 10:43:09 am >> SELECT document_num FROM ps_document WHERE document_num = '43/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 10:43: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 ( '24' , '43/A' , '2022-06-03' , 'A' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.00' , '109.84' , NOW() , NOW() ) 03/06/2022 10:43: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 = '58569' 03/06/2022 10:43:09 am >> DELETE FROM ps_document_detail WHERE id_document = '58569' 03/06/2022 10:43: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 ( '58569' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '120.00' ) 03/06/2022 10:43: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 ( '58569' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 03/06/2022 10:44:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1754' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 10:44:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1754' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 03/06/2022 10:44:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58570' 03/06/2022 10:44:59 am >> DELETE FROM ps_document_detail WHERE id_document = '58570' 03/06/2022 10:44:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58570' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2022 10:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/06/2022 10:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/06/2022 10:45:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1755' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 10:45:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1755' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 03/06/2022 10:45:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58571' 03/06/2022 10:45:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58571' 03/06/2022 10:45:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58571' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 03/06/2022 10:45:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 03/06/2022 10:45:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 03/06/2022 10:48:29 am >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '56604' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 03/06/2022 10:48:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '76', document_date = '2022-05-04', document_letter = '', id_customer = '3880', id_supplier = '', id_address = '4674058', address1 = 'VIA FOGLIZZO 3 10149 TORINO', address2 = '', note = '', price_shipping = '2.50', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '56604' 03/06/2022 10:48: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 = '56604' 03/06/2022 10:48:30 am >> DELETE FROM ps_document_detail WHERE id_document = '56604' 03/06/2022 10:48: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 ( '56604' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '15' , '42.50' ) 03/06/2022 10:48:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 03/06/2022 10:48:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 03/06/2022 10:48: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 ( '56604' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 03/06/2022 10:48:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 03/06/2022 10:48:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 03/06/2022 10:50:35 am >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '57223' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-12') 03/06/2022 10:50:35 am >> UPDATE ps_document SET id_document_type = '21', document_num = '81', document_date = '2022-05-12', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.55', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '91.37', price_tax_excluded = '91.37', date_upd = NOW() WHERE id_document = '57223' 03/06/2022 10:50:35 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 = '57223' 03/06/2022 10:50:35 am >> DELETE FROM ps_document_detail WHERE id_document = '57223' 03/06/2022 10:50:35 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 ( '57223' , '6629' , 'MIA PREGHIERA' , '30' , '-30' , '4' , '0.6500' , '0.65' , '0' , '15' , '16.57' ) 03/06/2022 10:50:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 03/06/2022 10:50:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 03/06/2022 10:50:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57223' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.0000' , '1' , '0' , '15' , '42.50' ) 03/06/2022 10:50:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 03/06/2022 10:50:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 03/06/2022 10:50:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57223' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '15' , '21.25' ) 03/06/2022 10:50:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 03/06/2022 10:50:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 03/06/2022 10:50:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57223' , '5251' , 'INCONTRI EUCARISTICI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 03/06/2022 10:50:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 03/06/2022 10:50:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 03/06/2022 10:52:13 am >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '57236' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-12') 03/06/2022 10:52:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '82', document_date = '2022-05-12', document_letter = '', id_customer = '3881', id_supplier = '', id_address = '4674170', address1 = 'Via X Regina , 16 76016 Margherita di Savoia ', address2 = '', note = '', price_shipping = '5.05', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '41.10', price_tax_excluded = '41.10', date_upd = NOW() WHERE id_document = '57236' 03/06/2022 10:52:13 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 = '57236' 03/06/2022 10:52:13 am >> DELETE FROM ps_document_detail WHERE id_document = '57236' 03/06/2022 10:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57236' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '15' , '21.25' ) 03/06/2022 10:52:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 03/06/2022 10:52:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 03/06/2022 10:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57236' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 03/06/2022 10:52:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 03/06/2022 10:52:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 03/06/2022 10:52:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57236' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '3.15' , '3.15' , '0' , '0' , '6.30' ) 03/06/2022 10:52:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 03/06/2022 10:52:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 03/06/2022 10:53:42 am >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '57788' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-16') 03/06/2022 10:53:42 am >> UPDATE ps_document SET id_document_type = '21', document_num = '83', document_date = '2022-05-16', document_letter = '', id_customer = '3883', id_supplier = '', id_address = '4674281', address1 = 'Via Maggiore Pietro Toselli 94 , 94 73043 Copertino ', address2 = '', note = '', price_shipping = '0.8', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '77.95', price_tax_excluded = '77.95', date_upd = NOW() WHERE id_document = '57788' 03/06/2022 10:53:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57788' 03/06/2022 10:53:42 am >> DELETE FROM ps_document_detail WHERE id_document = '57788' 03/06/2022 10:53:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57788' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 03/06/2022 10:53:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 03/06/2022 10:53:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 03/06/2022 10:53:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57788' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '3' , '-3' , '4' , '25.00' , '25' , '0' , '15' , '63.75' ) 03/06/2022 10:53:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 03/06/2022 10:53:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 03/06/2022 10:53:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57788' , '5251' , 'INCONTRI EUCARISTICI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 03/06/2022 10:53:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 03/06/2022 10:53:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 03/06/2022 10:54:30 am >> SELECT document_num FROM ps_document WHERE document_num = '75/A' AND id_document != '32723' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-09-17') 03/06/2022 10:54:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '75/A', document_date = '2021-09-17', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '620.00', price_tax_excluded = '508.20', date_upd = NOW() WHERE id_document = '32723' 03/06/2022 10:54: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 = '32723' 03/06/2022 10:54:30 am >> DELETE FROM ps_document_detail WHERE id_document = '32723' 03/06/2022 10:54: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 ( '32723' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '620.0000' , '508.19672131148' , '22' , '0' , '620.00' ) 03/06/2022 10:54:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19448' AND id_supplier = '' 03/06/2022 10:54:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19448' , '' , '1' ) 03/06/2022 10:55:40 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 03/06/2022 10:55:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'ACCONTO € 4,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '103.42', price_tax_excluded = '89.95', date_upd = NOW() WHERE id_document = '57793' 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 03/06/2022 10:55:40 am >> DELETE FROM ps_document_detail WHERE id_document = '57793' 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 03/06/2022 10:55:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/06/2022 10:55:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 03/06/2022 10:55:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 03/06/2022 10:55:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 03/06/2022 10:55:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 03/06/2022 10:55:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/06/2022 10:55:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 03/06/2022 10:55:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '9015' , 'RITO DELLA CONFERMAZIONE' , '1' , '-1' , '4' , '15.50' , '15.5' , '0' , '5' , '14.72' ) 03/06/2022 10:55:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '9015' AND id_supplier = '' 03/06/2022 10:55:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9015' , '' , '1' ) 03/06/2022 10:55:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2022 10:55:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/06/2022 10:55:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/06/2022 10:58:22 am >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '57795' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-16') 03/06/2022 10:58:22 am >> UPDATE ps_document SET id_document_type = '21', document_num = '84', document_date = '2022-05-16', document_letter = '', id_customer = '3455', id_supplier = '', id_address = '4672079', address1 = 'C. DA SANTA DOMENICA, SNC 84031 AULETTA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '19.00', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '57795' 03/06/2022 10:58:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57795' 03/06/2022 10:58:22 am >> DELETE FROM ps_document_detail WHERE id_document = '57795' 03/06/2022 10:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57795' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '-14' , '4' , '1.00' , '1' , '0' , '0' , '14.00' ) 03/06/2022 10:58:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 03/06/2022 10:58:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 03/06/2022 11:21:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '346' 03/06/2022 11:21:24 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '346' , '10' , '130' , 'PARROCCHIA SAN NICOLA DI BARI' , 'GIRALDI ' , 'DON VINCENZO' , 'P.ZZETTA S. NICOLA DI BARI' , '' , '83010' , 'CAPRIGLIA IRPINA' , '' , '3440443836' , '' , '' , '92068330643' , NOW() , NOW() ) 03/06/2022 11:21:24 am >> UPDATE ps_customer SET email = 'giraldi.vincenzo@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '346' 03/06/2022 11:21:55 am >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:21:55 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' , '95' , '2022-06-03' , '' , '346' , '0' , '4674403' , 'P.ZZETTA S. NICOLA DI BARI 83010 CAPRIGLIA IRPINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.13' , '53.13' , NOW() , NOW() ) 03/06/2022 11:21:55 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 = '58572' 03/06/2022 11:21:55 am >> DELETE FROM ps_document_detail WHERE id_document = '58572' 03/06/2022 11:21:55 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 ( '58572' , '2448' , 'COLUI IN CUI CREDO' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '15' , '53.13' ) 03/06/2022 11:27:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1756' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:27:12 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' , '1756' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.36' , '61.77' , NOW() , NOW() ) 03/06/2022 11:27:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58573' 03/06/2022 11:27:12 am >> DELETE FROM ps_document_detail WHERE id_document = '58573' 03/06/2022 11:27:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58573' , '2155' , 'CLERGY BLU MM - MISTO 39 ' , '1' , '-1' , '1' , '35.5' , '29.098360655738' , '22' , '15' , '30.18' ) 03/06/2022 11:27:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2155' AND id_supplier = '' 03/06/2022 11:27:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2155' , '' , '1' ) 03/06/2022 11:27:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58573' , '2331' , 'CLERGY GRIGIO MM - MISTO 39 ' , '1' , '-1' , '1' , '35.5' , '29.098360655738' , '22' , '15' , '30.18' ) 03/06/2022 11:27:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2331' AND id_supplier = '' 03/06/2022 11:27:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2331' , '' , '1' ) 03/06/2022 11:27:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58573' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 03/06/2022 11:27:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 03/06/2022 11:27:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 03/06/2022 11:33:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1757' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:33:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1757' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 03/06/2022 11:33:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58574' 03/06/2022 11:33:39 am >> DELETE FROM ps_document_detail WHERE id_document = '58574' 03/06/2022 11:33:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58574' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 03/06/2022 11:33:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '' 03/06/2022 11:33:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '' , '1' ) 03/06/2022 11:38:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:38:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1758' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.75' , '14.86' , NOW() , NOW() ) 03/06/2022 11:38:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58575' 03/06/2022 11:38:54 am >> DELETE FROM ps_document_detail WHERE id_document = '58575' 03/06/2022 11:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58575' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 03/06/2022 11:38:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 03/06/2022 11:38:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 03/06/2022 11:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58575' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/06/2022 11:38:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 03/06/2022 11:38:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 03/06/2022 11:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58575' , '13732' , 'BRACCIALE DECINA - 0493/11' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 03/06/2022 11:38:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '13732' AND id_supplier = '' 03/06/2022 11:38:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13732' , '' , '1' ) 03/06/2022 11:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58575' , '17995' , 'SACRO CUORE CM 12 - 023SH/12E' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 03/06/2022 11:38:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '17995' AND id_supplier = '' 03/06/2022 11:38:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17995' , '' , '1' ) 03/06/2022 11:52:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:52:26 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' , '1759' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 03/06/2022 11:52:26 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 = '58576' 03/06/2022 11:52:26 am >> DELETE FROM ps_document_detail WHERE id_document = '58576' 03/06/2022 11:52:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58576' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 03/06/2022 11:52:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16409' AND id_supplier = '' 03/06/2022 11:52:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16409' , '' , '1' ) 03/06/2022 11:57:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1760' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 11:57:18 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' , '1760' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 03/06/2022 11:57:18 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 = '58577' 03/06/2022 11:57:18 am >> DELETE FROM ps_document_detail WHERE id_document = '58577' 03/06/2022 11:57:18 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 ( '58577' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 03/06/2022 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '' 03/06/2022 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '' , '1' ) 03/06/2022 12:06:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1761' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:06:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1761' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 03/06/2022 12:06:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58578' 03/06/2022 12:06:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58578' 03/06/2022 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58578' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/06/2022 12:06:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 03/06/2022 12:06:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 03/06/2022 12:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58578' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/06/2022 12:06:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 03/06/2022 12:06:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 03/06/2022 12:28:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1762' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:28:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1762' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 03/06/2022 12:28:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58579' 03/06/2022 12:28:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '58579' 03/06/2022 12:28:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58579' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 03/06/2022 12:28:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/06/2022 12:28:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/06/2022 12:28:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58579' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 03/06/2022 12:28:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/06/2022 12:28:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/06/2022 12:30:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1763' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:30: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' , '1763' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 03/06/2022 12:30: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 = '58580' 03/06/2022 12:30:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '58580' 03/06/2022 12:30: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 ( '58580' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 03/06/2022 12:30:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 03/06/2022 12:30:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 03/06/2022 12:34:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1764' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:34:05 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' , '1764' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 03/06/2022 12:34:05 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 = '58581' 03/06/2022 12:34:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '58581' 03/06/2022 12:34:05 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 ( '58581' , '19107' , 'INCENSO GRANI 3A' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 03/06/2022 12:34:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 03/06/2022 12:34:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 03/06/2022 12:42:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1765' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:42:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1765' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.40' , '57.08' , NOW() , NOW() ) 03/06/2022 12:42:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58582' 03/06/2022 12:42:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58582' 03/06/2022 12:42:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58582' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 03/06/2022 12:42:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/06/2022 12:42:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/06/2022 12:42:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58582' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 03/06/2022 12:42:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 03/06/2022 12:42:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 03/06/2022 12:42:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58582' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/06/2022 12:42:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 03/06/2022 12:42:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 03/06/2022 12:53:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1766' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:53:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1766' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 03/06/2022 12:53:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58583' 03/06/2022 12:53:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '58583' 03/06/2022 12:53:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58583' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 03/06/2022 12:53:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '' 03/06/2022 12:53:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '' , '1' ) 03/06/2022 12:57:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1767' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 12:57:58 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' , '1767' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.25' , '29.27' , NOW() , NOW() ) 03/06/2022 12:57:58 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 = '58584' 03/06/2022 12:57:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58584' 03/06/2022 12:57:58 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 ( '58584' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 03/06/2022 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 03/06/2022 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 03/06/2022 12:57:58 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 ( '58584' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 03/06/2022 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15939' AND id_supplier = '' 03/06/2022 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15939' , '' , '1' ) 03/06/2022 12:57:58 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 ( '58584' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 03/06/2022 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 03/06/2022 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 03/06/2022 03:13:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '58572' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 03:13:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '95', document_date = '2022-06-03', document_letter = '', id_customer = '346', id_supplier = '', id_address = '4674403', address1 = 'P.ZZETTA S. NICOLA DI BARI 83010 CAPRIGLIA IRPINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '53.00', price_tax_excluded = '53.00', date_upd = NOW() WHERE id_document = '58572' 03/06/2022 03:13:13 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 = '58572' 03/06/2022 03:13:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '58572' 03/06/2022 03:13:13 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 ( '58572' , '2448' , 'COLUI IN CUI CREDO' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 03/06/2022 03:13:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2448' AND id_supplier = '' 03/06/2022 03:13:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2448' , '' , '1' ) 03/06/2022 03:13:13 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 ( '58572' , '' , 'arrotondamento' , '1' , '-1' , '0' , '-0.13' , '-0.13' , '' , '0' , '-0.13' ) 03/06/2022 03:13:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 03/06/2022 03:13:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 03/06/2022 03:49:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1768' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 03:49: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' , '1768' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.56' , '38.80' , NOW() , NOW() ) 03/06/2022 03:49: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 = '58585' 03/06/2022 03:49:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '58585' 03/06/2022 03:49: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 ( '58585' , '15399' , 'CONF. CARTONCINO SIMBOLO MADRE PERLA CONFESSIONE - 1907/J44' , '12' , '-12' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '26.40' ) 03/06/2022 03:49:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15399' AND id_supplier = '' 03/06/2022 03:49:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15399' , '' , '1' ) 03/06/2022 03:49: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 ( '58585' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '12' , '-12' , '4' , '1.50' , '1.5' , '0' , '5' , '17.16' ) 03/06/2022 03:49:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 03/06/2022 03:49:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 03/06/2022 03:54:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1769' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 03:54:17 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' , '1769' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.50' , '26.84' , NOW() , NOW() ) 03/06/2022 03:54:17 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 = '58586' 03/06/2022 03:54:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58586' 03/06/2022 03:54:17 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 ( '58586' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 03/06/2022 03:54:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 03/06/2022 03:54:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 03/06/2022 03:54:17 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 ( '58586' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 03/06/2022 03:54:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 03/06/2022 03:54:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 03/06/2022 03:54:17 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 ( '58586' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 03/06/2022 03:54:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 03/06/2022 03:54:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 03/06/2022 03:54:17 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 ( '58586' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2022 03:54:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/06/2022 03:54:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/06/2022 04:01:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 03/06/2022 04:01:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 50,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2761.00', price_tax_excluded = '2263.11', date_upd = NOW() WHERE id_document = '56617' 03/06/2022 04:01: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 = '56617' 03/06/2022 04:01:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 03/06/2022 04:01: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 03/06/2022 04:01:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 03/06/2022 04:01:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 03/06/2022 04:01: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 03/06/2022 04:01:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 03/06/2022 04:01:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 03/06/2022 04:01: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 ( '56617' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 03/06/2022 04:01:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 03/06/2022 04:01:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 03/06/2022 04:02:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001952' AND id_product != '19396' AND ean13 != '' 03/06/2022 04:02:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001952', date_upd = NOW() WHERE id_product = '19396' 03/06/2022 04:02:48 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO COTONE MM - C01', description = '' WHERE id_product = '19396' 03/06/2022 04:02:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.508196721311474' WHERE id_product = '19396' 03/06/2022 04:02:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.508196721311474', id_tax_rules_group = '1', id_category_default = '462', 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 = '19396' 03/06/2022 04:02:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '19396' 03/06/2022 04:02:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 03/06/2022 04:02:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 50,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2761.00', price_tax_excluded = '2263.11', date_upd = NOW() WHERE id_document = '56617' 03/06/2022 04:02:59 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 = '56617' 03/06/2022 04:02:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 03/06/2022 04:02:59 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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 03/06/2022 04:02:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 03/06/2022 04:02:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 03/06/2022 04:02:59 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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 03/06/2022 04:02:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 03/06/2022 04:02:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 03/06/2022 04:02:59 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 ( '56617' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 03/06/2022 04:02:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 03/06/2022 04:02:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 03/06/2022 04:58:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1770' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 04:58:49 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' , '1770' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 03/06/2022 04:58:49 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 = '58587' 03/06/2022 04:58:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '58587' 03/06/2022 04:58:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58587' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 03/06/2022 04:58:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 03/06/2022 04:58:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 03/06/2022 05:17:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1771' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 05:17:18 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' , '1771' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '33.93' , NOW() , NOW() ) 03/06/2022 05:17:18 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 = '58588' 03/06/2022 05:17:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '58588' 03/06/2022 05:17:18 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 ( '58588' , '9212' , 'S. FRANCESCO BABY - 023 SF/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 03/06/2022 05:17:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9212' AND id_supplier = '' 03/06/2022 05:17:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9212' , '' , '1' ) 03/06/2022 05:17:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58588' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 03/06/2022 05:17:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 03/06/2022 05:17:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 03/06/2022 05:17:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58588' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 03/06/2022 05:17:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9420' AND id_supplier = '' 03/06/2022 05:17:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9420' , '' , '1' ) 03/06/2022 05:17:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58588' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 03/06/2022 05:17:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9205' AND id_supplier = '' 03/06/2022 05:17:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9205' , '' , '1' ) 03/06/2022 05:34:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 05:34:38 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' , '1772' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 03/06/2022 05:34:38 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 = '58589' 03/06/2022 05:34:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '58589' 03/06/2022 05:34:38 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 ( '58589' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 03/06/2022 05:34:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 03/06/2022 05:34:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 03/06/2022 06:29:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '565' AND id_document != '51975' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-02-28') 03/06/2022 06:29:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '565', document_date = '2022-02-28', 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 = '40.60', price_tax_excluded = '34.30', date_upd = NOW() WHERE id_document = '51975' 03/06/2022 06:29:43 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 = '51975' 03/06/2022 06:29:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '51975' 03/06/2022 06:29:43 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 ( '51975' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '11.00' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 03/06/2022 06:29:43 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 ( '51975' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 03/06/2022 06:29:43 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 ( '51975' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '9.00' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 03/06/2022 06:29:43 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 ( '51975' , '19280' , 'MESSAGGIO DELLA QUARESIMA 2022' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19280' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19280' , '' , '1' ) 03/06/2022 06:29:43 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 ( '51975' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '2.9000' , '2.7884615384615' , '4' , '0' , '2.90' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 03/06/2022 06:29:43 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 ( '51975' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '3.00' ) 03/06/2022 06:29:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/06/2022 06:29:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/06/2022 06:29: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 ( '51975' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 03/06/2022 06:29:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14772' AND id_supplier = '' 03/06/2022 06:29:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14772' , '' , '1' ) 03/06/2022 06:29: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 ( '51975' , '14773' , 'BRACCIALE RIGATO - 0825N' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 03/06/2022 06:29:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14773' AND id_supplier = '' 03/06/2022 06:29:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14773' , '' , '1' ) 03/06/2022 06:29: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 ( '51975' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 03/06/2022 06:29:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 06:29:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 06:30:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '733' AND id_document != '53225' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-12') 03/06/2022 06:30:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '733', document_date = '2022-03-12', 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 = '22.26', price_tax_excluded = '21.77', date_upd = NOW() WHERE id_document = '53225' 03/06/2022 06:30:07 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 = '53225' 03/06/2022 06:30:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '53225' 03/06/2022 06:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '7442' , 'PANE QUOTIDIANO' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '5' , '6.66' ) 03/06/2022 06:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '' 03/06/2022 06:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '' , '1' ) 03/06/2022 06:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '19216' , 'MESSA MEDITAZIONE - MAR. 2022' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 03/06/2022 06:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19216' AND id_supplier = '' 03/06/2022 06:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19216' , '' , '1' ) 03/06/2022 06:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '19217' , 'MESSA MEDITAZIONE - APR. 2022' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 03/06/2022 06:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19217' AND id_supplier = '' 03/06/2022 06:30:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19217' , '' , '1' ) 03/06/2022 06:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '19289' , 'MESSA MEDITAZIONE - mag. 2022' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 03/06/2022 06:30:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19289' AND id_supplier = '' 03/06/2022 06:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19289' , '' , '1' ) 03/06/2022 06:30:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 03/06/2022 06:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 03/06/2022 06:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 03/06/2022 06:30:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53225' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '2' , '-2' , '1' , '1.35' , '1.1065573770492' , '22' , '0' , '2.70' ) 03/06/2022 06:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 06:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 06:30:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1219' AND id_document != '55363' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-22') 03/06/2022 06:30:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1219', document_date = '2022-04-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.60', price_tax_excluded = '16.89', date_upd = NOW() WHERE id_document = '55363' 03/06/2022 06:30:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55363' 03/06/2022 06:30:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '55363' 03/06/2022 06:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55363' , '2669' , 'CONFEZIONE SACRAMENTO CON CORONA BIMBO - 2317-J44' , '7' , '-7' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '11.90' ) 03/06/2022 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2669' AND id_supplier = '' 03/06/2022 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2669' , '' , '1' ) 03/06/2022 06:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55363' , '11694' , 'BRACCIALE ROSARIO LEGNO - 186/R' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 03/06/2022 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11694' AND id_supplier = '' 03/06/2022 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11694' , '' , '1' ) 03/06/2022 06:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55363' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 03/06/2022 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19015' AND id_supplier = '' 03/06/2022 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19015' , '' , '1' ) 03/06/2022 06:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55363' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '2' , '-2' , '1' , '0.85' , '0.69672131147541' , '22' , '0' , '1.70' ) 03/06/2022 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 06:31:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1483' AND id_document != '56698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 03/06/2022 06:31:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1483', document_date = '2022-05-10', 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 = '20.60', price_tax_excluded = '16.89', date_upd = NOW() WHERE id_document = '56698' 03/06/2022 06:31: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 = '56698' 03/06/2022 06:31:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '56698' 03/06/2022 06:31: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 ( '56698' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 03/06/2022 06:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 03/06/2022 06:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 03/06/2022 06:31: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 ( '56698' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 03/06/2022 06:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 03/06/2022 06:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 03/06/2022 06:31: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 ( '56698' , '19253' , 'bruciaincenso cm 9' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 03/06/2022 06:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19253' AND id_supplier = '' 03/06/2022 06:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19253' , '' , '1' ) 03/06/2022 06:31: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 ( '56698' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 03/06/2022 06:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 06:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 06:31:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 06:31:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1773' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.70' , '39.92' , NOW() , NOW() ) 03/06/2022 06:31:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58590' 03/06/2022 06:31:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58590' 03/06/2022 06:34:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1773' AND id_document != '58590' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 06:34:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1773', document_date = '2022-06-03', 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 = '48.70', price_tax_excluded = '39.92', date_upd = NOW() WHERE id_document = '58590' 03/06/2022 06:34:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58590' 03/06/2022 06:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58590' 03/06/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58590' , '14775' , 'SIMBOLI CRISTOLOGICI CON LACCIO ' , '19' , '-19' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '24.70' ) 03/06/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14775' AND id_supplier = '' 03/06/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14775' , '' , '1' ) 03/06/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58590' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 03/06/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 03/06/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 03/06/2022 06:41:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831549721' AND id_product != '13700' AND ean13 != '' 03/06/2022 06:41:58 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/3', ean13 = '9788831549721', date_upd = NOW() WHERE id_product = '13700' 03/06/2022 06:41:58 pm >> UPDATE ps_product_lang SET name = 'PIENA DI GRAZIA - G. SACINO', description = '' WHERE id_product = '13700' 03/06/2022 06:41:58 pm >> UPDATE ps_product SET wholesale_price = '3.35', on_sale = '0', price = '5.0000' WHERE id_product = '13700' 03/06/2022 06:41:58 pm >> UPDATE ps_product_shop SET wholesale_price = '3.35', price = '5.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13700' 03/06/2022 06:41:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '13700' 03/06/2022 07:15:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1084' AND id_document != '54690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-11') 03/06/2022 07:15:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1084', document_date = '2022-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 = '63.41', price_tax_excluded = '58.00', date_upd = NOW() WHERE id_document = '54690' 03/06/2022 07:15:00 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 = '54690' 03/06/2022 07:15:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '54690' 03/06/2022 07:15:01 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 ( '54690' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 03/06/2022 07:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 03/06/2022 07:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 03/06/2022 07:15:01 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 ( '54690' , '15438' , 'BIBBIA DELLA MIA CRESIMA' , '1' , '-1' , '4' , '24' , '24' , '0' , '0' , '24.00' ) 03/06/2022 07:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15438' AND id_supplier = '' 03/06/2022 07:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15438' , '' , '1' ) 03/06/2022 07:15:01 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 ( '54690' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 03/06/2022 07:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17554' AND id_supplier = '' 03/06/2022 07:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17554' , '' , '1' ) 03/06/2022 07:15:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 07:15:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1774' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 03/06/2022 07:15:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58591' 03/06/2022 07:15:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58591' 03/06/2022 07:15: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 ( '58591' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '10' , '-10' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.00' ) 03/06/2022 07:15:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7912' AND id_supplier = '' 03/06/2022 07:15:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7912' , '' , '1' ) 03/06/2022 07:15: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 ( '58591' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 03/06/2022 07:15:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 03/06/2022 07:15:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 03/06/2022 07:44:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 07:44:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1775' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 03/06/2022 07:44:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58592' 03/06/2022 07:44:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '58592' 03/06/2022 07:44:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 03/06/2022 07:44:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/06/2022 07:44:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/06/2022 07:44:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '13542' , 'ANGELO RESINA CON MANI GIUNTE - 4200' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 03/06/2022 07:44:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13542' AND id_supplier = '' 03/06/2022 07:44:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13542' , '' , '1' ) 03/06/2022 07:47:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 03/06/2022 07:47: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' , '1776' , '2022-06-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '380.00' , '311.48' , NOW() , NOW() ) 03/06/2022 07:47: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 = '58593' 03/06/2022 07:47:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58593' 03/06/2022 07:47: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 ( '58593' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '66.00' ) 03/06/2022 07:47:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 03/06/2022 07:47:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 03/06/2022 07:47: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 ( '58593' , '18260' , 'CLERGY GRIGIO NIDO DAPE MM - XL' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 03/06/2022 07:47:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18260' AND id_supplier = '' 03/06/2022 07:47:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18260' , '' , '1' ) 03/06/2022 07:47: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 ( '58593' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '139.00' , '113.93442622951' , '22' , '0' , '139.00' ) 03/06/2022 07:47:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 03/06/2022 07:47:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 03/06/2022 07:47: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 ( '58593' , '18368' , 'TUNICA PRIMA COMUNIONE BORDO ORO' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 03/06/2022 07:47:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18368' AND id_supplier = '' 03/06/2022 07:47:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18368' , '' , '1' ) 03/06/2022 07:47: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 ( '58593' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 03/06/2022 07:47:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/06/2022 07:47:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/06/2022 07:56:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '718' AND id_document != '53202' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-11') 03/06/2022 07:56:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '718', document_date = '2022-03-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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '53202' 03/06/2022 07:56: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 = '53202' 03/06/2022 07:56:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '53202' 03/06/2022 07:56: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 ( '53202' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '2.00' ) 03/06/2022 07:56:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 03/06/2022 07:56:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 03/06/2022 07:56: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 ( '53202' , '9948' , 'SFERA DIAMETRO MM 100' , '2' , '-2' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '13.00' ) 03/06/2022 07:56:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 03/06/2022 07:56:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 03/06/2022 07:56: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 ( '53202' , '17338' , 'TUNICA CON SCAPOLARE ' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 03/06/2022 07:56:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17338' AND id_supplier = '' 03/06/2022 07:56:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17338' , '' , '1' ) 03/06/2022 07:56: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 ( '53202' , '205' , 'ACCONCIATURA CON NASTRINI' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 03/06/2022 07:56:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '205' AND id_supplier = '' 03/06/2022 07:56:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '205' , '' , '1' ) 03/06/2022 07:56: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 ( '53202' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 03/06/2022 07:56:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 07:56:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 03/06/2022 07:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '831' AND id_document != '53356' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-21') 03/06/2022 07:56:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '831', document_date = '2022-03-21', 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 = '53356' 03/06/2022 07:56:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53356' 03/06/2022 07:56:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '53356' 03/06/2022 07:56:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53356' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '20' , '-20' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '30.00' ) 03/06/2022 07:56:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 07:56:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 03/06/2022 07:56:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '988' AND id_document != '54581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-05') 03/06/2022 07:56:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '988', document_date = '2022-04-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '155.50', price_tax_excluded = '135.96', date_upd = NOW() WHERE id_document = '54581' 03/06/2022 07:56:57 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 = '54581' 03/06/2022 07:56:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '54581' 03/06/2022 07:56:57 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 ( '54581' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 03/06/2022 07:56:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 03/06/2022 07:56:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 03/06/2022 07:56:57 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 ( '54581' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '1.70' ) 03/06/2022 07:56:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/06/2022 07:56:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/06/2022 07:56:57 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 ( '54581' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/06/2022 07:56:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '15.00' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.0000' , '7' , '0' , '5' , '19.95' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7704' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7704' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '19090' , 'OSTIA MAGNA 170 - OM170' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19090' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19090' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 03/06/2022 07:56:58 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 ( '54581' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '4.9500' , '4.95' , '0' , '0' , '4.95' ) 03/06/2022 07:56:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 03/06/2022 07:56:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 03/06/2022 07:57:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1203' AND id_document != '55342' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-21') 03/06/2022 07:57:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1203', document_date = '2022-04-21', 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 = '164.00', price_tax_excluded = '153.27', date_upd = NOW() WHERE id_document = '55342' 03/06/2022 07:57:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55342' 03/06/2022 07:57:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '55342' 03/06/2022 07:57:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55342' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 03/06/2022 07:57:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 03/06/2022 07:57:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 03/06/2022 07:57:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55342' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '29.5000' , '24.180327868852' , '22' , '0' , '29.50' ) 03/06/2022 07:57:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 03/06/2022 07:57:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 03/06/2022 07:57:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55342' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '20' , '-20' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '30.00' ) 03/06/2022 07:57:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 07:57:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 03/06/2022 07:57:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1225' AND id_document != '55881' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 03/06/2022 07:57:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1225', document_date = '2022-04-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '55881' 03/06/2022 07:57:51 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 = '55881' 03/06/2022 07:57:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '55881' 03/06/2022 07:57:51 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 ( '55881' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '16.00' ) 03/06/2022 07:57:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 03/06/2022 07:57:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' )