20/12/2022 09:30:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 09:30:06 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' , '3971' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '278.69' , NOW() , NOW() ) 20/12/2022 09:30:06 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 = '77397' 20/12/2022 09:30:06 am >> DELETE FROM ps_document_detail WHERE id_document = '77397' 20/12/2022 09:30:06 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 ( '77397' , '20538' , 'TALARE ROSSA - 431TPR' , '2' , '-2' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '210.00' ) 20/12/2022 09:30:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20538' AND id_supplier = '' 20/12/2022 09:30:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20538' , '' , '1' ) 20/12/2022 09:30:06 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 ( '77397' , '20539' , 'COTTA MISTO COTONE - 905TCB' , '2' , '-2' , '1' , '65' , '53.27868852459' , '22' , '0' , '130.00' ) 20/12/2022 09:30:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20539' AND id_supplier = '' 20/12/2022 09:30:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20539' , '' , '1' ) 20/12/2022 09:31:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3972' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 09:31: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' , '3972' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '43.49' , NOW() , NOW() ) 20/12/2022 09:31: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 = '77398' 20/12/2022 09:31:12 am >> DELETE FROM ps_document_detail WHERE id_document = '77398' 20/12/2022 09:31: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 ( '77398' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/12/2022 09:31:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 20/12/2022 09:31:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 20/12/2022 09:31: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 ( '77398' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 20/12/2022 09:31:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/12/2022 09:31:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/12/2022 09:33:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3973' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 09:33:14 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' , '3973' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.25' , '15.82' , NOW() , NOW() ) 20/12/2022 09:33:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77399' 20/12/2022 09:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '77399' 20/12/2022 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77399' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 20/12/2022 09:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 20/12/2022 09:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 20/12/2022 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77399' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/12/2022 09:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 09:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 09:33: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 ( '77399' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 20/12/2022 09:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 20/12/2022 09:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 20/12/2022 09:34:04 am >> DELETE FROM ps_document WHERE id_document = '77279' 20/12/2022 09:34:04 am >> DELETE FROM ps_document_detail WHERE id_document = '77279' 20/12/2022 09:36:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000392' AND id_product != '8053' AND ean13 != '' 20/12/2022 09:36:11 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000392', date_upd = NOW() WHERE id_product = '8053' 20/12/2022 09:36:12 am >> UPDATE ps_product_lang SET name = 'PISSIDE DIAM 14 C/COPERCHIO - 864', description = '' WHERE id_product = '8053' 20/12/2022 09:36:12 am >> UPDATE ps_product SET wholesale_price = '34.20', on_sale = '0', price = '77.8688524590164' WHERE id_product = '8053' 20/12/2022 09:36:12 am >> UPDATE ps_product_shop SET wholesale_price = '34.20', price = '77.8688524590164', id_tax_rules_group = '1', id_category_default = '147', 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 = '8053' 20/12/2022 09:36:12 am >> DELETE FROM ps_specific_price WHERE id_product = '8053' 20/12/2022 09:40:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3974' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 09:40:13 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' , '3974' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 20/12/2022 09:40:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77400' 20/12/2022 09:40:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77400' 20/12/2022 09:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77400' , '10445' , 'TAPPO - RICAMBIO' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 20/12/2022 09:40:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '10445' AND id_supplier = '' 20/12/2022 09:40:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10445' , '' , '1' ) 20/12/2022 09:58:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3975' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 09:58:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3975' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.60' , '59.51' , NOW() , NOW() ) 20/12/2022 09:58:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77401' 20/12/2022 09:58:20 am >> DELETE FROM ps_document_detail WHERE id_document = '77401' 20/12/2022 09:58:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77401' , '17746' , 'SEGNALIBRO - PR SP 09' , '242' , '-242' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '72.60' ) 20/12/2022 09:58:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '17746' AND id_supplier = '' 20/12/2022 09:58:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17746' , '' , '1' ) 20/12/2022 10:01:22 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2022 10:01:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20558' , '1' , '' , 'nuovo-prodotto' ) 20/12/2022 10:01:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20558' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2022 10:01:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20558' , '0' , '1' , '0' , '0' ) 20/12/2022 10:02:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002105' AND id_product != '20558' AND ean13 != '' 20/12/2022 10:02:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002105', date_upd = NOW() WHERE id_product = '20558' 20/12/2022 10:02:32 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 2,5X30 - 124', description = '' WHERE id_product = '20558' 20/12/2022 10:02:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.918032786885246' WHERE id_product = '20558' 20/12/2022 10:02:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.918032786885246', id_tax_rules_group = '1', id_category_default = '147', 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 = '20558' 20/12/2022 10:02:32 am >> DELETE FROM ps_specific_price WHERE id_product = '20558' 20/12/2022 10:05:07 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2022 10:05:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20559' , '1' , '' , 'nuovo-prodotto' ) 20/12/2022 10:05:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20559' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2022 10:05:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20559' , '0' , '1' , '0' , '0' ) 20/12/2022 10:05:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002106' AND id_product != '20559' AND ean13 != '' 20/12/2022 10:05:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002106', date_upd = NOW() WHERE id_product = '20559' 20/12/2022 10:05:53 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 3,2 X 30 - 132', description = '' WHERE id_product = '20559' 20/12/2022 10:05:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '20559' 20/12/2022 10:05:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '147', 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 = '20559' 20/12/2022 10:05:53 am >> DELETE FROM ps_specific_price WHERE id_product = '20559' 20/12/2022 10:06:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3976' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:06:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3976' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 20/12/2022 10:06:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77402' 20/12/2022 10:06:53 am >> DELETE FROM ps_document_detail WHERE id_document = '77402' 20/12/2022 10:06:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77402' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 20/12/2022 10:06:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19362' AND id_supplier = '' 20/12/2022 10:06:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19362' , '' , '1' ) 20/12/2022 10:06:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77402' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 20/12/2022 10:06:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '9695' AND id_supplier = '' 20/12/2022 10:06:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9695' , '' , '1' ) 20/12/2022 10:07:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000030655' AND id_product != '12317' AND ean13 != '' 20/12/2022 10:07:16 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000030655', date_upd = NOW() WHERE id_product = '12317' 20/12/2022 10:07:16 am >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879', description = '' WHERE id_product = '12317' 20/12/2022 10:07:16 am >> UPDATE ps_product SET wholesale_price = '3.80', on_sale = '0', price = '8.19672131147541' WHERE id_product = '12317' 20/12/2022 10:07:16 am >> UPDATE ps_product_shop SET wholesale_price = '3.80', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '147', 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 = '12317' 20/12/2022 10:07:16 am >> DELETE FROM ps_specific_price WHERE id_product = '12317' 20/12/2022 10:09:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '4103' , '2022-12-16' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '275.26' , '225.63' , NOW() , NOW() ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77403' 20/12/2022 10:09:50 am >> DELETE FROM ps_document_detail WHERE id_document = '77403' 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '1' , '1' , '39.5' , '32.377049180328' , '22' , '5' , '45.7805' ) 20/12/2022 10:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '12' 20/12/2022 10:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '12' , '1' ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '10' , '10' , '1' , '3' , '2.4590163934426' , '22' , '5' , '34.7700' ) 20/12/2022 10:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '12' 20/12/2022 10:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '12' , '1' ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '5.5' , '4.5081967213115' , '22' , '5' , '63.7450' ) 20/12/2022 10:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '12' 20/12/2022 10:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '12' , '1' ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '6' , '6' , '1' , '5.5' , '4.5081967213115' , '22' , '5' , '38.2470' ) 20/12/2022 10:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '12' 20/12/2022 10:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '12' , '1' ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '2' , '1' , '8' , '6.5573770491803' , '22' , '5' , '18.5440' ) 20/12/2022 10:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '12' 20/12/2022 10:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '12' , '1' ) 20/12/2022 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '5' , '10.4310' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '2' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '10.4310' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '3' , '3' , '1' , '5' , '4.0983606557377' , '22' , '5' , '17.3850' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '4205' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4205' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '20558' , 'FINTA CANDELA 2,5X30 - 124' , '2' , '2' , '1' , '2.5' , '2.0491803278689' , '22' , '5' , '5.7950' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20558' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20558' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '2' , '1' , '4' , '3.2786885245902' , '22' , '5' , '9.2720' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '20559' , 'FINTA CANDELA 3,2 X 30 - 132' , '2' , '2' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '10.4310' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20559' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20559' , '12' , '1' ) 20/12/2022 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '2' , '2' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '10.4310' ) 20/12/2022 10:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '12317' AND id_supplier = '12' 20/12/2022 10:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12317' , '12' , '1' ) 20/12/2022 10:10:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3977' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:10:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3977' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.25' , '5.12' , NOW() , NOW() ) 20/12/2022 10:10:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77404' 20/12/2022 10:10:48 am >> DELETE FROM ps_document_detail WHERE id_document = '77404' 20/12/2022 10:10:49 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 ( '77404' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '25' , '-25' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '6.25' ) 20/12/2022 10:10:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '' 20/12/2022 10:10:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '' , '1' ) 20/12/2022 10:30:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:30:50 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' , '3978' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.10' , '114.58' , NOW() , NOW() ) 20/12/2022 10:30:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77405' 20/12/2022 10:30:50 am >> DELETE FROM ps_document_detail WHERE id_document = '77405' 20/12/2022 10:30:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 20/12/2022 10:30:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 20/12/2022 10:30:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 20/12/2022 10:30:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '14835' , 'STELLA COMETA - P581' , '2' , '-2' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '4.80' ) 20/12/2022 10:30:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 20/12/2022 10:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 20/12/2022 10:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105' , '86.065573770492' , '22' , '0' , '105.00' ) 20/12/2022 10:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/12/2022 10:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/12/2022 10:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/12/2022 10:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/12/2022 10:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/12/2022 10:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '9486' , 'S. MICHELE ARC. BABY - 023 SMK/9 BB' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 20/12/2022 10:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '9486' AND id_supplier = '' 20/12/2022 10:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9486' , '' , '1' ) 20/12/2022 10:30:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77405' , '18102' , 'CROCE ULIVO DELL\'AMICIZIA - PG748 ' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 20/12/2022 10:30:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18102' AND id_supplier = '' 20/12/2022 10:30:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18102' , '' , '1' ) 20/12/2022 10:31:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3979' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:31:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3979' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 20/12/2022 10:31:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77406' 20/12/2022 10:31:18 am >> DELETE FROM ps_document_detail WHERE id_document = '77406' 20/12/2022 10:31:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77406' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/12/2022 10:31:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '' 20/12/2022 10:31:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '' , '1' ) 20/12/2022 10:31:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77406' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 20/12/2022 10:31:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '' 20/12/2022 10:31:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '' , '1' ) 20/12/2022 10:32:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3980' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:32:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3980' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '10.52' , NOW() , NOW() ) 20/12/2022 10:32:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77407' 20/12/2022 10:32:36 am >> DELETE FROM ps_document_detail WHERE id_document = '77407' 20/12/2022 10:32:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77407' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 20/12/2022 10:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 20/12/2022 10:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 20/12/2022 10:32:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77407' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/12/2022 10:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 20/12/2022 10:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 20/12/2022 10:32:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77407' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 20/12/2022 10:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/12/2022 10:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/12/2022 10:36:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3981' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:36:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3981' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 20/12/2022 10:36:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77408' 20/12/2022 10:36:18 am >> DELETE FROM ps_document_detail WHERE id_document = '77408' 20/12/2022 10:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77408' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/12/2022 10:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 20/12/2022 10:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 20/12/2022 10:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77408' , '18334' , 'CUORE VOTIVO' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 20/12/2022 10:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18334' AND id_supplier = '' 20/12/2022 10:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18334' , '' , '1' ) 20/12/2022 10:42:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3982' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 10:42:13 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' , '3982' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.10' , NOW() , NOW() ) 20/12/2022 10:42:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77409' 20/12/2022 10:42:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77409' 20/12/2022 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77409' , '15076' , 'PRESEPE ALABASTRO - 215' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 20/12/2022 10:42:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '15076' AND id_supplier = '' 20/12/2022 10:42:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15076' , '' , '1' ) 20/12/2022 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77409' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 20/12/2022 10:42:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17350' AND id_supplier = '' 20/12/2022 10:42:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17350' , '' , '1' ) 20/12/2022 11:06:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 11:06:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3983' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 20/12/2022 11:06:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77410' 20/12/2022 11:06:55 am >> DELETE FROM ps_document_detail WHERE id_document = '77410' 20/12/2022 11:06:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77410' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 20/12/2022 11:06:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 11:06:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 11:11:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 11:11:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3984' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.75' , NOW() , NOW() ) 20/12/2022 11:11:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77411' 20/12/2022 11:11:24 am >> DELETE FROM ps_document_detail WHERE id_document = '77411' 20/12/2022 11:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77411' , '18129' , 'TAU COLORATO - T56' , '15' , '-15' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '18.00' ) 20/12/2022 11:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '' 20/12/2022 11:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' ) 20/12/2022 11:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77411' , '8318' , 'PREGHIERA SEMPLICE' , '20' , '-20' , '4' , '0.20' , '0.2' , '0' , '0' , '4.00' ) 20/12/2022 11:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '8318' AND id_supplier = '' 20/12/2022 11:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8318' , '' , '1' ) 20/12/2022 11:45:37 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2022 11:45:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20560' , '1' , '' , 'nuovo-prodotto' ) 20/12/2022 11:45:37 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20560' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2022 11:45:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20560' , '0' , '1' , '0' , '0' ) 20/12/2022 11:47:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 11:47:46 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' , '3985' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.10' , '8.10' , NOW() , NOW() ) 20/12/2022 11:47:46 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 = '77412' 20/12/2022 11:47:46 am >> DELETE FROM ps_document_detail WHERE id_document = '77412' 20/12/2022 11:47:46 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 ( '77412' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 20/12/2022 11:47:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 20/12/2022 11:47:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 20/12/2022 11:47:46 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 ( '77412' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 20/12/2022 11:47:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20320' AND id_supplier = '' 20/12/2022 11:47:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20320' , '' , '1' ) 20/12/2022 11:50:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002107' AND id_product != '20560' AND ean13 != '' 20/12/2022 11:50:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002107', date_upd = NOW() WHERE id_product = '20560' 20/12/2022 11:50:35 am >> UPDATE ps_product_lang SET name = 'AMPOLLE VETRO 523', description = '' WHERE id_product = '20560' 20/12/2022 11:50:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '20560' 20/12/2022 11:50:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '147', 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 = '20560' 20/12/2022 11:50:35 am >> DELETE FROM ps_specific_price WHERE id_product = '20560' 20/12/2022 11:50:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002107' AND id_product != '20560' AND ean13 != '' 20/12/2022 11:50:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002107', date_upd = NOW() WHERE id_product = '20560' 20/12/2022 11:50:50 am >> UPDATE ps_product_lang SET name = 'AMPOLLE VETRO 523', description = '' WHERE id_product = '20560' 20/12/2022 11:50:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '20560' 20/12/2022 11:50:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '147', 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 = '20560' 20/12/2022 11:50:50 am >> DELETE FROM ps_specific_price WHERE id_product = '20560' 20/12/2022 11:51:22 am >> UPDATE ps_document SET id_document_type = '31', document_num = '4103', document_date = '2022-12-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '11', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '363.45', price_tax_excluded = '297.91', date_upd = NOW() WHERE id_document = '77403' 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77403' 20/12/2022 11:51:22 am >> DELETE FROM ps_document_detail WHERE id_document = '77403' 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '1' , '1' , '39.5000' , '32.377049180328' , '22' , '5' , '45.78' ) 20/12/2022 11:51:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '' 20/12/2022 11:51:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '' , '1' ) 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '10' , '10' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '34.77' ) 20/12/2022 11:51:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '' 20/12/2022 11:51:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '' , '1' ) 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '63.75' ) 20/12/2022 11:51:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '' 20/12/2022 11:51:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '' , '1' ) 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '6' , '6' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '38.25' ) 20/12/2022 11:51:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 20/12/2022 11:51:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '2' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '18.54' ) 20/12/2022 11:51:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '' 20/12/2022 11:51:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '' , '1' ) 20/12/2022 11:51:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '1' , '1' , '1' , '9.0000' , '7.3770491803279' , '22' , '5' , '10.43' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '3' , '3' , '1' , '5.0000' , '4.0983606557377' , '22' , '5' , '17.39' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '4205' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4205' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '20558' , 'FINTA CANDELA 2,5X30 - 124' , '2' , '2' , '1' , '2.5000' , '2.0491803278689' , '22' , '5' , '5.80' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20558' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20558' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '20559' , 'FINTA CANDELA 3,2 X 30 - 132' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20559' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20559' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12317' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12317' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '1' , '1' , '12.5' , '10.245901639344' , '22' , '5' , '14.4875' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '13523' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13523' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '2' , '2' , '1' , '15' , '12.295081967213' , '22' , '5' , '34.7700' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 20/12/2022 11:51:23 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 ( '77403' , '20560' , 'AMPOLLE VETRO 523' , '1' , '1' , '1' , '22' , '18.032786885246' , '22' , '5' , '25.4980' ) 20/12/2022 11:51:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20560' AND id_supplier = '' 20/12/2022 11:51:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20560' , '' , '1' ) 20/12/2022 11:59:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3896' AND id_document != '77313' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 20/12/2022 11:59:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3896', document_date = '2022-12-16', 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 = '121.60', price_tax_excluded = '99.67', date_upd = NOW() WHERE id_document = '77313' 20/12/2022 11:59: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 = '77313' 20/12/2022 11:59:40 am >> DELETE FROM ps_document_detail WHERE id_document = '77313' 20/12/2022 11:59: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 ( '77313' , '14792' , 'PRESEPE ALABASTRO 1921/22' , '1' , '-1' , '1' , '10.4' , '8.5245901639344' , '22' , '0' , '10.40' ) 20/12/2022 11:59:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '14792' AND id_supplier = '' 20/12/2022 11:59:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14792' , '' , '1' ) 20/12/2022 11:59: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 ( '77313' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '13' , '-13' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '32.50' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18846' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18846' , '' , '1' ) 20/12/2022 11:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77313' , '18847' , 'QUADRETTO NATIVITA ORO A CALDO - P662' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18847' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18847' , '' , '1' ) 20/12/2022 11:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77313' , '13316' , 'SEGNALIBRI E NATALE - 120' , '200' , '-200' , '1' , '0.1300' , '0.10655737704918' , '22' , '0' , '26.00' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '13316' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13316' , '' , '1' ) 20/12/2022 11:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77313' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 20/12/2022 11:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77313' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '100' , '0.00' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 20/12/2022 11:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77313' , '15072' , 'PRESEPE ALABASTRO - 210' , '4' , '-4' , '1' , '10' , '8.1967213114754' , '22' , '0' , '40.00' ) 20/12/2022 11:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '15072' AND id_supplier = '' 20/12/2022 11:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15072' , '' , '1' ) 20/12/2022 12:00:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '77337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 20/12/2022 12:00:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3916', document_date = '2022-12-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '77337' 20/12/2022 12:00:21 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 = '77337' 20/12/2022 12:00:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '77337' 20/12/2022 12:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77337' , '15080' , 'PRESEPE ALABASTRO - 229' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/12/2022 12:00:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15080' AND id_supplier = '' 20/12/2022 12:00:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15080' , '' , '1' ) 20/12/2022 12:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77337' , '15075' , 'PRESEPE ALABASTRO - 239' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 20/12/2022 12:00:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15075' AND id_supplier = '' 20/12/2022 12:00:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15075' , '' , '1' ) 20/12/2022 12:03:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 12:03: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' , '3986' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 20/12/2022 12:03: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 = '77413' 20/12/2022 12:03:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77413' 20/12/2022 12:03: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 ( '77413' , '15075' , 'PRESEPE ALABASTRO - 239' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 20/12/2022 12:03:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15075' AND id_supplier = '' 20/12/2022 12:03:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15075' , '' , '1' ) 20/12/2022 12:25:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3987' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 12:25:00 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' , '3987' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.92' , '35.92' , NOW() , NOW() ) 20/12/2022 12:25:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77414' 20/12/2022 12:25:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '77414' 20/12/2022 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77414' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 20/12/2022 12:25:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 12:25:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77414' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/12/2022 12:25:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 20/12/2022 12:25:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 20/12/2022 12:25:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77414' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/12/2022 12:25:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 20/12/2022 12:25:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 20/12/2022 12:25:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 12:25: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' , '3988' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.05' , '171.05' , NOW() , NOW() ) 20/12/2022 12:25: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 = '77415' 20/12/2022 12:25:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77415' 20/12/2022 12:25: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 ( '77415' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '25' , '-25' , '4' , '5.00' , '5' , '0' , '5' , '118.75' ) 20/12/2022 12:25:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 12:25:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 12:25: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 ( '77415' , '20440' , 'AMEN - FEB. 23' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/12/2022 12:25:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 20/12/2022 12:25:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 20/12/2022 12:25: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 ( '77415' , '20441' , 'AMEN - GEN. 23' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/12/2022 12:25:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 20/12/2022 12:25:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 20/12/2022 12:25: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 ( '77415' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 20/12/2022 12:25:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20320' AND id_supplier = '' 20/12/2022 12:25:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20320' , '' , '1' ) 20/12/2022 12:36:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/12/2022 12:36:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20561' , '1' , '' , 'nuovo-prodotto' ) 20/12/2022 12:36:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20561' , '1' , '1' , '2' , NOW() , NOW() ) 20/12/2022 12:36:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20561' , '0' , '1' , '0' , '0' ) 20/12/2022 12:37:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400330038' AND id_product != '20561' AND ean13 != '' 20/12/2022 12:37:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400330038', date_upd = NOW() WHERE id_product = '20561' 20/12/2022 12:37:20 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CARTONCINO CON BAMBINO- P762', description = '' WHERE id_product = '20561' 20/12/2022 12:37:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.4918032786885246' WHERE id_product = '20561' 20/12/2022 12:37:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.4918032786885246', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20561' 20/12/2022 12:37:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '20561' 20/12/2022 12:38:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'A5255' , '2022-12-16' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '11.98' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '167.85' , '137.58' , NOW() , NOW() ) 20/12/2022 12:38: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 = '77416' 20/12/2022 12:38:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '77416' 20/12/2022 12:38: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 ( '77416' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO- P762' , '400' , '400' , '1' , '0.21' , '0.17213114754098' , '22' , '0' , '102.4800' ) 20/12/2022 12:38:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20561' AND id_supplier = '28' 20/12/2022 12:38:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20561' , '28' , '1' ) 20/12/2022 12:38: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 ( '77416' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '500' , '500' , '1' , '0.0832' , '0.068196721311475' , '22' , '0' , '50.7520' ) 20/12/2022 12:38:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 20/12/2022 12:38:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 20/12/2022 12:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 12:42:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3989' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 20/12/2022 12:42:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77417' 20/12/2022 12:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '77417' 20/12/2022 12:42: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 ( '77417' , '20184' , 'ANGELO SU CONCHIGLIA - AR111' , '1' , '-1' , '1' , '4.70' , '3.8524590163934' , '22' , '0' , '4.70' ) 20/12/2022 12:42:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20184' AND id_supplier = '' 20/12/2022 12:42:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20184' , '' , '1' ) 20/12/2022 12:42: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 ( '77417' , '20179' , 'ANGELO IN RESINA CM 6 - AR94' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 20/12/2022 12:42:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20179' AND id_supplier = '' 20/12/2022 12:42:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20179' , '' , '1' ) 20/12/2022 12:44:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3927' AND id_document != '77349' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-19') 20/12/2022 12:44:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3927', document_date = '2022-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '48.60', price_tax_excluded = '48.60', date_upd = NOW() WHERE id_document = '77349' 20/12/2022 12:44:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77349' 20/12/2022 12:44:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77349' 20/12/2022 12:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77349' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.0000' , '3' , '0' , '0' , '15.00' ) 20/12/2022 12:44:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/12/2022 12:44:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/12/2022 12:44:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77349' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '8' , '-8' , '4' , '4.2' , '4.2' , '0' , '' , '33.60' ) 20/12/2022 12:44:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 12:44:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 03:35:52 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '4103', document_date = '2022-12-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '11.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '444.01', price_tax_excluded = '363.94', date_upd = NOW() WHERE id_document = '77403' 20/12/2022 03:35:52 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 = '77403' 20/12/2022 03:35:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77403' 20/12/2022 03:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '1' , '1' , '39.5000' , '32.377049180328' , '22' , '5' , '45.78' ) 20/12/2022 03:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '' 20/12/2022 03:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '' , '1' ) 20/12/2022 03:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '10' , '10' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '34.77' ) 20/12/2022 03:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '' 20/12/2022 03:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '' , '1' ) 20/12/2022 03:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '63.75' ) 20/12/2022 03:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '' 20/12/2022 03:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '' , '1' ) 20/12/2022 03:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '6' , '6' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '38.25' ) 20/12/2022 03:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 20/12/2022 03:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '2' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '18.54' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '1' , '1' , '1' , '9.0000' , '7.3770491803279' , '22' , '5' , '10.43' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '3' , '3' , '1' , '5.0000' , '4.0983606557377' , '22' , '5' , '17.39' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4205' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4205' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '20558' , 'FINTA CANDELA 2,5X30 - 124' , '2' , '2' , '1' , '2.5000' , '2.0491803278689' , '22' , '5' , '5.80' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20558' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20558' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '20559' , 'FINTA CANDELA 3,2 X 30 - 132' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20559' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20559' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '2' , '2' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '10.43' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12317' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12317' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '1' , '1' , '12.5000' , '10.245901639344' , '22' , '5' , '14.49' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13523' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13523' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '2' , '2' , '1' , '15.0000' , '12.295081967213' , '22' , '5' , '34.77' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '20560' , 'AMPOLLE VETRO 523' , '1' , '1' , '1' , '22.0000' , '18.032786885246' , '22' , '5' , '25.50' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20560' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20560' , '' , '1' ) 20/12/2022 03:35:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77403' , '18348' , 'TECA OSTIA MAGNA 17x23 - 823/M' , '1' , '1' , '1' , '69.5' , '56.967213114754' , '22' , '5' , '80.5505' ) 20/12/2022 03:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18348' AND id_supplier = '' 20/12/2022 03:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18348' , '' , '1' ) 20/12/2022 03:36:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000017779' AND id_product != '18348' AND ean13 != '' 20/12/2022 03:36:29 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000017779', date_upd = NOW() WHERE id_product = '18348' 20/12/2022 03:36:29 pm >> UPDATE ps_product_lang SET name = 'TECA OSTIA MAGNA 17x23 - 823/M', description = '' WHERE id_product = '18348' 20/12/2022 03:36:29 pm >> UPDATE ps_product SET wholesale_price = '59.85', on_sale = '0', price = '129.5081967213115' WHERE id_product = '18348' 20/12/2022 03:36:29 pm >> UPDATE ps_product_shop SET wholesale_price = '59.85', price = '129.5081967213115', id_tax_rules_group = '1', id_category_default = '147', 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 = '18348' 20/12/2022 03:36:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '18348' 20/12/2022 03:37:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 03:37:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3990' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 20/12/2022 03:37: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 = '77418' 20/12/2022 03:37:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '77418' 20/12/2022 03:37: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 ( '77418' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 20/12/2022 03:37:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18882' AND id_supplier = '' 20/12/2022 03:37:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18882' , '' , '1' ) 20/12/2022 03:42:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 20/12/2022 03:42:27 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '116.20', price_tax_excluded = '116.20', date_upd = NOW() WHERE id_document = '61794' 20/12/2022 03:42:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 20/12/2022 03:42:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 20/12/2022 03:42:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/12/2022 03:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 20/12/2022 03:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 20/12/2022 03:42:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/12/2022 03:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 20/12/2022 03:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 20/12/2022 03:42:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20443' , 'PAROLA E PREGHIERA - GEN. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/12/2022 03:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20443' AND id_supplier = '' 20/12/2022 03:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20443' , '' , '1' ) 20/12/2022 03:42:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 20/12/2022 03:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20462' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20462' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20492' , 'AMORE IN UNO SGUARDO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20492' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20492' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16980' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16980' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20527' , 'AMEN - APR 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20527' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20527' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20528' , 'AMEN - MAR 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20528' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20528' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/12/2022 03:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 20/12/2022 03:42:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '' 20/12/2022 03:42:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '' , '1' ) 20/12/2022 04:02:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 04:02: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' , '3991' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.00' , '111.48' , NOW() , NOW() ) 20/12/2022 04:02: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 = '77419' 20/12/2022 04:02:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '77419' 20/12/2022 04:02: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 ( '77419' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 20/12/2022 04:02:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '' 20/12/2022 04:02:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '' , '1' ) 20/12/2022 04:02: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 ( '77419' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 20/12/2022 04:02:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 20/12/2022 04:02:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 20/12/2022 04:02: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 ( '77419' , '13222' , 'CLERGY SPIGATO CELESTE ML COTONE - 41' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 20/12/2022 04:02:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13222' AND id_supplier = '' 20/12/2022 04:02:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13222' , '' , '1' ) 20/12/2022 04:09:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 04:09:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3992' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 20/12/2022 04:09:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77420' 20/12/2022 04:09:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '77420' 20/12/2022 04:09:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77420' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '21' , '-21' , '4' , '5.00' , '5' , '0' , '0' , '105.00' ) 20/12/2022 04:09:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:09:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:10:07 pm >> DELETE FROM ps_document WHERE id_document = '77420' 20/12/2022 04:10:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '77420' 20/12/2022 04:10:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 04:10:23 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' , '3992' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 20/12/2022 04:10:23 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 = '77421' 20/12/2022 04:10:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77421' 20/12/2022 04:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77421' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 20/12/2022 04:10:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 20/12/2022 04:10:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 20/12/2022 04:12:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 04:12:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3993' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '46.20' , NOW() , NOW() ) 20/12/2022 04:12:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77422' 20/12/2022 04:12:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77422' 20/12/2022 04:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77422' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '0' , '30.00' ) 20/12/2022 04:12:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77422' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 20/12/2022 04:12:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20320' AND id_supplier = '' 20/12/2022 04:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20320' , '' , '1' ) 20/12/2022 04:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77422' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2022 04:12:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 20/12/2022 04:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 20/12/2022 04:12:47 pm >> DELETE FROM ps_document WHERE id_document = '77422' 20/12/2022 04:12:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '77422' 20/12/2022 04:31:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3830' AND id_document != '77221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 20/12/2022 04:31:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3830', document_date = '2022-12-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 = '171.20', price_tax_excluded = '152.86', date_upd = NOW() WHERE id_document = '77221' 20/12/2022 04:31:23 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 = '77221' 20/12/2022 04:31:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77221' 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/12/2022 04:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '16' , '-16' , '4' , '4' , '4' , '0' , '0' , '64.00' ) 20/12/2022 04:31:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:31:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:34:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3782' AND id_document != '76139' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-07') 20/12/2022 04:34:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3782', document_date = '2022-12-07', 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 = '25.90', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '76139' 20/12/2022 04:34:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76139' 20/12/2022 04:34:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '76139' 20/12/2022 04:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76139' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '2.3000' , '2.3' , '0' , '0' , '6.90' ) 20/12/2022 04:34:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/12/2022 04:34:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/12/2022 04:34:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76139' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 20/12/2022 04:34:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:34:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:35:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3936' AND id_document != '77358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-19') 20/12/2022 04:35:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3936', document_date = '2022-12-19', 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 = '28.60', price_tax_excluded = '28.31', date_upd = NOW() WHERE id_document = '77358' 20/12/2022 04:35: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 = '77358' 20/12/2022 04:35:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '77358' 20/12/2022 04:35: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 ( '77358' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 20/12/2022 04:35:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/12/2022 04:35:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/12/2022 04:35: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 ( '77358' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 20/12/2022 04:35:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/12/2022 04:35:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/12/2022 04:35: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 ( '77358' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 20/12/2022 04:35:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:35:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:35:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3901' AND id_document != '77320' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 20/12/2022 04:35:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3901', document_date = '2022-12-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.50', price_tax_excluded = '26.98', date_upd = NOW() WHERE id_document = '77320' 20/12/2022 04:35:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77320' 20/12/2022 04:35:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77320' 20/12/2022 04:35:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77320' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 20/12/2022 04:35:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/12/2022 04:35:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/12/2022 04:35:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77320' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 20/12/2022 04:35:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/12/2022 04:35:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/12/2022 04:35:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77320' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 20/12/2022 04:35:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 20/12/2022 04:35:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 20/12/2022 04:35:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77320' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '3' , '-3' , '4' , '4.5' , '4.5' , '0' , '' , '13.50' ) 20/12/2022 04:35:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 20/12/2022 04:35:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 20/12/2022 04:36:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3859' AND id_document != '77261' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 20/12/2022 04:36:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3859', document_date = '2022-12-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 = '72.00', price_tax_excluded = '63.52', date_upd = NOW() WHERE id_document = '77261' 20/12/2022 04:36: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 = '77261' 20/12/2022 04:36:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '77261' 20/12/2022 04:36: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 ( '77261' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 20/12/2022 04:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/12/2022 04:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/12/2022 04:36: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 ( '77261' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 20/12/2022 04:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/12/2022 04:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/12/2022 04:36: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 ( '77261' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 20/12/2022 04:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 20/12/2022 04:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 20/12/2022 04:36: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 ( '77261' , '20320' , 'MESSA MEDITAZIONE - GEN/FEB 2022' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 20/12/2022 04:36:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20320' AND id_supplier = '' 20/12/2022 04:36:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20320' , '' , '1' ) 20/12/2022 05:28:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 05:28:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3993' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 20/12/2022 05:28: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 = '77423' 20/12/2022 05:28:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '77423' 20/12/2022 05:28: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 ( '77423' , '16333' , 'NATIVITA\' ALBERO VETRO CM 16' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 20/12/2022 05:28:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16333' AND id_supplier = '' 20/12/2022 05:28:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16333' , '' , '1' ) 20/12/2022 05:59:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 05:59:23 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' , '3994' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 20/12/2022 05:59:23 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 = '77424' 20/12/2022 05:59:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77424' 20/12/2022 05:59:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77424' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 20/12/2022 05:59:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 20/12/2022 05:59:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 20/12/2022 05:59:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77424' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/12/2022 05:59:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/12/2022 05:59:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/12/2022 07:06:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 07:06: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' , '3995' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 20/12/2022 07:06: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 = '77425' 20/12/2022 07:06:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '77425' 20/12/2022 07:06: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 ( '77425' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 20/12/2022 07:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/12/2022 07:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/12/2022 07:16:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20') 20/12/2022 07:16:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3996' , '2022-12-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '125.00' , NOW() , NOW() ) 20/12/2022 07:16:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77426' 20/12/2022 07:16:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '77426' 20/12/2022 07:16:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77426' , '1141' , 'BIBBIA DI GERUSALEMME - PELLE/ORO' , '1' , '-1' , '4' , '125' , '125' , '0' , '0' , '125.00' ) 20/12/2022 07:16:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1141' AND id_supplier = '' 20/12/2022 07:16:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1141' , '' , '1' )