Best sellers "page"

[davidrushton]

I would really appreciate if anyone can provide me with some help.

I am in the process of adding an AJAX tab section to my page (similar to the tabbed box on the right of bbc.co.uk) to contain things such as Featured Products, Best Sellers, etc..

The only problem is that I don't know how to get something like Best Sellers into the box for that tab in a plain style (without getting all of the site template along with it).

Can anyone help me?

Thanks,

David.

[kuroi]

I am in the process of adding an AJAX tab section to my page (similar to the tabbed box on the right of bbc.co.uk) to contain things such as Featured Products, Best Sellers, etc..

The only problem is that I don't know how to get something like Best Sellers into the box for that tab in a plain style (without getting all of the site template along with it).

You will need to write a server side handler based on the bestsellers sidebox module to query the database and format the result into the html that you want to return and then invoke that handler via your AJAX call.

[LissaE]

I added this mod and uploaded it all just as is (changing my custom folder name though lol) The only thing I changed was to add a define for no products, because that's exactly what it is telling me....I do have bestsellers but none are showing on the page, can anyone help?

http://havendesignz.com/store/index....e=best_sellers

[LissaE]

Just to let everyone know this was a simple fix once I thought about it properly LOL

To list only in-stock products, open includes/languages/english/extra_datafiles/your_template/best_sellers.php
set BEST_SELLERS_SHOW_OUT_OF_STOCK to false

My store is all downloadable products so I have the stock count disabled, I set it to true in this file and there they all appeared LOL :)

[LissaE]

Ok, I have just noticed that the best sellers page is pulling up ALL my products and not only the purchased ones, though the most purchased ones do seem to be at the top.... how can I fix this?

I have 36 that have been purchased, and a total of 65 in store which is the total that shows on Bestsellers page

http://havendesignz.com/store/index....e=best_sellers

[LissaE]

I think I managed to fix this without breaking it LOL, I downloaded and looked at the Bestsellers Reloaded Mod, and noticed one line in how the data was pulled from the database (I am assuming LOL some things I am still taking a HUGE learning leap on!)

In includes/modules/pages/best_sellers/header_php.php at around line 32 find this line:

WHERE p.products_status = 1

and add in directly after it:

AND p.products_quantity > 0

This changed the bestseller number count to the number of products that show as having been purchased in Admin, so hopefully I fixed it the right way LOL

[adamlop]

How to "limit". Please. This show me all of the products in shop.

[LissaE]

adamlop:

I think I managed to fix this without breaking it LOL, I downloaded and looked at the Bestsellers Reloaded Mod, and noticed one line in how the data was pulled from the database (I am assuming LOL some things I am still taking a HUGE learning leap on!)

In includes/modules/pages/best_sellers/header_php.php at around line 32 find this line:

WHERE p.products_status = 1

and add in directly after it:

AND p.products_quantity > 0

This changed the bestseller number count to the number of products that show as having been purchased in Admin, so hopefully I fixed it the right way LOL

You will also need to add in the same line around line 20 so that your header_php.php looks like this:

<?php
/**
 * Best Seller Page
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * $Id: header_php.php 165 2008-03-21 04:21:50Z yellow1912 $
 */ 
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
$disp_order_default = PRODUCT_ALL_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$order_by = !empty($order_by) ? ','.trim(str_replace("order by","",$order_by)) : $order_by;

if (BEST_SELLERS_SHOW_OUT_OF_STOCK == 'true') {
    $listing_sql = "SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
                                    p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status,
                                    p.master_categories_id
                             FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             WHERE p.products_status = 1
                             and p.products_ordered > 0
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " . 
                             "order by p.products_ordered desc ". $order_by;
} else {
    $listing_sql = "SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
                                    p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status,
                                    p.master_categories_id
                             FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             WHERE p.products_status = 1
                             AND p.products_quantity > 0
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " . 
                             "order by p.products_ordered desc ". $order_by;
}

$listing_sql = $db->bindVars($listing_sql, ':languageID', $_SESSION['languages_id'], 'integer');

//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);

/*                         ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
    if ($value > 0) $column_list[] = $key;
}
?>

[LissaE]

Hi, I have two more questions for this mod LOL

1. the bestsellers page uses the same listing display as my categories which with the mod I am using for that is the columns, would it be easy enough to change it to use the same listing display as the All Products, New Products etc page and if so how do I make those changes?

2. Is it possible to have the individual products display how many times it has been purchased? I know this would have to pull up data from the database somehow, but I don't know how LOL

For example to have it like this:

1st column
Image

2nd column
Product Name
Price
Description
Purchased X times

Something like that?

[abcoombe]

Okay, I followed the directions posted, but my best sellers page is still showing ALL of my products, with my actual bestsellers appearing at the very top. I added in AND p.products_quantity > 0 at line 21 on my header_php.php file... Any other advice?

Thanks!

http://www.theshoppingboutique.com/?...e=best_sellers