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
 VP-ASP 7.0 Questions
 Display List of ''Hidden'' Products
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cps
VP-ASP New User

South Africa
69 Posts

Posted - September 12 2012 :  07:28:11  Show Profile  Visit cps's Homepage  Reply with Quote
I need to print a list of hidden products loaded onto my website. I'm having a bit of trouble - I clicked on Store > Products and then entered the 'Selection Criteria' as 'Hide' contains 'Yes'. Nothing comes up and I know there are definitely hidden products as I did a test by deliberately hiding products and checking to see if they come up on the list.

Am I doing something wrong - is there another way of displaying a list like this?

www.thecpswarehouse.co.za

manilow
VP-ASP New User

France
106 Posts

Posted - September 13 2012 :  02:42:39  Show Profile  Visit manilow's Homepage  Reply with Quote
To filter all hidden products, use the following query string :

SELECT * from products Where hide order by catalogid ASC

Or to filter all other products :

SELECT * from products Where Not hide order by catalogid ASC

Erik
www.AquaThermia.com
Go to Top of Page

carfin
VP-ASP Expert

United Kingdom
948 Posts

Posted - September 13 2012 :  04:50:39  Show Profile  Reply with Quote
Hi,

use selection criteria hide = -1
(that's minus one)

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000