Inspiration

We were inspired because we personally experienced the annoyance of overpaying for a product on Amazon due to their dynamic pricing strategy. There is nothing more frustrating especially when you are just a broke college kid.

What it does

When you type your URL into the search bar and click "Track", you will be directed to the product's page. This page consists of its name, image, and a line graph displaying the price trends over time. The other option, "My Portfolio", allows you to see all the previously added products in a grid format.

How we built it

We created a database using mySQL to hold all the URLs of products and their respective prices and dates. Then we created a Java program that web scrapes for the prices of a certain product every hour. At the end of each hour, we updated the new price in our database. This was achieved by creating a cron job.

Challenges we ran into

A major challenge that we ran into was that we barely knew anything about front end. We also did not have previous experience with web development, web scraping, and cron jobs. We also had to learn to read and understand HTML.

Accomplishments that we're proud of

We were proud of creating a cron job and implementing web scraping in Java. We were also proud to not only create our own database in mySQL, but to update it every hour and have it communicate with our Java program.

What we learned

We learned a lot about how data science and computer science are very intertwined and how their components work together. We also learned that beginning and defining is the most difficult part, but after that is achieved more than half the work is completed.

What's next for ShopStock

Currently we would like to create a more functional model as ours is not complete on the front end. We have the backend 80% completed, but just need to add final touches.

Built With

Share this project:

Updates