Collecting data from multiple sources

Hi all, I’m building a web page where a user enters their location and then selects an item from a list of sporting goods (baseball bat for example). My program needs to return a list of locally sold products matching the selected item.

So the end view for the user would be a list of items similar to Amazon or EBay. The list should be able to contain info about the item, a picture, and a link to buy the item online.

I have thought of a couple ways to do this. One would be finding large chain stores and connecting with their APIs to pull in data. The drawback to this is that the user can be anywhere so I would need a enough APIs to assure the user can find a product. Also this limits the data to large companies with accessible APIs.

My other idea was to develop some type of web scraper. I’m not really sure how this is done however. It also seems unlikely that a web scraper could reliably pull in information and present the items in a consistent manner.

If anyone could offer insight on how I could solve this problem I would be extremely grateful.