Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 General help me questions
 NavigateTopTen		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pelicanPaul
Starting Member

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

hi,

this subroutine
NavigateTopTen
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.

thanks,

Paul

Kidd
VP-CART Super User

Australia
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

pelicanPaul
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

http://www.hunterhouse.com/toptenraw1.asp

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

pelicanPaul
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

devshb
Senior Member

United Kingdom
1904 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:

http://www.bigyellowzone.com/shopexd.asp?id=105

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
Developer
[email protected]
www.BigYellowZone.com
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
0 Item(s)
$0.00
  • Your Cart Is Empty