Looking for old forum posts and information? View the old forum archive here ยป

User Skriver

Member for: 4 years
Type: Approved user
Full name: Dean
Company Name:
Location: Sweden
Website:
About:

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: https://forums.vortx.com/?qa=1870/recently-added-products

I would greatly appreciate it.

Cheers,

Dan
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".
http://beta.vividpetsupplies.com/p-5-chain-leash.aspx
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 locpham7@gmail.com. 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">
        <sql>
            <![CDATA[
            EXEC aspdnsf_GetCustomersRelatedProducts
                 @CustomerGUID,
                 @ProductID,
                 @CustomerLevelID,
                 @InvFilter,
                 @affiliateID,
                         @storeID,
                 @FilterProduct
                 
         SELECT dbo.*,
                        pv.VariantID, pv.name VariantName, pv.Price, pv.Description VariantDescription, isnull(pv.SalePrice, 0) SalePrice, isnull(SkuSuffix, '') SkuSuffix, pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points,
                        sp.name SalesPromptName,
                        isnull(e.Price, 0) ExtendedPrice        
            ]]>
        

        </sql>
        <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="" />
    </query>
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">
    <PackageTransform>
        <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
            <xsl:template match="/">    
                <xsl:variable name="CustomerID" select="aspdnsf:CustomerID()" >    
                </xsl:variable>
                <xsl:if test="$CustomerID = 0">
                    <h>Don't Show Menu Navigation</h>
                </xsl:if>    
            </xsl:template>
        </xsl:stylesheet>
    </PackageTransform>
</package>

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

Thanks,

Bikash
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.

Bikash
Mar 4, 2014 by bikashm
...