Nop_ProductLoadAllPaged small issue

Hi,

Nop_ProductLoadAllPaged is considering ProductVariants which Deleted=1 leading to problems with sorting.

I've fixed it by simply putting an "AND pv.Deleted=0" in the where clause.

Thanks

I've just noticed things are a bit more complicated than that. Actually we can indeed have products and no productvariant. The only problem is that when trying to sort, the stored procedure will take in consideration deleted product variants.

So instead of only adding:

AND
      (
        pv.Deleted=0
      )

it will only work with

AND
      (
        @OrderBy=0 OR pv.Deleted=0
      )

Correction:

AND
      (
        @OrderBy<>0 AND pv.Deleted=0
      )

Correction # 2:


    AND
      (
        @OrderBy=0 OR (@OrderBy<>0 AND pv.Deleted=0)
      )

My bad! :P