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.
Cyber Warfare Mercenary Miniatures Category: 3D Animation, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max, Blender, Concept Art Budget: $250 - $750 AUD
28-Oct-2025 22:58 GMT
video edting Category: A / V Editing, After Effects, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming, Videography Budget: $10 - $50 USD
28-Oct-2025 22:56 GMT
Rediseño y Desarrollo Sitio para pinvirtual Category: CSS, Digital Marketing, Graphic Design, JavaScript, PHP, SEO, Web Design, Web Development, WooCommerce, WordPress Budget: $30 - $250 USD
28-Oct-2025 22:56 GMT
Football Manager 2026 Mods Configuration Category: C#, Programming, C++, Game Testing, PHP, Software Testing, Technical Support, Troubleshooting, Unity 3D Budget: €8 - €30 EUR
28-Oct-2025 22:52 GMT
OpenAI Upload Connection Fix with Google Drive Category: DNS, Firewall, Network Administration, Network Monitoring, Network Security, System Administration, TeamViewer, Technical Support, Troubleshooting, VPN Budget: $10 - $30 USD
Energetic DJ for House Party Category: Audio Engineering, Audio Production, Audio Services, Event Management, Event Planning, Music, Music Production, Sound Design Budget: $250 - $750 AUD
28-Oct-2025 22:46 GMT
Teach Video Download Techniques Category: Google Chrome, JavaScript, Python, Scripting, Video Editing, Video Processing, Video Production, Web Scraping Budget: €8 - €30 EUR
