Give every physical item a stable reference
Assign each reel or continuous piece a line ID and use that same ID in the spreadsheet, photo filenames, and document names. A stable reference lets a reviewer connect a tag photo, a product record, a footage number, and a storage location to the same physical item instead of guessing which reel a file represents.
For a group of truly identical reels, retain the count and the individual footage basis. Do not use one photo or one inventory row to stand in for several items that have different tags, conditions, or storage sites.
- Line or reel ID.
- Photo filename and document filename.
- Storage location for that ID.
Keep specification differences in the list
Record manufacturer or part number, designation, conductor metal and size, rating, condition, and current continuous length for each line. Group only the items that genuinely match in specification and condition. The point of a bulk list is not to make the total shorter; it is to keep material differences available for review.
If an item is unknown, leave it in the inventory with an explicit unknown field and its supporting photo. Do not force it into the nearest product family simply to complete a column or enlarge a uniform total.
- Manufacturer or part number and designation.
- Metal, size, rating, and condition.
- Current continuous length for each reel or piece.
State the quantity and weight basis
Show reel count and footage per reel, and label each figure measured, documented, or estimated. Keep gross reel or pallet weights distinct from cable-only or conductor weight. An aggregate number can be included as a summary, but it should never conceal the per-reel continuous lengths that produced it.
The common error is publishing one figure such as 2,000 ft for several reels at several sites and attaching one representative photo. Correct it by maintaining one row per reel or piece, matching each photo, and disclosing estimated values rather than manufacturing a unified lot description.
- Reel count and per-reel footage.
- Quantity basis for every length.
- Weight value and weight basis.
Map sites, access, and release
Group lines by actual storage site and add access limits, available loading resources, release contact, and requested timetable. These fields describe the seller’s situation; they do not assume a transport method or a completed transaction. If the release contact for a site is unknown, retain that unknown with the relevant line IDs.
Jackson-Medgar Wiley Evers International Airport serves approximately 1.2 million passengers and handles nearly 20 million pounds of air cargo, mail and packages annually. This local fact does not show that an inventory is at the airport or that it will be purchased. It is a limited reason to keep multi-location records and access information organized.
- Site and access limits.
- Available loading resources.
- Release contact and requested timetable.
Test the list with a fictional multi-site record
This fictional illustrative record—not a purchased lot—shows why separate rows matter: BL-JX-01; matching product; 500 ft documented; Site A; photo BL-JX-01_tag.jpg. BL-JX-02; same product; 90 ft estimated; Site B; photo BL-JX-02_tag.jpg; Site B release contact unknown.
The sample does not establish a transaction; it shows a checkable record. Before sending a bulk list, confirm that every photo and file name maps to one line ID and that any unknown quantity, specification, or release field remains visible.
- Fictional line A: 500 ft documented at Site A.
- Fictional line B: 90 ft estimated at Site B.
- Site B release contact: unknown.
