Give every reel a stable line ID
A grand total cannot show whether several reels are the same product, stored together, or controlled by the same release contact. Assign a stable ID to each reel or to a group only when the products and records are genuinely identical. Use the ID in the inventory, photo filename, document filename, and any site note.
Do not reuse an ID for two reels merely because they have the same outside appearance. If a reel changes location or its identity becomes uncertain, record that discrepancy on the line. A stable reference lets another reviewer trace a claim back to the specific material rather than to a general warehouse photograph.
- Line or reel ID
- Storage location code
- Photo and document filenames using the same ID
Keep quantity at reel level
For each line, record the manufacturer or part number, reel count, continuous length per reel, and whether the length is measured, documented, or estimated. A total of 900 feet across several partial reels is not the same record as one 900-foot continuous reel. Preserve the difference instead of collapsing it into a sales total.
When a group is truly identical, retain a count and the length of each matching reel. If one reel has an unknown balance, give it its own line or note the uncertainty. Also separate a gross loaded-reel weight from any cable or conductor weight claim; label the weight basis rather than treating it as a material quantity.
- Product marking or part number
- Reel count and per-reel continuous length
- Measured, documented, or estimated quantity basis
Match photographs to the actual line
Use at least a reel overview, readable tag or jacket-marking image, and a view of any visible condition issue for each distinct line. The photo filenames should repeat the line ID so the evidence can be opened beside the corresponding row. A single clean reel should not stand in for other reels with different labels, lengths, or visible condition.
If a tag is unreadable, keep the photo and record the limitation. If a record appears to apply to a different reel, mark it as unmatched instead of attaching it to the nearest line. This photo-to-line discipline is the central task for a bulk lot, not an extra administrative step.
- Reel overview with line ID
- Readable tag or jacket marking
- Visible condition note and supporting photo
Separate sites, release contacts, and conditions
Group rows by their real storage site, even if the seller wants the material considered in one inquiry. Record indoor, covered, or exposed storage; known condition differences; and the release-authority role for that location. One site’s contact or loading facts should not be assumed to apply to another site.
If a location, release contact, or condition is unknown, keep it as an explicit unknown. The inventory can still be useful, but an unknown must remain attached to the correct reel or site. This avoids presenting a multi-site lot as one uniform and immediately releasable collection of material.
- Actual storage site
- Condition and storage exposure
- Release-authority role by site
Record access facts without turning them into a promise
The city's FAQ identifies Interstate 215 and State Route 60 as part of the state highway system referenced for truck-route connections and says truck-route maps are to be publicly available in GIS format. This city fact provides routing context only; it does not identify a pickup plan, freight term, or confirmed route for a cable lot.
For every site that holds a large reel, record dimensions, the weight basis, available loading equipment, gate or appointment constraints, and any known access limitation. Leave a field unknown when the seller cannot verify it. The purpose is to make a multi-reel handoff reviewable, not to imply that movement has been scheduled.
A fictional record can show MV-BL-01 at Site A with 500 feet documented and MV-BL-02 at Site B with 90 feet estimated, with photo IDs and loading equipment recorded separately. That illustrates how location and quantity stay linked; it is not an actual inventory or purchase.
- Reel dimensions and stated weight basis
- Available loading equipment or unknown
- Gate, appointment, and route-access constraints
