We have a special need for inventory. We need to be able to see unfulfilled products easily while doing invenory update. Ideally, the tool would filter by vendor, show unfulfilled quantity and have the same update tool as the current inventory. Pretty straightforward. We could pay upfront or monthly.
Thanks for the reply. Sorry I wasn't clear. I mean a tool just like Products/Inventory in the admin, where I can update quantity quicklyand easily. It would just need to show a column for unfulfilled quantity. It can already filter by vendor. As long as I'm asking, it would be good to have a column for vendor as well and make it something I can change right there. We use a 2 digit number for vendor so it wouldn't take much space. Mostly, though, the unfulfilled (sold but not yet shipped) quantity is the most important bit in establishing an accurate inventory for us.
I have managed to achieve this using an export and a pivot table. However, I'd like to have it all in the admin as a quicker tool.
No, unfulfilled wouldn't be a variable. That column would simply report the current unfulfilled quantity.
My business is in live plants. The available quantity is in flux constantly (some plants die, others grow enough and become salable) and there is always a quantity of unfulfilled plants waiting for the proper time to ship. Inventory is the bane of our industry.
Oh I see now.
I've been researching a bit. There are several ways of doing product variant bulk edit (apps and built-ins), but none of them is showing the 'pending fulfilment' count!
Actually I can't even find a way of getting that number at all (apart from exporting and doing some excel stuff as you did).
Once I'm finished with my current project, I will consider building an app that can do that, but at this point in time I'm not sure how to help you...
Yes, it's an odd situation with the inventory in my line of work. In most businesses, you put the product on the shelf and it's there until it's picked. Also, fulfillment is usually ASAP, so it's rare to need to know the unfulfilled quantity. The pivot table concept was a revelation for me! It will also work for bulk pulling orders. We use the Vendor field to designate greenhouse bench locations. Orders can be oranized in a pivot sorted by vendor to minimize walking back and forth all day. Might even run it all from a tablet to save on printing.
Thanks for taking the time to work through the understanding. It always helps; even when a solution doesn't appear. I figured out something else as a result of it! If you do get something worked out, please let me know.
I have a solution for you. Since it works at the admin side of shopify, I will send you the login&password by email to test a few things out together.
Please send your email to firstname.lastname@example.org
Inscoder limited (https://inscoder.com)