Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
Post your project for free and start receiving proposals from freelancers within minutes after publication!

Order parser + synchronization in MySQL (Python/Docker)

Translated425 USD

Applications 2

Application viewing is only available registered users.

Client's review of cooperation with Vitalii Murovany

Quality
Professionalism
Cost
Contactability
Deadlines

Thank you for completing the work ahead of schedule. All revisions were made without reservations, and further collaboration is planned.

Freelancer's review of cooperation with Tigran Kocharov

Payment
Task setting
Clarity of requirements
Contactability

Wonderful client! The technical task was maximally clear and understandable, which allowed for effective completion of the work. Communication was pleasant and constructive. Everything went at the highest level, and I will gladly continue the collaboration. I recommend!

  1. 596
     2  0
    Work example:
    Rental Car
    1 day223 USD

    ✋ Hello! We are the IT company dZENcode.

    We are implementing a service in Python (FastAPI) with Playwright for monitoring SPA orders, MySQL/SQLAlchemy, multi-accounting, upsert by order_id, endpoints /sync, /status, /health, and Docker, based on the team's experience, best practices, and our own developments.

    Can you confirm the target website and access to the test account?
    Is there a captcha or anti-bot on the login?

    You can find detailed information about our services and rates on our website: Freelancehunt
    Take a look – we will discuss the details of the work further, write when you are ready.

    The final cost is determined only after clarifying the volume and requirements.

    ___________________
    Best regards,
    Manager of dZENcode

    Our strengths:
    💎 10+ years providing IT services: Outsourcing, Outstaffing
    🔥 90+ in-house specialists
    🚀 Projects "from scratch" and for support
    ⚙️ SLA and post-production support
    ✅ Contract with the company, guaranteed results!
    🔥 250+ public reviews since 2015.

  2. 14508
     24  0

    14 days601 USD

    Hello! I can take on the development of a service that will log into the restaurant system's admin panel, track new orders, and synchronize them in MySQL in real-time.

    What I will do in terms of functionality:

    - Auto-login at startup and automatic re-authorization if the session is "kicked out" (we will see a redirect to the login page and log in again). Login/password only through env or config.
    - Upon startup, I will perform a full synchronization of the history (today, yesterday, 7 days, 30 days), followed by constant monitoring of the Bestellungen page. New orders are immediately saved in the database.
    - No duplicates: upsert by order_id, so that reprocessing updates the data instead of creating copies.
    - Parsing both the list and the detailed order page: client, address, phone, comment, amount, payment (Bar/Online), source, type (delivery/pickup), status, items, extras, VAT by items, totals with breakdown.
    - API for management: GET /sync, GET /status, GET /health.
    - Support for multiple accounts (different restaurants) on one site: a separate worker for each restaurant, all data with restaurant_id. Adding a new account through config (if possible, I will implement hot-swapping without a full restart).
    - Docker + docker-compose (MySQL in compose or connection to an external database), auto-restart, logs in stdout and to a file.
    Deadline: 2 weeks.
    Budget: 90,000 UAH fixed (or 3,500 UAH/hour, if hourly is more convenient).

    To get started, I need access to the test account and a few screenshots/clarifications on where exactly the history switches (7/30 days) and whether there is pagination in the order list.

  3. 13756
     30  0

    14 days601 USD

    Hello! Your project brief for the development of a restaurant order monitoring system is very specific and technically sound. I specialize in automating data collection and developing robust backend systems in Python/Docker (over 30 successful projects, including intensive parsing of SPAs and synchronization logic). I understand the criticality of a stable session for the restaurant business: orders should not be lost due to logouts or dynamic page updates.
    🛠 My vision for technical implementation:
    1. Parsing and Automation (Playwright):
    * I will use Playwright (Python) in headless mode. It is faster than Selenium and works better with asynchronous loading (SPA).
    * I will implement Request Interception logic: instead of just "scraping" the DOM tree, the script will intercept JSON responses from the site's internal API. This guarantees 100% data accuracy (prices, VAT, extras) without layout errors.
    2. Multi-accounting and Parallelism:
    * I will use asyncio in combination with a task manager. Each restaurant is a separate independent object (Worker) that has its own browser context (cookies/session).
    * Adding accounts without restarting: I will implement this through periodic polling of the restaurants table in the database or monitoring a config file.
    3. Reliability and Consistency (MySQL):
    * I will use SQLAlchemy (Async Engine) to work with the database.
    * Upsert logic (ON DUPLICATE KEY UPDATE): the system will identify orders by order_number + restaurant_id, updating the status (for example, "canceled"), but not creating duplicates.
    4. API and Monitoring (FastAPI):
    * A lightweight interface on FastAPI for managing processes.
    * The /sync endpoint will trigger a background task to avoid blocking the API response.
    📋 Development and delivery plan:
    * Database architecture and Docker environment: Setting up containers (App + MySQL + Redis for queues, if needed).
    * Authorization module: Stable login, handling redirects, and session persistence.
    * Core parser: Logic for collecting the list of orders and details (Items/Extras/VAT).
    * Synchronizer: Scaling to multiple restaurants and implementing the API.
    * Testing: Checking "survivability" during internet or session failures.
    ⏱ Deadlines and cost:
    * Execution time: 10–14 working days.
    * Cost: $1,200 – $1,800 (depending on the complexity of the site structure and the number of nested pages for parsing extras).
    Why me:
    I have experience working with systems that require maintaining a session 24/7. My code will include Smart Retries and a logging system that will allow you to see the reason for the error (for example, change).

  4. 3481    49  2
    14 days445 USD

    Hello! I am ready to implement a microservice for order synchronization. The requirements for the stack (FastAPI + Playwright + SQLAlchemy + Docker) fully match my profile.

    How I will ensure stability (according to your specifications):

    1. Authorization: The script will save the storage_state (cookies/tokens) locally. Upon receiving a 401/403 error or redirect to login, the worker will automatically restart the authorization flow without crashing the entire service.
    2. Multiprocessing: To handle multiple restaurants, I will use asyncio.gather with semaphores to avoid overloading the server with spawning browser tabs.
    3. Data: The database structure (Orders, Items, Extras) will be implemented strictly according to the specifications. VAT and amount data will be validated before writing to MySQL.

    The project will be wrapped in Docker, with automatic restart and logging (through the logging module to stdout for docker logs). I would be happy to explore test access.

  5. 3718    193  12   7
    5 days196 USD

    Good day. The project brief looks quite interesting. I have done similar work before (I can tell/show more privately). If we can switch Python to PHP in the stack, I am ready to get started today. Write to me, we will discuss, it will be interesting to implement!

  6. 667    5  0
    5 days78 USD

    Hello! I am interested in your project. I have extensive experience in:

    📊 Data processing: working with databases, structuring and analyzing information, automating the processing of large volumes of data, import/export and validation;
    🤖 Automation and emulation of user actions, development of bots of varying complexity;
    ⚡️ Asynchronous and multithreaded parsing: collecting and processing data with performance optimization;
    🔍 OCR and text search: recognition and structuring of information;
    🖼 Media processing: working with images and multimedia;
    🖥 Software development, desktop applications, system services and utilities;
    📱 Mobile development: native and cross-platform applications;
    🌐 Working with APIs and third-party services: integration, automation, and data exchange;
    🗣 Translation and text processing: automation of translation, working with language models and text analytics;
    🤖 AI/LLM solutions: integration and use of artificial intelligence, working with language models and automating intelligent processes.

    I will complete the work quickly and efficiently. Contact me to discuss the details and deadlines of the project!

  7. 1177    16  3
    7 days178 USD

    Good day
    I am ready to take on your parser
    I have experience, you can take a look at my projects
    Message me privately, we will discuss the details
    I will be happy to collaborate)

  8. 5235    29  1   1
    7 days334 USD

    Hello, my name is Alexander, in the past a Python developer, now a smart contract and web3 projects developer. I have extensive experience, and I am technically skilled enough to easily, quickly, and qualitatively complete your task.

    My main advantage is that I have my own offline business with a POS service (poster+checkbox) and acquiring. I have experience in automating certain processes and reporting for my purposes. The task and goals are absolutely clear, and I can start discussing/executing them today.

  9. 3880    15  0
    27 days601 USD

    Hello.
    For the last three years, I have worked on a project with a hypermarket and restaurant delivery.
    I am a senior backend developer with ten years of experience:
    - Python, MySQL (extensive experience), Docker (I know how to configure it), Git
    - I have successfully used Playwright for various types of service parsers with protection
    - I know how to implement multi-accounts, how to properly match them with a proxy system, and create proxy contexts.
    - I understand how to properly synchronize data, not just copy/paste, but from the perspective of their architecture and the nuances of business logic.
    - I have successfully applied both long polling and WebSockets as well as event-driven architecture approaches in projects.

    I work with an hourly rate of $25-35.

    Regarding the estimate:
    The project description is not a complete technical specification.
    From it, one can only provide a rough estimate - 80-140 hours.

    The range depends on:
    - how "crooked" the site is (SPA, anti-bot, WebSocket, etc.)
    - the stability of the DOM
    - the number of edge cases (cancellations, partial orders, etc.)

    A precise estimate will be provided after creating a complete technical specification.
    Thank you for your attention!

  10. 390  
    14 days267 USD

    Good day! 👋

    I have strong experience in Python (parsing, automation, working with dynamic websites) and developing services with data synchronization and Docker infrastructure.

    Experience in similar tasks

    I have worked on:

    — parsing SPA websites using Playwright / Selenium
    — authorization through sessions, cookies, bypassing redirects
    — real-time data monitoring (polling / event-based)
    — synchronization in MySQL (upsert, deduplication)
    — multi-account parsers
    — API development (FastAPI)
    — Docker / docker-compose (production-ready services)

    How your project will be implemented

    Architecture

    — Python (Playwright for stable operation with SPA)
    — MySQL + SQLAlchemy
    — FastAPI for service endpoints
    — Docker + docker-compose
    — separate workers for each account

    Logic of operation

    — auto-login + reauthorization upon session loss
    — initial synchronization (history: 1/7/30 days)
    — constant monitoring of new orders
    — upsert by order_id (without duplicates)

    Parsing

    — list of orders + details
    — positions, extras, VAT, source, statuses
    — normalization and recording in the database

    API

    — /sync — full synchronization
    — /status — service status
    — /health — health check for Docker

    Scaling

    — multi-accounting through configuration
    — ability to add accounts without stopping the service
    — logging + stable error handling

    Result

    — stable service that operates 24/7
    — correct synchronization without duplicates
    — readiness for scaling to new restaurants
    — clear deployment through Docker

    I can quickly connect, assess the website, and propose an optimal implementation for your case 👍

  11. 218    1  0
    7 days200 USD

    Hello!
    I am interested in your project! Process automation systems are my professional focus. Your technical specifications are very clear, and I can start working on them. I will implement everything as per the requirements. I will try to use playwright/selenium minimally for greater stability (I have a lot of experience in solving such tasks). If it doesn't work out, then raising a headless browser will also not be a problem.
    I am ready to start working, waiting for you in private messages.

  12. 3140    52  1
    1 day22 USD

    Hello
    Write
    I am ready to discuss the details
    I will be happy to help with your task

  13. 417    2  0
    5 days334 USD

    Hello

    Git-hub
    https://github.com/ambarexpressmarket-lab/demo-repo

    Portfolio
    Google Drive

  14. 96304    1273  1   10
    7 days601 USD

    Hello. I am developing parsers in Node.js/Python. I am ready for collaboration.

  15. 612    21  0
    30 days445 USD

    Hello. I can do your project. I have experience. Write to me, and we will agree.

  16. 1993    12  0
    10 days557 USD

    Good day
    I have extensive experience in developing such systems
    Write to me

  17. 726    9  1
    3 days45 USD

    Hello! I have carefully studied your project and am ready to start its implementation. Let's discuss the details for the best execution.

  18. 3631    17  0
    14 days334 USD

    Hello! 🤖🍽️

    I have experience in developing Python services for parsing SPA/dynamic dashboards, authorization via session/cookies, data synchronization in MySQL, building Dockerized solutions, and APIs for manual management. For your task, I can implement a stable service with auto-login, re-authorization, full sync + realtime polling, upsert without duplicates, multi-account support, logging, and health/status endpoints. I will also set up the database structure, separate workers for restaurants, and provide a ready README for launching and adding new accounts.

    Technology stack used:

    Backend: Python, FastAPI, SQLAlchemy, MySQL

    Integrations: Playwright / Selenium, session/cookie auth, polling/retry, logging, sync API

    Infrastructure: Docker, docker-compose, multiprocessing / asyncio, stdout + file logs

    I am ready to discuss the project details in private and am prepared to start working.

    Best regards, Andriy

  19. 2318    8  0
    1 day27 USD

    Hello

    I am ready to implement an order parsing service with synchronization in MySQL.

    I have experience working with SPA (Playwright), authorization through sessions/cookies, and building stable parsers with Docker. I will implement: auto-login and re-authorization, order monitoring (polling/event), complete initial synchronization + upsert without duplicates, detailed parsing of orders/items/VAT. I will create an API (/sync, /status, /health), multi-account support (workers), logging, and auto-restart.

    Stack: Python, Playwright, FastAPI, MySQL, Docker.

    I am ready to discuss the details and start after gaining access to the test account.

  20. 136  
    10 days601 USD

    Contact us and we will discuss all the details and conditions that interest you.

  21. 615    3  0
    7 days267 USD

    Hello.

    I propose the implementation of a separate sync service for this order system with a division into two layers: a browser-worker for authorization and navigation, and a sync-layer for saving changes in MySQL. This format provides stable re-authorization, a separate context for each restaurant, and proper control over repeated passes through the history.

    From the screenshots, it is already clear that data will be collected in two stages: first, the list of orders, then a separate pass through the detail view with items, extras, and VAT. If internal XHR/JSON requests are available after login, it is advisable to use them as the main source of synchronization, leaving the DOM as a backup scenario. This simplifies service maintenance when interface changes occur.

    I propose the following work plan:
    1. Technical analysis of the test account and checking network requests after login
    2. Building the worker with authorization, session control, and auto re-authorization
    3. Initial synchronization of history and idempotent upsert in MySQL
    4. Separate analysis of the detailed order page with items, extras, VAT, and statuses
    5. API for manual sync, status, and health
    6. Launch in Docker, logging, and configuration for multiple accounts

    Before starting work, I need to clarify:
    - Is it critical to add a new restaurant without a restart in the first version?
    - What is the expected update frequency?
    - Should we track the status change of already synchronized orders?
    - How many accounts are planned at the start?

    I am ready to begin with the technical analysis of the account and move on to the first working layer of synchronization.

  22. 265  
    1 day22 USD

    Hello.

    I have extensive experience in developing similar services in Python, including browser automation through Playwright/Selenium, parsing dynamic interfaces, data synchronization in MySQL, working with Docker, and building APIs with FastAPI. I can implement authorization with re-authorization, full and incremental synchronization of orders without duplicates, support for multiple accounts, separate workers for each restaurant, and containerized launch through docker-compose.

    I also have experience working with services where data needs to be reliably retrieved from SPA interfaces and carefully organized into a normalized database structure considering positions, add-ons, statuses, and change history. I suggest moving to private messages.

  23. 172    1  1
    1 day89 USD

    Good day. I am ready to complete this project as I have extensive experience in application development.

  24. 986    12  1
    5 days111 USD

    I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!

  25. 3355    11  0
    6 days312 USD

    Hello!

    We consider your project a priority. We work in tandem: I (Nina) am responsible for management and communication, while the technical part is fully handled by a Backend specialist with extensive experience in automation.

    We have thoroughly studied the technical specifications and the provided screenshots of the system (Orders, VAT, specifics of menu nesting). We understand that behind the external simplicity lies serious logic, which we are ready to implement "turnkey."

    Why our solution will work reliably:

    Working with sessions (Playwright): This is fundamental. We will set up the saving and auto-refreshing of auth_state (cookies/tokens) to avoid constant logins and bans. The bot will automatically restore the session when redirected to the login page.

    Complex parsing (VAT and modifiers): We have taken into account the nesting of data (as in the example with Burger Menu + Extras). The entire composition of the order, including different VAT rates (7/19%) and sources (Lieferando, Uber Eats), will be correctly organized into MySQL tables.

    Synchronization via Upsert: We will use SQLAlchemy to implement the "insert or update" logic. This guarantees the absence of duplicates and the relevance of statuses (for example, the transition of an order to Canceled).

    Multi-accounting and Docker: The service will be designed on isolated asynchronous workers. Each restaurant is a separate process. Adding new locations will be done through the .env file without stopping the system.

    Control and Healthcheck: We will implement FastAPI endpoints /sync, /status, and /health so that you can check uptime and synchronization statistics at any time.

    We deliver clean, documented code in Docker containers. We are ready to discuss the details of access to the test account today and start working.

  26. 1495    13  0
    1 day56 USD

    Hello! I can implement it, please write to me privately to discuss all the details of the project. I will be happy to collaborate with you!

  27. 1251    35  1   3
    2 days49 USD

    Hello, I will do it according to the technical specifications. Write to me privately, I will be glad to cooperate.

  28. 727    6  0
    1 day16 USD

    Greetings, assessment after familiarization with the system that needs to be worked on, please reach out.

  29. Nick Osipov Web4Business
    4975    41  4   1
    3 days22 USD

    Good day!
    I professionally develop parsers and API services in Python. I am ready to implement the required order parsing service with MySQL synchronization, using Playwright, FastAPI, and Docker.

    Write to me in private messages, and we will clarify the details. I have extensive experience working with SPA websites, APIs, Docker, and multi-account solutions.

  30. 976    4  0
    3 days134 USD

    Good night!
    My name is Dmytro, from King Kong Lab. We can implement a stable order parsing service with full synchronization in MySQL for you.
    We have experience in developing similar systems: parsing SPA/dynamic websites using Playwright, working with sessions, automating authorization, data synchronization, and building services with API and Docker.
    What we will implement:
    - authorization with auto-reauthorization upon session loss
    - real-time order monitoring (polling or event-based)
    - complete initial synchronization (history) + upsert without duplicates
    - detailed parsing of orders and items (including extras and VAT)
    - support for multi-accounts (separate workers, restaurant_id)
    - API (sync, status, health)
    - fully containerized solution via docker-compose
    - logging and auto-retries
    On the stack:
    - Python (Playwright)
    - FastAPI
    - MySQL
    - Docker / docker-compose
    We will make the architecture stable and scalable so that the service operates without failures even with a large number of orders.
    We are ready to discuss the details, gain access to the test account, and start implementation.

  31. 1122    7  0
    7 days445 USD

    Good day, I have experience in implementing similar services, write for more detailed discussion.

  32. 747    2  0
    2 days45 USD

    Hello. The task is clear, I can implement such a service.

    What I see for the solution:
    — authorization and automatic re-authorization through Playwright
    — monitoring the Bestellungen section with full initial synchronization of history (today / yesterday / 7 days / 30 days)
    — parsing the list of orders and detailed pages
    — saving in MySQL with upsert, without duplicates
    — API for /sync, /status, /health
    — support for multi-accounting linked to restaurant_id
    — packaging in Docker / docker-compose
    — configuration through env, logging, auto-restart

    For the stack, I prefer Python + Playwright + FastAPI + SQLAlchemy + MySQL.

    For an accurate estimate, I need to clarify:

    is there test access
    is this a SPA without a proper backend API, or can we partially work through network requests
    how many accounts/restaurants are planned to be active simultaneously
    is near real-time mode needed, for example polling every 5–10 seconds
    should we track changes to existing orders, such as status changes

    After clarifications, I will be able to provide timelines and costs.
    If convenient, you can send a test account or a short video/screenshots of navigation through the orders!)

  33. 1562    7  0
    1 day22 USD

    I am among the top 10 developers in the category of "Artificial Intelligence and Machine Learning" among ~2100 specialists on the platform.
    I guarantee:
    - Fast and high-quality task execution
    - Strict adherence to deadlines
    - Regular communication throughout the entire process

  34. Another 13 proposals concealed

Current freelance projects in the category Databases & SQL

Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning

22 USD

Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always…

C#Databases & SQL ∙ 1 day 10 hours back ∙ 5 proposals

Heal the 1C configuration

111 USD

Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year.

Databases & SQL ∙ 2 days 2 hours back ∙ 8 proposals

Need a 1C specialist for refinements and development.

I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and…

Databases & SQL ∙ 7 days 1 hour back ∙ 12 proposals

Restoring Instagram after a ban

On March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files…

Databases & SQLWeb Programming ∙ 7 days 12 hours back ∙ 6 proposals

Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:

45 USD

Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into…

System & Network AdministrationDatabases & SQL ∙ 10 days 19 hours back ∙ 16 proposals

Client
Tigran Kocharov
Ukraine Dnepr  16  0
Project published
3 months 2 days back
450 views
Tags
  • sqlalchemy
  • MySQL
  • python
  • fastapi
  • docker
  • flask