X-Cart forums - How to display the price for products in the recommends list

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - How to display the price for products in the recommends list (https://forum.x-cart.com/showthread.php?t=7475)

How to display the price for products in the recommends list

Hi,

I have seen many people wondering about how to display the price for products in the recommends list. Has anyone managed to find a suiatble solution that could be shared?

I am presuming that a php file may need to be modified to include the price related to the productid of the recommended products, but which and how I don't know.

If anyone can help it would be very much appreciated.

thanks

Here is a way to get the price in the non-random method the recommends use
You have to edit ./customer/recommends.php
and replace the query on line 70 with

Code:

    $query = "select distinct sp2.productid, p.*, min($sql_tbl[pricing].price) as price from $sql_tbl[pricing], $sql_tbl[stats_customers_products] as sp1, $sql_tbl[stats_customers_products] as sp2, $sql_tbl[products] as p where sp1.productid='$productid' and sp1.login=sp2.login and sp2.productid!='$productid' and p.productid=sp2.productid and p.forsale='Y' ".$avail_condition2." and $sql_tbl[pricing].productid = p.productid and $sql_tbl[pricing].membership = '' and $sql_tbl[pricing].quantity = '1' GROUP BY p.productid ORDER BY p.product LIMIT ".$config["Modules"]["number_of_recommends"];

You also have to edit ./skin1/modules/Recommended_Products/recommends.tpl

Code:

{section name=num loop=$recommends}[*]

<span class="ItemsList">{$recommends[num].product} {$recommends[num].price}</span>



{/section}

I can't test it myself, I don't have a demo with the proper statistics loaded on it. But it should work, the query doesn't give an errors or anythng.

Let me know how it does

Hi,
How would you apply the pricing fix to the code for the random method: staring with

Code:

$query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' ".$avail_condition.$query_condition;

in

recommends.php

thanks

how do i add the product price to the random selection of this mod?

Hello,

Has anyone managed to come up with a solution to display the prices of items from the random products array? TIA

I had a little time to look into this and have it working for random products. I tested this with 3.5.5

First edit skin1/modules/Recommended_Products/recommends.tpl Add this code:

Code:

 <font class=ProductPrice>{include file="currency.tpl" value=$recommends[num].price}</font><font class=MarketPrice>{include file="customer/main/alter_currency_value.tpl" alter_currency_value=$recommends[num].price}

AFTER

Code:

<span class="ItemsList">{$recommends[num].product}

Then edit customer/recommends.php

Find this line:

Code:

$query_condition .= "productid='".$products_id[$rnd]["productid"]."'";

CHANGE IT TO:

Code:

$query_condition .= "$sql_tbl[products].productid='".$products_id[$rnd]["productid"]."'";

Find this line:

Code:

$query_condition .= " OR productid='".$products_id[$rnd]["productid"]."'";

CHANGE IT TO:

Code:

$query_condition .= " OR $sql_tbl[products].productid='".$products_id[$rnd]["productid"]."'";

Finally, find this line:

Code:

$query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND avail>0".$query_condition;

CHANGE IT TO:

Code:

$query = "SELECT * FROM $sql_tbl[products] left join $sql_tbl[pricing] on $sql_tbl[products].productid=$sql_tbl[pricing].productid WHERE forsale='Y' AND avail>0 and quantity='1'".$query_condition;

Hope this helps! Feel free to format recommends.tpl to suit your needs.

Carrie

Fantastic Carrie! - I will implement this in v3.5.10 and let you know how I get on.

Unfortunately there are a number of changes in recommends.php from the 2004/05/05 modification. Therefore it does not work under v3.5.10 - The most stragithforward solution might be to just use the 'recommends.php' file and implement the changes outlined.

I don't have any version above 3.5.7 installed anywhere yet. I need to do that though, so once I get one of the higher versions installed, I'll report back as to how to change it.

Carrie

I got around to trying this in 3.5.10 and found a solution since the recommends.php code is quite a bit different from the 3.5.5

First edit skin1/modules/Recommended_Products/recommends.tpl Add this code:

Code:

 <font class=ProductPrice>{include file="currency.tpl" value=$recommends_prices[num].price}</font><font class=MarketPrice>{include file="customer/main/alter_currency_value.tpl" alter_currency_value=$recommends_prices[num].price}

AFTER:

Code:

<span class="ItemsList">{$recommends[num].product}

Then edit customer/recommends.php

Add these two lines:

Code:

$recommends_prices = func_query("select * from $sql_tbl[pricing] where quantity='1' and productid in (".join(",",$query_ids).")");

    $smarty->assign("recommends_prices",$recommends_prices);

AFTER:

Code:

$query = "SELECT $sql_tbl[products].*, $lng_fields FROM $sql_tbl[products] LEFT JOIN $sql_tbl[products_lng] ON $sql_tbl[products].productid=$sql_tbl[products_lng].productid $lng_condition WHERE $sql_tbl[products].forsale='Y' ".$avail_condition." AND $sql_tbl[products].productid IN (".join(",",$query_ids).")";

Hope that helps! :)

Carrie