Tag products based on availability on specific Location

[fmartinezja]

Hello, dear members of this amazing community,

We run a fulfillment service that provides express shipping, next-day shipping, and store pick-up. We use a third-party app to show rates for these specific services if the order’s shipping address applies to certain rules (most of them are City based). To do this, we create a second location at our client’s Shopify and sync our WMS inventory with that specific location.

Here’s the situation:

We could run out of stock of an item in our location, but the store’s other location could very well have this item in stock, therefore Shopify shows that there is stock for this product, allowing it to be purchased, and, if all rules are met, Shopify will offer our shipping rates to that customer even though we don’t have that item in stock.

I’ve been going back and forth trying to find a solution for this, and apparently, the best way to go would be installing an app that automatically adds a tag to products that run out of stock at a specific location and then removing that tag once the product has inventory again. By doing this, I’d be able to create a Product Collection for every product that contains that tag and set the shipping rates app to only offer rates for that specific collection.

Now for the question:

What do you think of this? Does anyone has or can come up with a different, better solution? And even if what I’m trying to do is a good idea, does anyone know a good app that would do this? I found one but feels very buggy and is not working as intended

Thank you all.
All my best.

[DiegoPelaez]

Hi @fmartinezja , knowhing that Shopify flow app is now available to most Shopify plans, you might be able to achieve what you mentioned here with it. I tried to do a test myself and it seems possible:

In the backend I added another location called My location and I added inventory to it, after I submitted an order with all what it was left in that location, I checked the product and I saw the tag:

This is just a rough example, you might find this to work for you, please do your own testing to see if this could solve your problem. Cheers.

[fmartinezja]

Hi Diego, thank you so much for your reply. This does look like the solution I was looking for. Do you know if there’s a way to set up a flow similar to this, but instead of adding a Tag, removing it? So every time we add new stock for that product on that location the “out of stock” tag gets removed?

My best!