Use one persistent line per reel or piece
Assign a unique line or reel ID and reuse it in the inventory, photo filenames, and existing documents. A line should name the manufacturer, part number, designation, metal, size or count, rating, and per-piece length when known. The task here is lineage: a person reading the list should be able to move from a line ID to the physical reel and its evidence without reconstructing the connection from a grand total.
A bulk list may contain unlike materials, but it should not hide the differences. Keep copper and aluminum, power and control cable, full reels and cuts, and documented and unknown lines distinct. The better sorting method is evidence-first, not a single category called "mixed wire."
- Line/reel ID used in inventory, photos, and records.
- Specification and physical-quantity fields per piece.
- No merged total for differing material or evidence.
Keep each storage site visible
Group the inventory by actual storage point, then retain the individual line within that group. Record site notes, material condition or history, releasor, loading access, and restrictions for the same line. A reel at a yard with one releasor is not automatically interchangeable with an identical description in a warehouse with another releasor.
Hidalgo County reported that the FM 396 overpass improved access to the Anzalduas International Bridge and described Rio Grande Valley trade and commerce involving goods moving from Mexico. That regional fact does not prove a multi-site inventory exists. It is relevant only to why a seller should keep location and release authority attached to each actual storage point.
- Actual storage site and site notes.
- Release authority and access constraints per site.
- Condition/history retained with the physical line.
State quantity and weight bases honestly
For each piece, state footage as measured, documented, estimated, or unknown. If a weight is listed, state whether it is gross, net, cable-only, or unknown, and do not use that number to erase the footage basis. Do not add measured and estimated footage into an unlabeled total. Retain the quantity basis for every row so the source of the number remains visible.
When a length is estimated, add the method briefly, such as remaining-wrap observation, and keep it separate from measured or label-documented lengths. A bulk inquiry becomes more actionable when its uncertainty is distributed accurately, reel by reel, rather than buried in a summary.
- Footage basis for every line.
- Weight basis and known dimensions.
- Estimate method where an estimate is used.
Reconcile documents and images
Put the matching photo filename and document reference beside each line. A shipping record or prior list may identify a group, but it should not be used to fill a part number or length on a different reel. When an image or document cannot be matched, leave it unlinked and note the gap rather than applying it to every item at that site.
This approach also handles incomplete inventory. A reel without a tag can still have a line ID, site, image reference, condition note, and unknown specification fields. Keeping it separate allows the seller to improve that one record without changing the description of the rest of the lot.
- Photo filename and document reference per line.
- Unmatched documents left unlinked.
- Unknown specification fields retained with the correct reel.
Worked multi-site inventory record
Illustrative inventory example—not a purchased lot: line MC-BL-01; 500 ft documented; warehouse A; tag photo MC-BL-01-tag.jpg; releasor: warehouse role recorded. Line MC-BL-02; 90 ft estimated by remaining wrap; yard B; part number unknown; releasor: unknown. The fictional lines are not combined into 590 ft because their sites, evidence, and quantity bases differ.
The common mistake is reporting one grand-total footage figure for a set of reels at several locations. Correct it by using one row per reel or piece, retaining site and specification grouping, and making unknowns visible. The result is a seller record, not a promise about freight, pickup, timing, or any other lot term.
- One row per physical piece.
- Site, specification, and quantity differences remain visible.
