Thread: Image using SKU or ProducID?

I have it to where when we do large product uploads through XML or Excel then it uses the SKU to find the image name. Here is the trouble if we manually upload a product individually along with manually upload an image then it uses the productid. How do I go about finding out when it is going to chose between those two?

For instance I was using something like this:

Code:

		<xsl:param name="site">http://www.archerycenter.com/images/product/icon/</xsl:param>
		<xsl:param name="jpg">.jpg</xsl:param>
		<xsl:param name="image">
			<xsl:choose>
				<xsl:when test="sku!=''">
					<xsl:value-of select="$site" /><xsl:value-of select="/root/FPProducts/FrontPageProducts/sku" /><xsl:value-of select="$jpg" />
				</xsl:when>
				<xsl:otherwise>
					<xsl:value-of select="$site" /><xsl:value-of select="/root/FPProducts/FrontPageProducts/productid" /><xsl:value-of select="$jpg" />
				</xsl:otherwise>
			</xsl:choose>
		</xsl:param>

Now this doesn't take into account if there is a SKU, but still using the ProductID because it was manually entered and we uploaded the image.

I would figure there was a place in the database that quickly distinguishes this, but I couldn't find it. For instance 1 for if it is using SKU or 0 if it is using ProductID.

Have you tried using the LookupProductImage function? Here is how the manual describes it:

"Description: Returns an <img> tag specifically for a product. The ImageFileNameOverride or SKU parameter will allow this method to perform much faster than the standard LookupImage function if you use ImageFileNameOverride or UseSKUForProductImageName on your product's images. Either parameter can be an empty string if not used."

The same thing is available with VariantImages if you use them "LookupVariantImage".

Code:

<xsl:value-of select="aspdnsf:LookupProductImage(ProductID, ImageFileNameOverride, SKU, DesiredSize, IncliudeATag)" disable-output-escaping="yes"/>

http://manual.aspdotnetstorefront.co...-packages.aspx