Give a mixed lot a stable line structure
A bulk lot becomes difficult to assess when its inventory says only “three pallets” or reports one footage total for multiple products. Assign a stable line ID to each reel, coil, or genuinely identical group. Carry the same ID into photo filenames, product documents, and the storage-site column so a record can be checked without guessing which image belongs to which item.
The likely inventory mistake is replacing line-level information with a total weight or total footage figure. Correct it by retaining the number of reels, the continuous length for each line, the product marking available, and the evidence basis for that amount. A total can remain as a summary, but it should not replace the individual rows that explain it.
- Use one line or reel ID in the inventory, filenames, and supporting records.
- Keep product family, manufacturer or part number, and visible marking with that line.
- Separate a continuous piece from a collection of shorter pieces.
Keep quantity and weight bases separate
For each line, record footage per reel and label it measured, documented, or estimated. A counted reel is not proof of its remaining footage, and an original tag may not describe a partly used reel. When an estimate is all that is available, state how it was formed rather than presenting it with false precision.
Weight needs its own field. Gross loaded-reel weight can include wood, steel, packaging, and cable; it is not a statement of conductor weight. Preserve the scale ticket or other record if one exists, label the basis as gross, net, or estimated, and leave an unsupported component weight unknown.
- Record per-reel footage and reel count instead of only aggregate footage.
- Mark the basis for each quantity: measured, documented, or estimated.
- Label every weight as gross, net, or estimated and retain its source.
Map each site to its own release facts
Multi-site lots need more than one location field. Put the actual storage site, access limitations, available handling information, and the person or role that can authorize release on the relevant line or site group. This prevents a warehouse contact from being assumed to control a separate yard or project location.
The City of Boise says Water Renewal Services manages more than $2 billion in infrastructure, including five facilities and more than 1,000 miles of underground pipe; some infrastructure is nearing 100 years old. That is local infrastructure context only, not evidence that a particular cable lot exists or is available. A seller with a genuine public-works, facility, or commercial background still needs site-specific inventory and release records.
- Name the storage site and release contact for each site grouping.
- Record access limits and available handling information as known facts, not assumptions.
- Keep pending release status visible instead of combining it with released material.
Handle incomplete lines without hiding them
Do not discard an incomplete reel from the inventory or blend it into an identified group. Give it a separate ID, add readable tag and overview photos where available, and mark the precise fields that are unknown. For instance, a line can have documented gross weight while its remaining footage is unknown; the two facts should remain separate.
If a group has mixed specifications, split it before sending the record. A buyer can then ask focused follow-up questions about a single line rather than reopening the entire lot. This preserves the seller’s evidence and avoids turning a practical inventory into a broad, unsupported description.
- State which field is unknown and why it cannot yet be confirmed.
- Keep unidentifiable pieces on their own lines rather than in an estimated total.
- Attach photos or records to the line they support.
Use a fictional worked record before sending the file
Illustrative fictional record—not a purchased lot: line BL-B06 is a marked cable reel at Site A with 500 ft documented from a tag; line BL-B07 is a separate reel at Site B with 90 ft estimated from an inventory count. Both lines retain their own photo references, and the weight entry is “gross loaded-reel weight; conductor component unknown.”
The practical resolution is to send this type of line structure with a concise note on who can release each site and what is still unknown. It creates a usable starting record without suggesting that material, price, transport, or acceptance has already been agreed.
- Example line BL-B06: 500 ft documented, Site A, product marking photographed.
- Example line BL-B07: 90 ft estimated, Site B, quantity basis stated.
- Example weight: gross loaded-reel weight; conductor component unknown.
