Set one stable reference for every reel or continuous piece
Assign a distinct line or reel ID before grouping anything. Use the ID on the inventory row, photographs, product records, and site notes. Record manufacturer, part number, readable designation, conductor material, size or count, marked voltage, condition category, and a matching-group basis. Only group reels after confirming that their material records genuinely match.
A multi-site list becomes unreliable when one project name or one warehouse photo stands in for many different items. Keeping the identity of each reel intact makes it possible to see which attributes are known, which are estimated, and which belong to another site.
- Use one line or reel ID across inventory, photos, and records.
- Record specification and matching-group basis before adding totals.
- Keep unknown items visible instead of forcing them into a group.
Preserve per-reel quantities and condition differences
Give each reel or continuous piece its own length and state whether it is measured, documented, or estimated. Show reel count and length per reel when a group is genuinely identical, but do not turn separate cut pieces into a single continuous length. Separate unused, removed, and recovery-only condition categories so a bulk total does not hide meaningful differences.
The City says Somerville infrastructure work spans roads, sidewalks, parks, sewers, utilities and schools, with some assets dating to the 1870s; it lists active and ongoing improvement projects. That public context may explain why a seller has project-linked records or access constraints, but it does not show that a particular bulk lot exists, is available, or is connected to Industrial Wire Buyer.
- Record reel count, length per reel, quantity basis, and cut-length status.
- Keep material specification and condition category separate.
- Do not replace line-level lengths with one grand-total footage figure.
Make photos prove only the line they document
Name photo files with the line or reel ID and capture the readable tag, jacket marking, reel overview, visible condition, and relevant storage context for that item. An overview image can show scale or location, but it does not identify every cable in a large lot. If a photo is unavailable, say so on the inventory line rather than reusing a picture from another reel.
Attach matching documents to the same line ID and identify their scope. This prevents one tag, data sheet, or dimension note from being silently applied to nonmatching reels. A photo set should make the inventory clearer, not erase differences between sites or material types.
- Use line ID prefixes in tag, jacket-print, overview, and condition filenames.
- Identify which item a document or photo covers.
- Flag a missing image or record rather than substituting another reel’s evidence.
Split site access and release facts by location
For every storage site, list the location description, reel IDs stored there, dimensions, gross, net, or unknown weight basis, on-site loading resources, access limits, and seller-side release authority. A forklift or a contact at one site should not be assumed for another. Keep a requested timetable as seller information rather than a promise of a collection date.
When a site detail is not confirmed, mark it unknown and preserve any available note about gates, clearances, loading surfaces, or approvals. These facts allow the lot to be understood site by site without creating an agreement about freight, pickup, pricing, payment, or acceptance.
- Record site location and reel IDs stored at that site.
- State dimensions and gross, net, or unknown weight basis separately.
- List loading equipment, access limits, and release authority per site.
Illustrative two-site line-control record
Illustrative inventory example—not a purchased lot: line A BL-SOM-EXAMPLE-05, matching product, 500 ft documented, Site A; line B BL-SOM-EXAMPLE-06, same product, 90 ft estimated, Site B; photo linkage A-tag.jpg and B-overview.jpg; release site authority unknown. These fictional entries show why two reels may have the same broad product description but different lengths, locations, photo evidence, and release status.
The recurring mistake is one grand total and one warehouse photo for a mixed inventory. The resolution is one row per reel or continuous piece, a stated quantity basis, line-linked photos, and separate site and release fields. This is a coordination task for a bulk lot, not a material-classification substitute for the specialized sibling pages.
- Example line A: 500 ft documented at Site A.
- Example line B: 90 ft estimated at Site B.
- Example unknown: seller-side site release authority.
