Multi-Locations Low Inventory Alert

Nadav1
New Member
8 0 0

Hey there!


Im trying to use Shopify flow  to create an email notification for every time certain variant quantity is changing from 2, to 1. The difficulty is that i have 3 different warehouses, and I want it to be separated for each one of them.

That way, if a variant is low in quantity in only one of the warehouses, I will be notified that I need to transfer more of it to that warehouse. 

Is there any solution available with Shopify flow? or is there any inventory management systems recommended? 

 

Thanks!

Replies 10 (10)

paul_n
Shopify Staff
922 127 221

Search for "location" in the flow template library and you'll see a few patterns to use...it is possible, but the data is hidden a bit under variant / inventoryItem / inventoryLevels

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
Nadav1
New Member
8 0 0

Thanks!
Just to make sure, it takes the location from the item inventory fulfillment location?
I tried using it, but it seems that "location" refers to "product variant"/"inventory item"/ "inventory levels". Because the condition asks for at least on of the mentioned above name, even if a certain quantity went bellow the criteria I adjusted, it doesn't know where it went below the par levels because all of my products were available in a certain time in the 3 warehouses. Screen Shot 2023-08-27 at 10.28.25.png

paul_n
Shopify Staff
922 127 221

The "at least one" part is because "Levels" is a list where each item is the inventory for that location. So what you have in that image is correct. You would check that name and for the same inventory level you check the available amount. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
Nadav1
New Member
8 0 0

Because the "if" is for at least one of, it is not showing the correct location where the inventory levels went low, because the item is available in all of my warehouses, it is necessarily will use the first location in the flow as the one correct for the flow, because there is necessarily one of the products variant locations/levels for that location. 
I talked with Shopify support and it seems that currently there is no solution with Shopify flow. 

paul_n
Shopify Staff
922 127 221

I am not following your description of the problem here. Let's say you have 2 locations (A and B). Each location has it's own inventory. You want to check each separately. 

 

This is located at Product Variant / Inventory Item / Inventory Levels, which is a list. If you have 2 locations, it's 2 items in the list.

 

In a Flow condition you would check that a single inventory level has both the location name of A and the available quantity of 0 (or whatever number/operator you need). You for location B, you would add another condition, changing the location to B. This works - I've built it many times now. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
Nadav1
New Member
8 0 0

You are right. However, because each warehouse has the product in inventory, and the condition is that at least one of the product inventory levels/ variants/ inventory item is the location name, it doesn't matter in what location the product is went out-of-stock, because each of the location is going to be matched with that condition. Maybe can you share the flow template?  

paul_n
Shopify Staff
922 127 221
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
Nadav1
New Member
8 0 0

Hey Paul!
Thank you for your help, I tried using your template and it is indeed working very well. However, I did notice for one main issue, let me know what you think.
There can be a situation where an order is placed from a specific location, however there is low quantity in a different location. For example, today i issued that scenario. 

Location AProduct quantity - 1
Location BProduct quantity - 0
Location CProduct quantity - 9

Then, an order has been placed from Location C, and the product variant quantity changed. Because i set up the condition for quantity to be less than 2, I received a notification as there is a low quantity in location A, because he is the first location checked in the flow. In that issue, it wasn't a problem. But when there will be low quantity in two places, and one will go below the par levels, it may send me a notification for the location which is already low in quantity, and not the one that has been changed below the levels. I hope I'm describing the issue well enough..
I configured the conditions as you described:
Screen Shot 2023-08-30 at 15.55.51.png

Do you think there is any solution for this?
Anyway, thank you so much for your help, you already helped me a lot. 

paul_n
Shopify Staff
922 127 221

Yeah, in the template this is solved by storing the prior value of the inventory in a variant metafield and checking that value as well. Ideally this would be solved by having the event / trigger provide all of the prior location data. That may happen, but it's going to take awhile.  

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
Nadav1
New Member
8 0 0

Alright, Thanks!