Thread: price ranges

I am looking to put the prices of product search results into price ranges. I currently have it grouped by price but am not sure how to get it to actually group by a range dynamically. Any suggestions?

Here is what I have currently to group by price.

Code:

<xsl:key name="variants-by-price" match="Products/Product" use="Price" />
<h3>Price Range</h3>
          <ul>
          <xsl:for-each select="/root/Products/Product[count(. | key('variants-by-price', Price)[1]) = 1]">
            <xsl:sort select="Price"></xsl:sort>
            <xsl:variable name="ProductPrice" select="Price" />
            <li><a href="">$<xsl:value-of select="format-number($ProductPrice,'###,###.00')" disable-output-escaping="yes" /></a> <small>(<xsl:value-of select="count(/root/Products/Product[Price = $ProductPrice])" />)</small></li>
          </xsl:for-each>
          </ul>

position() logic may work for you. Try something like this:

Code:

<xsl:key name="variants-by-price" match="Products/Product" use="Price" />
<h3>Price Range</h3>
<ul>
<xsl:for-each select="/root/Products/Product[count(. | key('variants-by-price', Price)[1]) = 1]">
<xsl:sort select="Price"></xsl:sort>
<xsl:variable name="ProductPrice" select="Price" />
	<xsl:if test="position() = 1">
	<li><a href="">$<xsl:value-of select="format-number($ProductPrice,'###,###.00')" disable-output-escaping="yes" /></a> <small>(<xsl:value-of select="count(/root/Products/Product[Price = $ProductPrice])" />)</small></li>
	</xsl:if>
	<xsl:if test="position() = last()">
		<li><a href="">$<xsl:value-of select="format-number($ProductPrice,'###,###.00')" disable-output-escaping="yes" /></a> <small>(<xsl:value-of select="count(/root/Products/Product[Price = $ProductPrice])" />)</small></li>
	</xsl:if>
</xsl:for-each>
</ul>

Thanks for your reply mmcgeachy. I am looking for something a little different though. I'm looking to show multiple price ranges for the products so the customer can limit to that group.

i.e.
$0 - $10
$10.01 - $50
etc

This would be dynamic ranges based on the products in the results.

Anyone have any suggestions?