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.
Arabic Video Social Media Manager Category: Content Writing, Digital Marketing, Facebook Marketing, Instagram Marketing, Social Media Management, Video Editing, Video Production Budget: €30 - €250 EUR
CRM Online Energía y Telecomunicaciones Category: API Development, CRM, Database Management, HTML, PHP, Software Architecture, Web Development, Web Design Budget: €250 - €750 EUR
03-Nov-2025 17:02 GMT
Hindi-English Educational Material Translation Category: Content Writing, Editing, English (US) Translator, English Spelling, English Translation, Hindi Translator, Language Tutoring, Translation Budget: ₹1250 - ₹2500 INR
03-Nov-2025 17:01 GMT
Cottage Renovation Floor Plan Category: 2D Drafting, 3D Rendering, AutoCAD, Building Design, Floor Plan, Interior Design Budget: $750 - $1500 CAD
Google & Social Media Ad Plan Category: Digital Marketing, Facebook Ads, Facebook Marketing, Google Ads, Instagram Marketing, Internet Marketing, SEO, Social Media Marketing Budget: £750 - £1500 GBP
03-Nov-2025 17:00 GMT
Alianza Estratégica para Innovar Productos Category: 3D Design, 3D Modelling, 3D Printing, CAD / CAM, Fusion 360, Mechanical Engineering, Product Design, Solidworks Budget: $30 - $250 USD
