Web Scraper Produtos Farmacêuticos

@Herculesz

Hi I have strong experience with Python scraping systems, API diagnostics, Playwright automation, requests, pandas, openpyxl, CSV/Excel reporting, caching, logging, and pricing-analysis workflows. The main technical challenge here is stabilizing AppySaúde after its API/authentication changes while preserving the existing Mecofarma scraper and avoiding wrong product matches, invalid prices, duplicate offers, or exposed credentials. I can solve this by first running a proper AppySaúde diagnostic, confirming the live endpoint, JSON structure, pagination, token requirements, offer fields, and exact reason the current scraper fails. For AppySaúde, I would implement API v2 collection with page handling, offer-by-pharmacy extraction, invalid-price filtering, token caching, Playwright fallback, screenshots, and clear debug logs. For Mecofarma, I would keep the current working logic intact and only add preventive validation, logging, and output consistency where needed. I can generate standardized Excel/CSV outputs, consolidated competitor files, pricing parameter sheets, margin alerts, and Windows-friendly .bat execution scripts. My focus is to deliver a secure, maintainable scraper system with clean diagnostics, reliable exports, and a foundation ready for later pricing intelligence and automation. Thanks, Hercules

@intelliresponse

With 13+ years of experience, I'm Steven, your ultimate solution provider for web automation, data extraction, AI development and more. This project aligns perfectly with my skill set, honed through successfully completed ventures like scraping sports data from platforms like FlashScore and deploying VFS Global Visa Booking Bots efficiently. The latter is especially relevant given the need for a stable system for scraping products and prices from Mecofarma and AppySaúde- which is a service I'm an expert in. To address the issues you have identified, I will initially preserve the functional Mecofarma scraper but enhance it to avoid accepting wrong products due to Magento redirection. Regarding AppySaude, I'll thoroughly investigate the new API structure using my extensive Python knowledge and create a seamless experience with Playwright authentication when needed. Additionally, you can trust me with maintaining logs, diagnoses processes and contingency mechanisms to accommodate future site changes and errors. My commitment to generating high-quality work extends to employing fallback solutions like API calls within browsers via Playwright if the API itself fails. Using refreshing ticks to keep tokens valid during long-hour operations is another one of my specialties. Let's collaborate to ensure this essential service stays productive and efficient! Get in touch with me today

@onkarkulkarni8

Hello, your "Web Scraper Produtos Farmacêuticos" project is right in my wheelhouse. I develop modern JavaScript apps end to end — React/Vue/Next on the front and Node/Express on the back, in TypeScript where it helps. Working with javascript, python, excel, web scraping, software architecture, data extraction, beautifulsoup, api integration, I focus on responsive, fast UIs, clean component structure, and reliable APIs — no page-builder shortcuts. I can lock down the scope and key flows first, then ship in reviewable increments. Can we hop on a quick chat to align on your requirements? ⭐ 5.0/5 from a recent client: "This was wonderful experience and I also got an addtional choice of updating budget and other features which was not available in the old version of my existing software that I used to perform my d…" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.

@Friends4it

Ola, li todo o escopo tecnico — desenvolver, corrigir e estabilizar o sistema de scraping da Mecofarma e AppySaude: coletar produtos, precos, disponibilidade, fornecedor/farmacia, categoria, marca e link; manter o Mecofarma funcional com ajustes preventivos; corrigir o AppySaude (erro provavel por alteracao da API/site); gerar Excel/CSV padronizados para comparacao de precos e sugestao de precos; e criar logs, diagnosticos e mecanismos de contingencia para futuras mudancas. Isto e exatamente o que fazemos na Global IT Vision — scrapers, bypass de anti-bot e pipelines de dados sao trabalho rotineiro para nos. Minha abordagem: - Diagnostico do AppySaude: identificar se a quebra e mudanca de API/estrutura ou bloqueio, e reescrever a coleta de forma resiliente (de preferencia lendo o JSON do backend, nao HTML fragil). - Manutencao preventiva no Mecofarma para evitar quebras futuras. - Saida padronizada em Excel/CSV com todos os campos (produto, preco, disponibilidade, farmacia, categoria, marca, link), pronta para analise de concorrencia. - Logs, alertas e contingencia: quando um site mudar, o sistema avisa em vez de falhar silenciosamente. - Opcional: agendamento (diario/horario) e proxies para estabilidade. Deixei algumas perguntas no quadro para fechar o escopo. Podemos conversar rapidamente? Mostro scrapers que ja entregamos. — Muhammad Idrees / Global IT Vision Pvt. Ltd

@quan9824

