Help Center

How to Analyze Manifest Files

Learn how our manifest analyzer and real-time eBay price checking tools help you make data-driven buying decisions and maximize profits by analyzing your inventory manifests (.xlsx, .csv).

Liquidation Pallet Analysis: Quick Start Guide

1

Upload Manifest File

Click 'Choose File' and select your manifest (.xlsx or .csv). Ensure it includes columns like 'Item Title', 'Quantity', 'Retail Price', and 'UPC' (if available). Our system will parse the data for analysis.

Upload a manifest

Select your .xlsx or .csv manifest file

2

Add Shipping Cost

Enter your estimated shipping cost to get accurate profit calculations and maximum bid recommendations. Our calculator will distribute shipping costs proportionally across all items in the pallet.

Entering Analysis Parameters in Pallet Analyzer Pro

Entering the shipping cost and other parameters

3

Review Analysis

Get detailed item breakdowns with real-time eBay market prices, profit potential, and a recommended maximum bid. Use this data-driven analysis to make informed bidding decisions and avoid overpaying for liquidation pallets.

Analysis Review

Review detailed analysis of your pallet

Detailed Guides

Understanding the Manifest Analysis Report

Our manifest analyzer provides comprehensive information based on your uploaded file:

  • Item-by-item breakdown with details parsed from your manifest (Title, Quantity, Retail, UPC etc.)
  • Real-time eBay market price comparisons powered by actual sold data
  • Intelligent price filtering to remove outliers for accurate valuation
  • Proportional shipping cost allocation across all items
  • Potential revenue projections with marketplace fee considerations
  • Data-driven maximum bid recommendation to ensure profitability
  • Per-item profit analysis to identify high-margin opportunities

Real-time eBay Market Data & Market Pricing

We use real-time eBay market data and filter obvious outliers to provide accurate inventory pricing:

  • Outlier filtering to improve average price estimates
  • Smart Search Optimization combining manufacturer and model information
  • UPC verification for precise product matching when available
  • Recent eBay sold data used to derive robust median prices
  • Current market prices from active eBay listings
  • Sold item data for accurate valuation
  • Condition-based price adjustments for realistic estimates
  • Competitive pricing strategy with undercut percentage for quick sales

Learn more about our market pricing methodology and how it helps you bid confidently on profitable pallets.

Complete User Documentation

Getting Started

Pallet Analyzer Pro offers two powerful tools for resellers and inventory managers:

  • Manifest Analyzer: Assess the potential profitability of inventory lots or pallets by estimating market value, calculating profitability, determining bid prices, and analyzing existing stock
  • Market Pricing: Understand realistic price ranges using recent eBay sold data with outlier filtering

Preparing Your Manifest File

The accuracy of your analysis depends on the quality of your manifest file:

  • Supported Formats: .xlsx (Excel) and .csv (Comma Separated Values)
  • Required Columns: Item Title/Description, Quantity, Retail Price/MSRP
  • Recommended Columns: Brand/Manufacturer, Model Number/Part Number, UPC/EAN
  • Column Naming: Use clear, descriptive headers for best results

DirectLiquidation.com and B-Stock.com formats are automatically detected. For other formats, our AI system will attempt to identify the correct columns.

Analysis Parameters

Configure these settings to tailor the calculation to your situation:

  • Shipping Cost: Total cost to ship the entire pallet/lot to you
  • Undercut %: Percentage below average eBay sold price for competitive pricing
  • eBay Fee %: Average final value fee percentage (typically 10-15%)
  • Desired Profit Margin %: Target profit margin on cost of goods

Understanding Results

Your analysis provides comprehensive financial insights:

  • Total Retail Value: Sum of all retail prices in your manifest
  • Potential Gross Revenue: Estimated total sales revenue
  • Estimated Fees: Calculated marketplace fees
  • Maximum Recommended Bid: Data-driven maximum purchase price
  • Item Breakdown: Detailed analysis for each product

The Maximum Recommended Bid is calculated as: Net Revenue ÷ (1 + Desired Profit Margin %)

Frequently Asked Questions

Need More Help?

Our support team is here to help you make the most of Pallet Analyzer Pro.

Contact Support