Reconcile the physical balance before listing a lot
An old purchase order is useful history, but it is not a current inventory count. Start with one row for each physical reel or continuous piece. Match its reel reference, manufacturer marking, storage site, and remaining footage against the export. Set the footage basis to measured, documented, or estimated; do not make an estimate look measured.
Mark a line consumed, reserved, missing, pending return, or available. This is a balance exercise rather than a product-classification exercise. A reel can be accurately identified and still be unavailable because another job has reserved it. Keeping that status beside the quantity prevents an inquiry from silently treating historical footage as saleable footage.
- Use a stable reel or item reference in the inventory and photo filenames.
- Keep original order quantity in a history field, separate from current footage.
- Name the storage site for each row rather than giving one broad warehouse total.
Separate availability from condition and source
Record full reels, partial reels, cut lengths, and removed material on different lines. Also state why the stock became excess: project overrun, distributor inventory, maintenance stock, or closeout. That description helps frame the record, but it does not replace the jacket designation, continuous length, and visible condition notes.
For each available line, note whether the cable is uninstalled or removed and describe storage exposure such as indoor, covered, or outdoor. If a reel has a damaged flange, open packaging, or an exposed end, record it plainly. Preserve the material as found while the documentation is assembled instead of changing lengths to make the table look uniform.
- List one continuous length per reel or piece.
- Keep removed material distinct from uninstalled excess stock.
- Describe storage exposure and visible reel or jacket issues without guessing at unseen condition.
Make release authority a separate decision
Availability is not the same as authority to release a reel. Add an owner, the person or role able to authorize release, the approval status, and any known release constraint. When authority is pending, leave the quantity visible for reconciliation but mark the line unavailable until the necessary authorization exists.
Folsom Economic Development describes a strong tech orientation across corporate partners and small business, and says the city supports new, expanding and legacy businesses. That local description is only background for facility and project-stock scenarios; it does not identify a seller, an offered cable lot, or a business relationship with Industrial Wire Buyer.
- Record owner and release authority as different fields where they differ.
- Use pending, reserved, or unavailable rather than implying an unresolved reel can be transferred.
- Give the release contact enough context to match it to the correct inventory row.
Tie the evidence file to the current row
Photograph the readable tag or jacket marking and name each file with the reel reference. A photo from a similar reel is not evidence for the row being offered. If the manufacturer part number is incomplete or the marking cannot be read, write unknown and say whether a tag, packing record, or further photo may clarify it.
A practical submission has a small audit trail: row reference, current quantity basis, label evidence, condition note, storage site, and release status. That package lets the buyer ask follow-up questions about the actual balance rather than trying to reconstruct the lot from an invoice total and unlabelled images.
- Match photo filenames to inventory references exactly.
- Capture complete readable jacket or tag markings, not only a color or product nickname.
- Flag unknown fields and their reason instead of borrowing a neighboring reel’s information.
Worked current-balance example
Use a fictional row to keep original and current information separate. For example, OV-FOL-01 can be described as project-overrun feeder cable with the part number recorded from the tag, two reels, 300 feet documented, and 180 feet estimated. One reel can be noted as uninstalled while its release remains pending. This is an illustrative inventory record, not a report of a purchased lot.
The useful correction is not to delete the old order record. Keep it as history, but make the current reel balance and release status the fields that determine whether the line belongs in the inquiry. If the estimated reel cannot be reconciled, retain it as an estimate or take it out of the available list.
- Example reference: OV-FOL-01.
- Example evidence: OV-FOL-01-tag.jpg and OV-FOL-01-jacket.jpg.
- Example status: one reel release pending; do not count it as currently available.
