Use a location-aware line register
Start with a row for every reel or for a genuinely identical group whose individual lengths are still retained. Give each row a stable ID such as BL-SAC-01 and repeat that ID on photo filenames, inventory files, and supporting documents. Include the manufacturer, part number, complete cable designation when known, and storage site on that row.
A grand total is useful only after the underlying rows exist. It cannot show which reel has a worn label, which line is stored outdoors, or which site has a separate release contact. The decision here is traceability: can a reviewer match every physical item to the correct quantity, image, site, and release path?
- Stable line or reel ID
- Manufacturer and part number where available
- Storage site tied to the specific row
- Photo and document filenames using the same ID
Keep per-reel quantity evidence intact
List reel count and continuous footage for each item, then state whether the amount is measured, documented, estimated, or unknown. If a group contains matching reels, preserve each reel length before showing a subtotal. A two-reel subtotal should not be written as one continuous length.
Where weight is relevant for handling, state whether it is a documented gross value, a net cable value, or an estimate. Do not use a scale number to replace footage or product identity. Keep a short unknown-length reel on its own row instead of rolling it into a confident total.
- Footage per reel, not just total footage
- Measured, documented, estimated, or unknown basis
- Reel count preserved before grouping
- Gross or net weight basis identified separately
Treat site access as a row-level field
For every site group, record storage exposure, access limits, available loading equipment, and the role that can authorize release. A forklift noted at one location should not be assumed at another. Likewise, a release contact for Site A may not be able to release a reel at Site B.
Describe constraints factually: gated access, appointment requirement, limited dock access, or unknown loading equipment. This is not a transport promise. It lets the lot record preserve practical differences without asking a buyer to infer the condition or access of every reel from a single wide photograph.
- Storage exposure and condition by row
- Access limit or appointment note
- Available loading equipment or unknown
- Release role associated with that site
Keep port context in proportion
The Port of West Sacramento states that its history has served agriculture, natural resources and construction in Northern California; it identifies rice exports and cement imports as primary current cargos. This is regional logistics and construction context only. It does not identify cable at the port, establish a seller relationship, or make a multi-site lot available.
Its limited relevance is that a clear location field, handling note, and supporting record help preserve the chain between an inventory line and its stored material. The useful seller work is still the reel-level register, not a claim about regional activity.
- No port-held inventory is implied
- Location records remain seller supplied
- Condition and quantity stay attached to the same line
- Regional context does not replace a release record
Illustrative two-site packet and unknowns
Illustrative inventory example—not a purchased lot: BL-SAC-01; matching product; 500 feet documented; Site A; photo BL-SAC-01-tag.jpg; release role listed for Site A. BL-SAC-02; same product family; 90 feet estimated; Site B; photo BL-SAC-02-tag.jpg; loading equipment unknown. The two rows remain separate even though the products may later be grouped.
The common mistake is one lot-wide footage number and one warehouse photo for material at different sites. The resolution is one row per reel or continuous piece, with matched photos, quantity basis, site, condition, and release details. Unknowns stay visible until a seller can clarify them.
