goodroi - 9:05 pm on Dec 11, 2013 (gmt 0)
You are talking about a huge problem that industrial and B2B websites have been facing for years. To be honest I have yet to see a great solution. In my experience it usually ends up more like making the best of a bad situation.
Simple answer - Get creative.
More detailed answer - Avoid uploading a big, plain parts catalog. Google is basically a text retrieval system and you want to give it a bunch of good quality text for it to think your page is relevant.
Think about writing detailed description. How about posting customers reviews? If you can't do that then come up with a paragraph of common uses for the part. Add some suggested DIY projects that the part can be used in. Maybe post common questions & answers for this part. Get creative and make sure to post significant amount of unique text on eveyr page you want to perform well in Google.
Another option is to go to other way and just admit that not every page on your site should be indexed by Google. Create a stainless steel widget buying guide and maybe a few pages for each product line. But do not publish 1000 anemic pages for every single stainless steel widget. This can allow you to focus your link equity on a handful of good landing pages that can direct users to the individual product page for ordering.