I need a program that will go to a website and screen scrape the site. I'll provide the URL,
There is 20 items on a page, I need the item name, retail price, cost, SKU and status scraped, (i.e. in stock vs else)
I'll provide the queries that it should run, and when its done, it should auto restart at the beginning.
The queries will consist of
1) append table 1
2) append table 2
3) update table 2
It will do this to all 20 items, and then move onto the next page.
minimum speed requirements 1 page per second, but 2+ pages would be fantastic