24/06/2022 09:20:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 09:20: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' , '2022' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 24/06/2022 09:20: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 = '58875' 24/06/2022 09:20:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58875' 24/06/2022 09:20: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 ( '58875' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 24/06/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 24/06/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 24/06/2022 09:20: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 ( '58875' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 24/06/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 24/06/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 24/06/2022 09:40:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 09:40:00 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' , '2023' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 24/06/2022 09:40:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58876' 24/06/2022 09:40:00 am >> DELETE FROM ps_document_detail WHERE id_document = '58876' 24/06/2022 09:40:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58876' , '15731' , 'STOLA MARIANA - 1021/AM' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 24/06/2022 09:40:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15731' AND id_supplier = '' 24/06/2022 09:40:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15731' , '' , '1' ) 24/06/2022 09:46:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 09:46:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2024' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.91' , '42.75' , NOW() , NOW() ) 24/06/2022 09:46: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 = '58877' 24/06/2022 09:46:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58877' 24/06/2022 09:46: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 ( '58877' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '10' , '-10' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '14.00' ) 24/06/2022 09:46:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9695' AND id_supplier = '' 24/06/2022 09:46:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9695' , '' , '1' ) 24/06/2022 09:46:04 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 ( '58877' , '12685' , 'SACRO CUORE - 209' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 24/06/2022 09:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '12685' AND id_supplier = '' 24/06/2022 09:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12685' , '' , '1' ) 24/06/2022 09:46:04 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 ( '58877' , '19585' , 'PREGHIERE AL SACRO CUORE - 8071' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 24/06/2022 09:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19585' AND id_supplier = '' 24/06/2022 09:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19585' , '' , '1' ) 24/06/2022 09:46:04 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 ( '58877' , '19479' , 'VOLA CON NOI - ESTATE 2022' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 24/06/2022 09:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19479' AND id_supplier = '' 24/06/2022 09:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19479' , '' , '1' ) 24/06/2022 09:54:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 09:54: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' , '2025' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 24/06/2022 09:54: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 = '58878' 24/06/2022 09:54:12 am >> DELETE FROM ps_document_detail WHERE id_document = '58878' 24/06/2022 09:54: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 ( '58878' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 24/06/2022 09:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 24/06/2022 09:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 24/06/2022 09:56:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1851' AND id_document != '58685' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 24/06/2022 09:56:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1851', document_date = '2022-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '290.00', price_tax_excluded = '249.58', date_upd = NOW() WHERE id_document = '58685' 24/06/2022 09:56:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58685' 24/06/2022 09:56:09 am >> DELETE FROM ps_document_detail WHERE id_document = '58685' 24/06/2022 09:56: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 ( '58685' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '5' , '19.00' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '12270' , 'NUOVO ABC DEL CATECHISTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '12270' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12270' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '16019' , 'MARTA, MARIA E LAZZARO - L.M. EPICOCO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '2' , '-2' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '90.00' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '14163' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14163' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '2' , '-2' , '4' , '16.0000' , '16' , '0' , '5' , '30.40' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '2' , '-2' , '1' , '0.56' , '0.45901639344262' , '22' , '0' , '1.12' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7921' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7921' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '4.6' , '4.6' , '0' , '0' , '4.60' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 24/06/2022 09:56: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 ( '58685' , '17603' , 'BRACCIALE SIMIL PELLE NERO - AC120D' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 24/06/2022 09:56:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '17603' AND id_supplier = '' 24/06/2022 09:56:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17603' , '' , '1' ) 24/06/2022 10:06:28 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '3075' 24/06/2022 10:06:28 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '3075' 24/06/2022 10:10:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001099' AND id_product != '14777' AND ean13 != '' 24/06/2022 10:10:36 am >> UPDATE ps_product SET id_supplier = '39', reference = '', ean13 = '001099', date_upd = NOW() WHERE id_product = '14777' 24/06/2022 10:10:36 am >> UPDATE ps_product_lang SET name = 'DECINA LEGNO CON LACCIO', description = '' WHERE id_product = '14777' 24/06/2022 10:10:36 am >> UPDATE ps_product SET wholesale_price = '0.38', on_sale = '0', price = '1.0655737704918034' WHERE id_product = '14777' 24/06/2022 10:10:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.38', price = '1.0655737704918034', id_tax_rules_group = '1', id_category_default = '187', 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 = '14777' 24/06/2022 10:10:36 am >> DELETE FROM ps_specific_price WHERE id_product = '14777' 24/06/2022 10:32:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 10:32:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2026' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 24/06/2022 10:32:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58879' 24/06/2022 10:32:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58879' 24/06/2022 10:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58879' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 24/06/2022 10:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 24/06/2022 10:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 24/06/2022 10:50:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 10:50:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2027' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.22' , '173.22' , NOW() , NOW() ) 24/06/2022 10:50:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58880' 24/06/2022 10:50:15 am >> DELETE FROM ps_document_detail WHERE id_document = '58880' 24/06/2022 10:50:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58880' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '31' , '-31' , '4' , '5.00' , '5' , '0' , '5' , '147.25' ) 24/06/2022 10:50:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 24/06/2022 10:50:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 24/06/2022 10:50:16 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 ( '58880' , '19516' , 'AMEN - AGO 2022' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 24/06/2022 10:50:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 24/06/2022 10:50:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 24/06/2022 10:50:16 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 ( '58880' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 24/06/2022 10:50:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 24/06/2022 10:50:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 24/06/2022 11:14:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 11:14:10 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' , '2028' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '15.60' , NOW() , NOW() ) 24/06/2022 11:14:10 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 = '58881' 24/06/2022 11:14:10 am >> DELETE FROM ps_document_detail WHERE id_document = '58881' 24/06/2022 11:14:10 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 ( '58881' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.6' , '15.6' , '0' , '0' , '15.60' ) 24/06/2022 11:14:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 24/06/2022 11:14:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 24/06/2022 11:50:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 11:50:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2029' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.82' , NOW() , NOW() ) 24/06/2022 11:50: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 = '58882' 24/06/2022 11:50:40 am >> DELETE FROM ps_document_detail WHERE id_document = '58882' 24/06/2022 11:50: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 ( '58882' , '8248' , 'PREGATE, PREGATE, PREGATE - CART. - 8101' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 24/06/2022 11:50:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8248' AND id_supplier = '' 24/06/2022 11:50:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8248' , '' , '1' ) 24/06/2022 11:50: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 ( '58882' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 24/06/2022 11:50:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 24/06/2022 11:50:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 24/06/2022 11:53:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 11:53: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' , '2030' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.82' , NOW() , NOW() ) 24/06/2022 11:53: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 = '58883' 24/06/2022 11:53:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58883' 24/06/2022 11:53: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 ( '58883' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '17' , '13.934426229508' , '22' , '0' , '34.00' ) 24/06/2022 11:53:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 11:53:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 11:53: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 ( '58883' , '4195' , 'FINTA CANDELA 8X30 - 180' , '2' , '-2' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '46.00' ) 24/06/2022 11:53:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4195' AND id_supplier = '' 24/06/2022 11:53:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4195' , '' , '1' ) 24/06/2022 11:53:33 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 ( '58883' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 24/06/2022 11:53:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 24/06/2022 11:53:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 24/06/2022 11:53:33 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 ( '58883' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '116.5' , '95.491803278689' , '22' , '0' , '116.50' ) 24/06/2022 11:53:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 11:53:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 11:53:33 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 ( '58883' , '14021' , 'CINGOLO' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 24/06/2022 11:53:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '14021' AND id_supplier = '' 24/06/2022 11:53:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14021' , '' , '1' ) 24/06/2022 11:55:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 11:55:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2031' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.80' , '60.49' , NOW() , NOW() ) 24/06/2022 11:55:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58884' 24/06/2022 11:55:21 am >> DELETE FROM ps_document_detail WHERE id_document = '58884' 24/06/2022 11:55:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58884' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '36.90' , '30.245901639344' , '22' , '0' , '73.80' ) 24/06/2022 11:55:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 24/06/2022 11:55:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 24/06/2022 12:22:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '824' AND id_document != '53348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-21') 24/06/2022 12:22:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '824', 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 = '45.30', price_tax_excluded = '38.41', date_upd = NOW() WHERE id_document = '53348' 24/06/2022 12:22: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 = '53348' 24/06/2022 12:22:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '53348' 24/06/2022 12:22: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 ( '53348' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '9.00' ) 24/06/2022 12:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 24/06/2022 12:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 24/06/2022 12:22: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 ( '53348' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '0.40' ) 24/06/2022 12:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 24/06/2022 12:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 24/06/2022 12:22: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 ( '53348' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 24/06/2022 12:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 24/06/2022 12:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 24/06/2022 12:22: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 ( '53348' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/06/2022 12:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15089' AND id_supplier = '' 24/06/2022 12:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15089' , '' , '1' ) 24/06/2022 12:22: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 ( '53348' , '6362' , 'MEDAGLIE ASSORTITE CON SPILLA - MO20 ' , '19' , '-19' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '11.40' ) 24/06/2022 12:22:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6362' AND id_supplier = '' 24/06/2022 12:22:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6362' , '' , '1' ) 24/06/2022 12:22:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1105' AND id_document != '54718' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-12') 24/06/2022 12:22:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1105', document_date = '2022-04-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 = '198.94', price_tax_excluded = '168.55', date_upd = NOW() WHERE id_document = '54718' 24/06/2022 12:22: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 = '54718' 24/06/2022 12:22:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '54718' 24/06/2022 12:22: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 ( '54718' , '18120' , 'COPRILEGGIO AGNELLO ' , '1' , '-1' , '1' , '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 24/06/2022 12:22:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18120' AND id_supplier = '' 24/06/2022 12:22:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18120' , '' , '1' ) 24/06/2022 12:22: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 ( '54718' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 24/06/2022 12:22:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 12:22:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 12:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19303' , 'NOVENA AI PASTORELLI DI FATIMA - 8070' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 24/06/2022 12:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19303' AND id_supplier = '' 24/06/2022 12:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19303' , '' , '1' ) 24/06/2022 12:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 24/06/2022 12:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 24/06/2022 12:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 24/06/2022 12:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '4.4800' , '4.48' , '0' , '0' , '4.48' ) 24/06/2022 12:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 24/06/2022 12:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 24/06/2022 12:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/06/2022 12:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14145' AND id_supplier = '' 24/06/2022 12:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14145' , '' , '1' ) 24/06/2022 12:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54718' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/06/2022 12:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 24/06/2022 12:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '19184' , 'FARE LA STORIA 1' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19184' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19184' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.4300' , '1.43' , '0' , '0' , '1.43' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '14935' , 'GESU E RISORTO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14935' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14935' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '19281' , 'SE IL CHICCO DI GRANO - VIA CRUCIS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19281' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19281' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' ) 24/06/2022 12:22:41 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 ( '54718' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 24/06/2022 12:22:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 24/06/2022 12:22:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 24/06/2022 12:45:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 12:45:54 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' , '2032' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.01' , '17.01' , NOW() , NOW() ) 24/06/2022 12:45:54 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 = '58885' 24/06/2022 12:45:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58885' 24/06/2022 12:45:54 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 ( '58885' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 24/06/2022 12:45:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 24/06/2022 12:45:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 24/06/2022 12:45:54 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 ( '58885' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 24/06/2022 12:45:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 24/06/2022 12:45:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 24/06/2022 12:56:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 12:56: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' , '2033' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '270.00' , '221.31' , NOW() , NOW() ) 24/06/2022 12:56: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 = '58886' 24/06/2022 12:56:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58886' 24/06/2022 12:56: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 ( '58886' , '9049' , 'ROMANO NERO ML - COTONE 43 ' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 24/06/2022 12:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9049' AND id_supplier = '' 24/06/2022 12:56:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9049' , '' , '1' ) 24/06/2022 12:56: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 ( '58886' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 24/06/2022 12:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = '' 24/06/2022 12:56:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' ) 24/06/2022 12:56: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 ( '58886' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '216.5' , '177.45901639344' , '22' , '0' , '216.50' ) 24/06/2022 12:56:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 12:56:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 03:20: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 ( '33' , '2532/22' , '2022-06-21' , '22' , '3541' , '125' , '9340036' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 24/06/2022 03:20: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 = '5372' 24/06/2022 03:20:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '5372' 24/06/2022 03:20: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 ( '5372' , '125' , 'MIE PREGHIERINE - N. E.' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 24/06/2022 03:20:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '125' 24/06/2022 03:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '125' , '1' ) 24/06/2022 03:20: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 ( '5372' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 24/06/2022 03:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '124' AND id_supplier = '125' 24/06/2022 03:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '124' , '125' , '1' ) 24/06/2022 03:20: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 ( '5372' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 24/06/2022 03:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24' AND id_supplier = '125' 24/06/2022 03:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24' , '125' , '1' ) 24/06/2022 03:22:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 03:22: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 ( '24' , '7' , '2022-06-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1800.00' , '1800.00' , NOW() , NOW() ) 24/06/2022 03:22: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 = '5373' 24/06/2022 03:22:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '5373' 24/06/2022 03:22: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 ( '5373' , '115' , 'SAN FRANCESCO D\'ASSISI RACCONTATO AI RAGAZZI N.E.' , '150' , '-150' , '4' , '4.00' , '4' , '0' , '0' , '600.00' ) 24/06/2022 03:22: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 ( '5373' , '125' , 'MIE PREGHIERINE - N. E.' , '800' , '-800' , '4' , '1.50' , '1.5' , '0' , '0' , '1200.00' ) 24/06/2022 03:23:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 03:23:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '18' , '2022-06-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1130.00' , '1130.00' , NOW() , NOW() ) 24/06/2022 03:23:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58887' 24/06/2022 03:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58887' 24/06/2022 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.00' , '1' , '0' , '0' , '350.00' ) 24/06/2022 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '38' , '-38' , '4' , '15.00' , '15' , '0' , '0' , '570.00' ) 24/06/2022 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58887' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '30' , '-30' , '4' , '7.00' , '7' , '0' , '0' , '210.00' ) 24/06/2022 03:24:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 03:24:33 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 ( '23' , '20/E' , '2022-06-24' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '820.80' , '672.79' , NOW() , NOW() ) 24/06/2022 03:24:33 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 = '58888' 24/06/2022 03:24:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58888' 24/06/2022 03:24:33 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 ( '58888' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 24/06/2022 03:24:33 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 ( '58888' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 24/06/2022 03:24:33 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 ( '58888' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 24/06/2022 03:49:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801049053' AND id_product != '9490' AND ean13 != '' 24/06/2022 03:49:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788801049053', date_upd = NOW() WHERE id_product = '9490' 24/06/2022 03:49:53 pm >> UPDATE ps_product_lang SET name = 'SAN NICOLA - A.D\'URSO', description = '' WHERE id_product = '9490' 24/06/2022 03:49:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '9490' 24/06/2022 03:49:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9490' 24/06/2022 03:49:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '9490' 24/06/2022 03:50:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801033168' AND id_product != '3631' AND ean13 != '' 24/06/2022 03:50:32 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801033168', date_upd = NOW() WHERE id_product = '3631' 24/06/2022 03:50:32 pm >> UPDATE ps_product_lang SET name = 'DON BOSCO - T. BOSCO', description = '' WHERE id_product = '3631' 24/06/2022 03:50:32 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '5' WHERE id_product = '3631' 24/06/2022 03:50:32 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3631' 24/06/2022 03:50:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '3631' 24/06/2022 03:51:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801042856' AND id_product != '9499' AND ean13 != '' 24/06/2022 03:51:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788801042856', date_upd = NOW() WHERE id_product = '9499' 24/06/2022 03:51:36 pm >> UPDATE ps_product_lang SET name = 'SAN PIETRO - A.GOVERNALE', description = '' WHERE id_product = '9499' 24/06/2022 03:51:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '9499' 24/06/2022 03:51:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9499' 24/06/2022 03:51:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '9499' 24/06/2022 03:52:40 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 24/06/2022 03:52:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19664' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:52:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19664' , '1' , '1' , '2' , NOW() , NOW() ) 24/06/2022 03:52:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19664' , '0' , '1' , '0' , '0' ) 24/06/2022 03:53:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801038378' AND id_product != '19664' AND ean13 != '' 24/06/2022 03:53:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788801038378', date_upd = NOW() WHERE id_product = '19664' 24/06/2022 03:53:19 pm >> UPDATE ps_product_lang SET name = 'ANTONIO ROSMINI - V. SALVOLDI', description = '' WHERE id_product = '19664' 24/06/2022 03:53:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '19664' 24/06/2022 03:53:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19664' 24/06/2022 03:53:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '19664' 24/06/2022 03:53:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19664' 24/06/2022 03:53:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19665' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:53:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19665' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19664' 24/06/2022 03:53:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19665' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19664' 24/06/2022 03:56:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866718949' AND id_product != '19665' AND ean13 != '' 24/06/2022 03:56:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866718949', date_upd = NOW() WHERE id_product = '19665' 24/06/2022 03:56:16 pm >> UPDATE ps_product_lang SET name = 'SAN MATTIA AP. - SIMEONE/TESTI', description = '' WHERE id_product = '19665' 24/06/2022 03:56:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19665' 24/06/2022 03:56:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19665' 24/06/2022 03:56:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '19665' 24/06/2022 03:56:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866718949' AND id_product != '19665' AND ean13 != '' 24/06/2022 03:56:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866718949', date_upd = NOW() WHERE id_product = '19665' 24/06/2022 03:56:48 pm >> UPDATE ps_product_lang SET name = 'SAN MATTIA AP. - SIMEONE/TESTI', description = '' WHERE id_product = '19665' 24/06/2022 03:56:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19665' 24/06/2022 03:56:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19665' 24/06/2022 03:56:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '19665' 24/06/2022 03:56:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19665' 24/06/2022 03:56:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19666' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:56:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19666' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19665' 24/06/2022 03:56:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19666' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19665' 24/06/2022 03:57:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801044843' AND id_product != '9450' AND ean13 != '' 24/06/2022 03:57:21 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801044843', date_upd = NOW() WHERE id_product = '9450' 24/06/2022 03:57:21 pm >> UPDATE ps_product_lang SET name = 'SAN GIOVANNI BATTISTA - G. PESENTI', description = '' WHERE id_product = '9450' 24/06/2022 03:57:21 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '5' WHERE id_product = '9450' 24/06/2022 03:57:21 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9450' 24/06/2022 03:57:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '9450' 24/06/2022 03:58:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866719441' AND id_product != '19666' AND ean13 != '' 24/06/2022 03:58:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866719441', date_upd = NOW() WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> UPDATE ps_product_lang SET name = 'DON TONINO BELLO - A. GIORGIO', description = '' WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19667' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:58:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19667' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19666' 24/06/2022 03:58:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19667' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19666' 24/06/2022 03:58:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866719021' AND id_product != '19667' AND ean13 != '' 24/06/2022 03:58:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866719021', date_upd = NOW() WHERE id_product = '19667' 24/06/2022 03:58:47 pm >> UPDATE ps_product_lang SET name = 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI', description = '' WHERE id_product = '19667' 24/06/2022 03:58:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19667' 24/06/2022 03:58:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19667' 24/06/2022 03:58:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19667' 24/06/2022 03:58:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19667' 24/06/2022 03:58:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19668' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:58:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19668' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19667' 24/06/2022 03:58:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19668' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19667' 24/06/2022 03:59:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9722866119115' AND id_product != '19668' AND ean13 != '' 24/06/2022 03:59:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9722866119115', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 03:59:19 pm >> UPDATE ps_product_lang SET name = 'LUIGI MARIA PALAZZOLO - E. PLATI', description = '' WHERE id_product = '19668' 24/06/2022 03:59:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '19668' 24/06/2022 03:59:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 03:59:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '19668' 24/06/2022 03:59:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9722866119115' AND id_product != '19668' AND ean13 != '' 24/06/2022 03:59:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9722866119115', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 03:59:44 pm >> UPDATE ps_product_lang SET name = 'LUIGI MARIA PALAZZOLO - E. PLATI', description = '' WHERE id_product = '19668' 24/06/2022 03:59:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '19668' 24/06/2022 03:59:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 03:59:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19668' 24/06/2022 03:59:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19668' 24/06/2022 03:59:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19669' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 03:59:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19669' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19668' 24/06/2022 03:59:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19669' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19668' 24/06/2022 04:00:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866719175' AND id_product != '19668' AND ean13 != '' 24/06/2022 04:00:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866719175', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 04:00:13 pm >> UPDATE ps_product_lang SET name = 'LUIGI MARIA PALAZZOLO - E. PLATI', description = '' WHERE id_product = '19668' 24/06/2022 04:00:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.0000' WHERE id_product = '19668' 24/06/2022 04:00:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.0000', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19668' 24/06/2022 04:00:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '19668' 24/06/2022 04:01:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866718482' AND id_product != '19669' AND ean13 != '' 24/06/2022 04:01:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866718482', date_upd = NOW() WHERE id_product = '19669' 24/06/2022 04:01:07 pm >> UPDATE ps_product_lang SET name = 'SAN VITO MARTIRE - D. BOLOGNINI', description = '' WHERE id_product = '19669' 24/06/2022 04:01:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19669' 24/06/2022 04:01:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19669' 24/06/2022 04:01:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19669' 24/06/2022 04:01:08 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19669' 24/06/2022 04:01:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19670' , '1' , '' , 'nuovo-prodotto' ) 24/06/2022 04:01:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19670' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19669' 24/06/2022 04:01:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19670' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19669' 24/06/2022 04:01:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801055443' AND id_product != '9579' AND ean13 != '' 24/06/2022 04:01:26 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788801055443', date_upd = NOW() WHERE id_product = '9579' 24/06/2022 04:01:26 pm >> UPDATE ps_product_lang SET name = 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI', description = '' WHERE id_product = '9579' 24/06/2022 04:01:26 pm >> UPDATE ps_product SET wholesale_price = '2.28', on_sale = '0', price = '4' WHERE id_product = '9579' 24/06/2022 04:01:26 pm >> UPDATE ps_product_shop SET wholesale_price = '2.28', price = '4', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9579' 24/06/2022 04:01:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '9579' 24/06/2022 04:02:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801036626' AND id_product != '9399' AND ean13 != '' 24/06/2022 04:02:36 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801036626', date_upd = NOW() WHERE id_product = '9399' 24/06/2022 04:02:36 pm >> UPDATE ps_product_lang SET name = 'SAN CAMILLO DE LELLIS - F.RUFFINI', description = '' WHERE id_product = '9399' 24/06/2022 04:02:36 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '5' WHERE id_product = '9399' 24/06/2022 04:02:36 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9399' 24/06/2022 04:02:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '9399' 24/06/2022 04:02:50 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 ( '31' , '76/22' , '2022-06-24' , '22' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , 'CAMBIARE NUMERO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.75' , '58.75' , NOW() , NOW() ) 24/06/2022 04:02:50 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 = '58889' 24/06/2022 04:02:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58889' 24/06/2022 04:02:50 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 ( '58889' , '9490' , 'SAN NICOLA - A.DURSO' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.0000' ) 24/06/2022 04:02:50 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 ( '58889' , '6088' , 'MADRE SPERANZA - V.SALVOLDI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 24/06/2022 04:02:50 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 ( '58889' , '3631' , 'DON BOSCO - T. BOSCO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 24/06/2022 04:02:50 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 ( '58889' , '9499' , 'SAN PIETRO - A.GOVERNALE' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.0000' ) 24/06/2022 04:02:50 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 ( '58889' , '9399' , 'SAN CAMILLO DE LELLIS - F.RUFFINI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 24/06/2022 04:02:50 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 ( '58889' , '9533' , 'SANTANNA - F.DI STASIO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 24/06/2022 04:02:50 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 ( '58889' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 24/06/2022 04:02: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 ( '58889' , '19665' , 'SAN MATTIA AP. - SIMEONE/TESTI' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 24/06/2022 04:02: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 ( '58889' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.0000' ) 24/06/2022 04:02: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 ( '58889' , '9450' , 'SAN GIOVANNI BATTISTA - G. PESENTI' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 24/06/2022 04:02: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 ( '58889' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.5000' ) 24/06/2022 04:02: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 ( '58889' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 24/06/2022 04:02: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 ( '58889' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 24/06/2022 04:02: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 ( '58889' , '19668' , 'LUIGI MARIA PALAZZOLO - E. PLATI' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.0000' ) 24/06/2022 04:02: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 ( '58889' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 24/06/2022 04:02: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 ( '58889' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.0000' ) 24/06/2022 04:26:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 04:26:13 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' , '2034' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 24/06/2022 04:26: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 = '58890' 24/06/2022 04:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '58890' 24/06/2022 04:26: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 ( '58890' , '18664' , 'BRACCIALE ARG. E CAUCCIU - 7655' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 24/06/2022 04:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18664' AND id_supplier = '' 24/06/2022 04:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18664' , '' , '1' ) 24/06/2022 04:54:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '47/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 04:54: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 ( '24' , '47/A' , '2022-06-24' , 'A' , '3821' , '0' , '4672560' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.20' , '101.20' , NOW() , NOW() ) 24/06/2022 04:54: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 = '58891' 24/06/2022 04:54:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '58891' 24/06/2022 04:54: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 ( '58891' , '' , 'PORTACERO IN LEGNO' , '1' , '-1' , '0' , '99' , '99' , '' , '0' , '99.00' ) 24/06/2022 04:54: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 ( '58891' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '0' , '1.10' , '1.1' , '' , '0' , '2.20' ) 24/06/2022 05:06:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '58869' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 24/06/2022 05:06:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2016', document_date = '2022-06-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1200.00', price_tax_excluded = '983.61', date_upd = NOW() WHERE id_document = '58869' 24/06/2022 05:06: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 = '58869' 24/06/2022 05:06:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '58869' 24/06/2022 05:06:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19352' , 'CASULA LANA S/MOIRE AGNELLO - 8219' , '1' , '-1' , '1' , '870.0000' , '713.11475409836' , '22' , '0' , '870.00' ) 24/06/2022 05:06:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19352' AND id_supplier = '' 24/06/2022 05:06:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19352' , '' , '1' ) 24/06/2022 05:06:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '100' , '0.00' ) 24/06/2022 05:06:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 24/06/2022 05:06:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 24/06/2022 05:06:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '16040' , 'STOLA ROMANA S/MOIRE - 7336S' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 24/06/2022 05:06:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16040' AND id_supplier = '' 24/06/2022 05:06:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16040' , '' , '1' ) 24/06/2022 05:09:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 05:09:25 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' , '2035' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.43' , NOW() , NOW() ) 24/06/2022 05:09:25 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 = '58892' 24/06/2022 05:09:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58892' 24/06/2022 05:09:25 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 ( '58892' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '5.40' ) 24/06/2022 05:09:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 05:09:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 05:11:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '58892' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 05:11:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2035', document_date = '2022-06-24', 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 = '5.40', price_tax_excluded = '4.43', date_upd = NOW() WHERE id_document = '58892' 24/06/2022 05:11:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58892' 24/06/2022 05:11:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58892' 24/06/2022 05:11: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 ( '58892' , '3011' , 'CROCE LEG. CRESIMA CM 4X2,5 - CC87 ' , '3' , '-3' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '5.40' ) 24/06/2022 05:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3011' AND id_supplier = '' 24/06/2022 05:11:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3011' , '' , '1' ) 24/06/2022 05:35:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 05:35:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2036' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 24/06/2022 05:35:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58893' 24/06/2022 05:35:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58893' 24/06/2022 05:35:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58893' , '18127' , 'SEI DEI NOSTRI! ' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 24/06/2022 05:35:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18127' AND id_supplier = '' 24/06/2022 05:35:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18127' , '' , '1' ) 24/06/2022 06:01:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1920' AND id_document != '58763' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 24/06/2022 06:01:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1920', document_date = '2022-06-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '16.00', date_upd = NOW() WHERE id_document = '58763' 24/06/2022 06:01: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 = '58763' 24/06/2022 06:01:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58763' 24/06/2022 06:01: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 ( '58763' , '19057' , 'CARLO ACUTIS - 15 ANNI DI AMORE E FEDE' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 24/06/2022 06:01:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19057' AND id_supplier = '' 24/06/2022 06:01:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19057' , '' , '1' ) 24/06/2022 06:01: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 ( '58763' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 24/06/2022 06:01:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 24/06/2022 06:01:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 24/06/2022 06:01: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 ( '58763' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 24/06/2022 06:01:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 24/06/2022 06:01:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 24/06/2022 06:34:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 06:34: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' , '2037' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.40' , '102.11' , NOW() , NOW() ) 24/06/2022 06:34: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 = '58894' 24/06/2022 06:34:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58894' 24/06/2022 06:34: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 ( '58894' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 24/06/2022 06:34:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 24/06/2022 06:34:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 24/06/2022 06:34: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 ( '58894' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 24/06/2022 06:34:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 24/06/2022 06:34:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 24/06/2022 06:34: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 ( '58894' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/06/2022 06:34:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 24/06/2022 06:34:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 24/06/2022 06:34: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 ( '58894' , '19202' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 24/06/2022 06:34:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 24/06/2022 06:34:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 24/06/2022 06:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 06:45:51 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' , '2038' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 24/06/2022 06:45: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 = '58895' 24/06/2022 06:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58895' 24/06/2022 06:45: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 ( '58895' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '5' , '-5' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '50.00' ) 24/06/2022 06:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 24/06/2022 06:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 24/06/2022 06:46:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '58895' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 06:46:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2038', document_date = '2022-06-24', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '58895' 24/06/2022 06:46:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58895' 24/06/2022 06:46:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '58895' 24/06/2022 06:46:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58895' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '4' , '-4' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '40.00' ) 24/06/2022 06:46:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 24/06/2022 06:46:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 24/06/2022 06:46:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58895' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/06/2022 06:46:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 06:46:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 06:53:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 06:53:34 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' , '2039' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '8.56' , NOW() , NOW() ) 24/06/2022 06:53:34 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 = '58896' 24/06/2022 06:53:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '58896' 24/06/2022 06:53:34 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 ( '58896' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/06/2022 06:53:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 24/06/2022 06:53:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 24/06/2022 06:53:34 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 ( '58896' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 24/06/2022 06:53:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 24/06/2022 06:53:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 24/06/2022 07:35:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 07:35:35 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' , '2040' , '2022-06-24' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.70' , '25.98' , NOW() , NOW() ) 24/06/2022 07:35: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 = '58897' 24/06/2022 07:35:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '58897' 24/06/2022 07:35: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 ( '58897' , '16252' , 'CUORE PENDENTE' , '2' , '-2' , '1' , '12.20' , '10' , '22' , '0' , '24.40' ) 24/06/2022 07:35:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 24/06/2022 07:35:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 24/06/2022 07:35: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 ( '58897' , '16771' , 'QUADRO DECORATO' , '1' , '-1' , '1' , '7.30' , '5.983606557377' , '22' , '0' , '7.30' ) 24/06/2022 07:35:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16771' AND id_supplier = '' 24/06/2022 07:35:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16771' , '' , '1' ) 24/06/2022 07:41:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '58895' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 24/06/2022 07:41:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2038', document_date = '2022-06-24', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '58895' 24/06/2022 07:41:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58895' 24/06/2022 07:41:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58895' 24/06/2022 07:41:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58895' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '4' , '-4' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '40.00' ) 24/06/2022 07:41:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 24/06/2022 07:41:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 24/06/2022 07:41:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58895' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 24/06/2022 07:41:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 24/06/2022 07:41:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 24/06/2022 07:41:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58895' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/06/2022 07:41:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 24/06/2022 07:41:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 24/06/2022 07:54:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '910' AND id_document != '53963' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-29') 24/06/2022 07:54:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '910', document_date = '2022-03-29', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '53963' 24/06/2022 07:54: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 = '53963' 24/06/2022 07:54:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '53963' 24/06/2022 07:54: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 ( '53963' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 24/06/2022 07:54:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 24/06/2022 07:54:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 24/06/2022 07:54: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 ( '53963' , '17609' , 'CATENINA MEDAGLIA MIR. ARG. E STRASS - SL209RC' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 24/06/2022 07:54:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17609' AND id_supplier = '' 24/06/2022 07:54:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17609' , '' , '1' ) 24/06/2022 07:54: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 ( '53963' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 24/06/2022 07:54:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6355' AND id_supplier = '' 24/06/2022 07:54:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6355' , '' , '1' )