Hi Chris,

I faced the same challenge when I built my first Mechello shop. I solved that using a customize Examine index. 

I added all the necessary information from Merchello on a customized version of the standad External index. All category displays the get the display information from the Examine index.

Using this approach gave me the speed and flexibility of Examine with a little added logic.

if you are interested in this approach I can give you some pointers on the code.

Carsten

Yes please! I had a look at examine but I couldn't work out how to get the merchello products linked with the umbraco document.

Thanks

Chris

I have tried to strip down the code I use to update the index:

    public class AppStarting : IApplicationEventHandler

    {

        private static readonly object s_LockObj = new object();

        private static bool s_Ran;

 

        public void OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)

        {

            if (s_Ran)

                return;

 

            lock (s_LockObj)

            {

                if (s_Ran)

                    return;

                //Add event to allow searching by site section

                var indexerSite = ExamineManager.Instance.IndexProviderCollection["ExternalIndexer"];

                indexerSite.GatheringNodeData += this.SetSiteSearchFields;

                var productIndexerSite = ExamineManager.Instance.IndexProviderCollection["MerchelloProductIndexer"];

                productIndexerSite.GatheringNodeData += this.SetProductSearchFields;

 

                s_Ran = true;

            }

        }

 

        private void SetProductSearchFields(object sender, IndexingNodeDataEventArgs e)

        {

            // Find documents referencing product

            var sku = e.Fields.ContainsKey("productKey") ? e.Fields["productKey"] : null;

            if (sku != null)

            {

                BaseSearchProvider searcher = ExamineManager.Instance.SearchProviderCollection["ExternalSearcher"];

                ISearchCriteria criteria = searcher.CreateSearchCriteria(IndexTypes.Content);

                IBooleanOperation query = criteria.NodeTypeAlias("ShopProduct");

                query = query.And().GroupedOr(new[] { "product" }, sku);

 

                var compiledQuery = query.Compile();

                ISearchResults productRowsRaw = searcher.Search(compiledQuery);

 

                foreach (var result in productRowsRaw)

                {

                    ExamineManager.Instance.ReIndexNode(new Document(result.Id).ToXDocument(false).Root, IndexTypes.Content);

                }

            }

        }

 

        private void SetSiteSearchFields(object sender, IndexingNodeDataEventArgs e)

        {

            //grab the current data from the Fields collection

            var path = e.Fields["path"];

 

            //let's get rid of those commas!

            path = path.Replace(",", " ");

 

            //add as new field, as path seems to be a reserved word in Lucene

            e.Fields.Add("searchPath", path);

 

            if (e.Fields.ContainsKey("product"))

            {

                var productString = e.Fields["product"];

                if (!String.IsNullOrEmpty(productString))

                {

                    var productGuid = new Guid(productString);

                    var productVariants = Merchello.Core.MerchelloContext.Current.Services.ProductService.GetProductVariantsByProductKey(productGuid).Where(x => x.Available).ToList();

                    if (productVariants.Any())

                    {

                        var minPrice = productVariants.Min(x => x.Price);

                        var minSalePrice = productVariants.Min(x => x.SalePrice) ?? minPrice;

                        var manufacturer = productVariants.Max(x => x.Manufacturer);

                        string modelNumbers = "";

                        string skus = "";

                        foreach (var productVariant in productVariants)

                        {

                            modelNumbers += productVariant.ManufacturerModelNumber + " ";

                            skus += productVariant.Sku + " ";

                        }

                        e.Fields.Add("price", minPrice.ToString("00000"));

                        e.Fields.Add("salePrice", minSalePrice.ToString("00000"));

                        e.Fields.Add("manufacturer", manufacturer);

                        e.Fields.Add("onSale", productVariants.Any(x => x.OnSale).ToString());

                        e.Fields.Add("modelNumbers", modelNumbers);

                        e.Fields.Add("sku", skus);

                    }

                }

            }

        }

    }

I know there is a lot of code here, but basically it consists of two parts. The SetProductSearchFields method ensures that the nodes referencing the product is reindexed when a product is updated in Merchello. The SetSiteSearchFields method adds the product fields needed for rendering.

I removed some code to reduce complexity, so the code might not work as is. Just ask if you have any questions.

Carsten

Hi Carsten,

That looks great. I have it compiling in my project. Just trying to get my head around how to actually use examine to do the search now! I'll let you know if I get stuck.

Thanks

Chris

Hi Carten,

Thank you for your code. I have it working perfectly with very little tweaking.

Thanks

Chris

I have a question. I use your code and this line never return any variants:

var productVariants = Merchello.Core.MerchelloContext.Current.Services.ProductService.GetProductVariantsByProductKey(productGuid).Where(x => x.Available).ToList();

But in my merchello product I add SKU, Manufacturer, UPC code, Manufacturer MOdel No.

Can you also paste a line code of how to do the search in my controller, for example get all manufacturers. ?

Thanks

is working on a reply...