Create one auditable row for each physical item
Assign a stable line or reel reference to every reel, pallet group, or continuous piece. Record the product designation, conductor material when known, continuous length, and whether the quantity is documented, measured, estimated, or unknown. A grand-total footage number can be included as a summary, but it does not replace the individual records behind it.
Clearwater’s Marine & Aviation Department operates Clearwater Beach Marina, Clearwater Harbor Marina, Island Estates Marina and other boat-slip and ramp facilities, and oversees Clearwater Executive Airport. That verified city context does not say that material exists at any marina or airport. For a bulk inquiry, use the actual storage-site code or address for each line rather than a broad location label or an assumed connection to a named facility.
- Keep line or reel reference, specification, continuous length, and quantity basis on the same row.
- Use an explicit unknown value for an item whose label or footage cannot be confirmed.
Keep sites, groups, and conditions visible
Group rows by actual storage site and state whether the inventory is offered as one lot or as defined groups. Keep site-specific condition and release contact in the row or a connected site table. A reel at one site should not inherit access, authority, or condition information from a similarly described reel at another site.
This is distinct from merely counting surplus footage: the seller decision is whether every line can be traced across locations. When different site contacts control different material, the inventory must show that difference before a group is described as available.
- Record storage site, condition, release contact, and lot grouping for each item.
- Do not merge reels from different sites just because their product names resemble each other.
Match the photos and records to the correct row
Use filenames that repeat the line reference for label, jacket, overview, and condition images. Attach manufacturer records only where a part number, batch, or reel identifier makes the relationship clear. One pristine reel photo should not stand in for a mixed group with different labels or storage conditions.
If documentation is missing or a photo cannot be matched, state that next to the line. This avoids creating a false common specification and gives the reviewer a precise follow-up question instead of a vague request to clarify the entire lot.
- List photo filenames, manufacturer record, batch or reel match, and visible condition per line.
- Keep unmatched photos and records separate until they can be tied to a reference.
Add access facts without assuming a move
For each applicable site, record dimensions, gross, net, or unknown weight basis, access restrictions, and available loading equipment. These are factual handling inputs for a purchasing review, not a promise about trucking or collection. A site with an unknown forklift or clearance should remain marked unknown until the owner confirms it.
A fictional model has BL-CW-01 with a matching product, 500 ft documented at Site A, and BL-CW-02 with the same product, 90 ft estimated at Site B; release authority is pending and loading details are unknown. It is not a purchased lot. The two lines stay separate because quantity basis, site, and authority differ.
- Record dimensions, weight basis, access restrictions, and loading equipment per applicable site.
- Label release authority and handling facts as confirmed, pending, or unknown rather than assuming them.
