Create a reference that follows each reel
Assign a stable line or reel reference and use it in the inventory, photograph filenames, and attached documents. A seller can group genuinely matching products, but the group rule should be visible: same manufacturer or part number, designation, condition, and storage site. One attractive reel photo should not stand in for unshown material.
Keep manufacturer, part number, designation, conductor material, size, and marked rating with the same reference. If a group contains an unknown field or a different condition, split it. The point is traceability, not the shortest possible spreadsheet.
- Use the same reference in row, photo filename, and document name.
- State the matching-group rule before grouping reels.
- Separate any item with a different specification or unknown field.
Keep per-reel quantities visible inside the larger lot
Report reel count, continuous length per reel, and the basis for every quantity: measured, documented, estimated, or unknown. A grand total can be a summary, but it cannot conceal how many continuous pieces make up the lot. A 500-foot reel and several 50-foot partial reels are not the same inventory record.
Record condition and packaging differences at the reel or group level. If only a representative photo exists, identify which rows it represents and what it does not show. This prevents a single good image from becoming accidental evidence for the entire lot.
- List reel count and per-reel footage.
- Use a quantity-basis field for every number.
- Identify which inventory rows each photograph actually represents.
Separate storage sites, authority, and access
Multi-site lists need a storage-site field, owner, release authority, and site-specific restrictions for every group. Do not merge two yards or warehouses into one location simply because the product descriptions match. Different sites can have different access, release, or loading facts.
Add known dimensions, gross or net or estimated weight basis, access limitations, and available loading information by site. These facts help describe the practical boundaries of the lot without assuming transport or collection terms.
- Use a site code or ZIP field for every line or group.
- Keep owner and release authority beside the matching site group.
- Record dimensions, weight basis, access limits, and loading information separately by site.
Fix the grand-total and single-photo mistake
The common mistake is a single total footage figure across different reels, specifications, and storage sites, supported by one pristine photo. Correct it with one row per reel or an explicitly matching group, a photo-reference field, and site-level information. Unknown loading equipment or incomplete release information should remain visible instead of being silently omitted.
Illustrative fictional inventory record—not a purchased lot: BL-PM-01 is one matching reel with 500 feet documented at Site A and loading equipment unknown. BL-PM-02 is the same documented product but only 90 feet estimated at Site B. They may share a product description, but they do not lose their separate quantities or site records.
- Example line: BL-PM-01 | 1 reel | 500 ft documented | Site A.
- Example line: BL-PM-02 | 1 reel | 90 ft estimated | Site B.
- Do not use one photo or one total to erase site and reel differences.
Use local access context without overstating it
The city identifies I-494, Highway 169, Highway 55 and I-394 as highways and interstates providing access to locations across the Twin Cities.
That transportation statement is limited context for why a seller should state the actual storage site, access limits, and loading information for a bulk lot; it does not promise collection, identify a route for a particular inventory, or establish any site capability. The seller’s own line-by-line record remains the operative information.
- State actual site access and restrictions rather than relying on a city-level route reference.
- Keep requested seller timetable separate from inventory quantity.
- Identify a business contact and release authority for each location.
