X-Cart forums

[seyfin]

Originally Posted by fiberglass.supply

final issue is how to not show on products with no variants or options. on those products it shows price lowest to highest but it not needed.

Just change the code as follows:

{if $variants}
{assign var="variant_max_price" value=$product.taxed_price}
{assign var="variant_min_price" value=$product.taxed_price}
{foreach from=$variants item="variant_item"}
{math assign="variant_max_price" equation="max(x, y)" x=$variant_max_price y=$variant_item.taxed_price}
{math assign="variant_min_price" equation="min(x, y)" x=$variant_min_price y=$variant_item.taxed_price}
{/foreach}
Max. Price: {$variant_max_price}
Min. Price: {$variant_min_price}
{/if}

[fiberglass.supply]

Thank you very much, it worked perfectly on product details page.


I tried it on category page/products list page but it did not work. Is the code different for that page?

[seyfin]

The same code will not work on category page/products list page, unfortunately, as $variants variable is not available at this page.

Basically, it requires more complex custom code modifications both in X-Cart's scripts and templates: your custom code should retrieve the variants info for each product to be displayed on category page, then pass the info to Smarty templates, to display the min. and max. variant prices for each product.

You can take advantage of our custom development services, and our developers will implement such customization for you.

[PhilJ]

This worked for me... (v4.7.x)

In products.php

BEFORE...

$smarty->assign('cat_products',      isset($products) ? $products : array());

INSERT...

if($products) {

     foreach($products as $key=> $product)
     $products[$key]["minprice"] = func_query_first_cell("SELECT min(price) FROM $sql_tbl[pricing] WHERE productid=".$product["productid"]);

     foreach($products as $key=> $product)
     $products[$key]["maxprice"] = func_query_first_cell("SELECT max(price) FROM $sql_tbl[pricing] WHERE productid=".$product["productid"]);

}

In skin/<SKIN>/customer/main/products_list.tpl AND/OR skin/<SKIN>/customer/main/products_t.tpl

INSERT....

{if $product.variantid && ($product.minprice != $product.maxprice)}
{math assign="min_price" equation="x*y" x=$product.minprice y=1.2}{* tax rate if applicable *}
{math assign="max_price" equation="x*y" x=$product.maxprice y=1.2}{* tax rate if applicable *}
<p><b>{$lng.lbl_from} {currency value=$min_price} {$lng.lbl_to} {currency value=$max_price}</b></p>
{/if}

*Updated*