Freeze the offered balance before sending totals
Use an ERP export, purchase order, or count sheet as a starting point, then match every line to physical stock. Give each reel or package an inventory reference and identify its current availability. Flag reserved, returned, committed, or approval-pending items so the offered balance does not overstate what the seller can release.
A purchase order may identify a product, but it does not prove the current remaining footage. Where a balance has changed, preserve the original record as background and state the present quantity as measured, documented, or estimated. This is a reconciliation task, not an assumption that the inventory system is current.
- Record inventory line, reel ID, current availability, and reserved or pending status.
- List each partial reel separately from full or sealed stock.
- Exclude an unconfirmed line from the sale-ready balance while keeping it visible as pending.
Make every photo and product line traceable
Use the same inventory reference in the spreadsheet, reel photograph, and document filename. Group reels only when the manufacturer, part number, complete designation, and per-reel length genuinely match. If two reels have the same part number but different remaining footage or damage, retain separate quantity and condition entries.
Read the product record rather than relying on a warehouse aisle label. Record manufacturer, part number, designation, conductor metal and size when shown, marked voltage where relevant, and each reel’s length. A readable tag can establish a product identity; a broad category such as “miscellaneous wire” cannot do that work.
- Use a reference such as WH-A-014 in both the photo filenames and the inventory line.
- Retain manufacturer, part number, designation, reel count, and per-reel length.
- Keep products with different markings or quantities on separate lines.
Label footage and weight by their real basis
State whether footage is measured, documented, or estimated for every line. When a weight is useful for describing a large reel, label it gross, net, or unknown and state whether the reel or packaging is included. A loaded reel weight is not a substitute for a remaining footage count or a conductor-content statement.
Unknowns should be recorded where they occur. For example, a reel with a clear tag but no current footage can be an identified line with estimated quantity; it should not be combined with a documented balance from a different site to produce a more impressive total.
- Record continuous footage, quantity basis, gross, net, or unknown weight, and reel dimensions.
- Do not turn several reels into a claimed single continuous length.
- Keep an estimate labeled as an estimate even when a related record exists.
Describe the actual storage and release situation
Butte County says the county is accessible by Highways 99 and 70, with some areas about 20 minutes from Interstate 5, and highlights small and medium-sized companies and market access. That access context can help a seller explain where a warehouse line is stored and what site access is available; it does not promise transport, collection, or a local buying facility.
For each site, record the storage location, access limits, available loading resources, release authority, and requested timetable. A lot split between two warehouses needs two location records even when product specifications match. This prevents one site’s availability or approval status from being applied to another site by mistake.
- List storage site and access limits for every group of reels.
- Describe available loading resources without assuming a carrier or collection method.
- Identify the release authority and whether site approval remains pending.
Worked multi-site reconciliation record
Use this fictional line as a model: WH-A-014; matching manufacturer part number on two reels; 500 ft documented at Site A and 90 ft estimated at Site B; partial reels; Site B release approval pending. It is illustrative only and is not a purchased lot.
The mistake is presenting one old purchase order or one grand-total footage figure as the current available quantity for a mixed lot. Resolve it by reconciling each physical reel, preserving per-reel lengths, naming the evidence basis, and separating reserved or approval-pending stock from the confirmed offered balance.
- Illustrative only—not a purchased lot: reference WH-A-014.
- Quantity: 500 ft documented at Site A; 90 ft estimated at Site B.
- Condition: partial reels; Site B release approval pending.
- Use separate site records when access or release status differs.
