Automated inventory management
Automatically keep track of bar inventory
Basic features:
-
Inventories (in economy) -
Inventory item count -
Inventory list item count badge -
Inventory item count change event -
Track user submitting change -
User comment -
Track product mutation change -
Undo change on mutation undo
-
-
-
Attach inventory to bar -
Page to: -
Add/remove inventory items (purchase/trash) -
Edit inventory items (balance), all at once -
Edit inventory items (balance), one by one (moved to #526) -
Move items between inventories -
Inventory product details -
List all change events -
Show change event -
Product quantity history graph (moved to #525) -
Inventory quantity time machine -
Rebalance summary over time
-
-
On product: optionally select different products to affect -
Show inventory count on product pages -
Suggest to move inventory items on delete (#524 (closed)) -
Improve inventory period report details table and page style
Potential database structure:
- inventory:
- name
- FK economy
- inventory_item:
- FK inventory
- FK product
- quantity
- inventory_item_change:
- FK inventory_item
- quantity
- type: (update, purchase, move)
- FK related: related inventory item change (when moving inventories)
- FK user: user making this change
- comment: user comment
- FK product mutation: related product mutation
- product_inventory_item:
- FK product
- FK inventory_product
- quantity
Edited by Tim Visée