Start with the physical balance, not the original order
An order acknowledgement or inventory export can identify a product, but it may not show what remains on a partly used reel. Walk the offered stock and give each reel or genuinely identical group a stable reference. Against that reference, record the part number, the current continuous length, and whether the length is measured, documented on a record, or estimated.
Keep an order total in a notes field if it helps explain the history, but do not turn it into current footage. A line that says 500 feet on the original order and 180 feet estimated on the reel should display both facts separately. That distinction lets a buyer ask the right follow-up instead of treating historic quantity as inventory now available.
- Use one reference from the spreadsheet through the photo filenames.
- Label each footage figure measured, documented, or estimated.
- List partial reels separately when their remaining lengths differ.
Keep condition categories and lengths visible
Separate unopened or otherwise uninstalled stock, partial reels, coils, previously in-service cable, and short mixed pieces. They are not interchangeable merely because the jacket printing looks alike. For each line, state the visible reel and packaging condition, storage exposure that is known, and whether the offered length is one continuous piece or several pieces.
Do not improve the record by combining short pieces into a number that resembles one long length. If a cable end, tag, or package is missing, say what is unavailable and attach the best remaining photo. An honest unknown is more useful than a tidy-looking line that borrows information from a neighboring reel.
- Show readable tag and jacket-print photographs for each specification.
- Keep full reels, partial reels, coils, and short pieces on separate lines.
- State known storage exposure and visible packaging or jacket issues.
Clear the release gate before calling a line available
Availability has two parts: the material must be physically present, and someone must be able to authorize its sale and release. Identify the owner or organization controlling each offered sublot, the person or role authorized to release it, and whether a line is reserved, pending return, or awaiting internal approval.
Do not include a pending reel in an offered total simply because it appears in the same warehouse report. Mark it as pending and state the confirmation still needed. This prevents a buyer from reviewing material that cannot yet be transferred and helps the seller focus on the records needed to resolve the gap.
- Name the release authority or mark it unknown.
- Separate reserved or return-pending stock from the offered sublot.
- Identify the actual storage location for every offered group.
Make photos and records answer the same line item
Use the reel reference in every image name and place the matching filenames on the inventory line. A useful set shows the tag or manufacturer label, a readable stretch of jacket printing, the whole reel or coil, and any visible condition issue. Existing purchase or delivery records can be included when they can be linked to the same identified item.
If a document covers a family of products but not the offered reel, label it background only. Do not use it as proof of the current balance. Keeping product identity, quantity basis, and photographs together creates a compact record that can be reviewed without guessing which evidence belongs to which reel.
- Match photo filenames to the inventory reference exactly.
- Photograph tag, jacket printing, whole reel, and visible condition.
- Describe a document as unmatched when it cannot be tied to the reel.
Use local context only to explain a possible surplus situation
The City of Overland Park says its Unified Development Ordinance regulates land use, including what structures may be built, where they may be located and how they may be used; the city began a two-year update in 2024. That is limited local context for why a seller might be reconciling uninstalled material after a changing project scope; it does not identify a cable lot, show that material is available, or establish purchasing interest.
For example, an illustrative record might show reference OP-SW-14, a feeder-cable part number photographed on its tag, two reels with 300 feet documented and 180 feet estimated, and one pending release confirmation. The common error is reporting both reels as the original order quantity. The fix is to present the current evidence basis and hold the pending reel outside the available total until authority is confirmed.
- Keep the inventory intact while its balance and release status are being checked.
- State what remains unknown and the record or confirmation needed to resolve it.
