Thread: How are products hidden if inventory threshold is flagged?

From what I understand, you can hide products if they fall below a certain inventory level threshhold.

What function is called to check this?

I have a custom product feed that I built, and right now it isn't hiding those products since the logic isn't in place.

The product list is generated on each entity page by executing the dbo.aspdnsf_GetProducts stored procedure, with a bunch of parameters (categoryID, pagesize, InventoryFilter, etc). Check out how we do that in the entity.*.xml.config XML packages for an example.

I'm running version 8 with no source code, it seems all the xml packages are using stored procedures which are locked?

I need to know whether I can include a product in a feed, right now I am doing:

C#/VB.NET Code:

 SELECT p.*,
       pv.*,
    FROM product p (NOLOCK)
        left outer join productVariant pv (NOLOCK) on pv.productID = p.productID
    WHERE 
        p.deleted = 0 AND pv.deleted = 0            -- delete
        AND p.published = 1 AND pv.published = 1    -- published 


This is currently returning products that have their inventory threshold set, so they should be hidden if inventory reachs x.

That's going to return everything that is published and not deleted, which is not how the software handles inventory hiding. You would have to modify that SQL query to look at the related product variant and check that Inventory > whatever # you want.

It'd probably be easier to use the same sproc we do in our XML packages, which'll return just what you're after. If you want to look at the 'innards' of those sprocs, you can unlock them with the directions here.