I have a website that sells product from a vendor (will provide website name if requested). The vendor’s website does not expose a table of updated stock status and prices, but rather lists one product per page on the site. There are 2 fields on each page that I need to import into a spreadsheet using the item number listed on the page. When querying for an item number, I need the stock status and retail price returned. I want it to query all of my items overnight so I can upload the new stock status. I’m trying to use the Excel .iqy file but I’m having no luck. Has anyone tackled this problem?
All help appreciated.
