Filter Item search results on inventory?

November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / Customized Commerce 14 /

Anders Kåre Olsen

Vote:

Hi Forum

Is there an easy way to search for items (products/variants) that are in stock in a specific warehouse?

We have multiple warehouses where items can be in stock, but in certain scenarios I only want to see items that are in stock in the local warehouse.

Based on this page, I can search for Variants that are available in a specific market:

var result = SearchClient.Instance.Search<VariationContent>() .Filter(x => x.AvailableMarkets().MatchContained(v => v.Value, "market"));

But what would I do, to search for items in stock on a specific Warehouse?

Thank you for your help.

Regards

Anders

#331891

Oct 24, 2024 7:50

Quan Mai

Vote:

if you install Find.Commerce, you can use Inventories() which is an extension method on IStockPlacement content (variant etc.)

#331897

Oct 24, 2024 9:06

Anders Kåre Olsen

Vote:

Yes, of course. I just needed to find the correct syntax for my query.

This seems to work just fine:

query = query.Filter(x => x.Inventories(), x => x.WarehouseCode.Match("XYZ") & x.InStockQuantity.GreaterThan(0));

#331899

Oct 24, 2024 10:24