X-Cart forums

[IndieDepot]

THis sure would have been a nice mod. Too bad it doesn't work on the latest versions of X-Cart. *sad face*

- Shannon

[Online Michael]

Hi Jon,

Nice mod. However, I'm sorry for going off-topic for a moment, but I noticed something while visiting the mixtapemp3.com site that I want to ask you about. This site uses tabs to display information, and since my store uses them too, I was wondering how you managed to stop the page from jumping around (making the tabs appear at the top of the page) when clicking on them. Mine always go to the top of the page for some strange reason. How did you stop this from happening?

[Jon]

If somebody is interested you can PM me for a quote for 4.x, but I don't have the time to make it without necessity to do so.

You can prevent your page from jumping to the type by adding this code to your <a href tag:

 onclick="return false;"

Prevents the link from doing what it's supposed to.

[Online Michael]

Thanks Jon, love your work mate! Oh, and btw, worked great too!

[Lucent88]

yages,

I think the reason why you see that error is because ...

On v4.0.x.. you need

require $xcart_dir."/bestsellers_month.php";

instead of

require "./bestsellers_month.php";

After I corrected to that, I don't see the error message no more.
My site is still at testing stage, and there is no product sold, so I don't see any change this MOD does to my site just yet.

Let me know if anyone has a working demo site with standard template.

[yages]

I tried to install this mod but it would not work

Maybe this could be the problem
My home.php looks like this

#
# $Id: home.php,v 1.44.2.2 2005/01/12 07:41:51 svowl Exp $
#

header("Location: ../home.php".(!empty($QUERY_STRING) ? "?".$QUERY_STRING : ""));
?>

where do I put the code
require $xcart_dir."/bestsellers_month.php";

[sbkp]

Thanks! This is excellent.

I made one change so it's the last month's bestsellers, not just since the first of the current month:

$start_date = strtotime("-1 month");
$end_date = strtotime("now");

I removed the month_cat, since I want all categories included. I also checked orders' status (for Processed or Completed in my case):

$query = "SELECT $sql_tbl[products].*,$sql_tbl[pricing].*,$sql_tbl[order_details].productid,$sql_tbl[order_details].orderid,$sql_tbl[orders].orderid,$sql_tbl[orders].date, count($sql_tbl[order_details].productid) as sold FROM $sql_tbl[pricing],$sql_tbl[products],$sql_tbl[orders],$sql_tbl[order_details] WHERE ($sql_tbl[orders].status='C' OR $sql_tbl[orders].status='P') AND $sql_tbl[orders].date > '$start_date' AND $sql_tbl[orders].date < '$end_date' AND $sql_tbl[order_details].orderid=$sql_tbl[orders].orderid AND $sql_tbl[products].productid=$sql_tbl[order_details].productid AND $sql_tbl[pricing].productid=$sql_tbl[products].productid AND $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail>0 GROUP BY $sql_tbl[order_details].productid ORDER BY sold DESC LIMIT $month_limit";

And finally, I modified skin1/modules/Bestsellers/menu_bestsellers.tpl, rather than changing welcome.tpl.

Just change all instances of $bestsellers to $month_bestsellers.

Best,
Stefan

[ShishaPipeUK]

I changed this for xcart 4.1.3

shopcart/bestsellers_month.php

<?
$start_date = strtotime("-1 month"); # LAST MONTH PRODUCTS
$end_date = strtotime("now"); # TODAY - NOW
$amount_prod_to_show = '6'; # AMOUNT OF PRODUCTS TO SHOW
$query = "SELECT $sql_tbl[products].*, $sql_tbl[pricing].*, $sql_tbl[order_details].productid, $sql_tbl[order_details].orderid, $sql_tbl[orders].orderid, $sql_tbl[orders].date, count($sql_tbl[order_details].productid) as sold FROM $sql_tbl[pricing], $sql_tbl[products], $sql_tbl[orders], $sql_tbl[order_details] WHERE ($sql_tbl[orders].status='C' OR $sql_tbl[orders].status='P') AND $sql_tbl[orders].date > '$start_date' AND $sql_tbl[orders].date < '$end_date' AND $sql_tbl[order_details].orderid=$sql_tbl[orders].orderid AND $sql_tbl[products].productid=$sql_tbl[order_details].productid AND $sql_tbl[pricing].productid=$sql_tbl[products].productid AND $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail>0 GROUP BY $sql_tbl[order_details].productid ORDER BY sold DESC LIMIT $amount_prod_to_show";
$month_sellers = func_query($query);
$smarty->assign("month_sellers",$month_sellers);
?>

In the shopcart/home.php add

require "./bestsellers_month.php";

In the shopcart/skin1/customer/main/welcome.tpl add

{if $month_sellers ne ""}
{include file="modules/Bestsellers/bestsellers_month.tpl" products=$month_sellers featured="Y"}
<br />{/if}

Also add the above if you want it to be displayed in your subcategories to shopcart/skin1/customer/main/subcategories.tpl

I also made in shopcart/skin1/modules/bestsellers/bestsellers_month.tpl file which is:

bestsellers_month.tpl

{if $month_sellers}
{capture name=bestsellers}
<TABLE border="0" cellpadding="0" cellspacing="0">
<tr>
{foreach from=$month_sellers item=bestseller}
<TD width="100" align="center" valign="top">
<div align="center">{if $config.Bestsellers.bestsellers_thumbnails eq "Y"} <a href="product.php?productid={$bestseller.productid }&cat={$cat}&bestseller">{include file="product_thumbnail.tpl" productid=$bestseller.productid image_x=50 product=$bestseller.product alt=$bestseller.fulldescr|replace:"":""}</a>
<br />
{/if}
<b><a href="product.php?productid={$bestseller.productid }&amp;cat={$cat}&amp;bestseller">{$bestseller.prod uct}</a></b><br />
{$lng.lbl_our_price}: {include file="currency.tpl" value=$bestseller.price}<br />
</div></td>
<TD width="10"></TD>
{/foreach}
</tr>
</table>
{/capture}
{include file="dialog.tpl" title="This Months Hottest Sellers!" content=$smarty.capture.bestsellers extra='width="100%"'}
{/if}

You can see the finished product at http://www.theshisha.com/shopcart/home.php?cat=255

It will also display at the top of every categories, to see this go to http://www.theshisha.com/shopcart/home.php?cat=272

[blakekr]

Thank you so much for sharing the original, and everyone who posted 4x revisions. I haven't tried this yet, so may come back with questions -- but it's very kind of you.

[Jon]

Glad to see people are still benefiting from this, thanks for posting the updates