Give every reel or continuous piece a durable line ID
Assign one line or reel ID before combining information from a spreadsheet, photo folder or storage list. Use the same ID on the inventory line, tag image and any existing record. Group only reels that truly share a manufacturer, part number and complete designation; similar storage locations do not make products identical.
Where a tag is unreadable, keep the reel in the inventory under its own ID and mark the product field unknown. Do not let a good image of one reel stand in for another reel with a different marking, condition or quantity basis.
- Line or reel ID
- Manufacturer, part number and complete designation
- Photo filenames beginning with the same ID
- Explicit unknown field for unreadable or absent markings
Retain quantity and condition for each reel
List the reel count and remaining continuous footage for each line, then label the footage as measured, documented or estimated. Preserve condition observations by reel rather than applying one blanket note to the entire lot. A total derived from separate reels does not mean the footage is one continuous length.
If an estimate is all that is available, say so and attach the tag, overview or existing record that explains the basis. Large-reel dimensions and any weight should also carry a basis such as documented, gross or estimated. Unknown measurements remain useful when they are not disguised as precision.
- Reel count and length per reel
- Measured, documented or estimated quantity basis
- Condition and visible damage per reel
- Dimensions and weight with stated basis where available
Keep release and access information at the site level
For inventory stored at more than one location, identify the storage site, person authorized to release the material, access limits and available loading resources for each group. Do not merge separate site contacts into one generic lot contact. If release authority is pending, show that status next to the affected reel lines.
This is a seller-side record, not a transportation promise. Describe the access facts you know, including dock, forklift, escort or scheduling restrictions, and leave undecided handling terms for the lot-specific discussion.
- Storage site for each line group
- Release authority or pending status
- Access limits at that site
- Available loading resources, if any
Build a photo map before using a grand total
The city's public-transit page identifies Metro-North Railroad, Amtrak and intercity bus services as users of the Stamford Transportation Center. That transportation context is relevant only when a seller describes actual access constraints near a site; it does not imply freight service, pickup or a particular cable lot.
Capture a tag, jacket legend, reel overview and any visible damage for each differing product or condition. Then place the matching filenames in the line record. The common error is reporting a single footage total for reels with different sites and conditions; the workable correction is one row per reel or continuous piece, with totals shown only as a derived summary.
- Tag, jacket, overview and condition photo references
- One row per reel or continuous piece
- Site-specific photo mapping for dispersed lots
- Grand total retained only as a derived summary
