Database not configured

This app reads its database connection from a .env file next to server.js — nothing is entered in the browser.

Copy .env.example to .env
Paste the DATABASE_URL you were given (or fill in PGHOST/PGUSER/PGPASSWORD/PGDATABASE)
…or leave those blank and set GOOGLE_APPLICATION_CREDENTIALS to the service-account key file so the URL is read from Google Secret Manager (DB_URL)
Restart the server (npm start) and reload this page

Generate a report

Monthly performance data per merchant. Pick who, when, and what to include.

1 Merchants

No merchants yet — add at least one to run a report. You can queue several at once.

2 Reporting window

Month Span

RUNS Pick a month to preview the window.

3 Scope

Return abuse

Serial returners, wardrobing, empty-box claims.

Reseller

Bulk-buy patterns and resale-driven order flow.

FTID

Fake tracking ID refund scams on shipments.

Severity

Pinch cost per order $ Used for ROI math. Blank omits ROI. Top flagged cases How many highest-value customers to list. You can trim the list in the report.

ROI basis — which abuse types count as protected value Affects the ROI figure only. The per-type dollar splits in the report are always shown in full.

Egr Return abuse

BLOCK returns — auto-stopped.

Susp Return abuse

REVIEW returns — held, not confirmed.

Both FTID

Empty-box / fake-tracking claims.

Egr Reseller abuse

Blocked order value held.

Count Return abuse – Suspect at % as block Suspect cases are held for review, not confirmed abuse — only this share of their value counts toward ROI. 100% treats every suspect case as a confirmed block.

Presets

Run history

Reports you generate this session land here with live progress.

Database not configured

Generate a report

Email report

Presets

Run history

Connection diagnostics