I'm trying to brainstorm the best way to setup a product search functionality on a site in development. I thought maybe I would have one entry per product, then each variation of that product would be in its own Matrix row (columns = item#, color, woodtype, image url, etc.). So if I searched for "Tables" with color "White", woodtype "Pine", I could return the image of that product variation as well as the rest of the variation's row content(Only ever finding the one exact matching result). I'm looking to use a third-party search plugin, so Low Search or SolSpace Super Search. I'm also hoping to eventually return the result via Ajax if one of those plugins makes that easier.
Or maybe each variation variable is a category? Then I could search for "Tables" with "White" set as the color category, "Pine" set as the woodtype category, etc.? Or use Tags?
Any thoughts on the best way to accomplish this would be great. Thanks!