Elasticsearch

[ElasticType(Name = "product")] 
public class ElasticsearchProduct_Custom : ElasticsearchProduct 
{      /// Gets or sets the Closeout product value.      public int Closeout { get; set; } 
}

[DependencyOrder(1)] 
public class ElasticsearchProductFactory_Custom : 
ElasticsearchProductFactoryBase<IndexableProduct_Custom, ElasticsearchProduct_Custom>
{      /// Initializes a new instance of the <see cref="ElasticsearchProductFactory_Custom" /> class.
  ///The boost helper.      ///The unit of work factory.      public ElasticsearchProductFactory_Custom(IBoostHelper boostHelper, IUnitOfWorkFactory unitOfWorkFactory)            : base(boostHelper, unitOfWorkFactory)
  {
  } 
  /// The map additional properties.      ///The indexable product.      ///The elasticsearch product.      /// The <see cref="ElasticsearchProduct_Custom" />.      protected override ElasticsearchProduct_Custom 
  MapAdditionalProperties(IndexableProduct_Custom indexableProduct, 
  ElasticsearchProduct_Custom elasticsearchProduct)      {
    elasticsearchProduct.Closeout = indexableProduct.Closeout;
    return elasticsearchProduct;
  }
} 

/// <summary>  
/// This class overrides the default ElasticsearchProductMapping. With this you can  
/// change Elasticsearch mappings for the standard ElasticsearchProduct /// properties, or new custom properties.  
/// </summary>  
[DependencyOrder(1)]  
[DependencyName("ElasticsearchProductMapping")]  
public class ElasticsearchProductMapping_Custom : ElasticsearchProductMapping  
  {      /// <summary>The type of the class you are creating a mapping for.</summary>  
  public override Type MappingType { get; } = typeof(ElasticsearchProduct_Custom);  
  /// <summary>The get mapping.</summary>      /// <returns>The <see cref="RootObjectMapping"/>.</returns>      public override RootObjectMapping GetMapping()      {            var mapping = base.GetMapping();     mapping.Properties.Add(nameof(ElasticsearchProduct_Custom.Closeout).ToCamelCase(), new  
    StringMapping { Index = FieldIndexOption.Analyzed });     return mapping;      }  
}

/// <summary> 
/// This is the object that the SQL query gets bound to. If you add custom fields to the 
/// SQL query (See IndexableProductRepository_Custom.cs) you will also 
/// need to add the corresponding properties to this class. 
/// </summary>
public class IndexableProduct_Custom : IndexableProduct 
{      /// <summary>Gets or sets the Closeout product value.</summary>      public int Closeout { get; set; } 
} 

[DependencyOrder(1)] 
public class IndexableProductRepository_Custom : IndexableProductRepository 
{      public IndexableProductRepository_Custom(IUnitOfWorkFactory unitOfWorkFactory)            : base(unitOfWorkFactory)    {
  }
         /// <summary>The all product query custom fields.</summary>    protected override string AllProductQueryCustomFields => @"
  CONVERT(INT, ISNULL((
    SELECT pp.Value
    FROM CustomProperty pp WITH (NOLOCK)
    WHERE pp.ParentId = p.Id AND pp.Name = 'Closeout'
  ), '0')) 
  AS Closeout";
} 

[DependencyApplicationSetting("ProductSearchProvider", "ElasticsearchCustom")]  
public class ProductSearchIndexerElasticsearch_Custom : ProductSearchIndexerElasticsearch  
{  
  /// <summary>Initializes a new instance of the <see cref="ProductSearchIndexerElasticsearch_Custom"/> class.</summary>      /// <param name="index">The index.</param>     /// <param name="unitOfWorkFactory">The unit of work factory.</param>     /// <param name="indexableProductRepository">The indexable product repository.</param>      public ProductSearchIndexerElasticsearch_Custom(IElasticsearchIndex index,  
    IUnitOfWorkFactory unitOfWorkFactory, IIndexableProductRepository  
    indexableProductRepository)            : base(index, unitOfWorkFactory, indexableProductRepository)      {  
  }  
   /// <summary>The build product search index.</summary>      /// <param name="indexName">The index name.</param>      /// <param name="incremental">The incremental.</param>      /// <param name="logMessage">The log message.</param>      public override void BuildProductSearchIndex(string indexName = null, bool  
  incremental = false, Action<string> logMessage = null)      {            indexName = indexName ?? this.Index.Alias;     try            {                  this.IndexProducts\<IndexableProduct_Custom,  
      ElasticsearchProduct_Custom>(indexName, logMessage, incremental);           }  
    catch (Exception ex)  
    {                  logMessage?.Invoke($"Product search indexer exception: {ex.Message}  
      {ex.StackTrace}");                  throw;            }      }  
}

[DependencyApplicationSetting("ProductSearchProvider", "ElasticsearchCustom")] 
public class ProductSearchProviderElasticSearch_Custom : 
  Insite.Search.Elasticsearch.DocumentTypes.Product.Query.ProductSearchProviderElasticsearch
{      public ProductSearchProviderElasticSearch_Custom(            IElasticsearchIndex index,                 ICacheManager cacheManager,                ICatalogCacheKeyProvider catalogCacheKeyProvider,                  IPerRequestCacheManager perRequestCacheManager,            IUnitOfWorkFactory unitOfWorkFactory,            IProductSearchFacetProcessor facetProcessor,            IElasticsearchQueryBuilder queryBuilder,            IPhraseSuggestConfiguration phraseSuggestConfiguration,            IBoostHelper boostHelper,            IApplicationSettingProvider applicationSettingProvider) : base(index,              cacheManager,              catalogCacheKeyProvider,              perRequestCacheManager,              unitOfWorkFactory,              facetProcessor,              queryBuilder,              phraseSuggestConfiguration,              boostHelper,              applicationSettingProvider)      {            base.SortOptions.Add(new SortOrderDto() { DisplayName = "Closeout", SearchOnly = 
    false, SortType = "Closeout" });      }      protected override SortOrderField[] MakeCustomSortOrder(string sortBy, 
    IProductSearchParameter parameter, out bool manualSort)      {            manualSort = false; // for price sorting
    // sortBy string is from the sort options SortType property
    if (sortBy == "Closeout")            {                 // secondary sort                  // determine the order of items added to searchLookup cannot be sorted on. Only indexed.                  // name of the sort order field is the custom property called Closeout. Name of whatever we added to the index as. 
      // if numeric field then it is the type of field.                  // if numeric it will default to 0,1 and then when reverse is set it is saying that Closeout is at the top because 1 is true.                  // thus rendering 1,0
      return new SortOrderField[]                              {
        new SortOrderField("Closeout",false, true),                                    new SortOrderField(SortOrderField.Score, true, true)                              };
    }     return null;
  }
}