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
 Listing products by highest/lowest price first
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sabhuku
Starting Member

USA
22 Posts

Posted - December 23 2008 :  00:10:00  Show Profile  Reply with Quote
I am trying to find the top 100 most expensive items we sell on our website. When I log in to our admin pages, the "selection criteria" options are not giving me an option to accomplish this. Please help me out if you know of a way I can get this done. Thank you.

carfin
VP-ASP Expert

United Kingdom
948 Posts

Posted - December 23 2008 :  03:39:26  Show Profile  Reply with Quote
Hi,

if you go to Admin, View/Edit Products and click the Switch to Advanced search option you can type in the following SQL into the Query statement box:

SELECT * from products order by cprice DESC

This will display your products from highest price to lowest.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

Sabhuku
Starting Member

USA
22 Posts

Posted - December 23 2008 :  03:50:58  Show Profile  Reply with Quote
That worked. Thank you!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000