Eppraise is a library to help estimate value of items based on sold ebay listings. It uses the python-ebay API to connect and query data, SQL storage (default sqlite) to collect data over time, and serval convenience classes for working with data. It also provides several command line features for high level usage.
It also has a web UI for examining data:
Eppraise is python3-based. Required debian packages are listed in packages.lst.
Install Steps:
- Install dependencies:
sudo apt-get install $( cat ./packages.lst )
- Install ebay library:
- Clone the repo:
git clone https://github.com/timotheus/ebaysdk-python
- Install the repo:
cd ebayskd-python; python3 setup.py install --user
- Clone the repo:
Configuration Steps:
- Obtain an Ebay API App ID
- Create a config file:
cp config.yaml.example config.yaml
- Place an App ID in the config file:
ebay: { id: "my-app-id-key-9876543210" }
As an application, eppraise expresses several subcommands, similar to git and svn. Commands faciliate administrating watches, bulk IO, collecting data, and a local web server. Peruse it's help documentation for details around each command.
All commands are database-relative. By default, the database is assumed to
reside at ./eppraise.db
; use the --database-url
switch to specify
otherwise. Database URLs should use SQLAlchemy syntax. Database schema is
auto-created on connect as appropriate.
Add or enable a watch:
eppraise.py watch "Some Ebay keywords"
Disable a watch:
eppraise.py watch "Some Ebay keywords" --disable
Add many watches from a spreadsheet:
eppraise.py xlsx mySpreadsheet.xlsx --input-range='A2:A200'
Add watches and output estimates from/to a spreadsheet:
eppraise.py xlsx mySpreadsheet.xlsx --input-range='A2:A200' --output-range='B2:B200'
Query ebay for watch results:
eppraise.py update
Start the webserver on port 5000:
eppraise.py web
Manually specify configuration, database, or verbosity:
eppraise.py --verbose=DEBUG --config=myConfig.yaml --database-url=sqlite:///myDB.db [SUBCOMMAND] ...
Currently the web UI offers a read-only view of current watches: An estimate, id, and status of each watch, and a scatter plot of matching items. Hover over a plot item to see it's sell price and date, click to open the item's ebay page(if still available).
Improve subcommand and web functionality!