Give every reel or piece a stable line reference
A bulk list becomes workable when the inventory line, photo filenames, document names, and storage note use the same reference. Give each reel or continuous piece its own ID. If several reels are genuinely identical, retain individual reel references or an explicit count so the group can still be checked later.
Do not use one warehouse overview photo as evidence for material stored at different sites. A reference system should identify the product, the physical item, and the site group without exposing a public street address in the page content.
- Line or reel ID
- Photo filename
- Document filename
- Site group or storage-location code
Keep specification and quantity differences visible
Record manufacturer or part number, readable designation, conductor metal and size, and continuous footage for each line. Group only material with matching documented construction. Keep copper, aluminum, unknown metal, different condition histories, and different cable designs in separate rows even if they are staged together.
State whether footage is measured, documented, or estimated. If weight is available, identify whether it is gross loaded-reel weight, cable weight, or an estimate. A grand total without those bases hides the material and quantity distinctions a reviewer needs.
- Manufacturer or part number
- Cable designation
- Conductor metal and size
- Continuous footage and quantity basis
- Weight basis when available
Treat each storage site as its own release record
For every site group, name the internal release contact or approval path, access restrictions, staging condition, and available loading information. The same material description at two locations may have different release status or handling constraints, so keep those facts with the appropriate rows.
If a site cannot yet confirm its release authority, mark that line unknown rather than treating the entire lot as ready. These are planning facts for a review; they do not establish inspection, transport, payment, or purchase terms.
- Site group
- Release contact or approval path
- Access restrictions
- Available loading information
- Current release status
Make the photo and document map auditable
Use the inventory reference in each photo and record filename. Capture a readable tag or jacket print, a full reel or coil view, and visible condition for the corresponding line. When a document applies only to one product or batch, say so instead of assigning it across the full multi-site lot.
For unknowns, retain the image and note what is missing. A photo map makes it possible to follow a line from the count to its evidence without treating one identified reel as proof for unlike or unphotographed material.
- Tag or jacket-print image
- Full-reel or coil image
- Visible-condition image
- Inventory reference on every file
Local context and a fictional multi-site worksheet
The Water District lists current water-main replacement and extension projects on Eisenbeisz Street, Meadow Grove Drive and Elk Grove–Florin Frontage Road, involving new 8-inch PVC mains and services in specified segments.
That is public utility-project context only; it does not identify electrical cable, seller inventory, or a transaction. Illustrative inventory example—not a purchased lot: BL-EG-01 is a matching product with 500 feet documented at Site A; BL-EG-02 has 90 feet estimated at Site B. Both photo filenames match their references, Site A has an identified release contact, and Site B approval is unknown. The mistake is combining them into one 590-foot, single-location total.
- BL-EG-01: 500 feet documented at Site A
- BL-EG-02: 90 feet estimated at Site B
- Site B approval unknown
- Illustrative only, not a purchased lot
