Reconcile the current balance before describing the lot
Start with the inventory export or original order, then match each offered line to a physical reel, box, or continuous piece. Record the inventory reference, part number, physical match, offered quantity, reserved quantity, and the date of the count. An old purchase total is a locator for the record, not the current balance.
The Clear Lake Industrial Area is approximately 650 acres across 11 sites near Eugene Airport and Highway 99, with large vacant sites and planned industrial activity. The fact is only local context for a seller organizing project or warehouse material; it does not say that a particular lot exists. The seller task remains a current count and a clear boundary around what is actually offered.
- Create one stable line ID for every reel, box, or piece.
- Mark retained, reserved, and offered quantities separately.
- Use a dated physical count when invoice footage is no longer current.
Draw the offered boundary around releasable stock
For each line, state why it is being released, such as overrun, discontinued stock, distributor excess, or a closeout. Then record ownership, the release authority, and whether an approval is pending. This prevents a buyer from mistaking all material on a warehouse report for stock available for sale.
A pending approval should stay visible even when the item is otherwise fully identified. Do not convert a possible future release into an offered quantity until the authorized seller can confirm it.
- Keep release reason and approval status as separate fields.
- Identify the owner and release authority for each line.
- Use pending when the approval is not complete.
Preserve per-reel quantities and packaging
Keep full reels, partial reels, boxes, and cut lengths on separate rows. For a reel, record the continuous length and whether it is measured, documented, or estimated. For boxed or loose material, state the package condition rather than creating an artificial continuous footage figure.
Photos should use the same line ID as the inventory. A photo of a reel can support a specific row, but it should not be used as proof for other reels with the same part number or a different remaining length.
- Record one continuous length per reel.
- State package condition for boxes and loose coils.
- Use matching line IDs in photo names and inventory rows.
Add access facts without assuming a move
Include the storage site, access limits, and loading resources that are known for the offered material. If the material is split between locations, preserve that split instead of treating it as one undifferentiated quantity. These are seller-side facts for a lot review, not a statement of freight, timing, or acceptance terms.
Where site information is incomplete, list the best contact for clarification and mark the missing field. It is better to disclose an unknown dock or loading resource than to make the inventory sound simpler than it is.
- State storage site for each line or group.
- Note gates, escorts, hours, or other access limits if known.
- List available loading resources only when documented.
Show uncertainty in the worked balance
Illustrative record—not a purchased lot: OV-EUG-02; project overrun; two reels with 300 ft and 180 ft continuous, documented; uninstalled; release approval pending. The record demonstrates a present count and a release gap without pretending the reels are available today.
The common mistake is reporting original invoice footage as remaining inventory. Correct it by retaining the source record, recording the physical balance by reel, and putting missing counts or pending returns in an explicit unknown or pending field.
- Example field: two separate documented reel lengths.
- Example field: approval pending.
- Example field: release reason project overrun.
