25/05/2022 09:11:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '600505' , '2022-05-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.24' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '77.58' , '77.58' , NOW() , NOW() ) 25/05/2022 09:11:01 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 = '58433' 25/05/2022 09:11:01 am >> DELETE FROM ps_document_detail WHERE id_document = '58433' 25/05/2022 09:11:01 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 ( '58433' , '7745' , 'PAURE - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 25/05/2022 09:11:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7745' AND id_supplier = '7' 25/05/2022 09:11:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7745' , '7' , '1' ) 25/05/2022 09:11:01 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 ( '58433' , '7012' , 'NOIA - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 25/05/2022 09:11:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7012' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7012' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '677' , 'ANSIA - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '677' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '677' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17127' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17127' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '7274' , 'ORDO MISSAE ' , '3' , '3' , '4' , '3.00' , '3' , '0' , '33' , '6.0300' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '7274' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7274' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '19328' , 'AMEN - GIU. 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '1763' , 'CASTELLO INTERIORE - TERESA DAVILA' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '33' , '5.6950' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '1763' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1763' , '7' , '1' ) 25/05/2022 09:11:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58433' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '1' , '4' , '34.00' , '34' , '0' , '33' , '22.7800' ) 25/05/2022 09:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17414' AND id_supplier = '7' 25/05/2022 09:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17414' , '7' , '1' ) 25/05/2022 09:14:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047700' AND id_product != '19587' AND ean13 != '' 25/05/2022 09:14:43 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047700', date_upd = NOW() WHERE id_product = '19587' 25/05/2022 09:14:43 am >> UPDATE ps_product_lang SET name = 'GESU\' BAMBINO DI PRaGA - 8079', description = '' WHERE id_product = '19587' 25/05/2022 09:14:43 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '19587' 25/05/2022 09:14:43 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19587' 25/05/2022 09:14:43 am >> DELETE FROM ps_specific_price WHERE id_product = '19587' 25/05/2022 09:22:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 09:22: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' , '1647' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.25' , '49.11' , NOW() , NOW() ) 25/05/2022 09:22: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 = '58434' 25/05/2022 09:22:48 am >> DELETE FROM ps_document_detail WHERE id_document = '58434' 25/05/2022 09:22:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58434' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 25/05/2022 09:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '' 25/05/2022 09:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '' , '1' ) 25/05/2022 09:22: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 ( '58434' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 25/05/2022 09:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 25/05/2022 09:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 25/05/2022 09:22: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 ( '58434' , '19588' , 'SCELTA DI ENEA - L.M. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/05/2022 09:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 25/05/2022 09:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 25/05/2022 09:24:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817160957' AND id_product != '19588' AND ean13 != '' 25/05/2022 09:24:03 am >> UPDATE ps_product SET id_supplier = '47', reference = '7/4', ean13 = '9788817160957', date_upd = NOW() WHERE id_product = '19588' 25/05/2022 09:24:03 am >> UPDATE ps_product_lang SET name = 'SCELTA DI ENEA - L. EPICOCO', description = '' WHERE id_product = '19588' 25/05/2022 09:24:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '19588' 25/05/2022 09:24:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '113', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19588' 25/05/2022 09:24:03 am >> DELETE FROM ps_specific_price WHERE id_product = '19588' 25/05/2022 09:24:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1647' AND id_document != '58434' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 09:24:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1647', document_date = '2022-05-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.25', price_tax_excluded = '49.11', date_upd = NOW() WHERE id_document = '58434' 25/05/2022 09:24:29 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 = '58434' 25/05/2022 09:24:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58434' 25/05/2022 09:24:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58434' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 25/05/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '' 25/05/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '' , '1' ) 25/05/2022 09:24:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58434' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 25/05/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 25/05/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 25/05/2022 09:24:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58434' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/05/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 25/05/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 25/05/2022 10:09:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 10:09:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1648' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.36' , '63.07' , NOW() , NOW() ) 25/05/2022 10:09:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58435' 25/05/2022 10:09:39 am >> DELETE FROM ps_document_detail WHERE id_document = '58435' 25/05/2022 10:09:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58435' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '2' , '-2' , '4' , '18.50' , '18.5' , '0' , '5' , '35.16' ) 25/05/2022 10:09:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 25/05/2022 10:09:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 25/05/2022 10:09:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58435' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/05/2022 10:09:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 25/05/2022 10:09:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 25/05/2022 10:09: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 ( '58435' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 25/05/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = '' 25/05/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '' , '1' ) 25/05/2022 10:09: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 ( '58435' , '19507' , 'MESSA MEDITAZIONE - LUG/AGO 2022' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 25/05/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = '' 25/05/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '' , '1' ) 25/05/2022 10:09: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 ( '58435' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 25/05/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 25/05/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 25/05/2022 10:14:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 10:14:07 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' , '1649' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.80' , '46.61' , NOW() , NOW() ) 25/05/2022 10:14:07 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 = '58436' 25/05/2022 10:14:07 am >> DELETE FROM ps_document_detail WHERE id_document = '58436' 25/05/2022 10:14:07 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 ( '58436' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 25/05/2022 10:14:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 25/05/2022 10:14:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 25/05/2022 10:14:07 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 ( '58436' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 25/05/2022 10:14:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 25/05/2022 10:14:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 25/05/2022 10:14:07 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 ( '58436' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.8' , '10.8' , '0' , '0' , '10.80' ) 25/05/2022 10:14:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 25/05/2022 10:14:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 25/05/2022 11:06:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 11:06:08 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' , '1650' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '11.13' , NOW() , NOW() ) 25/05/2022 11:06:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58437' 25/05/2022 11:06:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58437' 25/05/2022 11:06:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58437' , '7274' , 'ORDO MISSAE ' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '0' , '9.00' ) 25/05/2022 11:06:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '7274' AND id_supplier = '' 25/05/2022 11:06:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7274' , '' , '1' ) 25/05/2022 11:06:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58437' , '3103' , 'CROCE SAN BENEDETTO' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 25/05/2022 11:06:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '3103' AND id_supplier = '' 25/05/2022 11:06:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3103' , '' , '1' ) 25/05/2022 11:09:26 am >> UPDATE ps_document SET id_document_type = '31', document_num = '115/22', document_date = '2022-05-10', document_letter = '22', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '26.50', price_tax_excluded = '26.50', date_upd = NOW() WHERE id_document = '57838' 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57838' 25/05/2022 11:09:26 am >> DELETE FROM ps_document_detail WHERE id_document = '57838' 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '9436' , 'SAN GABRIELE DELL\'ADDOLORATA - V.SALVOLDI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '9549' , 'SANTA CATERINA LABOURÉ - M.TARONI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '6055' , 'MADONNA DEL CARMINE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '19552' , 'MADONNA CHE SCIOGLIE I NODI - A. CAMPAGNA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:35 am >> UPDATE ps_document SET id_document_type = '31', document_num = '115/22', document_date = '2022-05-10', document_letter = '22', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '26.50', price_tax_excluded = '26.50', date_upd = NOW() WHERE id_document = '57838' 25/05/2022 11:09:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57838' 25/05/2022 11:09:35 am >> DELETE FROM ps_document_detail WHERE id_document = '57838' 25/05/2022 11:09:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57838' , '9436' , 'SAN GABRIELE DELL\'ADDOLORATA - V.SALVOLDI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 25/05/2022 11:09:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '17' 25/05/2022 11:09:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '9549' , 'SANTA CATERINA LABOURÉ - M.TARONI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '9549' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9549' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '6055' , 'MADONNA DEL CARMINE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '6055' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6055' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '19552' , 'MADONNA CHE SCIOGLIE I NODI - A. CAMPAGNA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19552' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19552' , '17' , '1' ) 25/05/2022 11:09: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 ( '57838' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 25/05/2022 11:09:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '17' 25/05/2022 11:09:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '17' , '1' ) 25/05/2022 11:10:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/05/2022 11:10:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19594' , '1' , '' , 'nuovo-prodotto' ) 25/05/2022 11:10:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19594' , '1' , '1' , '2' , NOW() , NOW() ) 25/05/2022 11:10:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19594' , '0' , '1' , '0' , '0' ) 25/05/2022 11:39:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001995' AND id_product != '19594' AND ean13 != '' 25/05/2022 11:39:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001995', date_upd = NOW() WHERE id_product = '19594' 25/05/2022 11:39:46 am >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100%', description = '' WHERE id_product = '19594' 25/05/2022 11:39:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.24590163934426' WHERE id_product = '19594' 25/05/2022 11:39:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.24590163934426', id_tax_rules_group = '1', id_category_default = '253', 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 = '19594' 25/05/2022 11:39:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19594' 25/05/2022 11:39:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19594' 25/05/2022 11:39:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19595' , '1' , '' , 'nuovo-prodotto' ) 25/05/2022 11:39:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19595' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19594' 25/05/2022 11:39:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19595' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19594' 25/05/2022 11:40:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001996' AND id_product != '19595' AND ean13 != '' 25/05/2022 11:40:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001996', date_upd = NOW() WHERE id_product = '19595' 25/05/2022 11:40:23 am >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100% - EXTRA', description = '' WHERE id_product = '19595' 25/05/2022 11:40:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '33.60655737704918' WHERE id_product = '19595' 25/05/2022 11:40:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '33.60655737704918', id_tax_rules_group = '1', id_category_default = '253', 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 = '19595' 25/05/2022 11:40:23 am >> DELETE FROM ps_specific_price WHERE id_product = '19595' 25/05/2022 12:47:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 12:47:40 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' , '1651' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 25/05/2022 12:47:40 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 = '58438' 25/05/2022 12:47:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '58438' 25/05/2022 12:47: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 ( '58438' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 25/05/2022 12:47:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 25/05/2022 12:47:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 25/05/2022 01:07:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 01:07:43 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' , '1652' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.30' , '30.32' , NOW() , NOW() ) 25/05/2022 01:07:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58439' 25/05/2022 01:07:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58439' 25/05/2022 01:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58439' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/05/2022 01:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 25/05/2022 01:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 25/05/2022 01:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58439' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 25/05/2022 01:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 25/05/2022 01:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 25/05/2022 01:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58439' , '579' , 'ANELLO FEDINA IN ARG. 925 - M043/020' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/05/2022 01:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '579' AND id_supplier = '' 25/05/2022 01:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '579' , '' , '1' ) 25/05/2022 02:34:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001389' AND id_product != '16550' AND ean13 != '' 25/05/2022 02:34:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001389', date_upd = NOW() WHERE id_product = '16550' 25/05/2022 02:34:47 pm >> UPDATE ps_product_lang SET name = 'CLERGY BIANCO COT. ML - C02', description = '' WHERE id_product = '16550' 25/05/2022 02:34:47 pm >> UPDATE ps_product SET wholesale_price = '16.06', on_sale = '0', price = '32.7049' WHERE id_product = '16550' 25/05/2022 02:34:48 pm >> UPDATE ps_product_shop SET wholesale_price = '16.06', price = '32.7049', id_tax_rules_group = '1', id_category_default = '462', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16550' 25/05/2022 02:34:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '16550' 25/05/2022 02:36:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1///////' , '2022-05-25' , '' , '0' , '77' , '2672' , 'UL. MALBORSKA, 8 42200 CZESTOCHOWA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '429.05' , '429.05' , NOW() , NOW() ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58440' 25/05/2022 02:36:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58440' 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8147' , 'POLO NERA MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '77' 25/05/2022 02:36:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '77' , '1' ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8129' , 'POLO GRIGIO CHIARO MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8129' AND id_supplier = '77' 25/05/2022 02:36:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8129' , '77' , '1' ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8127' , 'POLO GRIGIO CHIARO MM - COTONE - M' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8127' AND id_supplier = '77' 25/05/2022 02:36:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8127' , '77' , '1' ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8113' , 'POLO CELESTE MM - COTONE - XXL - OGGETTI' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8113' AND id_supplier = '77' 25/05/2022 02:36:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8113' , '77' , '1' ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8111' , 'POLO CELESTE MM - COTONE - M' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8111' AND id_supplier = '77' 25/05/2022 02:36:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8111' , '77' , '1' ) 25/05/2022 02:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14296' , 'POLO BLU MM - M ' , '3' , '3' , '0' , '10.5000' , '10.5' , '0' , '0' , '31.50' ) 25/05/2022 02:36:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14296' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14296' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '8101' , 'POLO BLU MM - COTONE - XL - OGGETTI' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8101' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8101' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '8098' , 'POLO BLU MM - COTONE - 3XL - OGGETTI' , '1' , '1' , '0' , '11.8500' , '11.85' , '0' , '0' , '11.85' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8098' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8098' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '8102' , 'POLO BLU MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8102' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8102' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '12766' , 'CLERGY CELESTE MISTO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12766' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12766' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '2177' , 'CLERGY CELESTE MISTO MM - M' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14297' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14297' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14297' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14299' , 'CLERGY BIANCO MM - MISTO - XL' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14299' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14299' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14300' , 'CLERGY BIANCO MM - MISTO - L' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14300' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14300' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14301' , 'CLERGY BIANCO MM - MISTO - M' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 02:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14301' AND id_supplier = '77' 25/05/2022 02:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14301' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14302' , 'CLERGY BIANCO MM - MISTO - 3XL' , '1' , '1' , '0' , '13.7500' , '13.75' , '0' , '0' , '13.75' ) 25/05/2022 02:36:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14302' AND id_supplier = '77' 25/05/2022 02:36:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14302' , '77' , '1' ) 25/05/2022 02:36: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 ( '58440' , '14303' , 'CLERGY BIANCO MM - MISTO - XXL' , '3' , '3' , '0' , '11.6500' , '11.65' , '0' , '0' , '34.95' ) 25/05/2022 02:36:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14303' AND id_supplier = '77' 25/05/2022 02:36:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14303' , '77' , '1' ) 25/05/2022 02:37:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '101' , '2022-05-24' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '109.12' , '89.44' , NOW() , NOW() ) 25/05/2022 02:37:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58441' 25/05/2022 02:37:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '58441' 25/05/2022 02:37:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58441' , '16550' , 'CLERGY BIANCO COT. ML - C02' , '4' , '4' , '1' , '17.3' , '14.180327868852' , '22' , '5' , '80.2028' ) 25/05/2022 02:37:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16550' AND id_supplier = '137' 25/05/2022 02:37:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16550' , '137' , '1' ) 25/05/2022 02:37:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58441' , '13749' , 'TUNICA SVASATA COLLETTO LISTINO' , '1' , '1' , '1' , '13.7' , '11.229508196721' , '22' , '0' , '16.7140' ) 25/05/2022 02:37:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13749' AND id_supplier = '137' 25/05/2022 02:37:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13749' , '137' , '1' ) 25/05/2022 03:56:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 25/05/2022 03:56:24 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', 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 = '90.60', price_tax_excluded = '90.60', date_upd = NOW() WHERE id_document = '50074' 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '50074' 25/05/2022 03:56:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '50074' 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 25/05/2022 03:56:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 25/05/2022 03:56:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 25/05/2022 03:56:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 25/05/2022 03:56:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19498' , 'VANGELI' , '1' , '-1' , '4' , '69.0000' , '69' , '0' , '0' , '69.00' ) 25/05/2022 03:56:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19498' AND id_supplier = '' 25/05/2022 03:56:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19498' , '' , '1' ) 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 25/05/2022 03:56:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 25/05/2022 03:56:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 25/05/2022 03:56:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 25/05/2022 03:56:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 25/05/2022 03:56:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 25/05/2022 03:56:33 pm >> DELETE FROM ps_document WHERE id_document = '58427' 25/05/2022 03:56:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58427' 25/05/2022 05:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 05:05: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' , '1653' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '9.80' , NOW() , NOW() ) 25/05/2022 05:05: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 = '58442' 25/05/2022 05:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58442' 25/05/2022 05:05: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 ( '58442' , '677' , 'ANSIA - V. M. FERNANDEZ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 25/05/2022 05:05:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '677' AND id_supplier = '' 25/05/2022 05:05:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '677' , '' , '1' ) 25/05/2022 05:05: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 ( '58442' , '7012' , 'NOIA - V. M. FERNANDEZ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 25/05/2022 05:05:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7012' AND id_supplier = '' 25/05/2022 05:05:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7012' , '' , '1' ) 25/05/2022 05:45:14 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '80/2022', document_date = '2022-05-19', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '429.05', price_tax_excluded = '429.05', date_upd = NOW() WHERE id_document = '58440' 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58440' 25/05/2022 05:45:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58440' 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8147' , 'POLO NERA MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8129' , 'POLO GRIGIO CHIARO MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8129' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8129' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8127' , 'POLO GRIGIO CHIARO MM - COTONE - M' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8127' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8127' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8113' , 'POLO CELESTE MM - COTONE - XXL - OGGETTI' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8113' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8113' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8111' , 'POLO CELESTE MM - COTONE - M' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8111' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8111' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14296' , 'POLO BLU MM - M ' , '3' , '3' , '0' , '10.5000' , '10.5' , '0' , '0' , '31.50' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14296' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14296' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8101' , 'POLO BLU MM - COTONE - XL - OGGETTI' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8101' AND id_supplier = '' 25/05/2022 05:45:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8101' , '' , '1' ) 25/05/2022 05:45:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8098' , 'POLO BLU MM - COTONE - 3XL - OGGETTI' , '1' , '1' , '0' , '11.8500' , '11.85' , '0' , '0' , '11.85' ) 25/05/2022 05:45:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8098' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8098' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '8102' , 'POLO BLU MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8102' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8102' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '12766' , 'CLERGY CELESTE MISTO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12766' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12766' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '2177' , 'CLERGY CELESTE MISTO MM - M' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14297' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14297' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14297' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14299' , 'CLERGY BIANCO MM - MISTO - XL' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14299' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14299' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14300' , 'CLERGY BIANCO MM - MISTO - L' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14300' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14300' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14301' , 'CLERGY BIANCO MM - MISTO - M' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14301' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14301' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14302' , 'CLERGY BIANCO MM - MISTO - 3XL' , '1' , '1' , '0' , '13.7500' , '13.75' , '0' , '0' , '13.75' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14302' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14302' , '' , '1' ) 25/05/2022 05:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58440' , '14303' , 'CLERGY BIANCO MM - MISTO - XXL' , '3' , '3' , '0' , '11.6500' , '11.65' , '0' , '0' , '34.95' ) 25/05/2022 05:45:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14303' AND id_supplier = '' 25/05/2022 05:45:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14303' , '' , '1' ) 25/05/2022 06:10:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 06:10:41 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' , '1654' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.50' , '21.72' , NOW() , NOW() ) 25/05/2022 06:10:41 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 = '58443' 25/05/2022 06:10:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '58443' 25/05/2022 06:10:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58443' , '15706' , 'CROCE LEGNO ULIVO CM 20 - 4118' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 25/05/2022 06:10:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15706' AND id_supplier = '' 25/05/2022 06:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15706' , '' , '1' ) 25/05/2022 06:10:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58443' , '19311' , 'BRACCIALE MADREPERLA COMUNIONE - 1906/K126' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 25/05/2022 06:10:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19311' AND id_supplier = '' 25/05/2022 06:10:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19311' , '' , '1' ) 25/05/2022 06:12:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 06:12:08 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' , '1655' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 25/05/2022 06:12:08 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 = '58444' 25/05/2022 06:12:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '58444' 25/05/2022 06:12:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58444' , '13749' , 'TUNICA SVASATA COLLETTO LISTINO' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 25/05/2022 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13749' AND id_supplier = '' 25/05/2022 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13749' , '' , '1' ) 25/05/2022 06:36:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-25') 25/05/2022 06:36:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1656' , '2022-05-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 25/05/2022 06:36:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58445' 25/05/2022 06:36:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58445' 25/05/2022 06:36:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58445' , '15590' , 'ANGELO CON CUORE ARG. - 4214' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 25/05/2022 06:36:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15590' AND id_supplier = '' 25/05/2022 06:36:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15590' , '' , '1' )