Build one auditable line for each reel or matching group
Assign a stable line or reel ID before creating summaries. Each line should show manufacturer, part number, actual cable specification, reel count, footage per reel, quantity basis, condition, and photo filenames. A matching group may share a line only when the product, length basis, condition, storage site, and release record are genuinely the same.
Keep unknown material in the inventory. Instead of forcing it into the closest known product line, create a separate reference with the available marking, photographs, and an explicit unknown field. The inventory remains useful when its uncertainty is visible.
- Line or reel ID
- Manufacturer and part number
- Specification and quantity basis
- Photo filenames using the same ID
Preserve per-reel quantities beneath the total
Record continuous footage for every reel or piece and identify whether each amount is measured, documented, or estimated. A total may be helpful as a summary, but it must not erase the number of reels, individual lengths, or condition differences that created it. Two pieces totaling 500 feet are not necessarily one 500-foot continuous length.
Keep packaging damage, exposed ends, and missing labels with the line they describe. That allows a bulk submission to contain a realistic mixture without pretending every reel is identical or every figure has the same evidence basis.
- Reel count and footage per reel
- Measured, documented, or estimated basis
- Condition record
- Unknown quantities retained as unknown
Separate actual sites and release contacts
When a lot is stored across more than one yard, warehouse, or project location, maintain site-specific lines or groups. Record storage location, release authority, access limits, and loading resources with each location. A total of all material does not answer who can release a reel or what site conditions apply to it.
This is the central difference between a bulk-lot task and a surplus-reel task. The surplus page reconciles a current balance and release status for excess stock; this page protects the line-level evidence when several material families or sites are included in one inventory.
- Storage location
- Release authority
- Access limits
- Seller-reported loading resources
Make the photo set independently traceable
Use each line ID in tag, jacket-print, overview, and visible-damage photo filenames. The filename can also carry a site shorthand when material is split between locations. A reviewer should be able to begin with an inventory line and find the corresponding images without guessing which reel appears in a generic warehouse photograph.
The city’s Circulation Element identifies Interstate 280 and Highway 1 as freeways through Daly City and names Mission Street, John Daly Boulevard and Serramonte Boulevard among its arterials. This city-level context is relevant to the need for actual access notes on large reels, but it does not describe a particular seller site, guarantee a route, or provide a transport commitment.
- Tag photo
- Jacket legend photo
- Reel overview
- Damage or packaging photo when relevant
Worked multi-site inventory record
A fictional example: line BL-DC-01; matching product; one reel, 500 feet documented; Site A. Line BL-DC-02; same product; one reel, 90 feet estimated; Site B. Site-specific loading equipment and restrictions: unknown. Release authority: not yet confirmed. This illustrative inventory example is not an actual or purchased lot.
The mistake is using one grand-total footage figure for a mixed lot and hiding the differences in reel length and storage site. The resolution is one row per reel or continuous piece, with site and specification groupings retained and unknown fields stated in the same record.
- Line BL-DC-01: 500 feet documented
- Line BL-DC-02: 90 feet estimated
- Site-specific access: unknown
- Release authority: not yet confirmed
