1. Who We Are We are a travel agency and tour operator. For each hotel request from our clients, we currently have to log into multiple B2B booking portals and supplier websites, search manually, and compare prices and conditions. This process takes 20–25 minutes for each quote, because we repeat the same search on many different platforms. 2. Goal of the Project I want to create an internal web tool (for our team only, not for the public) that: Lets us enter search criteria only once on our website (destination, dates, number of people, etc.). Automatically searches the same hotel / same destination across multiple B2B suppliers / booking channels that we already use. Shows on one page all the available rates from each supplier, side by side, with: price room type board basis (BB, HB, AI, etc.) refundable vs non-refundable supplier name Very important: We do not want to make the booking via this tool. We only want to extract and display the data. After that, we will manually go to the supplier’s website and complete the booking there. 3. High-Level Functionality 3.1 Search Form (on our site) A search form on our internal site with fields like: Destination (city / area / hotel name) Check-in date Check-out date Number of adults Number of children (with ages, if needed) Number of rooms Optional filters: Board basis (BB, HB, FB, AI, etc.) Refundable / non-refundable Room type (if possible) After clicking “Search”, the system should: Send the request to all configured suppliers / booking channels (via API or other method). Receive the responses. Display a unified result list on our website. 4. Results Page The results page should show, for each hotel / room combination: Hotel name Destination / city Room type Board basis Refundable / non-refundable Cancellation policy short text (if available) Total price for the entire stay Currency Supplier name (very important – we must clearly see which supplier is offering that rate) Extra options (nice to have, not mandatory but useful): Highlight the cheapest rate per hotel (e.g., “Best price” badge). Allow sorting and filtering by: Price (low to high / high to low) Supplier Board basis Refundable / non-refundable Again, no booking function is needed. Only display and comparison. 5. Integration & Technical Context Our existing back-office is in PHP/MySQL (if you prefer a different stack, please suggest, but we preferably want it to integrate with our current system). The tool should be accessible only to our staff (e.g., under a secure /admin area or password protected). We already use several B2B hotel suppliers / booking portals. Some of them may provide: official APIs (XML/SOAP/REST), others only web interfaces (in this case we need your advice on what is realistically possible). We need a developer who can: Integrate with multiple suppliers (I will provide the list of suppliers and, where possible, API documentation and test credentials). Design the system so that it is modular (it should be easy to add/remove new suppliers in the future). 6. Important Technical Points Speed: The search should be reasonably fast, considering we might query several suppliers at the same time. Error handling: If one supplier is down or returns an error, the system must: not crash, still show data from the other suppliers, maybe show a warning like “Supplier X not available”. Logging: Log search requests and responses (for debugging and control). Hotel matching: Hotel names can differ slightly between suppliers. We’re open to: matching by hotel codes if available, or simple text/fuzzy matching (you can suggest an approach). Caching (nice to have): If the same search is repeated in a short period, it would be good to reuse results to improve speed (for example, cache for a few minutes). 7. Admin / Configuration We need some kind of simple configuration area or config files where we can: Add/edit suppliers: API credentials (ID, username, password, etc.) API endpoints or login URLs Enable/disable specific suppliers from searches Set default options if needed This doesn’t need to be a very complex UI, but it must be clear and maintainable. 8. Security The tool is for internal use only (not public). Access must be protected (login or restricted area on our existing back-office). API credentials and supplier logins must be stored safely (not in plain text in public files). 9. What I Will Provide List of suppliers / booking portals that we use. Where available: API documentation for each supplier (XML, SOAP, REST, etc.). Test accounts or demo credentials. Access details for our hosting / development environment (if needed). Guidance on how we want the UI to look (basic design; we don’t need something super fancy, just clean and functional). 10. Deliverables Fully working web application integrated into our site (or as a standalone tool that we can link from our back-office). Source code (PHP/MySQL or other proposed stack) with clear structure. Database schema (if additional tables are required). Basic technical documentation: how to install / deploy, how to configure suppliers, how to add a new supplier connector in the future. Short user guide for our staff (how to use the search page, how to read results). 11. Required Skills Strong experience with: Web development (PHP/MySQL or similar), APIs integration (REST, SOAP, XML), Experience with travel / hotel B2B APIs is a big plus. Ability to work with multiple external systems and unify data. Good communication in English. 12. Next Steps When you apply, please: Show examples of similar projects (API integrations, price comparison tools, travel-related systems, etc.). Briefly describe how you would architect the system (at a high level). Give me an estimated timeline and cost for: MVP with a small number of suppliers (e.g. 2–3 suppliers), and then adding more suppliers later.