Excluding Products from Best Seller List
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=1581
Printed Date: 22-April-2025 at 3:48pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Excluding Products from Best Seller List
Posted By: avalight
Subject: Excluding Products from Best Seller List
Date Posted: 01-May-2008 at 12:27am
|
Hello everyone. I want to use the Best Seller feature of the PC, but I notice that accessory products will show up on the list as a best seller, when it merely an add-on and not really sold as a separate item. There is no way I can tell to exclude this from the best seller list, is there? If so, how? Thanks -------------  Curt
|
Replies:
Posted By: Hamish
Date Posted: 01-May-2008 at 3:19pm
| Hi Avalight, do you mean "BTO items" which I don't think would show up - or just low value items - or items in certain categories etc? Have you got a link to an example? |
Posted By: Espressotec
Date Posted: 02-May-2008 at 1:15pm
|
Well we do have low priced items, but we only want our espresso machines to be in the best sellers ------------- |
Posted By: Hamish
Date Posted: 02-May-2008 at 3:11pm
|
Hi, I think it would be a great feature to be able to select from the admin pages which categories are included or perhaps excluded from the best sellers. Perhaps a post in the "New Features" may get it added to EA's list - If it's not already there. In the absence of that the simplest way is to modify the SQL (on lines 102 & 104 in my V3.11 copy. You could either add a lowest price limit to the WHERE in the form of AND ((product.listPrice)>1000) - You'll have to play with the number to get what you want. OR limit it to certain categories in a similar fashion. Don't forget to keep a copy of the original file & keep a note of any changes you make. HTH Hamish |
Posted By: Espressotec
Date Posted: 02-May-2008 at 3:16pm
|
Thanks for the quick reply, the only problem is that some of our the parts we sell are more exspensive than some of the lower end machines so unless we can restrict this to categories, I don't think this trick would work for us, but thanks again. ------------- |
Posted By: katharina
Date Posted: 02-May-2008 at 3:39pm
|
You could use one of the other pages for it. The one called Featured Products or Specials, and don't use the best sellers. The best sellers is generated on how many have sold. It's sometimes bogus in my point of view. Example you sell a machine, and then people have to buy production parts for it. They will buy more production parts then machines, pushing the machines down on the best seller list. PC may should consider to offer a quantity set to modify the heaviness of a listing. For now this is what you can do. Use the featured items page, rename the button to "best sellers" and then select items you want to show on that page in stead. This gives you complete control of what is listed as best sellers. Katharina |
Posted By: Hamish
Date Posted: 02-May-2008 at 5:21pm
|
It's a good idea and a very good point Katharina & I can see why it's often the best approach. I took a look and see that espressotec is already using showspecials as well as showbestsellers. Espressotec - You could focus your showspecials as Katharina suggests - which is definitely the quickest and cleanest solution, or, if you wish to keep both, do you have a (hopefully short) list of the categories (numbers) you wish to select best sellers from? If you go for the former you could, to make it look as "legit" as possible, take a copy of showspecials & call it, say, viewBestSellers.asp, althogh few customers are likely to either notice it in the url, or realise the difference, especially if you pick out your best selling machines which is what your trying to achieve anyway. |
Posted By: Espressotec
Date Posted: 05-May-2008 at 2:13pm
|
Thank you for all you suggesstions. Currently we are swamped, and so is our web designer, so this will be done later on. ------------- |