Back to lots

All auction platforms

Sources we index on koveh.com. New collectors are added via Airflow + automation/.

Aurena

AT / DE

Live

Insolvency auctions via Aurena Beacon API. Full catalog ~62k lots; bi-daily Airflow sync.

www.aurena.deAirflow DAG: koveh_aurena_collectors_etlDatabase: aurena
Browse lots

Surplex

EU

Planned

Machinery and plant auctions — planned second source.

www.surplex.comDatabase: aurena

Adding a new auction platform

  1. Create `automation/<platform>_collectors/` with scraper → JSON catalog → Postgres uploader (mirror `aurena_collectors/`).
  2. Add DDL in `automation/scripts/sql/<platform>_tables.sql` or extend `aurena` schema with `source` column on lots.
  3. Register the platform in `src/lib/aurena-platforms.ts` (this file drives `/auctions/platforms`).
  4. Add Airflow DAG under `marketplace-dwh/airflow/dags/koveh_<platform>_collectors_etl.py` — mount `/root/automation` is already in compose.
  5. Set `AURENA_DATABASE_URL` (or per-source DSN) in Airflow env and koveh.com `docker-compose.yml`.
  6. Expose listings via `/api/aurena/lots` or a new `/api/auctions/<source>/lots` route; unify types in `aurena-types.ts`.
  7. Map categories in `aurena-category-labels.ts` or a per-source label map.
  8. Smoke: `AURENA_SKIP_GATE=1 python3 scraper/scraper.py --max-lots 50` then uploader with `--run-key manual`.