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
Username:
Password:
Save Password
Forgot your Password?

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

candleash
Starting Member

USA
13 Posts

Posted - September 01 2009 :  23:15:25  Show Profile  Reply with Quote
Is there a way to run a report showing my top 10 selling products? I don't want to display the items on my home page I just want the report for myself. I looked in my admin area and in the help section but I couldn't find out how to do it.

Ashley

Agravane
Starting Member

34 Posts

Posted - September 10 2009 :  21:16:56  Show Profile  Reply with Quote
if your still looking for answer, let me know and ill write you an sql script to run
Go to Top of Page

candleash
Starting Member

USA
13 Posts

Posted - September 10 2009 :  21:24:59  Show Profile  Reply with Quote
Yes, I'm still trying to figure out how to run the report.

Ashley
Go to Top of Page

Agravane
Starting Member

34 Posts

Posted - September 12 2009 :  08:59:28  Show Profile  Reply with Quote
Hello,

From your admin page, click on SQL Queries, paste in the following query and run it.

SELECT TOP 10 products.cname, oitems.numitems FROM oitems INNER JOIN products ON oitems.catalogid = products.catalogid ORDER BY oitems.numitems DESC
Go to Top of Page

candleash
Starting Member

USA
13 Posts

Posted - September 24 2009 :  13:41:19  Show Profile  Reply with Quote
Thank you so much! I'll try it!

Ashley
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000