Shopify Flow - Can Flow Check Inventory at Two Locations, and notify me if a transfer is possible?

Shopify Discussion
,
1

Hey there,

I work as the online presence for a small business and I’ve been working on getting Flow to basically help me automate a bunch of different tasks, but primarily I’ve used it to add tags to products.

I was wondering if it’s possible for Shopify Flow to automate the following situation:

When a customer buys a product in Location A, Flow would check Location B’s inventory to see if it’s possible for us to move inventory from location B to Location A, and if it’s possible for product to move from B > A, then it adds it to a collection that we can easily and quickly look through to create a transfer, and move product from one store to another. This is also because we work out of a warehouse that transfers product to both our stores in one city, so I want it to be a one way street, so we’re filling inventory up in our stores and not just balancing it between the stores and warehouses.

Below is my thought process for how this might look:

Trigger: When a customer purchases items in-store at Location A.

Condition: Check “Location A” for Inventory being Equal or Less than 1 [AND] Check “Location B” for Inventory Being Greater than or equal to 1. If both conditions are true, it moves to an action.

Action: Add Tag “_Warehouse” or something else, denoting that the product is something we can and should move over.

Let me know if you see this and have any ideas on how to make this work! I’m particularly struggling with setting up the condition to work correctly.

-Big LaCroix

2

Not sure if you got any help on this - if you did I’d love to know your solution. I have gotten all the way from item sale to checking two other locations, and then tagging so that I can have a collection based off of that tag for the staff to search when compiling a transfer. What I can seem to do is provide quantities of self populate a transfer.

3

When you say that they bought something in Location A, is that something happening in Shopify POS?

4

Have you had any solutions to this? My problem is similar and I am trying to create a workflow solution as well. I have a warehouse location that I keep inventory at and would like to receive an email or slack message when my brick and mortar location inventory reaches 0 but I have that same product in the warehouse that can restock that item. I basically just need an alert that “warehouse” has products that can restock “brick and mortar”.