Navigating Drupal Commerce Products
So I have this Commerce build I am working on, I've worked with Commerce before but never a top to bottom build.
I had to import close to 40,000 products, to which Feeds Importer for Commerce worked like magic. The problem I have now is creating a reasonable way to navigate these products.
What I would Like is a drill down, or tree structure for products. In the products I have imported 3 fields. Product Type (Bolts, Nuts, Washers), Product Category (Stainless Steel Bolts, Welding Nuts) and Product Sub Category (Metric Stainless Steel Bolts, 5 inch Welding Nuts).
So with that, I want to use these fields to create a sort of navigation that works like this.
Lists Product Types - You click One (Bolts), Pulls up all the bolts and the option to click on Product Category (Stainless Steel Bolts), and finally when you click on that it pulls up Stainless steel bolts and you can click on a sub category (Metric Stainless Steel Bolts)
Now there are only about 40 Product Types, so I created a view to navigate through those. But I have no idea how to go about navigating through the 1300 Product Categories and the 8000 Product Subcategories, short of custom creating a view for each an manually linking, which would take eons.
Can anyone point me in the right direction to do this sort of thing. I'd prefer not to do it with Apache Solr, that will come in at a later release of the site.
I REALLY appreciate any help.