Or do you need to create relationships between your products, and the make/model/type of products where they can be applied? eg Car automotive industry, some parts fit many different types of cars. Yes you can
Most importantly, your customers can easily search by make/model/year/type to find the part they need. They do not need to know the category nor anything else. They can find all your parts that match their vehical.
If the user selects a make, they can continue to select a model, then year/type, and then search and our system will quickly find all matching parts for the chosen vehicle (or similar type search).
Our suggestion for year data, is to enter/import the data showing the year range (where applicable) and not breaking it into individual years. In many ways it does not matter which approach you take, however, it is noted that some cars have different year ranges spanning the same year, and therefore the year range indicates more specifically the vehicle chosen. If you separate it into individual years, you create more work, and there will be confusion if some products match the year (but not the range)
The above approach assumes you are selling parts for other products (eg cars) where there exists a one to many relationship between a part and the applicable use. If instead you want to provide a similar sort of search just for your products, where the make/model/year etc is an explicit search for your products, then please see make model year search.