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.
Tekla Industrial Steel Modeling Category: 3D CAD, 3D Design, 3D Modelling, 3D Rendering, AutoCAD, Building Architecture, Construction Engineering, Tekla Structures Budget: $250 - $750 USD
Modern Party Dress Design & Translation Category: 3D Graphic Design, Adobe Illustrator, English Translation, Procreate, Technical Drawing / Tech Pack, Textile Design Budget: min $50 USD
01 Dec 2025 17:01 GMT
Small Functional PLA Prototype Category: 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, CAD / CAM, Fusion 360, Solidworks Budget: $10 - $30 USD
Engaging SaaS Homepage Design Category: CSS, Frontend Development, Graphic Design, HTML, UI / User Interface, User Interface / IA, Web Design Budget: £750 - £1500 GBP
01 Dec 2025 17:00 GMT
YouTube Educational Video Creator Category: After Effects, AI Art Creation, AI Content Creation, AI Image Editing, AI Model Development, Animation, Video Editing, Video Services Budget: $10 - $30 USD
01 Dec 2025 17:00 GMT
Handwritten Text Transcribed to Word Category: Data Entry, Editing, Microsoft Word, Proofreading, Time Management, Transcription, Typing, Word Processing Budget: ₹750 - ₹1250 INR
01 Dec 2025 16:59 GMT
Metro Engineering Certification Form Preparation Category: Data Visualization, Engineering, Project Management, Report Writing, Research And Development, Technical Documentation, Technical Writing Budget: $250 - $750 SGD
01 Dec 2025 16:59 GMT
PeepChat Fun UI/UX Design Category: Adobe XD, Figma, Graphic Design, Logo Design, Photoshop, UI / User Interface, User Interface / IA, UX / User Experience Budget: $15 - $25 USD
01 Dec 2025 16:59 GMT
Modern Standout Logo Revamp Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: $50 - $75 USD
