Start with a site-by-site inventory
The Port lists five major container terminals plus breakbulk and bulk terminals, and says Port-leased space supports logistics, manufacturing, warehousing and distribution. That is useful local context for a seller organizing warehouse or distribution inventory; it does not identify a cable lot or imply a Port relationship.
A single total hides the distinctions that determine whether a line can be understood: the physical reel, its specification, whether footage is measured or estimated, its storage site, and the person who controls release. Create one row for each reel or continuous piece before adding any roll-up total.
- Use a stable line or reel ID in the list and photo filenames.
- Keep warehouse, yard, and project-site rows separated.
- Record the actual location for each line rather than a city-wide label.
Make each reel traceable
For every line, transcribe the manufacturer, part number, readable jacket designation, conductor metal, and any visible rating. A photo reference should show the tag or printing tied to the same ID. Products that merely look alike should remain separate until their markings and condition records support grouping.
A workable row also states reel count, remaining continuous footage, dimensions when available, and the basis for each quantity. “Documented,” “measured,” and “estimated” are different bases; retain the label rather than turning an estimate into a precise-looking total.
- Line or reel ID and matching photo filename.
- Manufacturer, part number, and full readable designation.
- Per-reel footage with measured, documented, or estimated basis.
Keep unlike quantities and conditions visible
Do not use footage as a substitute for a continuous length. A 500-foot reel and several short pieces may have the same aggregate length but are different inventory records. Keep unused stock, removed cable, and recovery-only material on separate lines, and note visible jacket damage, missing labels, or storage exposure without guessing at unseen condition.
If weights are available, label what they represent. A gross loaded-reel weight can help describe handling but does not establish cable or conductor weight. Retain unknown fields as unknown instead of borrowing a neighboring reel’s specification.
- Separate continuous footage from aggregate footage.
- Label gross, net, documented, and estimated weights accurately.
- Flag mixed, unmarked, or uncertain lines for follow-up rather than classifying them by appearance.
Record release and access facts without presuming movement
Add the release authority or role, site restrictions, access hours if known, and available loading resources to the same row or site block. These details describe the seller’s current situation; they do not authorize a move or establish transport terms. If separate sites have different contacts, keep those contacts with the relevant inventory lines.
A concise note such as “forklift listed by site contact; capacity not documented” is more useful than an assumption. Where authority is pending, identify the status as pending and say who can confirm it.
- Release authority or approval status.
- Site access restrictions and loading resources.
- Separate contact details for separate storage sites.
Resolve unknown rows and avoid the grand-total mistake
The common mistake is presenting one grand-total footage figure as though unlike reels at different sites were one uniform lot. The correction is a per-piece record that preserves the physical ID, quantity basis, condition, storage site, and release status even when an overview total is also supplied.
Illustrative record—not a purchased lot: BL-TAC-A1 is a labeled reel with 500 ft documented at Warehouse 1; BL-TAC-B1 has the same recorded part number but 90 ft estimated at Yard 2. Their photos are BL-TAC-A1-tag.jpg and BL-TAC-B1-overview.jpg, and the Yard 2 release authority is still unknown. The example shows why the two records should not be merged.
- Create a separate unknown group only when individual identification is not yet possible.
- State what evidence is missing and which site contact can clarify it.
