Selling one product in bulk is relatively straightforward. The buyer can review a single SKU, confirm the quantity and evaluate the current resale opportunity.
Mixed-SKU inventory is more complicated.
One pallet may contain electronics, home goods, apparel and seasonal products. Some items may be factory-sealed, while others are shelf pulls, open-box products or customer returns. Quantities may range from hundreds of units for one SKU to only a few units for another.
This variety does not make the inventory impossible to sell. However, the buyer needs enough information to understand what is included, how it is organised and what work may be required before resale.
A clear manifest, honest condition reporting and organised pallet-level data can make a mixed lot significantly easier to evaluate.
Whether you have several pallets left from a warehouse clearance or multiple truckloads of mixed merchandise, this guide explains how to prepare and sell bulk inventory without creating unnecessary delays.
What Is Mixed-SKU Inventory?
SKU stands for stock-keeping unit. Businesses use SKUs to distinguish products, variations, sizes, colours, models or packaging formats.
Mixed-SKU inventory contains more than one unique SKU within the same lot, pallet or shipment.
Examples include:
- A pallet containing several models of small appliances
- A truckload of clothing in different sizes and colours
- Customer returns from multiple product categories
- Shelf pulls collected from several retail stores
- Excess inventory from a distributor’s warehouse
- Discontinued products from multiple brands
- Seasonal merchandise combined after a clearance event
- Mixed cases from cancelled orders
- General merchandise from a business closure
- Ecommerce inventory containing many low-quantity SKUs
A mixed lot can contain ten SKUs or several thousand. It may be carefully manifested or offered as unmanifested merchandise.
The more complex the product mix, the more important accurate organisation becomes.
Why Mixed Inventory Can Be More Difficult to Sell
A buyer considering mixed pallets must estimate the potential value and risk of many different products rather than one consistent item.
The buyer may need to determine:
- What products are included
- How many units exist for each SKU
- Whether product identifiers are accurate
- The condition of each item
- Which categories dominate the lot
- Whether products are complete
- Whether packaging is intact
- How much inventory may be damaged
- Which items have resale demand
- Whether any merchandise is expired or restricted
- How much sorting, testing or repackaging is required
- Whether the lot can be distributed through existing channels
If the inventory is poorly documented, the buyer has to account for greater uncertainty.
That does not necessarily mean every unit must be individually inspected. It means sellers should provide the best available information and clearly explain what has and has not been verified.
Decide Whether the Inventory Is Manifested or Unmanifested
Before approaching a buyer, determine whether the lot can be described as manifested.
Manifested mixed inventory
A manifested lot includes an itemised spreadsheet showing the products and quantities available.
A useful manifest may contain:
- Product name
- Brand
- SKU
- UPC, EAN or GTIN
- Manufacturer part number
- Category
- Quantity
- Product condition
- Packaging condition
- Unit cost
- MSRP
- Current selling price
- Expiration date
- Case-pack information
- Pallet number
- Warehouse location
- Image link
The information does not need to be perfect, but it should accurately represent what is being offered.
Unmanifested mixed inventory
An unmanifested lot does not include a complete SKU-level list.
This is common with:
- Customer returns
- Retail shelf pulls
- Salvage loads
- Store-clearance merchandise
- Rapid warehouse removals
- Products consolidated from many sources
Even when a complete manifest is unavailable, provide alternative information such as:
- Total pallet count
- Estimated total units
- Product categories
- Approximate category percentages
- Known brands
- General condition
- Estimated percentage of damaged units
- Representative photographs
- Warehouse location
- Approximate truckload weight
- How the inventory was generated
Do not call inventory manifested if the spreadsheet covers only part of the lot or contains estimates presented as confirmed quantities.
Start with a Physical Inventory Review
Warehouse records do not always match the actual products on the pallets.
Before offering the inventory, conduct a physical review.
Confirm:
- Total pallets
- Total cases
- Estimated units
- Number of SKUs
- Product categories
- Brands
- Conditions
- Packaging quality
- Expiration dates
- Damaged or incomplete items
- Whether pallets have been opened
- Whether inventory has moved since the last count
- Whether units remain allocated to other orders
Use clear pallet numbers such as:
- P001
- P002
- P003
- P004
Attach the same identifier to the physical pallet and the spreadsheet.
If a buyer asks which products are on pallet P014, your team should be able to locate that pallet and provide an answer.
Pallet-level control becomes especially important when the lot is divided, inspected or collected in stages.
Create a Useful Mixed-SKU Inventory Manifest
Excel or CSV is normally the most practical format. Buyers can filter the file by pallet, category, brand, condition and quantity.
Use one row for every unique product variation.
Do not enter several unrelated products in one spreadsheet cell.
A basic manifest could include these columns:
| Pallet | Product Name | Brand | SKU | UPC/GTIN | Category | Quantity | Condition | Packaging |
|---|---|---|---|---|---|---|---|---|
| P001 | Example Wireless Speaker | Example Brand | SPK-100 | 000000000001 | Electronics | 60 | New | Factory sealed |
| P001 | Example Phone Case | Example Brand | CASE-20 | 000000000002 | Accessories | 120 | Shelf pull | Stickered packaging |
| P002 | Example Kitchen Set | Example Brand | KIT-500 | 000000000003 | Home Goods | 40 | Open-box | Mixed packaging |
These entries are examples only. Replace them with verified information from your inventory.
If several conditions exist for the same SKU, create separate rows.
For example:
- SKU ABC-100: 300 units, new
- SKU ABC-100: 80 units, open-box
- SKU ABC-100: 25 units, damaged
This is more useful than entering 405 units under the condition “mixed.”
Include Reliable Product Identifiers
Product identifiers make mixed inventory easier to research.
Add available:
- Internal SKUs
- UPCs
- GTINs
- EANs
- Manufacturer part numbers
- Model numbers
- ASINs, where relevant
- Lot or batch numbers
GS1 US explains that a Global Trade Item Number identifies a specific trade item. GTIN structures can include 8, 12, 13 or 14 digits depending on the product and packaging level.
When entering UPCs or GTINs into Excel, format the column as text. This prevents the spreadsheet from removing leading zeros or changing longer numbers.
Test a sample of the product codes against the actual packaging. An inaccurate identifier can cause a buyer to research the wrong product.
If a product has no standard identifier, include a detailed name, brand, model and photograph.
Avoid descriptions such as:
- Assorted products
- General merchandise
- Electronics
- Mixed home goods
- Various items
These descriptions may be used for a broad category summary, but they are not sufficient for an individual manifest line when more precise information is available.
Separate Products by Condition
Condition has a major effect on how mixed inventory is evaluated.
Common condition groups include:
- New and factory-sealed
- New in retail packaging
- New with damaged packaging
- Shelf pulls
- Open-box
- Refurbished
- Manifested customer returns
- Unmanifested customer returns
- Used
- Incomplete
- Damaged
- Salvage
- Untested
Use the same condition terms throughout the manifest.
If your warehouse uses grades such as A, B and C, add a condition key explaining what each grade means.
For example:
- Grade A: New or like-new with complete packaging
- Grade B: Minor cosmetic or packaging damage
- Grade C: Visible damage, missing parts or testing required
Do not assume the buyer uses the same grading definitions.
Separate customer returns from new merchandise, even when some returned units appear unused. Unless every unit has been inspected and verified, describe the condition accurately.
Organise Pallets by Category Where Possible
A completely random pallet is more difficult to evaluate and distribute than one grouped by category or condition.
When practical, consolidate similar products.
Possible groupings include:
- Electronics
- Home and kitchen
- Apparel
- Health and beauty
- Toys and games
- Sporting goods
- Tools and hardware
- Office supplies
- Seasonal merchandise
- New products
- Customer returns
- Damaged packaging
- Short-dated inventory
Do not spend more on sorting than the likely improvement in recovery. For very large or low-value loads, extensive reorganisation may not make commercial sense.
Instead, perform a sample review and provide reasonable category estimates.
Before investing in sorting, ask potential buyers which information would materially affect their decision.
Create a Pallet Summary Sheet
A detailed SKU manifest is useful, but a pallet-level summary gives the buyer a faster overview.
Include:
- Pallet number
- Main category
- Total cases
- Estimated units
- Number of SKUs
- Primary condition
- Approximate dimensions
- Approximate weight
- Whether the pallet is stackable
- Whether it is wrapped and ready for collection
For example:
| Pallet | Main Category | Cases | Units | SKUs | Condition | Approx. Weight |
|---|---|---|---|---|---|---|
| P001 | Electronics Accessories | 18 | 420 | 12 | New/Shelf Pull | 650 lbs |
| P002 | Home and Kitchen | 22 | 180 | 8 | Open-Box | 780 lbs |
| P003 | Apparel | 30 | 600 | 35 | New | 500 lbs |
A summary makes it easier to understand the size and structure of the load before reviewing thousands of individual lines.
Photograph the Actual Inventory
Stock images do not show the current condition of mixed merchandise.
Provide clear photographs of:
- Every pallet
- Representative cases
- Individual products
- Product labels
- UPCs and model numbers
- Packaging condition
- Damaged products
- Open cartons
- Expiration dates
- Pallet labels
- The overall warehouse quantity
- Loading and dock areas, where useful
Name files using the pallet or SKU identifier.
Examples:
P001_overview.jpgP001_open_case.jpgP002_packaging_damage.jpgSKU-ABC100_label.jpg
Store photographs in organised folders and include links in the manifest or pallet summary.
Photograph representative conditions, not only the best-looking products. If a percentage of the lot has crushed boxes, visible damage or missing packaging, show it and estimate the affected quantity.
Identify Expired, Short-Dated and Regulated Products
Mixed loads can hide products that require special handling.
Review carefully for:
- Expired food
- Short-dated beverages
- Cosmetics with batch codes
- Supplements
- Medical-related products
- Aerosols
- Chemicals
- Batteries
- Flammable goods
- Products subject to recalls
- Items with age restrictions
- Merchandise requiring licences or certifications
Separate expired or potentially unsafe goods from regular inventory.
Do not mix recalled, prohibited or non-compliant products into a general merchandise load.
If the same SKU has several expiration dates, list each batch separately.
The buyer needs enough remaining shelf life to transport, process and resell the inventory. A product that technically has several months remaining may still be commercially short-dated when the full distribution timeline is considered.
Consult appropriate regulatory, legal or safety professionals when products fall into regulated categories.
Decide Whether to Sell by Pallet or Truckload
Mixed inventory can be offered in several ways.
Sell the complete truckload
A full-load sale may:
- Clear the inventory faster
- Reduce administration
- Simplify pickup
- Avoid leftover products
- Transfer the entire mixed lot in one transaction
However, the buyer must account for every weak, damaged or difficult product in the load.
Sell individual pallets
Pallet-level sales may attract category-specific buyers and allow stronger merchandise to be separated.
The disadvantages include:
- More transactions
- More inspections
- More pickups
- Additional warehouse labour
- Greater risk of undesirable pallets remaining
- Longer total clearance time
Divide inventory by category
Category lots are often easier to understand and may fit a buyer’s resale channels better.
Divide by condition
Separating new merchandise from returns, open-box and salvage products can make each lot easier to evaluate.
Choose the structure based on your priorities.
If the main goal is clearing space before a warehouse deadline, a full truckload may be preferable. If time is available and recovery is the priority, category or condition-based lots may make sense.
Set Realistic Pricing Expectations
The original MSRP does not determine the value of a mixed pallet.
A buyer may consider:
- Current resale prices
- Product demand
- Total quantity
- Number of SKUs
- Condition
- Packaging
- Product age
- Expiration dates
- Sorting requirements
- Testing requirements
- Expected damaged percentage
- Marketplace restrictions
- Freight
- Storage
- Expected sell-through time
Mixed loads often require more work than single-SKU inventory. The buyer may need to receive, count, test, sort, photograph, list and distribute many products.
A lot with a high stated retail value may still have limited bulk value if it contains:
- Old models
- Incomplete products
- Short-dated merchandise
- Poorly documented items
- Highly fragmented quantities
- Restricted brands
- Damaged packaging
- Slow-moving categories
Provide MSRP and original cost as context, but do not treat them as guaranteed liquidation values.
The website’s existing guide on valuing excess inventory provides additional information about setting realistic expectations.
Disclose Brand and Resale Restrictions
Mixed loads may include products from several brands with different resale rules.
Document any:
- Marketplace restrictions
- Geographic restrictions
- Export restrictions
- Minimum advertised price policies
- Approved-reseller requirements
- Debranding requirements
- Serial-number controls
- Warranty limitations
- Confidentiality conditions
- Prohibited retail accounts
If only certain products are restricted, identify the relevant SKUs rather than applying a vague restriction to the entire load.
A buyer must determine whether its resale channels can accommodate the conditions.
Introducing restrictions after an offer has been made may delay or change the transaction.
Provide Complete Logistics Information
A buyer needs to understand how the inventory will be collected.
Share:
- Warehouse address
- Number of pallets
- Number of truckloads
- Approximate total weight
- Pallet dimensions
- Whether pallets are stackable
- Whether products are floor-loaded
- Dock availability
- Forklift availability
- Pickup hours
- Appointment requirements
- Removal deadline
- Whether loading assistance is available
- Whether several locations are involved
If the load is described as a full truckload, confirm whether that means:
- A 53-foot trailer
- A different trailer size
- A floor-loaded shipment
- A specific number of pallets
- A weight-limited load
Use exact quantities rather than assuming every party interprets “truckload” the same way.
Freight may influence the offer, particularly when products are heavy, bulky, non-stackable or spread across multiple warehouses.
Prepare a Complete Buyer Submission Package
A professional submission should include:
- An Excel or CSV manifest
- A pallet summary
- Product and pallet photographs
- Total quantities
- Condition definitions
- Packaging information
- Expiration dates
- Warehouse location
- Loading details
- Brand and channel restrictions
- Desired removal timeline
- Whether partial purchases will be considered
Add a short summary explaining why the inventory is available.
Examples include:
- Warehouse consolidation
- Business closure
- Overstock reduction
- Product discontinuation
- Retail shelf pulls
- Customer returns
- Packaging change
- Cancelled orders
- Seasonal clearance
The reason does not automatically determine value, but it helps the buyer understand the context and timeline.
What Happens After You Submit the Inventory?
A buyer may begin by reviewing the manifest, photographs, categories, conditions and warehouse location.
Additional requests may include:
- Updated inventory counts
- More photographs
- Sample units
- Purchase invoices
- Proof of ownership
- Inspection access
- Product testing reports
- Expiration details
- Pallet dimensions
- Confirmation of restrictions
If the lot matches the buyer’s purchasing requirements, the next stage may involve an offer and written transaction terms.
Confirm:
- Purchase price
- Payment timing
- Inspection conditions
- Freight responsibility
- Pickup date
- Loading requirements
- Discrepancy procedures
- Title transfer
- Treatment of rejected or missing products
- Resale restrictions
Do not release inventory based only on a verbal discussion. Important terms should be documented.
Common Mistakes When Selling Mixed Inventory
Sending photographs without a manifest
Photographs can show condition but usually cannot provide accurate SKU-level quantities.
Sending a manifest without photographs
A spreadsheet cannot show crushed boxes, opened cartons or mixed pallet organisation.
Combining all conditions
Separate new, returned, open-box, damaged and salvage quantities.
Using vague product descriptions
Identify the products as specifically as possible.
Providing outdated quantities
Perform a fresh count and revise the manifest when inventory changes.
Hiding low-value products
A mixed load should reflect the actual merchandise. The buyer may revise terms if the physical inventory differs materially from the submission.
Inflating retail value
Use verifiable MSRP and current price information. Do not select the highest marketplace listing.
Ignoring pallet-level organisation
The spreadsheet and physical inventory should use matching pallet identifiers.
Forgetting freight information
Location, pallet count, weight and loading access all affect the transaction.
Failing to explain restrictions
Disclose channel and brand limitations before receiving an offer.
Sorting without calculating the benefit
Reworking thousands of units can consume more labour than the likely improvement in value.
Mixed Inventory Seller Checklist
Before contacting a buyer, confirm that you have:
- Counted all pallets
- Assigned pallet numbers
- Created a pallet summary
- Prepared an editable manifest
- Listed one SKU per row
- Verified sample product identifiers
- Separated conditions
- Identified damaged packaging
- Added expiration dates
- Calculated case packs
- Taken representative photographs
- Documented known restrictions
- Confirmed the warehouse location
- Provided loading information
- Established a removal timeline
- Decided whether the lot can be divided
- Confirmed your authority to sell the products
- Assigned one contact person for questions
Frequently Asked Questions
Can I sell mixed pallets without a complete manifest?
Possibly. Some buyers consider unmanifested customer returns, shelf pulls or general merchandise. Provide category estimates, pallet counts, condition information, photographs and the inventory’s source.
What is the difference between manifested and unmanifested inventory?
Manifested inventory has an itemised list of products and quantities. Unmanifested inventory lacks a complete SKU-level record and may be evaluated using samples, category estimates and condition assumptions.
Should I separate products by category?
If practical, category separation can make the inventory easier to evaluate. Compare the labour cost of sorting with the likely benefit before reorganising the lot.
Can different conditions be included in the same truckload?
Yes, but each condition should be identified clearly. Keep new merchandise, returns and damaged products physically separated when possible.
How are mixed-SKU pallets valued?
Buyers may consider the product mix, condition, quantity, current resale demand, processing requirements, restrictions and freight. There is no universal percentage of MSRP.
Do buyers purchase partial truckloads?
Some buyers may consider smaller quantities, while others focus on full loads. State the number of pallets and whether partial offers are acceptable.
What photographs should I provide?
Include pallet overviews, open cases, product labels, packaging, UPCs, visible damage and representative products from every major category and condition.
Should I include damaged products?
Disclose damaged products and separate them from saleable inventory. A buyer may consider them, but the condition must be represented accurately.
How current should the manifest be?
Update it immediately before submission and again before finalising the transaction if products continue to sell or move.
Who handles the freight?
Freight terms depend on the transaction. Confirm who arranges transportation, pays the cost and assumes responsibility during transit.
Ready to Sell Mixed-SKU Inventory?
Mixed pallets and truckloads can be sold more efficiently when the buyer can understand what is included.
Begin with a physical count. Label the pallets, prepare a SKU-level manifest and separate products by condition. Add clear photographs, disclose restrictions and provide complete warehouse information.
You do not need to present every product as perfect. You need to present the inventory accurately.
When your manifest and photographs are ready, submit your bulk inventory for review. Bulk Inventory Buyer can evaluate the product mix, condition, quantity and logistics to determine whether the lot fits its purchasing requirements.