Sort Order By On-hand Inventory to determine which items are fulfillable

Shopify Discussion

Topic summary

Main issue: A merchant wants a fast way to identify and sort orders that are “fulfillable” (all line items in stock) without checking each product manually.

  • Current state: Manual cross-checking per order; affordable apps not found—only costly OMS (Order Management Systems).
  • Proposed workaround: Use a spreadsheet with orders and inventory on separate sheets plus a script to check stock, flag line items, decrement inventory, and output a list of fully fulfillable orders.
  • App lead: The “Inventory Reports by Assisty” team said they would try to build this report; the original poster planned to report back if successful.
  • Platform limitation: Participants note Shopify lacks a native “sort by stock” feature on both front and back end; a linked feature request advocates adding inventory-based sorting, which may require core enhancements.
  • Recent updates: Other users asked whether Assisty delivered and whether a lightweight fulfillable/not-fulfillable view was found.
  • Outcome: No confirmation of an app-based solution. Spreadsheet scripting remains the only concrete option mentioned. Discussion remains open with unanswered status on Assisty’s feature.
Summarized with AI on January 5. AI used: gpt-5.
1

We sell items that we don’t have in inventory. We need a way to identify when a customer order is fulfillable - meaning all items on that order have inventory in stock. Presently we have to look at each order one-by-one and then search (in another window) on the product/inventory screen to see which items are in stock. It is very labor intensive. Has anyone found a way to see available inventory by order and sort for those orders that are fulfillable? Any suggestions would be welcome. I have searched for an app that does this and so far the only solutions come from expensive Order Management Systems.

Thanks.

Steven

1 Like
2

That sounds like you want to use a spreadsheet program. Put the orders with line items on one page, and put the inventoried items on a second, then run a script that checks the inventory for unfulfilled items. If the item is found, it flags the line item on the first page, then lowers the quantity on the second page by 1.

Then it would look through all the orders on the first page to see which orders had all its line items fulfilled.

I would put the button to run the script along with the fulfilled orders list on a third page.

If you’re unfamiliar with spreadsheet programs, a Google search can get you up to speed.

It may take you a bit to build it if you’re new to scripting, but once it’s done, you’ll never have to do it again.

3

Thank you for your suggestion.

I have been thinking that I may have to do this myself and a spread sheet may make sense.

Your logic flow makes sense.

BTW, there is an app called Inventory Reports by Assisty. They have told me they will try to develop this report for me. If that does not work out, I will work on the spread sheet.

I will let the community know if Assisty delivers a solution.

Again, thank you for taking the time to reply.

Much appreciated.

4

2 things:

1- I agree with you that this should be a SORTING feature EVERYWHERE in shopify,

both front end and back end..

2- After trying to make this happen on the front end,

I understand why it does not exist on the back end…

That said.

Examine this post about the “front end” sorting by stock problem:

(note the 3rd feature request I have posted at bottom)

https://community.shopify.com/topic/1785852

This “human idea” seems like common sense: “Give us an option to sort by stock”

However, after trying to make this happen I do indeed see why Shopify has ignored this…

with enough community support we could help bring this feature to Shopify’s attention, and with the right DEV team on their end a good solution could be reached by enhancing the Shopify core code and collection array. (further details in link above)

Good luck.

PS: using the spreadhseet as suggested here is currently the only option I can think of for you until Shopify engineers INVENTORY into the system a selectable sort option within the root collection array (which I suspect is easier asked for than done, but is indeed doable if the put their DEV team on it and there is enough community support)

5

Hi,

I am also looking for an app like that. Did the app you are refering to develop this feature?

6

Hi @StevenF1

Hi Steven,

I came across your post about identifying whether an order is fulfillable
without checking each product one by one.

I know this is an older thread, but I was curious —
did you end up finding a lightweight way to see “fulfillable vs not yet fulfillable”
orders at a glance, or is this still a manual process?

I’m researching how merchants make these fulfillment decisions in practice,
not selling anything.