Re: Is it possible for solr to calculate and give back the price of a product based on its sub-products
I am not sure if that is doable , I think it needs to be taken care of at the indexing time. On Sun, Jun 8, 2014 at 4:55 PM, Gharbi Mohamed < gharbi.mohamed.e...@gmail.com> wrote: > Hi, > > I am using Solr for searching magento products in my project, > I want to know, is it possible for solr to calculate and give back the > price > of a product based on its sub-products(items); > > For instance, i have a product P1 and it is the parent of items m1, m2. > i need to get the minimal price of items and return it as a price of > product > P1. > > I'm wondering if that is possible ? > I need to know if solr can do that or if there is a feature or a way to do > it ? > And finally i thank you! > > regards, > Mohamed. > >
Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible, can you help me ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed. -- View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-for-solr-to-calculate-and-give-back-the-price-of-a-product-based-on-its-sub-products-tp4135081.html Sent from the Solr - User mailing list archive at Nabble.com.
Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
Re: is it possible for solr to calculate and give back the price of a product based on its sub-products
Thanks jack for your response, Actually my use case is that the sub products are the different sizes and colors of the parent product. So in order to have the adequate price for my product in the current search i need to return the minimum price of the matching sub-products, in other words i need that if i tape products name for instance i get the product with min-price over all it sub products and then, when refining the search, specifiying a size for example i need to get my product in the result with the min-price the minimum of it sub-products with matching the refinement size. -- View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-for-solr-to-calculate-and-give-back-the-price-of-a-product-based-on-its-sub-products-tp4135212p4135215.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: is it possible for solr to calculate and give back the price of a product based on its sub-products
Are these really sub-products? It sounds like you have the same product from multiple vendors and just want to return the lowest cost vendor, with no actual calculation. Either way, there is no direct method for this calculation/selection in Solr. Sure, you can always code a custom query component and/or custom function query value source, but this sort of sounds like an operation that you should be doing in your application layer rather than in Solr itself. You can certainly sort "ascending" by your price field, then the cheapest vendor would be returned first. In any case, please clarify your use case. -- Jack Krupansky -Original Message- From: Gharbi Mohamed Sent: Friday, May 9, 2014 3:29 PM To: solr-user@lucene.apache.org Subject: is it possible for solr to calculate and give back the price of a product based on its sub-products Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible, can you help me ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
Re: is it possible for solr to calculate and give back the price of a product based on its sub-products
Do that at index time. Index a document that has the product, the child products, and the total price. Flatten your data to match what the search results will display. Solr is not a relational system, so don't design with normalized tables, joins, and calculated result columns. wunder On May 9, 2014, at 12:29 PM, "Gharbi Mohamed" wrote: > Hi, > > I am using Solr for searching magento products in my project, > I want to know, is it possible for solr to calculate and give back the price > of a product based on its sub-products(items); > > For instance, i have a product P1 and it is the parent of items m1, m2. > i need to get the minimal price of items and return it as a price of product > P1. > > I'm wondering if that is possible, can you help me ? > I need to know if solr can do that or if there is a feature or a way to do > it ? > And finally i thank you! > > regards, > Mohamed. >
Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed. -- *Mohamed GHARBI* *Software engineering intren at DECADE-Tunisia*
Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible, can you help me ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible, can you help me ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.
Re: Is it possible for solr to calculate and give back the price of a product based on its sub-products
Hi Gharbi, It looks like CollapsingQParserPlugin can do that? fq={!collapse field=parent_id min=price_field} https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=40509582 Ahmet On Sunday, May 11, 2014 5:29 AM, gharbi mohamed wrote: Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of items and return it as a price of product P1. I'm wondering if that is possible, can you help me ? I need to know if solr can do that or if there is a feature or a way to do it ? And finally i thank you! regards, Mohamed.