Inventory Manifest Template for Liquidation

Inventory Manifest Template for Liquidation: Free Download + Step-by-Step Guide

The Single Document That Determines How Fast — and How Much — You Get Paid

If you’ve ever contacted a liquidation buyer and heard nothing back, or received a vague, lowball offer without explanation, there’s a good chance the problem wasn’t your inventory. It was your documentation.

A properly prepared inventory manifest is the foundation of every successful bulk liquidation transaction. It is the document that tells a buyer what you have, how much of it you have, what condition it’s in, and whether it’s worth making an offer on — all without them needing to visit your warehouse, ask a dozen follow-up questions, or guess at information that should be clearly stated.

Buyers typically ask for a manifest in Excel format, and with all the required information, their inventory specialists can provide a solution and quote within 24 hours of submission.

That 24-hour turnaround only happens when the manifest is complete. An incomplete or vague manifest adds days — sometimes weeks — of back-and-forth. In some cases, buyers simply move on to the next seller, whose inventory is better documented.

This guide walks you through exactly what a liquidation manifest needs to contain, how to fill each field correctly, and what mistakes to avoid. At the bottom, you’ll find a link to download our free Excel manifest template — the same format accepted by LiquidateProducts.com and built to match what serious buyers actually need.

What Is an Inventory Manifest?

In the context of bulk liquidation, a manifest is a structured document — almost always an Excel spreadsheet — that lists every SKU or product line you want to sell, with key information about each one.

A manifest essentially brings the store to you. Since buyers can’t physically touch or view your inventory before making an offer, reviewing the manifest helps them understand exactly what they’re getting so they can calculate potential offers.

Think of it this way: a liquidation buyer evaluating your inventory is making a purchasing decision that may involve tens or hundreds of thousands of dollars. They need the same information any professional buyer needs — product identity, quantity, condition, and pricing reference points. The manifest provides all of that in one organized document.

Without it, a buyer has three options: ask you for all the information piecemeal (slow, frustrating for both sides), guess (which means they’ll price conservatively to account for risk), or pass. None of those outcomes are good for you.

What Every Liquidation Manifest Must Include

Not every field in a manifest carries equal weight. Some are absolute requirements — a buyer literally cannot make an offer without them. Others are strongly recommended and will meaningfully improve the offer you receive. The rest are optional but useful for logistics coordination.

Here’s the breakdown:

Required fields — a buyer cannot quote without these:

Product Name: The full, descriptive name of the product. Include model name, variant, size, and colour where relevant. “Men’s Running Shoe” is not useful. “Men’s Running Shoe — Nike Air Zoom Pegasus 41, Size 10, Black/White” is. The more specific your product name, the faster a buyer can research pricing and make a confident offer.

Brand: The manufacturer or brand name. This matters enormously to buyers because brand recognition directly affects resale value and channel options. A generic off-brand product and a recognisable national brand in the same product category can have dramatically different secondary market values.

SKU or Item Number: Your internal stock-keeping unit number. The fastest way to get a response is knowing and understanding your closeout inventory — at minimum this means Item Condition, Item SKU Number, UPC Code, Product Description, and Quantity Available. If you truly don’t have SKUs assigned, write “N/A” — but do your best to provide them.

Category: What type of product is it? Use consistent, recognisable categories: Apparel & Footwear, Electronics & Tech, Home Goods & Housewares, Beauty & Personal Care, Toys & Games, Food & Grocery, Industrial & Hardware, and so on. Category is how buyers quickly assess whether your inventory fits their purchasing channels.

Condition: This is the most important single field in the entire manifest. See the full condition guide below. Never leave it blank, never be vague, and never overstate condition.

Quantity Available: Total units (or sets, cases, or pallets) available to sell. Round numbers are fine, but be accurate — buyers will verify quantities on pickup and will renegotiate if they find significant discrepancies.

Strongly recommended fields — these meaningfully improve the offer:

UPC or Barcode: The 12- or 13-digit barcode number. Buyers use UPCs to instantly look up current retail pricing, market demand, and secondary market comparables. Data that is helpful for buyers includes the SKU/UPC list, MSRP/MAP guidance, age/seasonality, and any channel restrictions. A UPC speeds up offer turnaround more than any other optional field.

Retail or MSRP: The original selling price per unit. This is the single most useful pricing reference point for a buyer calculating recovery percentages. If you fill in no other price field, fill in this one.

Optional but useful fields:

Original Cost: What you paid per unit. Gives buyers context on margin and can occasionally improve offer framing.

Your Asking Price: Optional — leave blank to invite the buyer’s first offer, or fill in if you have a target number.

Unit of Measure: Units, sets, cases, pallets. Clarifies what “quantity” means for your specific product.

Location or Pallet Number: Where the inventory physically is. Warehouse section, pallet labels, lot identifiers. Logistics coordination is significantly faster when pickup locations are clearly mapped in the manifest.

