Improve Inventory Management in Shop Forms
in progress
R
Ryan
We sell shirts to donors using a shop form and use the "maximum # of items to purchase" feature to limit sales to what we have in inventory. When we re-stock an item, we can't just update this number to the inventory on hand because the system recognizes previous purchases and decrements those from the number we enter (e.g. if we enter 10, sell those 10, then re-stock with 25 and enter 25 in the field, the system will only display 15 available for purchase... 25 entered in the max items field less the 10 previously sold).
The only work-arounds right now are:
1) make a new item with the re-stocked quantity--this clutters the shop screen, confusing donors & making sales data messy; or
2) clone the shop form and edit the quantities of all items--this takes significant work, creates multiple forms, creates many opportunities for error, and makes analysis of sales more complicated.
We haven't tried deleting the sold-out items and creating a new one because we're afraid of losing the historical sales information.
Log In
Rowan from Zeffy
marked this post as
in progress
Rowan from Zeffy
marked this post as
planned
Rowan from Zeffy
Merged in a post:
Inventory Tracking in Online Store
S
Sarah
The ability for zeffy to automatically track inventory as it's sold for each variant of an item in an Online Store. For example, I have 5 items each available in 12 colors. I'd like to be able to track all the variant inventory in my Online Store without having to create 60 "ticket" types in an event.
L
Lucie
There is no place on the back-end shop form to see an inventory count. The only place you can see it is on the front-end shop form, but there are several limitations. Currently, to maintain accurate inventory counts in the front-end shop form, it is necessary to ADD your restock quantity to the misnamed "Number of items available" quantity in the back-end shop form. This works, but it is a backwards way to do things, and it breaks down under certain circumstances.
An example of where this breaks down - one of the items for sale in our shop is also a giveaway item to new members. Since Zeffy can't track those giveaways, our inventory quantity gets off over time. We do an annual inventory count to reconcile actual quantities on hand with what is showing available in Zeffy, but the front-end form only displays the available count for items with fewer than 10 remaining. For items with available quantity more than 9, you can manually go into an item and add the item as though you're attempting to purchase it (which you have to do one click at a time since the form does not support direct quantity entry), but that only works up to quantities of 100, since the form does not allow a higher quantity. Bottom line - there is absolutely no way in Zeffy to display the true available quantity of an item if it is above 100.
Recommended enhancements:
1) Change the "Number of items available" field on the form so that it ignores any previous sales transactions, i.e. is is the actual number of items currently in inventory. If not, rename this field label to "Total quantity stocked for this item since the beginning of time", since that is what it really is.
2) If #1 is not possible or desirable for some reason, add another field to the back-end form that displays Zeffy's calculated "X items left!" from the front-end form (and make that count available even for items that have remaining quantity greater than 9).
3) Add a toggle button to allow the form owner to choose whether or not to display the remaining quantity on the front-end form and/or to set a limit above/below which the remaining quantity does/does not display.
J
Justin
I am having the same troubles with our shirt sales form. There is not an easy way to update available quantities for each item. Please add the ability to directly edit the available quantity, or at least display the available quantity and/or quantity sold next to the box for changing the total quantity. Thanks!