As a full-stack developer with a mastery of JavaScript and Python, I am the perfect fit for your web scraping project. My extensive experience in AI systems makes me exceptionally skilled at automating large-scale data extraction tasks, such as collecting products, prices, availability, and more from various sources like Mecofarma and AppySaúde. For the Mecofarma module, I'm well-versed in handling Magento-based sites, ensuring that only relevant product information (validated by CNP/SKU) is scraped without falling into the redirect-error trap. As for AppySaúde's scraper correction, my proficiency with endpoint adaptation work makes me competent at identifying structural changes on sites/APIs and quickly adjusting them. This includes the new API version being used (v2.0) along with pagination via 'pageNumber', data extraction from nested 'offers[]', possible token-bearer authentication through MSAL/acquireTokenSilent or request interception. I always prioritize clear logging and diagnostic mechanisms so that future adjustments for any site alterations will be much easier. Additionally, since clean data outputs are crucial for competitive analysis, as your chosen freelancer I will ensure the generated Excel/CSV files are meticulously structured and cater to your specific needs so you can efficiently perform price comparisons, analyze competition and make informed pricing decisions. Choose me for a smooth project experience combined with excellent results!

@stheven19

As an experienced Data Analyst and Automation Expert, I am quite familiar with the intricate workings of web scraping and data extraction. With 5+ years and over 60 successful projects under my belt, I believe I have the expertise to breathe new life into your Mecofarma web scraper and fix any glitches in the AppySaúde module. My proficiency in Python, JavaScript, and using libraries like Pandas, NumPy will enable me to effectively retrieve data from these websites, while my knowledge in Playwright for task automation will be invaluable for resolving authentication issues and dealing with APIs. Additionally, your focus on generating standardized Excel/CSV files aligns perfectly with my skills as I have extensive knowledge of manipulating data in these formats for analysis and comparison purposes. My ability to analyze complex data is the backbone of superior business intelligence, which is a key attribute you need for this project. Furthermore, I am a proponent of building scalable solutions – a quality you seek in maintaining the existing Mecofarma functional modules while making adjustments as needed for future website changes. Finally, I value thoroughness and customization in my work; from validating products to avoiding duplication/false positives to creating diagnostic folders – all will be integrated into our proposed solution.

@toriquldev123

Prezado Cliente, Olá! Sou Md Toriqul Islam e estou pronto para iniciar imediatamente. Sou desenvolvedor Full-Stack com mais de 10 anos de experiência em Python, automação, web scraping, APIs, processamento de dados e geração de relatórios Excel. Entendi que você precisa corrigir e estabilizar o scraper da AppySaúde, preservar o funcionamento da Mecofarma, implementar autenticação/token quando necessário, criar logs robustos, cache controlado, fallback com Playwright e gerar arquivos Excel/CSV consolidados para análise de concorrência e pricing. Tenho ampla experiência com Python, Pandas, Playwright, Requests, BeautifulSoup, OpenPyXL, APIs REST e sistemas de monitoramento. Estou pronto para realizar o diagnóstico completo da AppySaúde e entregar uma solução escalável, documentada e pronta para produção. Atenciosamente, Md Toriqul Islam

@durgesh8527

As a seasoned Full-Stack Developer specializing in web scraping, I am confident that I am the right person for your project. I have over a decade of experience handling complex web scraping tasks just like yours. My proficiency in Python and JavaScript, alongside my knowledge of libraries like BeautifulSoup and Scrapy, positions me as an efficient problem solver. My commitment to clean code guarantees that your scraping system will be well structured, easy to maintain, and effective in retrieving the sought-after data. In addition to my technical abilities, I value effective communication and understanding client requirements. This aligns with your need for someone who can expand on the current scrapers while preserving the functionalities of the Mecofarma scraper. I am well-versed in preventing scraper breaks by anticipating site changes and implementing proactive solutions. Lastly, my comprehensive range of proficiencies extends beyond web scraping to include creating structured outputs in Excel and CSV formats. Choosing my service would mean not only getting an expert scraper but also access to post-project support. I look forward to discussing further details with you and working together to create a more stable and productive web scraping solution for your business needs.

@ravichedwal

Hi, I have 9+ years of experience in Python development, web scraping, API integrations, and data processing, and I can help stabilize and enhance your existing Mecofarma and AppySaúde scraping system. I understand that the priority is to preserve the working Mecofarma scraper while diagnosing and fixing the AppySaúde integration, including API v2.0 migration, pagination, Azure B2C/MSAL authentication, Playwright token handling, and extracting pharmacy-specific offers accurately. My approach: • Diagnose the current AppySaúde failure and document the root cause. • Repair API/token workflow with Playwright fallback when required. • Maintain Mecofarma functionality and validation logic. • Generate standardized Excel/CSV outputs with detailed logs and cache management. • Build the consolidated pricing dataset for competitor analysis and future pricing automation. I will deliver clean, secure Python code, updated requirements, Windows batch files, documentation, sample outputs, and comprehensive test logs while ensuring no sensitive credentials are exposed. I am available to start immediately and would be happy to discuss your existing codebase. Thanks & Regards, Aminesh

