Loading…
Dashboard
Year-to-date · 2026 · Leumas Live
eBay Connected
eBay Business Policies
Required to list on eBay. Click Load from eBay to pull your shipping, payment & return policies, pick one of each, then Save. (Requires Connect eBay first.)
2026 Net Profit / Loss
—
Loading...
Monthly Performance — 2026
Expenses
Sales
Earnings
Operations P&L (Monthly) — 2026· investment spend tracked separately on Master Dashboard
| Month | Expenses | Investment | eBay Sales | Off-eBay | Total Sales | Earnings | Profit | Margin | Orders | Units |
|---|
Promoted Listings — 2026
| Month | Ad Spend | eBay Sales | Ad % of eBay | Ad Transactions |
|---|
Master Dashboard
Inventory + Investments · all channels
Business Net Worth
—
Listed inventory + investments + earnings − expenses
eBay Inventory
Top Lots by Earnings
| # | Type | Invested | Earnings | P/L |
|---|
Investments
Top Singles by P/L
| Card | Paid | Earned | P/L |
|---|
Expense Breakdown
| Category | 2025 | 2026 | Total | Share |
|---|
Market Value — Coming with eBay & TCGPlayer API
Real-time card values via TCGPlayer + eBay Sold Listings. Listed price replaced by market price. Portfolio value updated daily.
TCGPlayer Planned
eBay Sold Listings Planned
PSA Pop Report Planned
Historical
Multi-year financials
Year over Year
All-time combined · one final number
Year Over Year Performance
Expenses
Sales
Earnings
Year-by-Year Breakdown
| Year | Card Expenses | Biz Expenses | Total Expenses | Sales | Earnings | P/L | Margin |
|---|---|---|---|---|---|---|---|
Month-by-Month
| Month | Expenses | Sales | Earnings | P/L | Margin |
|---|---|---|---|---|---|
All-Time Net Result
—
Total earnings minus all expenses across all years
Snapshot
Real-time business view · YTD 2026
Inventory Value by Price Band —
| Band | Listings | Total Quantity | Value | Avg / Card |
|---|
Data sources: Avg daily deposit = (CREDITs − DEBITs − marketplace fees + refunded fees) over last 90 days ÷ 90, from ebay_transactions. Operating P/L = eBay net YTD − operating expenses (ST.expenses table, no investments). Cash P/L = eBay net YTD − all expenses YTD (expenses_full rollup, includes card investment spend). Delta between the two = capital spent acquiring inventory this year. Activity YTD = ST.ord rows with sale_date in 2026, all channels.
Inventory
Loading your cards...
Never synced
Listings
Pricing Tool
Listings
| Img | SKU | Title | Lot | Qty | Price | TCGP MKT | MP MKT | Sold | Listed | Status | Actions |
|---|
Playable Sets
Top-25 competitive Pokémon decks — your stock vs market
Card Matching
TCG cards that need a catalog match
Needs Review
| Title | Qty | Price | Match |
|---|
Fix Duplicates
Find listings that are really the same card, and merge them so your counts are right
Duplicate listings
Review each — the same card listed under different box SKUs should merge into one listing. If two rows are actually different cards (a mis-bind), do not consolidate — use Card Matching to fix the binding instead. Consolidating keeps one listing (highest qty), sets its quantity to the group total, and ends the others on eBay. This fires real eBay Revise/End and is confirm-gated.
Ledger integrity
Checks that every listing's quantity still matches its recorded movement history. A clean result is the expected state — your ledger re-ties to your live counts nightly, so this is a read-only tripwire that flags anything the system couldn't record.
Read-only — nothing is changed.
eBay Mismatches
Where eBay's counts don't match yours — review and fix them in bulk
eBay vs Leumas
Leumas is the source of truth. Syncs no longer overwrite your data — they just report what eBay shows. These
are the listings where eBay and Leumas disagree on quantity or price. Tick the ones to fix and
Push selected to eBay — Leumas's number is written to each live listing (ReviseItem), then the flag clears.
This fires real eBay writes and is confirm-gated; nothing changes until you push.
Lots
Your lot listings — set completion, set lots, and custom bulk lots
Dashboard
Set Lots
Set Lots
Track set completion across your TCGs — pick a game, series & set
Pick a series and set above to load the master-set completion grid.
This page only counts what you own — it never changes your listings.
This page only counts what you own — it never changes your listings.
Combine Scanner
Find existing eBay listings that look like the same card and could be combined
Scans active eBay listings and clusters them by extracted card # + matching set name.
Only listings with BOTH a detectable card number AND a detected set name are eligible.
Listings with grading prefixes (PSA, BGS, SGC, CGC) or "signed/auto" markers are skipped.
Each proposed cluster shows the listings — you pick which one is parent, check the box to include, then click Queue Selected.
Queueing pushes to the same approval queue used elsewhere — nothing combines on eBay until you click Push.
No scan run yet
Click "Scan Active Listings" to find combine candidates among your existing eBay inventory.
Orders
Every sale, on every platform — one page
All orders
TCGplayer orders
Orders
Every sale in one place — eBay and everywhere else
Never synced
Orders
| Rec# | Date (PST) | Title | SKU | Qty | Earnings | Total | Buyer / Platform | Lot |
|---|
Combine Recovery
Reunite orphaned grandchildren · verify combine integrity
How this page works
Each row is an archived combine whose children were never absorbed into an active parent. For each row you can:
Absorb — splice this archived combine's children into a selected active combine (recommended when you find the right target).
Un-archive — restore as a standalone active combine (use if the eBay listing for this SKU still exists and just got incorrectly archived).
Dismiss — hide from view this session only (no DB write). Use for rows you've decided to leave alone.
Every absorb / un-archive is logged to combine_recovery_audit; click Undo Last to reverse the most recent action.
—
Reset
Not loaded yet
Click Refresh to load archived combines and compute candidate matches.
Combine & Fix Duplicates
Merge duplicate listings of the same card into one — Leumas tracks which box each copy lives in.
Combine Flow
New Exact — same-title duplicates, safe to approve. Similar — near-matches to review. Approve the ones you want, then Push to eBay — the kept listing's quantity goes up and the extras end.
Already listed the same card more than once? Click Consolidate Duplicate Listings (top of this page) — it finds every duplicate across your live listings and merges each into one.
Existing (0)
New Exact (0)
Similar — Review (0)
Queue (0)
New Imports (0)
Manual Combine
Denied (0)
Fix Duplicates
Lot Backfill (0)
Combined Groups — 0 parent SKUs
Duplicate Listings — combine-aware (admin test)
Finds cards listed more than once across all your active listings — including combine parents/children, which the New Exact list below can't see. Keeps the combine parent (or highest-qty listing), sums quantities into it, ends the rest (each recorded as a combine child). Dry-run first; runs in small batches.
Reconcile inventory from this import
Treats the import you just staged in New Imports as the source of truth: sets your on-hand quantity for each card to the imported amount — raising under-counts and draining over-counts. Re-importing an unchanged pile nets zero. Shows a dry-run preview first; Leumas updates first (reversible backup + ledger), then your eBay listings are revised/ended to match.
Exact Duplicate Titles — 0 pending
| Parent SKU + Title | Child SKU + Title | New Qty | Lot | Action |
|---|
Similar Titles — Manual Review — 0 pending · —
| Existing Parent | New Listing | Match Score | Lot | Action |
|---|
Approval Queue — 0 waiting to push
These combines have been approved and will push to eBay on the next Push. If a combine
fails (parent delisted, eBay rejection, etc.) it stays in the queue and re-fails on retry.
Use to remove a single stuck approval without wiping the whole queue, or to point
it at a different parent SKU when the original parent has been absorbed elsewhere.
| Parent SKU | Child SKU | Title | Action |
|---|
New Imports — Unmatched Cards — 0 pending
| SKU | Title | Price | Qty | Lot | Status | Action |
|---|
Pick a lot to tag listings as they're created
Manual Combine — Search and combine any two listings
PARENT SKU (keep this listing)
CHILD SKU (merge into parent)
Select a parent and child SKU above
Denied Combines — these will never be re-suggested
| SKU A | SKU B | Action |
|---|
Assign cards to lots — …
Match the photo, pick a lot, Assign. Skip just hides a card from this list (nothing is written — bring them back with Review skipped). Every assign is logged in the Audit Trail below and revertible.
Lot Backfill — what this does
Backfills lot_id across three tables in one shot per rule:
combines.child_lot_map · inventory.lot_id · orders.lot_id.
Order sales pick up the lot via assigned_child_sku chain, so the Lots tab P/L attributes correctly going forward.
Safety: the engine never overwrites an existing lot value — only fills nulls / empty map keys. Every write is logged to lot_backfill_audit under one batch_id. Revert any batch with one click.
SKU convention: new lots use SKUs starting with "Box ". Anything else is legacy → assignable to lot old via the one-click below.
Quick Actions
Phase A — Auto-pass
For every unmapped combine child, fill from existing data: (a)
orders.assigned_child_sku → orders.lot_id pair, then (b) live ST.inv.lot_id where the child sku still exists in inventory. Free wins, no patterns required.
Click "Preview" to scan…
Non-Box → Lot 'old'
Pattern
^(?!Box ).+ → lot old. Sweeps every SKU not prefixed with "Box " (B1-/B2- shorthand, COMBINED-, SV/SWSH set SKUs, CDP-, etc.) into the legacy bucket. Single batch, fully revertable.
Click "Preview" to scan…
SKU Rule Engine — 0 rules
Type a regex pattern + pick a lot. Live match preview before commit. Each Apply runs across all three tables under one batch_id. Stored rules persist between sessions — re-running an already-applied rule is a no-op for rows already tagged.
Match preview will appear here
| Pattern | Lot | Last Applied | Writes | Action |
|---|
SKU Bucket Browser — 0 buckets unmapped
Buckets are auto-extracted from currently-unmapped SKUs across combines + inventory + orders. Click a bucket's Apply button to create a rule for that prefix and run it immediately. Buckets only show "Box "-prefixed SKUs — use the Non-Box one-click above for legacy formats.
| Bucket | Inv | Children | Orders | Total | Assign to lot | Action |
|---|
Audit Log — 0 batches
Showing most recent ~1000 rows of audit history (PostgREST cap). Each row = one Apply click. Revert undoes exactly that batch's writes (clears the lot_id back to null wherever this batch had filled it). Manual edits made after a batch are preserved — revert only touches values this batch wrote.
| When | Source / Pattern | Lot | Writes | Status | Action |
|---|
Pick List
Orders to pull and ship — check each card off as you box it
Pending Orders
| Order | Item | Pull SKU | Buyer | Date (PST) | Price |
|---|
Card Lots
A lot is one batch of cards you bought — track what you paid and what it has earned back
Your Lots
Monthly Report
Month-by-month profit from selling — investment purchases are tracked separately on the Master Dashboard
All Months Summary — Operations P&L
| Month | Expenses | Investment | Sales | Earnings | Profit | MoM | Margin | Orders | Units | Listed $ | Sell-Thru | Multi-Card% |
|---|
Expense Ledger
Business expenses · all channels
Expenses
| Date | Item | Type | Cost |
|---|
Filtered Total:
$0.00
Investments
Singles & Sealed · by year
Combined — Singles + Sealed
Singles
Sealed Product
Investment P/L by Year
| Year | Type | Invested | Sales | Earnings | Unsold Value | P/L | ROI |
|---|
Singles
Individual card investments
Singles
| Card | Purchased | Paid | Copies | MKT | Value Now | If-Sold Gain | Sold Date | Sales | Earnings | P/L | Status | Actions |
|---|
Sealed Product
Sealed product investments
Sealed Items
| Item | Copies | Invested | MKT | Value Now | If-Sold Gain | Sold | Sales | Earnings | P/L | Status | Actions |
|---|
CARD SEARCH
Search by card name, set, SKU — inventory + orders + combine groups
Start typing to search
Results across inventory, orders, and combine groups
Widget Lab
Build your own pages from widgets — Orders, Pick List, KPIs, Inventory on one grid. Saved pages appear under "My Pages".
Scan & Identify
Upload card images — we match them automatically
1 Configure
2 Upload
3 Review
Setup
Saved title / description / images / policies — edit via Configurations
Catalog we match your scans against
Listing defaults
Default for every card (editable per card later)
Default starting price
Auto-increments if it ends in a number
Scheduling (optional — stagger listings)
All listings go live immediately.
Scan Configuration
Title format, description, images, platform policies & categories
Configuration profile
Title generator
Variables — click to add to the title; AA forces that variable uppercase
Structure — drag to reorder (or use ); × to remove
Preview
Description & images
Platform & business policies
Store categories — each maps to its own business policies
Map a store category to its payment / shipping / return policies. When a card is filed under a category, those policies apply automatically.
Cropping — zoom regions shown on every card during review
Pick a card game and draw the regions you want to inspect on every card of it — edges, centering, the collector number, the holo pattern. Each region becomes a zoom tile on the review screen, beside your scan. Each game keeps its own set. Display only — cropping never changes matching, pricing, or your listing photos.
Scan Batches
Drop big batches, work the matching & pricing as you have time
Your batches
Not-found report — every card the matcher couldn't identify, with the likely cause
Loading…
Match Accuracy
Auto-match accuracy & manual corrections by TCG — all tenants (admin)
Accuracy by TCG
Loading…
Inconsistency reports (beta)
Loading…
eBay Tools
Promoted Listings ads and markdown sales — you review every change before it goes live.
eBay Ads
Discounts & Offers
Customize
Make it yours — brand, colors, text size. Live preview; nothing changes for anyone else.
Brand
Your name + logo replace the in-app wordmark. (The browser-tab name stays "Leumas Live".)
Colors & Text
Brand-accent, sidebar, and background. (Profit/loss reds & greens stay fixed so P&L always reads right.)
Changes preview live as you edit. Save makes them stick across devices.
Labels
Rename the sidebar sections to match how you work. Blank = the default name.
Feature Store
Turn optional features on or off for your account.
Manual Listing
Add an item to inventory — eBay-ready (photos, policies, description). Added to inventory, not auto-listed.
Add Item to Inventory
Sealed product, sleeves, accessories, or any item not from CardUploader.
Click to add a photo
Recently Added (Manual)
No manual entries yet
Import Data
Bring your cards and sales in from spreadsheet files — eBay, CardUploader, TCGplayer, and more
CardUploader Export
Export from carduploader.com. Cards added to inventory. Assign lot after import. Multiple files supported — drop or pick several at once.
Raw Cards
Click or drop raw CSV(s)
Graded Slabs
Click or drop slab CSV(s)
Captures grader, grade & cert #. Excluded from combines.
Reads:
*Title CustomLabel *StartPrice *Quantity · slabs also read grade + Certification NumberCard Dealer Pro Export
Export from carddealerpro.com (eBay Bulk Upload format). Cards added to inventory. Multiple files supported — same parser as CardUploader with the CDP metadata prefix stripped.
Click or drop CSV(s)
Reads:
*Title CustomLabel *StartPrice *Quantity · skips Info,Version=... lineTCG Automate Export
Export from TCG Automate (eBay Bulk Upload format). Cards added to inventory. Multiple files supported — same parser as CardUploader.
Click or drop CSV(s)
Reads:
*Title CustomLabel *StartPrice *QuantityTCGplayer Inventory → eBay
Upload your TCGplayer MyPricing export to cross-list your TCGplayer stock to eBay. Cards bind automatically (no matcher), pull a product image, and price with your eBay markup. Staged in New Imports — review before listing. One file.
Click or drop your MyPricing CSV
Reads:
TCGplayer Id Product Line Total Quantity TCG Market PriceMigrate Inventory (CardUploader)
Switching from CardUploader (or a similar platform)? Upload your full inventory export. Each Catalog SKU is matched to its eBay listing as the combine parent; User SKUs become child SKUs (not on eBay) and appear in the Existing tab. Quantities, prices & TCGplayer bindings from this file become the source of truth. One file.
Click or drop your inventory CSV
Reads:
Catalog SKU User SKU Title TCGplayer SKU Price Qty · no eBay listings revised/endedRestore SKU mapping
Does your pull sheet show codes like CS-XXXXXX instead of your own SKUs? Upload the same CardUploader inventory export here. This restores only which of your SKUs each card belongs to, so pull sheets name the right box. It does not change quantities, prices, listings or anything on eBay, and it will not add cards back into your inventory. Safe to run more than once.
Click or drop your inventory CSV
Reads:
Catalog SKU (or Custom Label) + User SKU · columns are detected and shown before anything is saved · no inventory, listing or eBay changesHistorical Sales (any platform)
Import past sales from eBay, TCGplayer, Cash, Discord, Mercari, or anywhere else. Download CSV template
Click or drop Sales CSV
Cols:
Date Platform Item Name Quantity Sold Price Fees Net Buyer SKU Lot Cost Basis Marketplace Order ID Item ID Item URLHistorical Expenses
Import past expenses (supplies, shipping costs, fees, subscriptions, etc.). Download CSV template
Click or drop Expenses CSV
Cols:
Date Type Amount Description NotesTCGplayer Order History
Import past TCGplayer orders for your records. This records order history only — it does not change inventory. Re-importing is safe (deduped by order #).
Click or drop TCGplayer Orders CSV
Reads:
Order # Date Product Set Condition Quantity Price Buyer
Recent Imports (last 10)
| Time | Type | Rows | Status | Files |
|---|---|---|---|---|
| Loading... | ||||
Import Log
| Time | Type | Records | Status | Notes |
|---|---|---|---|---|
| No imports yet | ||||
API Status
Connected services · sync status
eBay Developer API
Listings sync, order fulfillment, finances, combine push · per-tenant OAuth
Connected
eBay Sync Controls
Last sync: Never — click Test Connection first
TCGPlayer API
Real-time card market prices for Singles & Sealed investments
Supabase Database
leumas-live · cxyjpfdpmvcfjpqbaigp · East US
Connected
Domain — inventory.leumascc.com
DNS setup pending · will point here after Netlify deploy
Domain — leumascardcraze.com
Brand domain · parked for future storefront
When eBay API connects — what happens automatically:
→Your eBay listings sync to database
→New orders appear in real time
→Pick list activates for every order
→eBay fees tracked exactly via Finances API
→Combine push: parent qty updated on eBay
→April 30–today orders backfilled automatically
→Parent hits zero → unpulled children flagged
→Weekly eBay store fee auto-import to ledger
Diagnostics
Read-only audits across inventory and combines data. Run any anytime.
Note: All buttons here are READ-ONLY. They scan local state and report findings — no database writes, no eBay calls. Cleanup scripts (which DO write) remain console-paste-only by design.
Fire every read-only card in sequence (~30s end-to-end). Each card's verdict renders inline; scroll to review.
Admin-only operational audits below. New users won't see this block.
Self-Loop Audit
Scans combines for any parent_sku that appears in its own child_skus, and pending approvals for parentSku===childSku. Verifies the v2.9.88 chokepoint is holding the line. Expected: 0 findings.
Year-Boundary Patterns Audit
Hard deadline: Dec 31, 2026. Scans local state for any field/value that still references "2026" — `totals2026`, `months2026`, `ord2026`, etc. Documents the pattern surface for the eventual refactor session. Past Dec 31 these become silent misclassification bugs.
Combine Integrity Audit
Scans combines table for structural anomalies: duplicate parent_skus (two combine rows pointing to the same parent), empty child_skus arrays (combine with no children), non-string elements in child_skus, and parent_skus with no matching inv row (orphan parents). Expected: 0 across all four categories.
Combine Qty Integrity
For every active combine where all kids have an inv row (no phantoms), compares parent
inventory.quantity against the sum of child quantities. Flags mismatches. Phantom-containing combines are skipped — you can't honestly sum kids that no longer exist locally. Same sweep also available on Combine Recovery page; mirrored here for general diagnostics use.eBay Webhook Subscription
Registers your eBay account to push real-time notifications to the
ebay-webhook Edge Function — sales, listing created/revised/closed, auction checkout. Without this, the app only learns of new sales via the periodic syncOrders poll; with it, sales appear within seconds via Supabase Realtime. One-time setup; idempotent if you click again. Per ef-security-audit notes: never been called → 0 events received in DB ever.
TCG Diagnostics
Sync · Catalog · Reconciliation · Projection
TCG Sync Health
Queries
tcg_eligible_inventory for drift between local and TCGplayer. Shows decrement candidates (sold on eBay since last push), increment candidates (restocked / new combine pulls), ghost listings (cards on TCG you don't have anymore), and total cards diverged. If decrements or ghosts are non-zero, the next CSV export will reconcile them.TCG Projection Refresh
Reloads
tcg_orders + tcg_order_lines and re-projects them into ST.ord as synthetic off-eBay rows so dashboards reflect any commits since boot AND any lot_id changes on the matched inventory. Idempotent — safe to click repeatedly. Cancelled/refunded/voided parents are excluded from the projection.TCG Catalog Freshness
Queries
tcg_catalog for the newest updated_at across all rows, plus per-game freshness, plus running count of tcg_order_lines with match_status='no_match'. Color bands: ≤7d green / 8-30d yellow / >30d red. New TCG sets release roughly monthly — refresh the catalog if it's been a while, especially before high-volume sales.TCG Reconciliation
Shows the count of inventory rows where
tcg_listed_qty > 0 (what local thinks is live on TCG), sum of cards listed, pending drift to reconcile on next CSV push, and last successful export from tcg_sync_log. Mentally diff the "Cards on TCG" number against your TCG seller dashboard's count — if they disagree materially, you have ghost listings TCG didn't reconcile.Lot Attribution Coverage
Snapshot of Lot Backfill progress — how many
combines.child_lot_map entries are populated, how many inventory rows have a lot_id, how many orders are attributed. Click Check to compute against current in-memory ST. Mirrors the KPI strip on the Lot Backfill tab; surfaced here so you can monitor progress without leaving Diagnostics.Webhook Events Delivered
Queries the
webhook_events table to confirm the subscription above is actually pushing. Shows total events ever, last 24h count, last event timestamp, and per-event-type breakdown. If you just registered, give eBay a few minutes — they don't backfill, only push events that fire AFTER subscription is active.
Data Health
SKU drift · combine recording · audit batches
Dup-SKU Drift Monitor
Counts SKUs shared by 2+ active inventory rows. Post the 2026-05-25 cleanup (930 rows renamed under batch
8d9c4cbf-…) this should sit at 0. Any drift indicates future imports / manual edits re-introducing duplicates. Re-run after CSV imports to confirm cleanliness.Combine Recording Health
For every active combine whose parent has a live inv row, compares
child_skus.length against parent quantity. Surfaces the 4,047-style backlog from the v2.16.33 audit (68% under-recorded). Companion to Combine Qty Integrity: that one checks sum-of-child-quantities; this one checks count-of-recorded-locations.Malformed Combine Children
Counts
child_skus elements with structural problems: trailing dash (the "Box 11 - M1 -" class from v2.16.31), leading/trailing whitespace, empty strings, non-string types, double-dash. Each becomes a manual fix candidate. Per v2.16.31's note, the app renders these as-is — auto-cleanup is a separate workflow.Historical-Overlap SKU Tracker
Counts the SKU collision categories intentionally skipped in the 2026-05-25 dup-SKU cleanup: 1 active + N historical (functionally fine — single live SKU) and all-historical (audit noise only). Plus surfaces any new active-vs-active collisions that might appear later. Lets you decide later if/when to clean up historical overlap.
Recent Audit Batches
Merges the most recent batches across three audit tables:
lot_backfill_audit, tcg_collision_cleanup_audit, dup_sku_rename_audit. Shows table, batch_id (first 8 chars), row count, reverted count, source/reason. Surfaces dup_sku_rename_audit which has no other UI today.ST Length Sanity
For every boot-loaded ST array (
ST.lots, ST.ord, ST.inv, ST.ebayTx, etc.), compares in-memory length against DB COUNT(*). Smoking gun = ST length stuck at 1000 while DB has more (PostgREST default cap signature). Caught the v2.16.52 silent truncation bugs; will catch the next one too. ST.ord + ST.inv legitimately exceed DB count (synthetics + carduploader staging).Multi-Listed Cards Scanner
Scans inventory for
(tcgplayer_id, condition) groups with 2+ active rows. This was the trigger for the 2026-05-25 Umbreon over-sell — pre-v2.16.14 the CSV dedupe summed wrong on these and inflated TCG state. v2.16.14 fixed the math, but multi-listing remains operationally fragile (hard to allocate when TCG sells one). Run before any TCG CSV push; consolidate flagged groups via the Combine Listings page first.TCG State Readback (drift detector)
Compares TCG's actual listed inventory against our local
tcg_listed_qty model. Upload a fresh TCGplayer MyPricing CSV export (Pricing → Generate Pricing Custom Export → download). We parse the Total Quantity column, aggregate by (tcgplayer_id, condition), and surface every drift bucket. This is the only path to detect TCG state corruption. Run after every kill-switch + push cycle to confirm TCG agrees with us.
Force-Drain CSV: uses TCG's exported Total Quantity per row to compute negative deltas. Drains TCG to 0 even when our local
tcg_listed_qty under-counted (e.g., post-kill-switch stragglers from pre-v2.16.14 dedupe drift). Generate, upload to TCG, then re-run Drift Check to verify.
Admin
Cross-tenant operational view · admins only
TCG Catalog
TCGplayer reference data · upload monthly Pricing Custom Export CSVs
Upload one CSV per game (TCGplayer · My Account · Pricing · Generate Pricing Custom Export). Re-uploading replaces existing rows on conflict — safe to refresh anytime.
Matching is now automatic — new inventory binds to the catalog on its own; anything ambiguous waits for a one-click review under Card Matching.
Match to Catalog
Matching now runs automatically — no button to press
Inventory now binds to the TCG catalog automatically. The moment cards land in your inventory (after listing/approval or manual entry) the safe matcher runs on your rows, and a nightly job re-checks everything as catalog data and prices change. Safe, unambiguous matches bind silently; the rare ambiguous card is held for a one-click Confirm / Reject under Card Matching. Nothing here needs your attention unless you want it.
Sync to TCGplayer
Send your prices and quantities to TCGplayer — you preview every change first
Sends every card that's new or has changed to TCGplayer, in the file format TCGplayer expects. Prices — and which cards qualify — come from your Pricing Tool rules. After a push, the next one only sends what changed since.
Recent Sync History
TCG Orders
Bring in your TCGplayer orders and take the sold cards out of your inventory
PREVIEW FIRST, THEN COMMIT. Upload your Shipping CSV + Packing Slips PDF, then click Run Preview Match to see how each order line matches up with your cards. When it looks right, click Commit OK Orders to: (1) record the orders, (2) take the sold cards out of your inventory, (3) update the matching eBay listings (or end ones that hit zero). Safe to run again — orders already committed are skipped, never double-counted. Only orders marked 'ok' commit; anything marked 'review' or 'hold' waits for your decision.
1. Shipping CSV
No file selected
2. Packing Slips PDF
No file selected
Shipping Queue
TCGplayer orders ready to pack — print labels, mark them shipped
SHIPPING WORKFLOW. After committing TCG orders on the TCG Orders page, they land here as
pending. Click 4×6 Label per row to print a pick/pack slip (works on thermal printers — Rollo/Munbyn/DYMO 4XL). Pull the cards using the SKU + LOT chips on the label. Attach the TCG-supplied shipping label and ship. Click Mark Shipped to drop the row from the queue. Filter switches between Pending (default), Shipped (history), and All.
Card Shows
Take cards to a show, sell on the floor, and square everything up when you're back.
What's New
Roadmap, recent updates, and your feedback.
Roadmap
Recent Adds / Fixes
Suggestions & Issues
Aging Inventory
Active eBay listings by time on market — refresh the stale ones with End & Relist
AUTO END & RELIST
Every night, Leumas ends and relists your OLDEST active eBay listings (past your age threshold), optionally
dropping the price — a fresh listing without lifting a finger. Price-adjusted cards are locked from the
auto-pricer (🔒) so the discount sticks; cards already 🔒 locked relist at their current price.
⚠ Before you turn this on: eBay can see repeated end-and-relist churn — heavy use may flag your account
or affect search placement. Each relist starts a NEW listing, so its watchers, views, and sale history are
lost — and it counts against your monthly free-listing (zero insertion fee) allowance; past that, eBay
charges an insertion fee per relist (check your allowance in Seller Hub). This is optional and entirely
your call — it runs only while you leave it on.
"Cards with watchers" uses your last-synced watcher counts — run 👁 Sync watchers on the Aging page to refresh them; a card whose count was never synced is treated as having no watchers.
Recent activity (last 3 nights)
Inventory Audit
Cycle counting — walk your physical inventory on a schedule so every card gets checked at least once per cycle
Audit setup
Confirmed / Mismatch only records what you saw — it never changes your inventory count and never touches eBay or TCGplayer. A mismatch is filed below for you to resolve through Inventory or Combine Listings when you're ready.
Record a mismatch
This records the variance only — it does not change your inventory count or touch eBay/TCGplayer. Resolve it through Inventory / Combine Listings when you're ready.
Charts
Visual view of the same figures as Monthly / Master / Year Over Year
Monthly Sales · Earnings · Expenses
Cumulative P/L Trend
Cards Out / Sales
Cards out the door + daily sales & earnings across all platforms · Jun 1 – Sep 1, 2026 (owner only)
Money
Everything you sold and everything you kept — one page
Profit
Master
Snapshot
Monthly
Year over year
Historical
Profit
What you actually kept, by platform, after every fee and what the cards cost you
Profit by channel
| Channel | Revenue | Fees + Shipping | COGS | True Net | Cost basis |
|---|---|---|---|---|---|
Tax Summary
Your year organized into the lines the IRS tax form (Schedule C) asks for — sole proprietor / single-member LLC
Informational summary — not tax advice. This maps your tracked sales, card/lot purchases and expense ledger to the closest Schedule C lines for the selected year. Numbers come straight from your dashboards and may need adjustment for items the app doesn't track (vehicle/home-office/depreciation, personal-use splits, inventory timing). Always confirm with your tax professional before filing.
Income & Cost of Goods Sold
| Schedule C line | Amount |
|---|
Part II — Expenses
| Schedule C line | Fed by | Amount |
|---|---|---|
Line 31 — Net profit (or loss)
Line 1 gross receipts − Line 4 COGS − Line 28 total expenses
Break-Even Calculator
How many sales / how much revenue to hit a target — pre-filled from your data
Inputs
Community Comps
Real sold prices across the Leumas community, every platform — last 30 days plus all-time. Anonymized, minimum 3 sellers per card. Refreshes hourly.
Bulk Exchange
Move bulk lots member-to-member. Transact out-of-band via PayPal Goods & Services — Leumas is not a party to the sale.
Help & Guides
ADD LOT
ASSIGN SKUs TO LOT
ASSIGN ORDER TO LOT
Links sale revenue to selected lot for P/L tracking.
RECORD SALE
Manual sale record. In Leumas Live with eBay API, this will push a real-time quantity update to eBay.
SUGGESTION
REPORT AN ISSUE
ADD ROADMAP ITEM
ADD UPDATE
NEW POLL
Launching a new poll closes the current one (its votes are kept).
COST BREAKDOWN —
Each purchase entry behind the combined Paid figure.
NEW CARD SHOW
RECORD SALE
TRADE
Cards received (you can add several)
| Card name | Card # | Value ($) |
|---|
Gives away 1 unit of the card above (its eBay listing is decremented or ended). Each received card becomes a sellable line. Cash received books as card-show income; cash paid books as a New Purchase cost.
PULL IN INVESTMENTS
Liquidating? Pull held investments onto the floor. Selling one books to the investment tab (decrements qty-on-hand) — it does NOT touch the card-show P/L; the "Investment Sold" tile is a visual aid only.
NEW PURCHASE
Does not touch eBay. Counts as a New Purchase (lowers show P/L + books to your Expense Ledger → monthly/yearly P&L). If it sells, it books to Orders. Export "New Cards" after the show to scan in.
BULK PURCHASE
Rate is per-card (decimal). Total = Count × Rate. Tier abbreviations (C / UC / RH / H / IR…) come later.
| Name | Count | Rate | Total |
|---|
Grand Total: $0.00
SHOW EXPENSE
Books to your Expense Ledger (tagged to this show) → flows into monthly/yearly P&L.
CONSIGNMENT
RECORD SALE
BIND TO CATALOG
Click a result to bind it to every copy of this item and set its market value.
ADD PRODUCT
Click a result to match it (sets market value + product id). Then enter what you paid and how many copies you're holding.
MATCH TO CATALOG
Pick the exact card + set + condition — binds this listing's identity.
REMATCH INVENTORY
ADD EXPENSE
ADD RECURRING COST
Auto-populates the ledger from the start date forward — monthly on that day-of-month, yearly on that month/day. Months already passed since the start date are filled in too.
EXPENSE TYPES
Add custom categories. Click × to remove unused types.
RETARGET PARENT
AUTO-MATCH PARENTS
QUEUE HEALTH AUDIT
EDIT LISTING
0 / 80
$
First photo is the gallery image. Removing a photo only applies when you Save — nothing is removed without you.
Loading store categories from eBay...
More: shipping · package · quantity · Best Offer · item specifics
Open a listing to load its specifics…
Editing specifics replaces the listing's ENTIRE specifics set — all rows below are sent.
Photos — add / remove
BULK FIELDS
Every filled field below is applied to ALL listings. Blank = leave that field unchanged.
BULK EDIT TITLES
$ BULK EDIT PRICES
Quick actions (applies to all visible rows, doesn't save until you click Save):
Set all to $
·
Multiply all by
·
Decrease all by
%
·
LIST SELECTED CARDS
EDIT PRICING
Help improve card matching?
Leumas Live can get better at identifying cards — including sports and games with no catalog — by learning from
confirmed matches. If you opt in, we may use your card photos, titles, and the matches you confirm (never your
prices, costs, sales, or any personal or account information) to improve the shared matcher and catalog for everyone.
• It's completely optional — the app works exactly the same either way.
• Only cards you match or correct are used, and only after you opt in.
• Your prices, costs, orders, and account details are never used.
• Only cards you match or correct are used, and only after you opt in.
• Your prices, costs, orders, and account details are never used.
TRACK PLATFORM