Build Excel VBA to scrape website product auction feedback details
Budget: $30 – $250 NZD
Build Excel VBA to scrape website product auction feedback details
I need a scrapper to copy data from an ecommerce auction website. Some of the data I need are listed below, also see further requirements on spreadsheet attached and screen images for examples.
The code must be run in Excel and the output. I do not want to install a web scrapping software. There is about 20pages (1000 products) to scrape through, and your code should be able to complete within 1-2hours
Your code should allow me to specify the landing page where to scrape from, also the URL where to search product data fields below.
To retrieve 3 of the data fields below (sold price, title, page views) your code needs to be able to search the website for the auction page based of the auction number provided off the feedback landing page.
Please note that the ecommerce website has 2 formats (depending on the category), although very similar to each, your code needs to take this into account whilst scrapping for the 3 data fields mentioned.
Data Fields:
Date
Buyer
Feedback Comment
Feedback Rating
Auction Number
Store
Sold Price$
Title
Page views
I need a scrapper to copy data from an ecommerce auction website. Some of the data I need are listed below, also see further requirements on spreadsheet attached and screen images for examples.
The code must be run in Excel and the output. I do not want to install a web scrapping software. There is about 20pages (1000 products) to scrape through, and your code should be able to complete within 1-2hours
Your code should allow me to specify the landing page where to scrape from, also the URL where to search product data fields below.
To retrieve 3 of the data fields below (sold price, title, page views) your code needs to be able to search the website for the auction page based of the auction number provided off the feedback landing page.
Please note that the ecommerce website has 2 formats (depending on the category), although very similar to each, your code needs to take this into account whilst scrapping for the 3 data fields mentioned.
Data Fields:
Date
Buyer
Feedback Comment
Feedback Rating
Auction Number
Store
Sold Price$
Title
Page views