Notes or Restrictions: Expiry dates, brand channel restrictions (e.g. “no Amazon resale”), packaging details, size distribution, known defects, missing accessories. The Notes column is where you prevent misunderstandings. Use it generously.

The Condition Guide: The Most Critical Field in Your Manifest

Condition is where most sellers make mistakes — and those mistakes either cost them money (by underpricing well-conditioned goods) or cause deals to fall apart (when buyers discover overstated condition on inspection).

Here is the standard condition taxonomy used across the liquidation industry:

New / Sealed: Unopened, unused, original factory packaging. No visible wear to product or packaging. This is the ideal scenario for sellers — buyers can price confidently and offer the best recovery rates. Typical recovery on new/sealed merchandise ranges from 40 to 70 percent of your original wholesale cost depending on category and brand.

Like New / Open Box: Opened but unused. All parts and accessories present. Packaging may show minor wear. Buyers treat this as only slightly below new/sealed condition. Recovery typically 30 to 55 percent of wholesale.

Shelf Pull: Merchandise removed from retail shelves — never sold to an end consumer. May have sticker residue, price tags, display wear, or minor cosmetic marks. A very common category for overstock buyers. Recovery typically 20 to 45 percent of wholesale.

Customer Return: Returned by an end consumer. Condition varies significantly within this category — some returns are completely unused, others show significant wear. If you have customer returns, you should ideally inspect a representative sample and note what you find. “Customer return — approximately 70% appear unused, 30% show light use, all units present and functional” is a useful Notes field entry. Recovery typically 10 to 35 percent of wholesale.

Damaged or Salvage: Product or packaging has visible damage. Must be disclosed fully. Buyers who specialise in salvage merchandise will still quote this, but only if the damage is described honestly. Recovery typically 5 to 20 percent of wholesale.

Expired or Near-Expiry: Food, beauty, or health products past or approaching their expiration date. Must include exact dates in the Notes field. Buyers for this category are specialised — some charitable redistribution, some clearance processors. Recovery varies.

Mixed: A lot containing multiple condition levels. Use only when you genuinely cannot separate them. Note in the Notes field what the mix looks like — e.g. “approximately 60% new/sealed, 40% shelf pull.” Buyers price mixed lots at the lowest condition in the lot, so separating conditions whenever possible always yields better total recovery.

The most important rule: do not overstate condition. Buyers inspect inventory on receipt. Discrepancies between manifest condition and actual condition lead to renegotiation, partial refusal, or permanent damage to the business relationship. Buyers have seen every inventory condition that exists — they won’t be surprised, but they will be annoyed.

Step-by-Step: How to Build Your Manifest

Step 1: Export from your inventory system

Start with what you have. Most e-commerce platforms, WMS systems, and ERPs can export inventory data to CSV or Excel. Platforms like Shopify, NetSuite, ShipBob, and 3PL software all support inventory exports. Pull your existing data first — product names, SKUs, quantities — and use it as the starting point rather than building from scratch.

Step 2: Add or verify the required fields

Review your export against the required fields list above. Product names may need to be more descriptive than your internal system requires. Condition won’t be in your system at all — you’ll need to assess and add it. MSRP may need to be looked up if it’s not stored in your system.

Step 3: Assess and record condition accurately

Walk your warehouse with your manifest open. Physically verify the condition of a representative sample of each SKU. Condition stated on the manifest must match what a buyer will find when they inspect. If you have mixed conditions within a single SKU, note it in the description or split the line into two rows (one for each condition tier).

Step 4: Separate returns from new overstock

If you have customer returns and new/sealed overstock, list them as separate line items — even if they’re the same product. A buyer will offer different rates for each condition, and a combined lot gets priced at the lower condition. Separating them almost always produces better total recovery.

Step 5: Fill in the MSRP column

Even if you don’t know your original cost, even if you don’t have a UPC — fill in the MSRP. It is the single most useful pricing anchor for the buyer. If products in your lot have different retail prices, use the correct MSRP for each SKU.

Step 6: Add notes for anything unusual

Expiry dates. Brand restrictions on resale channels (some brands contractually prohibit liquidation through certain channels — disclose this). Missing accessories or components. Size distribution for apparel. Known cosmetic damage. Anything that a buyer would need to know before making an offer goes in Notes.

Step 7: Assign pallet or location numbers

If your inventory spans multiple warehouse locations, pallets, or sections, note this in the Location / Pallet # column. Buyers who can see at a glance that “SKU X is on Pallet A-1 through A-3, SKU Y is on Pallets B-1 and B-2” can coordinate pickup logistics far more efficiently.

Step 8: Review for completeness before submitting

Before sending your manifest, do a final pass. Is every required field filled for every row? Are quantities accurate? Are conditions honestly stated? Are expiry dates included where relevant? A five-minute review can prevent days of back-and-forth.

Common Manifest Mistakes That Delay or Kill Deals

