Look for the presentations online. You are not the first store to use Solr, there are some explanations around. Try one from Gilt, but I think there were more.
You will want to store data at the lowest meaningful level of search granularity. So, in your case, it might be ProductVariation (shoes+color). Some examples I have seen, even store it down to availability level or price-difference level. Then, you do some post-search normalization either by doing groups or by doing filtering. Solr is not a database, store what you want to find. Regards, Alex. Personal website: http://www.outerthoughts.com/ LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch - Time is the quality of nature that keeps events from happening all at once. Lately, it doesn't seem to be working. (Anonymous - via GTD book) On Thu, Jul 25, 2013 at 12:42 PM, Mark <static.void....@gmail.com> wrote: > How would I go about doing something like this. Not sure if this is > something that can be accomplished on the index side or its something that > should be done in our application. > > Say we are an online store for shoes and we are selling Product A in red, > blue and green. Is there a way when we search for Product A all three > results can be returned even though they are logically the same item (same > product in our database). > > Thoughts on how this can be accomplished? > > Thanks > > - M