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

Thread: Is there an easy way to add category info to product page?

  1. 11-20-2011, 05:07 AM #1
    alanzhou is offline Junior Member
    Join Date
    Sep 2011
    Location
    Shanghai China
    Posts
    16

    Lightbulb Is there an easy way to add category info to product page?

    Hi there,

    I'd like to dispaly current product's parent category's name and description on product details page. I know I need to change the product.Simpleproduct.xml.config. I wonder if I have to change the SP getProductInfo also?

    Thanks,
    Alan
    Last edited by alanzhou; 11-20-2011 at 05:50 AM. Reason: no additional
  2. 11-22-2011, 07:08 PM #2
    alanzhou is offline Junior Member
    Join Date
    Sep 2011
    Location
    Shanghai China
    Posts
    16

    Question

    nobody knows?
  3. 11-23-2011, 01:05 AM #3
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Do you want this instead of the product description? What version are you running on? Need some more information.
  4. 12-06-2011, 12:51 AM #4
    alanzhou is offline Junior Member
    Join Date
    Sep 2011
    Location
    Shanghai China
    Posts
    16

    Default

    Thank you, deanfp.
    I changed the product.simpleproduct.xml.config, and a SP.
    But I get further problem, please see http://forums.aspdotnetstorefront.co...ct-detail-page.

    Thanks,
    Alan
  5. 12-06-2011, 01:37 AM #5
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Are these products mapped to more than one root level category?
  6. 12-06-2011, 03:28 AM #6
    alanzhou is offline Junior Member
    Join Date
    Sep 2011
    Location
    Shanghai China
    Posts
    16

    Default

    maybe.

    I changed the product.simpleproduct.xml.config to
    <query name="Products" rowElementName="Product" runif="showproduct">
    <sql>
    <![CDATA[
    exec dbo.aspdnsf_ProductInfo @ProductID, @CustomerLevelID, 1, 0, @affiliateID, @CategoryID
    ]]>
    </sql>
    <queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
    <queryparam paramname="@CustomerLevelID" paramtype="runtime" requestparamname="CustomerLevelID" sqlDataType="int" defvalue="0" validationpattern="" />
    <queryparam paramname="@affiliateID" paramtype="system" requestparamname="AffiliateID" sqlDataType="int" defvalue="0" validationpattern="" />
    <queryparam paramname="@CategoryID" paramtype="runtime" requestparamname="entityID" sqlDataType="int" defvalue="0" validationpattern="" />
    </query>

    Then the laest viewed parent category appears!

    Thanks,
    Alan