Sorts products in a category based on how it is sorted in backoffice

Questions
1

I am using Lucene search. I have a search query. It searches the products in a category. I need the search to return the products in the same order it is ordered inside the category

For sort by i used category_sort_order

image
image1353×558 35.6 KB

But the result i got is not in the same order as in back office

This is the part of frontend result

image
image1664×463 42.9 KB

This is the backoffice product

image
image969×902 24.7 KB

Litium version: [7.6.1]

2

Use

SearchQueryConstants.Recommended

as the sort order.

3

image
image929×473 24.6 KB

image
image1354×823 51 KB

I made the changes for sortby. Still getting the same result. Am i doing something wrong with the code

4

It works fine when testing with similar code (see below). If you debug, is the sorting being applied correctly? Does it make a difference if you rebuild the index?

var searchQuery = new SearchQuery();
var products = new List<Litium.Web.Models.Products.ProductModel>();
searchQuery.CategorySystemId = Guid.Parse("76930397-9a9e-4b14-8b7a-5520ccb4a1b7");
searchQuery.SortBy = SearchQueryConstants.Recommended;
searchQuery.PageNumber = 1;
searchQuery.PageSize = 100000;
var response = _productSearchService.Search(searchQuery, searchQuery.Tags, true, true, true);

if (response.Hits != null)
{
	products.AddRange(_productSearchService
		.Transform(searchQuery, response)
		.Items
		.Value
		.OfType<ProductSearchResult>()
		.Select(x => x.Item));
}

var articles = products.Select(x => x.SelectedVariant.Id);

yields

[
    "637471676729630133-06160106-0000-001",
    "637471676729630133-06160107-0000-001_S",
    "637471676729630133-06160105-0000-001",
    "637471676729630133-02423006_L",
    "637471676729630133-23788284"
]

which matches

image
image590×539 36.3 KB

5

Please, check the log-file (not Event log in back office) to see the real lucene.net queries where also the sort information is included. The sort for products in a category should have a sort field like category-{categorySystemId}-sortindex, if that not is the first selection in the sort fields the sorting on the query is not applied correctly.