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.
Organize and Fix TikTok Business Accounts Category: Account Management, Advertising, Digital Marketing, Google Adwords, Internet Marketing, Marketing, Social Media Management, TikTok Budget: $10 - $30 USD
21-Aug-2025 03:52 GMT
Promotional Short Film Creation Category: Cinematography, Creative Writing, Film Production, Script Writing, Video Editing, Video Production, Video Services, Videography Budget: $30 - $250 AUD
Post 50 Land Sale Ads Category: Advertising, Content Writing, Copywriting, Data Entry, Excel, Facebook Marketing, Market Research, SEO Writing, Social Media Management, Social Media Marketing Budget: $2 - $8 USD
Video Ads Sales Campaign Category: Advertising, Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Instagram Marketing, Internet Marketing, Sales, Social Media Marketing, Video Ads Budget: ₹1500 - ₹12500 INR
21-Aug-2025 03:48 GMT
4K Relaxing Nature Videos Category: After Effects, Animation, Cinematography, Color Grading, Drone Photography, Video Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR