Thread: Question about Storefront displaying items with less than 0 inventory

Our site is not showing items with less than 0 inventory. I need to fix this so it will show all items, regardless of inventory. I have tried all the suggestions in this older thread:

http://forums.aspdotnetstorefront.co...InventoryLevel

It doesn't matter what negative value I change on the HideProductsWithLessThanThisInventoryLevel AppConfig, items are still being hidden. How can I permanently disable this function?

Simply modify the stored procedure: aspdnsf_GetProducts, and disable the filter for HideProductsWithLessThanThisInventoryLevel and that's it...

Ok, now how do I do that?

It depends on the version of ASPDNSF you have. In version 8+ all the stored procedures in SQL are protected, so you can't just modify them. You'll have to open up the Create AspDotNetStorefront.sql script in your /db/ folder, find the stored procedure you want to modify, change the code, then execute only that portion of the script. I strongly recommend you just snip/copy/cut the code out of the script first, then modify and execute it.

In prior versions you could just modify the sproc in SQL Management Studio with the change Jao mentioned.