Inventory_Items

Inventory_Items

Primary identifier. Must be unique.
Human-readable label.
Product, Asset, Supply — whatever buckets you need.
The stock count.
The line in the sand for low-stock alerts.
Optional. Hide from front-end staff via Admin Only.
Supplier
“Warehouse A — Bin 12”.
MM slash DD slash YYYY
When stock was last verified.
Catch-all.
Quantity × Unit cost. Useful for reporting.