Hi Markus, Thanks for your reply.
Using the current schema and query like you suggest, how can I identify the unique combination of options and price for a given SKU? I don't want the user to arrive at a product which doesn't completely satisfy their search request. For example, with the "color:Green", "size:M", and "price:[0 to 9.99]" search refinements applied, no products should be displayed which only have "size:M" in "color:Blue" The actual data in the database for a product to display on the frontend could be as follows: product id = 1 product name = T-shirt related skus... -- sku id = 7 [color=green, size=S, price=10.99] -- sku id = 9 [color=green, size=L, price=10.99] -- sku id = 10 [color=blue, size=S, price=9.99] -- sku id = 11 [color=blue, size=M, price=10.99] -- sku id = 12 [color=blue, size=L, price=10.99] Regards, Kelly Markus Jelsma - Buyways B.V. wrote: > > Hello Kelly, > > > I am not entirely sure if i understand your problem correctly. But i > believe your first approach is the right one. > > Your question: "Which products are available that contain skus with color > Green, size M, and a price of $9.99 or less?" can be easily answered using > a schema like yours. > > id = 1 > color = [green, blue] > size = [M, S] > price = 6 > > id = 2 > color = [red, blue] > size = [L, S] > price = 12 > > id = 3 > color = [green, red, blue] > size = [L, S, M] > price = 5 > > Using the data above you can answer your question using a basic Solr query > [1] like the following: q=color:green AND price:[0 TO 9,99] AND size:M > > Of course, you would make this a function query [2] but this, if i > understood your question well enough, answers it. > > [1] http://wiki.apache.org/solr/SolrQuerySyntax > [2] http://wiki.apache.org/solr/FunctionQuery > > > Cheers, > > -- View this message in context: http://old.nabble.com/Encountering-a-roadblock-with-my-Solr-schema-design...use-dedupe--tp27118977p27120031.html Sent from the Solr - User mailing list archive at Nabble.com.
