V1.9 - Product order in Admin area

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 yıl önce
hi, some issuie i`ve just finded out - when you add a new product in admin the product you can not find it in the list
because it appears somewere in the inner pages and not by some order

seems like a "Sp_ProductLoadAllPaged" sp is not doing it`s job ?
13 yıl önce
ok, that what should be changed :

ORDER BY
    CASE WHEN @OrderBy = 0 AND @CategoryID IS NOT NULL AND @CategoryID > 0
    THEN pcm.DisplayOrder END ASC,
    CASE WHEN @OrderBy = 0 AND @ManufacturerID IS NOT NULL AND @ManufacturerID > 0
    THEN pmm.DisplayOrder END ASC,
    CASE WHEN @OrderBy = 0 AND @RelatedToProductID IS NOT NULL AND @RelatedToProductID > 0
    THEN rp.DisplayOrder END ASC,
    CASE WHEN @OrderBy = 0
    THEN p.ProductId END DESC,
-- instead of               THEN p.[Name] END ASC,
    CASE WHEN @OrderBy = 5
    THEN dbo.NOP_getnotnullnotempty(pl.[Name],p.[Name]) END ASC,
    CASE WHEN @OrderBy = 10
    THEN pv.Price END ASC,
    CASE WHEN @OrderBy = 15
    THEN p.CreatedOn END DESC
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.