How to read a liquidation manifest before you buy
Sort the manifest by extended retail, then verify the few lines that carry most of the value: exact UPCs, plausible quantities, real retail. Flag duplicates, blank retail and vague descriptions, read the condition column, and value anything you cannot identify at zero until the seller explains it.
Reviewed by Tyler Kober · Updated
Key takeaways
- Sort by extended retail first. A handful of lines usually carries most of the stated value, and those are the lines to verify.
- A UPC with 11 digits has usually lost a leading zero in a spreadsheet. Fix it before you look it up.
- Quantities must make physical sense against the pallet count, carton count and weight.
- Duplicate lines, blank retail and "assorted" descriptions with big values are the most common ways a manifest overstates a load.
- Value a line you cannot identify at zero until the seller gives you a UPC or photo.
How do you read a liquidation manifest?
Sort it by extended retail, highest first. The top lines usually hold most of the value, so verify those: exact UPC, sensible quantity, real current retail. Then scan the rest for duplicates, blank retail and vague descriptions. Read the condition column last. Anything you cannot identify gets no value in your offer until the seller explains it.
A manifest is the seller's claim about a load. Reading it well means testing that claim before you pay. The manifests and condition guide explains where manifests come from and why their accuracy varies; this page is the practical walkthrough.
The columns, one at a time
Most manifests use some version of these columns. The names change from seller to seller, so learn what each one does rather than what it is called.
| Column | Read it for | A quick test |
|---|---|---|
| Item # / SKU | Cross-reference with the seller | Ignore it for valuation; it is internal |
| UPC / EAN | Exact product identity | 12 digits (UPC) or 13 (EAN); 11 digits means a dropped zero |
| Description | What the item is | Does it match what the UPC looks up as? |
| Brand | Demand and channel limits | Private label rarely has an outside comp |
| Qty | Units on the line | Units, not cases? Fits the pallet? |
| Unit retail | Claimed price per unit | Current shelf price, old MSRP or a system default? |
| Ext retail | Qty × unit retail | Recalculate a few lines yourself |
| Condition | New, shelf pull, return, salvage | Per line, or one word for the whole load? |
| Pallet ID | Where the line sits | Lets you count one pallet at a time |
| Category | Rough mix | Useful for a quick split, not for value |
If a load includes dated goods, look for lot and expiry columns too. Their absence on a food or HBA load is itself a finding; see expiry dates for food, HBA and OTC.
A step-by-step process
Work through these steps in order. Each one narrows down where the risk sits.
- Check the totals. Add the extended retail column yourself and compare it to the stated total. Recalculate qty × unit retail on five lines at random. A file that does not add up was edited by hand somewhere.
- Sort by extended retail, highest first. Note how many lines it takes to reach most of the total. That group is your verification list.
- Check UPCs on the verification list. Fix dropped leading zeros. Look up each code and confirm it matches the description, including size and color. Use only exact matches as comps; the method is in how to verify retail value with a UPC.
- Test quantities for physical sense. Compare total units against the pallet count, the carton count and the weight. Bulky items in large quantities on few pallets do not fit.
- Hunt for duplicates. Sort by UPC. The same UPC and quantity appearing twice may be two pallets, or it may be a double count. Ask.
- Flag blanks and vague lines. Blank UPC, blank retail, "assorted", "misc.", "mixed GM": list them with their extended retail.
- Look at the category mix. Does the mix fit how you sell? A load that is mostly one category you cannot move is not a bargain at any price.
- Read the condition column. Per line or one label for everything? Get the seller's written definitions; condition terms explained covers what each term usually means.
- Write your questions. Everything you flagged becomes a question to the seller before you offer.
Worked example: a small hypothetical manifest
Illustration only. These items, quantities and retail values are made up to show the method, in no particular currency. They are not market prices or typical loads.
Say a seller sends this two-pallet returns manifest:
| Line | Description | UPC | Qty | Unit retail | Ext retail | Condition | Pallet |
|---|---|---|---|---|---|---|---|
| 1 | Wireless earbuds, black | 12 digits | 40 | 50.00 | 2,000.00 | Customer return, uninspected | P1 |
| 2 | Robot vacuum, gray | 12 digits | 6 | 300.00 | 1,800.00 | Customer return, uninspected | P1 |
| 3 | Phone case, assorted | blank | 120 | 15.00 | 1,800.00 | Shelf pull | P2 |
| 4 | Assorted general merchandise | blank | 1 | 1,500.00 | 1,500.00 | Mixed | P2 |
| 5 | Stand mixer, 5 qt, red | 12 digits | 4 | 250.00 | 1,000.00 | Customer return, uninspected | P1 |
| 6 | Kids' water bottle, 12 oz | 11 digits | 60 | 12.00 | 720.00 | Overstock | P2 |
| 7 | Bath towel set, white | 12 digits | 20 | 30.00 | 600.00 | Shelf pull | P2 |
| 8 | Wireless earbuds, black | same as line 1 | 40 | 50.00 | 2,000.00 | Customer return, uninspected | P2 |
| Total | 291 | 11,420.00 |
Step 1, totals. The extended retail column adds to 11,420. Each line's qty × unit retail checks out. Fine so far.
Step 2, sort. Sorted by extended retail: lines 1 and 8 (2,000 each), then lines 2 and 3 (1,800 each), then line 4 (1,500). Those five lines hold 9,100 of the 11,420, about 80% of the stated value. That is the verification list.
Step 3, UPCs. Lines 3 and 4 have no UPC. Line 6 has 11 digits, so a leading zero was probably dropped; add it and look it up. Lines 1, 2, 5 and 7 can be checked.
Step 4, plausibility. Six robot vacuums and four stand mixers are bulky. Together with 40 boxed earbuds they could fit on one pallet, but only just. Ask for P1's weight and photos to confirm.
Step 5, duplicates. Line 8 repeats line 1: same description, same UPC, same quantity, but on a different pallet. That may be genuine, or it may be a double count. If it is a double count, the real total drops to 9,420.
Step 6, blanks. Line 4, "assorted general merchandise" at 1,500, cannot be valued. Line 3, assorted phone cases with no UPC, cannot be comped. Set both aside.
What is left that you can actually verify? Lines 1, 2, 5, 6 and 7 come to 6,120 of claimed retail. If line 8 is confirmed as a real second pallet of earbuds, that rises to 8,120. So this 11,420 manifest is really somewhere between 6,120 and 8,120 of checkable retail, before you account for the condition of uninspected returns. Your offer should rest on the verifiable figure, plus whatever value you place on the unknowns after the seller answers.
What to ask the seller
Turn every flag into a short, specific question. Sellers answer specific questions faster than general ones.
- Where did this manifest come from: a retailer's returns system, a warehouse export, or your own count?
- Is line 8 a second pallet, or a repeat of line 1?
- Can you send UPCs or photos for lines 3 and 4?
- Is the condition per line, and what does "uninspected" mean here: never opened by you, or not tested?
- What does each pallet weigh, and can I see all four sides of each with the pallet ID visible?
- Where does the unit retail come from: current price, past selling price or MSRP?
- What happens if the count or items differ on arrival, and by when do I need to report it?
How variance is usually measured and settled is covered in manifest accuracy and variance.
Mistakes to avoid
- Valuing the total, not the lines. The headline retail number is the least reliable figure on the sheet.
- Trusting description over UPC. Descriptions are typed by people; a UPC either matches or it does not.
- Comping near-matches. A similar model, the next size, the bundle version: none of these are the item on the manifest.
- Ignoring units of measure. "Qty 12" may be 12 cases of 24. Ask when the number looks too small or too large for the pallet.
- Skipping the boring lines entirely. Spot-check a few low-value lines too. A manifest that is careless at the bottom may be careless at the top.
- Reading condition as a guarantee. "New" from a returns system can mean the box was sealed when it was scanned.
Buying on Skyline Dealz Marketplace
Skyline Dealz Marketplace offers closeout and liquidation loads to approved member buyers. Where a manifest exists it comes with the listing, photos are embedded in the spreadsheet cells, and retail comps are shown only on exact UPC matches; everything else says "no verified comp". Category pages such as wholesale closeout electronics show what kinds of loads come through. To get alerts on loads that match what you buy, request access.
Frequently asked questions
What is extended retail on a manifest?
Extended retail is the quantity on a line multiplied by the unit retail, so 40 units at a unit retail of 50 is 2,000 of extended retail. The manifest total is the sum of these. It is a claimed retail value, not what you will sell the goods for, and it is only as accurate as the unit retail figure behind it.
Why do some UPCs on a manifest have only 11 digits?
A UPC is 12 digits. When a spreadsheet stores it as a number, a leading zero is dropped, leaving 11 digits. Add the zero back on the left and the code should look up correctly. If a code has 10 digits or fewer, or 14 or more, it is probably an internal item number or a case code, not a unit UPC.
How many manifest lines should I check before buying?
Check every line in the group that makes up most of the extended retail, then spot-check a few from the middle and bottom of the list. On a long manifest that may be a few dozen lines. The aim is to confirm the value you are paying for, not to research every phone case.
What should I do with a manifest line that just says "assorted"?
Ask the seller for UPCs, a photo, or a breakdown. Until you have one, give the line no value in your offer. Assorted lines with large retail figures are a common way for a manifest to look bigger than the load really is, even when nobody intends to mislead.
Related
Sources
Send a list or manifest and we'll come back with an offer. Approved buyers see live loads, prices and manifests. Or call +1 215 278 4122.