Give each reel or matching group a stable ID
Start with one row per reel or one row for genuinely identical reels at the same site. Reuse the line ID in the inventory, image files, and supporting records. Add manufacturer, part number, complete marking, conductor material, size, and remaining footage so the line can be understood without a grand-total assumption.
The City of Roseville business portal links commercial users to economic development, permits and licenses, procurement services, utilities customer care and utility rebates. It is a local business-context fact, not a statement that a City program owns, needs, or offers any cable. A seller’s actual inventory and release records remain the evidence for the lot.
- Reuse the same ID in every file name and inventory row.
- Create a separate row when a reel, site, or specification differs.
Keep quantity and specification at reel level
Record the reel count and continuous footage per reel rather than only aggregate footage. State whether each length is measured, documented, or estimated. A row should retain complete marking and condition differences even when several products appear to be the same general cable family.
The common failure is a single total that makes two sites and two lengths look like one uniform lot. Splitting that total into line items keeps short pieces, partial reels, and differing specifications from being disguised as one continuous quantity.
- Use per-reel length and quantity basis, not only a lot total.
- Keep unmatched or incomplete markings on separate lines.
Map site facts without blending locations
Group rows by actual storage location and add condition observations, seller-reported access restrictions, and available loading information for that site. If the same part number appears in two places, maintain separate rows because access, footage, and release authority may differ.
A multi-site inquiry can be one submission, but each site should remain visible. This makes it possible to understand which photo belongs to which reel and which business contact controls a particular group.
- State the storage site on every line.
- Record site-specific access and loading details without assuming a transport arrangement.
Document release scope and unknowns
Identify whether the seller is offering a defined group together or as stated subgroups, then list the release authority for each site or mark it pending. If an inventory field is incomplete, use a clear status such as estimated footage, partial marking, or release pending with a short note about the basis.
Do not use blanks to hide uncertainty. A photo reference for an unreadable label or a note that a site contact must confirm authority gives the buyer a specific follow-up point while keeping the rest of the inventory accurate.
- Show offered grouping and release authority per site.
- Tie every unknown to its line ID and its supporting photo or record.
Worked multi-site inventory example
Illustrative inventory example—not a purchased lot: BL-RV-01 is a documented 500-foot reel at Site A; BL-RV-02 is a 90-foot estimated reel at Site B; both use matching file names and Site B release authority is pending. The example is fictional and does not claim that any similar inventory was bought in Roseville.
This page coordinates traceability across multiple sites. It differs from surplus reconciliation, which establishes whether a current balance is released at all, and from distribution cable handoff, which concentrates on a reel’s voltage and neutral or shield construction.
- Illustrative fields: line ID, marking, footage basis, photo reference, storage site, condition, access, release status.
- Avoid adding two reels together as though they form one continuous length.
