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

Thread: I want to edit XML package to order products by SKU

  1. #1
    jwhoward is offline Junior Member
    Join Date
    Jan 2012
    Posts
    1

    Default I want to edit XML package to order products by SKU

    I am very new to editing the sql query in an XML package in order to change the output. Below is the query to execute the aspdnsf_GetProducts Stored Procedure.
    Can I edit this to sort the results by SKU number?
    <sql>
    <![CDATA[
    exec dbo.aspdnsf_GetProducts
    @categoryID = @CatID,
    @sectionID = @SecID,
    @manufacturerID = @ManID,
    @distributorID = @DistID,
    @genreID = @GenreID,
    @vectorID = @VectorID,
    @localeName = @locale,
    @CustomerLevelID = @CustLevelID,
    @affiliateID = @AffID,
    @ProductTypeID = @ProdTypeID,
    @ViewType = 1,
    @pagenum = @pgnum,
    @pagesize = null,
    @StatsFirst = 0,
    @publishedonly = 1,
    @ExcludePacks = 0,
    @ExcludeKits = 0,
    @ExcludeSysProds = 0,
    @InventoryFilter = @InvFilter,
    @sortEntityName = "SKU",
    @storeID = @StoreID,
    @filterProduct = @FilterProduct
    ]]>
    </sql>

    Thanks,
    J

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    This is a call to the stored procedure dbo.aspdnsf_GetProducts. You would need to edit that sp to return the products by SKU order.
    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!