Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Displaying products within a category

  1. 02-18-2010, 06:35 PM #1
    chris-user is offline Member
    Join Date
    Feb 2010
    Posts
    30

    Lightbulb Displaying products within a category

    Currently, our products are displayed in alphabetical order. How can we have the software display our products based on the product SKU/number versus the product name?

    Thanks for the help!
  2. 02-18-2010, 07:20 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Edit the stored proc aspdnsf_GetProducts. At the bottom part of the stored proc, you can see ORDER BY pf.rownum, change it to ORDER BY p.sku+pv.skusuffix (remove the +pv.skusuffix if you only want to sort it according to product sku).
  3. 02-19-2010, 09:04 AM #3
    chris-user is offline Member
    Join Date
    Feb 2010
    Posts
    30

    Talking Thanks!

    Thanks much for your help Alfred! We'll send the info to our developer and have him make that change for us!

    Best,

    Chris
  4. 02-19-2010, 11:08 AM #4
    chris-user is offline Member
    Join Date
    Feb 2010
    Posts
    30

    Question Code change not working properly

    We updated the code based on your recommendations/corrections and we are having some problems with the products displaying in product number/SKU order versus alphabetically.

    Here is what we are finding...most of the categories have enough products that there are multiple pages of products to be displayed. It seems that some things are in SKU order for the most part but then there are random products showing up in between...

    For example: In an astrology category I have 12 products with the sku AST0010 thru AST0120. We also have a few other products from other categories showing up in this category as they represent astrological signs. The products are displaying in this order:

    AST0010
    AST0020
    AST0030
    FAS0460
    OCC0270
    GAR00480
    AST0040
    AST0050
    AST0060
    AST0070
    AST0080
    AST0090
    AST0100
    AST0110
    AST0120

    Any ideas of what's happening here?