Check Inventory Quantity for a Specific Inventory Location

[ali303]

Hi. I run a store which holds physical stock and fulfils the vast majority of our orders from a single UK warehouse. However, we have multiple Locations setup on our store so that we can check and display the live inventory from some of our main suppliers that are provided via various API feeds from their end.

The main problem I am having is setting up various Flow automations that only check the inventory level at our UK warehouse Location, and ignore the inventory levels at all other Locations.

For example, one our suppliers has thousands of SKUs. We hold a lot of their stock here in the UK warehouse (with availability displayed on our front end product pages as “UK warehouse”). However, for SKUs that we don’t have physically have stock of, we display the inventory availability at the supplier’s warehouse to inform customers that they can still order these items, but there might be a little wait for them while we order the item(s) in especially for them (availability is displayed on our front end product pages as “our EU warehouse”).

The primary Flow I am trying to create is one that recognises that these special order items have arrived at our UK warehouse (i.e. stock is booked in via a Transfer) from the supplier’s warehouse, but in doing so ignores the supplier’s warehouse live stock level (which is almost always greater than zero). This Flow would then notify our warehouse team that the inventory has arrived and is then queued for dispatch to the customer later that day.

For example, once the inventory Transfer is booked in, the Flow would need to check:

Inventory Quantity at our UK warehouse only is greater than or equal to zero.

So far, no matter which lineItems field I try to use on Flow, it factors in the inventory of the variant at all Locations when checking this availability. As a result, if the supplier has stock but we do not, the variant is still marked as available due to the overall inventory quantity being greater than zero (i.e. if our inventory is -1 and the supplier’s is 20, the overall inventory quantity is 19).

So far, what I have been able to come up with is:

“line items item fulfillment service location name is equal to UK Warehouse”

“inventory levels item location name is equal to UK Warehouse”
“line items item variant inventory quantity is greater than or equal to 0”

It is the final line that seems to be causing issues, as the Flow activity log shows that this line is checking the total inventory quantity available, as opposed to the inventory quantity at the item location of “UK Warehouse”.

Apologies if I’ve written this in a way that sounds more complicated than it is! I am sure there is a straightforward answer (i.e. a field or variant that I have missed) and I would imagine that a solution to this issue would be quite useful for shop owners who allow customers to back order items that are only available at supplier warehouses, as opposed to the shop owner’s warehouse.

Thanks in advance for any help or suggestions!

[DaveMcV]

Hi Ali303,

I reached out to you privately to ask for some more context to help debug this.

Thanks!

[gentryalan]

Were you able to find a resolution for this? I have a similar situation for a store in NY with multiple warehouses and a store.

[paul_n]

There are a lot of different ways that merchants might want to manage low stock or out of stock processes in their store. We recently published a new template to the Flow Template Library that shows how to show and hide products if all of its variants are out of stock at a single location. It makes use of a tag to track whether it was already out of stock, and then you can check the current inventory using Flow’s conditions. This template can be adapted to fit any number of scenarios.

[DariusWS]

@paul_n Thank you! It was exactly what I was looking for.

P.S. Url doesnt work

[paul_n]

Great. About the URL, what didn’t work? It does require you to login to
your store and if you have multiple stores to choose a store. Once you do
that, it should open the template library in Flow to that template.

[DariusWS]

My fault. That shop didn’t have FLOW APP. So url was not informative: There’s no page at this address.

[DariusWS]

@paul_n Another issue I found using FLOW app. When using same template you shared I would like to make multiple warehouse check. For example if qty in warehouseX is 0 and warehouseZ is more then 0 add tag. Simple task, but… App Freeze each time try to add extra condition. No error msg, nothing. It is problem with my account permissions maybe? Could you help? store: worldcondomsstore

[cybko]

No matter what I do, whether I try “start with” or put the whole name in, it always fails the condition

I’ve asked it to look at ones beginning with Y, it finds one beginning with Y but still marks it as false

[paul_n]

Most likely you’ve set up some other part of your condition incorrectly. I can’t tell though because there isn’t enough detail in your post. If you could provide a screenshot showing all of the condition that would be helpful, along with what your data looks like.

[cybko]

You were right. I flipped some conditions around and it fixed it. I edited my reply as the example I put in was a working version.

[USAToolDepot]

Can you link the new template again. The current link is broke.

[paul_n]

For these links with v2 in them, just remove the v2/:
Instead of :

https://shopify.com/admin/apps/flow/web/v2/editor/templates/f310fc68-64c7-4234-91ea-888555a3ab8e

Use :
https://shopify.com/admin/apps/flow/web/editor/templates/f310fc68-64c7-4234-91ea-888555a3ab8e

[cheyenne_ecomm]

I realize this is an old thread, but I struggled with a similar issue and finally found a solution that may help. I figured out how to send an internal email notification when at least one location (of several) has fewer than X units of a product variant in stock. The email also prints the inventory breakdown by location for that specific product variant, looping through all of the locations you want to check. Sharing here in case it helps someone else and saves them time!

Flow config:

Code for Message body of internal email alert:

Show More

{%- assign location_ids = “gid://shopify/Location/32270856,gid://shopify/Location/73659416765” | split: “,” -%}

At least one warehouse has less than 20 units of the below SKU available in stock, please check.

SKU: {{ productVariant.sku }}

Product: {{ product.title }}

Variant: {{ productVariant.title }}

{% for location_id in location_ids %}
{%- assign matched_quantity = “” -%}
{%- assign location_name = “” -%}

{% for inventoryLevels_item in productVariant.inventoryItem.inventoryLevels %}
{% if inventoryLevels_item.location.id == location_id %}
{%- assign matched_quantity = inventoryLevels_item.available -%}
{%- assign location_name = inventoryLevels_item.location.name -%}
{% endif %}
{% endfor %}

Location: {% if location_name != “” %}{{ location_name }}{% else %}Not Found for ID {{ location_id }}{% endif %} - Inventory Quantity: {% if matched_quantity != “” %}{{ matched_quantity }}{% else %}N/A{% endif %}

{%- unless forloop.last -%}

{%- endunless -%}
{% endfor %}

Note:

• Replace the location IDs with the locations you want to check, add more if necessary
• Edit alert message “At least one warehouse…” to suit your use case