How to display the price for products in the recommends list

laureon · #1 05-07-2004, 07:49 AM

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

Mod King · #2 05-14-2004, 07:38 AM

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

xcell67 · #3 05-20-2004, 09:56 PM

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

MOC · #4 07-10-2004, 02:21 PM

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

laureon · #5 07-17-2004, 04:49 AM

Hello,

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

BCSE · #6 07-17-2004, 06:55 AM

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

laureon · #7 07-17-2004, 06:59 AM

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

laureon · #8 07-17-2004, 07:18 AM

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.

BCSE · #9 07-17-2004, 07:51 AM

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

BCSE · #10 07-17-2004, 06:34 PM

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