Hi, below is from a previous job post. If you are an expert in website data scraping and very experienced in Excel formulas and macros...please reply and I can get you the attachments and more info.
thanks. I'm thinking $250.
** Have to be an expert in Scraping website product data.
** Have to be an expert in Excel formulas and macros.
The job is scraping/updating the Year Range product data from another website for our products. (auto parts)
Attached you will see a sample of our product data. (large spreadsheet with Year Range Data in many columns and in a few different formats - examples: 1999, 2000, 2001, 2002. 1999-2002. [[1999]] [[2000]] [[2001]]
The Yellow columns all contain the Year Range Data.
The Orange column contains the Part Number which needs to match.
This is the website I would like to use for this data.
xxxxxxxxxxxxxxxxx
Please see attached screenshots
The Products which contain "xxxxxxxxxxx" (specific text) in the Product Title are the only group of products we want to target.
The Year Range data is in the Product Title. It is also in the Product Details below as highlighted in screenshots.
When there is a Part Number match, the year data needs to be scraped and updated for that product.
There are some part numbers which are not an exact match, but the complete part number from our data will always be present in their data. I can get into the details on that later if this is something that you can do.
It's not that complicated, basically some Letters are sometimes included which need to be ignored in the matching process.
let me know you thoughts,
thanks for taking a look.
dave
this is the url for the example product in the screenshots.
xxxxxxxxxxxxxxxx