eBay Pallet Manifest Valuation Tool

This tool ingests a pallet manifest (CSV), aggregates items by UPC, queries eBay for current and recently sold prices, and computes valuation metrics to aid pricing for eBay sales.

Features

• CSV upload of pallet manifests
• eBay search by UPC for active and completed listings
• Metrics: average current list price, average sold price, sell-through, trend
• Report view with export to CSV

Requirements

• Python 3.10+
• eBay Developer account with an App ID (Client ID) that can access the Finding API

Setup

1. Create and activate a virtual environment.
2. Install dependencies:

   pip install -r requirements.txt

3. Copy env.example to .env and fill in values:
   • EBAY_APP_ID = your eBay App ID (Client ID)
   • SECRET_KEY = any random string for Flask sessions
4. Run the app (default port 5000):

   python app.py

CSV Format

Provide a CSV with headers containing at least:

• Item or Item Name or Description
• UPC
• Quantity
• Retail (original retail per-unit price)

Example:

Item,UPC,Quantity,Retail
Widget A,012345678905,3,19.99
Gadget B,098765432109,2,29.99

Notes

• The tool uses eBay Finding API endpoints findItemsByKeywords and findCompletedItems with the UPC as the keyword.
• Completed search filters to sold results where available and aggregates prices in USD.
• If a UPC has no matches, metrics will be empty for that section.

Windows PowerShell quick start

From the project directory:

py -3 -m venv .venv; .\.venv\Scripts\Activate.ps1; python -m pip install -r requirements.txt; Copy-Item env.example .env -Force
# Edit .env and set EBAY_APP_ID, then run:
python app.py

Disclaimers

• This tool is for research/valuation only. eBay market data can fluctuate.
• Respect eBay API rate limits. The client includes basic backoff.