Make one master line for every reel or continuous piece
Create a stable line or reel ID and reuse it in the inventory, photo filename, and any record attached to the item. Add manufacturer, part number, complete designation, conductor metal, size, marked voltage, construction, reel count, and continuous length. A grand total may be useful as a later summary, but it cannot replace the traceable line that shows what makes up the total.
This page is about a package with several physical items or locations. It differs from the project-surplus balance workflow because its primary decision is whether every item can remain traceable across sites and access conditions, even where the material specifications are not identical.
- Give each reel or continuous piece one stable ID.
- Use that ID in photo filenames, records, and the storage-site group.
- Keep complete designation, metal, size, voltage, and construction on the line.
Keep sites and release paths separate
Group the master lines by actual storage site, but do not collapse all locations into one warehouse description. For each group, record condition, owner, release authority, release status, and any known access restriction. Identical products at two locations still need separate release and site fields because the seller-side contact and staging conditions may differ.
The likely mistake is a single warehouse photograph and one total footage figure for material spread across different reels, specifications, or locations. The resolution is one line per physical item plus a site group that names what is known and what remains pending.
- Record storage site, owner, release authority, and release status on the applicable item or site group.
- Separate a pending authorization from a confirmed release path.
- Attach site-specific photos rather than treating one overview as proof for every reel.
State quantity and handling facts with their basis
For each reel, list continuous length and state whether it is measured, documented, or estimated. Add dimensions, gross, net, or unknown weight basis, available loading equipment, and access restrictions for the site. A weight estimate or a building-wide equipment list should be labeled accordingly; it should not be treated as a confirmed detail for every item.
These facts help define a realistic scope for a multi-reel discussion. They do not book a movement or settle who will handle it. When equipment or weight is unknown, say so and note whether the seller can obtain the information from a tag, scale, or site record.
- Preserve continuous length and quantity basis per reel.
- Label weight gross, net, or unknown and identify the source of that basis.
- List dock, forklift, crane, or access facts only where the seller knows them.
Use an exception list instead of hiding incomplete inventory
A useful large-lot package identifies exceptions: a reel with no readable part number, an estimated footage figure, a site without confirmed equipment, or a release contact still pending. Keep those records in a distinct exception list linked to the same master ID. This lets a reviewer see which lines are documented and which require a follow-up without confusing the two.
Do not replace a missing field with a confident-looking aggregate. If two reels have the same product but different storage facts, retain two rows. That discipline is the practical resolution for multi-site inventory and gives the seller a specific checklist for closing the gaps.
- Mark missing marking, quantity, access, or release fields as unknown or pending.
- Keep one exception note per master reel ID.
- Do not merge site groups merely to make the total shorter.
Use Erie port context and a fictional multi-site record
The Erie Western PA Port Authority describes Erie as Pennsylvania’s only commercial lake port, connected to the St. Lawrence Seaway, rail, I-79 and I-90. That context supports asking a multi-site seller for exact storage, access, and loading facts; it does not show that a particular lot is present, that a shipment is arranged, or that the buyer has accepted it.
Illustrative fictional inventory example—not a purchased lot: BL-ERIE-01 at Site A — one matching reel, 500 ft documented, dock noted; BL-ERIE-02 at Site B — same product, 90 ft estimated, loading equipment unknown; owner authorization pending. The value of the record is the separate site and evidence basis, not the combined footage.
- Keep Site A and Site B as separate groups even when the product matches.
- Link the reel IDs to their own photo and release notes.
- Treat the fictional owner authorization as pending, not an actual release.
