Inventory tracking

I want to see exactly what's in the yard and what needs to be ordered. Every time an order is created, the system should check if the stone, vase, or porcelain is in stock. If it is, reserve it for that order. If it's not, flag it as needing to be ordered.

I should be able to see everything on hand, what's reserved for upcoming jobs, and what's running low. Set a minimum for any item and get notified when stock gets close so I can reorder before running out. Each item should show which vendor it comes from so reordering is one step away. For shops with multiple locations, inventory should be tracked separately per yard.

A few specifics that come up a lot:

Per-item vendor info. Track the vendor, original vendor order number, and sales tax paid date for each item — needed for warranty returns and lifetime warranty claims years later.

SKU system. Short code (user-visible, like "SG17") for counts, plus a unique identifier per physical piece for tracing.

Custom categories. Same pattern as custom granite colors. Die, Slant, Marker, Base, Bevel, Bench, Monolith — let users define their own. Distinguish inventory items from non-inventory items and from services (cleaning, lettering, foundation have a price but no stock).

Custom names. Let users name items themselves: "single die round top", "double slant", etc.

Search when creating orders. Type "double", see all double dies, select one, auto-fill the order and deduct from inventory.

In-transit tracking. "In stock" vs "in transit" vs "needs to be ordered". Mark as ordered with an ETA, mark as received.

Vendor order receiving. Place a vendor order (e.g. 7 stones from McCannon), system tracks pending. On arrival, click "Received" and all pieces auto-add to inventory.

Total value calculator. Running total of inventory on hand. When a piece is assigned to an order, deduct its cost. December 31st, look at one number and know exactly how much money is tied up in granite.

Bronze and porcelain: no stock tracking. These are custom-ordered per family — track them via workflow to-dos, not inventory.

Individual piece tracking. Each piece: SKU, color, dimensions, finish, country of origin, container/shipment number, date received, cost paid. Important for warranty (trace the piece back to its manufacturer/shipment) and cost tracking across containers from different suppliers at different tariff rates.