How can I automate product tagging by location in my warehouse?

[BigLaCroix]

Hi there Shopify Wizards and people with questions alike!

I'm working on putting together an automated system that will tag products in our Warehouse with an appropriate tag. When I tried using the search bar for "location", "Inventory", or "single-location", I wound up falling into a seemingly-endless trail of more columns. 

I want to know if it's possible to create a flow automation that will:

Look at the inventory of a product ONLY at a single location (Warehouse) and if it's got inventory in stock at Warehouse, it will add the tag "_Warehouse" to the product. if the Inventory at the warehouse for that product, and all of it's variants is 0, that the same tag would hopefully be removed by the same flow. 

If anyone could direct me to what the correct condition setup might look like, that would be extremely helpful. I'm really new to Flow so any other tips that you've learned that you might be willing to share would be extremely appreciated!

Thanks!

-Big LaCroix

[paul_n]

We have a template that shows how to use inventory locations in conditions:

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

[BigLaCroix]

Hi Paul,

I noticed that this exists, but when I've tried using it in practice, but my issue that I've found is that it only seems to work under the circumstances that the item only exists in the warehouse. When I've attempted to run it in practice, what it seems to do (according to the activity log and step by step process it shows me in Flow), is that it checks across all 5 of our stores, and makes sure that the inventory is at least greater than 0 in any of the stores, and then the next step checks to make sure that one of the locations is named warehouse, and if both are true it will add the tag. This is not what I want. What I was hoping for is that it would check the SPECIFIC inventory at just the warehouse, and let me know if that value is above 0, by adding a tag to it. 

Let me know if I'm misunderstanding the template you sent me, but when I've attempted to modify and run it, it's added product tags to products that shouldn't have them on it. I would imagine I'm making a mistake somewhere in the conditions.

I guess a better, more specific question would be:
In my below image, what do the lines on the side connotate? I notice that they separate certain parts of the condition, but I think that there's a specific piece of this that I'm misunderstanding. What does the function I've set up here do? This is what I imagine would be the correct setup, but it doesn't seem to operate correctly for us.

 

[paul_n · Accepted solution]

When you use inventory quantity changes as a trigger, it's telling you the variant inventory changed and giving you those values. If you want to control product visibility, you need to check inventory for all the variants of that product. Complicating matters, inventory at the variant level is across locations. Is if you then want to check a single location, you need to use Inventory levels. 

This particular condition is checking if at least one product variant has inventory at that Warehouse location. if it's false, that means all variants are sold out at that location. 

[BigLaCroix]

EXCELLENT! THANK YOU SO MUCH. I just really needed to get that translated.
That is exactly what I am trying to get done. I don't care about visibility across web and the like, because I've managed to code it into our website that tags that involve an underscore are not listed as search terms. The warehouse tag is a back-end piece that allows me to know what we have here in our warehouse. That's really all I needed.

Thanks so much for both responding to me in the first place, and getting back to me. I really appreciate your help here!

[simonski]

@paul_n Thank you so much for this template! It works just perfect and solved an issue I was thinking about since weeks!

One question: can I be sure that this function will work in the next years, or is it possible that shopify will remove certain variables of this template in the future? (While editing the template, I read sth like this as a note from shopify within flow that one variable was outdated). Thank you!!

[paul_n]

In case it's not clear, when you use a template you are copying that into your store and it's no longer linked to the original, so any changes Flow makes to the template will not affect you.

Regarding variables/etc, there is no guarantee that something won't change. In particular, the method of using the "available" quantity is deprecated right now. The alternative method isn't supported by Flow yet, but we are working to supporting it. Typically, most deprecations come with an alternative and Flow will try to migrate your workflow to use the new variable when this happens so that you don't have to do anything.  

[USAToolDepot]

The link to this template is broke.  Could you please post a link this template again?

[paul_n]

I updated the original one

[USAToolDepot]

Thank you for doing this.   After looking at the template its not quite what we are looking for, so I'll try to start a new thread in hopes there's a solution for us.