Inventory App

Tourist
28 0 2

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.

0 Likes
Shopify Partner
660 0 109

You mean you want some sort of report or table where you can update the qty right there and save changes?

Not sure what you mean by "have the same update tool as the current inventory"?

0 Likes
Tourist
28 0 2

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. 

0 Likes
Shopify Partner
660 0 109

Hmm.

I'm not sure that would work because if you have multiple pending orders for a given product, and you are substracting 1 to the current unfulfilled qty, how would it know which order was fulfilled?

Shipped items need to be associated with a fulfilment...

0 Likes
Tourist
28 0 2

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.

0 Likes
Tourist
28 0 2

Here's a mock up. Maybe easier to visualize.

0 Likes
Shopify Partner
660 0 109

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...

1 Like
Tourist
28 0 2

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.

0 Likes
Shopify Expert
41 0 1

Hi Daniel,

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 support@inscoder.com

Regards,

Billy Yeung

Inscoder limited (https://inscoder.com)

Find more about apps for your store.
★ Geo IP Redirect Manager: https://apps.shopify.com/geo-ip-redirect-manager
★ Connected Inventory: https://apps.shopify.com/connected-inventory
★ Theme Save: https://apps.shopify.com/theme-save
0 Likes
Tourist
28 0 2

OK, sent!

0 Likes