I need a lot of data scraped and added to an excel spreadsheet. The data can be found by logging into this website:
Website: [url removed, login to view]
Account #: 60101699
Click on the Quotes link, then Add Quote. Click Next, click Next again and this is where the data scraping needs to begin. What I need is to go through each Category, then each Product in that Category, and then each Fabric/Style for the product and copy all the Colors from the Color dropdown menu to a spreadsheet. Each Category needs to have its own worksheet within the workbook. I have created a sample of a couple categories and colors in the format that I am looking for.
Basically, what I need is a script that will scrape all the data for each category and output that to a spreadsheet that lists the Category, Product, Fabric/Style, and Color. If you have any questions, please don't hesitate to ask. I would also like to have a copy of this script if possible. Thanks!