As of today, 08-JUN-2023, the changes to the stock handling for Shopify have only served to hurt users across the board. Please allow for:
There is a key assumption in the Shopify use case that is not handled well and is completely wrong: that my one Shopify website knows all allocation. It does not, it cannot, and it never will! Further, there is no ERP environment that will ever handle the tracking the way that Shopify thinks about it today.
Here's the real example (with fake products that we don't sell):
I have two websites, and I sell paper clips on both.
On the retail website, I have 3 unfulfilled orders.
On the wholesale website, I have 7 unfulfilled order.
I have 50 units of paper clips sitting on my shelf.
What I should see:
On Hand for both sites: 50 units
Available for both sites: 40 units.
Instead, Shopify assumes that it knows ALL COMMITTED QTY (but only per each site), so we either show:
Retail has 47 units [should be 40] available, 50 On Hand
Wholesale has 43 units [should be 40] available, 50 On Hand
or Method B)
Retail has 40 units Available, 43 units On Hand [should be 50]
Wholesale has 40 units Available, 47 units On Hand [should be 50].
Right now, our inventory control software is defaulting to use Method B (control via Available qty, due to API restrictions). This is great! Until we get down to the last few units, and then we're overselling on both platforms.
The problem is that no user interaction can override or change the values either. Switching to Method A still results in overselling!
Users also cannot use a CSV import of any logical pattern. Why? It is incredibly unreasonable to know and manage inventory at the aggregate level (50 units on hand, 40 available), but then also know PER CHANNEL how to federate out the allocation (i.e. knowing to give 3 units of allocation to Retail and 7 units of allocation to Wholesale) to then produce fictitious inventory qty (either On-Hand is wrong or Available is wrong, because neither method A nor B actually work).
We don't have a wholesale website but we would also prefer not to see the On-Hand number.
I cannot agree more strongly that this is the preferred action.
4. Revert functionality to only show Available and get rid of On-Hand tracking (since Shopify is not and never will manage inventory like an ERP will do). This is the preferred action.
Honestly I don't know why (and I really would love to know why) we need to see the On-Hand quantity number. Has anyone seen a good (or semi-satisfactory) explanation?
Based on your feedback, our product team wanted to highlight a few features that may solve many of the issues you’re experiencing:
Thank you for your feedback! It truly helps us make a better inventory platform.
Please reach out to our Support Team for more specific help about your scenario, or if you have any other questions or concerns.
@Jacqui It seems updating "On Hand" is only available in the GraphQL API.
Is there a timeline when this option will be available on the REST API. The doc for the latest stable version only shows "available" is supported: https://shopify.dev/docs/api/admin-rest/2023-07/resources/inventorylevel
On our Shopify Expert Marketplace, you can find many trusted third party developers and fr...By Arno Nov 27, 2023
You've downloaded the Search & Discovery app from the Shopify App store, and as you're ...By Skye Nov 8, 2023