VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

31 Posts

Posted - February 15 2007 :  16:05:10  Show Profile  Visit pelicanPaul's Homepage  Reply with Quote


this subroutine
does not work correctly.

I have products with subproducts but all it is showing is the first sold product.

Access DB.

see: http://www.hunterhouse.com/topten.asp

I took it out and am displaying on a separate page.

has anyone run into this or delt with this sub... it has a lot of conditional for types of DB and all and is a bit hard to follow.



VP-ASP Super User

373 Posts

Posted - February 15 2007 :  22:17:46  Show Profile  Reply with Quote
do you mean its only showing the parent product instead of the sub?

how many orders have you got on your stores?
Go to Top of Page

Starting Member

31 Posts

Posted - February 16 2007 :  11:04:20  Show Profile  Visit pelicanPaul's Homepage  Reply with Quote
check it out. here is a list of products sold and gives you a sum of what is sold. the shop is brand new so not very many numbers but there are some


the sql is

SELECT TOP 10 oitems.catalogid, Sum(oitems.numitems) AS sumofnumitems, products.cname, products.cdescription FROM orders, oitems INNER JOIN products ON oitems.catalogid = products.catalogid WHERE (((orders.orderid)=[oitems].[orderid])) GROUP BY oitems.supplierid, oitems.catalogid, oitems.unitprice, products.cname, products.cdescription ORDER BY Sum(oitems.numitems) DESC;

Go to Top of Page

Starting Member

31 Posts

Posted - February 16 2007 :  11:12:36  Show Profile  Visit pelicanPaul's Homepage  Reply with Quote
so the script NavigateTopTen

only shows one item and it happens to be the first sold.

Go to Top of Page

Senior Member

United Kingdom
1898 Posts

Posted - February 16 2007 :  11:22:13  Show Profile  Visit devshb's Homepage  Reply with Quote
yep; there are loads of ways to do what you're after; tweaking the existing top-ten-sql, creating your own, or, you could try our product-showcase function which includes a top-seller list (among millions of other things), it also allows you to use context (category) sensitive top-sellers if you want:


also, check the stock-level and hide-flags for the sub-products; it might be those which are stopping them from displaying on the normal vpasp top-sellers.

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons

Edited by - devshb on February 16 2007 11:26:07
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000