here is a simplified package for MS 9+ that uses:
- SEDescription (no need to strip html)
- /root/System/StoreUrl and /root/System/PageName for the canonical URL (no editing and/or guessing
- aspdnsf:ProductImageUrl to get the link to the image (no assumptions/guessing)
Code:
<?xml version="1.0" standalone="yes" ?>
<package version="2.1" displayname="BFGs Facebook / rel canonical package" debug="false" includeentityhelper="false" allowengine="true">
<query name="Products" rowElementName="Product">
<sql>
<![CDATA[
SELECT ProductID, Name, SEDescription, ImageFileNameOverride, SKU FROM Product WHERE ProductID = @ProductID
]]>
</sql>
<queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
</query>
<PackageTransform>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
<xsl:output method="xml" omit-xml-declaration="yes" />
<xsl:template match="/">
<!-- start of setting the canonical link for category & product pages -->
<xsl:param name="canonical" select="concat(/root/System/StoreUrl, /root/System/PageName)" />
<!-- end of setting the canonical link for category & product pages -->
<!-- start of setting the image link for product pages -->
<xsl:param name="image_link">
<xsl:choose>
<xsl:when test="boolean(/root/Products/Product/ProductID)">
<xsl:value-of select="aspdnsf:ProductImageUrl(/root/Products/Product/ProductID, /root/Products/Product/ImageFileNameOverride, /root/Products/Product/SKU, 'medium', 'true')" />
</xsl:when>
<xsl:otherwise>0</xsl:otherwise>
</xsl:choose>
</xsl:param>
<!-- end of setting the image link for product pages -->
<!-- start of setting the product name for product pages -->
<xsl:param name="prod_name">
<xsl:choose>
<xsl:when test="boolean(/root/Products/Product/ProductID)">
<xsl:value-of select="/root/Products/Product/Name"/>
</xsl:when>
<xsl:otherwise>0</xsl:otherwise>
</xsl:choose>
</xsl:param>
<!-- end of setting the product name for product pages -->
<!-- use SEDescription - no HTML -->
<xsl:variable name="FBDesc" select="/root/Products/Product/SEDescription" />
<!-- end of setting the product description for product pages (including stripping html tags) -->
<!-- start of rel canonical DELETE THIS IF YOU DON'T WANT IT -->
<xsl:choose>
<xsl:when test="$canonical != 0">
<link rel="canonical" href="{$canonical}" />
</xsl:when>
<xsl:otherwise></xsl:otherwise>
</xsl:choose>
<!-- end of rel canonical DELETE THIS IF YOU DON'T WANT IT -->
<!-- start of og tags REMEMBER TO EDIT THE ADMIN ID TO MATCH YOUR OWN AND THE SITE NAME TOO-->
<xsl:choose>
<xsl:when test="$image_link != 0">
<meta property="og:title" content="{$prod_name}"/>
<meta property="og:type" content="product"/>
<meta property="og:image" content="{$image_link}"/>
<meta property="og:url" content="{$canonical}"/>
<meta property="og:description" content="{$FBDesc}"/>
<meta property="og:site_name" content="Site Name"/>
<meta property="fb:admins" content="555221822"/>
<link rel="image_src" href="{$image_link}" />
</xsl:when>
<xsl:otherwise></xsl:otherwise>
</xsl:choose>
<!-- start of og tags REMEMBER TO EDIT THE ADMIN ID TO MATCH YOUR OWN AND THE SITE NAME TOO-->
</xsl:template>
</xsl:stylesheet>
</PackageTransform>
</package>
Originally Posted by macecase
Reply With Quote
