I need to capture details from all product detail pages that are linked pages linked to in this site map - https://www.selectcarleasing.co.uk/sitemap-vehicles
The top level sitemap links down to 82 lower level sitemaps which then each link to product description pages.
Examples:
Top level sitemap: /sitemap-vehicles Sub-sitemap: /sitemap-derivative-groups?channel_id=car-leasing&page=1 Product Description Page: /car-leasing/hyundai/bayon/suv/10-tgdi-premium-5dr-dct
For each product description page I need the following fields pulled from the URL:
Manufacturer:text Model:text Bodytype: text Derivative: text MIleage: number Term: number
In addition, for each product description I need the following fields scraped from the page:
Initial Payment: number Monthly Payment: number Delivery Status: text
The attached PDF shows where each field can be found.
Data should be output in an excel friendly CSV with URL followed by the fields for that URL.
Lead-Focused Social Video Campaign Category: Content Strategy, Facebook Marketing, Google Adwords, Instagram Marketing, Internet Marketing, Lead Generation, Social Media Marketing, Video Editing Budget: ₹12500 - ₹37500 INR
16-Aug-2025 04:04 GMT
eBook Formatting for Amazon KDP Category: Amazon Kindle, EBook Design, EBooks, Editing, Microsoft Word, Publishing, Word Processing Budget: ₹600 - ₹1500 INR
16-Aug-2025 04:02 GMT
Wiise ERP Training & Support Category: Business Consulting, Change Management, ERP, Inventory Management, Logistics, Operations Management, Project Management, Training Budget: $15 - $25 AUD
16-Aug-2025 04:02 GMT
Video Creation Category: A / V Editing, Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
16-Aug-2025 04:02 GMT
Daily Job Application Assistant Category: Admin Support, Customer Service, Data Entry, Excel, Google Sheets, Internet Marketing, Time Management, Virtual Assistant Budget: $52 - $53 SGD
16-Aug-2025 04:00 GMT
Real-Time Stock Options Tracker Setup Category: API Integration, Data Analysis, Data Integration, Data Visualization, Excel, Financial Analysis, Google Sheets, Market Analysis Budget: $30 - $250 USD
Audio Transcription of Interviews Category: Audio Editing, Copy Typing, English (UK) Translator, English (US) Translator, Transcription, Typing Budget: $15 - $25 USD
16-Aug-2025 03:51 GMT
PDF to Word Typing Task Category: Copy Typing, Data Entry, Data Processing, Editing, Microsoft Word, PDF, Proofreading, Typing, Word Budget: $250 - $750 USD
16-Aug-2025 03:50 GMT
E-commerce Site Data Entry Category: Content Management System (CMS), Data Entry, Excel, Photo Editing, Product Management, Website Management Budget: $10 - $11 USD
Remote Data Entry VA Needed Category: Admin Support, Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Excel, Virtual Assistant Budget: ₹750 - ₹1250 INR
