Give every reel or continuous piece a stable line ID
A bulk lot becomes reviewable when a spreadsheet row, photo filename, product document, and storage location all use the same reference. Assign one ID to each reel or continuous piece before grouping anything. If several items share a product designation, retain their separate IDs whenever their footage, condition, site, or release status differs.
Use a simple reference such as BL-YU-01 in each record. This avoids a common failure of large lists: a grand total that cannot be traced back to a physical item. A stable ID also lets a seller add evidence later without replacing the entire inventory file.
- Line or reel ID.
- Photo reference.
- Document reference.
- Storage-site field.
Build one evidence line for each item
For every line, capture manufacturer, part number, full designation, conductor metal, size, count, marked voltage when available, reel count, and continuous footage. State whether footage is measured, documented, or estimated. Do not merge matching-looking reels where the markings or quantity basis have not been compared.
Use the same line to note visible condition and packaging. Where identification is incomplete, keep the item in the list with an unknown field and a photo reference. That is better than assigning the entire mixed lot the specification of one readable reel.
- Manufacturer and part number.
- Designation, metal, size, count, and voltage.
- Reel count and per-reel footage.
- Condition and quantity basis.
Keep site and release differences visible
A lot at more than one warehouse, yard, or project storage point needs more than a total quantity. Add the actual storage site, ownership or control note, release-authority role, loading facts, and access restrictions to each line or site group. Do not assume a contact at one site can authorize material at another.
If location access is restricted, state the limitation and identify what documentation is available. These fields help describe the seller’s inventory; they do not commit either party to a collection method, schedule, or commercial term.
- Site and ownership or control note.
- Release-authority role.
- Loading resources and access limits.
- Requested timetable if the seller has one.
Label every dimension and weight basis
For large reels or pallets, add available dimensions and specify whether a reported weight is gross loaded-reel, cable-only, net, or estimated. Do not convert a gross figure into conductor content. A line-level weight basis is useful even when the exact weight is unknown, because it tells a reviewer what the number does and does not represent.
The Greater Yuma Port Authority says the San Luis II Commercial Port of Entry serves agricultural commodities, manufactured goods and binational commerce, and that SR 195 is a principal overweight corridor serving the commercial port. This is limited local context for organization of supply-chain inventory; it does not promise freight, pickup, or a buyer relationship.
- Dimensions per reel or pallet.
- Gross, cable-only, net, or estimated weight basis.
- Known loading equipment.
- Unknown weight marked as unknown.
Illustrative multi-site record
Illustrative inventory example—not a purchased lot: BL-YU-01; matching product; one reel; 500 ft documented; Site A. BL-YU-02; same product; one reel; 90 ft estimated; Site B. Photo filenames match the line IDs; the listed weight is gross loaded-reel weight with a documented basis.
The mistake to avoid is treating those two lines as one footage and weight total. Resolve it by retaining one row per reel or continuous piece, matching evidence to the row, and preserving site, specification, release, and quantity differences even within one inquiry.
- Fictional record only.
- One row per reel or continuous piece.
- No combined footage or weight assumption.
