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 3 of 3

Thread: How to sort variants list in product display?

  1. 10-06-2011, 11:59 AM #1
    omairkha is offline Member
    Join Date
    Aug 2011
    Posts
    89

    Question How to sort variants list in product display?

    Hi,

    I am using the product.tabbedUI.xml.config for the product info display.

    I noticed that my variants within a product are sorted by their Name. Is there a way to change this so that they are sorted by variant Manufacturer Part Number or SKU?

    Thanks in advance!
  2. 10-07-2011, 12:48 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    product.tabbedUI.xml.config data is supplied from the stored procedure aspdnsf_ProductInfo which returns data sorted by ProductVariant.DisplayOrder and then by ProductVariant.Name. So you should set the DisplayOrder for each of the ProductVariants, otherwise change the stored procedure to your prefered columns.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!
  3. 10-07-2011, 09:53 AM #3
    omairkha is offline Member
    Join Date
    Aug 2011
    Posts
    89

    Smile

    Thanks! I managed to find the display order settings for the variants