I am student using drupal commerce as a part of my thesis.

As an exercise in PHP I am attempting to display certain items on a page that fall into specific criteria. I know this is possible through Views and Taxonomy, but again this is to show/illustrate an understanding of PHP.

While reading through some related posts, a contributor had said that the specific product-page urls, as well as the image urls, are stored within the database. However, I have been unable to find them.