Vague product descriptions. “Misc. clothing” or “electronics lot” are not useful descriptions. Buyers cannot research market value for undefined products. Be specific — brand, model, size, colour, variant.

Condition overstated. The most common and most costly mistake. Describe what you actually have, not what you wish you had.

Quantities inflated. Buyers verify on pickup. Significant quantity discrepancies — even honest counting errors — create friction. Count carefully.

Returns and new overstock mixed in one line. As discussed above, this prices your better-condition merchandise at your lower-condition merchandise’s rate. Always separate them.

Missing MSRP. Buyers can look this up themselves, but it slows them down and may result in a more conservative offer based on lower price comparisons they find.

No notes on expiry dates. For any food, beauty, health, or wellness product, the expiry date is not optional information. A buyer will ask. Include it from the start.

Restrictions left undisclosed. If your supplier or brand has resale restrictions — geographic limitations, channel prohibitions, brand approval requirements — disclose them. A buyer who discovers undisclosed restrictions after making an offer will walk away from future deals.

How to Submit Your Manifest to Get the Fastest Quote

Once your manifest is complete, submission is straightforward.

LiquidateProducts accepts manifest submissions directly at liquidateproducts.com/submit-your-inventory/. Upload your completed Excel file, include your contact information and warehouse location, and our team reviews the manifest and responds within 24 hours with a quote or clarifying questions if needed.

A few final tips for submission:

Send early in the week. Buyers are most active Monday through Wednesday. Manifests submitted Thursday or Friday are often actioned the following Monday. If speed matters, submit at the start of the week.

Attach photos where relevant. For new, sealed merchandise a manifest alone is sufficient. For returns, open-box, or damaged goods, a few clear photos meaningfully improve the offer you receive and reduce the need for follow-up questions.

Include your warehouse location and any logistics constraints. If there are specific pickup windows, access restrictions, dock requirements, or other logistics factors, note them in your submission email rather than waiting for the buyer to ask. It saves time on both sides.

If you have multiple distinct inventory groups, consider separate manifests. A pallet of sealed electronics and a warehouse section of customer-return apparel are different categories with different buyers and different pricing logic. Submitting them as separate manifests can speed up evaluation and produce cleaner offers for each.

Download the Free Excel Manifest Template

The template linked above includes three tabs:

The Inventory Manifest tab is your working spreadsheet — 100 pre-formatted data rows with dropdown validation for Category and Condition fields, auto-totalling for quantity and value columns, and pre-filled sample rows showing how to structure your entries correctly.

The Condition Guide tab is a reference sheet covering all seven condition codes with plain-language descriptions, typical recovery rate ranges, and the best buyer channels for each condition. Keep it open while you fill out your manifest.

The Tips & FAQ tab answers the twelve most common questions sellers ask before their first manifest submission — including what happens after you submit, how long the process takes, and whether you need to clean or organize inventory before a buyer arrives.

The template is free to download and use. Fill it in, save a copy, and submit directly to liquidateproducts.com/submit-your-inventory/.

Click to Download: LiquidateProducts_Manifest_Template

Frequently Asked Questions

Do I need to have a manifest to get a quote from LiquidateProducts? A manifest is the fastest path to a quote and is strongly preferred. If you have a small lot (fewer than 10 SKUs) or are unsure how to start, you can contact us directly and we can help you structure the information. For larger lots, a complete manifest is required.

What format should the manifest be in? Excel (.xlsx) is the preferred format, as it allows buyers to sort, filter, and calculate quickly. CSV is also acceptable. PDFs and images of spreadsheets are not workable — buyers need to manipulate the data.

What if I don’t have SKUs for my products? Provide the most complete product description you can — brand, product name, model, size, colour, and any other identifiers. A UPC is more useful than a SKU if you have it. If you have neither, describe the product as specifically as possible.

How many rows can the template handle? The template is set up for 100 line items. If you have more SKUs, you can add rows below row 112 while maintaining the same column structure. For very large manifests (500+ SKUs), contact us directly and we can discuss batch submission.

What happens after I submit my manifest? Our team reviews your manifest and responds within 24 hours with a quote or any clarifying questions. Once you accept an offer, we coordinate pickup logistics — typically within 3 to 10 business days depending on volume and your location. Payment follows pickup confirmation.

Is my manifest information confidential? Yes. We do not share your inventory details or company information with third parties outside the transaction. If you require an NDA before sharing your manifest, we can accommodate that.

Conclusion

A good inventory manifest takes an hour or two to build properly. A bad one — or no manifest at all — can cost you days of delay, a lower offer, or a deal that doesn’t close at all.

The time you invest in building a complete, accurate manifest is the highest-ROI activity in the entire liquidation process. It signals to buyers that you’re a professional, organised seller. It gives them the information they need to make a fast, confident offer. And it eliminates the back-and-forth that slows everything down.

Download the free Excel template above, follow the step-by-step guide, and submit your completed manifest at liquidateproducts/submit-your-inventory/. Our team will respond within 24 hours.