Create one inventory row that follows a reel
Assign a stable line or reel ID before naming photo files or collecting documents. Each row should identify one reel or one continuous piece with its manufacturer, part number, product designation, condition, and quantity basis. A grand-total footage number cannot show which physical item a photograph represents.
Use the same reference in the inventory, photo filename, and any document note. If several reels are truly identical, you may identify a group, but retain each reel count and per-reel length. A group label never replaces the ability to find the physical material.
- Line or reel ID and matching photo filename
- Manufacturer, part number, and product designation
- Condition, reel count, and per-reel length
Group specifications only when the evidence matches
Keep conductor metal, size, marked voltage, product designation, condition, and continuous length visible for every line. Reels may look alike while carrying different part numbers, footage, or visible condition. The record should make those differences easy to see before a seller asks that they be treated as a single group.
State whether each quantity is documented, measured, or estimated. When a reel lacks a specification or a photo, leave it on a separate unknown line rather than blending it into a better-documented total. That practice protects the integrity of both the known group and the unknown item.
- Specification fields retained per reel
- Continuous length and quantity basis
- Unknown reels kept outside confirmed groups
Map rows to actual storage sites and access
Group the finished list by warehouse, yard, or project storage location and retain the line IDs underneath each site. For every site, record access restrictions, available loading equipment, and the site contact who can coordinate entry. This is the seller’s site information, not a promise about a pickup method.
Multi-site does not require one combined lot. State whether material is offered together or in defined groups, and give a requested release timetable if known. A separate site record prevents an available reel at one location from being mistaken for an accessible reel at another.
- Storage location and access restrictions
- Available loading equipment
- Site contact and requested release timetable
Record release authority beside the site decision
Identify the owner or person authorized to release material at each location. A site contact who can show a reel is not necessarily the person who can authorize sale or release, so keep those roles distinct when they differ. If authorization is pending, show that status on the relevant row or lot group.
The core error in a multi-site lot is a single footage total that hides different conditions, sites, and release contacts. The practical fix is one row per reel or continuous piece, with site and specification grouping retained and each quantity labeled documented, measured, or estimated.
- Owner and release authority
- Lot grouping
- Pending authorization visible on affected rows
Worked two-site record and unknowns
Illustrative only—not a purchased lot: BL-I-01 at Site A is one reel with 500 ft documented; BL-I-02 at Site B is one reel with 90 ft estimated. Their condition and release contacts are recorded separately even when the product record matches. The example shows why one grand total would hide the differences a buyer needs to review.
For an incomplete list, leave a reel on its own row with an unknown field such as photo pending, marked voltage unknown, or release contact pending. State only the material detail you actually have, then add the related site and access facts. This gives Industrial Wire Buyer a concrete, organized record without pretending every line is fully documented.
- Mistake: one grand-total footage figure across sites
- Resolution: row-level site, specification, and quantity-basis record
- Illustrative record distinguishes documented from estimated length
