Scrape LuxuryGold Tour Data

I need a reliable script that automatically pulls complete tour and pricing details from https://www.luxurygold.com/en-au and pushes the results straight into MySQL database tables I can query.

The data set must cover the full catalogue on the site and include, for every tour: the day-by-day itinerary text, available dates, all stated inclusions or exclusions, and the advertised price and details in Australian dollars for each departure date.

You are free to use Python with BeautifulSoup, Scrapy (preferred), Selenium or another stack you trust, as long as the final result is a repeatable, well-commented script plus clear connection settings so I can run it myself on a schedule.

Deliverables
• Script loaded to server, tested and working.
• Ongoing support (paid as separate tasks on hourly rate or fixed fee) to tune the script to deal with site changes.
• Schedule weekly imports directly into a set of MySQL tables on our server.

Acceptance criteria
• Every tour on the site appears in the database with itinerary, date, inclusion/exclusion notes and matching price. Tables will be set up as required and may be modified by you to best handle the data and content being captured.
• No critical HTML tags hard-coded—changes in URL parameters or pagination should be handled dynamically.
• A rerun of the script updates existing rows rather than duplicating them.

If you have recent projects involving large-scale travel or e-commerce scraping, please reference them when you reply so I can gauge how quickly we can move forward.