I've created a bot that scrapes info from an inventory checker online. The output comes out in a continuous strings but I want it each store to be it's own column for easier analysis. The website I am using is brickseek.com/walmart-inventory-checker. An example zip code and item number are zip:60403, ID: 47335781.
It appears as the data is set in a table on the website. I was able to make the bot grab the first set of information that appears and divided it into 3 columns, one for the product name, one for the store it's at, and one for the price/availability, for this example:
Walmart Supercenter #3790
16241 S Farrell Rd
Lockport IL 60441
(815) 838-1027
7.71 Miles$ 5.00
Limited Stock
Est Qty in Stock: 1 or Less
But I can't get it to pull the second stores information, it just keeps pulling the first store.
Again I was able to create a bot that would pull the entire table but the output is a continuous string of text for each item.
The second task I need a bot to complete but I absolutely cannot figure out is I would like the bot to take the output data and be able to run it against a previously run version of the bot to spot the differences. Ideally, if the price or availability changes it would output a list of the changes. Any help is greatly appreciated.