Printable View
We already have 2 "best sellers" mods:
1. Display the best sellers items on the side box.
2. Display them on the main page
None of those suit my need, so I modify it a bit a make a best sellers page that can be accessed at ?main_page=best_sellers. This one also shares the same layout with product_listing.
Let me know if you want it, otherwise I don't have to waste my time and post some thing no one needs.
Hello there,
I think this is a great idea for a mod. I would find use for it. I am using a couple of your mods at the minute, so I will send you some readies when I can as I have found them beneficial.
Regards,
Heathenmagic:smile:
Hello there,
I think this is a great idea for a mod. I would find use for it. I am using a couple of your mods at the minute, so I will send you some readies when I can as I have found them beneficial.
Regards,
Heathenmagic:smile:
This mod will create a best-sellers page that can be accessed at ?main_page=best_sellers
Unlike the "best sellers reloaded" mod, this one does not have its own template, it uses the product_listing template (the template used for listing category products)
The reason for that:
1. It keeps the mod extremely light weight.
2. Keep the listing consistent with the product_listing.
You can download it at the download section (waiting for approval) or at my svn server:
https://svn.rubikintegration.com/zen...t_sellers_mod/
Cool. This will allow removal of the Best Sellers sidebox and instead put up a link to the new Best Sellers page in both the Information sidebox and the header drop down menu. Let us know when it gets posted to ZC downloads area. Can't wait to try out.
Woody
Might want to add following to best_sellers.phpQuote:
You can download it at the download section (waiting for approval) or at my svn server:
https://svn.rubikintegration.com/zen...t_sellers_mod/
Apart from that..Code:define('TABLE_HEADING_IMAGE', 'Image');
define('TABLE_HEADING_PRICE', 'Price');
Downloaded, tested, works fine.. thank you.
:thumbsup:
Ah, actually it's because I use a custom template which does not use those fields.^^
Link in download section:
http://www.zen-cart.com/index.php?ma...roducts_id=728
great mod! works great, thank you! :)
I think that this is an excellent mod. Can you tell me how to get the "Best Sellers" to show on the breadcrumbs and the title of the page?
Thanks
bigjoed,
For breadcrumbs - add this to the top of: includes/modules/pages/best_sellers/header_php.php
Hope this helps,Code:$breadcrumb->add(TABLE_HEADING_BEST_SELLERS);
I want to place the link to this bestsellers mod in the "our products" sidebox along with the "new products", "featured products" and "all product" links.
Can anyone advise how i do this please.
I have installed it and workes great, except .. well check it out
http://rcnut.com/best_sellers
on the top of the items list it shows
instead ofQuote:
TABLE_HEADING_IMAGE TABLE_HEADING_MODEL Item Name TABLE_HEADING_MANUFACTURER TABLE_HEADING_PRICE Stock.
Any ideas ? :/Quote:
Product Image Model- Item Name Manufacturer Price Stock.
The definitions for those are missing, you can edit your language file to fix it.
Thanks, I added those to best_sellers.php and that fixed it
but I still having a small problem, chek the page, the defenitions and descriptions below dont line up, I have an extra one "Model" that does not show, and that trows the rest off
Open includes/modules/pages/best_sellers/header_php.php, replace the content by:PHP Code:<?php
/**
* Best Sellers Alpha 1
*/
if (BEST_SELLERS_SHOW_OUT_OF_STOCK == 'true') {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
order by p.products_ordered desc, pd.products_name";
} else {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
and p.products_quantity > 0
order by p.products_ordered desc, pd.products_name";
}
$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;
}
?>
whoohoo :)
Thank you, that fixed it. looks GREAT
Thank you for the wonderful mod!
I was wondering if there would be any way to limit the results to a certain number of products. For example, my best sellers page lists a total of 1288 products, 15 per page. Instead of having so many products listed on that page, could I make it so that the results only give the top 50 best sellers?
You can edit includes/modules/pages/best_sellers/header_php.php and put LIMIT into the sql query.
Thank you for your reply. I did figure that much, but my problem is that I do not know this programming language. Rather than come here immediately for answers, I tried to solve this on my own by entering LIMIT into the dev tool kit for ideas on how it is used. I saw several examples in other Zen files, although when I tried editing the header.php file on my own, I received errors every time. I even Googled SQL limit query and saw similar examples, but of course they don't work when I try them. If anyone knows how to set a limit of 50 results for the following, your help would be greatly appreciated.Quote:
Originally Posted by yellow1912
Code:if (BEST_SELLERS_SHOW_OUT_OF_STOCK == 'true') {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
order by p.products_ordered desc, pd.products_name";
} else {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
and p.products_quantity > 0
and p.master_categories_id != 123
and p.products_id != 1992
order by p.products_ordered desc, pd.products_name";
}
$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;
}
?>
PHP Code:
$limit = " LIMIT 50";
if (BEST_SELLERS_SHOW_OUT_OF_STOCK == 'true') {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
order by p.products_ordered desc, pd.products_name $limit";
} else {
$listing_sql = "select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . 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 = '" . (int)$_SESSION['languages_id'] . "'
and p.products_quantity > 0
and p.master_categories_id != 123
and p.products_id != 1992
order by p.products_ordered desc, pd.products_name $limit";
}
$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;
}
?>
Thanks for the help, but I receive the same error I was getting before:
"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 15' at line 10
in:
[select distinct p.products_quantity, p.products_id, p.products_image, p.products_model, pd.products_name, p.products_ordered from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_quantity > 0 and p.master_categories_id != 123 and p.products_id != 1992 order by p.products_ordered desc, pd.products_name LIMIT 50 limit 0, 15]"
The setting I have in the admin for product listing per page is 15. I suppose the product listing page and the best sellers page don't like competing over limits! If its an easy fix, then by all means feel free to let me know, but if its going to be a time-consuming pain, please don't hesitate to ignore me! It's not a huge deal or anything. :smile:
I have a new site with no best seller history. My vendor has a best seller list, which is called from the main db on their site and is the same db that I use. Mine is a dupe of theirs, but on my server.
Is it possible to create a best sellers Product Listing on the Home page that would have a different layout from the other product pages and would call from the main db?
I'm not good at databases, so I don't know if I would have to manually add these products and links or just what. Suggestions?
Ref: http://artbeautiful.com
@JackA: Check Best Seller reloaded mod.
@craftzombie: This mod simply queries all products, sort them by number of purchased.
To make it light weight, I used the product listing template, so adding a limit into the query seems to break things a bit. It's not that hard to fix, it's rather complex and I want to leave it there for now.
Hint: you can either:
1. check the code of ZC featured product listing or all product listing and copy it.
2. Overwrite includes/modules/product_listing.php
Since I have no clue how to go about doing what you suggested, I decided to be sneaky and I did this instead:Quote:
Originally Posted by yellow1912
1. Made a copy of tpl_modules_product_listing.php and renamed it tpl_modules_product_listing2.php
2. changed tpl_best_sellers_default.php to show tpl_modules_product_listing2.php
3. removed productsListingTopNumber and productsListingListingTopLinks from tpl_modules_product_listing2.php and replaced them by manually adding links to
main_page=best_sellers
main_page=best_sellers&page=2
So now I am only showing them 30 of the bestsellers, even though the file is actually bringing up over 1200. Unfortunately, by doing it this way you cannot tell which page you are on unless you look at the web address in the top of your browser. But with only 2 pages, I don't think thats a big deal.
Its enough to make me shut up about this and move on to something else!
Thanks for all of your help.
Hi, thanks for what looks to be a cracking mod. Just what the doctor ordered. But I wonder if anyone who is a bit more technically minded than me can tell me in what file do i need to place the - <?php echo zen_href_link(FILENAME_BEST_SELLERS); ?> - so that the link for the page appears at the bottom of my categories sidebox under the rest of the categories?
Thanks for any help
dave
Try this...Quote:
Originally Posted by barricades
in includes/templates/your_template/sideboxes/tpl_categories.php
directly underneath
$content .= '<a class="category-links" href="' . zen_href_link(FILENAME_SPECIALS) . '">' . CATEGORIES_BOX_HEADING_SPECIALS . '</a>' . '<br />' . "\n";
add:
$content .= '<a class="category-links" href="' . zen_href_link(FILENAME_BEST_SELLERS) . '">' . Best Sellers . '</a>' . '<br />' . "\n";
This will probably only work if you have specials set to "true". If you don't, then you can add it underneath one of the other sections like New Products. I tried adding it on its own, but I kept getting a blank page. I don't know enough PHP to figure out how to do it any other way, but this is the way I have it on my page and its working fine.
Thanks. I've tried that but i get Parse error: parse error, unexpected T_STRING etc...
The place I put it in is:
if (SHOW_CATEGORIES_BOX_PRODUCTS_ALL == 'true') {
$content .= '<a class="category-links" href="' . zen_href_link(FILENAME_BEST_SELLERS) . '">' . Best Sellers . '</a>' . '<br />' . "\n";
$content .= '<a class="category-links" href="' . zen_href_link(FILENAME_PRODUCTS_ALL) . '">' . CATEGORIES_BOX_HEADING_PRODUCTS_ALL . '</a>' . "\n";
}
I just copied and pasted the code you told me to, but I know very little about php. Have i missed something obvious?
Thanks for replying
Sorry about that. Its the space between Best and Sellers. Do this instead. The placement you have underneath New products is fine, just change it to this instead:Quote:
Originally Posted by barricades
Where it says Best Sellers, change it to CATEGORIES_BOX_HEADING_BEST_SELLERS
so it will look like this:
$content .= '<a class="category-links" href="' . zen_href_link(FILENAME_BEST_SELLERS) . '">' . CATEGORIES_BOX_HEADING_BEST_SELLERS . '</a>' . '<br />' . "\n";
Then open up includes/languages/your_template/english
and add
define('BOX_HEADING_BEST_SELLERS', 'Best Sellers');
define('CATEGORIES_BOX_HEADING_BEST_SELLERS', 'Best Sellers');
preferably near the other ones (New Products, Specials, etc.) just to keep things organized. In my file, those start at around line 87. I think you can put it anywhere though, I'm just being anal.
(You can do all of this, or you can keep it the way you have it and make Best Sellers into one word and you won't get the error anymore)
Woo Hoo! Thanks for that CraftZombie. That seems to have done the trick.
The only thing wrong now (which i suppose isn't that important) is that the images on the bestseller page now kinda cover a wee line I had.
normally the page displays like this http://www.traditionalirishgifts.com...dex&cPath=2_20
but on the bestsellers page the images cover the line btw the sideboxes and the main page http://www.traditionalirishgifts.com...e=best_sellers
Is there an easy way to fix that?
Thanks for all this
You can try adding this to your css file:Quote:
Originally Posted by barricades
#productListing {margin-left: 1em; }
Although this will move over the products just a little bit on the rest of your pages too because the Best Sellers page uses the same template and has none of its own id's or classes (as far as I know).
If 1em isn't enough, just keep increasing it a little (1.1, 1.2, etc.) until you can see the line and then check your regular product pages to see if it looks okay too. I'm not the best when it comes to CSS!
That worked great. Thank you so much. I'm still learning (only been at this since the summer) so it's great that the kind people on this forum are patient and willing to answer what must be, for them, simple questions.
thanks
craftzombie
No problem! I've been at it for a year and a half now and I'm still learning too. :smile:Quote:
Originally Posted by barricades
hi guys, i have a question
1)how can i change products in bestsellers? where do i must change that?
2) how do i proper install that mod? just replace the files?
co13
1 - not sure what you mean, can you explain
2 - there is a readme file in the mod files when you download it. Follow that. You won't actually be replacing files but it will add extra files into some already existing folders
The purpose of this mod is to show the best sellers. It is pulling the top selling items from your database. If you want to show specific products, maybe you should use Featured Products instead. For best sellers, you can exclude certain products from appearing, but I don't believe you can choose which products appear. If you do not have a lot of products, I suppose you can exclude a bunch of them to obtain your goal, but thats too much work when you can just use Featured Products instead.Quote:
Originally Posted by co13
thnx, i should use featured prods instead, ... i have tryied but no solutions, it was put by default some best sell prods, dont know how to delete or change the more selled prods
it took some doing and adjusting, but I got the page and a link to it working well. Good show on this - hope to see it continued and cleaned up, made a bit more out-the-box easy.
hi,
i've installed this mod and it works great except for one thing, The headings, which work as a filter on the normal products page just appear as text in the best sellers page.
Any idea how I can make these work correctly on this page ?
Thanks
Rachael
Do have a link? I'm a little confused by the "headings, which work as a filter" statement. Do you mean in terms of search engines and font size or am I just barking up the wrong tree??Quote:
Originally Posted by rlparker
hi,
on the normal categories the table headers (product name, manufacturer etc) work as filters for the search results. e.g to order by lowest price
http://absholdings.bpweb.net/index.p...=index&cPath=2
On the best sellers page they are just plain text and no longer work as filters
http://absholdings.bpweb.net/index.p...e=best_sellers
hope that makes more sense!
You may want to try the latest version here:
https://svn.rubikintegration.com/zen...t_sellers_mod/
Glad to have this mod. Here's a couple of things I found:
1. The "languages" is named "laguages" so add an n to correct:
2. here's the info for the best_sellers.ph p file to add manufacturer, image and price.
<?php
/**
* Best Sellers Alpha 1
*/
define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');
define('FILENAME_BEST_SELLERS', 'best_sellers');
define('BEST_SELLERS_SHOW_OUT_OF_STOCK', false);
define('TABLE_HEADING_BEST_SELLERS', 'Best Sellers');
define('TABLE_HEADING_IMAGE', 'Image');
define('TABLE_HEADING_PRICE', 'Price');
?>
Also, not sure how to fix but the manufacturer header appears without the manufacturer being listed underneath.
Try the newest version:
https://svn.rubikintegration.com/zen...t_sellers_mod/
Hello,
Is there a coming soon version or can I turn this into coming soon?
Thx
Is there a zipped version of this?Quote:
Originally Posted by yellow1912
No, not now.
I was having the same problem and used your solution with a minor edit and it worked great for me. I completely removed the productsListingBottomNumber and productsListingListingTopLinks (as well as the BottomNumber/Links) and now it displays just one page with my top 15 Best Sellers.Quote:
Originally Posted by craftzombie
I also made another small change and made the Best Sellers sidebox header a clickable link leading to this page like Featured Products and New Products.
To do this, go to:
/public_html/includes/modules/sideboxes/best_sellers.php
FIND (on or about line 75):
$title = BOX_HEADING_BESTSELLERS;
ADD AFTER IT:
$title_link = FILENAME_BEST_SELLERS;
Works like a charm!
Great mod! Many thanks to yellow1912! :thumbsup:
Can i have the top 100 only?
sidebox images are not showing on clients website. How can I fix this?
Thanks!
www.designerfaves.com
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.
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.Quote:
Originally Posted by davidrushton
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
Just to let everyone know this was a simple fix once I thought about it properly LOL
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 :)Code: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
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
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
How to "limit". Please. This show me all of the products in shop.
adamlop:
You will also need to add in the same line around line 20 so that your header_php.php looks like this:Quote:
Originally Posted by christon26
PHP Code:<?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;
}
?>
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?
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
I'm sorry, I think I made a booboo in my posts LOL, the line I added apparently was
and p.products_ordered > 0
And because I have stock/quantity disabled, I didn't add it in the second section, I think the products quantity was already there maybe? If you add the above line to both sections, as highlighted it should work for you
A tiny bit of knowledge mixed with blonde can be dangerous it seems LOLCode: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_ordered > 0
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;
}
Can one of the mods maybe go back and edit my previous post on this or delete it?
:blush:
That worked, thank you!
You're welcome :D
Has anyone figured out a way to show a specific number of best sellers? I would only like to show 10 on the page at all times.
The best sellers page uses the same display as the categories, and in my store at least lol it displays the same amount of products as my categories, so I *think* it depends on how many you have set in admin for categories to show.....but I could be wrong :)
There isn't anywhere in admin to set the number of best sellers showing on this mod. It will be some type of code modification. There was some discussion on it earlier in this thread but nothing in any of those threads did the trick for me.
I would like for this page to only show the top 8 sellers. Currently it shows every product in my store which makes the page useless.
I updated the module to add these features:
1. Only list products that have been sold (thanks to christon26)
2. Include sold out products switch now moved to admin
3. Allow setting the maximum number of best sellers listed. Please note that this number can NOT be less that the number of products listed per page, so say if you have 20 products listed per page then the minimum number can only be 20 (this is due to the fact that this module use the product listing template)
Enjoy
Too cool I get a lil mention (blushes from someone who generally has no idea what she's doing), thanx! LOL
If anyone is interested, I decided that I didn't want my freebies listed in the bestsellers as they were 'bought' so many times they all went to the top LOL so I added the following in under my previously posted addition in both relevant sections:
Code: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_price > 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_ordered > 0
and p.products_price > 0
I updated this module once again. Now it will correctly show the number of pages of best sellers (for example, if you set max to 10, and you have 10 products per page then it wont display all the 1.2.3.4.5.... page)
http://public.rubikintegration.com/
Thanks...very useful update to your excellent script
:clap:
You are welcome. And BTW I realized that I missed an important switch in the package I posted last night, so if anyone of you download it last night, please re-download it.Quote:
Originally Posted by misty
Hello,
Thanks for the mod. I downloaded and installed the latest version and changed the limit to 100 but there are no link to view the other products. It only shows the first 12 (the amount set in maximum values for product listing)
Thx
hello,Quote:
Originally Posted by yellow1912
what happens if you set it to 50 best sellers and you have 10 products per page? shouldn't it display page 1.2.3 etc. coz im not getting that at the moment?
thx...
i cant get this light mod to work correctly.
its not fitting in my main area and its not bring in the headers. please see here.
http://www.rubberduckbathrooms.co.uk...e=best_sellers
anyhelp would be greaful. i have defo uploaded the files. this is 1.3.7
I am using the apple zen template, when the best sellers page is viewed it moves my right boxes to bottom of page. plz help
http://www.2antioch.org/store/index.php
jettrue that made the apple zen template said this about my problem"Quote:
Originally Posted by nikki72
"It's not apple zen, the people who designed those mods probably forgot to wrap the pages correctly with the centerColumn wrapper. I've seen it happen a lot."
She must be real busy and hasn't had the time to give me the fix. Does anyone here know how to fix this issue?
thanks
You are missing the define statements for you TABLE_HEADING_IMAGE and TABLE_HEADING_PRICE, uses the developers tool kit in admin to search for those terms then edit the file for the best seller. Hope that helpsQuote:
Originally Posted by kitcorsa
Is there anyway to make this mod show best seller separated by Categories?
We have several categories and would like to display them separated.
i uploaded all the files as instructed, is their a missing file in the download or something??Quote:
Originally Posted by lextechs
i cant see why it isn't working
Files don't always transfer properly. The file in question is best_sellers.php that is located in includes\languages\english or includes\languages\YOUR_TEMPLATE\english.Quote:
Originally Posted by kitcorsa
Maybe you forgot to upload it to your template folder????
Hello yellow1912,Quote:
Originally Posted by yellow1912
Can you please upload the mod file again? I cannot find any place to download it.
Thank you in advance.
Hello,
I wonder if someone out there knows how to modify the sidebox best sellers.
In best sellers sidebox I want only the top 5 to be shown.
I have search the admin area but cant find any settings to modify this.
Help needed, thanks in advance
//Jolas jolas
I have best sellers installed and working, but I would like to change it to be a "hot items". In theory I should be able to modify the SQL statement in header_php.php to limit the query the number of sales in the last 30 days. Unfortunately I have no idea how to do that. Anyone know how?
I found a way to limit it to the last 30 days. The code works, but I would greatly appreciate someone looking at it and maybe cleaning it up or optimizing it a bit. Here is the resulting header_php.php
Code:<?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));
$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 orders o, orders_products op, products p, products_description pd, manufacturers m
WHERE o.orders_id = op.orders_id
AND op.products_id = p.products_id
AND p.products_id = pd.products_id
AND p.manufacturers_id = m.manufacturers_id
AND p.products_status = 1
AND TO_DAYS(date_purchased) >= (TO_DAYS(NOW())-60) GROUP BY op.products_id ORDER BY SUM(op.products_quantity) desc";
$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;
}
?>
I'm working on a simple module that loads the best sellers from a given category from the previous x months. Here is the SQL query:
The issue I am having is that if a product is linked, it doubles up the products_ordered. Any fresh eyes see the mistake?PHP Code:SELECT DISTINCT (p2c.products_id), SUM( op.products_quantity ) AS products_ordered, pd.products_name, p.products_image
FROM products_to_categories p2c
LEFT JOIN orders_products op ON ( op.products_id = p2c.products_id )
LEFT JOIN orders o ON ( o.orders_id = op.orders_id )
LEFT JOIN products_description pd ON ( pd.products_id = p2c.products_id )
LEFT JOIN products p ON ( p.products_id = p2c.products_id )
WHERE p.products_status =1
AND pd.language_id = '1'
AND (o.date_purchased >= '2010-03-12'
AND o.date_purchased <= '2010-05-13')
AND p2c.categories_id
IN ( 8, 6, 10, 11, 12, 4, 7, 9, 13, 5 )
GROUP BY p2c.products_id
ORDER BY products_ordered DESC , products_name ASC;
If anyone was wondering how to do this, the following query worked:Quote:
Originally Posted by numinix
PHP Code:SELECT DISTINCT (p2c.products_id), SUM( op.products_quantity ) AS products_ordered, pd.products_name, p.products_image
FROM products_to_categories p2c
LEFT JOIN orders_products op ON ( op.products_id = p2c.products_id )
LEFT JOIN orders o ON ( o.orders_id = op.orders_id )
LEFT JOIN products_description pd ON ( pd.products_id = p2c.products_id )
LEFT JOIN products p ON ( p.products_id = p2c.products_id )
WHERE p.products_status =1
AND pd.language_id = '1'
AND (o.date_purchased >= '2010-03-12'
AND o.date_purchased <= '2010-05-13')
AND p2c.categories_id
IN ( 8, 6, 10, 11, 12, 4, 7, 9, 13, 5 )
GROUP BY p2c.products_id, p2c.categories_id
ORDER BY products_ordered DESC , products_name ASC;
You are hard coding the categories_id rather than pulling dynamically pulling from a Top Level category to grab all of its kids and get them that way?
Or you don't care about being dynamic and just want the few listed categories_id used?
That list is created dynamically in PHP. I was just showing the raw SQL query so it would be easier to read and test using PHPMYADMIN.Quote:
Originally Posted by Ajeh
Does anyone have a link to the zip file in which the page num issue was fixed?Quote:
Originally Posted by yellow1912
Anyone? :(
http://www.zen-cart.com/index.php?ma...roducts_id=728Quote:
Originally Posted by www.heymama.ie
hi my site is on zen cart version 1.39h i have installed the bestsellers page.but it is not showing any product it just shows TEXT_NO_PRODUCTS the link is http://www.mol wa.com/index.php?main_page=best_sellers can any one help..thanks in advance.
Hi, is this module on the plugin page still compatible with the latest zen cart v1.5.1?