Web Scraping and Data Export Script

import requests
from bs4 import BeautifulSoup

# Base url of the website
base_url = 'https://www.example.com/product-page-'

# A list to store scraped data
data_list = []

# Loop over the page numbers you want to scrape
for page_number in range(1, 11): # Scraping 10 pages here
    url = base_url + str(page_number)

    # Request the page
    response = requests.get(url)

    # If the request is successful, the status code will be 200
    if response.status_code == 200:
        # Get the content of the response
        page_content = response.content

        # Create a Beautiful Soup object and specify the parser
        soup = BeautifulSoup(page_content, 'html.parser')

        # Let's say we want to scrape the product names and prices, and they
        # are in divs with the class 'product'. Replace this with your actual scenario.
        products = soup.find_all('div', class_='product')

        # Loop over the product details
        for product in products:
            name = product.find('h2', class_='product-name').text # Replace with actual class name
            price = product.find('span', class_='product-price').text # Replace with actual class name

            # Append this data as a tuple to the data list.
            data_list.append((name, price))

# Now you have data from multiple pages. Do whatever you want with it.
# For instance, you could write it to a CSV file.

import csv

with open('product_data.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    # Write the headers
    writer.writerow(['Product Name', 'Price'])
    # Write the data
    writer.writerows(data_list)