Start with the count you can stand behind
A buyer sees a worksheet with 480 units, a warehouse note that says 40 cases and a separate list of open cartons. Those records may describe the same stock. Before sending the offer, reconcile them into a dated file that shows exactly what the buyer can purchase.
Save the original warehouse export with its date, time and warehouse locations. Give each source line a stable reference. For the offer, group only stock that shares the same product, edition, condition, location and selling terms. If two warehouses have different pickup windows, keep the lines separate even when the item code matches.
Include the product ID and ID type, your own SKU, format or variant, condition, pack configuration, counted quantity, held quantity and offered quantity. State whether each figure counts retail units, cases or sets. If you already have a file layout, use the bulk media manifest guide to check what the buyer still needs.
Use the same unit for counts and prices
Keep the retail identifier and the case identifier in separate fields where both are supplied. GS1 distinguishes packaging levels and specifies when a change in pack quantity requires a different GTIN for the case. Preserve source identifiers as text, including their leading zeros, and follow the buyer’s agreed format when exporting a normalized identifier. GS1 GTIN Management Standard, section 2.8 · GS1 guidance on GTIN formatting
Convert only verified case packs to retail units. For open cartons, count the contents directly and record whether those units can be sold separately. Write the price basis beside the price, such as USD per sealed case. When two conditions or price bases apply, quote separate lines or explain that the offer is for the whole lot.
Worked example: reconcile a 480-unit headline
Suppose a warehouse export lists 40 carton records for one DVD edition and assumes 12 retail units per carton. A physical count shows 36 complete cases, three open cartons containing 21 loose units in total, and one carton awaiting inspection. Four of the 36 complete cases are already reserved for a different order. These figures are fictional.
| Stock group | Verified count | Offer treatment |
|---|---|---|
| Unreserved complete cases | 32 cases × 12 = 384 units | Offer as 32 cases of 12. |
| Reserved complete cases | 4 cases × 12 = 48 units | Exclude from the offer. |
| Open cartons | 21 loose units across 3 cartons | Quote on a separate line if their condition is verified and loose units are eligible for sale. |
| Awaiting inspection | 1 carton, unit count unknown | Hold until counted and checked. |
The confirmed case offer is 384 units. If the loose units pass inspection and may be sold, the buyer can consider another 21 units on a separate line, bringing the combined offer to 405. The warehouse has verified 453 units including reserved stock. The remaining 27-unit difference from the export is a reconciliation gap. It gives the warehouse a reason to check the export and uninspected carton; it provides no count for that carton.
If the asking price is $72 per sealed case, the 32-case line totals $2,304 before freight and any applicable charges. Quote loose units independently. Before sharing, check that the carton records reconcile as 32 offered, four reserved, three open and one on hold.
Keep each revision traceable
Attach a short summary that names the file version, availability timestamp and count owner. State what changed since the previous version, such as a reservation release, an updated count or an edition correction. If a buyer has an earlier file, send a replacement with the affected lines clearly identified.
Define how long your quoted quantities are valid and how you will confirm availability before accepting an order. Include pickup location, earliest shipping or pickup date, whether partial offers are possible, and who arranges freight. Use a separate tab for held or unresolved lines when the buyer needs visibility into them.
Use AI to surface exceptions before sending
Give an approved AI tool a limited sample of row IDs and relevant notes. Ask it to group unresolved items by issue, such as missing pack size, conflicting edition or unclear condition, and include the original row ID for each question. Keep identifiers, quantities, formulas and prices in the source workbook and apply repeatable checks there.
Have the warehouse or purchasing owner compare each proposed correction with the original evidence before publishing a revised file. NIST recommends checking generated sources and citations. In this workflow, that means opening the cited row or count sheet and confirming it supports the proposed correction. NIST Generative AI Profile, MS-2.5-003