I created this site while employed as the webmaster for this company. They built and reconditioned very large diesel engines for large machines and generators. I built a database for this site to track their entire inventory and to keep track of prices.
Here is what the main inventory area looked like. The inventory was listed in a summary format. If the customer was interested in something they could click on the item itself and it would take you to a page with more information and several pictures of the item. An example of this detail screen is below.
Here is the detail view of a particular item. This gives the customer more information about the item. One more step of detail is available by clicking on the picture popup window.