User Skriver

Member for: 6 years (since Sep 24, 2013)
Type: Approved user
Full name: Dean
Company Name:
Location: Sweden

Activity by Skriver

Score: 2,345 points (ranked #7)
Questions: 19 (3 with best answer chosen)
Answers: 53 (6 chosen as best)
Comments: 117
Voted on: 4 answers
Gave out: 4 up votes, 0 down votes
Received: 3 up votes, 0 down votes

Wall for Skriver

Please log in or register to post on this wall.
Hi Dean,

Could you please give me a hand on this? I'm not really up with XML:

I would greatly appreciate it.


Jun 24, 2014 by donato
Hi Skriver, did you have any luck with the related-product price? Thanks.
Mar 31, 2014 by locpham7
Hi Skriver, I have tested your code, it shows the product price. However, It is of the current-viewing product, not the related-products (which could be multiple related-products) and prices. Please click on the link below and check out the "You May Also Like" column on the right; The title may be miss leading but it is the same as "Related Products".
Please help. Thank you.
Mar 24, 2014 by locpham7
Hi Skriver, would you please send me the solution for the related-product pricing. My email is [email protected] Thank you, I really appreciate your effort.
Mar 23, 2014 by locpham7
Hi Skriver, per our conversation on the forum, I am using version 9.3.1, and relatedProduct.Xml.config package. Here is the SQL part in that package. Thank you.

<package version="2.1" displayname="Related Products" debug="false" includeentityhelper="false">
    <query name="RelatedItems" rowElementName="Item">
            EXEC aspdnsf_GetCustomersRelatedProducts
         SELECT dbo.*,
                        pv.VariantID, VariantName, pv.Price, pv.Description VariantDescription, isnull(pv.SalePrice, 0) SalePrice, isnull(SkuSuffix, '') SkuSuffix, pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points,
                        isnull(e.Price, 0) ExtendedPrice        

        <queryparam paramname="@ProductID"       paramtype="runtime"   requestparamname="productid"                                  sqlDataType="int"          defvalue="0"    validationpattern="" />
        <queryparam paramname="@CustomerLevelID" paramtype="runtime"   requestparamname="CustomerLevelID"                            sqlDataType="int"          defvalue="0"    validationpattern="" />
        <queryparam paramname="@InvFilter"       paramtype="appconfig" requestparamname="HideProductsWithLessThanThisInventoryLevel" sqlDataType="int"          defvalue="0"    validationpattern="" />
        <queryparam paramname="@CustomerGUID"    paramtype="runtime"   requestparamname="customerGuid"                               sqlDataType="nvarchar" defvalue=""        validationpattern=""  />
        <queryparam paramname="@affiliateID"     paramtype="system"    requestparamname="AffiliateID"                                sqlDataType="int"          defvalue="0"    validationpattern="" />
            <queryparam paramname="@StoreID"             paramtype="runtime"   requestparamname="StoreID"                                                       sqlDataType="int"          defvalue="1"  validationpattern="" />
        <queryparam paramname="@FilterProduct"   paramtype="runtime"   requestparamname="FilterProduct"                                                   sqlDataType="bit"        defvalue="0"  validationpattern="" />
Mar 6, 2014 by locpham7
Hi Skriver,
I have created following XML Package for disable the top and Left menu navigation for before login :

<?xml version="1.0" standalone="yes" ?>
<package version="2.1" displayname="Default Home Page" debug="true">
        <xsl:stylesheet version="1.0" xmlns:xsl="" xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
            <xsl:template match="/">    
                <xsl:variable name="CustomerID" select="aspdnsf:CustomerID()" >    
                <xsl:if test="$CustomerID = 0">
                    <h>Don't Show Menu Navigation</h>

Please let me know how to use the package and disable the menu navigation.


Mar 6, 2014 by bikashm
Hi Skriver,

I am facing following issue,Can u plz help me out?

I have set Product and Entity for individual Store but Now, I need to set Product / Entity menu as per the login id. Depending on user Login, the menu will be change.

Actually I need, when a user comes on my site, it shows a login page and after login it will show the home page and the corresponding navigation.

Can u please let me know what are the procedures for that?

Thanks in advance.

Mar 4, 2014 by bikashm