@TheSecondSource

Greeting! This is a technically advanced scraping and pricing intelligence system involving API reverse engineering, authentication handling, and structured data consolidation. We are a team of 62 professionals with over 9 years of experience in Python automation, Playwright scraping, data pipelines, and pricing analytics systems. Here’s how we can help: • Maintain and stabilize the Mecofarma scraper while improving validation and duplicate prevention • Diagnose and fix the AppySaúde scraper by analyzing the new API v2.0 structure • Implement Playwright-based authentication (Azure B2C/MSAL) with secure token handling and caching • Extract multi-offer data correctly, splitting each pharmacy offer into separate structured rows • Build fallback logic (API → browser interception → diagnostic mode with logs and screenshots) • Generate structured Excel/CSV outputs (Raw, Available, Errors, Summary) for both sources • Create consolidated pricing comparison files across Mecofarma, AppySaúde, and internal inventory • Implement configurable pricing rules via parameters sheet (margins, alerts, pricing strategy) • Add robust logging, caching control, and Windows-ready execution scripts (.bat) We will first restore stable data extraction for AppySaúde, then build the consolidation and pricing intelligence layer so the system becomes reliable, scalable, and decision-ready.

@marjanahmed13

Hi! My name is Marjan and I'm here to offer you my services as a skilled applicant with over a decade of experience working on Freelancer.com. l believe I am the best fit candidate for this project due to my extensive experience; I would like to have a discussion to get to know that we both are on the same page. Once the scope will be locked, I will start working on it right away.

@reservestep

Hi there, I have strong experience with Python, web scraping, API integrations, Playwright automation, data processing, and Excel reporting. Your project is well-defined, and I can help stabilize both Mecofarma and AppySaúde while maintaining a clean, maintainable architecture. My approach would be: • First perform a full diagnostic of AppySaúde to identify the exact cause of failure, validate the current API endpoints, authentication flow, token requirements, pagination structure, and offer extraction logic. • Preserve the existing Mecofarma scraper while implementing preventive improvements, logging, validation checks, and error handling. • Rebuild and stabilize the AppySaúde integration using the current API structure, including Playwright-based authentication and token management if required. • Implement robust logging, cache management, retry mechanisms, screenshots, and diagnostic reporting. Relevant expertise: ✔ Python 3.x, Pandas, OpenPyXL, Requests, BeautifulSoup, Playwright ✔ API reverse engineering and authentication workflows ✔ Large-scale data extraction and normalization ✔ Excel automation and reporting systems ✔ Windows-compatible automation tools I can start with the AppySaúde diagnostic immediately and provide a detailed technical report before implementing the fixes, ensuring transparency throughout the project. Looking forward to discussing the current codebase and moving this project into a stable production-ready state. Best regards, Raman

@Champactro

Hola He revisado el alcance de Mecofarma y AppySaúde. Tengo amplia experiencia en bypass de autenticación (Azure B2C), APIs dinámicas y procesamiento de datos financieros con Pandas. Mi propuesta 1. AppySaúde: Usaré Playwright para extraer el token Bearer (Azure B2C/MSAL) de forma automática con caché local de sesión. Consumiré la API v2.0 paginada y desglosaré cada farmacia del array offers[] en filas individuales. 2. Mecofarma: Mantendré el scraper AJAX y aplicaré validación de CNP/SKU para evitar falsos positivos. 3. Consolidación y Pricing: Pipeline en Pandas para cruzar bases de datos y generar reportes Excel multi-pestaña ( Raw , Disponíveis , Resumo ) con reglas dinámicas de precios (márgenes 25%/38%). 4. Entregables: CLI programable, scripts .bat de Windows, manuales y el reporte de diagnóstico inicial con JSON de AppySaúde. Listo para iniciar hoy mismo con el diagnóstico obligatorio de AppySaúde. Atentamente, Walid CHABCHI

@taimoorkhan311

Hello, I have 4 years of experience in Web Scraping, Software Architecture, and Data Extraction. I have expertise in Python, JavaScript, Web Scraping, BeautifulSoup, API Integration, and Excel. I understand your requirement for developing, correcting, and stabilizing a scraping system for products and prices from Mecofarma and AppySaúde websites. I will focus on collecting product details, maintaining the Mecofarma scraper, correcting the AppySaúde scraper, generating standardized Excel/CSV files for price comparison, and creating logs for future website changes. I have carefully read through the project requirements and believe I can deliver a professional solution. Let's discuss further details in the chat. I am open to discussing the budget and timeline. Looking forward to connecting in chat for further discussion. Best regards, Taimoor from Pixels Soft

