Selling a large quantity of closeout merchandise involves more than telling a buyer how many pallets you have available. Before making an offer, a buyer needs to understand exactly what is included in the lot, where it is located and what condition the products are in.
An inventory manifest provides this information in one organised document.
A clear and accurate manifest helps a buyer evaluate your merchandise without sending repeated questions or making assumptions. It can reduce delays, prevent misunderstandings and make it easier to compare offers from potential buyers.
Whether you are clearing discontinued products, seasonal overstock, customer returns or slow-moving merchandise, preparing the right inventory manifest is one of the most important steps before approaching a bulk closeout buyer.
This guide explains what an inventory manifest is, what information it should contain and how to prepare one before submitting your closeout inventory for review.
What Is an Inventory Manifest?
An inventory manifest is a detailed list of the products included in a bulk inventory lot. It is normally created as an Excel or CSV spreadsheet so the information can be sorted, filtered and reviewed efficiently.
A basic manifest identifies each product and its available quantity. A stronger manifest also includes information such as:
- Product name
- Brand
- SKU
- UPC, EAN or GTIN
- Product category
- Quantity available
- Unit cost
- Original retail price
- Product condition
- Packaging condition
- Expiration date, when applicable
- Inventory location
- Case-pack details
- Pallet or carton count
- Product restrictions
- Images or image links
The exact information required depends on the products being sold. For example, a manifest for new consumer electronics will look different from one prepared for unmanifested customer returns.
The purpose, however, remains the same: to give the buyer enough reliable information to understand and evaluate the inventory.
Why Buyers Need an Accurate Inventory Manifest
Bulk inventory buyers evaluate many factors before making an offer. They need to consider the type of merchandise, quantity, condition, current demand, resale potential, logistics and possible sales restrictions.
If the manifest is incomplete, the buyer may not be able to determine the value of the lot confidently. That can lead to more questions, a slower review or an offer that accounts for the uncertainty.
A complete manifest can help in several ways.
It makes the inventory easier to evaluate
A buyer can quickly identify the brands, products, quantities and conditions represented in the lot. This makes it easier to decide whether the inventory fits their purchasing criteria.
It reduces unnecessary communication
Without a manifest, the buyer may need to request product codes, quantities, prices, photographs and other details separately. Providing this information from the beginning can shorten the evaluation process.
It establishes realistic expectations
An accurate breakdown helps both sides understand what is being discussed. It reduces the risk of discovering major differences between the submitted information and the physical inventory later.
It supports logistics planning
Carton counts, pallet counts, dimensions, weight and warehouse location can help the buyer estimate collection or shipping requirements.
It demonstrates that the seller is prepared
A well-organised manifest shows that the inventory has been reviewed and that the seller is ready to discuss a serious bulk transaction.
Choose the Right File Format
Microsoft Excel is usually the most practical format for an inventory manifest. A .xlsx file allows buyers to sort products by category, brand, condition or quantity.
CSV files are also widely accepted, particularly when inventory data is exported from warehouse management, ecommerce or accounting software.
Avoid sending the complete manifest as:
- Screenshots
- Photographs of a computer screen
- Scanned handwritten lists
- Long email paragraphs
- Locked files that cannot be filtered
- PDFs with hundreds of unsortable products
A PDF can be useful as a supporting document, but an editable spreadsheet is normally more efficient for a detailed inventory review.
Use one row for each unique product or SKU and one column for each type of information. Do not combine several unrelated products in the same row.
Essential Information to Include
The more accurately you describe the inventory, the easier it becomes for a buyer to evaluate it. Begin with the following core fields.
1. Product name
Enter the complete and recognisable product name. Avoid descriptions such as “assorted items,” “general merchandise” or “electronics” unless the inventory is genuinely unmanifested.
Instead of writing:
Wireless headphones
Use a more precise description:
Brand X Model 500 Bluetooth Over-Ear Headphones, Black
A precise product name helps buyers understand what is included without immediately searching for more information.
2. Brand or manufacturer
Add the brand or manufacturer in a separate column. Brand recognition, resale restrictions and consumer demand can affect the evaluation of a closeout lot.
If the inventory is private-label or unbranded, state that clearly rather than leaving the field blank.
3. SKU
Include your internal stock-keeping unit when available. A SKU helps distinguish products with similar names, colours, sizes or configurations.
If your inventory system uses separate parent and variation SKUs, include both where helpful.
4. UPC, EAN or GTIN
Product identification numbers help buyers verify the exact item and distinguish between similar variations.
According to GS1 US product identification guidance, a Global Trade Item Number identifies products and is commonly encoded in UPC or EAN barcodes.
Make sure product identifiers are stored as text in your spreadsheet. Otherwise, Excel may remove leading zeros or display long numbers incorrectly.
Do not add a code unless you have verified that it belongs to the listed product.
5. Product category
Assign each item to a clear category, such as:
- Consumer electronics
- Health and beauty
- Apparel
- Home and kitchen
- Toys and games
- Sporting goods
- Automotive accessories
- Office supplies
- General merchandise
Categories help buyers filter large manifests and quickly identify the parts of the lot most relevant to them.
6. Quantity available
Enter the actual sellable quantity for every product.
Do not use the original quantity if units have already been sold, damaged, returned to a supplier or allocated to another transaction.
If the amount is still changing, add a date showing when the inventory count was last updated.
For mixed-condition stock, divide the quantity by condition. For example:
- 500 units: new
- 120 units: open-box
- 80 units: customer returns
This is much more useful than listing all 700 units under a single unclear condition.
7. Product condition
Condition can significantly affect how a buyer evaluates inventory. Use consistent terms across the entire manifest.
Common condition labels include:
- Brand new
- New in retail packaging
- New without retail packaging
- Shelf pulls
- Open-box
- Refurbished
- Manifested customer returns
- Unmanifested customer returns
- Used
- Damaged
- Salvage
- As-is
Add a short condition guide in a separate worksheet if your company uses specialised classifications.
Do not describe customer returns as brand-new inventory unless every unit has been inspected and meets that description.
8. Packaging condition
The product may be functional while its packaging is damaged, faded, stickered or incomplete. Buyers need to know the difference between product condition and packaging condition.
Useful descriptions include:
- Factory-sealed retail packaging
- Open retail packaging
- Damaged retail box
- Plain brown box
- Missing packaging
- Relabelled packaging
- Packaging with previous retailer stickers
Provide photographs showing representative packaging conditions.
9. Unit cost and retail price
If appropriate, include:
- Original unit cost
- Manufacturer’s suggested retail price
- Previous selling price
- Current advertised price
These values should be placed in separate columns. Never label a number as MSRP if it is actually your wholesale cost or previous sale price.
A high original retail value does not automatically determine the liquidation value. Buyers also consider current demand, competition, condition, age, restrictions and the cost of moving the products.
Treat pricing information as context rather than a guarantee of what the inventory is worth.
10. Expiration or best-by dates
Expiration information is essential for products such as cosmetics, personal care items, supplements, food, beverages and other date-sensitive goods.
Include:
- Expiration date
- Best-by date
- Manufacturing date, if relevant
- Remaining shelf life
- Quantity associated with each date
If the same SKU has several expiration dates, use separate rows for each batch.
Businesses selling regulated or date-sensitive products should also confirm the rules applying to their product category. The U.S. Food and Drug Administration’s industry resources provide guidance for industries and products regulated by the FDA.
Do not hide short-dated or expired products inside a mixed lot. Disclose them clearly so the buyer can assess whether the products are eligible for purchase or resale.
11. Inventory location
Provide the complete pickup location or, at minimum, the city, state and ZIP code during the initial review.
The location affects:
- Freight costs
- Collection options
- Loading arrangements
- Transportation time
- Regional resale opportunities
- Whether multiple warehouses are involved
If products are stored at more than one location, include a location column for every line item or create a separate worksheet for each warehouse.
12. Case, carton and pallet details
A buyer may need to understand how the inventory is packed before arranging collection.
Where possible, include:
- Units per case
- Number of cases
- Cases per pallet
- Total pallet count
- Pallet dimensions
- Approximate pallet weight
- Whether pallets are stackable
- Whether products are floor-loaded
- Whether mixed SKUs share the same cartons
You may not have every measurement at the beginning, but accurate totals can prevent logistics problems later.
13. Brand and resale restrictions
Tell the buyer if the inventory is subject to any restrictions, including:
- Marketplace restrictions
- Geographic restrictions
- Minimum advertised price policies
- Export limitations
- Serial-number tracking
- Required removal of labels
- Prohibited sales channels
- Confidentiality requirements
- Destruction or debranding requirements
Restrictions can affect where and how inventory may be resold. Disclosing them at the beginning allows the buyer to decide whether they can handle the lot appropriately.
If a restriction is contractual or legally sensitive, consult your legal adviser before completing the transaction.
A Simple Inventory Manifest Template
A practical spreadsheet may include columns like these:
| Product Name | Brand | SKU | UPC/GTIN | Category | Quantity | Condition | Packaging | Unit Cost | MSRP | Expiration Date | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example Bluetooth Speaker | Example Brand | SPK-100-BLK | 000000000000 | Electronics | 500 | New | Factory sealed | $18.00 | $49.99 | N/A | Chicago, IL |
| Example Skin Care Set | Example Brand | SKIN-SET-02 | 000000000001 | Health & Beauty | 240 | New | Minor box damage | $12.00 | $34.99 | 06/2027 | Chicago, IL |
These are only example entries. Replace them with accurate information from your own inventory records.
You can add additional columns for colour, size, model number, lot number, case pack, pallet number or image URL.
Add Supporting Photographs
A spreadsheet explains what you have. Photographs help show the physical condition of the merchandise.
Include clear images of:
- The overall inventory
- Loaded pallets
- Individual cartons
- Product packaging
- Product labels and barcodes
- Expiration or lot codes
- Damaged packaging
- Open-box products
- Mixed or unmanifested returns
- Warehouse access and loading areas, when relevant
Photographs should represent the actual inventory being offered. Avoid relying only on manufacturer images or online product listings.
If a condition issue affects part of the lot, show it clearly and state the approximate quantity affected.
You can organise photographs in labelled folders and include corresponding links in the spreadsheet. Use filenames that match the SKU, pallet number or product name.
Separate Different Inventory Conditions
Combining new products, customer returns and damaged merchandise under one condition makes the lot difficult to evaluate.
Separate the inventory by:
- Product condition
- Packaging condition
- Warehouse
- Expiration date
- Brand
- Product category
- Pallet
- Purchase order or batch
If you have 1,000 units of the same SKU but only 600 are factory-sealed, list the remaining units separately.
This level of transparency protects both parties and reduces the likelihood of disputes after collection.
Common Inventory Manifest Mistakes
Even a large spreadsheet can be unhelpful if the information is inaccurate or poorly organised. Avoid these common problems.
Providing outdated quantities
Verify quantities shortly before sending the file. If products continue to sell through other channels, make that clear and provide an updated manifest before accepting an offer.
Combining unrelated products
Use one row per SKU or unique product variation. Do not put ten products into one cell with a combined quantity.
Leaving the condition unclear
Terms such as “good,” “mixed” or “sellable” can mean different things to different businesses. Use defined condition categories and explain any uncertainty.
Hiding damaged or expired products
Disclose damage, missing parts, short dates and expired inventory. A buyer’s inspection may identify these issues later, which can affect the offer or transaction.
Using inaccurate retail values
Verify MSRP and previous selling prices. Do not use the highest third-party marketplace listing as evidence of standard retail value.
Removing leading zeros from UPCs
Format the UPC or GTIN column as text before importing or entering product codes.
Sending an unstructured PDF
Provide the main inventory data in Excel or CSV format. You can attach a PDF summary, but the detailed data should remain filterable.
Forgetting the warehouse location
A buyer cannot properly consider transportation requirements without knowing where the inventory is stored.
Failing to disclose restrictions
Marketplace, geographic or branding restrictions may affect a buyer’s ability to resell the merchandise. Address them before finalising the transaction.
Review the Manifest Before Submission
Before sending your inventory to a buyer, complete a final quality check.
Confirm that:
- Each row represents one product or variation
- Product names are clear and complete
- Quantities reflect current stock
- UPCs and SKUs are accurate
- Conditions are defined consistently
- Packaging damage is disclosed
- Expiration dates are included where applicable
- Prices are correctly labelled
- Warehouse locations are included
- Photographs show the actual merchandise
- Brand and channel restrictions are explained
- The file opens without errors
- No confidential information has been included accidentally
Remove internal notes, supplier details, employee information and unrelated financial data that the buyer does not need.
Keep an original copy of the manifest and create a dated version for submission. A simple filename such as CompanyName_Closeout_Manifest_September_2026.xlsx makes the document easier to identify.
What Happens After You Submit the Manifest?
Once submitted, the buyer may review the product categories, quantities, condition, pricing context, location and resale requirements.
They may then ask for:
- Additional photographs
- A sample unit
- Updated quantities
- Purchase invoices or proof of ownership
- Clarification about product condition
- Case-pack or pallet information
- Expiration details
- Brand-authorisation documents
- A physical or third-party inspection
These requests do not necessarily indicate a problem. They help confirm that the inventory matches the information provided.
The final offer may depend on the results of the review, product demand, transportation costs and any restrictions affecting resale.
You can learn more about the company and the types of sellers it works with on the About Bulk Closeout Buyer page.
How to Make Your Closeout Lot More Attractive to Buyers
A manifest cannot change the products themselves, but good preparation can make the opportunity easier to understand.
Before contacting a buyer:
- Consolidate scattered inventory where practical.
- Separate new merchandise from returns and damaged goods.
- Count the inventory accurately.
- Identify products with short expiration dates.
- Photograph representative units and pallets.
- Gather product identifiers and packaging details.
- Clarify resale restrictions internally.
- Decide whether the entire lot must be sold together.
- Confirm when the inventory needs to leave the warehouse.
- Assign one person to answer buyer questions.
If the stock is seasonal, do not wait until demand has completely passed before seeking a buyer. Read our guide to seasonal overstock liquidation for guidance on timing the sale.
Frequently Asked Questions
Do I need a manifest to sell closeout inventory?
A manifest is strongly recommended for identified products because it allows buyers to evaluate the lot efficiently. Some buyers may consider unmanifested returns or mixed merchandise, but you should still provide total quantities, categories, condition estimates, pallet counts, photographs and location details.
Can I create an inventory manifest in Excel?
Yes. Excel is one of the most useful formats because the buyer can sort and filter the information. CSV files are also commonly used.
Should I include my original product cost?
Including the original unit cost can provide context, but label it correctly. Your original cost does not guarantee the liquidation value of the merchandise.
Should different product conditions be placed in separate rows?
Yes. New, open-box, returned, damaged and salvage units should be separated whenever possible. This makes the quantities and conditions easier to evaluate.
What if I do not have UPCs for every product?
Provide other available identifiers, such as SKU, model number, manufacturer part number or a detailed product name. Clearly state when products are unbranded or do not have standard product identifiers.
Can I submit photographs instead of a manifest?
Photographs are useful supporting evidence, but they usually do not replace an organised manifest for a large identified lot. Use both whenever possible.
How recent should the inventory count be?
The count should be as current as possible. Add a “last updated” date and send a revised file if quantities change before the transaction is finalised.
Can I sell inventory from multiple warehouses?
Potentially, but each location should be identified clearly. Separate the inventory by warehouse and provide quantities, addresses and loading details for each site.
Ready to Sell Your Closeout Inventory?
A complete inventory manifest gives buyers the information they need to review your products and determine whether the lot fits their purchasing requirements.
Before submitting, verify the quantities, separate products by condition, add clear photographs and disclose any expiration dates or resale restrictions.
When your file is ready, submit your closeout inventory to Bulk Closeout Buyer. Include your company details, inventory spreadsheet and product photographs so the available stock can be reviewed.