Developer forum

Hi DW,

We see wrong ordering of products on the initial display of products when we have set a custom order, but after the page is reloaded then the sort order is correct.

It seems to be caused by this code in ProductService.vb:

        Friend Function GetByAutoIDs(autoIDs As Int64()) As IEnumerable(Of Product)
            Dim products As New List(Of Product)
            Dim missingAutoIds As New List(Of Long)()

            For Each autoId As Long In autoIDs
                'Lookup the cachekey in the autoId mapping
                Dim cacheKey As String = Nothing
                If Not AutoIdIndex.TryGetValue(autoId, cacheKey) Then
                    missingAutoIds.Add(autoId)
                    Continue For
                End If

                Dim cacheProduct As Product = LookupProductInCache(cacheKey)

                If cacheProduct IsNot Nothing Then
                    products.Add(cacheProduct)
                Else
                    missingAutoIds.Add(autoId)
                End If
            Next

            Dim databaseProducts As IEnumerable(Of Product) = Repository.GetProductsByAutoIDs(missingAutoIds.ToArray())

            For Each databaseProduct In databaseProducts
                AddProductToCache(databaseProduct)
            Next

            products.AddRange(databaseProducts)

            Return products
        End Function

Here the products need to be reordered according to the index of each autoid, as the initial sort order will be messed up with products from cache and products from the database

We are experiencing this issue on 9.4.7 and will be happy for a quick fix :-)

Best regards, Anders