Excluding Products from Best Seller List

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
avalight Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-September-2007 Status: Offline Points: 3	Post Options Post Reply Quote avalight Report Post Thanks(0) Quote Reply Topic: Excluding Products from Best Seller List 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

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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? Edited by Hamish - 01-May-2008 at 3:19pm

Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply 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
	Espressotec Sales and Services

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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

Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply 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.
	Espressotec Sales and Services

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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.

Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply 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.
	Espressotec Sales and Services