@engruhulajom

Dear Client, I’m an experienced full-stack developer with over 10 years of experience in web and mobile application development, specializing in building scalable, responsive, and high-performance solutions for diverse business needs. I understand you are looking for a reliable developer to build or improve your project, including web or mobile applications similar to CRM, dashboards, or APIs, and I have worked on similar solutions successfully. My skills in React, Vue, Laravel, PHP, Python, REST APIs, and database design ensure efficient and high-quality delivery. Feel free to share more details or ask questions. I’m ready to refine my approach to match your exact requirements. Looking forward to working with you. Best regards, Md Ruhul Ajom

@juanpablomacf

Puedo corregir y evolucionar tu sistema de scraping para Mecofarma y AppySaúde, garantizando estabilidade, logs claros y arquivos Excel padronizados para análise de concorrência e pricing. No módulo Mecofarma, mantenho toda a lógica atual, validando CNP/SKU, evitando falsos positivos e preservando abas Raw, Disponíveis, Indisponíveis e Erros. No módulo AppySaúde, realizo diagnóstico completo da API v2.0, confirmo endpoint, paginação, estrutura de ofertas e requisitos de autenticação via Azure B2C/MSAL. Implemento coleta estável via API ou fallback com Playwright, extraindo cada oferta por farmácia em linhas separadas, ignorando preços inválidos e registrando status, erros e método de extração. Entrego arquivos Excel/CSV com abas Raw, Disponíveis, Indisponíveis, Erros e Resumo, além do consolidado de concorrência. Também implemento cache controlado, logs detalhados, scripts .bat, documentação curta e relatório técnico da correção. Na fase seguinte, posso integrar inventário, aplicar regras de pricing e gerar alertas automáticos. Estou pronto para iniciar imediatamente.

@FizzaNadeemK

Hi, The real challenge here is not just fixing two scrapers but stabilizing a resilient pricing intelligence pipeline that survives API changes, authentication layers (like MSAL), and inconsistent marketplace data structures without breaking your downstream pricing logic. You clearly need two different layers handled separately: Mecofarma as a stable validated AJAX-based extractor with strict SKU/CNP matching, and AppySaúde as a dynamic, authenticated API v2 system that requires Playwright-based token interception plus proper normalization of nested `offers[]` into a flat pricing model. I will first diagnose and restore AppySaúde by validating the live API flow, extracting the MSAL token if required, mapping the new schema, and building a robust Playwright fallback with structured logging, then stabilize Mecofarma with defensive parsing and validation safeguards. After both pipelines are stable, I will standardize outputs, build the consolidated pricing engine, and ensure Excel/CSV exports support your margin rules, alerts, and cross-source price comparison logic without manual intervention. Before starting, do you already have a working login session for AppySaúde available, or should the Playwright authentication flow be built fully from scratch? Best Regards, Fizza Nadeem K

@Algokage

Hello, Posso entregar de forma eficiente o scraper de produtos farmacêuticos conforme suas especificações. Vou corrigir e estabilizar os módulos Mecofarma e AppySaúde, garantindo coleta precisa de dados como preços, disponibilidade e categorias. Implementarei autenticação via Azure B2C/MSAL para a AppySaúde e gerarei arquivos Excel/CSV padronizados para análise de preços. Com mais de 5 anos de experiência em Python e scraping, garanto logs detalhados, mecanismos de contingência e integração com bases de comparação de preços. Envie uma mensagem para discutirmos mais detalhes ou ver amostras de projetos similares. Thanks, Adegoke. M

@alizashaikh8778

With experience in API integration and a knack for solving complex problems, I am confident that I am the perfect fit for your project. My technical skills span across HTML, CSS, JavaScript, PHP, React, Flutter, and Laravel - all of which are essential for building and fixing the web scraping tools you require. Additionally, my proficiency in using Figma and Adobe XD goes hand-in-hand with creating clear, intuitive UI/UX designs for your output files. My portfolio boasts several successful web scraping projects that required addressing changing endpoints, authentication, and handling dynamic structures similar to what you need for the Mecofarma and AppySaúde scrapers. For instance, while working on a recent project for a clothes retailer's website, I had to adapt a scraper every time an API was updated or changed location. I achieved this by meticulously examining the new API structure, possible parameters, required authentication steps -- just like what I'll do to fix AppySaúde scraper challenges.