Order parser + synchronization in MySQL (Python/Docker)
Order Parser + Synchronization in MySQL (Python/Docker)
Task Description:
A programmer is needed to develop a service that monitors the web interface of a restaurant order management system in real-time and synchronizes all orders into a MySQL database.
Technical Requirements
1. Authorization and Session
- Automatic authorization on startup
- Automatic re-authorization when logged out (detection of redirect to login page)
- Storing credentials in config / env variables
2. Order Monitoring (Bestellungen section)
- Periodic polling or event-driven monitoring of the orders page
- Immediate saving to the database upon the appearance of a new order
- On service startup — full synchronization of all available orders (history: today, yesterday, 7 days, 30 days)
- Reprocessing of orders should not create duplicates (upsert by order_id)
3. Data Parsing
Order List:
- Order Number
- Date and Time
- Customer Name
- Delivery Address
- Phone Number
- Comment
- Order Amount
- Payment Method (Bar / Online)
- Order Source (Lieferando, Uber Eats, direct order, etc.)
- Order Type (delivery / pickup)
- Status (active / canceled)
Inside each order (detailed page):
- Items: dish name, quantity, price
- Add-ons/extras for each item: name, price
- VAT % for each item
- Total amount with VAT breakdown
4. API for Manual Management
GET /sync— initiate full re-synchronization, return JSON with results (how many orders processed, how many new, how many updated, errors)GET /status— service status, last processed order, uptimeGET /health— healthcheck for Docker
5. Multi-account Support
- Support for multiple accounts (restaurants) on the same site
- Each account — separate process/worker
- Adding a new account through config without restarting the entire service (preferably)
- All data tagged with
restaurant_id
6. Docker
- Fully containerized solution (
docker-compose) - MySQL also in compose (or connection to external DB via env)
- Automatic restart on crash (
restart: always) - Logging to stdout + file
Database Structure (minimum, can be extended)
restaurants — id, name, address, login, password, site_url, active orders — id, restaurant_id, order_number, order_date, customer_name, address, phone, comment, total_price, payment_method, order_source, order_type, status, synced_at order_items — id, order_id, product_name, quantity, price, tax_percent order_item_extras — id, order_item_id, extra_name, priceStack (preferred, negotiable)
- Python (Playwright or Selenium for authorization and parsing)
- MySQL + SQLAlchemy or direct queries
- FastAPI or Flask for API endpoints
- Docker + docker-compose
- Multiprocessing or asyncio for multi-account support
What Needs to be Submitted
- Source code on GitHub (private repo)
docker-compose.yml+.env.example- README with instructions for launching and adding accounts
- Brief documentation for the API
Important
- The site uses session/cookie authorization — browser automation (Playwright/Selenium) is likely mandatory
- Experience with parsing SPAs or dynamic sites is required
- Willingness to clarify details through screenshots and access to a test account
Applications 2
Client's review of cooperation with Vitalii Murovany
Order parser + synchronization in MySQL (Python/Docker)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
Order parser + synchronization in MySQL (Python/Docker)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!
-
✋ 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.
-
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.
-
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).
-
3481 49 2 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.
-
3718 193 12 7 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!
-
667 5 0 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!
-
1177 16 3 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)
-
5235 29 1 1 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.
-
3880 15 0 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!
-
390 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 👍
-
218 1 0 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.
-
3140 52 1 Hello
Write
I am ready to discuss the details
I will be happy to help with your task
-
417 2 0 Hello
Git-hub
https://github.com/ambarexpressmarket-lab/demo-repo
Portfolio
Google Drive
-
96304 1273 1 10 Hello. I am developing parsers in Node.js/Python. I am ready for collaboration.
-
612 21 0 Hello. I can do your project. I have experience. Write to me, and we will agree.
-
1993 12 0 Good day
I have extensive experience in developing such systems
Write to me
-
726 9 1 Hello! I have carefully studied your project and am ready to start its implementation. Let's discuss the details for the best execution.
-
3631 17 0 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
-
2318 8 0 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.
-
136 Contact us and we will discuss all the details and conditions that interest you.
-
615 3 0 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.
-
265 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.
-
172 1 1 Good day. I am ready to complete this project as I have extensive experience in application development.
-
986 12 1 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!
-
3355 11 0 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.
-
1495 13 0 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!
-
1251 35 1 3 Hello, I will do it according to the technical specifications. Write to me privately, I will be glad to cooperate.
-
727 6 0 Greetings, assessment after familiarization with the system that needs to be worked on, please reach out.
-
4975 41 4 1 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.
-
976 4 0 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.
-
1122 7 0 Good day, I have experience in implementing similar services, write for more detailed discussion.
-
747 2 0 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!)
-
1562 7 0 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
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 8 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 ∙ 1 day 23 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 ∙ 6 days 22 hours back ∙ 12 proposals |
Restoring Instagram after a banOn 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 & SQL, Web Programming ∙ 7 days 10 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 Administration, Databases & SQL ∙ 10 days 17 hours back ∙ 16 proposals |