Any ideas how to tackle following scenario with Drupal Commerce?
User selects his own vehicle from select drop-downs. Vehicle consists of following attributes: vehicle type, manufacturer, year, model. Then, by clicking any product category, user gets a view of products in that category that are suitable for the currently selected vehicle.
There are 50000 products in Excel file (with unique SKU), 8500 different vehicles as csv (with unique vehicle id and each vehicle attribute in their own columns), there are going to be 800+ product categories with many subcategories (snow mobiles, scooters, engine parts, exhaust pipe systems…) Many products may fit in many vehicles.
So where to start? How to match products with vehicles? How to match products with categories? Any help is appreciated. Thank you.