Show Custom Field On Category Pages

Developers Dev talks
1

I'd like to show the lowest possible price after quantity discounts on the category page underneath the base price.

I've created an addon for this which adds a column to the products table in the database for "low_price"

            ALTER TABLE `cscart_products` ADD `low_price` VARCHAR(50) AFTER `product_code` ;
		
         ALTER TABLE `cscart_products` DROP `low_price`;

The on the manage product template I have the following code to save the lowest quantity discount value to the new field. 

Lowest Price


{foreach from=$product_data.prices item="price" key="_key" name="prod_prices"}
				{assign var="lowest" value=$price.price}

				{/foreach}




                        Lowest Price:

This lets me see the lowest available price in the admin side, I can also add it to product page templates using the smarty tag {$products.low_price}

My question is how can I also show the lower price on the category page under the main price?

thanks in advance!

2

Use the products:prices_block hook in the following template:

design/themes/responsive/templates/common/product_data.tpl

To get product prices, please use the following code:

{$product.product_id|fn_get_product_prices:$product:$auth}
{$lowest = $product.price}
{foreach from=$product.prices item="price" key="_key" name="prod_prices"}
          {assign var="lowest" value=$price.price}
{/foreach}
3

Use the products:prices_block hook in the following template:

design/themes/responsive/templates/common/product_data.tpl

To get product prices, please use the following code:

{$product.product_id|fn_get_product_prices:$product:$auth}
{$lowest = $product.price}
{foreach from=$product.prices item="price" key="_key" name="prod_prices"}
          {assign var="lowest" value=$price.price}
{/foreach}

that works perfect, thank you.

4

You are welcome. We are always glad to help you.

5

that works perfect, thank you.

Hi,

Can you exactly specify where to use or replace these codes in product_data.tpl in MV 4.3.6?

6

use the products:prices_block hook

http://docs.cs-cart.com/4.3.x/developer_guide/addons/hooking/tpl_hooks.html