Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Hidden products

  1. 10-22-2009, 04:05 AM #1
    newtothis is offline Senior Member
    Join Date
    Mar 2009
    Posts
    200

    Default Hidden products

    Hello,

    When we are temporarily sold out of a product, we will hide it.

    Is there anyway we can run a report to see which items are hidden? Its very hard to keep track of them otherwise.

    Many thanks
  2. 10-22-2009, 05:36 AM #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Sure, you can run these scripts to view the hidden products and variants:
    Code:
    select * from Product where Published = 0
select * from ProductVariant where Published = 0
    You can use the Custom Report and use each script as value for the SQLCommand parameter.
    Last edited by Jao; 10-22-2009 at 07:31 AM.