Give each reel and site a stable reference
For a lot spread across a warehouse, yard or project area, assign a reel or line ID before taking photographs. Reuse that ID in the inventory row, photo filenames, storage-site field and supporting record. A group may share one line only when the products, condition and location are genuinely the same; otherwise retain separate references.
Port Milwaukee describes multimodal sea, rail and interstate transportation and reports 27 million metric tons of cargo handled. That citywide transportation context makes clear site fields useful for a bulk inquiry, but it does not mean a listed lot is at the port, is affiliated with the port, or has any particular transport arrangement.
- Use one stable reel or line ID in the list, photos and documents.
- Record the storage site beside the reference, not only in a lot-level note.
- Mark a representative-photo group only when every grouped reel matches the stated specification and condition.
Keep per-reel quantities visible
Record manufacturer, part number, complete designation, reel count and continuous length for each reference. State whether footage and any weight are measured, documented or estimated. A total footage figure can still be included for orientation, but it should not replace the length of each reel or continuous piece.
For a partially accessible reel, enter the best supported value and mark the basis. Do not convert an estimated gross loaded-reel weight into a cable-only or conductor weight. If weight, dimensions or footage are unknown, state unknown and identify the person or record that might resolve the field.
- Keep reel count separate from continuous length per reel.
- Label every quantity and weight as measured, documented, estimated or unknown.
- Keep products with different markings, lengths or condition on different lines.
Match photographs and records to the same item
For each distinct specification, collect a readable reel tag, jacket legend, reel overview and any visible condition difference. Name the files with the reel or line ID, such as BL-MKE-01_tag and BL-MKE-01_jacket. A representative image is useful only when the inventory says precisely which matching reels it represents.
Attach a data sheet, packing list or inventory export only to the reel or group it actually describes. If a record has a different part number, batch, storage site or condition than the offered line, note the mismatch instead of treating it as support. A clear mismatch is more useful than a polished but ambiguous inventory file.
- Photograph tags and jacket printing as separate identification views.
- Record the matching document filename or state that no matching record is available.
- Describe visible damage or packaging differences at the same reference level as the quantity.
Separate sites, release contacts and access facts
Do not let one site note stand in for the whole lot when release contact, access, condition or loading resources vary. Keep the warehouse, yard and project-area entries separate, with the person who can confirm release for that location. Identify gates, appointment rules, dock access, available loading equipment and any restrictions as facts to discuss, not as arranged services.
If a site is not ready to release material, mark its status pending and retain its quantities outside the stated available balance. When an access detail is unknown, say so and list the site contact who can clarify it. This is different from deciding price, pickup, freight or acceptance terms, which require a lot-specific discussion.
- Use a site field, release-contact field and access-restrictions field for every line.
- List loading resources as available, unavailable or unknown; do not assume a movement plan.
- Keep pending-site quantities distinct from quantities the seller has confirmed as available.
Correct the common grand-total mistake
The common mistake is presenting one grand-total footage figure and one representative photo for reels held at different sites. That record hides whether each reel has the same product marking, remaining length, condition, release contact and access situation. It can also make a quantity at a pending site look ready for discussion.
Correct it by using one row per reel or genuinely identical group, matching photographs to each reference and keeping site-specific facts in that row. Where two reels have the same part number but different length basis or condition, retain two rows. Where a field is incomplete, label it unknown rather than borrowing information from a nearby reel.
- Do not substitute a lot total for reel-level evidence.
- Do not use one site contact or photo as evidence for another site.
- Preserve unknowns and pending status instead of converting them into assumptions.
Illustrative multi-site inventory record
The following record is illustrative only—not a purchased Milwaukee lot. It shows how location, quantity basis and unknown handling can remain visible without claiming that the entire lot is one uniform product.
BL-MKE-01: Site A, one reel, 500 ft documented, tag and jacket photos matched to the recorded designation, release contact listed. BL-MKE-02: Site B, one reel, 90 ft estimated, same designation not yet confirmed, gross loaded-reel weight unknown, loading resources to be confirmed. Keep both lines separate until their site facts and evidence match.
- Example label: Illustrative inventory example—not a purchased lot.
- Use the reel or line ID in every associated filename and document reference.
