Give every reel or piece a stable reference
A bulk inventory begins with a line or reel ID that appears exactly the same in the spreadsheet, photo filenames, and any attached product record. Record manufacturer, part number, full designation, conductor metal, size, count, marked rating, and continuous length for that actual item. A grand total may be useful as a summary, but it cannot replace per-reel detail.
If several reels are genuinely identical, retain their individual count and length within the group. Do not treat separate short pieces as one continuous run, and do not force unreadable or mixed items into a specification group simply to reduce the number of lines.
- One stable line ID across files.
- Specification and per-reel length rather than aggregate footage alone.
- Unknown or mixed items kept on their own documented lines.
Group the list by real storage site
Create a site field before sending the inventory. If material is at more than one warehouse, yard, or project location, keep each line with its actual place and do not assume a shared access or release condition. Then add the site-level access limits, available loading resources, and the seller contact who can authorize release for the lines stored there.
RivCoED describes Riverside County’s Northwest Region as a hub for logistics, manufacturing and distribution, with access via I-15, I-215, SR-60 and SR-91. This is limited context for why location and handoff fields matter in a multi-site record, not an assertion that a particular facility has inventory or that a highway connection establishes a transport arrangement.
- Site name or location field for every line.
- Access limits and loading resources recorded per site.
- Authorized release contact tied to the lines at that site.
Make photos prove only the line they depict
Use the line ID in each tag close-up, jacket-legend image, and overall reel or piece view. A single photo of one well-labeled reel does not establish the specification or condition of every line in a large lot. Keep visible condition, label legibility, and quantity differences attached to the photographs for the relevant item.
When a photo is representative only of a genuinely matching group, say so in the inventory and identify the exact members of that group. If a reel has a different label, length, storage exposure, or visible issue, create another line and another photo reference instead of treating it as covered.
- Tag, jacket, and overview photo references use the line ID.
- Representative photos limited to explicitly matching reels.
- Different label, length, or condition means a different line.
Separate the inventory boundary from the movement discussion
The seller needs to identify which lines are included, which are excluded, and which still need approval. Add a release-status field and a requested timetable if one exists. This makes the lot scope clear without assuming that all sites will be available together or that a storage location answers every access question.
Keep handling facts practical: known reel dimensions, documented or estimated weights, available loading equipment, gate or scheduling restrictions, and the correct release contact. If a fact is unknown, state it. Accurate site information is more useful than an unsupported promise about how material will move.
- Included, excluded, and pending-release lines visibly separated.
- Known dimensions and weight basis attached to large reels.
- Unknown loading or access field left visible for follow-up.
Worked multi-site record
The fictional BL-RIV-01 and BL-RIV-02 records illustrate the essential separation. They describe the same product at two sites, but retain different lengths, quantity bases, photos, and release contacts. The inventory therefore does not disguise a 500-foot documented reel and a 90-foot estimate as one uniform quantity.
The common error is combining two locations under one total and attaching one photograph to the whole list. The correction is a row for every reel or continuous piece, a site group for each location, and evidence that can be traced to the exact line before a buying discussion proceeds.
- BL-RIV-01: 500 ft documented at site A.
- BL-RIV-02: 90 ft estimated at site B.
- Separate release contacts and matching photo filenames.
