How can I filter orders based on on-hand inventory at a specific location?

How can I filter orders based on on-hand inventory at a specific location?

HYS81
Visitor
2 0 0

We sell out-of-stock items because we manufacture on site and can restock quickly. I need the ability to see only orders I can fill at a given time based on my On Hand inventory at a specific location.

I have tried a couple of tagging apps but none is using the right source information - either they can't focus on one location, or they use Available inventory instead of On Hand.

Can anyone suggest something that will let me tag or filter orders the way I need?

Replies 4 (4)

richardstowey
Shopify Partner
1 0 0

Hi!

 

Can you share the details of which apps you have tried?

Peter_Datma
Shopify Partner
50 0 5

Hi @HYS81 ,

 

As I was working recently on inventory reports for our app I am curious about your issue. 

You say that you continue selling sold-out products, meaning that inventory for certain products & variants would go into the negatives.  What you need, and correct me if I am wrong is a list of "shipable" orders, meaning, those orders that were placed before the inventory quantity went into the negatives (and also some mechanism in order to adjust for new inventory quantity added)? I am saying this, because it is not as easy as one would think to have the "on-hand" inventory quantity from Shopify.

 

Best,

Andras

Datma

 

HYS81
Visitor
2 0 0

What I'm looking for is an app that can check an order against on-hand inventory. If on-hand is positive, tag it as fillable. Or conversely, apply an out-of-stock tag if on-hand is <0, and then remove it when on-hand is replenished.

I tried Leap Auto tags which can do this, but it looks at the combined inventory of my two locations instead of just my online store. I can't get timely enough help from their support team to pursue this route.

I am also trying SC Order Tags & Flows which can focus on one inventory location, but it only considers an item "in stock and able to fill" if the available quantity is >0, so if I have one item in stock and it gets ordered, availablity=0 and the order is tagged as unfillable, even though I still have the item on hand to fill that order. I do have someone from support trying to help me, but it's taking some time. I'm exploring alternatives in the meantime.

FunkyMoose
Shopify Partner
1 0 0

We're in the exact same boat. We rely on pre-orders for most of a lot of our products. So much so that I've reached out to a development team to build something for us, exactly like you explained.

It should be a fairly simple task: "Check if ALL items in this order have 1+ items on hand > Tag 'Shippable' ".
I even want to go a step further, where if one item in the order isn't on hand but others are and those others can complete another order, then move the tag to a newer order.