Reconcile the current balance before offering it
An old purchase order or warehouse export is useful background, but it is not proof of what remains. Walk the stock and give each reel, coil, or distinct cut length a stable reference. Match that reference to the record, a reel-tag image, and a readable jacket-print image. Record the present reel count, storage location, condition category, and remaining continuous footage for each line.
The inventory mistake on this kind of lot is reporting the original order quantity as though it were still available. Retain the original figure as history, then report the current balance separately. If footage is estimated, say so and identify the basis; do not combine an estimated partial reel with documented full reels simply to produce one larger total.
- Use the same inventory reference in the spreadsheet, tag photograph, jacket photograph, and any supporting record.
- Mark footage as measured, documented, or estimated for each reel.
- Keep full reels, partial reels, cut lengths, and unidentified pieces on separate lines.
Separate release status from product identity
A reel can be correctly identified and still be unavailable because it is retained for spares, assigned to another job, or awaiting internal approval. Add a release-status field and the role responsible for authorization to every line. “Available,” “reserved,” and “approval pending” are more useful than a blanket statement that the entire warehouse list is for sale.
Do not remove a reserved line just because it is not ready to offer. Keep its reference and evidence in the file, but distinguish it from the present offer. This prevents a reviewer from treating a historical inventory record as a released quantity and lets the seller update one line when authorization changes.
- State the reason for a hold: spare stock, another project, or approval pending.
- Identify the authorization role, not personal contact details, where release is unresolved.
- Keep release status independent from condition and footage.
Use local business context without turning it into a claim
The City’s business page describes small businesses, high-technology companies, and craft brewing, bioscience, software, hardware and clean-energy activity in San Ramon.
That is context for describing whether a balance came from a business change, a technology facility, or a project file; it does not identify a seller, prove that a local lot exists, or imply that the City is involved. The useful local detail in an inquiry is the actual material location, the record owner, and the authorization path for the offered reels.
- Describe the actual stock source only when known.
- Do not substitute a project name or general business category for cable markings.
Use a fictional reconciliation record and expose unknowns
A workable inventory row can show both what is known and what remains unresolved. Illustrative inventory example—not a purchased lot: reference OV-SR-04; product: manufacturer and part number on tag, full designation pending; quantity: two reels, 300 ft documented and 180 ft estimated; status: uninstalled, release approval pending. The documented and estimated balances remain separate so no one reads 480 ft as one confirmed continuous length.
When a tag cannot be read, enter “unknown” or “pending,” attach the best available photo, and explain whether access, visibility, or a missing document prevents confirmation. Do not create a replacement part number from a similar reel. The missing field is a useful buying-review fact, not a reason to make an unsupported specification.
- Photograph the tag, jacket printing, and overall reel under the same reference.
- State the limitation behind every unknown field.
- Preserve long identified lengths instead of altering them for an inquiry.
Send a release-ready inventory file
Before requesting a buying review, filter the list to lines that are actually released or clearly label approval-pending lines. Include the material location, practical access information, and the person or role that can confirm release. A brief note about a deadline is useful context, but it does not establish collection, pricing, acceptance, or transport terms.
This page is intentionally narrower than a bulk-lot workflow. Its central decision is whether the physical balance is genuinely releasable now. Multi-site handling, broad mixed-specification aggregation, and material-specific construction questions should remain visible as separate decisions rather than being hidden in a surplus label.
- Provide a current line-item list rather than only an original purchase total.
- Include the location and access facts for the released balance.
- Leave any price, inspection, payment, and transport terms for the actual lot discussion.
