Thread: Search for items not in inventory

In our store we are noticing the search wont list the item if the inventory is zero. Is there a appconfig parameter that we can set to remove this limitation. We want the product to be part of the search irrespective of the stock.

The default behavior of the stored proc that does the search "aspdnsf_GetProducts" by default filters out anything with zero or less. You can change this in one of two ways, either change the search XML Package to pass in an @InventoryFilter parameter with a value of -1 or you can change the Store proc to have a default value for the @InventoryFilter parameter of negative one.

Dusty
ASPDotNetStorefront Staff

I added a new input parameter @InventoryFilter to page.search.xml.package with a value of -1. Still it does not work. Here is the code:

Code:

     <![CDATA[
                exec aspdnsf_GetProducts 
                    @localeName = @locale,
                    @CustomerLevelID = @CustLevelID,
                    @affiliateID = @AffID,
                    @ProductTypeID = @ProdTypeID, 
                    @ViewType = 0,
                    @pagenum = 1,
                    @pagesize = 2147483647,
                    @StatsFirst = 0,
					@searchstr = @SearchTerm,
                    @publishedonly = 1,
                    @ExcludePacks = 0,
                    @ExcludeKits = 0,
                    @ExcludeSysProds = 1,
                    @InventoryFilter = -1
            ]]>

Any help?