Give every reel and file a stable reference
Assign an inventory ID to each reel or genuinely identical group, then use that exact ID in the spreadsheet, photograph filenames, and any document notes. Add specification, reel count, continuous length, condition, and measurement basis beside the ID. A reference system lets a reviewer connect a tag photo and a release note to one defined piece rather than to a large, shifting total.
The common mistake is one grand-total footage line for different reels at different sites. Correct it by breaking the total into per-reel or defined-group rows. Do not use a photograph of one marked reel as evidence for unrecorded reels unless their matching status is documented in the same group.
- Use one stable ID for the inventory row, file names, and document references.
- List length per reel and whether it is measured, documented, or estimated.
- Keep different specifications, conditions, and weight bases on separate rows.
Group by actual storage site and release authority
Add the actual storage site or ZIP, the condition reported for that site, the person or role able to authorize release, and whether the material is offered as one lot or defined groups. If the same product appears at two sites, retain separate lines or site fields so the physical location and approval path do not disappear into a single quantity.
Record seller-known reel dimensions, gross or net weight basis, loading resources, access restrictions, and desired release timetable. These are inventory facts, not an agreement to move material. Where an item is not known, write unknown instead of filling the row with a generic site assumption.
- Keep site location, release authority, and access limits with the appropriate inventory group.
- State whether a multi-site list is one lot or separately defined site groups.
- Add dimensions, weight basis, and loading notes only to the line they describe.
Use local logistics context without attributing a lot to it
The Port of Tucson reports more than 700 acres, over 2.2 million square feet of manufacturing, warehousing and distribution buildings, and over 13 miles of track.
This is limited context for why a Tucson seller may need disciplined warehouse or distribution-lot records. It does not identify material at the Port or imply a source relationship. The practical seller task is still to state each actual storage location, access limitation, and release contact for the inventory being offered.
- Do not use an intermodal or warehouse-area description as a substitute for a storage-site record.
- Keep local context separate from inventory ownership and release details.
- List only seller-known site facts for the offered reels.
Turn a collapsed lot into reviewable lines
Illustrative inventory example—not a purchased lot: BL-TUS-07A is one documented 500 ft reel at Site A; BL-TUS-07B is the same recorded product with 90 ft estimated at Site B. The tag photo for the first uses BL-TUS-07A and the overview photo for the second uses BL-TUS-07B. The site contacts are separate and loading resources are unknown.
The correction is not to invent one combined 590 ft continuous length. Preserve two references, two quantity bases, and two site records. Before submitting, ensure each row can be matched to its photos, product evidence, condition notes, and release information. This allows a buying review to address the actual inventory rather than a grand total that cannot be released as one piece.
- Required evidence: inventory ID, photo filenames, specification, reel count, length per reel, and quantity basis.
- Add site, condition, release authority, lot grouping, dimensions, weight basis, and access information.
- Keep unknown loading or approval details visible at the appropriate site level.
