Assign a durable ID to every physical piece
Give every reel or continuous piece a line ID before building the spreadsheet. Reuse that exact ID in the inventory row, tag photo, jacket-legends close-up, overview image, and any existing document. A stable reference is what allows a reviewer to see whether a photograph and a quantity belong to the same reel.
Do not use one warehouse overview as evidence for a mixed lot. If an item cannot be matched to a photo or document, keep its record in the list and label the supporting field unknown. That is more useful than forcing it under another reel’s reference.
- Line or reel ID repeated in all files
- Tag, jacket, and overview photo references
- Document reference where one exists
- Product group stated without hiding distinct specifications
Retain quantity and construction at reel level
For each row, record manufacturer, part number, construction, conductor material, size, marked rating, reel count, and continuous footage. Identify footage as measured, documented, estimated, or unknown. Keep an estimated 90 ft partial reel distinct from a documented 500 ft reel even when the product designation matches.
Large-lot totals can be provided as a summary after the individual lines are complete. They should not replace per-reel quantities, because an aggregate figure cannot show how many usable continuous pieces, partial reels, or condition variations are included.
- Manufacturer and part number
- Construction, conductor material, size, and rating
- Reel count and current continuous footage
- Measured, documented, estimated, or unknown quantity basis
Group the file by actual storage site
Create a site group for each warehouse, yard, or disclosed project location. Add the actual address or site area, the on-site contact, loading access, reel dimensions, and weight basis available for the items in that group. Do not imply that a reel at one site has the same access or release status as a reel at another site.
The city profile lists a navigable waterway, I-40, I-540, I-49, multiple Class I railroads and Arkansas & Missouri Railroad short-line freight service in the area. This is background only, not a transport promise. The useful seller work is to document the real site conditions for each group.
- Storage address or identified site area
- Site-group ID and on-site contact
- Dock, forklift, crane, or trailer access when known
- Reel dimensions and gross, net, or estimated weight basis
Define the offered boundary line by line
A mixed lot can include uninstalled stock, removed cable, and recovery-only pieces. Preserve those distinctions on individual rows. Record the owner, release authority, pending approval, and any relevant site restriction next to the item rather than assuming one authorization covers the entire spreadsheet.
The main error is a grand-total footage figure accompanied by one warehouse photo for reels at different locations. Correct it by matching every item to an ID, a site group, a construction, a current quantity, and its own release status.
- Condition category for each line
- Owner and release authority for the offered item
- Pending approval labeled as pending
- Included or excluded status visible in the row
Send a usable multi-site inventory record
Fictional example—not a purchased lot: BL-FS-A01 is one reel with 500 ft documented at Warehouse A. BL-FS-B02 is one reel of the same recorded product with 90 ft estimated at Yard B. Their tag, jacket, and overview filenames match their IDs, and owner approval for Yard B is pending. This example makes the site and quantity difference visible instead of burying it in one total.
If exact weight, dimension, or release authority is not available, retain the row and state unknown or pending. Email the inventory and photo set to saleselectricalbuyers@gmail.com. Industrial Wire Buyer can arrange trucking for reviewed surplus wire and cable lots, while specific handling and purchasing terms remain tied to the actual submission.
- Example line: BL-FS-A01; one reel; 500 ft documented; Warehouse A
- Example line: BL-FS-B02; one reel; 90 ft estimated; Yard B
- Photo filenames matched to each line ID
- Yard B release: owner approval pending
