How can I edit the bestsellers list?

[Guest]

Please direct me as to how to edit the best sellers area.

 

Thanks,

[Guest]

Edit What? which products are in the list? well you can monkey around with products_ordered field in the database to move things around.

 

I think their is a contrib. that helps you manage the bestsellers list but never used it.

[wondernet]

There's;

 

http://www.oscommerce.com/community/contributions,1884 - image instead of '01, 02'

 

http://www.oscommerce.com/community/contributions,508 - look like 'new products'

 

http://www.oscommerce.com/community/contributions,1231 - show prices

 

http://www.oscommerce.com/community/contributions,1944 - select products instead of actual ones bought

[Guest]

Can anyone tell me how to clear down the contents of the Bestseller box after testing tghe site. Need to start with an empty box before going live. Would rather not go tampering with the database backend just right now ;-)

[♥yesudo]

a store looks better with a bestseller list - so the site doesn't look empty.

 

otherwise i think the only way to do it is via db manipulation.

 

run this sql:

 

UPDATE `products` SET `products_ordered` = '0';

[Guest]

Yes I agree, but I just need to flush the fictitious data before I go live, and maybe replace it with more appropriate bestsellers. Is anything else dependent on that database table? Of not I'll try your fix.

 

Many Thanks!

[♥yesudo]

running that query will be fine.